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 BDI) |
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 |
Fill column length. |
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 |
Fill column length. |
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. |