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
NameTypeConstraintsDescription
ar_transaction_item_KEYint (4)NOT NULLPrimary key for this table.
gl_transaction_KEYint (4)NOT NULLkey to GL Transaction key for the AR Transaction this item belongs to.
ar_item_idnvarchar (22)NOT NULLThe id for the item.
descriptionnvarchar (2000)NOT NULLThe description for the item.
ar_item_type_KEYint (4)NOT NULLThe item type.
per_item_pricedecimal (9, 4)NOT NULLThe price per item for this ar transaction item. This value will be used along with quantity to calculate amount original.
per_item_purchase_costdecimal (9, 4)NOT NULLThe purchase cost per item. This will be used along with quantity to calculate total cost of the item.
ar_item_tax_status_KEYint (4)NOT NULLThe 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_descriptionnvarchar (60)NOT NULLIf 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_ratedecimal (5, 6)NOT NULLIf 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_percentagedecimal (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_discountbit (1)NOT NULLThe eligibility for discount on the item.
quantitydecimal (9, 4)NOT NULLThe quantity of this item to be used when calculating amount original.
sequence_numberint (4)NOT NULLA 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_originaldecimal (9, 2)NOT NULLThe 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_overridedecimal (9, 2)An override field for amount.
additional_tax_amountdecimal (9, 2)NOT NULLAn 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_amountdecimal (9, 2)NOT NULLAn 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_shippingbit (1)NOT NULLThis 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_discountbit (1)NOT NULLThis 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_KEYint (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_sortablevarchar (48)NOT NULLThe sortable id for the item.
amountdecimal (9, 2)This amount field shows the override value if not null otherwise it shows the original amount.
Primary key
NameColumnsDescription
PK_AR_Transaction_Itemar_transaction_item_KEY
Foreign keys
NameColumnsReferenced tableDescription
FK_AR_Transaction_Item__AR_Transaction__gl_transaction_KEYgl_transaction_KEYAR_Transaction (gl_transaction_KEY)
FK_AR_Transaction_Item__AR_Item_Tax_Status__ar_item_tax_status_KEYar_item_tax_status_KEYAR_Item_Tax_Status (ar_item_tax_status_KEY)
FK_AR_Transaction_Item__AR_Item_Type__ar_item_type_KEYar_item_type_KEYAR_Item_Type (ar_item_type_KEY)
FK_AR_Transaction_Item__AR_Transaction__assessed_invoice__gl_transaction_KEYassessed_invoice__gl_transaction_KEYAR_Transaction (gl_transaction_KEY)
Incoming foreign keys
NameColumnsReferencing tableDescription
FK_AR_Transaction_Item_GL_Account__AR_Transaction_Item__ar_transaction_item_KEYar_transaction_item_KEYAR_Transaction_Item_GL_Account
FK_AR_Transaction_Item_N_AR_Item__AR_Transaction_Item__ar_transaction_item_KEYar_transaction_item_KEYAR_Transaction_Item_N_AR_Item

Schema diagram