INVOICE_DETAIL_LINE

Unknown macro: {float}

Col #	Column Name	Data Type	Field Length	Not Null?	Comments
1	ID	NUMBER	22	N	Primary key
2	BILLING_RECORD_ID	NUMBER	22	N	Reference to object creating this record (billing record, account payment, etc.)
3	INVOICE_LINE_ID	NUMBER	22	N
4	ACCOUNT_ID	NUMBER	22	N	Reference to ACCOUNT
5	SERVICE_ID	NUMBER	22	N	Reference to SERVICE
6	CHARGE_ITEM_ID	NUMBER	22	N	Reference to CHARGE_ITEM
7	SUM_QUANTITY	NUMBER	22	N
8	SUM_TIME	NUMBER	22	N
9	TOTAL_EXCL_VAT	NUMBER	22	N
10	TOTAL_VAT	NUMBER	22	N
11	DESCRIPTION	VARCHAR2	100	Y
12	CHARGE_DATE	DATE	7	Y
13	LEVEL1	VARCHAR2	100	Y
14	LEVEL2	VARCHAR2	100	Y
15	LEVEL3	VARCHAR2	100	Y
16	LEVEL4	VARCHAR2	100	Y
17	LEVEL5	VARCHAR2	100	Y
18	INVOICE_ID	NUMBER	22	Y	Reference to INVOICE
19	SUBSCRIPTION_ID	NUMBER	22	Y	Reference to SUBSCRIPTION
20	BILLING_GROUP_ID	NUMBER	22	Y	Reference to BILLING_GROUP
21	CALLER	VARCHAR2	20	Y
22	FINANCE_CODE_ACCOUNT	NUMBER	22	Y
23	FINANCE_CODE_BILL_GROUP	NUMBER	22	Y
24	FINANCE_CODE_PRODUCT	NUMBER	22	Y
25	FINANCE_CODE_PRICEPLAN	NUMBER	22	Y
26	FINANCE_CODE_NUMBERPLAN	NUMBER	22	Y
27	FINANCE_CODE_PLAN_ELEMENT	NUMBER	22	Y
28	FINANCE_CODE_CHARGE_ITEM	NUMBER	22	Y
29	FINANCE_CODE_DAY_CHARGE	NUMBER	22	Y
30	FINANCE_CODE_TIME_CHARGE	NUMBER	22	Y
31	FINANCE_CODE_BILLING_RECORD	NUMBER	22	Y
32	BRAND_ID	NUMBER	22	Y	Not used in application
33	VAT_METHOD_NAME	VARCHAR2	80	Y
34	CURRENCY_CODE	VARCHAR2	12	Y
35	CHARGED_UNITS	NUMBER	22	Y
36	CHARGED_UNIT_TYPE	VARCHAR2	60	Y

Contains all Credit and Debit Items charged in the system