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

XML-Schema Name:TsfDelvCtnModVo 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 TsfDelvCtnModVo 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
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 The external carton identifier
reference_id varchar2128 0 1 The reference identifier. TSF_DELV_CARTON REFERENCE_ID VARCHAR2 128 No A reference identifier.
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 Serial code. TSF_DELV_CARTON SERIAL_CODE NUMBER 18 No A Serial code associated to the container.
tracking_number varchar2128 0 1 A tracking number for the container. TSF_DELV_CARTON TRACKING_NUMBER VARCHAR2 128 No The Tracking number for the container.
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 Y indicates if the stock would be received at shop floor otherwise it is received in 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.
TsfDelvCtnItmMod * 0 5000 Collection of items within the container.
TsfDelvCtnModNote * 0 1000 Notes associated to the vendor delivery.

XML-Schema Name:TsfDelvCtnItmMod 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 TsfDelvCtnItmMod 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_id number15 0 1 Line item unique identifier. If left blank, the item will be added to the delivery container. 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.
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 7 Yes The date when transfer document was created.
TsfDelvUinMod * 0 5000 Collection of all the Unique Identification Numbers associated with the line item.
StrInvExtAttDesc:StrInvExtAttDesc * 0 1000 Collection of extended attributes associated with the line item, either added or updated external attributes. NA NA NA NA NA NA
removed_ext_att_col varchar2128 0 1000 Collection of extended attributes associated with the line item to be removed. n/a Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.

XML-Schema Name:TsfDelvUinMod 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 TsfDelvUinMod 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
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.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.

XML-Schema Name:TsfDelvCtnModNote 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 TsfDelvCtnModNote 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
note varchar22000 1 1 Note associated to the transfer delivery. NOTES TEXT VARCHAR2 2000 Yes Note associated to the transfer delivery.