Table: dbo.Initial_Open_Item_Bank_Transaction
This table holds additional information needed only by an Initial Open Item bank transaction.
Columns
NameTypeConstraintsDescription
bank_transaction_KEYint (4)NOT NULLThe primary key and a foreign key to the parent bank transaction.
related__client_KEYint (4)NOT NULLNon-impound client that the impound transaction refers to.
Primary key
NameColumnsDescription
PK_Initial_Open_Item_Bank_Transaction$bank_transaction_KEYbank_transaction_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Initial_Open_Item_Bank_Transaction__Bank_Transaction__bank_transaction_KEYbank_transaction_KEYBank_Transaction (bank_transaction_KEY)
FK_Initial_Open_Item_Bank_Transaction__Client__related__client_KEYrelated__client_KEYClient (client_KEY)

Schema diagram