_INVOICE_MAIN

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
6	BILLING_GROUP_ID	NUMBER	22	Y
7	IS_OPEN	CHAR	1	Y
8	TOTAL_EXCL_VAT	NUMBER	22	Y
9	TOTAL_VAT	NUMBER	22	Y
10	PERIOD_TEXT	VARCHAR2	100	Y
11	INVOICE_NUMBER	VARCHAR2	250	Y
12	XML_FILE_NAME	VARCHAR2	250	Y
13	XSL_STYLE_SHEET	VARCHAR2	250	Y
14	XML_INVOICE_BATCH_ID	VARCHAR2	250	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
20	INVOICE_FILE_LOCATION	VARCHAR2	1000	Y
21	INVOICE_FILE_NAME	VARCHAR2	100	Y
22	SEQUENCE	NUMBER	22	Y
23	CLOSE_DATE	DATE	7	Y
24	BATCH_ID	NUMBER	22	Y
25	PAYMENT_TYPE_ID	NUMBER	22	Y
26	INVOICE_STATE	VARCHAR2	20	Y
27	LIFECYCLE_STATE	NUMBER	22	Y
28	IS_SUSPENDED	CHAR	1	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	CHAR	1	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	1000	Y
38	INVOICE_DETAIL_FILE_NAME	VARCHAR2	100	Y
39	DELIVERY_IDENTIFIER	VARCHAR2	100	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
42	MAX_INVOICE_DETAIL_LINE_ID	NUMBER	22	Y
43	IS_LOCKED	VARCHAR2	4	Y
44	PAYMENT_REFERENCE	VARCHAR2	160	Y
45	IS_ANONYMIZED	CHAR	4	Y
46	NUMBER_OF_LINES	NUMBER	22	Y
47	DUNNING_BALANCE	NUMBER	22	Y
48	DUNNING_DATE	DATE	7	Y
49	IS_PUBLISHED	CHAR	4	Y