Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ItemSalePaymentSeq | int | 4 | null |
|
|
|||
| ItemSaleSeq | int | 4 | null |
|
|
|||
| PaymentSeq | int | 4 | √ | null |
|
|
||
| SaleHoldFlag | bit | 1 | null |
|
|
|||
| BusinessUnitCode | varchar | 15 | null |
|
|
|||
| PaymentMethodCode | varchar | 15 | null |
|
|
|||
| ReceiptAllocationMethod | varchar | 1 | √ | null |
|
|
||
| PaymentAmountGross | money | 21,4 | null |
|
|
|||
| PaymentAmount | money | 21,4 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| DebtorID | int | 4 | null |
|
|
|||
| DebtorStudentID | int | 4 | null |
|
|
|||
| DebtorName | varchar | 100 | √ | null |
|
|
||
| DebtorSurname | varchar | 30 | √ | null |
|
|
||
| DebtorPreferred | varchar | 20 | √ | null |
|
|
||
| DebtorPrimaryOnlyFlag | bit | 1 | √ | null |
|
|
||
| GLCode | varchar | 15 | null |
|
|
|||
| GLDescription | varchar | 50 | null |
|
|
|||
| GLSubAllocationCode | varchar | 15 | 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 |
|
|
|||
| SaleInvoiceNumber | int | 4 | null |
|
|
|||
| InvoiceNumberIssued | int | 4 | null |
|
|
|||
| PostingNumber | int | 4 | null |
|
|
|||
| PostingSource | varchar | 10 | null |
|
|
|||
| ChargedToID | varchar | 30 | √ | null |
|
|
||
| ChargedToName | varchar | 60 | √ | null |
|
|
||
| PaymentMethodDescription | varchar | 30 | √ | null |
|
|
||
| PaymentMethodCloseOffType | varchar | 1 | √ | null |
|
|
||
| PaymentMethodScreenSeq | tinyint | 1 | √ | null |
|
|
||
| PaymentMethodFunctionKey | varchar | 2 | √ | null |
|
|
||
| PaymentMethodOpenDrawerFlag | bit | 1 | √ | null |
|
|
||
| PaymentMethodType | varchar | 10 | √ | null |
|
|
||
| PaymentMethodCreditCardType | varchar | 5 | √ | null |
|
|
||
| PaymentMethodDebtorID | int | 4 | √ | null |
|
|
||
| PaymentMethodActiveFlag | bit | 1 | √ | null |
|
|
||
| PaymentMethodRoundFlag | bit | 1 | √ | null |
|
|
||
| ReconciledManualFlag | bit | 1 | null |
|
|
|||
| ItemSalePaymentSeqDebtorSplit | int | 4 | √ | null |
|
|
||
| Workstation | varchar | 50 | null |
|
|
Table contained 0 rows