Groups
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 |
Contains all Invoices.
This is a VIEW-representation of tables INVOICE_MAIN and INVOICE-BALANCE.