Table: dbo.Bank_Feeds_Assignment_Column
This table hold the information of Assign value in Create Rules dialog. Assign value should allow the user to select either description, reference, vendor, or account to bank statement transactions.
Columns
NameTypeConstraintsDescription
bank_feeds_assignment_column_KEYint (4)NOT NULLPrimary key for table.
descriptionnvarchar (40)NOT NULLDescription stored list of columns that can have values assigned to them.
Primary key
NameColumnsDescription
PK_Bank_Feeds_Assignment_Columnbank_feeds_assignment_column_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Feeds_Assignment_Column$descriptiondescription
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Feeds_Assignment_Rule_Action__Bank_Feeds_Assignment_Column__bank_feeds_assignment_column_KEYbank_feeds_assignment_column_KEYBank_Feeds_Assignment_Rule_Action

Schema diagram