Retail Integration Mappings Report Release:16.0.030 (Store Inventory Management)
Application Store Inventory Management
Target Name Space http://www.oracle.com/retail/integration/base/bo/TsfDelvMisCtnCol/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:TsfDelvMisCtnCol Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfDelvMisCtnCol 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
TsfDelvMisCtnVo:TsfDelvMisCtnVo * 0 unbounded Collection of transfer delivery customer orders information. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. TSF_DELV_CARTON n/a RIB or/and RSB Fill column length. Yes number of records

XML-Schema Name:TsfDelvMisCtnVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfDelvMisCtnVo 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
store_id number10 1 1 The unique store identifier where container is created. TSF_DELV_CARTON STORE_ID NUMBER 10 Yes Store unique identifier.
delivery_id number15 1 1 Transfer delivery unique identifier. TSF_DELV_CARTON TSF_DELV_ID NUMBER 15 Yes Transfer delivery unique identifier.
carton_id number15 1 1 The unique identifier for the transfer delivery container. TSF_DELV_CARTON ID NUMBER 15 Yes Container unique identifier.
external_id varchar2128 0 1 The container external identifier. TSF_DELV_CARTON EXTERNAL_ID VARCHAR2 128 No The external carton identifier
asn varchar2128 0 1 An ASN number associated to the misdirected container. TSF_DELV ASN_ID VARCHAR2 128 No ASN external identifier.
status tsf_delv_carton_status 1 1 The current status of the transfer delivery container. Valid values are IN_PROGRESS, DAMAGED, RECEIVED, MISSING, UNKNOWN. TSF_DELV_CARTON STATUS NUMBER 4 Yes The status of the Transfer delivery carton. 1 - New,2 - In progress,3 - Damaged,4 - Received,5 - Missing.