Contains templates that can be used to generate an AR transaction. |
transaction_template_KEY | int (4) | NOT NULL | Specifies what type of AR transaction this template will be used to generate. It will either be an invoice or a credit memo. |
ar_transaction_type_KEY | int (4) | NOT NULL | |
reference_number | nvarchar (32) | NOT NULL | The reference number a generated transaction will be assigned. Every transaction generated by this template will be given this same reference number. |
purchase_order_number | nvarchar (32) | NOT NULL | The purchase order number a generated transaction will be assigned. Every transaction generated by this template will be given this same purchase order number. |
payment_discount_amount | decimal (9, 2) | NOT NULL | If there is a discount for the generated transaction, this is the amount that will be used instead of the normal amount. |
payment_term_KEY | int (4) | | The payment term a generated transaction will be assigned. A null value indicates that no payment term is specified for the template and so the payment term will not be filled in when users create transactions from the template. |
gl_account_KEY | int (4) | NOT NULL | The GL account that will be associated with this template. This account will be associated with all transactions generated by this template. |
payment_discount__gl_account_KEY | int (4) | | The GL account that will be associated with the discount amount for this template. A null value indicates that no GL account is specified for a generated transaction to use for discounts. |
shipping__contact_address_type_KEY | int (4) | | Specifies which address type to use for shipping on a generated transaction. A null value indicates that no contact address type is specified; this is typical of templates that do not involve shipping items. |
shipping_salutation | nvarchar (80) | NOT NULL | Specifies the salutation that will be used for the shipping name on a transaction generated from this template. |
shipping_name | nvarchar (100) | NOT NULL | Specifies the name that will be used for shipping on a transaction generated from this template. |
create_as_printed | bit (1) | NOT NULL | Specifies whether to mark transactions that are generated from this template as printed transactions when they are created. |
message | nvarchar (2000) | NOT NULL | The message a generated transaction will be assigned. Every transaction generated by this template will be given this same message. |