ReceiptsOnlineHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ReceiptsOnlineHistorySeq int identity 4 √ null
ReceiptsOnlineSeq int 4 √ null
Reference varchar 150 null
CreatedDate datetime 16,3 √ null
ID int 4 √ null
TotalAmount money 21,4 √ null
Comment varchar 2147483647 null
OnlineProcessedDateTime datetime 16,3 √ null
OnlineProcessedBankStatus varchar 200 null
PostingNumber int 4 √ null
ReceiptNumber int 4 √ null
CRN varchar 18 null
CreditCardReference varchar 16 null
CreditCardType varchar 5 null
OnlinePaymentMerchantsSeq int 4 √ null
SynergeticImportXML xml 1073741823 √ null
SurchargeAmount money 21,4 √ null
PaymentSummaryXml xml 1073741823 √ null
AuditAction varchar 30 √ null
ModifiedBy int 4 √ null
ModifiedDate datetime 16,3 √ null
refPaymentTypeCode varchar 20 √ null
TmpPaymentParamsXML xml 1073741823 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_ReceiptsOnlineHistory_ReceiptsOnlineHistorySeq Primary key Asc ReceiptsOnlineHistorySeq