Dept Chrg Detail

This field contains the unique identifier for the department for which the upcharges are being defined.

This field contains the unique identifier for the location from which goods will be transferred. This is a store, warehouse or external finisher if the FROM_LOC_TYPE is S, W or E respectively.

This field contains the unique identifier for the location to which goods will be transferred. This is a store, warehouse or external finisher if the TO_LOC_TYPE is S, W or E respectively.

This field contains the unique identifier of the Up Charge component.

This field contains the type of location from which goods will be transferred. This column can contain either S for store, W for warehouse, or E for External Finisher.

This field contains the type of location to which goods will be transferred. This column can contain either S for store, W for warehouse, or E for External Finisher.

This field contains the rate to be charged against the cost of the Item/To Location combinations within the department. The value in this field will be a percentage if the calculation basis is V (Value), and a monetary amount if the calculation basis is S (Specific).

This field contains a count indicating the amount of the Per Count Unit of Measure to which the rate applies. This column will only contain a value if the calculation basis is S (Specific). For example, when creating an Up Charge that is defined as $.20 for every 10 kilograms of an item transferred, the Per Count would be 10.

This field contains the unit of measure in which the Per Count is specified. This column will only contain a value if the calculation basis is S (Specific). For example, when creating an Up Charge that is defined as $.20 for every 10 kilograms of an item transferred, the Per Count UOM would be the Unit of Measure code for Kilograms.

This field contains the group to which the component ID belongs. Valid values can be found on the codes table with a code type of UCHG.

This field contains the currency of the Up Charge component.

Contains the Computation Value Basis for the Up Charge component. This column will default to the value in the ELC_COMP table but can be updated at the department level.

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

Contains the display order from the Up Charge definition in the ELC_COMP table. The value cannot be updated at the department level. It is used to order the records displayed in the Department Up Charges screen.

Used to determine if the value of the individual up charge component is used to calculate the total up charge (Y) or if it is only used as the basis of calculating another up charge (N). This column will default to the value in the ELC_COMP table but can be updated at the department level.