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
NameTypeConstraintsDescription
transaction_template_KEYint (4)NOT NULLThe primary key for the table. Links back to the base table Transaction_Template.
vendor_KEYint (4)NOT NULLThe vendor associated with this transaction template.
payable__gl_account_KEYint (4)NOT NULLThe GL Account to be associated with this transaction template.
payable_transaction_type_KEYint (4)NOT NULLThe type of transaction that this template will be used to create. Can either be a payable or a credit memo.
reference_numbernvarchar (32)NOT NULLThe reference number to be used for this template.
purchase_order_numbernvarchar (32)NOT NULLThe purchase order number to be used for this template.
vendor__contact_address_type_KEYint (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_KEYint (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_amountdecimal (9, 2)NOT NULLHow much of the transaction generated from the template will not be eligible for discounts.
memonvarchar (480)NOT NULLA memo to be associated with transactions generated from this template.
descriptionnvarchar (240)NOT NULLA description to be associated with transactions generated from this template.
transaction_status_KEYint (4)NOT NULLThe 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
NameColumnsDescription
PK_Payable_Transaction_Template$transaction_template_KEYtransaction_template_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Payable_Transaction_Template__Contact_Address_Type__vendor__contact_address_type_KEYvendor__contact_address_type_KEYContact_Address_Type (contact_address_type_KEY)
FK_Payable_Transaction_Template__GL_Account__payable__gl_account_KEYpayable__gl_account_KEYGL_Account (gl_account_KEY)
FK_Payable_Transaction_Template__Payable_Transaction_Type__payable_transaction_type_KEYpayable_transaction_type_KEYPayable_Transaction_Type (payable_transaction_type_KEY)
FK_Payable_Transaction_Template__Payment_Term__payment_term_KEYpayment_term_KEYPayment_Term (payment_term_KEY)
FK_Payable_Transaction_Template__Transaction_Status__transaction_status_KEYtransaction_status_KEYTransaction_Status (transaction_status_KEY)
FK_Payable_Transaction_Template__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template (transaction_template_KEY)
FK_Payable_Transaction_Template__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Payable_Transaction__Payable_Transaction_Template__generated_by__transaction_template_KEYgenerated_by__transaction_template_KEYPayable_Transaction

Schema diagram