Wf Order Exp

This is the unique system generated franchise order no. It also serves as the primary key for this table along with SEQ_NO.

This field is used with WF_ORDER_NO to make the record unique.

This is a required system generated field that is used to link an item record to the WF_ORDER_DETAIL table.

This field identifies the cost component ID which gives the upcharge cost component that was applied to this item location.

This field identifies the calculation basis as how the component rate will be used. The two valid values are, Value and Specific. When the calculation basis is Value the component rate represents a percent. When the calculation basis is Specific the component rate represents a particular monetary amount.

This field represents the rate of the upcharge amount based on the CALC_BASIS. This field will have a percent when the calculation basis is value and it will have an amount when the calculation basis is specific.

This field represents the number of units for the per count unit of measure that a specific component rate will be applied against.

This field represents the UOM that a specific component rate will be applied against. This field is only used when the CALC_BASIS is specific.

This field represents the currency the component rate is entered in. If the CALC_BASIS is V then this field is null.

This field represents the exchange rate between the currency the component rate is entered in and the franchise currency. If the CALC_BASIS is V then this field is NULL.

This field represents the estimated upcharge amount for this particular expense against the item/location on the order.

Contains the Computation Value Basis when the comp_id is an Up Charge component. This column will hold the value on ITEM_CHRG_DETAIL when the franchise order line was created.

Contains the basis the Up Charge will be calculated against. Valid values are defined in code type UCCB (Up Charge Cost Basis) with values: Acquisition Cost (W), Supplier Cost (S) and Off-Invoice Net Cost (N).