Skip to content

What Is The Purpose of Field CPORDHDR_FRT_ENT_MTHD in COP Order Header?

Release Date: 2/23/2021
Version: 7.5 & Up

Q - Can you explain the purpose/functionality of the ORDER_FRT_ENT_MTHD field in the CPORDHDR table?

AThe purpose is to record how the order header freight amount is determined. 

The possible values can be:
  • "A" = Automatically Calculate in Billing Screen
  • "B" = Manual Enter Through Billing Screen
  • "S" = Manual Enter Through Shipping Data Update
  • "D" = Automatically Calculate in Shipping Data Update
  • "V" = Calculated By Shipping Verification
  • "X" = Calculated By Shipping Confirmation
  • "C" = Manual Enter By Shipping Confirmation
  • "R" = Calculated By Mass Billing By Range
  • "M" = Calculated By Mass Billing By Shipping Verification
  • "L" = Through VICS BOL
  • “Spaces” = No Value
As you know, in Elliott users can optionally access the billing screen in Order Entry. The freight amount could be determined at the time of order entry. But what if the order is changed later on -- should the freight amount be changed later? We have an issue here because we don’t know if the freight amount should stay fixed or should be recalculated if the order is changed.

The main purpose is to determine if the freight should be recalculated in the billing screen. There is a related flag in Global Setup -> Cop-Func -> Order Billing Screen -> 1. Initialize Freight Amount in Order Billing. If this Global Setup flag is “N,” then the existing freight amount in the billing screen will be preserved in the billing screen. If it is “Y,” then the system tries to determine if the freight was previously entered manually based on the value in CPORDHDR ORDER_FRT_ENT_MTHD. If it was previously entered manually (Value “B” or “S”), then even if the Global Setup flag is = “Y,” the previous manually entered freight amount will be preserved. If it was calculated automatically, then it will wiped out and possibly recalculated.

EMK

Feedback and Knowledge Base