{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width
33%
INVOICE_DETAIL_LINE
Col #
Column Name
Data Type
Field Length
Not Null?
Data Def.
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
Column
width
33%
Contains all Credit and Debit Items charged in the system