Order Entry measures

Measure name Table name Source field
CO Actual Freight Charge CUSTORDER ACTUAL_FRT_CHG
CO CashIn Adv Req Percent CUSTORDER CIA_PCT
CO Currency Rate CUSTORDER CURR_RATE
CO Customer Order Count CUSTORDER COUNT(CustomerOrderKey)
CO Customs Total CUSTORDER CSTMS_TOT
CO Discount TakenOn Invoices CUSTORDER DISC_TKN_CURR
CO Discountable Amount CUSTORDER DISCNTBL_CURR
CO Electronic Payment Amount CUSTORDER EP_AMT_CURR
CO Electronic Payment Base Amount CUSTORDER EP_AMT_BASE
CO Electronic Payment Min Margin CUSTORDER EP_MARGIN_MIN
CO Entered Discount CUSTORDER ENTERED_DISC
CO Entered Payment CUSTORDER ENTERED_PMNT
CO EP Min Margin Pct CUSTORDER EP_MARGIN_PCT
CO Freight Charge CUSTORDER FRT_CHG_CURR
CO Freight Total CUSTORDER FREIGHT_TOT
CO Insurance Total CUSTORDER INSURANCE_TOT
CO Inv Goods Amount CUSTORDER INV_GDS_CURR
CO Inv Goods Base Amount CUSTORDER INV_GDS_BASE
CO NonInv Goods Amount CUSTORDER NI_GDS_CURR
CO NonInv Goods Base Amount CUSTORDER NI_GDS_BASE
CO Open Order Amount CUSTORDER OPEN_ORD_AMT
CO Open Order Base Amount CUSTORDER OPEN_ORD_CURR
CO Order Discount Amount CUSTORDER ORD_DISC_CURR
CO Order Gross Base Amount CUSTORDER FRT_CHG_CURR, INV_GDS_CURR, NI_GDS_CURR, MISC_TTL_CURR, CURR_RATE
CO Other AddOn Charges Total CUSTORDER OTHER_AOC_TOT
CO Pass Order Amount CUSTORDER PASS_ORD_AMT
CO Payment Invoiced CUSTORDER PMNT_INVCED
CO Stock Volume CUSTORDER CUBIC_FEET
CO Tax Total CUSTORDER TAX_TTL_CURR
CO Taxable Amount CUSTORDER TXBL_TTL_CURR
CO Total AddOn Charge Amount CUSTORDER MISC_TTL_CURR
CO Total Order Amount CUSTORDER ORDER_TTL_CURR
CO Total Order Base Amount CUSTORDER ORDER_TTL_BASE
COL Booked Quantity COLINE BOOKED_QTY
COL Cancel Quantity COLINE CXL_QTY
COL Cmsn Split Percentage COLINE COMM_SPLIT
COL Commission Rate1 COLINE COMM_RATE_1
COL Commission Rate2 COLINE COMM_RATE_2
COL Customs Total COLINE CSTMS_TOT
COL Disc Amount Currency COLINE DISC_AMT_CURR
COL Discount Taken COLINE DISC_TKN_CURR
COL Entered Discount COLINE ENTERED_DISC
COL Entered Price COLINE ENTERED_PRICE
COL Freight Total COLINE FREIGHT_TOT
COL Insurance Total COLINE INSURANCE_TOT
COL Invoice Quantity COLINE INVOICE_QTY
COL Order Quantity COLINE ORDER_QTY
COL Other AddOn Charges Total COLINE OTHER_AOC_TOT
COL Returned Quantity COLINE RETURNED_QTY
COL Secondary To Stock COLINE SEC_TO_STOCK
COL Sell Price Currency COLINE SELL_PRC_CURR
COL Sell Price To Stock COLINE SPR_TO_STOCK
COL Sell To Stock COLINE SELL_TO_STOCK
COL Sell Unit Price COLINE SELL_UNIT_PRC
COL Shipped Quantity COLINE SHIPPED_QTY
COL Supplementary Quantity COLINE SUPLMNTARY_QTY
COL Unit Cost COLINE UNIT_COST
COL Unit Price COLINE UNIT_PRICE
COR Comment Count RETURNHDR CM_CNT
COR Freight Charge RETURNHDR FRT_CHARGE
COR Line Total RETURNHDR LINE_TOTAL
COR Undecided Comment Count RETURNHDR UND_CM_CNT
COR Undecided Item Count RETURNHDR UND_ITEM_CNT
CORL Average Cost RETURNLINE AVERAGE_COST
CORL Base Price RETURNLINE BASE_PRICE
CORL Customs Total RETURNLINE CSTMS_TOT
CORL Detail Quantity RETURNLINE DETAIL_QTY
CORL Entered Price RETURNLINE ENTERED_PRICE
CORL Entered Unit Cost RETURNLINE ENT_UNIT_COST
CORL Freight Total RETURNLINE FREIGHT_TOT
CORL Insurance Total RETURNLINE INSURANCE_TOT
CORL Inventory Catch Weight Qty RETURNLINE INVEN_CW_QTY
CORL Invoice Catch Weight Quantity RETURNLINE INVC_CW_QTY
CORL Other AddOn Charges Total RETURNLINE OTHER_AOC_TOT
CORL Quantity RETURNLINE QUANTITY
CORL Restock Charge RETURNLINE RESTK_CHG_CODE
CORL Selling Price To Stock RETURNLINE SPR_TO_STOCK
CORL Standard Cost RETURNLINE STD_COST
CORL Stock OnHand Quantity RETURNLINE SOH_QTY
CORL Unit Cost RETURNLINE UNIT_COST
CORL Unit Price RETURNLINE UNIT_PRICE