Table: dbo.Bank_Feeds_Assignment_Rule
This table hold the information of Create Rules dialog. The dialog should allow the user to create rules for assigning a description, reference, vendor, and account to bank statement transactions. The user may use the reference, description, amount, vendor, or account fields to apply the rules.
Columns
NameTypeConstraintsDescription
bank_feeds_assignment_rule_KEYint (4)NOT NULLPrimary key for table.
predicate_xmlnvarchar (-1)NOT NULLThis column indicates an xml schema to capture the predicate syntax and stores each rules predicate in an xml string.
namenvarchar (100)NOT NULLThis column indicates the identification of created Rule.
client_KEYint (4)NOT NULLKey of client to which this rule belongs
Primary key
NameColumnsDescription
PK_Bank_Feeds_Assignment_Rulebank_feeds_assignment_rule_KEY
Unique constraints
NameColumnsDescription
UK_Bank_Feeds_Assignment_Rule$name$client_KEYname, client_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Feeds_Assignment_Rule__Client__client_KEYclient_KEYClient (client_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Feeds_Assignment_Rule_Action__Bank_Feeds_Assignment_Rule__bank_feeds_assignment_rule_KEYbank_feeds_assignment_rule_KEYBank_Feeds_Assignment_Rule_Action
FK_Bank_Feeds_Assignment_Rule_Action_Distribution__Bank_Feeds_Assignment_Rule__bank_feeds_assignment_rule_KEYbank_feeds_assignment_rule_KEYBank_Feeds_Assignment_Rule_Action_Distribution
FK_Bank_Feeds_Retrieved_Transaction_Rule_Applied__Bank_Feeds_Assignment_Rule__bank_feeds_assignment_rule_KEYbank_feeds_assignment_rule_KEYBank_Feeds_Retrieved_Transaction_Rule_Applied

Schema diagram