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

XML-Schema Name:TsfShipCtnDesc Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfShipCtnDesc 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
tsf_ship_carton_id number15 1 1 The unique transfer shipment container identifier. TSF_SHIP_CARTON ID NUMBER 15 Yes Fill this description.
store_id number10 1 1 The unique store identifier from where shipment is created. TSF_SHIP_CARTON STORE_ID NUMBER 10 Yes Fill this description.
external_id varchar2128 0 1 The external identifier. TSF_SHIP_CARTON EXTERNAL_ID VARCHAR2 128 No Fill this description.
tsf_ship_id number15 1 1 The transfer shipment identifier. TSF_SHIP_CARTON TSF_SHIP_ID NUMBER 15 Yes Fill this description.
status tsf_ship_ctn_status 1 1 The current status of the container. Valid values are NEW, IN_PROGRESS, COMPLETED, SHIPPED, CANCELED, UNKNOWN, NO_VALUE. TSF_SHIP_CARTON STATUS NUMBER 4 Yes The status of theShipment carton. Valid values: 1- New, 2- In progress, 3- Completed, 4- Canceled
destination_type tsf_ship_dest_type 1 1 The destination type of the destination the transfer shipment is being shipped to. Valid values are FINISHER, STORE, WAREHOUSE, UNKNOWN. TSF_SHIP DESTINATION_TYPE RIB or/and RSB 2 Yes The shipment destination type. 1- Store, 3 Warehouse, 4 - Finisher
destination_name varchar2128 1 1 The destination name of the destination the transfer shipment is being shipped to. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
hierarchy_level tsf_hierarchy_level 1 1 The container restricted hierarchy level. Valid values are NONE, DEPT, CLASS, SUBCLASS. TSF_SHIP_CARTON RESTRICTION_LEVEL NUMBER 4 No Fill this description.
TsfShipCtnSize * 0 1 The container size.
weight number12_4 0 1 The weight of the container. TSF_SHIP_CARTON WEIGHT NUMBER 12,4 No Fill this description.
weight_uom varchar24 0 1 The unit of measure of the weight of the container. TSF_SHIP_CARTON WEIGHT_UOM VARCHAR2 4 No Fill this description.
tracking_number varchar2128 0 1 The tracking number for the container. TSF_SHIP_CARTON TRACKING_NUMBER VARCHAR2 128 No Fill this description.
create_user varchar2128 1 1 The user who created the container. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
update_user varchar2128 0 1 The user who last updated the container. TSF_SHIP_CARTON UPDATE_USER VARCHAR2 128 Yes Fill this description.
approval_user varchar2128 0 1 The user who approved the container. TSF_SHIP_CARTON APPROVAL_USER VARCHAR2 128 No Fill this description.
create_date xs:dateTime 1 1 The date the transfer shipment container was created. TSF_SHIP_CARTON. CREATE_USER VARCHAR2 128 Yes Fill this description.
update_date xs:dateTime 0 1 The most recent date when the transfer shipment container was updated. TSF_SHIP_CARTON UPDATE_DATE DATE 7 Yes Fill this description.
approval_date xs:dateTime 0 1 The date when the transfer shipment container was approved. TSF_SHIP_CARTON APPROVAL_DATE DATE 7 No Fill this description.
use_available xs:boolean 1 1 True if container uses only available inventory. TSF_SHIP_CARTON USE_AVAILABLE VARCHAR2 1 Yes value of Y indicates carton will use only available inventory, N means carton will use unavailable inventory
order_related xs:boolean 1 1 Indicates if any customer orders are associated with the container. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
TsfShipCtnItm * 0 5000 A collection of items in the container.

XML-Schema Name:TsfShipCtnSize Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfShipCtnSize 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
id number15 1 1 The unique carton size identifier. SHIPMENT_CARTON_DIM ID NUMBER 12 Yes The shipment carton dimension identifier.
store_id number10 0 1 The unique store identifier. SHIPMENT_CARTON_DIM STORE_ID NUMBER 10 Yes Store identifier
description varchar2128 0 1 The description of the dimensions. SHIPMENT_CARTON_DIM DESCRIPTION VARCHAR2 120 Yes The carton dimensions description
height number20_4 0 1 The height of the carton. SHIPMENT_CARTON_DIM HEIGHT NUMBER 12,4 Yes The height of the carton.
width number20_4 0 1 The width of the carton. SHIPMENT_CARTON_DIM WIDTH NUMBER 12,4 No The width of the carton
length number20_4 0 1 The length of the carton. SHIPMENT_CARTON_DIM LENGTH NUMBER 12,4 No length of the shipment carton
unit_of_measure varchar2128 1 1 Unit of measure for the measurements. SHIPMENT_CARTON_DIM UOM VARCHAR2 4 No Unit of measure

XML-Schema Name:TsfShipCtnItm Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for TsfShipCtnItm 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
line_item_id number15 1 1 The unique line item identifier. TSF_SHIP_LINE_ITEM ID NUMBER 15 Yes Fill this description.
item_id varchar225 1 1 The unique identifier of the sku. TSF_SHIP_LINE_ITEM ITEM_ID VARCHAR2 25 Yes Fill this description.
description varchar2400 0 1 Description of the item. STORE_ITEM SHORT_DESCRIPTION VARCHAR2 255 No Fill this description.
case_size number10_2 0 1 Case size of the item. ITEM CASE_SIZE NUMBER 12,4 No Fill this description.
quantity number10 1 1 Quantity to be shipped. TSF_SHIP_LINE_ITEM QUANTITY NUMBER 20,4 Yes Fill this description.
shipment_reason_id number15 0 1 The identifier of the reason for the item shipment. TSF_SHIP_LINE_ITEM SHIPMENT_REASON_ID NUMBER 15 No The shipment reason identifier
transfer_id number12 1 1 The document id associated with this item and quantity. TSF ID NUMBER 15 No Fill this description.
cust_ord_ext_id varchar2128 0 1 The external identifier of a customer order if one is associated to the item. TSF CUST_ORD_EXTERNAL_ID VARCHAR2 128 No Fill this description.
ful_ord_ext_id varchar2128 0 1 The external identifier of a fulfillment order if one is associated to the item. FUL_ORD EXTERNAL_ID VARCHAR2 128 No Fill this description.
uin_col varchar2128 0 5000 Collection of all the unique identifiers/serial numbers associated with the line item. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
StrInvExtAttDesc:StrInvExtAttDesc * 0 999 Collection of extended attributes associated with the line item. NA NA NA NA NA NA

XML-Schema Name:StrInvExtAttDesc Version:16.0.21 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StrInvExtAttDesc 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
barcode varchar2128 1 1 Barcode data representation of the associated GS1 international code standards and their values. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. n/a (multiple tables) Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode.