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

XML-Schema Name:StsTsfShpModVo Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StsTsfShpModVo 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
transfer_id number12 0 1 Internal transfer identifier. If null, will create a new transfer, otherwise will modify specified transfer. TRANSFER ID NUMBER 12,0 Yes unique identifier of the transfer
sending_store_id number10 1 1 Identifier of store sending the items. This value can not be altered on update. TRANSFER SENDING_STORE_ID number 10,0 Yes the identifier of the store that will send the items on the transfer.
receiving_store_id number10 1 1 Identifier of store receiving the items. This value can not be altered on update. TRANSFER RECEIVING_STORE_ID number 10,0 Yes the identifier of the store that will receive the items on the transfer.
external_id varchar2128 0 1 External identifier to associated to the transfer. This value can not be altered on update. TRANSFER EXTERNAL_ID varchar2 128 No external id. ex external id is from rms
comments varchar22000 0 1 Comments associated to the transfer during the transfer stage. TRANSFER TRANSFER_COMMENT varchar2 2000 No comments associated with the transfer.
context_type_id varchar215 0 1 Identifier of the context type associated to the transfer. TRANSFER CONTEXT_TYPE_ID varchar2 15 No This field hods the functional area code to which the transfer relates to. For example promotions. e.g PROM - Promotion
context_value varchar2240 0 1 Value of the context associated to the transfer TRANSFER CONTEXT_VALUE varchar2 25 No This field holds value relating to the context type, e.g promotin number.
StsTsfBolMod * 0 1 Information about bill of lading for the transfer.
StsTsfShpItmMod * 0 1500 Collection of transfer line items containing modified information.
removed_line_id_col number12 0 1500 Collections of removed line items indicated by their identifier. Yes removed line items

XML-Schema Name:StsTsfBolMod Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StsTsfBolMod 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
bill_of_lading_motive_id varchar2120 0 1 Bill of lading motive identifier SHIPMENT_BOL MOTIVE VARCHAR2 120 Yes this field contains the motive
requested_pickup_date xs:dateTime 0 1 Bill of lading requested pickup date SHIPMENT_BOL REQUESTED_PICKUP_DATE DATE No the field contains the requested pickup date
carrier_role sts_tsf_mod_carrier_role 1 1 Bill of lading carrier role. Valid values are THIRD_PARTY, SENDER. SHIPMENT_BOL CARRIER_ROLE varchar2 12 Yes this field contains the type of carrier for the shipment
carrier_code varchar225 0 1 Bill of lading carrier code SHIPMENT_CARRIER CODE VARCHAR2 4 Yes Unique code identifier for a carrier
carrier_service_code varchar225 0 1 Bill of lading carrier service role SHIPMENT_CARRIER_SERVICE CODE VARCHAR2 6 Yes Unique identifier that represents the delivery service
carrier_name varchar2240 0 1 Bill of lading carrier name SHIPMENT_BOL THIRD_PARTY_NAME varchar2 240 No this field contains the name of the third party
carrier_address varchar22000 0 1 Bill of lading carrier address SHIPMENT_BOL THIRD_PARTY_ADDRESS VARCHAR2 2000 No this field contains the address of the third party
carton_type_id number12 0 1 Unique identifier of the shipment carton type that the order is shipped in. NA NA NA NA NA NA
package_weight number12_4 0 1 The weight of the package measured by package_weight_uom. NA NA NA NA NA NA
package_weight_uom varchar24 0 1 The unit of measure of the package weight. NA NA NA NA NA NA
alternate_ship_to_address varchar22000 0 1 Bill of lading alternate destination address SHIPMENT_BOL ALT_DESTINATION_ADDRESS VARCHAR2 2000 No this field contains the alternate destination address
tracking_number varchar2128 0 1 Bill of lading tracking number SHIPMENT_BOL TRACKING_NUMBER VARCHAR2 128 No Holds the tracking number for the transaction.

XML-Schema Name:StsTsfShpItmMod Version:14.1.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StsTsfShpItmMod 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 number12 0 1 Line Item identifier. If left empty, indicates new line item, otherwise will attempt to modify existing line item. TRANSFER_LINE_ITEM ID number 12,0 Yes unique identifier of the transfer line item
item_id varchar225 1 1 Sku number of the item. This value cannot be altered for an existing line item. TRANSFER_LINE_ITEM ITEM_ID varchar2 25 Yes reference to item identifier
case_size number10_2 0 1 Case size associated with the item on this line item. The value will be defaulted by the service if a value is not supplied. TRANSFER_LINE_ITEM CASE_SIZE number 10,2 No pack size
transfer_quantity number12_4 1 1 Quantity to transfer in units. TRANSFER_LINE_ITEM TRANSFER_QUANTITY number 20,4 No transfer quantity of a transfer line item
added_uin_col varchar2128 0 200 Unique Identifier Numbers to add to the line item. Yes serial numbers in line item
removed_uin_col varchar2128 0 200 Unique Identifier Numbers to remove from the line item. Yes removed serial numbers
StrInvExtAttDesc:StrInvExtAttDesc * 0 1000 Collection of extended attributes associated to the line item, either added or updated external attributes. NA NA NA NA NA NA
removed_ext_att_col varchar2128 0 1000 Contains barcodes associated to the extended attribute scan to be deleted. All occurrences will be deleted. NA NA NA NA NA NA

XML-Schema Name:StrInvExtAttDesc Version:14.1.0 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. NA NA NA NA NA NA
quantity number10 1 1 Number of occurrences of the extended attribute scanned on the line item. NA NA NA NA NA NA
StrInvCodVal * 0 10 Collection of code-value pairs that contains the broken out information from within the barcode. NA NA NA NA NA NA