Table: dbo.Bank_Feeds_Retrieved_Transaction_Distribution
This table provides transaction distribution records related to a bank feeds transaction.
Columns
NameTypeConstraintsDescription
bank_feeds_retrieved_transaction_distribution_KEYint (4)NOT NULLthe primary Key for this table.
bank_feeds_retrieved_transaction_KEYint (4)NOT NULLthe bank_feeds_retrieved_transaction_KEY for the bank feeds transaction associated with the transaction distribution..
gl_account_KEYint (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.
descriptionnvarchar (240)NOT NULLthe description for the transaction distribution.
amountdecimal (9, 2)NOT NULLthe amount of the transaction distribution.
sequence_numberint (4)NOT NULLThe 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_KEYint (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_KEYint (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
NameColumnsDescription
PK_Bank_Feeds_Retrieved_Transaction_Distributionbank_feeds_retrieved_transaction_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Feeds_Retrieved_Transaction_Distribution__W2_1099_Box_Type__first__w2_1099_box_type_KEYfirst__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)
FK_Bank_Feeds_Retrieved_Transaction_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)
FK_Bank_Feeds_Retrieved_Transaction_Distribution__Bank_Feeds_Retrieved_Transaction__bank_feeds_retrieved_transaction_KEYbank_feeds_retrieved_transaction_KEYBank_Feeds_Retrieved_Transaction (bank_feeds_retrieved_transaction_KEY)
FK_Bank_Feeds_Retrieved_Transaction_Distribution__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)

Schema diagram