Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| InvoiceTransactionSeq | int | 4 | null |
|
|
|||
| CreditorID | int | 4 | √ | null |
|
|
||
| CreditorPayeeName | varchar | 50 | √ | null |
|
|
||
| CreditorName | varchar | 100 | null |
|
|
|||
| CreditorNameInternal | varchar | 100 | null |
|
|
|||
| CreditorNameExternal | varchar | 100 | null |
|
|
|||
| CreditorLegalFullName | varchar | 150 | null |
|
|
|||
| CreditorPreferredFormal | varchar | 20 | null |
|
|
|||
| CreditorPreferred | varchar | 20 | null |
|
|
|||
| CreditorSurname | varchar | 30 | null |
|
|
|||
| NameSortSequence | varchar | 30 | null |
|
|
|||
| CreditorAddressFull | varchar | 200 | √ | null |
|
|
||
| CreditorCurrentBalance | money | 21,4 | √ | null |
|
|
||
| InvoicePostingNumber | int | 4 | null |
|
|
|||
| InvoicePostingDate | datetime | 16,3 | null |
|
|
|||
| InvoicePostingCompleteFlag | bit | 1 | 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 |
|
|
|||
| ChequePostingDate | datetime | 16,3 | √ | null |
|
|
||
| GLJournalSeq | int | 4 | √ | null |
|
|
||
| GLCode | varchar | 15 | null |
|
|
|||
| GLDescription | varchar | 50 | √ | null |
|
|
||
| GLActiveFlag | bit | 1 | √ | null |
|
|
||
| GLJournalDescription | varchar | 255 | √ | null |
|
|
||
| GLSubAllocationCode | varchar | 15 | √ | null |
|
|
||
| GLFullCode | varchar | 31 | √ | null |
|
|
||
| GLAmount | money | 21,4 | null |
|
|
|||
| TaxAmount | money | 21,4 | null |
|
|
|||
| GrossAmount | money | 21,4 | √ | null |
|
|
||
| TaxCode | varchar | 5 | √ | null |
|
|
||
| EFTPostingNumber | int | 4 | null |
|
|
|||
| PaymentMethod | varchar | 5 | √ | null |
|
|
||
| SupplierCategory | varchar | 10 | √ | null |
|
|
||
| InvoicePaymentMethod | varchar | 5 | null |
|
|
|||
| BankCode | varchar | 15 | √ | null |
|
|
||
| CurrentBalance | money | 21,4 | √ | null |
|
|
||
| HoldPaymentFlag | bit | 1 | √ | null |
|
|
||
| InvoiceAmountDue | money | 21,4 | √ | null |
|
|
||
| CostCentreCode | varchar | 15 | √ | null |
|
|
||
| GLDivisionCode | varchar | 15 | √ | null |
|
|
Table contained 0 rows