Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| GLCOACode | varchar | 10 | √ | null |
|
|
||
| GLCOADescription | varchar | 100 | √ | null |
|
|
||
| GLCOAProfitLossFlag | bit | 1 | √ | null |
|
|
||
| GLCOATaxCode | varchar | 5 | √ | null |
|
|
||
| GLCOAClassificationCode | varchar | 15 | √ | null |
|
|
||
| GLCOAClassificationDescription | varchar | 30 | √ | null |
|
|
||
| GLCOAHeadingLevel | varchar | 15 | √ | null |
|
|
||
| GLCOAAutoCreateGLCodesFlag | bit | 1 | √ | null |
|
|
||
| GLYear | smallint | 2 | null |
|
|
|||
| GLCode | varchar | 15 | null |
|
|
|||
| GLCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| GLCreatedBy | varchar | 50 | √ | null |
|
|
||
| GLModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| GLModifiedBy | varchar | 50 | √ | null |
|
|
||
| GLDescription | varchar | 50 | null |
|
|
|||
| GLProfitLossFlag | bit | 1 | null |
|
|
|||
| GLNormallyCreditFlag | bit | 1 | null |
|
|
|||
| GLDivisionCode | varchar | 15 | √ | null |
|
|
||
| GLDivisionDescription | varchar | 50 | √ | null |
|
|
||
| GLEnforceDescriptionFlag | bit | 1 | null |
|
|
|||
| GLHeadingLevel | tinyint | 1 | null |
|
|
|||
| GLLastYearMovement | money | 21,4 | null |
|
|
|||
| GLStartYearBalance | money | 21,4 | null |
|
|
|||
| GLCurrentBalance | money | 21,4 | null |
|
|
|||
| GLSubLedgerControl | varchar | 5 | null |
|
|
|||
| GLReceiptAllocationCode | varchar | 5 | null |
|
|
|||
| GLTaxCode | varchar | 5 | null |
|
|
|||
| GLTaxCodeFixedFlag | bit | 1 | null |
|
|
|||
| GLClassificationCode | varchar | 15 | null |
|
|
|||
| GLClassificationDesciption | varchar | 30 | √ | null |
|
|
||
| GLGovernmentReturnCategory | varchar | 15 | null |
|
|
|||
| GLRequiresSubAllocationFlag | bit | 1 | null |
|
|
|||
| GLActiveFlag | bit | 1 | null |
|
|
|||
| GLCostCentreCode | varchar | 15 | null |
|
|
|||
| GLCostCentreDescription | varchar | 100 | √ | null |
|
|
||
| GLCostCentreActiveFlag | bit | 1 | √ | null |
|
|
||
| GLCostCentreStaffID | int | 4 | √ | null |
|
|
||
| GLCostCentreStaffName | varchar | 100 | √ | null |
|
|
||
| GLCostCentreTaxCode | varchar | 15 | √ | null |
|
|
||
| GLCostCentreAutoCreateGLCodesFlag | bit | 1 | √ | null |
|
|
||
| GLComment | varchar | 2147483647 | √ | null |
|
|
||
| GLAllowJournalsFlag | varchar | 1 | null |
|
|
|||
| GLJournalEntryMessage | varchar | 255 | null |
|
|
Table contained 0 rows