DebtorPaymentMethodsOnline


Columns

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

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_DebtorPaymentMethodsOnline Primary key Asc DebtorPaymentMethodsOnlineSeq
AK_DebtorPaymentMethodsOnline_DebtorPaymentMethodsOnlineSeq Must be unique Asc/Asc/Asc DebtorID + DebtorStudentID + PaymentMethodSeq

Relationships

Close relationships within degrees of separation