XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for ItmRqstHdrDesc 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. |
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. |
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 |
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. |
department_id |
number12 |
1 |
1 |
SIM internal department identifier |
ITEM_REQUEST |
DEPARTMENT_ID |
VARCHAR2 |
128 |
Yes |
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_count |
number9 |
1 |
1 |
Number of line items on request |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |