wkGeneralLedgerBankTransactions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
wkGeneralLedgerBankTransactionsSeq int identity 4 √ null
wkBankStatementTransactionsXRef.wkGeneralLedgerBankTransactionsSeq FK_wkBankStatementTransactionsxRef_wkGeneralLedgerBankTransactions R
BankStatementControlSeq int 4 √ null
GLJournalSeq int 4 ((0))
ChequeNumber int 4 ((0))
GLCode varchar 15 ('')
PostingSource varchar 10 ('')
PostingNumber int 4 ((0))
GLDate datetime 16,3 (getdate())
GLAmount money 21,4 ((0))
StatementDate datetime 16,3 √ null
StatementPage smallint 2 ((1))
StatementAmount money 21,4 ((0))
ReconciledFlag bit 1 ((0))
ChequeDate datetime 16,3 √ null
PayeeName varchar 50 ('')
CancelledFlag bit 1 ((0))
InitialReconciledFlag bit 1 ((0))
GeneralLedgerBankTransactionsSeq int 4 √ null
ForeignCurrencyCode varchar 15 ('')
ForeignCurrencyExchangeRate decimal 18,8 √ null
LocalCurrencyAmount money 21,4 √ null
MatchReference int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_wkGeneralLedgerBankTransactions Primary key Asc wkGeneralLedgerBankTransactionsSeq
AK_wkGeneralLedgerBankTransactions_BankStatementControlSeq Performance Asc BankStatementControlSeq
AK_wkGeneralLedgerBankTransactions_GeneralLedgerBankTransactionsSeq Performance Asc GeneralLedgerBankTransactionsSeq

Relationships

Close relationships within degrees of separation