Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| TransactionSeq | int | 4 | null |
|
|
|||
| CreditorID | int | 4 | null |
|
|
|||
| CreditorPayeeName | varchar | 50 | null |
|
|
|||
| CreditorCurrentBalance | money | 21,4 | null |
|
|
|||
| CreditorPaymentMethod | varchar | 5 | null |
|
|
|||
| CreditorSupplierCategory | varchar | 10 | null |
|
|
|||
| CreditorSupplierCategoryDescription | varchar | 50 | null |
|
|
|||
| CreditorHoldPaymentFlag | bit | 1 | null |
|
|
|||
| CreditorName | varchar | 100 | null |
|
|
|||
| CreditorSurname | varchar | 30 | null |
|
|
|||
| CreditorAccountReference | varchar | 30 | null |
|
|
|||
| CreditorActiveFlag | bit | 1 | null |
|
|
|||
| InvoiceCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceCreatedByID | int | 4 | √ | null |
|
|
||
| InvoiceModifiedDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceModifiedByID | int | 4 | √ | null |
|
|
||
| InvoicePostingNumber | int | 4 | null |
|
|
|||
| InvoicePostingSource | varchar | 10 | null |
|
|
|||
| InvoicePostingDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceMode | char | 1 | null |
|
|
|||
| InvoiceDate | datetime | 16,3 | null |
|
|
|||
| InvoiceNumber | varchar | 20 | null |
|
|
|||
| InvoiceDescription | varchar | 50 | null |
|
|
|||
| InvoiceAmount | money | 21,4 | null |
|
|
|||
| InvoiceDueDate | datetime | 16,3 | √ | null |
|
|
||
| InvoiceDiscount | money | 21,4 | null |
|
|
|||
| InvoiceDisputedFlag | bit | 1 | null |
|
|
|||
| InvoicePayNextChequeRunFlag | bit | 1 | null |
|
|
|||
| InvoiceGLDate | datetime | 16,3 | √ | null |
|
|
||
| InvoicePaymentMethod | varchar | 5 | null |
|
|
|||
| InvoiceForeignCurrencyCode | varchar | 15 | null |
|
|
|||
| InvoiceForeignCurrencyExchangeRate | decimal | 18,8 | √ | null |
|
|
||
| InvoiceForeignCurrencyAmount | money | 21,4 | √ | null |
|
|
||
| InvoiceBankFeeAmount | money | 21,4 | null |
|
|
|||
| InvoiceBankFeeAmountForeignCurrency | money | 21,4 | √ | null |
|
|
||
| InvoiceBankFeeGLCode | varchar | 15 | null |
|
|
|||
| InvoiceBankFeeDescription | varchar | 100 | null |
|
|
|||
| ChequeDate | datetime | 16,3 | √ | null |
|
|
||
| ChequeNumber | int | 4 | null |
|
|
|||
| ChequePostingNumber | int | 4 | null |
|
|
|||
| EFTPostingNumber | int | 4 | null |
|
|
|||
| PaidPostingDate | datetime | 16,3 | √ | null |
|
|
Table contained 0 rows