XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvAvailDesc in ROB application. |
ROB's Table Name |
ROB's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
ROB's Column Length |
Is Column Required in ROB's API? |
ROB's API Description |
item |
varchar225 |
1 |
1 |
The item identifier. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
loc_type |
loc_type |
1 |
1 |
Type of location. Valid values are 'S' (store) and 'W' (warehouse). |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
available_qty |
number12_4 |
1 |
1 |
Contains the available quantity for the item/location in standard unit of measure. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
unit_of_measure |
varchar24 |
1 |
1 |
Contains the unit of measure for available quantity. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
available_date |
xs:dateTime |
0 |
1 |
The date at which this quantity of inventory is available. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
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. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
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
|