EnrolmentDeposits


Columns

Column Type Size Nulls Auto Default Children Parents Comments
DepositSeq int identity 4 √ null
DepositCreatedDate datetime 16,3 √ (getdate())
DepositCreatedBy varchar 50 √ null
DepositModifiedDate datetime 16,3 √ (getdate())
DepositModifiedBy varchar 50 √ ('')
DepositCode varchar 10 ('')
EnrolmentDepositDefinitions.DepositCode FK_EnrolmentDeposits_EnrolmentDepositDefinitions R
ID int 4 ((0))
ContactID int 4 ((0))
Amount money 21,4 ((0))
AmountOwed money 21,4 ((0))
OriginalDate datetime 16,3 √ null
FinalisedDate datetime 16,3 √ null
Drawer varchar 50 ('')
PostingNumber int 4 ((0))
ReceiptNumber int 4 ((0))
DebtorTransactionSeq int 4 ((0))
CreditorTransactionSeq int 4 ((0))
Repayee1ID int 4 ((0))
Repayee2ID int 4 ((0))
DonateDepositFlag bit 1 ((0))
DonateDepositFund varchar 10 ('')
Comment varchar 2147483647 √ null
GLJournalSeq int 4 ((0))
PostingSource varchar 10 ('')
CertificatePrintedFlag bit 1 ((0))
TaxCode varchar 5 ('')

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_EnrolmentDeposits Primary key Asc DepositSeq
AK_EnrolmentDeposits_ContactID Performance Asc ContactID
AK_EnrolmentDeposits_CreditorTransactionSeq Performance Asc CreditorTransactionSeq
AK_EnrolmentDeposits_DebtorTransactionSeq Performance Asc DebtorTransactionSeq
AK_EnrolmentDeposits_ID Performance Asc ID
AK_EnrolmentDeposits_PostingNumber Performance Asc PostingNumber
AK_EnrolmentDeposits_ReceiptNumber Performance Asc ReceiptNumber
AK_EnrolmentDeposits_Repayee Performance Asc/Asc Repayee1ID + Repayee2ID

Relationships

Close relationships within degrees of separation