PaymentGatewayLog


Columns

Column Type Size Nulls Auto Default Children Parents Comments
PaymentGatewayLogSeq int identity 4 √ null
DebtorID int 4 null
PaymentGatewayProviderName varchar 50 null
RequestVersion int 4 null
RequestCommand varchar 3 null
RequestMerchTxnRef varchar 40 null
RequestVPCMerchant varchar 16 null
RequestOrderInfo varchar 34 √ null
RequestAmountCents bigint 8 null
RequestSecureHash varchar 40 √ null
RequestUrl varchar 2147483647 √ null
RequestDateTime datetime 16,3 √ null
ResponseSecureHash varchar 40 √ null
TxnResponseCode varchar 1 √ null
ResponseVersion int 4 √ null
ResponseCommand varchar 3 √ null
ResponseMerchTxnRef varchar 40 √ null
ResponseMerchant varchar 16 √ null
ResponseOrderInfo varchar 34 √ null
ResponseAmountCents bigint 8 √ null
ResponseTransactionNo int 4 √ null
ResponseMessage varchar 2147483647 √ null
AcqResponseCode varchar 3 √ null
ResponseReceiptNo varchar 12 √ null
ResponseBatchNo varchar 8 √ null
ResponseAuthorisedId varchar 12 √ null
ResponseCardType varchar 2 √ null
ResponseUrl varchar 2147483647 √ null
ResponseDateTime datetime 16,3 √ null
ResponseSecureHashCalculatedFlag bit 1 √ ((0))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_PaymentGatewayLog Primary key Asc PaymentGatewayLogSeq