wkEnrolmentDepositRepayments


Columns

Column Type Size Nulls Auto Default Children Parents Comments
WorkSeq int identity 4 √ null
DepositSeq int 4 ((0))
ID int 4 ((0))
RepaymentDate datetime 16,3 √ null
RepaymentAmount money 21,4 ((0))
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))

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK__wkEnrolmentDepos__0B5CAFEA Primary key Asc WorkSeq
AK_wkEnrolmentDepositRepayments_CreditorTransactionSeq Performance Asc CreditorTransactionSeq
AK_wkEnrolmentDepositRepayments_DebtorTransactionSeq Performance Asc DebtorTransactionSeq
AK_wkEnrolmentDepositRepayments_GLJournalSeq Performance Asc GLJournalSeq
AK_wkEnrolmentDepositRepayments_ReceiptNumber Performance Asc ReceiptNumber
AK_wkEnrolmentDepositRepayments_wkJournalSeq Performance Asc wkJournalSeq