Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| wkReceiptsSeq | int identity | 4 | √ | null |
|
|
||
| ReceiptNumber | int | 4 | null |
|
|
|||
| PostingNumber | int | 4 | ((0)) |
|
|
|||
| PaymentType | varchar | 8 | ('') |
|
|
|||
| Drawer | varchar | 50 | ('') |
|
|
|||
| BankCode | varchar | 5 | ('') |
|
|
|||
| BankBranch | varchar | 20 | ('') |
|
|
|||
| BankStatementReference | varchar | 30 | ('') |
|
|
|||
| CreditCardType | varchar | 5 | ('') |
|
|
|||
| CreditCardNumber | varchar | 16 | ('') |
|
|
|||
| ReceiptAmount | money | 21,4 | ((0)) |
|
|
|||
| ReceiptCompletedFlag | bit | 1 | ((0)) |
|
|
|||
| ReceiptPrintedFlag | bit | 1 | ((0)) |
|
|
|||
| ReceiptDescription | varchar | 50 | ('') |
|
|
|||
| ReceiptPrintFlag | bit | 1 | ((0)) |
|
|
|||
| ReceiptPrintCount | tinyint | 1 | ((0)) |
|
|
|||
| CreditCardExpiryMonth | tinyint | 1 | ((0)) |
|
|
|||
| CreditCardExpiryYear | smallint | 2 | ((0)) |
|
|
|||
| AlreadyProcessedFlag | bit | 1 | ((0)) |
|
|
|||
| ID | int | 4 | ((0)) |
|
|
|||
| AutomaticPaymentType | varchar | 10 | √ | ('') |
|
|
||
| AutomaticAllocationTreatment | varchar | 10 | ('') |
|
|
|||
| EFTAccountBSB | varchar | 8 | √ | ('') |
|
|
||
| EFTAccountNumber | varchar | 15 | ('') |
|
|
|||
| CreditCardAuthorisation | varchar | 6 | ('') |
|
|
|||
| ReceiptDate | datetime | 16,3 | √ | null |
|
|
||
| ItemSalePaymentSeqDebtorSplit | int | 4 | √ | null |
|
|
||
| ForeignCurrencyCode | varchar | 15 | ('') |
|
|
|||
| ForeignCurrencyExchangeRate | decimal | 18,8 | √ | null |
|
|
||
| ReceiptAmountForeignCurrency | money | 21,4 | √ | null |
|
|
||
| SurchargePercent | decimal | 8,4 | ((0)) |
|
|
|||
| SurchargeAmount | money | 21,4 | ((0)) |
|
|
|||
| SurchargeAmountForeignCurrency | money | 21,4 | √ | null |
|
|
||
| SurchargeGLCode | varchar | 15 | ('') |
|
|
|||
| SurchargeDescription | varchar | 100 | ('') |
|
|
|||
| ReceiptAmountNett | money | 21,4 | ((0)) |
|
|
|||
| ReceiptAmountNettForeignCurrency | money | 21,4 | √ | null |
|
|
Table contained -1 rows
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PK_wkReceipts | Primary key | Asc | wkReceiptsSeq |
| AK_wkReceipts_ReceiptNumber | Must be unique | Asc | ReceiptNumber |