Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ItemSalePaymentSeq | int | 4 | null |
|
|
|||
| ItemSaleSeq | int | 4 | null |
|
|
|||
| PaymentMethodCode | varchar | 15 | null |
|
|
|||
| PaymentMethodDescription | varchar | 30 | √ | null |
|
|
||
| PaymentMethodType | varchar | 10 | √ | null |
|
|
||
| PaymentAmountGross | money | 21,4 | null |
|
|
|||
| PaymentAmount | money | 21,4 | null |
|
|
|||
| DebtorID | int | 4 | null |
|
|
|||
| DebtorStudentID | int | 4 | null |
|
|
|||
| DebtorName | varchar | 100 | √ | null |
|
|
||
| GLCode | varchar | 15 | null |
|
|
|||
| GLSubAllocationCode | varchar | 15 | null |
|
|
|||
| GLDescription | varchar | 50 | √ | null |
|
|
||
| Drawer | varchar | 50 | null |
|
|
|||
| BankCode | varchar | 5 | null |
|
|
|||
| BankBranch | varchar | 20 | null |
|
|
|||
| DriversLicenseNumber | varchar | 20 | null |
|
|
|||
| CreditCardType | varchar | 5 | null |
|
|
|||
| CreditCardNumber | varchar | 16 | null |
|
|
|||
| CreditCardExpiryMonth | tinyint | 1 | null |
|
|
|||
| CreditCardExpiryYear | smallint | 2 | null |
|
|
|||
| EFTReference | varchar | 30 | null |
|
|
|||
| ScreenSeq | tinyint | 1 | √ | null |
|
|
||
| FunctionKey | varchar | 2 | √ | null |
|
|
||
| OpenDrawerFlag | bit | 1 | √ | null |
|
|
||
| ActiveFlag | bit | 1 | √ | null |
|
|
||
| RoundFlag | bit | 1 | √ | null |
|
|
||
| SaleInvoiceNumber | int | 4 | null |
|
|
|||
| InvoiceNumberIssued | int | 4 | null |
|
|
|||
| PostingNumber | int | 4 | null |
|
|
|||
| PostingSource | varchar | 10 | null |
|
|
|||
| PostingNumberReceipt | int | 4 | null |
|
|
|||
| ReconciledManualFlag | bit | 1 | null |
|
|
|||
| ReconciledAutomaticFlag | bit | 1 | null |
|
|
|||
| ReceiptPostingMethod | varchar | 1 | null |
|
|
|||
| PaymentDate | datetime | 16,3 | √ | null |
|
|
||
| OrderNumber | int | 4 | null |
|
|
|||
| BusinessUnitCode | varchar | 15 | √ | null |
|
|
||
| ItemSaleDate | datetime | 16,3 | √ | null |
|
|
||
| ID | int | 4 | √ | null |
|
|
Table contained 0 rows