DebtorPaymentMethodsOnlineHistory


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DebtorPaymentMethodsOnlineHistorySeq int identity 4 √ null
DebtorPaymentMethodsOnlineSeq int 4 null
DebtorID int 4 null
DebtorStudentID int 4 null
PaymentMethodSeq int 4 null
CRN varchar 18 null
PaymentType varchar 8 null
Drawer varchar 50 null
CreditCardType varchar 5 null
CreditCardReference varchar 16 null
CreditCardExpiryMonth tinyint 1 null
CreditCardExpiryYear smallint 2 null
CreditCardIssuingBank varchar 100 null
EFTAccountBSB varchar 8 √ null
EFTAccountNumber varchar 15 null
EFTBranchName varchar 100 null
EFTBankName varchar 100 null
AllowAutoPaymentFlag bit 1 null
AutoPaymentSplitPercent decimal 7,2 null
AutoPaymentSplitAmount money 21,4 null
CreatedDate datetime 16,3 null
ProcessedDate datetime 16,3 √ null
ModifiedByPortalID int 4 null
ModifiedByPortalDate datetime 16,3 √ null
Comment varchar 100 null
ProcessStatus varchar 1 √ null
DebtorPaymentMethodSeq int 4 null
DebtorActiveSeq int 4 null
OnlinePaymentMerchantsSeq int 4 √ null
OwnerID int 4 √ null
CreatedByID int 4 √ null
ActionMessageProcessedDate datetime 16,3 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorPaymentMethodsOnlineHistory Primary key Asc DebtorPaymentMethodsOnlineHistorySeq
AK_DebtorPaymentMethodsOnlineHistory_DebtorPaymentMethodsOnlineSeq Performance Asc DebtorPaymentMethodsOnlineSeq