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

XML-Schema Name:ProdGrpDesc 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 ProdGrpDesc 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 Includes only product group with this 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 Description. PRODUCT_GROUP DESCRIPTION VARCHAR2 100 Yes the description of product group which is assigned by the user.
store_id number10 0 1 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.
status group_status 1 1 Status of the product group. Valid values are ACTIVE, CANCELED. PRODUCT_GROUP STATUS VARCHAR2 1 Yes the current status of the product group. valid values 0 - active 1 - canceled.
uom_mode uom_mode 1 1 Current unit of measure being used for this group. Valid values are STANDARD, CASES, PREFERRED. PRODUCT_GROUP UNIT_OF_MEASURE_TYPE NUMBER 2,0 Yes for pick list type product groups the user must define the unit of measure for the pick. Valid values 1 - standard, 2 - cases, 3- preferred
variance_count number12 0 1 Product group allowed variance count. PRODUCT_GROUP VARIANCE_COUNT NUMBER 12,4 No this field is used by unit, unit and amount, problem line and wastage type product groups. the number of units in the standard uom for an item to be considered discrepant, when comparing the system total soh inventory level with the quantity entered on the stock count by the user. an item is discrepant if it deviates + or ? over or equal to the variance count.
variance_percent number12_2 0 1 Product group allowed variance percent. PRODUCT_GROUP VARIANCE_PERCENT NUMBER 12,4 No this field is used by unit, unit and amount, problem line and wastage type product groups. the percentage of units counted for an item to be considered discrepant. the system will compare the soh inventory level with the quantity entered on the stock count by the user. an item is discrepant if it deviates + or ? over or equal to the variance %.
variance_value number12_2 0 1 Product group allowed variance value. PRODUCT_GROUP VARIANCE_VALUE NUMBER 12,4 No this field is only applicable for unit and amount type product groups. the variance value field allows the user to enter the threshold in terms of a dollar amount for an item to be considered discrepant for unit and amount stock counts. this will be a cash amount that will be compared to the number of discrepant units x unit retail of the goods. if the calculated value exceeds the variance value, then the item would be considered discrepant during the stock counting process. an item is discrepant if it deviates + or ? over or equal to the variance value.
counting_method counting_method 1 1 Counting method used only for a stock count product group. Valid values are GUIDED, UNGUIDED, THIRD_PARTY, AUTO, UNKNOWN, NO_VALUE. PRODUCT_GROUP COUNTING_METHOD NUMBER 2,0 Yes Stock counting method. 1 - Guided, 2 - Unguided, 3 - Third Party, 4 - Auto
breakdown_type breakdown_type 1 1 Breakdown type used only for the stock count product group. Valid values are DEPARTMENT, CLASS, SUBCLASS, LOCATION, NONE, UNKNOWN, NO_VALUE. PRODUCT_GROUP BREAKDOWN_TYPE NUMBER 2,0 Yes The breakdown types for a product group that represents a stock count. 1 - Department, 2 - Class, 3 - Subclass, 4 - Location, 5 - None
diff_type diff_type 1 1 Differentiator type used only for a shelf replenishment type product group. Valid values are DIFF1, DIFF2, DIFF3, DIFF4, UNKNOWN, NO_VALUE. PRODUCT_GROUP DIFF_TYPE NUMBER 2,0 Yes Diff type for display list shelf replenishment type. 0 - Diff1, 1 - Diff2, 2 - Diff3, 3 - Diff4.
all_items xs:boolean 1 1 True if the product group is for all items, false otherwise. PRODUCT_GROUP ALL_ITEM VARCHAR2 1 No all items ex - y or n
recount_active xs:boolean 1 1 True if a recount is required for this product group, false otherwise. Used only for stock counts. PRODUCT_GROUP DO_RECOUNT VARCHAR2 1 No this flag indicates if the stock count should be recounted is discrepancies are found. this flag is only valid for product groups wtih a type of unit, unit and amount or problem line. valid values are y - yes, a recount should be performed n - no, a recount should not be performed
auto_authorize xs:boolean 1 1 True if the stock count should be automatically authorized, false otherwise. Used only for stock counts. PRODUCT_GROUP AUTO_AUTHORIZE VARCHAR2 1 No auto authorize. ex Y and N
pick_less_suggested xs:boolean 1 1 Indicates problem line should check action pick amount less than suggested amount, false otherwise. Used only for problem line stock counts. PRODUCT_GROUP PICK_LESS_SUGGESTED VARCHAR2 1 Yes pick list less than suggested. ex: pick_less_suggested y means include if pick list less than suggested pick_less_suggested n means exclude if pick list less than suggested Shelf replenish less than suggested.
shelf_repl_less_suggested xs:boolean 1 1 Indicates problem line should check action pick amount less than suggested amount, false otherwise. Used only for problem line stock counts. PRODUCT_GROUP REPL_LESS_SUGGESTED VARCHAR2 1 No Shelf replenish less than suggested.
negative_available xs:boolean 1 1 Indicates problem line should include negative available inventory, false otherwise. Used only for problem line stock counts. PRODUCT_GROUP REPL_NEGATIVE_AVAILABLE VARCHAR2 1 No pick list negative available. ex pick_negative_available y means include if pick list negative available
uin_discrepancy xs:boolean 1 1 Indicates problem line should include UIN discrepancies, false otherwise. Used only for problem line stock counts. PRODUCT_GROUP UIN_DISCREPANT VARCHAR2 1 No y or n. y indicates whether to write discrepancies to the problem line table.
include_active_items xs:boolean 1 1 True if the stock count should include active items, false otherwise. PRODUCT_GROUP ACTIVE_ITEMS VARCHAR2 1 No active items. ex y or n
include_inactive_items xs:boolean 1 1 True if the stock count should include inactive items, false otherwise. PRODUCT_GROUP INACTIVE_ITEMS VARCHAR2 1 No inactive items. ex y or n
include_discontinued_items xs:boolean 1 1 True if the stock count should include discontinued items, false otherwise. PRODUCT_GROUP DISCONTINUED_ITEMS VARCHAR2 1 No discontinued items. ex y or n
include_deleted_items xs:boolean 1 1 True if the stock count should include deleted items, false otherwise. PRODUCT_GROUP DELETED_ITEMS VARCHAR2 1 No deleted items. ex y or n
include_soh_zero xs:boolean 1 1 True if the stock count should include items whose stock on hand is zero, false otherwise. PRODUCT_GROUP SOH_ZERO VARCHAR2 1 No zero stock on hand. ex soh_zeor y means include if soh is zero soh_zero n means exclude if soh is zero
include_soh_less_than_zero xs:boolean 1 1 True if the stock count should include items whose stock on hand is less than zero, false otherwise. PRODUCT_GROUP SOH_NEGATIVE VARCHAR2 1 No negative stock on hand. ex soh_negative y means include if soh is negative soh_negative n means exclude if soh is negative
include_soh_greater_than_zero xs:boolean 1 1 True if the stock count should include items whose stock on hand is greater than zero, false otherwise. PRODUCT_GROUP SOH_POSITIVE VARCHAR2 1 No positive stock on hand. ex soh_positive y means include if soh is positive soh_positive n means exclude if soh is positive
auto_replenishment xs:boolean 1 1 True of the product group supports auto replenishment via batch, false otherwise. PRODUCT_GROUP AUTO_REPLENISHMENT VARCHAR2 1 No Indicates if the product group is eligible for auto replenishment through scheduled batch run
refresh_ticket_quantity xs:boolean 1 1 True if the ticket quantity to be refreshed to SOH, false otherwise. PRODUCT_GROUP REFRESH_TICKET_QUANTITY VARCHAR2 1 No refresh ticket quantity. ex y or n refresh ticket quantity. ex
days_to_expire_request number12 0 1 Days to expire automatically. Used only for item requests. PRODUCT_GROUP EXPIRATION_DAYS NUMBER 3,0 No this field is only used for item request type product groups. this number is used to determine the expiration date for the item request. this is an optional value for item request type product groups.
days_to_request_delivery number12 0 1 Days to request delivery after the creation of the item request. Used only for item requests. PRODUCT_GROUP REQUEST_DELIVERY_DAYS NUMBER 3,0 No this field is only used for item request type product groups. this number is used to determine the requested delivery date for the item request. this is an optional value for item request type product groups.
ProdGrpHrchy * 0 1000 Collection of product group hierarchies.
ProdGrpItm * 0 1000 Collection of item hierarchies.

