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 BDI) |
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 |
Fill this description. |
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 |
Fill this description. |
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 |
Fill this description. |
channel_id |
number4 |
0 |
1 |
Channel identifier of the warehouse. If the location is store, channel will be blank. If the location is warehouse, this is optional based on the input criteria. |
STORE or WH |
CHANNEL_ID |
RSB |
4 |
Yes |
Fill this description. |
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 |
Fill this description. |
unit_of_measure |
varchar24 |
1 |
1 |
Contains the unit of measure for available quantity. |
ITEM_MASTER |
STANDARD_UOM |
RSB |
4 |
Yes |
Fill this description. |
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 |
Fill this description. |
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 |
Fill this description. |
Dist:DistanceDesc
|
*
|
0
|
1
|
Gives the distance of the location from the center of Search Area.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|