wkEnrolmentDeposits


Columns

Column Type Size Nulls Auto Default Children Parents Comments
WorkSeq int identity 4 √ null
DepositCode varchar 10 ('')
ID int 4 ((0))
ContactID int 4 ((0))
Amount money 21,4 ((0.0))
OriginalDate datetime 16,3 √ null
Drawer varchar 50 ('')
PostingSource varchar 10 ('')
PostingNumber int 4 ((0))
ReceiptNumber int 4 ((0))
DebtorTransactionSeq int 4 ((0))
CreditorTransactionSeq int 4 ((0))
GLJournalSeq int 4 ((0))
wkJournalSeq int 4 ((0))
Repayee1ID int 4 ((0))
Repayee2ID int 4 ((0))
DonateDepositFlag bit 1 ((0))
DonateDepositFund varchar 15 ('')
TaxCode varchar 5 ('')
DepositSeq int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK__wkEnrolmentDepos__0C50D423 Primary key Asc WorkSeq
AK_wkEnrolmentDeposits_CreditorTransactionSeq Performance Asc CreditorTransactionSeq
AK_wkEnrolmentDeposits_DebtorTransactionSeq Performance Asc DebtorTransactionSeq
AK_wkEnrolmentDeposits_GLJournalSeq Performance Asc GLJournalSeq
AK_wkEnrolmentDeposits_ReceiptNumber Performance Asc ReceiptNumber
AK_wkEnrolmentDeposits_wkJournalSeq Performance Asc wkJournalSeq