Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| ReceiptNumber | int | 4 | null |
|
|
|||
| PostingNumber | int | 4 | null |
|
|
|||
| ReceiptCreatedDate | datetime | 16,3 | √ | null |
|
|
||
| ReceiptCreatedBy | varchar | 50 | √ | null |
|
|
||
| PaymentType | varchar | 8 | null |
|
|
|||
| Drawer | varchar | 50 | null |
|
|
|||
| BankCode | varchar | 5 | null |
|
|
|||
| BankBranch | varchar | 20 | null |
|
|
|||
| BankStatementReference | varchar | 30 | null |
|
|
|||
| CreditCardType | varchar | 5 | null |
|
|
|||
| CreditCardNumber | varchar | 16 | null |
|
|
|||
| ReceiptAmount | money | 21,4 | null |
|
|
|||
| ReceiptCompletedFlag | bit | 1 | null |
|
|
|||
| ReceiptPrintedFlag | bit | 1 | null |
|
|
|||
| ReceiptDescription | varchar | 50 | null |
|
|
|||
| ReceiptPrintFlag | bit | 1 | null |
|
|
|||
| ReceiptPrintCount | tinyint | 1 | null |
|
|
|||
| CreditCardExpiryMonth | tinyint | 1 | null |
|
|
|||
| CreditCardExpiryYear | smallint | 2 | null |
|
|
|||
| AlreadyProcessedFlag | bit | 1 | null |
|
|
|||
| ID | int | 4 | null |
|
|
|||
| AutomaticPaymentType | varchar | 10 | √ | null |
|
|
||
| AutomaticAllocationTreatment | varchar | 10 | null |
|
|
|||
| EFTAccountBSB | varchar | 8 | √ | null |
|
|
||
| EFTAccountNumber | varchar | 15 | null |
|
|
|||
| CreditCardAuthorisation | varchar | 6 | null |
|
|
|||
| ReceiptDate | datetime | 16,3 | √ | null |
|
|
||
| ItemSalePaymentSeqDebtorSplit | int | 4 | √ | null |
|
|
||
| ForeignCurrencyCode | varchar | 15 | null |
|
|
|||
| ForeignCurrencyExchangeRate | decimal | 18,8 | √ | null |
|
|
||
| ReceiptAmountForeignCurrency | money | 21,4 | √ | null |
|
|
||
| SurchargePercent | decimal | 8,4 | null |
|
|
|||
| SurchargeAmount | money | 21,4 | null |
|
|
|||
| SurchargeAmountForeignCurrency | money | 21,4 | √ | null |
|
|
||
| SurchargeGLCode | varchar | 15 | null |
|
|
|||
| SurchargeDescription | varchar | 100 | null |
|
|
|||
| ReceiptAmountNett | money | 21,4 | null |
|
|
|||
| ReceiptAmountNettForeignCurrency | money | 21,4 | √ | null |
|
|
||
| CRN | varchar | 18 | null |
|
|
|||
| ExportT1PaymentType | varchar | 15 | √ | null |
|
|
||
| DebtorAmount | money | 21,4 | null |
|
|
|||
| GLAmount | money | 21,4 | null |
|
|
|||
| ModifyInProcessFlag | bit | 1 | √ | null |
|
|
Table contained 0 rows