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

XML-Schema Name:PrGpSchModVo 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 PrGpSchModVo 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. If this exists, the schedule will be updated. If no id is included, the schedule will be created. PRODUCT_GROUP_SCHEDULE ID NUMBER 8,0 No the unique identifier of product group schedule. this is assigned by the system.
description varchar2250 1 1 Description of the schedule. PRODUCT_GROUP_SCHEDULE DESCRIPTION VARCHAR2 250 Yes the description of product the product group schdule.
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. This value cannot be altered on an update. 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. This value cannot be altered on an update. 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_SCHED_STORE STORE_ID NUMBER 10,0 No Collection of unique identifier of the store that belongs to this product group schedule.
ScheduleMod * 0 1 Schedule Details.

XML-Schema Name:ScheduleMod 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 ScheduleMod 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_type schedule_type 1 1 Schedule Type. Valid values are DAILY, DAILY_BY_WEEKDAY, WEEKLY, MONTHLY_BY_DAY, MONTHLY_BY_WEEK, YEARLY_BY_DAY, YEARLY_BY_WEEK, UNKNOWN, NO_VALUE. PRODUCT_GROUP_SCHEDULE TYPE NUMBER 4,0 Yes the frequency that the schedule should be run. valid values: 1 a daily schedule. 2 a daily-by-weekday schedule. 3 a weekly schedule. 4 a monthly-by-day schedule. 5 a monthly-by-week schedule. 6 a yearly-by-day schedule. 7 a yearly-by-week schedule.
start_date xs:dateTime 1 1 Schedule Start Date. PRODUCT_GROUP_SCHEDULE START_DATE DATE Yes the beginning date of the time span which the schedule covers.
end_date xs:dateTime 1 1 Schedule End Date. PRODUCT_GROUP_SCHEDULE END_DATE DATE Yes the ending date of the time span which the schedule covers.
daily_frequency number6 0 1 Daily frequency of schedule. Value expected should be in range of 1 to 999999. PRODUCT_GROUP_SCHEDULE PARAMETER_1 NUMBER 12,0 No the first schedule parameter. the value of this parameter depends on type: 1 this parameter is the daily frequency. 2 unused (0). 3 this parameter is the weekly frequency. 4 this parameter is the monthly frequency. 5 this parameter is the monthly frequency. 6 this parameter is the month in the range of java.util.calendar.january to java.util.calendar.december. 7 this parameter is the month in the range of java.util.calendar.january to java.util.calendar.december.
weekly_frequency number4 0 1 Weekly frequency of schedule. Value expected should be in range of 1 to 9999. PRODUCT_GROUP_SCHEDULE PARAMETER_2 NUMBER 12,0 No the second schedule parameter. the value of this parameter depends on type: 1 unused (0). 2 unused (0). 3 this parameter is the days of the week bitmap. this bitmap is a big-endian representation of the days of the week to schedule stock counts. the value is a bitwise-or where the bits in the range from java.util.calendar.sunday to java.util.calendar.saturday are: java.util.calendar.sunday whether this daily-by-weekday schedule is scheduled for sundays. java.util.calendar.monday whether this daily-by-weekday schedule is scheduled for mondays. java.util.calendar.tuesday whether this daily-by-weekday schedule is scheduled for tuesdays. java.util.calendar.wednesday whether this daily-by-weekday schedule is scheduled for wednesdays. java.util.calendar.thursday whether this daily-by-weekday schedule is scheduled for thursdays. java.util.calendar.friday whether this daily-by-weekday schedule is scheduled for fridays. java.util.calendar.saturday whether this daily-by-weekday schedule is scheduled for saturdays. 4 this parameter is the day of the month in the range of 1 to 31. 5 this parameter is the number of the week in the month in the range of 1 to 5. 6 this parameter is the day of the month in the range of 1 to 31. 7 this parameter is the number of the week in the month in the range of 1 to 5.
monthly_frequency number5 0 1 Monthly frequency of schedule. Value expected should be in range of 1 to 99999. PRODUCT_GROUP_SCHEDULE PARAMETER_1 NUMBER 12,0 No the first schedule parameter. the value of this parameter depends on type: 1 this parameter is the daily frequency. 2 unused (0). 3 this parameter is the weekly frequency. 4 this parameter is the monthly frequency. 5 this parameter is the monthly frequency. 6 this parameter is the month in the range of java.util.calendar.january to java.util.calendar.december. 7 this parameter is the month in the range of java.util.calendar.january to java.util.calendar.december.
DayOfWeekMod * 0 7 Collection of days of week. Single or multiple values expected depending on schedule type selected. Each value denoted a day of the week.
day_of_month number1 0 1 Day of month. Value expected should be in range of 1-31 as per the calendar dates for the month. PRODUCT_GROUP_SCHEDULE PARAMETER_2 NUMBER 12,0 No the second schedule parameter. the value of this parameter depends on type: 1 unused (0). 2 unused (0). 3 this parameter is the days of the week bitmap. this bitmap is a big-endian representation of the days of the week to schedule stock counts. the value is a bitwise-or where the bits in the range from java.util.calendar.sunday to java.util.calendar.saturday are: java.util.calendar.sunday whether this daily-by-weekday schedule is scheduled for sundays. java.util.calendar.monday whether this daily-by-weekday schedule is scheduled for mondays. java.util.calendar.tuesday whether this daily-by-weekday schedule is scheduled for tuesdays. java.util.calendar.wednesday whether this daily-by-weekday schedule is scheduled for wednesdays. java.util.calendar.thursday whether this daily-by-weekday schedule is scheduled for thursdays. java.util.calendar.friday whether this daily-by-weekday schedule is scheduled for fridays. java.util.calendar.saturday whether this daily-by-weekday schedule is scheduled for saturdays. 4 this parameter is the day of the month in the range of 1 to 31. 5 this parameter is the number of the week in the month in the range of 1 to 5. 6 this parameter is the day of the month in the range of 1 to 31. 7 this parameter is the number of the week in the month in the range of 1 to 5.
week_of_month number1 0 1 Week of month. Value expected should be in range of 1 to 5. PRODUCT_GROUP_SCHEDULE PARAMETER_2 NUMBER 12,0 No the second schedule parameter. the value of this parameter depends on type: 1 unused (0). 2 unused (0). 3 this parameter is the days of the week bitmap. this bitmap is a big-endian representation of the days of the week to schedule stock counts. the value is a bitwise-or where the bits in the range from java.util.calendar.sunday to java.util.calendar.saturday are: java.util.calendar.sunday whether this daily-by-weekday schedule is scheduled for sundays. java.util.calendar.monday whether this daily-by-weekday schedule is scheduled for mondays. java.util.calendar.tuesday whether this daily-by-weekday schedule is scheduled for tuesdays. java.util.calendar.wednesday whether this daily-by-weekday schedule is scheduled for wednesdays. java.util.calendar.thursday whether this daily-by-weekday schedule is scheduled for thursdays. java.util.calendar.friday whether this daily-by-weekday schedule is scheduled for fridays. java.util.calendar.saturday whether this daily-by-weekday schedule is scheduled for saturdays. 4 this parameter is the day of the month in the range of 1 to 31. 5 this parameter is the number of the week in the month in the range of 1 to 5. 6 this parameter is the day of the month in the range of 1 to 31. 7 this parameter is the number of the week in the month in the range of 1 to 5.
month_of_year month_of_year 1 1 Month of year. Each value denotes a month of the year. Valid values are JANUARY, FEBRUARY, MARCH, APRIL, MAY, JUNE, JULY, AUGUST, SEPTEMBER, OCTOBER, NOVEMBER, DECEMBER, UNKNOWN, NO_VALUE. PRODUCT_GROUP_SCHEDULE PARAMETER_1 NUMBER 12,0 Yes the first schedule parameter. the value of this parameter depends on type: 1 this parameter is the daily frequency. 2 unused (0). 3 this parameter is the weekly frequency. 4 this parameter is the monthly frequency. 5 this parameter is the monthly frequency. 6 this parameter is the month in the range of java.util.calendar.january to java.util.calendar.december. 7 this parameter is the month in the range of java.util.calendar.january to java.util.calendar.december.

XML-Schema Name:DayOfWeekMod 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 DayOfWeekMod 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
day_of_week days_of_week 1 1 Day of week Valid values are SUNDAY, MONDAY, TUESDAY, WEDNESDAY, THURSDAY, FRIDAY, SATURDAY, UNKNOWN, NO_VALUE. PRODUCT_GROUP_SCHEDULE PARAMETER_3 NUMBER 12,0 Yes the third schedule parameter. the value of this parameter depends on type: 1 unused (0). 2 unused (0). 3 unused (0). 4 unused (0). 5 this parameter is the day of the week in the range of java.util.calendar.sunday to java.util.calendar.saturday. 6 unused (0). 7 this parameter is the day of the week in the range of java.util.calendar.sunday to java.util.calendar.saturday.