Table: dbo.AR_Transaction_Item
This table stores items for an AR Transaction. Items are usually created by selected an row from the AR Item table and copying all necessary information down to this table. This way changes made to the AR Item will not change existing payables.
Columns
Name | Type | Constraints | Description
ar_transaction_item_KEY | int (4) | NOT NULL | Primary key for this table.
gl_transaction_KEY | int (4) | NOT NULL | key to GL Transaction key for the AR Transaction this item belongs to.
ar_item_id | nvarchar (22) | NOT NULL | The id for the item.
description | nvarchar (2000) | NOT NULL | The description for the item.
ar_item_type_KEY | int (4) | NOT NULL | The item type.
per_item_price | decimal (9, 4) | NOT NULL | The price per item for this ar transaction item. This value will be used along with quantity to calculate amount original.
per_item_purchase_cost | decimal (9, 4) | NOT NULL | The purchase cost per item. This will be used along with quantity to calculate total cost of the item.
ar_item_tax_status_KEY | int (4) | NOT NULL | The tax status. The chosen status will determine how tax amount will be calculated. A Status of Non-Tax or Taxable means tax amount will be zero while a status of Additional will mean tax amount will have a calculated value.
taxing_authority_description | nvarchar (60) | NOT NULL | If a taxing authority is selected on the AR Item this item is setup from then this field will hold a copy of the description on that taxing authority.
taxing_authority_rate | decimal (5, 6) | NOT NULL | If a taxing authority is selected on the AR Item this item is setup from then this field will hold a copy of the rate on that taxing authority.
item_percentage | decimal (5, 4) |  | When the percentage is not null it will be used to calculate the amount orginal instead of using the per item price and quantity.
eligible_for_discount | bit (1) | NOT NULL | The eligibility for discount on the item.
quantity | decimal (9, 4) | NOT NULL | The quantity of this item to be used when calculating amount original.
sequence_number | int (4) | NOT NULL | A sequence number for the item that represents the order in which the item appears on the invoice. The sequence is important because some amount calculations use seqence to determine which items to sum before multiplying them by a percentage to get an amount.
amount_original | decimal (9, 2) | NOT NULL | The amount for the item that will be used in summation of the total amount of the transaction. This field is for an original amount.
amount_override | decimal (9, 2) |  | An override field for amount.
additional_tax_amount | decimal (9, 2) | NOT NULL | An amount of tax on the item for items that have a Tax Status of Additional. This amount will be used in summation of the total amount of the transaction.
cost_amount | decimal (9, 2) | NOT NULL | An amount of cost on the item for item. This amount will be used in summation of the total cost of the transaction.
apply_taxing_authority_rate_to_shipping | bit (1) | NOT NULL | This flag indicates if the taxing rate should be appled to items with a type of shipping. This flag should only be true if the item is of type Sales Tax.
apply_taxing_authority_rate_to_discount | bit (1) | NOT NULL | This flag indicates if the taxing rate should be appled to items with a type of discount. This flag should only be true if the item is of type Sales Tax.
assessed_invoice__gl_transaction_KEY | int (4) |  | Finance charge items must have a non-null value for this column; it should be null for all other types of items. This column contains the key value of the AR invoice that was assessed to create the finance charge item.
ar_item_id_sortable | varchar (48) | NOT NULL | The sortable id for the item.
amount | decimal (9, 2) |  | This amount field shows the override value if not null otherwise it shows the original amount.

Primary key
Name | Columns | Description
PK_AR_Transaction_Item | ar_transaction_item_KEY |

Foreign keys
Name | Columns | Referenced table | Description
FK_AR_Transaction_Item__AR_Transaction__gl_transaction_KEY | gl_transaction_KEY | AR_Transaction (gl_transaction_KEY) |
FK_AR_Transaction_Item__AR_Item_Tax_Status__ar_item_tax_status_KEY | ar_item_tax_status_KEY | AR_Item_Tax_Status (ar_item_tax_status_KEY) |
FK_AR_Transaction_Item__AR_Item_Type__ar_item_type_KEY | ar_item_type_KEY | AR_Item_Type (ar_item_type_KEY) |
FK_AR_Transaction_Item__AR_Transaction__assessed_invoice__gl_transaction_KEY | assessed_invoice__gl_transaction_KEY | AR_Transaction (gl_transaction_KEY) |

Incoming foreign keys
Name | Columns | Referencing table | Description
FK_AR_Transaction_Item_GL_Account__AR_Transaction_Item__ar_transaction_item_KEY | ar_transaction_item_KEY | AR_Transaction_Item_GL_Account |
FK_AR_Transaction_Item_N_AR_Item__AR_Transaction_Item__ar_transaction_item_KEY | ar_transaction_item_KEY | AR_Transaction_Item_N_AR_Item |