Table: dbo.Bank_Transaction_Type
Columns
NameTypeConstraintsDescription
bank_transaction_type_KEYint (4)NOT NULL
descriptionnvarchar (80)NOT NULL
Primary key
NameColumnsDescription
PK_Bank_Transaction_Typebank_transaction_type_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Transaction_Type$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Journal__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYJournal
FK_Bank_Transaction__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYBank_Transaction
FK_Bank_Reconciliation_Recurring_Adjustment_Template__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYBank_Reconciliation_Recurring_Adjustment_Template
FK_Bank_Feeds_Retrieved_Transaction__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYBank_Feeds_Retrieved_Transaction
FK_Bank_Transaction_Template__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYBank_Transaction_Template
FK_Manage_AP_Payment_Processable_Transaction__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYManage_AP_Payment_Processable_Transaction
FK_Bank_Feeds_Assignment_Rule_Action__Bank_Transaction_Type__assigned_value__bank_transaction_type_KEYassigned_value__bank_transaction_type_KEYBank_Feeds_Assignment_Rule_Action
FK_Bank_Reconciliation_Statement_Detail__Bank_Transaction_Type__bank_transaction__bank_transaction_type_KEYbank_transaction__bank_transaction_type_KEYBank_Reconciliation_Statement_Detail

Schema diagram