Groups
INVOICE_MAIN
| 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 | ||
| 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 |