Table: dbo.Payable_Transaction_Template_Distribution
A table used to describe one of the possibly multiple distributions that make up a payable transaction template.
Columns
NameTypeConstraintsDescription
payable_transaction_template_distribution_KEYint (4)NOT NULLThe primary key for the table.
transaction_template_KEYint (4)NOT NULLThe transaction template that this distribution will be associated with.
gl_account_KEYint (4)The GL Account to be associated with this distribution. A null value indicates that no GL account will be filled in when the user creates a transaction from this template.
descriptionnvarchar (240)NOT NULLA brief description of the distribution.
amountdecimal (9, 2)NOT NULLThe amount of the distribution.
discount_allowed_amountdecimal (9, 2)NOT NULLHow much of the amount can be used for discounts.
first__w2_1099_box_type_KEYint (4)The first w2 1099 box type. A null value indicates that the distribution amount will not be filled out in the 1099 form box when the user creates a transaction from this template.
second__w2_1099_box_type_KEYint (4)The second w2 1099 box type. A null value indicates that the distribution amount will not be filled out in the 1099 form box when the user creates a transaction from this template.
sequence_numberint (4)NOT NULLA sequence number used to order the distributions.
Primary key
NameColumnsDescription
PK_Payable_Transaction_Template_Distributionpayable_transaction_template_distribution_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Transaction_Template_Distribution__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_Payable_Transaction_Template_Distribution__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template (transaction_template_KEY)
FK_Payable_Transaction_Template_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_Payable_Transaction_Template_Distribution__W2_1099_Box_Type__second__w2_1099_box_type_KEYsecond__w2_1099_box_type_KEYW2_1099_Box_Type (w2_1099_box_type_KEY)

Schema diagram