Cost Comp Upd Stg

Sequence number for the cost components updates.

Defaulting level for the cost component change. It represents the at which level the cost component change was made. Valid values are E - Expense Component Level, C - Country level, S - Supplier level, P - Partner level, D - Dept level, I - Item level.

Contains a unique user specified code representing the cost Component.

Contains a code used to distinguish between Expenses, Assessments, and Up Charges.

This field will be populated only when the component type is Expense and it defines the type of the expense

Contains the unique number that is used to distinguish between the different profiles.

Contains the department number.

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 COST_COMP_UPD_STG.

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

The unique identifier for the Harmonized Tariff Schedule code.

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.

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 old rate to be charged against the calculation base.

Contains the old currency the expense or assessment is to be 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 is 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.

Indicator to specify if this cost component change is to be cascaded to countries.

Indicator to specify if this cost component change is to be cascaded to suppliers.

Indicator to specify if this cost component change is to be cascaded to partners.

Indicator to specify if this cost component change is to be cascaded to items.

Indicator to specify if this cost component change is to be cascaded to orders.

Indicator to specify if this cost component change is to be cascaded to transfers and allocations

Indicator to specify if this cost component change is to be cascaded to departments.

Contains the zone identification number which uniquely identifies the zone. Ifthe level of the zone group is store, then the zone will be the store number. Thisfield will only have a value for zone level expenses.

This field contains the zone group ID for which the profile or the items expense belongs to. This field will only have a value for zone level expenses.

This field contains the exchange between the old and new component currencies.

The date from which the new values are effective in the system. If the defaulting level is I then the date is equal to the vdate

Contains the identification of the Landed Cost lading port.This field will only contain a value if the Expense Type is Country

Contains the identification of the discharge port where item is entering the country

Describes the type of action. Valid values are 'NEW' for create, 'MOD' for update and 'DEL' for delete.

This field will capture whether or not defaulted from values should be used when determining which items or orders to update for expense rate updates via the supplier, country or partner expense profile. Valid values are Yes (Y) or No (N). This indicator is not used for item level updates.