XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItmRqstCriVo 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 |
store_id |
number10 |
1 |
1 |
Return only item requests for this store. |
ITEM_REQUEST |
STORE_ID |
NUMBER |
10,0 |
Yes |
the unique identifier of the store that is requesting the items. |
user_name |
varchar2128 |
0 |
1 |
Return only item requests created by this user. |
ITEM_REQUEST |
CREATE_USER |
VARCHAR2 |
128 |
No |
The create user name. |
status |
itm_rqst_status |
1 |
1 |
Return only item requests in this 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 |
item_id |
varchar225 |
0 |
1 |
Return only item requests containing this item |
ITEM_REQUEST_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
No |
the unique identifier of the item that is being requested. |
department_id |
number12 |
0 |
1 |
Return only item requests for this department |
ITEM_REQUEST |
DEPARTMENT_ID |
VARCHAR2 |
128 |
No |
the unique identifier of the department that the items on the request belong to. if the items on the request belong to more than 1 department this will only hold 1 value. in the display the user will see this value followed by a +. |
item_request_id |
number12 |
0 |
1 |
Return only item request with this identifier. This will limit responses to a single item request. |
ITEM_REQUEST |
ID |
NUMBER |
12,0 |
No |
the unique identifier of item request. this is generated by the system. |
timeslot_id |
varchar215 |
0 |
1 |
Return only item requests that deliveries scheduled in this timeslot. |
ITEM_REQUEST |
DELIVERY_SLOT_ID |
VARCHAR2 |
15 |
No |
delivery slot id |
from_expiration_date |
xs:dateTime |
0 |
1 |
Return only item requests that expire after this GMT date. |
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. |
to_expiration_date |
xs:dateTime |
0 |
1 |
Return only items requests that expire before this GMT date. |
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. |
from_create_date |
xs:dateTime |
0 |
1 |
Return only item requests that were created after this GMT date. |
ITEM_REQUEST |
REQUESTED_DELIVERY_DATE |
DATE |
Fill column length. |
No |
the date and time stamp of when the item request was created. |
to_create_date |
xs:dateTime |
0 |
1 |
Return only item requests that were created before this GMT date. |
ITEM_REQUEST |
REQUESTED_DELIVERY_DATE |
DATE |
Fill column length. |
No |
the date and time stamp of when the item request was created. |