Customer Order
- Cancelled Date
- Order Date
| Measure | Source and/or calculation |
|---|---|
| Cancelled Order Count |
IF FSM_CancelledDate != NULL THEN Cancelled Order Count = 1 ELSE Cancelled Order Count = 0 |
| COH Actual Freight Charge | ActualFreightCharge |
| COH Base Order Discount For Discount Code | Order Discount Amount For Discount Code * Currency Rate |
| COH Cash In Advance Required Percent | CashInAdvanceRequiredPercent |
| COH Commission Rate 1 | CommissionRate1 |
| COH Commission Rate 2 | CommissionRate2 |
| COH Commission Split Percentage | CommissionSplitPercentage |
| COH Currency Rate |
IF FSM_CurrencyRate <> NULL THEN COH Currency Rate = FSM_CurrencyRate ELSE COH Currency Rate = 0 |
| COH Customer Current Balance | CustomerCurrentBalance |
| COH Customer Open Order Amount | CustomerOpenOrderAmount |
| COH Customer Order Count | UniqueID |
| COH Customs Total | CustomsTotal |
| COH Derived Tax Total Base Amount | Tax Total * Currency Rate |
| COH Derived Total Taxable Base Amount | Derived Total Taxable Amount * Currency Rate |
| COH Discount Taken On Invoices | DiscountTakenOnInvoices |
| COH Electronic Payment Base Amount | ElectronicPaymentBaseAmount |
| COH Entered Discount Base | Entered Discount * Currency Rate |
| COH Entered Payment | EnteredPayment |
| COH Freight Charge |
IF FreightCharge <> NULL THEN COH Freight Charge = FreightCharge ELSE COH Freight Charge = 0.0 |
| COH Freight Charge Base | Freight Charge * Currency Rate |
| COH Freight Total | FreightTotal |
| COH Goods Base Amount | Inventory Goods Base Amount + Non Inventory Goods Base Amount |
| COH Insurance Total | InsuranceTotal |
| COH Inventory Goods Base Amount |
IF InventoryGoodsBaseAmount <> NULL THEN COH Inventory Goods Base Amount = InventoryGoodsBaseAmount ELSE COH Inventory Goods Base Amount = 0.0 |
| COH Non Inventory Goods Base Amount |
IF NonInventoryGoodsBaseAmount <> NULL THEN COH Non Inventory Goods Base Amount = NonInventoryGoodsBaseAmount ELSE COH Non Inventory Goods Base Amount = 0.0 |
| COH Open Order Base Amount | OpenOrderBaseAmount |
| COH Order Discount Amount |
IF OrderDiscountAmount <> NULL THEN COH Order Discount Amount = OrderDiscountAmount ELSE COH Order Discount Amount = 0.0 |
| COH Order Discount Percentage | OrderDiscountPercentage |
| COH Order Gross Base Amount | ((Inventory Goods Base Amount/Currency Rate) + (Non Inventory Goods Base Amount/Currency Rate) + Total Add On Charge Amount + Freight Charge) * Currency Rate |
| COH Order Total Base |
(IF Order Total <> NULL THEN COH Order Total Base = Order Total ELSE COH Order Total Base = 0.0) * (IF Currency Rate <> NULL THEN COH Order Total Base = Currency Rate ELSE COH Order Total Base = 0.0) |
| COH Original Open Order Base Amount | ((Inventory Goods Base Amount / Currency Rate) + (Non Inventory Goods Base Amount / Currency Rate) + Total Add On Charge Amount + Freight Charge Order Discount Amount Entered Discount) * Currency Rate |
| COH Other Add On Charges Total | OtherAddOnChargesTotal |
| COH Pass Order Amount | PassOrderAmount |
| COH Proforma Cash In Advance Required Percent | ProformaCashInAdvanceRequiredPercent |
| COH Released Order Count |
IF Status_State = 'Released' THEN Released Order Count = 1 ELSE Released Order Count = 0 |
| COH Sales Tax Base | Sales Tax *Currency Rate |
| COH Stock Volume | StockVolume |
| COH Stock Weight | StockWeight |
| COH Tax Total |
IF TaxTotal <> NULL THEN COH Tax Total = TaxTotal ELSE COH Tax Total = 0.0 |
| COH Taxable Amount | TaxableAmount |
| COH Terms Discount Base Amount |
(IF Terms Discount Amount <> NULL THEN COH Terms Discount Base Amount = Terms Discount Amount ELSE COH Terms Discount Base Amount = 0.0) * (IF Currency Rate <> NULL THEN COH Terms Discount Base Amount = Currency Rate ELSE COH Terms Discount Base Amount = 0.0) |
| COH Total Add On Charge Amount |
IF TotalAddOnChargeAmount <> NULL THEN COH Total Add On Charge Amount = TotalAddOnChargeAmount ELSE COH Total Add On Charge Amount = 0.0 |
| COH Total Add On Charge Base Amount | Total Add On Charge Amount * Currency Rate |
| COH Total Order Base Amount | TotalOrderBaseAmount |