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