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 |
Definition of all Charge Items