Table: dbo.Bank_Transaction_Template
This table stores information about the bank transaction portion of a transaction template.
Columns
Name | Type | Constraints | Description
transaction_template_KEY | int (4) | NOT NULL | Primary key. Also the key of the transaction template parent.
bank_transaction_type_KEY | int (4) | NOT NULL | Denotes the type of transaction. For example, deposit.
checkbook_KEY | int (4) |  | Denotes the checkbook in which the application will create a transaction.
reference_number | nvarchar (32) | NOT NULL | The reference number which the application will assign to the transaction created from the template.
description | nvarchar (240) | NOT NULL | The description which the application will assign to the transaction created from the template.
data_origin_KEY | int (4) | NOT NULL | Denotes the origin of the template. For example, data entry.
origin__accounting_application_KEY | int (4) | NOT NULL | Denotes the application that was running when we created the template. For example, Accounting CS.
vendor_KEY | int (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_check | bit (1) | NOT NULL | Indicates whether or not the bank transaction is a handwritten check

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

Foreign keys
Name | Columns | Referenced table | Description
FK_Bank_Transaction_Template__Accounting_Application__origin__accounting_application_KEY | origin__accounting_application_KEY | Accounting_Application (accounting_application_KEY) |
FK_Bank_Transaction_Template__Bank_Transaction_Type__bank_transaction_type_KEY | bank_transaction_type_KEY | Bank_Transaction_Type (bank_transaction_type_KEY) |
FK_Bank_Transaction_Template__Checkbook__checkbook_KEY | checkbook_KEY | Checkbook (checkbook_KEY) |
FK_Bank_Transaction_Template__Data_Origin__data_origin_KEY | data_origin_KEY | Data_Origin (data_origin_KEY) |
FK_Bank_Transaction_Template__Transaction_Template__transaction_template_KEY | transaction_template_KEY | Transaction_Template (transaction_template_KEY) |
FK_Bank_Transaction_Template__Vendor__vendor_KEY | vendor_KEY | Vendor (vendor_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_Bank_Transaction_Template_Reconciliation_Detail__Bank_Transaction_Template__transaction_template_KEY | transaction_template_KEY | Bank_Transaction_Template_Reconciliation_Detail |
FK_Bank_Transaction_Template_Distribution__Bank_Transaction_Template__transaction_template_KEY | transaction_template_KEY | Bank_Transaction_Template_Distribution |