XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for StrFtrInvDesc in SIM application. |
SIM's Table Name |
SIM's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
item_id |
varchar225 |
1 |
1 |
Sku number |
STORE_ITEM_STOCK |
ITEM_ID |
RIB or/and RSB |
25 |
Yes |
Fill this description. |
store_id |
number10 |
1 |
1 |
Store identifier |
STORE_ITEM_STOCK |
STORE_ID |
RIB or/and RSB |
10 |
Yes |
Fill this description. |
src_loc_type |
inv_location_type |
1 |
1 |
Location type of the source of the delivery. Valid values are STORE, WAREHOUSE, FINISHER, UNKNOWN. |
Fill application table name. |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
src_loc_id |
number10 |
1 |
1 |
Identifier of the source of the delivery. |
n/a (multiple tables) |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
delivery_type |
inv_delivery_type |
1 |
1 |
Type of delivery. Valid values are ALLOCATION, PURCHASE_ORDER, TRANSFER, UNKNOWN. |
n/a (multiple tables) |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
expected_date |
xs:dateTime |
0 |
1 |
The date the inventory is expected to arrive. |
n/a (multiple tables) |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
inbound_qty |
number20_4 |
1 |
1 |
Amount of inventory inbound on delivery. |
n/a (multiple tables) |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |
ordered_qty |
number20_4 |
1 |
1 |
Amount of inventory on order. |
n/a (multiple tables) |
Fill table column name. |
RIB or/and RSB |
Fill column length. |
Yes |
Fill this description. |