INVOICE

Groups

INVOICE

Col #	Column Name	Data Type	Field Length	Not Null?	Comments
1	ID	NUMBER	22	N	Primary key
2	START_DATE	DATE	7	Y
3	END_DATE	DATE	7	Y
4	STATUS_ID	NUMBER	22	Y
5	ACCOUNT_ID	NUMBER	22	Y	Reference to ACCOUNT (redundant, from BILLING_GROUP_ID)
6	BILLING_GROUP_ID	NUMBER	22	Y	Reference to BILLING_GROUP
7	IS_OPEN	VARCHAR2	4	Y
8	TOTAL_EXCL_VAT	NUMBER	22	Y
9	TOTAL_VAT	NUMBER	22	Y
10	PERIOD_TEXT	VARCHAR2	400	Y
11	INVOICE_NUMBER	VARCHAR2	1000	Y
12	XML_FILE_NAME	VARCHAR2	1000	Y
13	XSL_STYLE_SHEET	VARCHAR2	1000	Y
14	XML_INVOICE_BATCH_ID	VARCHAR2	1000	Y
15	PAYED_AMOUNT	NUMBER	22	Y
16	DUE_DATE	DATE	7	Y
17	LAST_ALLOWED_CHARGE_DATE	DATE	7	Y
18	INVOICE_TYPE_ID	NUMBER	22	Y
19	INVOICE_SCHEDULE_ID	NUMBER	22	Y	Reference to INVOICE_SCHEDULE
20	INVOICE_FILE_LOCATION	VARCHAR2	4000	Y
21	INVOICE_FILE_NAME	VARCHAR2	400	Y
22	SEQUENCE	NUMBER	22	Y
23	CLOSE_DATE	DATE	7	Y
24	BATCH_ID	NUMBER	22	Y	Reference to INVOICE_BATCH
25	PAYMENT_TYPE_ID	NUMBER	22	Y
26	INVOICE_STATE	VARCHAR2	80	Y
27	LIFECYCLE_STATE	NUMBER	22	Y
28	IS_SUSPENDED	VARCHAR2	4	Y
29	DATE_LAST_STEP	DATE	7	Y
30	LAST_STEP_ID	NUMBER	22	Y
31	SUSPEND_REASON_ID	NUMBER	22	Y
32	HAS_PAYMENT_PLAN	VARCHAR2	4	Y
33	SUSPEND_DATE	DATE	7	Y
34	CREDIT_FORWARDED	NUMBER	22	Y
35	TOTAL_TRAFFIC_EXCL_VAT	NUMBER	22	Y
36	TOTAL_TRAFFIC_VAT	NUMBER	22	Y
37	INVOICE_DETAIL_FILE_LOCATION	VARCHAR2	4000	Y
38	INVOICE_DETAIL_FILE_NAME	VARCHAR2	400	Y
39	DELIVERY_IDENTIFIER	VARCHAR2	400	Y
40	INVOICE_FLOW_ID	NUMBER	22	Y
41	BG_INVOICE_TYPE_ID	NUMBER	22	Y
42	MAX_AGGREGATED_DETAIL_LINE_ID	NUMBER	22	Y
43	MAX_INVOICE_DETAIL_LINE_ID	NUMBER	22	Y
44	IS_LOCKED	VARCHAR2	4	Y
45	PAYMENT_REFERENCE	VARCHAR2	160	Y
46	IS_ANONYMIZED	CHAR	4	Y
47	NUMBER_OF_LINES	NUMBER	22	Y
48	DUNNING_BALANCE	NUMBER	22	Y
49	DUNNING_DATE	DATE	7	Y
50	IS_PUBLISHED	CHAR	4	Y

Contains all Invoices.

This is a VIEW-representation of tables INVOICE_MAIN and INVOICE-BALANCE.