XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvAvailDesc 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 |
The item identifier. |
ITEM_LOC_SOH |
ITEM |
RSB |
25 |
Yes |
|
location |
number10 |
1 |
1 |
Location where the item is to be found. This field may contain a store or a warehouse. |
ITEM_LOC_SOH |
LOC |
RSB |
10 |
Yes |
|
loc_type |
loc_type |
1 |
1 |
Type of location. Valid values are 'S' (store) and 'W' (warehouse). |
ITEM_LOC_SOH |
LOC_TYPE |
RSB |
1 |
Yes |
|
channel_id |
number4 |
0 |
1 |
Channel identifier of the warehouse. If the location is store, channel will be blank. If the location is WH, this is optional based on the input criteria. |
STORE or WH |
CHANNEL_ID |
RSB |
4 |
Yes |
|
available_qty |
number12_4 |
1 |
1 |
Contains the available quantity for the item/location in standard unit of measure. |
ITEM_LOC_SOH |
STOCK_ON_HAND - TSF_RESERVED_QTY + CUSTOMER_RESV + RTV_QTY + NON_SELLABLE_QTY |
RSB |
12 |
Yes |
|
unit_of_measure |
varchar24 |
1 |
1 |
Contains the unit of measure for available quantity. |
ITEM_MASTER |
STANDARD_UOM |
RSB |
4 |
Yes |
|
available_date |
xs:dateTime |
0 |
1 |
The date at which this quantity of inventory is available. |
N/A |
N/A |
N/A |
N/A |
No |
|
pack_calculate_ind |
pack_calculate_ind |
0 |
1 |
Valid for pack item only. Indicate if the pack item available quantity is actual held value ('N') or calculated using pack component ('Y'). Calculated pack quantity should be treated as an estimate value. |
N/A |
N/A |
RSB |
N/A |
Yes |
|