ReceiptsHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ReceiptsHistorySeq int identity 4 √ null
ModifiedDate datetime 16,3 √ null
ModifiedByID int 4 √ null
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

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_ReceiptsHistory_ReceiptsHistorySeq Primary key Asc ReceiptsHistorySeq
AK_ReceiptsHistory_ReceiptNumber Performance Asc ReceiptNumber