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 BDI) |
SIM's Column Length |
Is Column Required in SIM's API? |
SIM's API Description |
item_id |
varchar225 |
1 |
1 |
Sku number |
TSF_LINE_ITEM, TSF_ALLOCATION, TSF_DELV_LINE_ITEM, PURCHASE_ORDER_LINE_ITEM, DSD_LINE_ITEM |
ITEM_ID |
VARCHAR2 |
25 |
Yes |
Item identifier. |
store_id |
number10 |
1 |
1 |
Store identifier |
PURCHASE_ORDER, TSF, TSF_DELV, TSF_ALLOCATION |
STORE_ID |
NUMBER |
(10,0), (10,0), (10,0), (10,0) |
Yes |
Store Identifier. |
src_loc_type |
inv_location_type |
1 |
1 |
Location type of the source of the delivery. Valid values are STORE, WAREHOUSE, FINISHER, UNKNOWN. |
TSF, TSF_DELV, TSF_ALLOCATION |
SOURCE_TYPE |
NUMBER |
2 |
Yes |
Source from which quantity is expected to be delivered |
src_loc_id |
number10 |
1 |
1 |
Identifier of the source of the delivery. |
TSF, TSF_ALLOCATION, TSF_DELV, PURCHASE_ORDER |
SOURCE_ID, SOURCE_ID, SOURCE_ID, SUPPLIER_ID |
NUMBER, NUMBER, NUMBER, VARCHAR2 |
(10,0), (10,0), (10,0), (128) |
Yes |
Source identifier. |
delivery_type |
inv_delivery_type |
1 |
1 |
Type of delivery. Valid values are ALLOCATION, PURCHASE_ORDER, TRANSFER, UNKNOWN. |
|
|
|
|
No |
Type of delivery. Valid values are ALLOCATION, PURCHASE_ORDER, TRANSFER |
expected_date |
xs:dateTime |
0 |
1 |
The date the inventory is expected to arrive. |
TSF, TSF_ALLOCATION, TSF_DELV, PURCHASE_ORDER, DSD |
NOT_AFTER_DATE, QUANTITY_EXPECTED |
DATE |
|
No |
Expected Date of delivery. |
inbound_qty |
number20_4 |
1 |
1 |
Amount of inventory inbound on delivery. |
DSD_LINE_ITEM, TSF_DELV_LINE_ITEM |
QUANTITY_RECEIVED, QUANTITY_DAMAGED |
NUMBER |
20,4 |
No |
Quantity that was delivered. |
ordered_qty |
number20_4 |
1 |
1 |
Amount of inventory on order. |
TSF_LINE_ITEM, TSF_ALLOCATION, PURCHASE_ORDER_LINE_ITEM |
QUANTITY_APPROVED, QUANTITY_EXPECTED, QUANTITY_EXPECTED |
NUMBER |
20,4 |
No |
Quantity ordered |
|