Order Entry measures
Company Customer
| Measure | Source and/or calculation |
|---|---|
| Credit Limit | CompanyCustomer.CreditLimit |
| Credit Review Days | CompanyCustomer.CreditReviewDays |
| Current Balance | CompanyCustomer.CurrentBalance |
| Disputed Invoice Amount | CompanyCustomer.DisputedInvoiceAmount |
| Disputed Invoices | CompanyCustomer.DisputedInvoices |
| Last Dunning Letter Number | CompanyCustomer.LastDunningLetterNumber |
| Last Payment Amount | CompanyCustomer.LastPaymentAmount |
| Open Order Amount | CompanyCustomer.OpenOrderAmount |
| Order Limit | CompanyCustomer.OrderLimit |
| Search Name | CompanyCustomer.SearchName |
| Unapplied Payments Credits | CompanyCustomer.UnappliedPaymentsCredits |
| Unreleased Payments | CompanyCustomer.UnreleasedPayments |
| Year To Date Cash Paid | CompanyCustomer.YearToDateCashPaid |
| Year To Date Earned Discounts | CompanyCustomer.YearToDateEarnedDiscounts |
| Year To Date Unearned Discounts | CompanyCustomer.YearToDateUnearnedDiscounts |
Customer Order
| Measure | Source and/or calculation |
|---|---|
| Cancelled Order Count |
IF [FSM_CustomerOrder.CancelledDate] != NULL THEN [Cancelled Order Count] = 1 ELSE [Cancelled Order Count] = 0 END IF |
| COH Actual Freight Charge | CustomerOrder.ActualFreightCharge |
| COH Base Order Discount For Discount Code | [Customer Order.Order Discount Amount For Discount Code] * [Customer Order.Currency Rate] |
| COH Cash In Advance Required Percent | CustomerOrder.CashInAdvanceRequiredPercent |
| COH Commission Rate 1 | CustomerOrder.CommissionRate1 |
| COH Commission Rate 2 | CustomerOrder.CommissionRate2 |
| COH Commission Split Percentage | CustomerOrder.CommissionSplitPercentage |
| COH Currency Rate | IFNULL([FSM_CustomerOrder.CurrencyRate],0.0) |
| COH Customer Current Balance | CustomerOrder.CustomerCurrentBalance |
| COH Customer Open Order Amount | CustomerOrder.CustomerOpenOrderAmount |
| COH Customer Order Count | CustomerOrder.UniqueID |
| COH Customs Total | CustomerOrder.CustomsTotal |
| COH Derived Tax Total Base Amount | [Customer Order.Tax Total] * [Customer Order.Currency Rate] |
| COH Derived Total Taxable Base Amount | [Customer Order.Derived Total Taxable Amount] * [Customer Order.Currency Rate] |
| COH Discount Taken On Invoices | CustomerOrder.DiscountTakenOnInvoices |
| COH Electronic Payment Base Amount | CustomerOrder.ElectronicPaymentBaseAmount |
| COH Entered Discount Base | [Customer Order.Entered Discount] * [Customer Order.Currency Rate] |
| COH Entered Payment | CustomerOrder.EnteredPayment |
| COH Freight Charge | IFNULL([FSM_CustomerOrder.FreightCharge],0.0) |
| COH Freight Charge Base | [Customer Order.Freight Charge] * [Customer Order.Currency Rate] |
| COH Freight Total | CustomerOrder.FreightTotal |
| COH Goods Base Amount | [Customer Order.Inventory Goods Base Amount] + [Customer Order.Non Inventory Goods Base Amount] |
| COH Insurance Total | CustomerOrder.InsuranceTotal |
| COH Inventory Goods Base Amount | IFNULL([FSM_CustomerOrder.InventoryGoodsBaseAmount],0.0) |
| COH Non Inventory Goods Base Amount | IFNULL([FSM_CustomerOrder.NonInventoryGoodsBaseAmount],0.0) |
| COH Open Order Base Amount | CustomerOrder.OpenOrderBaseAmount |
| COH Order Discount Amount | IFNULL([FSM_CustomerOrder.OrderDiscountAmount],0.0) |
| COH Order Discount Percentage | CustomerOrder.OrderDiscountPercentage |
| COH Order Gross Base Amount | (([OE Customer Order.Inventory Goods Base Amount] / [OE Customer Order.Currency Rate]) + ([OE Customer Order.Non Inventory Goods Base Amount] / [OE Customer Order.Currency Rate]) + [OE Customer Order.Total Add On Charge Amount] + [OE Customer Order.Freight Charge]) * [OE Customer Order.Currency Rate] |
| COH Order Total Base | IFNULL([OE Customer Order.Order Total],0.0) * IFNULL([OE Customer Order.Currency Rate],0.0) |
| COH Original Open Order Base Amount | (([OE Customer Order.Inventory Goods Base Amount] / [OE Customer Order.Currency Rate]) + ([OE Customer Order.Non Inventory Goods Base Amount] / [OE Customer Order.Currency Rate]) + [OE Customer Order.Total Add On Charge Amount] + [OE Customer Order.Freight Charge] - [OE Customer Order.Order Discount Amount] - [OE Customer Order.Entered Discount]) * [OE Customer Order.Currency Rate] |
| COH Other Add On Charges Total | CustomerOrder.OtherAddOnChargesTotal |
| COH Pass Order Amount | CustomerOrder.PassOrderAmount |
| COH Proforma Cash In Advance Required Percent | CustomerOrder.ProformaCashInAdvanceRequiredPercent |
| COH Released Order Count |
IF [FSM_CustomerOrder.Status_State] = 'Released' THEN [Released Order Count] = 1 ELSE [Released Order Count] = 0 END IF |
| COH Sales Tax Base | [OE Customer Order.Sales Tax] * [OE Customer Order.Currency Rate] |
| COH Stock Volume | CustomerOrder.StockVolume |
| COH Stock Weight | CustomerOrder.StockWeight |
| COH Tax Total | IFNULL([FSM_CustomerOrder.TaxTotal],0.0) |
| COH Taxable Amount | CustomerOrder.TaxableAmount |
| COH Terms Discount Base Amount | IFNULL([OE Customer Order.Terms Discount Amount],0.0) * IFNULL([OE Customer Order.Currency Rate],0.0) |
| COH Total Add On Charge Amount | IFNULL([FSM_CustomerOrder.TotalAddOnChargeAmount],0.0) |
| COH Total Add On Charge Base Amount | [OE Customer Order.Total Add On Charge Amount] * [OE Customer Order.Currency Rate] |
| COH Total Order Base Amount | CustomerOrder.TotalOrderBaseAmount |
Customer Order Line
| Measure | Source and/or calculation |
|---|---|
| COL Cancel Quantity | CustomerOrderLine.CancelQuantity |
| COL Commission Rate 1 | CustomerOrderLine.CommissionRate1 |
| COL Commission Rate 2 | CustomerOrderLine.CommissionRate2 |
| COL Commission Split Percentage | CustomerOrderLine.CommissionSplitPercentage |
| COL Customs Total | CustomerOrderLine.CustomsTotal |
| COL Derived Tax Total | CustomerOrderLine.DerivedTaxTotal |
| COL Discount Amount Currency | IFNULL([FSM_CustomerOrderLine.DiscountAmountCurrency],0.0) |
| COL Discount Taken | CustomerOrderLine.DiscountTaken |
| COL Entered Discount | CustomerOrderLine.EnteredDiscount |
| COL Entered Price | CustomerOrderLine.EnteredPrice |
| COL Freight Total | CustomerOrderLine.FreightTotal |
| COL Gross Amount Base | ([OE Customer Order Line.Order Quantity] * [OE Customer Order Line.Sell Price Currency]) * [OE Customer Order Line.Currency Rate] |
| COL Insurance Total | CustomerOrderLine.InsuranceTotal |
| COL Invoice Quantity | CustomerOrderLine.InvoiceQuantity |
| COL Line Booked Quantity | CustomerOrderLine.BookedQuantity |
| COL Line Total | CustomerOrderLine.LineTotal |
| COL Net Amount Base | (([OE Customer Order Line.Order Quantity] * [OE Customer Order Line.Sell Price Currency]) - [OE Customer Order Line.Discount Amount Currency] - [OE Customer Order Line.Entered Discount]) * [OE Customer Order Line.Currency Rate] |
| COL Order Quantity | IFNULL([FSM_CustomerOrderLine.OrderQuantity],0.0) |
| COL Other Add On Charges Total | CustomerOrderLine.OtherAddOnChargesTotal |
| COL Returned Quantity | CustomerOrderLine.ReturnedQuantity |
| COL Sell Price Currency | IFNULL([FSM_CustomerOrderLine.SellPriceCurrency],0.0) |
| COL Sell Price To Stock | CustomerOrderLine.SellPriceToStock |
| COL Sell To Stock | CustomerOrderLine.SellToStock |
| COL Sell Unit Price | CustomerOrderLine.SellUnitPrice |
| COL Shipped Quantity | CustomerOrderLine.ShippedQuantity |
| COL Supplementary Quantity | CustomerOrderLine.SupplementaryQuantity |
| COL Taxable Amount Currency | CustomerOrderLine.TaxableAmountCurrency |
| COL Unit Cost | CustomerOrderLine.UnitCost |
| COL Unit Price | CustomerOrderLine.UnitPrice |
| Override Taxable | CustomerOrderLine.OverrideTaxable |
Customer Order Return
| Measure | Source and/or calculation |
|---|---|
| COR Customs Total | CustomerOrderReturn.CustomsTotal |
| COR Freight Charge | CustomerOrderReturn.FreightCharge |
| COR Freight Total | CustomerOrderReturn.FreightTotal |
| COR Insurance Total | CustomerOrderReturn.InsuranceTotal |
| COR Line Total | CustomerOrderReturn.LineTotal |
| COR Other Add On Charges Total | CustomerOrderReturn.OtherAddOnChargesTotal |
| Released Return Count |
IF [FSM_CustomerOrderReturn.Status_State] = 'Released' THEN [Released Return Count] = 1 ELSE [Released Return Count] = 0 END IF |
| Return Count | CustomerOrderReturn.ReturnCount |
Customer Order Return Line
| Measure | Source and/or calculation |
|---|---|
| CRL Average Cost | CustomerOrderReturnLine.AverageCost |
| CRL Base Price | CustomerOrderReturnLine.BasePrice |
| CRL Customs Total | CustomerOrderReturnLine.CustomsTotal |
| CRL Detail Quantity | CustomerOrderReturnLine.DetailQuantity |
| CRL Entered Price | CustomerOrderReturnLine.EnteredPrice |
| CRL Entered Unit Cost | CustomerOrderReturnLine.EnteredUnitCost |
| CRL Freight Total | CustomerOrderReturnLine.FreightTotal |
| CRL Insurance Total | CustomerOrderReturnLine.InsuranceTotal |
| CRL Inventory Catch Weight Quantity | CustomerOrderReturnLine.InventoryCatchWeightQuantity |
| CRL Invoice Catch Weight Quantity | CustomerOrderReturnLine.InvoiceCatchWeightQuantity |
| CRL Other Add On Charges Total | CustomerOrderReturnLine.OtherAddOnChargesTotal |
| CRL Quantity | CustomerOrderReturnLine.Quantity |
| CRL Sell To Stock | CustomerOrderReturnLine.SellToStock |
| CRL Selling Price To Stock | CustomerOrderReturnLine.SellingPriceToStock |
| CRL Standard Cost | CustomerOrderReturnLine.StandardCost |
| CRL Stock On Hand Quantity | CustomerOrderReturnLine.StockOnHandQuantity |
| CRL Unit Cost | CustomerOrderReturnLine.UnitCost |
| CRL Unit Price | CustomerOrderReturnLine.UnitPrice |