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 |
|
|
||
| InvoiceNumber | varchar | 20 | √ | null |
|
|
||
| InvoiceDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceDescription | varchar | 50 | √ | null |
|
|
||
| InvoiceAmount | money | 21,4 | √ | null |
|
|
||
| InvoiceAmountDue | money | 21,4 | √ | null |
|
|
||
| InvoiceDisputedFlag | bit | 1 | √ | null |
|
|
||
| ChequeNumber | int | 4 | √ | null |
|
|
||
| ChequeDate | datetime | 16,3 | √ | null |
|
|
||
| CurrentBalance | money | 21,4 | null |
|
|
|||
| HoldPaymentFlag | bit | 1 | null |
|
|
|||
| PaymentMethod | varchar | 5 | null |
|
|
|||
| SupplierCategory | varchar | 10 | null |
|
|
Table contained 0 rows