Table: dbo.Bank_Feeds_Assignment_Rule_Action
This table holds the information for Create Rules dialog Action part. 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_action_KEY | int (4) | NOT NULL | Primary key for table.
bank_feeds_assignment_rule_KEY | int (4) | NOT NULL | Primary key of table Bank Feeds Assignment Rule which is used to link the action to parent rule.
bank_feeds_assignment_column_KEY | int (4) | NOT NULL | Primary key of the Bank Feeds Assignment Column associated with Bank Feeds Assignment Rule. This column will only have a value of description, reference, vendor, and account.
assigned_value__vendor_KEY | int (4) |  | This column indicates the vendor that should be assigned to any bank feed transaction that matches the predicate. This column will only have a value if the bank_feeds_assignment_column_KEY is of type Vendor. Otherwise, it will be set to NULL.
assigned_value__gl_account_KEY | int (4) |  | This column indicates the GL Account that should be assigned to any bank feed transaction that matches the predicate. This column will only have a value if the bank_feeds_assignment_column_KEY is of type Account. Otherwise, it will be set to NULL.
assigned_value | nvarchar (240) |  | This column indicates the Description or Reference that should be assigned to any bank feed transaction that matches the predicate. This column will only have a value if the bank_feeds_assignment_column_KEY is of type either Description or Reference. Otherwise, it will be set to NULL.
assigned_value__vendor_1099_box_setup_KEY | int (4) |  | This column indicates the Vendor 1099 box setup that should be assigned to any bank feeds transaction that matches the predicate.["BR"] This column will only have a value if the bank_feeds_assignment_column_KEY is of type 1099. Otherwise, it will be set to NULL.
assigned_value__bank_transaction_type_KEY | int (4) |  | This column indicates the bank transaction type that should be assigned to any bank feeds transaction that matches the predicate.["BR"] This column will only have a value if the bank_feeds_assignment_column_KEY is of type (Transaction) type. Otherwise, it will be set to NULL.

Primary key
Name | Columns | Description
PK_Bank_Feeds_Assignment_Rule_Action | bank_feeds_assignment_rule_action_KEY |

Foreign keys
Name | Columns | Referenced 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 (bank_feeds_assignment_rule_KEY) |
FK_Bank_Feeds_Assignment_Rule_Action__Bank_Feeds_Assignment_Column__bank_feeds_assignment_column_KEY | bank_feeds_assignment_column_KEY | Bank_Feeds_Assignment_Column (bank_feeds_assignment_column_KEY) |
FK_Bank_Feeds_Assignment_Rule_Action__Vendor__assigned_value__vendor_KEY | assigned_value__vendor_KEY | Vendor (vendor_KEY) |
FK_Bank_Feeds_Assignment_Rule_Action__GL_Account__assigned_value__gl_account_KEY | assigned_value__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Bank_Feeds_Assignment_Rule_Action__Vendor_1099_Box_Setup__assigned_value__vendor_1099_box_setup_KEY | assigned_value__vendor_1099_box_setup_KEY | Vendor_1099_Box_Setup (vendor_1099_box_setup_KEY) |
FK_Bank_Feeds_Assignment_Rule_Action__Bank_Transaction_Type__assigned_value__bank_transaction_type_KEY | assigned_value__bank_transaction_type_KEY | Bank_Transaction_Type (bank_transaction_type_KEY) |