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/ProdGrpHdrColDesc/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:ProdGrpHdrColDesc 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 ProdGrpHdrColDesc 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
ProdGrpHdrDesc:ProdGrpHdrDesc * 0 unbounded Collection of product group 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:ProdGrpHdrDesc 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 ProdGrpHdrDesc 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
product_group_id number10 1 1 Product group identifier internal to SIM. PRODUCT_GROUP ID NUMBER 12,0 Yes unique identifying number for the product group within the system. this number is generated by the system when a new product group is created.
group_type group_type 1 1 Product group type. 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
description varchar2250 1 1 A full description of the product group. PRODUCT_GROUP DESCRIPTION VARCHAR2 100 Yes the description of product group which is assigned by the user.
store_id number10 0 1 Unique store identifier. PRODUCT_GROUP STORE_ID NUMBER 10,0 No the unique identifier of the store that this product group is for. if the all store option was selected when creating the product group this value will be blank.