A Appendix - Interface Details
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 |
SIOCS to Merchandising
| Entity | Merchandising Import Table | Merchandising Consume Job |
|---|---|---|
| Direct Store Delivery Receipts |
SIM_RMS_DSD_RECEIPT SIM_RMS_DSD_RECEIPT_DETAIL |
SIM_RMS_IMPORT_DSD_RECEIPT_ADHOC_JOB |
| Fiscal Documents |
SIM_RMS_FDG_DTL SIM_RMS_FDG_ETT SIM_RMS_FDG_EXT SIM_RMS_FDG_HDR SIM_RMS_FDG_REF SIM_RMS_FDG_TEXT |
SIM_RMS_FDG_ADHOC_JOB
|
| Inventory Adjustments | SIM_RMS_INV_ADJ | SIM_RMS_IMPORT_INV_ADJ_ADHOC_JOB |
| Inventory Requests |
SIM_RMS_INVENTORY_REQUEST SIM_RMS_INVENTORY_REQUEST_DETAIL |
SIM_RMS_IMPORT_INVENTORY_REQUEST_ADHOC_JOB |
| Outbound ASNs |
SIM_RMS_ASNOUT SIM_RMS_ASNOUT_DISTRO SIM_RMS_ASNOUT_CARTON SIM_RMS_ASNOUT_ITEM |
SIM_RMS_IMPORT_ASNOUT_ADHOC_JOB |
| PO Receipts |
SIM_RMS_PO_RECEIPT SIM_RMS_PO_RECEIPT_DETAIL |
SIM_RMS_IMPORT_PO_RECEIPT_ADHOC_JOB |
| Return to Vendor |
SIM_RMS_RTV SIM_RMS_RTV_DETAIL SIM_RMS_RTV_CFA |
SIM_RMS_IMPORT_RTV_ADHOC_JOB |
| Stock Order Receipts |
SIM_RMS_STOCK_ORDER_RECEIPT SIM_RMS_STOCK_ORDER_RECEIPT_DETAIL |
SIM_RMS_IMPORT_STOCK_ORDER_RECEIPT_ADHOC_JOB |
| Stock Order Status |
SIM_RMS_STOCK_ORDER_STATUS SIM_RMS_STOCK_ORDER_STATUS_DETAIL |
SIM_RMS_IMPORT_STOCK_ORDER_STATUS_ADHOC_JOB |
| Stock Count Results |
SIM_RMS_STOCK_COUNT_RESULT SIM_RMS_STOCK_COUNT_RESULT_DETAIL |
SIM_RMS_IMPORT_STOCK_COUNT_RESULT_JOB SIM_RMS_IMPORT_STOCK_COUNT_RESULT_CYCLE_JOB |
| Stock Count Schedule |
SIM_RMS_STOCK_COUNT_SCHEDULE SIM_RMS_STOCK_COUNT_SCHEDULE_STORE SIM_RMS_STOCK_COUNT_SCHEDULE_PROC |
SIM_RMS_IMPORT_STOCK_COUNT_SCHEDULE_ADHOC_JOB |
The Merchandising import jobs should be scheduled using POM scheduler to run at regular frequency throughout the day. To avoid data conflicts, the import jobs related to inventory will not process data during the Merchandising nightly batch duration.
In addition to the specific entity jobs mentioned in the table above, the following two jobs purge history tables and clean up old ignored errors:
- SIM_RMS_PURGE_JOB
- SIM_RMS_HISTORY_PURGE_JOB