Gtt Cost Comp Upd

Oracle Retail target column ROW_IDYROWID102EXP_PROF_KEY on GTT_COST_COMP_UPD.

Alphanumeric value that identifies the item.

The unique identifier for the supplier.

Contains the type of expense. Oracle Retail target column ITEM_EXP_TYPE on GTT_COST_COMP_UPD.

Contains a sequence number that is used to distinguish between the differentItem/Supplier expenses.

Used to store the order number, used in scenarios when the order loc expense or ordsku hts assessments are updated.

The pack item number. Oracle Retail target column PACK_ITEM on GTT_COST_COMP_UPD.

The location associated with the order expense

Contains the department number.

Contains the location number of the location from which goods will be transferred. This column can contain either a store or a warehouse.

Contains the location number of the location to which goods will be transferred. This column can contain either a store or a warehouse.

Contains the transfer number associated with the Transfer that is fetched for update.

The sequence is directly taken from the TSFDETAIL table.

Used to store the allocation number when an allocation is fetched for update.

This column stores the harmonized tariff number whenever assessments at various levels are fetched for update.

The unique identifier for the country that the item will be imported into.

The country where the item was manufactured or significantly altered.

The date from which the Item/HTS relationship is valid. This field is used to maintain historical information related to the Item/HTS relationship.

The date till which the Item/HTS relationship is valid. This field is used to maintain historical information related to the Item/HTS relationship.

This column is used to store the sequence value associated with hts assessments.

Holds the component id associated with the cost component entries at any level.

Contains the current rate to be charged against the calculation base.

Contains the current currency the expense or assessment is to be entered in.

Contains the current count indicating the amount of the Per Count Unit of Measure to which the rate applies.

Contains the current unit of measure in which the Per Count is specified.

Contains the old rate which was charged against the calculation base.

Contains the old currency the expense or assessment was entered in.

Contains the old count indicating the amount of the Per Count Unit of Measure to which the rate applies.

Contains the old unit of measure in which the Per Count was specified.

Contains the new rate to be charged against the calculation base.

Contains the new currency the expense or assessment is to be entered in.

Contains the new count indicating the amount of the Per Count Unit of Measure to which the rate applies.

Contains the new unit of measure in which the Per Count is specified.

A flag to indicate whether the order/item holding the expense or assessment has been shipped.

Contains the value from the table ordloc_exp or ordsku_hts_assess.It indicates the status of the cost component.

Contains the value of the CVB_code taken up from the table cvb_head.

A flag to indicate the status of the concerned order/item.

This column will be used to store the exchange rate from the table cost_comp_upd_stg.

This column holds the zone_id of the item expense.

This column holds the zone group id of the item expenses zone id.

This field specifies the default level for this cost component update 1 - Item, 2 - Supplier, 3 - Partner, 4 - Country, 5 - Expense.

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.