XML-Schema Name:ProdGrpHrchy 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 ProdGrpHrchy 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
department_id number12 1 1 Department identifier PRODUCT_GROUP_HIERARCHY DEPARTMENT_ID NUMBER 12,0 No hierarchy department id
class_id number10 0 1 Class identifier. PRODUCT_GROUP_HIERARCHY CLASS_ID NUMBER 12,4 No hierarchy class id
subclass_id number10 0 1 Subclass identifier PRODUCT_GROUP_HIERARCHY SUBCLASS_ID NUMBER 12,0 No hierarchy subclass id
number_of_items number5 0 1 Subclass identifier 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:ProdGrpItm 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 ProdGrpItm 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
item_id varchar225 1 1 Item Identifier. PRODUCT_GROUP_ITEM ITEM_ID VARCHAR2 25 Yes unique identifying number for the item that is attached to the product group.
short_description varchar2250 0 1 Short Description. ITEM SHORT_DESCRIPTION VARCHAR2 255 Yes the textural description of the item and its characteristics.
long_description varchar2250 0 1 Long Description ITEM LONG_DESCRIPTION VARCHAR2 400 Yes long description of the item.
mdse_hierarchy_id varchar225 0 1 Hierarchy Identifier. ITEM_HIERARCHY ID NUMBER 12,0 No hierarchy id
department_id number10 0 1 Department Identifier. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
deparment_name varchar2100 0 1 Department Name. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
class_id number10 0 1 Merchandise hierarchy class identifier Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
class_name varchar2100 0 1 Merchandise hierarchy class name ITEM_HIERARCHY SUBCLASS_NAME VARCHAR2 360 No hierarchy subclass name
sub_class_id number10 0 1 Merchandise hierarchy subclass id ITEM CLASS_ID NUMBER 12,0 No hierarchy class id
sub_class_name varchar2100 0 1 Merchandise hierarchy subclass name Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
status item_status 1 1 Includes only item with this status. Valid values are NONE, ACTIVE, DISCONTINUED, INACTIVE, DELETED, AUTO_STOCKABLE, NON_RANGED. ITEM STATUS VARCHAR2 1 No the current status of the item. A - Active, C - Discountinued, I - Inactive, D - Deleted, Q - AutoStockable, N - Non-ranged
ranged xs:boolean 1 1 True if inventory exists at the criteria input store, false otherwise. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
sellable xs:boolean 1 1 Include only items with this SIM internal non-sellable quantity type identifier. ITEM SELLABLE VARCHAR2 1 No indicates if this item may be sold as a unit. valid values are: Y and N. this field is required by sim when using pack items.
store_order_repl_typ xs:boolean 1 1 True if this item is store order replenishment, false otherwise STORE_ITEM REPLENISHMENT_TYPE VARCHAR2 6 No contains the character code for the algorithm that will be used to calculate the recommended order quantity for the item location. valid values: so - store orders
type item_type 1 1 Includes only item with this type. Valid values are ITEM, CONSIGNMENT, CONCESSION, NON_INVENTORY, PACK_SIMPLE, PACK_COMPLEX, PACK_SIMPLE_BREAKABLE, PACK_COMPLEX_BREAKABLE. ITEM ITEM_TYPE VARCHAR2 1 No Indicates the type of item. Possible values are 0 - Item,5 - Consignment,10- Concession,12 - Non Inventory,15 - Simple Pack,20 - Complex Pack,25 - Simple Breakable Pack,30 - Complex Breakable Pack