XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for InvAvailDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
item |
varchar225 |
1 |
1 |
The item identifier. |
ITEM |
ID |
varchar2 |
25 |
Yes |
the retailers sku or unique item identifier for items sold or returned. this field is required by sim. |
location |
number10 |
1 |
1 |
Location where the item is to be found. This field may contain a store or a warehouse. |
STORE_ITEM |
STORE_ID |
Number |
10,0 |
Yes |
the unique identifier of the location that is holding the item. |
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 |
SIM sets values as ''S" |
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 |
not used in SIM |
available_qty |
number12_4 |
1 |
1 |
Contains the available quantity for the item/location in standard unit of measure. |
STORE_ITEM_STOCK |
QUANTITY_RESERVED, QUANTITY_CUSTOMER_RESERVE, QUANTITY_NON_SELLABLE, QUANTITY_VENDOR_RETURN |
number |
12,4 |
Yes |
Available quantity for item |
unit_of_measure |
varchar24 |
1 |
1 |
Contains the unit of measure for available quantity. |
ITEM |
UNIT_OF_MEASURE |
varchar2 |
4 |
Yes |
unit of measure which the stock for this item is tracked at the coporate level. |
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 |
not used in SIM |
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 |
pack calculated indicator Y or N |
Dist:DistanceDesc
|
*
|
0
|
1
|
Gives the distance of the location from the center of Search Area.
|
NA
|
NA
|
NA
|
NA
|
NA
|
NA
|