Table: dbo.AR_Transaction_Template
Contains templates that can be used to generate an AR transaction.
Columns
NameTypeConstraintsDescription
transaction_template_KEYint (4)NOT NULLSpecifies 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_KEYint (4)NOT NULL
reference_numbernvarchar (32)NOT NULLThe reference number a generated transaction will be assigned. Every transaction generated by this template will be given this same reference number.
purchase_order_numbernvarchar (32)NOT NULLThe 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_amountdecimal (9, 2)NOT NULLIf there is a discount for the generated transaction, this is the amount that will be used instead of the normal amount.
payment_term_KEYint (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_KEYint (4)NOT NULLThe 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_KEYint (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_KEYint (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_salutationnvarchar (80)NOT NULLSpecifies the salutation that will be used for the shipping name on a transaction generated from this template.
shipping_namenvarchar (100)NOT NULLSpecifies the name that will be used for shipping on a transaction generated from this template.
create_as_printedbit (1)NOT NULLSpecifies whether to mark transactions that are generated from this template as printed transactions when they are created.
messagenvarchar (2000)NOT NULLThe message a generated transaction will be assigned. Every transaction generated by this template will be given this same message.
Primary key
NameColumnsDescription
PK_AR_Transaction_Template$transaction_template_KEYtransaction_template_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Transaction_Template__AR_Transaction_Type__ar_transaction_type_KEYar_transaction_type_KEYAR_Transaction_Type (ar_transaction_type_KEY)
FK_AR_Transaction_Template__Contact_Address_Type__shipping__contact_address_type_KEYshipping__contact_address_type_KEYContact_Address_Type (contact_address_type_KEY)
FK_AR_Transaction_Template__GL_Account__gl_account_KEYgl_account_KEYGL_Account (gl_account_KEY)
FK_AR_Transaction_Template__GL_Account__payment_discount__gl_account_KEYpayment_discount__gl_account_KEYGL_Account (gl_account_KEY)
FK_AR_Transaction_Template__Payment_Term__payment_term_KEYpayment_term_KEYPayment_Term (payment_term_KEY)
FK_AR_Transaction_Template__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template (transaction_template_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AR_Transaction_Template_Item__AR_Transaction_Template__transaction_template_KEYtransaction_template_KEYAR_Transaction_Template_Item
FK_AR_Transaction_Template_N_Customer__AR_Transaction_Template__transaction_template_KEYtransaction_template_KEYAR_Transaction_Template_N_Customer
FK_AR_Transaction__AR_Transaction_Template__generated_by__transaction_template_KEYgenerated_by__transaction_template_KEYAR_Transaction

Schema diagram