A Appendix – Interface Details

Merchandising to SIOCS

Interface	Change Log Table	Merchandising View/s	SIOCS Staging Table	SIOCS DCS Work Type
Address	ICL_RMS_ADDR	V_RMS_SIM_ADDR	MPS_STAGED_MESSAGE	Address
Allocations	ICL_RMS_ALLOC	V_RMS_SIM_ALLOC_HEADER V_RMS_SIM_ALLOC_DETAIL	MPS_STAGED_MESSAGE	Allocation
ASNs	ICL_RMS_SHIPMENT	V_RMS_SIM_SHIPMENT V_RMS_SIM_SHIPSKU V_RMS_SIM_SHIPSKU_UIN	MPS_STAGED_MESSAGE	Shipment
ASN-IN	ICL_RMS_ASNIN	V_RMS_SIM_ASNIN_CTN V_RMS_SIM_ASNIN_DESC V_RMS_SIM_ASNIN_ITEM V_RMS_SIM_ASNIN_PO V_RMS_SIM_ASNIN_UIN	MPS_STAGED_MESSAGE	VendorDelivery
Fiscal Document Based ASNIN	ICL_RFM_ASNIN	V_RFM_ASNIN_CTN V_RFM_ASNIN_DESC V_RFM_ASNIN_ITEM V_RFM_ASNIN_PO V_RFM_ASNIN_UIN	MPS_STAGED_MESSAGE	FiscalShipment
Fiscal Documents	ICL_RMS_FDG		MPS_STAGED_MESSAGE	FiscalDocument
Clearances and Clearance Resets	RPM_ICL_PRICE_EVENT_PAYLOAD	RPM_SIM_CLEARANCE_V	MPS_STAGED_MESSAGE ICLS_CLEARANCE	ItemPrice
Codes		V_RMS_SIM_CODE_HEAD V_RMS_SIM_CODE_DETAIL		N/A
Delivery Slots		V_RMS_SIM_DELIVERY_SLOT		N/A
Differentiator Types	ICL_RMS_DIFF_TYPE	V_RMS_SIM_DIFF_TYPE	MPS_STAGED_MESSAGE	DiffType
Differentiators	ICL_RMS_DIFF_IDS	V_RMS_SIM_DIFF	MPS_STAGED_MESSAGE	Diff
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	ItemLocation ItemReplenishment
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	Item Related Item ItemImage ItemTicket SupplierItemCountry SupplierItemCountryDim SupplierItemCountryManufacture SupplierItemUom
Merchandise Hierarchy	ICL_RMS_DEPS ICL_RMS_CLASS ICL_RMS_SUBCLASS	V_RMS_SIM_MERCH_HIER	MPS_STAGED_MESSAGE	Department Class Subclass
Partners	ICL_RMS_PARTNER	V_RMS_SIM_EXTERNAL_FINISHER	MPS_STAGED_MESSAGE	Partner
Price Changes	RPM_ICL_PRICE_EVENT_PAYLOAD	RPM_SIM_PRICE_CHANGE_V	MPS_STAGED_MESSAGE ICLS_PRICE_CHANGE	ItemPrice
Price History	NONE	V_RMS_SIM_PRICE_HIST	MPS_STAGED_MESSAGE ICLS_CLEARANCE	N/A
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	PurchaseOrder
Receiver Unit Adjustments	ICL_RMS_RCV_UNIT_ADJ	V_RMS_SIM_RCV_UNIT_ADJ	MPS_STAGED_MESSAGE	ReceiverUnitAdjustment
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	VendorReturn
Stores	ICL_RMS_STORE	V_RMS_SIM_STORE	MPS_STAGED_MESSAGE	Store
Store Inventory		V_RMS_SIM_STORE_ITEM_SOH		N/A
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	Transfer
UOM Classes and Conversion		V_RMS_SIM_UOM_CLASS V_RMS_SIM_UOM_CONVERSION		N/A
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	Uda
Vendors	ICL_RMS_SUPPLIER	V_RMS_SIM_SUPS V_RMS_SIM_SUPS_CFA_EXT V_RMS_SIM_PARTNER_ORG_UNIT	MPS_STAGED_MESSAGE	Supplier
Warehouses	ICL_RMS_WH	V_RMS_SIM_WH	MPS_STAGED_MESSAGE	Warehouse

Sales Audit to SIOCS

Interface	Change Log Table	Merchandising View/s	SIOCS Staging Table	SIOCS DCS Work Type
Audit Revision to Sales/Return Transaction	ICL_SA_REVISED_SALES	V_SA_SIM_REVISED_SALES_HEAD V_SA_SIM_REVISED_SALES_DETAIL	MPS_STAGED_MESSAGE	SalesAudit

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
Store Order Review	SIM_RMS_STORE_ORDER_REVIEW SIM_RMS_STORE_ORDER_REVIEW_ITEM	SIM_RMS_IMPORT_STORE_ORDER_ REVIEW_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. The alternate approach is to use Merchandising Background Engine. Refer to Appendix – SIOCS to Merchandising Data Processing Using Background Engine for details.

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:

1. SIM_RMS_PURGE_JOB
2. SIM_RMS_HISTORY_PURGE_JOB