wkBankStatementTransactionsXRef


Columns

Column Type Size Nulls Auto Default Children Parents Comments
wkBankStatementTransactionsXRefSeq int identity 4 √ null
BankStatementControlSeq int 4 √ null
BankStatementControl.BankStatementControlSeq FK_wkBankStatementTransactionsxRef_BankStatementControl R
wkBankStatementTransactionsSeq int 4 √ null
wkBankStatementTransactions.wkBankStatementTransactionsSeq FK_wkBankStatementTransactionsxRef_wkBankStatementTransactions R
wkGeneralLedgerBankTransactionsSeq int 4 √ null
wkGeneralLedgerBankTransactions.wkGeneralLedgerBankTransactionsSeq FK_wkBankStatementTransactionsxRef_wkGeneralLedgerBankTransactions R
Amount money 21,4 √ null
GeneralLedgerBankTransactionsSeq int 4 √ null
BankStatementTransactionsSeq int 4 ((0))
MatchReference int 4 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_wkBankStatementTransactionsXRef Primary key Asc wkBankStatementTransactionsXRefSeq
AK_wkBankStatementTransactionsXRef_BankStatementControlSeq Performance Asc BankStatementControlSeq
AK_wkBankStatementTransactionsXRef_wkBankStatementTransactionsSeq Performance Asc wkBankStatementTransactionsSeq
AK_wkBankStatementTransactionsXRef_wkGeneralLedgerBankTransactionsSeq Performance Asc wkGeneralLedgerBankTransactionsSeq

Relationships

Close relationships within degrees of separation