Merchandising to SIOCS
| Interface | Change Log Table | Merchandising View/s | SIOCS Staging Table |
|---|---|---|---|
| Address | ICL_RMS_ADDR | V_RMS_SIM_ADDR | MPS_STAGED_MESSAGE |
| Allocations | ICL_RMS_ALLOC |
V_RMS_SIM_ALLOC_HEADER V_RMS_SIM_ALLOC_DETAIL |
MPS_STAGED_MESSAGE |
| ASNs | ICL_RMS_SHIPMENT |
V_RMS_SIM_SHIPMENT V_RMS_SIM_SHIPSKU |
MPS_STAGED_MESSAGE |
| Clearances and Clearance Resets | RPM_ICL_PRICE_EVENT_PAYLOAD | RPM_SIM_CLEARANCE_V |
MPS_STAGED_MESSAGE ICLS_CLEARANCE |
| Codes |
V_RMS_SIM_CODE_HEAD V_RMS_SIM_CODE_DETAIL |
||
| Delivery Slots | V_RMS_SIM_DELIVERY_SLOT | ||
| Differentiator Types | ICL_RMS_DIFF_TYPE | V_RMS_SIM_DIFF_TYPE | MPS_STAGED_MESSAGE |
| Differentiators | ICL_RMS_DIFF_IDS | V_RMS_SIM_DIFF | MPS_STAGED_MESSAGE |
| Item Locations |
ICL_RMS_ITEM_LOC ICL_RMS_REPL_ITEM_LOC |
V_RMS_SIM_ITEM_LOC V_RMS_SIM_ITEM_LOC_CFA_EXT V_RMS_SIM_REPL_ITEM_LOC V_RMS_SIM_STORE_ITEM |
MPS_STAGED_MESSAGE ICLS_ITEM_LOC ICLS_ITEM_LOC_CFA |
| Items |
ICL_RMS_ITEM_MASTER ICL_RMS_ITEM_IMAGE ICL_RMS_ITEM_SUPPLIER ICL_RMS_ITEM_SUPP_CTRY ICL_RMS_ITEM_SUPP_CTRY_DIM ICL_RMS_ITEM_SUPP_MANU_CTRY ICL_RMS_ITEM_SUPP_UOM ICL_RMS_ITEM_TICKET ICL_RMS_RELATED_ITEM ICL_RMS_RELATED_ITEM |
V_RMS_SIM_ITEM_MASTER V_RMS_SIM_ITEM_MASTER_CFA_EXT V_RMS_SIM_ITEM_MASTER_TL V_RMS_SIM_ITEM_IMAGE V_RMS_SIM_ITEM_SUPPLIER V_RMS_SIM_ITEM_SUPP_CFA_EXT V_RMS_SIM_ITEM_SUPP_COUNTRY V_RMS_SIM_ITEM_SUPP_CTRY_DIM V_RMS_SIM_ITEM_SUPP_MANU_CTRY V_RMS_SIM_ITEM_SUPP_UOM V_RMS_SIM_RELATED_ITEM_DETAIL V_RMS_SIM_RELATED_ITEM_HEAD V_RMS_SIM_PACKITEM V_RMS_SIM_RELATED_ITEM_HEAD V_RMS_SIM_RELATED_ITEM_DETAIL |
MPS_STAGED_MESSAGE |
| Merchandise Hierarchy |
ICL_RMS_DEPS ICL_RMS_CLASS ICL_RMS_SUBCLASS |
V_RMS_SIM_MERCH_HIER | MPS_STAGED_MESSAGE |
| Partners | ICL_RMS_PARTNER | V_RMS_SIM_EXTERNAL_FINISHER | MPS_STAGED_MESSAGE |
| Price Changes | RPM_ICL_PRICE_EVENT_PAYLOAD | RPM_SIM_PRICE_CHANGE_V |
MPS_STAGED_MESSAGE ICLS_PRICE_CHANGE |
| Price History | NONE | V_RMS_SIM_PRICE_HIST |
MPS_STAGED_MESSAGE ICLS_CLEARANCE |
| Purchase Orders | ICL_RMS_ORDER |
V_RMS_SIM_ORDHEAD V_RMS_SIM_ORDHEAD_CFA_EXT V_RMS_SIM_ORDLOC V_RMS_SIM_ORDLOC_CFA_EXT |
MPS_STAGED_MESSAGE |
| Receiver Unit Adjustments | ICL_RMS_RCV_UNIT_ADJ | V_RMS_SIM_RCV_UNIT_ADJ | MPS_STAGED_MESSAGE |
| Return to Vendor Requests | ICL_RMS_RTV |
V_RMS_SIM_RTV_HEAD V_RMS_SIM_RTV_DETAIL V_RMS_SIM_RTV_HEAD_CFA_EXT |
MPS_STAGED_MESSAGE |
| Stores | ICL_RMS_STORE | V_RMS_SIM_STORE | MPS_STAGED_MESSAGE |
| Store Inventory | V_RMS_SIM_STORE_ITEM_SOH | ||
| Transfers | ICL_RMS_TRANSFER |
V_RMS_SIM_TSFDETAIL V_RMS_SIM_TSFHEAD V_RMS_SIM_TSFHEAD_CFA_EXT V_RMS_SIM_TSFZONE V_RMS_SIM_ORDCUST_DETAIL |
MPS_STAGED_MESSAGE |
| UOM Classes and Conversion |
V_RMS_SIM_UOM_CLASS V_RMS_SIM_UOM_CONVERSION |
||
| User Defined Attributes |
ICL_RMS_UDA ICL_RMS_UDA_ITEM_DATE ICL_RMS_UDA_ITEM_FF ICL_RMS_UDA_ITEM_LOV |
V_RMS_SIM_UDA V_RMS_SIM_UDA_ITEM_DATE V_RMS_SIM_UDA_ITEM_FF V_RMS_SIM_UDA_ITEM_LOV V_RMS_SIM_UDA_VALUES |
MPS_STAGED_MESSAGE |
| Vendors | ICL_RMS_SUPPLIER |
V_RMS_SIM_SUPS V_RMS_SIM_SUPS_CFA_EXT V_RMS_SIM_PARTNER_ORG_UNIT |
MPS_STAGED_MESSAGE |
| Warehouses | ICL_RMS_WH | V_RMS_SIM_WH | MPS_STAGED_MESSAGE |