 |
Retail Integration Bus Mappings Report
Release: 13.0.1 |
 |
|
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:ItemLocDesc.xsd |
| Tag Name | Table Name | Column Name | API Req | Description |
| item | item_loc | item | Yes | Unique identifier for the item. |
| ItemLocPhys | * | * | * | * |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:ItemLocPhys |
| Tag Name | Table Name | Column Name | API Req | Description |
| physical_loc | wh, item_loc | physical_wh, loc | Yes | If the loc_type is 'W', this is the physical warehouse that is assigned to the virtual wh where the item is located. If the loc_type is an 'S' then this is the store where the item is located. |
| ItemLocVirt | * | * | * | * |
| ItemLocVirtRepl | * | * | * | * |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:ItemLocVirt |
| Tag Name | Table Name | Column Name | API Req | Description |
| loc | item_loc | loc | Yes | Location where the item is to be found. This field may contain a store or a warehouse. |
| loc_type | item_loc | loc_type | Yes | Type of location in the "loc" field. Valid values are 'S' (store) and 'W' (warehouse). |
| local_item_desc | item_loc | local_item_desc | Yes | Contains the local description of the item. |
| local_short_desc | item_loc | local_short_desc | No | Contains the local short description of the item. |
| status | item_loc | status | Yes | Current status of the item at the store (valid values are 'A' (active), 'I' (inactive), 'C' (discontinued) and 'D' (deleted). |
| primary_supp | item_loc | primary_supp | No | Primary supplier for the item/location. |
| primary_cntry | item_loc | primary_cntry | No | Contains the origin country which will be considered the primary country for the item/location. |
| receive_as_type | item_loc | receive_as_type | No | Determines whether the stock on hand for a pack component item or the buyer pack itself will be updated when a buyer pack is received at a warehouse. Valid values are 'E'ach or 'P'ack. |
| taxable_ind | item_loc | taxable_ind | Yes | Indicates whether the item is taxable at the store. Valid values are 'Y' (yes) and 'N' (No). |
| source_method | item_loc | source_method | No | Determines the source method for a requested item at a store. Valid values: 'W'(warehouse) and 'S'(supplier), default value is 'S'. |
| source_wh | item_loc | source_wh | No | If the source_method is 'W', this field contains the source warehouse for fulfilling item requests at a store. |
| unit_retail | item_loc | unit_retail | No | Unit retail of the item in the selling Unit of Measure. Only published for create not modify. |
| selling_unit_retail | item_loc | selling_unit_retail | No | Selling unit retail in selling unit of measure. Only published for create, not update |
| selling_uom | item_loc | selling_uom | No | Selling Unit of measure. Only published for Create not update. |
| store_price_ind | item_loc | store_price_ind | Yes | Indicates if the location can modify the item's price |
| Application Name: Retail Merchandising System |
Version 13.0.1 |
XML-Schema or Node Name:ItemLocVirtRepl |
| Tag Name | Table Name | Column Name | API Req | Description |
| loc | repl_item_loc | location | Yes | Location that is on replenishment. Will hold only virtual warehouse in the multi-channel environment. |
| loc_type | repl_item_loc | loc_type | Yes | Contains the type of the location on replenishment. Valid values include 'S'tore, 'W'arehouse. |
| primary_repl_supplier | repl_item_loc | primary_repl_supplier | No | Contains the numeric identifier of the supplier from which the specified location will source the replenishment demand for the specified item location. Used for items on Direct to Store/Warehouse or Cross-docked replenishment. |
| repl_method | repl_item_loc | repl_method | Yes | Contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. Valid values include 'C'onstant, 'M'in/Max, 'F'loating point, 'T'ime Supply, 'D'ynamic, 'SO' Store Orders. |
| reject_store_order_ind | repl_item_loc | reject_store_ord_ind | No | Contains an indicator that determines if uploaded store orders should be rejected. If the indicator is 'N', then store orders for all need dates are valid. If 'Y', store orders with needs date on or after the NEXT_DELIVERY_DATE are valid." |
| next_delivery_date | repl_item_loc | next_delivery_date | No | Contains the next delivery date calculated for the next review cycle. If, for the next review cycle, an order will be created that is calculated to arrive on Thursday, this field will be updated with Thursday's date. |