XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvReqItem 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 |
item |
varchar225 |
1 |
1 |
Unique alphanumeric value that identifies the item to be requested. |
ITEM_REQUEST_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
the unique identifier of the item that is being requested. |
qty_rqst |
number12_4 |
1 |
1 |
The quantity for the item being requested. This field is stored in the standard unit of measure. |
ITEM_REQUEST_LINE_ITEM |
QUANTITY |
NUMBER |
20,4 |
No |
the quantity of this item that is being requested in units. |
uop |
varchar26 |
1 |
1 |
Unit of Purchase - used for conversion, since NEED_QTY is being stored in the standard unit of measure. |
n/a |
n/a |
null |
null |
Yes |
Unit of Purchase. Used for conversion. |
need_date |
xs:dateTime |
1 |
1 |
The date that the store needs the item by. |
ITEM_REQUEST |
REQUESTED_DELIVERY_DATE |
DATE |
null |
No |
the date the user would like the item delivered to the store by. |
delivery_slot_id |
varchar215 |
0 |
1 |
Specifies when the store requested quantity is needed at the store. |
DELIVERY_SLOT, ITEM_REQUEST |
ID |
VARCHAR2 |
15 |
Yes |
delivery slot id |