XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItmRqstDesc 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 |
request_id |
number12 |
1 |
1 |
SIM internal identifier |
ITEM_REQUEST |
ID |
NUMBER |
12,0 |
Yes |
the unique identifier of item request. this is generated by the system. |
store_id |
number10 |
1 |
1 |
Store identifier |
ITEM_REQUEST |
STORE_ID |
NUMBER |
10,0 |
Yes |
the unique identifier of the store that is requesting the items. |
user_name |
varchar2128 |
1 |
1 |
User that last modified the request |
ITEM_REQUEST |
CREATE_USER |
VARCHAR2 |
128 |
Yes |
The create user name. |
comments |
varchar22000 |
0 |
1 |
Comments |
ITEM_REQUEST |
COMMENTS |
VARCHAR2 |
2000 |
No |
any comments as defined by the user. |
delivery_date |
xs:dateTime |
0 |
1 |
Delivery date in GMT |
ITEM_REQUEST |
REQUESTED_DELIVERY_DATE |
DATE |
Fill column length. |
No |
the date the user would like the item delivered to the store by. |
expiration_date |
xs:dateTime |
0 |
1 |
Expiration date in GMT |
ITEM_REQUEST |
EXPIRATION_DATE |
DATE |
Fill column length. |
No |
the date the item request expires. this cannot be specified in the item request and is only populated through the batch process when a days before expiration value is specified in the product group. |
process_date |
xs:dateTime |
0 |
1 |
Process date in GMT |
ITEM_REQUEST |
PROCESS_DATE |
DATE |
Fill column length. |
No |
the date that the item request is requested or cancelled. |
create_date |
xs:dateTime |
1 |
1 |
Creation date in GMT |
ITEM_REQUEST |
CREATE_DATE_TIME |
DATE |
Fill column length. |
Yes |
the date and time stamp of when the item request was created. |
status |
itm_rqst_status |
1 |
1 |
Current status Valid values are PENDING, COMPLETED, CANCELED, UNKNOWN, NO_VALUE. |
ITEM_REQUEST |
STATUS |
NUMBER |
2,0 |
Yes |
the status of the item request. 1 - pending 2 - completed 4 - cancelled |
timeslot_id |
varchar215 |
0 |
1 |
Unique timeslot identifier |
ITEM_REQUEST |
DELIVERY_SLOT_ID |
VARCHAR2 |
15 |
No |
delivery slot id |
schedule_description |
varchar2250 |
0 |
1 |
Schedule description |
ITEM_REQUEST |
SCHEDULE_DESCRIPTION |
VARCHAR2 |
250 |
No |
for item lists created via a product group, this will hold the description that was assigned to the product group when it was scheduled. |
ItmRqstItm
|
*
|
1
|
1000
|
Collection of item request line items
|
|
|
|
|
|
|