Tsfdetail Chrg

This field contains a number that uniquely identifies the transfer within the system.

This field contains a sequence number when combined with the transfer number references a unique record on the transfer detail table.

This field contains the shipment number for the associated transfer. The field will only contain a value if the transfer is an Externally Generated transfer (i.e. the Transfer Type is EG).

This field contains the sequence number used along with the Shipment number and Item to make the Shipment Item records unique. There can be multiple Transfers [Distros], Inventory Statuses, or Cartons for the same Shipment/Item; the sequence number will refer back to a single unique Shipment/Item record if those values vary. The field will only contain a value if the transfer is an Externally Generated transfer (i.e. the Transfer Type is EG).

This field holds the unique alphanumeric value that identifies the item, or a component item of a pack that is on the transfer.

This field contains the location number of the from location for the up charge associated with the transfer detail inventory flow. This field will contain either a store or virtual warehouse or external finisher number based on the FROM_LOC_TYPE field.

This field contains the location number of the to location for the up charge associated with the transfer detail inventory flow. This field will contain a store, virtual warehouse, internal finisher or external finisher based on the TO_LOC_TYPE field.

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

This field contains the location type of the from location for the up charge associated with the transfer detail inventory flow. Valid values are Store, Warehouse (warehouse and internal finisher), External finisher (on PARTNER table).

This field contains the location type of the to location for the up charge associated with the transfer detail inventory flow. Valid values are Store, Warehouse (warehouse and internal finisher), External finisher (on PARTNER table).

This field contains the unique identifier for a pack when one is on the transfer.

This field contains the rate to be charged against the weighted average 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.

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 code of the Up Charge component.

This field contains the order in which the components should be displayed. A value of 0 (zero) indicates that the component will not be displayed in the form, but the assoicated value will be included in the calculations.

Contains the Computation Value Basis for the Up Charge component. This column will be defaulted from the value in ELC_COMP when the Up Charge component is added directly to an item via the Item Up Changes screen. It will be defaulted from the value in DEPT_CHRG_DETAIL when the Up Charge component is defaulted from Department Up Charges. The value can be overwritten at the item 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).

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 ELC_COMP when the Up Charge component is added directly to an item via the Item Up Changes screen. It will default to the value in DEPT_CHRG_DETAIL when the Up Charge component is defaulted from Department Up Charges. The value can be overwritten at the item level.