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
Name | Type | Constraints | Description
payable_transaction_template_distribution_KEY | int (4) | NOT NULL | The primary key for the table.
transaction_template_KEY | int (4) | NOT NULL | The transaction template that this distribution will be associated with.
gl_account_KEY | int (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.
description | nvarchar (240) | NOT NULL | A brief description of the distribution.
amount | decimal (9, 2) | NOT NULL | The amount of the distribution.
discount_allowed_amount | decimal (9, 2) | NOT NULL | How much of the amount can be used for discounts.
first__w2_1099_box_type_KEY | int (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_KEY | int (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_number | int (4) | NOT NULL | A sequence number used to order the distributions.

Primary key
Name | Columns | Description
PK_Payable_Transaction_Template_Distribution | payable_transaction_template_distribution_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Transaction_Template_Distribution__GL_Account__gl_account_KEY | gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payable_Transaction_Template_Distribution__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Transaction_Template (transaction_template_KEY) |
FK_Payable_Transaction_Template_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_Payable_Transaction_Template_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) |