Groups
CHARGE_ITEM
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 | ||
| 17 | TAX_TRANSACTION_TYPE_ID | NUMBER | 22 | Y |