Table: dbo.Transaction_Template | |||
Transaction Templates - Parent table for template information used to create OnDemand or recurring transactions. | |||
Columns | |||
Name | Type | Constraints | Description |
transaction_template_KEY | int (4) | NOT NULL | Primary key |
transaction_template_id | nvarchar (22) | NOT NULL | Id for the template |
description | nvarchar (240) | NOT NULL | Description |
journal_KEY | int (4) | Key of the journal to used for any generated transactions. Can be null for OnDemand templates, in which case the user will have to specify the Journal on the generated transaction before saving. | |
transaction_template_frequency_KEY | int (4) | NOT NULL | Specifies the frequency at which transactions should be generated from the template. |
frequency_interval | int (4) | NOT NULL | The interval between generations of the template based on the frequency. |
transaction_template_automatic_type_KEY | int (4) | Required subtype for templates of frequency automatic. For all other types the value should remain null. | |
client_KEY | int (4) | NOT NULL | |
next_recurrence__gl_period_KEY | int (4) | The next GL period in which the transaction recurs. |
Primary key | |||
Name | Columns | Description | |
PK_Transaction_Template | transaction_template_KEY |