Table: dbo.Payable_Transaction_Template
This table is used to store information about a transaction template that can be used to generate a payable transaction.
Columns
Name | Type | Constraints | Description
transaction_template_KEY | int (4) | NOT NULL | The primary key for the table. Links back to the base table Transaction_Template.
vendor_KEY | int (4) | NOT NULL | The vendor associated with this transaction template.
payable__gl_account_KEY | int (4) | NOT NULL | The GL Account to be associated with this transaction template.
payable_transaction_type_KEY | int (4) | NOT NULL | The type of transaction that this template will be used to create. Can either be a payable or a credit memo.
reference_number | nvarchar (32) | NOT NULL | The reference number to be used for this template.
purchase_order_number | nvarchar (32) | NOT NULL | The purchase order number to be used for this template.
vendor__contact_address_type_KEY | int (4) |  | The contact address type for the vendor. A vendor can have multiple contact addresses and this specifies which type of address to use. It is acceptable if the vendor specified by the vendor_KEY in this table does not have a contact address for the specified type. When generating a Payable_Transaction row from this template, this value is used to specify the vendor__contact_address_type_KEY in Payable_Transaction. A null value indicates that no contact address type is specified for this template; when generating a payable transaction from this template the corresponding vendor__contact_address_type_KEY in the generated Payable_Transaction row will be null as well.
payment_term_KEY | int (4) |  | The payment term that will be used for transactions generated from this template. A null value indicates that no payment term is specified for the template and payment term will not be filled in when users create a transaction from the template.
not_eligible_for_discount_allowed_amount | decimal (9, 2) | NOT NULL | How much of the transaction generated from the template will not be eligible for discounts.
memo | nvarchar (480) | NOT NULL | A memo to be associated with transactions generated from this template.
description | nvarchar (240) | NOT NULL | A description to be associated with transactions generated from this template.
transaction_status_KEY | int (4) | NOT NULL | The transaction status of this template. The template can be live, where it can be used to generate transactions. It can also be voided, where it can no longer be used to generate transactions.

Primary key
Name | Columns | Description
PK_Payable_Transaction_Template$transaction_template_KEY | transaction_template_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_Payable_Transaction_Template__Contact_Address_Type__vendor__contact_address_type_KEY | vendor__contact_address_type_KEY | Contact_Address_Type (contact_address_type_KEY) |
FK_Payable_Transaction_Template__GL_Account__payable__gl_account_KEY | payable__gl_account_KEY | GL_Account (gl_account_KEY) |
FK_Payable_Transaction_Template__Payable_Transaction_Type__payable_transaction_type_KEY | payable_transaction_type_KEY | Payable_Transaction_Type (payable_transaction_type_KEY) |
FK_Payable_Transaction_Template__Payment_Term__payment_term_KEY | payment_term_KEY | Payment_Term (payment_term_KEY) |
FK_Payable_Transaction_Template__Transaction_Status__transaction_status_KEY | transaction_status_KEY | Transaction_Status (transaction_status_KEY) |
FK_Payable_Transaction_Template__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Transaction_Template (transaction_template_KEY) |
FK_Payable_Transaction_Template__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Payable_Transaction__Payable_Transaction_Template__generated_by__transaction_template_KEY | generated_by__transaction_template_KEY | Payable_Transaction |