Retail Integration Mappings Report Release:15.0.0 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/PrGpSchHdrColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:PrGpSchHdrColDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrGpSchHdrColDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
PrGpSchHdrDesc:PrGpSchHdrDesc * 0 unbounded Collection of product group schedule headers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:PrGpSchHdrDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PrGpSchHdrDesc in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and RSL) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
schedule_id number8 0 1 Schedule unique identifier. PRODUCT_GROUP_SCHEDULE ID NUMBER 8,0 No the unique identifier of product group schedule. this is assigned by the system.
description varchar2250 0 1 Description of the schedule. PRODUCT_GROUP_SCHEDULE DESCRIPTION VARCHAR2 250 No the description of product the product group schedule.
status schedule_status 1 1 Schedule Status. Valid values are OPEN, CLOSED, UNKNOWN, NO_VALUE. PRODUCT_GROUP_SCHEDULE STATUS VARCHAR2 1 Yes the current status of the product group schedule. valid values: o - open c - closed
group_id number12 0 1 Unique identifier of product group associated with the schedule. PRODUCT_GROUP_SCHEDULE PRODUCT_GROUP_ID NUMBER 12,0 No the unique identifier of the product group that this schdule is for.
group_description varchar2100 0 1 Description of product group associated with the schedule. PRODUCT_GROUP DESCRIPTION VARCHAR2 100 No the description of product group which is assigned by the user.
group_type schedule_group_type 1 1 Type of product group associated with the schedule. Valid values are STOCK_COUNT_UNIT, STOCK_COUNT_UNIT_AMOUNT, STOCK_COUNT_PROBLEM_LINE, STOCK_COUNT_WASTAGE, STOCK_COUNT_RMS_SYNC, SHELF_REPLENISHMENT, ITEM_REQUEST, AUTO_TICKET_PRINT, UNKNOWN, NO_VALUE. PRODUCT_GROUP TYPE NUMBER 3,0 Yes "Indicates the type of product group that was created. 1 - Unit, 2 - Unit and Amount, 3 - Problem Line, 4 - Wastage, 5 - RMS Inventory Sync, 6 - Shelf Replenishment, 7 - Item Request"
store_id_col number10 0 1000 Collection of store identifiers. PRODUCT_GROUP_SCHEDULE STORE_ID NUMBER 10,0 Yes the unique identifier of the store that belongs to this product group schedule.
store_count number10 0 1 Count of store for which the schedule was generated. PRODUCT_GROUP_SCHED_STORE STORE_ID NUMBER No Count of the stores for which schedule is created