A table used to describe one of the possibly multiple distributions that make up a payable transaction template. |
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. |