Groups
GL_TRANSACTIONMATRIX
Col # | Column Name | Data Type | Field Length | Not Null? | Data Def. | Comments |
|---|---|---|---|---|---|---|
| 1 | ID | NUMBER | 22 | N | ||
| 2 | DESCRIPTION | VARCHAR2 | 32 | Y | ||
| 3 | DEBET_ACCOUNT | VARCHAR2 | 16 | Y | ||
| 4 | CREDIT_ACCOUNT | VARCHAR2 | 16 | Y | ||
| 5 | DEBET_CASE_ID | VARCHAR2 | 16 | Y | ||
| 6 | CREDIT_CASE_ID | VARCHAR2 | 16 | Y | ||
| 7 | DEBET_TEXT | VARCHAR2 | 32 | Y | ||
| 8 | CREDIT_TEXT | VARCHAR2 | 32 | Y | ||
| 9 | VAT_DEBET_ACCOUNT | VARCHAR2 | 16 | Y | ||
| 10 | VAT_CREDIT_ACCOUNT | VARCHAR2 | 16 | Y | ||
| 11 | VAT_DEBET_TEXT | VARCHAR2 | 32 | Y | ||
| 12 | VAT_CREDIT_TEXT | VARCHAR2 | 32 | Y | ||
| 13 | GL_GROUP_ID | NUMBER | 22 | Y | ||
| 14 | GL_ID | NUMBER | 22 | Y | Primary key | |
| 15 | ADD_TO_INVOICE | VARCHAR2 | 4 | Y |
Definition of all GL Codes