# 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 |