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 |
|
|
||
| NameSortSequence | varchar | 30 | √ | null |
|
|
||
| CreditorNameInternal | varchar | 100 | √ | null |
|
|
||
| CreditorNameExternal | varchar | 100 | √ | null |
|
|
||
| CreditorLegalFullName | varchar | 150 | √ | null |
|
|
||
| CreditorPreferredFormal | varchar | 20 | √ | null |
|
|
||
| CreditorSurname | 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 |
|
|
|||
| CurrentBalance | money | 21,4 | √ | null |
|
|
||
| HoldPaymentFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows