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
Name | Type | Constraints | Description
bank_feeds_assignment_rule_KEY | int (4) | NOT NULL | Primary key for table.
predicate_xml | nvarchar (-1) | NOT NULL | This column indicates an xml schema to capture the predicate syntax and stores each rules predicate in an xml string.
name | nvarchar (100) | NOT NULL | This column indicates the identification of created Rule.
client_KEY | int (4) | NOT NULL | Key of client to which this rule belongs

Primary key
Name | Columns | Description
PK_Bank_Feeds_Assignment_Rule | bank_feeds_assignment_rule_KEY |
Unique constraints
Name | Columns | Description
UK_Bank_Feeds_Assignment_Rule$name$client_KEY | name, client_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Feeds_Assignment_Rule__Client__client_KEY | client_KEY | Client (client_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Bank_Feeds_Assignment_Rule_Action__Bank_Feeds_Assignment_Rule__bank_feeds_assignment_rule_KEY | bank_feeds_assignment_rule_KEY | Bank_Feeds_Assignment_Rule_Action |
FK_Bank_Feeds_Assignment_Rule_Action_Distribution__Bank_Feeds_Assignment_Rule__bank_feeds_assignment_rule_KEY | bank_feeds_assignment_rule_KEY | Bank_Feeds_Assignment_Rule_Action_Distribution |
FK_Bank_Feeds_Retrieved_Transaction_Rule_Applied__Bank_Feeds_Assignment_Rule__bank_feeds_assignment_rule_KEY | bank_feeds_assignment_rule_KEY | Bank_Feeds_Retrieved_Transaction_Rule_Applied |