Cst City = AR_Customer.City
Cst Country = AR_Customer.CountryCode
Cst State = AR_Customer.State
Cst Zip = AR_Customer.ZipCode
Customer Name = AR_Customer.CustomerName
Customer No = AR_Customer.CustomerName
Customer Status = AR_Customer.CustomerStatus
AR_InvoiceHistoryDetail Table
Comment Text = AR_InvoiceHistoryDetail.CommentText
Exploded Kit Item = AR_InvoiceHistoryDetail.ExplodedKitItem
Extension Amt = AR_InvoiceHistoryDetail.ExtensionAmt
Quantity Shipped = AR_InvoiceHistoryDetail.QuantityShipped
Unit Cost = AR_InvoiceHistoryDetail.UnitCost
Unit Of Measure = AR_InvoiceHistoryDetail.UnitOfMeasure
Warehouse Code = AR_InvoiceHistoryDetail.WarehouseCode
Header Seq No = AR_InvoiceHistoryHeader.HeaderSeqNo
Invoice Date = AR_InvoiceHistoryHeader.InvoiceDate
Invoice No = AR_InvoiceHistoryHeader.InvoiceNo
Invoice Type = AR_InvoiceHistoryHeader.InvoiceType
Sales Order No = AR_InvoiceHistoryHeader.SalesOrderNo
Ship To City = AR_InvoiceHistoryHeader.ShipToCity
Ship To Code = AR_InvoiceHistoryHeader.ShipToCode
Ship to CountryCode = AR_InvoiceHistoryHeader.ShipToCountryCode
Ship To Name = AR_InvoiceHistoryHeader.ShipToName
Ship To State = AR_InvoiceHistoryHeader.ShipToState
Ship To Zip Code = AR_InvoiceHistoryHeader.ShipToZipCode
Salesperson Division No =AR_Salesperson.SalespersonDivisionNo
Salesperson Name = AR_Salesperson.SalespersonName
Salesperson No = AR_Salesperson.SalespersonNo
Item Code = CI_Item.ItemCode
Item Code Desc = CI_Item.ItemCodeDesc
Item Type = CI_Item.ItemType
Product Line = CI_Item.ProductLine
Product Type = CI_Item.ProductType
Account = GL_Account.Account
Account Desc = GL_Account.AccountDesc
Cost of Sales = AR_InvoiceHistoryDetail.(if ExplodedKitItem <> ‘C’ then UnitCost * QuantityShipped end)
Gross Profit = Sales – Cost of Sales
Qty Sold = AR_InvoiceHistoryDetail.(if QuantityShipped <> 0 then QuantityShipped end)
Sales = AR_InvoiceHistoryDetail.ExtensionAmt
