Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| TransactionSeq | int | 4 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| PayeeName | varchar | 50 | null |
|
|
|||
| CreditorName | varchar | 100 | √ | null |
|
|
||
| PostingNumber | int | 4 | null |
|
|
|||
| TransactionDate | datetime | 16,3 | null |
|
|
|||
| InvoiceMode | char | 1 | null |
|
|
|||
| InvoiceNumber | varchar | 20 | null |
|
|
|||
| Description | varchar | 50 | null |
|
|
|||
| ChequeNumber | int | 4 | null |
|
|
|||
| PaymentMethod | varchar | 5 | null |
|
|
|||
| EFTPostingNumber | int | 4 | null |
|
|
|||
| FullInvoiceDescription | varchar | 68 | √ | null |
|
|
||
| Amount | money | 21,4 | null |
|
|
|||
| InvoiceAmount | money | 21,4 | √ | null |
|
|
||
| TotalAllocated | money | 21,4 | null |
|
|
|||
| DisputedFlag | bit | 1 | null |
|
|
|||
| DueDate | datetime | 16,3 | √ | null |
|
|
||
| PayNextChequeRunFlag | bit | 1 | null |
|
|
|||
| PostingCompleteFlag | bit | 1 | null |
|
|
|||
| BankCode | varchar | 15 | null |
|
|
|||
| PayThisAccountOnlyFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows