{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
Col#
Column Name
Data Type
Field Length
Not Null?
Data Def.
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
Column
width
33%
Contains all Invoices.
Note
This is a VIEW-representation of tables INVOICE_MAIN and INVOICE-BALANCE.