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/TsfDelvCtnHdrCol/v1
Version 1.0
Description
XSD Structure

XML-Schema Name:TsfDelvCtnHdrCol 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 TsfDelvCtnHdrCol 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
TsfDelvCtnHdrDesc:TsfDelvCtnHdrDesc * 0 unbounded Collection of transfer delivery container headers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. TSF_DELV_CARTON n/a RIB or/and RSB n/a Yes number of transfer delivery carton records

XML-Schema Name:TsfDelvCtnHdrDesc 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 TsfDelvCtnHdrDesc 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
delivery_id number15 1 1 Transfer delivery unique identifier. TSF_DELV_CARTON TSF_DELV_ID NUMBER 15 Yes Transfer delivery unique identifier.
store_id number10 1 1 Store unique identifier. TSF_DELV_CARTON STORE_ID NUMBER 10 Yes Store 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 Container external identifier. TSF_DELV_CARTON EXTERNAL_ID VARCHAR2 128 No Container 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.
number_of_skus number10 1 1 Number of line items in the transfer delivery container. No Number of items on the container.
number_of_docs number10 1 1 Number of documents in the transfer delivery container. No Number of document associated with items on the container.
customer_order_related cust_order_related 1 1 Indicates if container contains customer order items. Valid values are YES, NO, MIX, UNKNOWN. TSF_DELV_CARTON CUSTOMER_ORDER_RELATED NUMBER 4 No Indicates if carton contains customer order items. 1 - all items customer order related; 2 - some items customer related; 3 - no items customer order related
discrepant xs:boolean 1 1 Indicates if there is any discrepancy in the item quantities. TSF_DELV_CARTON DISCREPANT VARCHAR2 1 Yes Indicates if there is any discrepancy in the item quantities.
uin_required xs:boolean 1 1 Indicates if there is any UINs (Universal Identification Number) in the container. No True if the container has UINs else false.