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

XML-Schema Name:TsfDelvCtnDesc 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 TsfDelvCtnDesc 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.
container_id number15 1 1 Container unique identifier. TSF_DELV_CARTON ID NUMBER 15 Yes Container unique identifier.
store_id number10 1 1 Store unique identifier. TSF_DELV_CARTON STORE_ID NUMBER 10 Yes Store unique identifier.
external_id varchar2128 0 1 The external identifier. TSF_DELV_CARTON EXTERNAL_ID VARCHAR2 128 No The external carton identifier
misdirected_carton_id number15 0 1 Misdirected container identifier that refers back to the misdirected container this was copied from. TSF_DELV_CARTON ID NUMBER 15 No Misdirected container identifier that refers back to the misdirected container this was copied from.
reference_id varchar2128 0 1 A reference identifier. TSF_DELV_CARTON REFERENCE_ID VARCHAR2 128 No A reference identifier.
status tsf_delv_carton_status 1 1 The current status of the 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.
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
damaged_reason varchar2128 0 1 The reason for container damage. TSF_DELV_CARTON DAMAGED_REASON VARCHAR2 128 No The reason for container damage.
serial_code number18 0 1 A Serial code associated to the container. TSF_DELV_CARTON SERIAL_CODE NUMBER 18 No A Serial code associated to the container.
tracking_number varchar2128 0 1 The Tracking number for the container. TSF_DELV_CARTON TRACKING_NUMBER VARCHAR2 128 No The Tracking number for the container.
create_date xs:dateTime 1 1 The date when the transfer delivery container was created. TSF_DELV_CARTON CREATE_DATE DATE Yes The date when the transfer delivery container was created.
update_date xs:dateTime 1 1 The date when the transfer delivery container was updated. TSF_DELV_CARTON UPDATE_DATE DATE Yes The date when the transfer delivery container was updated.
received_date xs:dateTime 0 1 The date when the Transfer delivery carton was received. TSF_DELV_CARTON RECEIVED_DATE DATE No The date when the Transfer delivery carton was received.
create_user varchar2128 1 1 The user who created the transfer delivery container. TSF_DELV_CARTON CREATE_USER VARCHAR2 128 Yes The user who created the transfer delivery container.
update_user varchar2128 1 1 The user who last updated the transfer delivery container. TSF_DELV_CARTON UPDATE_USER VARCHAR2 128 Yes The user who last updated the transfer delivery container.
received_user varchar2128 0 1 The user who received the transfer delivery container. TSF_DELV_CARTON RECEIVED_USER VARCHAR2 128 No The user who received the transfer delivery container.
adjusted xs:boolean 1 1 Indicates if container has been opened for adjustment. TSF_DELV_CARTON ADJUSTED VARCHAR2 1 Yes Indicates if container has been opened for adjustment.
external_create xs:boolean 1 1 Indicates if container was externally created. TSF_DELV_CARTON EXTERNAL_CREATE VARCHAR2 1 Yes Indicates if container was externally created.
damage_remaining xs:boolean 1 1 Indicates all remaining quantities should be damaged on final receipt. TSF_DELV_CARTON DAMAGE_REMAINING VARCHAR2 1 Yes Indicates all remaining quantities should be damaged on final receipt.
receive_shopfloor xs:boolean 1 1 True indicates the stock should be received at shop floor, false indicates it should be received in a back room. TSF_DELV_CARTON RECEIVE_AT_SHOP_FLOOR VARCHAR2 1 Yes True indicates the stock should be received at shop floor, false indicates it should be received in a back room.
TsfDelvCtnItm * 0 5000 Collection of items within the container.

XML-Schema Name:TsfDelvCtnItm 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 TsfDelvCtnItm 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
line_id number15 1 1 Line item identifier. TSF_DELV_LINE_ITEM ID NUMBER 15 Yes transfer delivery Line item identifier
item_id varchar225 1 1 SKU number. TSF_DELV_LINE_ITEM ITEM_ID VARCHAR2 25 Yes SKU number.
description varchar2400 0 1 Description of the item. STORE_ITEM SHORT_DESCRIPTION, LONG_DESCRIPTION VARCHAR2 255, 400 No Description of the item.
case_size number10_2 0 1 Case size associated with the item. TSF_DELV_LINE_ITEM CASE_SIZE NUMBER 10,2 No Case size associated with the item.
quantity_expected number20_4 0 1 The total number of units expected in this transfer delivery. TSF_DELV_LINE_ITEM QUANTITY_EXPECTED NUMBER 20,4 No The total number of units expected in this transfer delivery.
quantity_received number20_4 0 1 The total number of units received in this transfer delivery. TSF_DELV_LINE_ITEM QUANTITY_RECEIVED NUMBER 20,4 Yes The total number of units received in this transfer delivery.
quantity_damaged number20_4 0 1 The total number of units that were damaged when the transfer delivery was received. TSF_DELV_LINE_ITEM QUANTITY_DAMAGED NUMBER 20,4 No The total number of units that were damaged when the transfer delivery was received.
document_type tsf_delv_doc_type 1 1 Transfer delivery document type. Valid values are TRANSFER, ALLOCATION, UNKNOWN. TSF_DELV_LINE_ITEM DOCUMENT_TYPE NUMBER 2 Yes Transfer delivery document type. 0 - Transfer, 1 - Allocation
document_id number15 1 1 Reference to a transfer or allocation. TSF_DELV_LINE_ITEM DOCUMENT_ID NUMBER 15 No Reference to a transfer or allocation.
document_date xs:dateTime 1 1 The date when document was created. TSF_DELV_LINE_ITEM DOCUMENT_DATE DATE Yes The date when transfer document was created.
customer_order_id varchar2128 0 1 Customer order external identifier. TSF_DELV_LINE_ITEM CUST_ORD_EXTERNAL_ID VARCHAR2 128 No Customer order external identifier.
fulfillment_order_id varchar2128 0 1 Fulfillment order external identifier. TSF_DELV_LINE_ITEM FUL_ORD_EXTERNAL_ID VARCHAR2 128 No Fulfillment order external identifier.
use_available xs:boolean 1 1 Value of Y indicates item will be received as available inventory, N means received as unavailable inventory. TSF_DELV_LINE_ITEM USE_AVAILABLE VARCHAR2 1 Yes Value of Y indicates item will be received as available inventory, N means received as unavailable inventory.
TsfDelvUin * 0 5000 Collection of all the Unique Identification Numbers associated with the line item
StrInvExtAttDesc:StrInvExtAttDesc * 0 999 Collection of extended attributes for the line item. NA NA NA NA NA NA

XML-Schema Name:TsfDelvUin 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 TsfDelvUin 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
uin varchar2128 1 1 Unique serial number. ITEM_UIN UIN VARCHAR2 128 Yes Unique serial number
shipped xs:boolean 1 1 Indicates if the item is shipped. TSF_DELV_LINE_ITEM_UIN SHIPPED VARCHAR2 1 Yes Indicates if the item is shipped.
received xs:boolean 1 1 Indicates if the item is received. TSF_DELV_LINE_ITEM_UIN RECEIVED VARCHAR2 1 Yes Indicates if the item is received.
damaged xs:boolean 1 1 Indicates if the item is damaged. TSF_DELV_LINE_ITEM_UIN DAMAGED VARCHAR2 1 No Indicates if the item is damaged.

XML-Schema Name:StrInvExtAttDesc 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 StrInvExtAttDesc 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
barcode varchar2128 1 1 Barcode data representation of the associated GS1 international code standards and their values. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT BARCODE VARCHAR2 128 Yes Extended attribute barcode.
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. TSF_SHIP_LINE_ITEM_ATT,TSF_DELV_LINE_ITEM_ATT,STOCK_COUNT_LINE_ITEM_ATT,RTV_SHIP_LINE_ITEM_ATT,INV_ADJUST_LINE_ITEM_ATT,FUL_ORD_DLV_LINE_ITEM_ATT,DSD_LINE_ITEM_ATT QUANTITY NUMBER 12 Yes Extended attribute quantity.
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode.