Table: dbo.Bank_Feeds_Assignment_Rule_Action_Distribution
This table holds the information about multiple distributions to be assigned via rules.
Columns
Name | Type | Constraints | Description
bank_feeds_assignment_rule_action_distribution_KEY | int (4) | NOT NULL | Primary key for the table.
bank_feeds_assignment_rule_KEY | int (4) | NOT NULL | Rule key for the distribution assignment.
assigned_value__gl_account_KEY | int (4) | NOT NULL | Key of the GL Account used in the distribution assignment.
assigned_value__description | nvarchar (240) |  | Description for the distribution assignment. If this is null or is not specified, the description of the transaction distribution to which["BR"] this rule is applied will be cleared.
assigned_value__amount | decimal (9, 2) |  | Amount for the distribution assignment. If this is null or not specified, then the amount of the distribution of the transaction to which this["BR"] rule is applied will be modified based on the amounts set for other distributions of the same rule. If all the amounts set for the rule distributions["BR"] are zero, the amount of the transaction will be applied to the first distribution of the transaction. Otherwise, the amount will be applied to the["BR"] transaction distribution and if it the last distribution, its wmount will be modified to make the total of all distributions equal to the full["BR"] transaction amount.
assigned_value__vendor_1099_box_setup_KEY | int (4) |  | Key of the Vendor 1099 box setup for the distribution assignment. This will be null if not specified or for a non-1099 recipient type vendor.
sequence_number | int (4) | NOT NULL | Key of the Vendor 1099 box setup for the distribution assignment.

Primary key
Name | Columns | Description
PK_Bank_Feeds_Assignment_Rule_Action_Distribution | bank_feeds_assignment_rule_action_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
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 (bank_feeds_assignment_rule_KEY) |
FK_Bank_Feeds_Assignment_Rule_Action_Distribution__GL_Account__assigned_value__gl_account_KEY | assigned_value__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Bank_Feeds_Assignment_Rule_Action_Distribution__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) |