Tag Name |
Type |
Min Occurs |
Max Occurs |
Description |
rms Mapping For XCostChgDesc |
Table Name |
Column Name |
API Type |
Column Length |
API Required |
API Description |
item |
varchar225 |
1 |
1 |
The item to which the cost change applies. It can be a parent item, but its item level cannot be greater than its transaction level. This cannot be a buyer pack. |
item_supp_country |
item |
varchar2 |
25 |
Yes |
The item to which the cost change applies. It can be a parent item, but its item level cannot be greater than its transaction level. This cannot be a buyer pack. |
supplier |
number10 |
1 |
1 |
The number of the supplier that sources the items the cost change affects. This value must be predefined on the SUPS table. This can be a primary or non-primary supplier. |
item_supp_country |
supplier |
varchar2 |
10 |
Yes |
The number of the supplier that sources the items the cost change affects. This value must be predefined on the SUPS table. This can be a primary or non-primary supplier. |
origin_country_id |
varchar23 |
1 |
1 |
The identifier of the origin country of the item\supplier to which the cost change will apply. This value must be predefined on the COUNTRIES table. This can be the primary or a non-primary country. |
item_supp_country |
origin_country_id |
varchar2 |
3 |
Yes |
The identifier of the origin country of the item\supplier to which the cost change will apply. This value must be predefined on the COUNTRIES table. This can be the primary or a non-primary country. |
diff_id |
varchar210 |
0 |
1 |
The identifier for a differentiator. This can be used with a parent or grandparent item. The cost change will "explode" to all the parent's transaction level items with the differentiator. This value must be predefined on the DIFF_IDS table. |
item_master |
diff_1, diff_2, diff_3, diff_4 |
null |
null |
No |
The identifier for a differentiator. This can be used with a parent or grandparent item. The cost change will "explode" to all the parent's transaction level items with the differentiator. This value must be predefined on the DIFF_IDS table. |
unit_cost |
number20_4 |
1 |
1 |
The new unit cost of the item in the currency specified on the message. Tables item_supp_country_loc, item_loc_soh, and ordloc can also be updated, depending on the values in tags hier_level and hier_value. |
item_supp_country |
unit_cost |
null |
null |
Yes |
The new unit cost of the item in the currency specified on the message. Tables item_supp_country_loc, item_loc_soh, and ordloc can also be updated, depending on the values in tags hier_level and hier_value. |
recalc_ord_ind |
varchar21 |
1 |
1 |
This field will indicate if orders in approved status for items on the cost change will be recalculated with the new cost. Valid values will be Y (yes) and N (no). |
n/a |
n/a |
null |
null |
Yes |
This field will indicate if orders in approved status for items on the cost change will be recalculated with the new cost. Valid values will be Y (yes) and N (no). |
currency_code |
varchar23 |
1 |
1 |
The currency code of the unit cost. This value must be predefined on the CURRENCIES table and must be the currency of the supplier. |
currency |
currency_code |
null |
null |
Yes |
The currency code of the unit cost. This value must be predefined on the CURRENCIES table and must be the currency of the supplier. |
hier_level |
varchar22 |
0 |
1 |
The hierarchy level of the hierarchy value. This field will indicate the level of the organizational hierarchy to which the cost change applies. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), W (warehouse). |
n/a |
n/a |
null |
null |
No |
The hierarchy level of the hierarchy value. This field will indicate the level of the organizational hierarchy to which the cost change applies. Valid values are CH (chain), AR (area), RE (region), DI (district), S (store), W (warehouse). |
XCostChgHrDtl
|
*
|
0
|
unbounded
|
Description is not available.
|
|
|
|
|
|
|
ExtOfXCostChgDesc:ExtOfXCostChgDesc
|
*
|
0
|
1
|
Provide an extension hook to customize XCostChgDesc.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|