Table: dbo.Bank_Feeds_Retrieved_Transaction_Distribution
This table provides transaction distribution records related to a bank feeds transaction.
Columns
Name | Type | Constraints | Description
bank_feeds_retrieved_transaction_distribution_KEY | int (4) | NOT NULL | the primary Key for this table.
bank_feeds_retrieved_transaction_KEY | int (4) | NOT NULL | the bank_feeds_retrieved_transaction_KEY for the bank feeds transaction associated with the transaction distribution..
gl_account_KEY | int (4) |  | the gl_account_KEY for the gl account associated with the transaction distribution. We would expect a gl account key to eventually be assigned by the user, but we also want to be able to save off work in progress where a gl account key has not yet been assigned.
description | nvarchar (240) | NOT NULL | the description for the transaction distribution.
amount | decimal (9, 2) | NOT NULL | the amount of the transaction distribution.
sequence_number | int (4) | NOT NULL | The sequence number of a transaction distribution. The sequence number shows the order of a transaction distribution in the user interface.
first__w2_1099_box_type_KEY | int (4) |  | The w2_1099_box_type_KEY for first box of the W2_1099_Box_Type associated with the transaction distribution.["BR"] This is an optional field, the user does not have to supply a first__w2_1099_box_type_KEY. Not every bank transaction distribution will have a first__w2_1099_box_type_KEY assigned to it.
second__w2_1099_box_type_KEY | int (4) |  | The w2_1099_box_type_KEY for second box of the W2_1099_Box_Type associated with the transaction distribution.["BR"] This is an optional field, the user does not have to supply a second__w2_1099_box_type_KEY. Not every bank transaction distribution will have a second__w2_1099_box_type_KEY assigned to it.

Primary key
Name | Columns | Description
PK_Bank_Feeds_Retrieved_Transaction_Distribution | bank_feeds_retrieved_transaction_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Feeds_Retrieved_Transaction_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEY | first__w2_1099_box_type_KEY | W2_1099_Box_Type (w2_1099_box_type_KEY) |
FK_Bank_Feeds_Retrieved_Transaction_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEY | second__w2_1099_box_type_KEY | W2_1099_Box_Type (w2_1099_box_type_KEY) |
FK_Bank_Feeds_Retrieved_Transaction_Distribution__Bank_Feeds_Retrieved_Transaction__bank_feeds_retrieved_transaction_KEY | bank_feeds_retrieved_transaction_KEY | Bank_Feeds_Retrieved_Transaction (bank_feeds_retrieved_transaction_KEY) |
FK_Bank_Feeds_Retrieved_Transaction_Distribution__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |