This table provides transaction distribution records related to a bank feeds transaction. |
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. |