XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvReqItem in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's API Description |
item |
varchar225 |
1 |
1 |
Unique alphanumeric value that identifies the item to be requested. |
store_orders |
item |
varchar2 |
25 |
Yes |
Unique alphanumeric value that identifies the item to be requested. |
qty_rqst |
number12_4 |
1 |
1 |
The quantity for the item being requested. This field is stored in the standard unit of measure. |
store_orders |
need_qty |
number |
12 |
Yes |
The quantity for the item being requested. This field is stored in the standard unit of measure. |
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 |
n/a |
n/a |
Yes |
Unit of Purchase. Used for conversion, because NEED_QTY is stored in the standard unit of measure. |
need_date |
xs:dateTime |
1 |
1 |
The date that the store needs the item by. |
store_orders |
need_date |
RIBDate |
Fill column length. |
Yes |
The date that the store needs the item by. |
delivery_slot_id |
varchar215 |
0 |
1 |
Specifies when the store requested quantity is needed at the store. |
store_orders |
delivery_slot_id |
varchar2 |
15 |
No |
Specifies when the store requested quantity is needed at the store. |