Table: dbo.Bank_Transaction_Template
This table stores information about the bank transaction portion of a transaction template.
Columns
NameTypeConstraintsDescription
transaction_template_KEYint (4)NOT NULLPrimary key. Also the key of the transaction template parent.
bank_transaction_type_KEYint (4)NOT NULLDenotes the type of transaction. For example, deposit.
checkbook_KEYint (4)Denotes the checkbook in which the application will create a transaction.
reference_numbernvarchar (32)NOT NULLThe reference number which the application will assign to the transaction created from the template.
descriptionnvarchar (240)NOT NULLThe description which the application will assign to the transaction created from the template.
data_origin_KEYint (4)NOT NULLDenotes the origin of the template. For example, data entry.
origin__accounting_application_KEYint (4)NOT NULLDenotes the application that was running when we created the template. For example, Accounting CS.
vendor_KEYint (4)An optional association with a vendor. When a user associates a vendor with a template, the application will use the standard distributions defined for the vendor to create bank transaction template distributions. The application will also bring in the 1099 form selections defined for the vendor, which a user may optionally on a template distribution.
is_handwritten_checkbit (1)NOT NULLIndicates whether or not the bank transaction is a handwritten check
Primary key
NameColumnsDescription
PK_Bank_Transaction_Template$transaction_template_KEYtransaction_template_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_Bank_Transaction_Template__Accounting_Application__origin__accounting_application_KEYorigin__accounting_application_KEYAccounting_Application (accounting_application_KEY)
FK_Bank_Transaction_Template__Bank_Transaction_Type__bank_transaction_type_KEYbank_transaction_type_KEYBank_Transaction_Type (bank_transaction_type_KEY)
FK_Bank_Transaction_Template__Checkbook__checkbook_KEYcheckbook_KEYCheckbook (checkbook_KEY)
FK_Bank_Transaction_Template__Data_Origin__data_origin_KEYdata_origin_KEYData_Origin (data_origin_KEY)
FK_Bank_Transaction_Template__Transaction_Template__transaction_template_KEYtransaction_template_KEYTransaction_Template (transaction_template_KEY)
FK_Bank_Transaction_Template__Vendor__vendor_KEYvendor_KEYVendor (vendor_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_Bank_Transaction_Template_Reconciliation_Detail__Bank_Transaction_Template__transaction_template_KEYtransaction_template_KEYBank_Transaction_Template_Reconciliation_Detail
FK_Bank_Transaction_Template_Distribution__Bank_Transaction_Template__transaction_template_KEYtransaction_template_KEYBank_Transaction_Template_Distribution

Schema diagram