Table: dbo.AR_Transaction_Template_Item
Tracks items associated with an AR template.
Columns
Name | Type | Constraints | Description
ar_transaction_template_item_KEY | int (4) | NOT NULL | A primary key.
ar_item_KEY | int (4) | NOT NULL | Links to the associated AR item. This table will share all the data with the AR item it is linked to. When an entry in the AR item table is deleted, all the associated entries in the template table must be deleted as well.
transaction_template_KEY | int (4) | NOT NULL | Links back to its parent AR transaction template.
quantity | decimal (9, 4) | NOT NULL | When generating an AR transaction item from this template item, this will fill in the quantity of the item to use.
sequence_number | int (4) | NOT NULL | The sequence number for this template item. When generating an AR transaction item from this template item, this will be the assigned sequence number.
amount_override | decimal (9, 2) |  | An override for the amount on the template item. If not null, this value should be used instead of the amount on the corresponding AR item. If null, the relevant amount field on the AR item should be used.
per_item_price_override | decimal (9, 4) |  | An override for the per item price on the template item. If not null, this value should be used instead of the per item price on the corresponding AR item. If null, the per item price field on the AR item should be used.
description_override | nvarchar (2000) |  | An override for the description on this template item. If null, the description for the template item will be pulled from the linked AR item row.

Primary key
Name | Columns | Description
PK_AR_Transaction_Template_Item | ar_transaction_template_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_AR_Transaction_Template_Item__AR_Item__ar_item_KEY | ar_item_KEY | AR_Item (ar_item_KEY) |
FK_AR_Transaction_Template_Item__AR_Transaction_Template__transaction_template_KEY | transaction_template_KEY | AR_Transaction_Template (transaction_template_KEY) |