This table stores information about the bank transaction portion of a transaction template. |
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 |