XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for XCostChgDesc in IGS application. |
IGS's Table Name |
IGS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
IGS's Column Length |
Is Column Required in IGS's API? |
IGS's 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. |
RMS.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. |
RMS.item_supp_country |
supplier |
varchar2 |
10 |
Yes |
The number of the supplier that sources the items affected by the cost change. 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. |
RMS.item_supp_country |
origin_country_id |
varchar2 |
3 |
Yes |
The identifier of the origin country of the item\supplier to which the cost change applies. This value must be predefined in 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. |
RMS.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. |
RMS.item_supp_country |
unit_cost |
null |
null |
Yes |
The new unit cost of the item in the currency specified in the message. The tables, item_supp_country_loc, item_loc_soh, and ordloc also can 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). |
RMS.n/a |
n/a |
null |
null |
Yes |
This field indicates whether orders in Approved status for items on the cost change will be recalculated with the new cost. Valid values are Y and N. |
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. |
RMS.currency |
currency_code |
null |
null |
Yes |
The currency code of the unit cost. This value must be predefined in 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). |
RMS.n/a |
n/a |
null |
null |
No |
The hierarchy level of the hierarchy value. This field indicates 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.
|
|
|
|
|
|
|