Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| 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 |
|
|
||
| GLCostCentreCode | varchar | 15 | √ | null |
|
|
||
| GLEnforceDescriptionFlag | bit | 1 | √ | null |
|
|
||
| GLHeadingFlag | tinyint | 1 | √ | null |
|
|
||
| GLLastYearMovement | money | 21,4 | √ | null |
|
|
||
| GLStartYearBalance | money | 21,4 | √ | null |
|
|
||
| GLCurrentBalance | money | 21,4 | √ | null |
|
|
||
| GLJournalSeq | int | 4 | √ | null |
|
|
||
| GLSuballocationCode | varchar | 15 | √ | null |
|
|
||
| GLCodeFull | varchar | 31 | √ | null |
|
|
||
| PostingNumber | int | 4 | √ | null |
|
|
||
| PostingDescription | varchar | 60 | √ | null |
|
|
||
| PostingMonth | int | 4 | √ | null |
|
|
||
| PostingYear | int | 4 | √ | null |
|
|
||
| PostingDate | datetime | 16,3 | √ | null |
|
|
||
| PostingCompleteFlag | bit | 1 | √ | null |
|
|
||
| PostingDeletedFlag | bit | 1 | √ | null |
|
|
||
| PostingCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| PostingCreatedBy | varchar | 50 | √ | null |
|
|
||
| GLJournalDate | datetime | 16,3 | √ | null |
|
|
||
| PostingSource | varchar | 10 | √ | null |
|
|
||
| ReceiptNumber | int | 4 | √ | null |
|
|
||
| OrderNumber | int | 4 | √ | null |
|
|
||
| DebtorTransactionSeq | int | 4 | √ | null |
|
|
||
| CreditorTransactionSeq | int | 4 | √ | null |
|
|
||
| PayCode | varchar | 10 | √ | null |
|
|
||
| GLJournalAmount | money | 21,4 | √ | null |
|
|
||
| GLJournalDescription | varchar | 255 | √ | null |
|
|
||
| PrintVersion | smallint | 2 | √ | null |
|
|
||
| InvoiceTransactionSeq | int | 4 | √ | null |
|
|
||
| CreditorID | int | 4 | √ | null |
|
|
||
| CreditorPayeeName | varchar | 50 | √ | null |
|
|
||
| CreditorName | varchar | 100 | √ | null |
|
|
||
| NameSortSequence | varchar | 30 | √ | null |
|
|
||
| CreditorAddressFull | varchar | 200 | √ | null |
|
|
||
| InvoicePostingNumber | int | 4 | √ | null |
|
|
||
| InvoicePostingDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceMode | char | 1 | √ | null |
|
|
||
| InvoiceModeDescription | varchar | 11 | √ | null |
|
|
||
| InvoiceNumber | varchar | 20 | √ | null |
|
|
||
| InvoiceDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceDescription | varchar | 50 | √ | null |
|
|
||
| FullInvoiceDescription | varchar | 68 | √ | null |
|
|
||
| InvoiceAmount | money | 21,4 | √ | null |
|
|
||
| InvoiceDiscount | money | 21,4 | √ | null |
|
|
||
| InvoiceDisputedFlag | bit | 1 | √ | null |
|
|
||
| InvoiceDueDate | datetime | 16,3 | √ | null |
|
|
||
| PaymentSelect | varchar | 1 | √ | null |
|
|
||
| BulkSelectedFlag | bit | 1 | √ | null |
|
|
||
| TotalAllocated | money | 21,4 | √ | null |
|
|
||
| ReferenceTransactionSeq | int | 4 | √ | null |
|
|
||
| ChequeNumber | int | 4 | √ | null |
|
|
||
| ChequeDate | datetime | 16,3 | √ | null |
|
|
||
| ChequePostingNumber | int | 4 | √ | null |
|
|
||
| BudgetDate | datetime | 16,3 | √ | null |
|
|
||
| JournalTotal | money | 21,4 | null |
|
|
|||
| BudgetTotal | money | 21,4 | null |
|
|
|||
| BudgetApprovedTotal | money | 21,4 | null |
|
|
|||
| Description | varchar | 100 | √ | null |
|
|
||
| StaffID | int | 4 | √ | null |
|
|
||
| GLCOACode | varchar | 10 | √ | null |
|
|
||
| GLDivisionCode | varchar | 15 | √ | null |
|
|
Table contained 0 rows