Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|
| 1 | ID | NUMBER | 22 | N | |
| Primary key |
| 2 | CHARGE_ITEM_GROUP_ID | NUMBER | 22 | Y | |
| Reference to CHARGE_ITEM_GROUP |
| 3 | DESCRIPTION | VARCHAR2 | 120 | Y | | |
|
|
| 4 | VALUE_TYPE | VARCHAR2 | 10 | Y | | |
|
|
| 5 | VALUE | FLOAT | 22 | Y | | |
|
|
| 6 | VAT | FLOAT | 22 | Y | | |
|
|
| 7 | GL_CODE | VARCHAR2 | 128 | Y | | |
|
|
| 8 | SUM_PATTERN | VARCHAR2 | 50 | Y | | |
|
|
| 9 | GENERATE_ZERO_DETAIL_LINE | CHAR | 1 | Y | | |
|
|
| 10 | GL_ID | NUMBER | 22 | Y | |
| Reference to GL_TRANSACTIONMATRIX |
| 11 | METHOD | VARCHAR2 | 400 | Y | | |
|
|
| 12 | SERVICE_CODE | VARCHAR2 | 400 | Y | | |
|
|
| 13 | SERVICE_KEY | VARCHAR2 | 400 | Y | | |
|
|
| 14 | ABSOLUTE_MATCH | NUMBER | 22 | Y | | |
|
|
| 15 | SERVICE_KEY_BNUMBER_METHOD_ID | NUMBER | 22 | Y | | |
|
|
| 16 | VAT_METHOD_NAME | VARCHAR2 | 80 | Y | |
| Reference to VAT_METHOD |
| 17 | TAX_TRANSACTION_TYPE_ID | NUMBER | 22 | Y | |
| Reference to TAX_TRANSACTION_TYPE |