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

XML-Schema Name:StsTsfDesc 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 StsTsfDesc 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 1 1 Internal identifier TRANSFER ID NUMBER 12,0 Yes unique identifier of the transfer
sending_store_id number10 1 1 Identifier of store sending the items 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 TRANSFER RECEIVING_STORE_ID NUMBER 10,0 Yes the identifier of the store that will receive the items on the transfer.
create_store_id number10 1 1 Identifier of store that created the transfer TRANSFER CREATE_STORE_ID NUMBER 10,0 Yes the identifier of the store that created the transfer
external_id varchar2128 0 1 External identifier TRANSFER EXTERNAL_ID VARCHAR2 128 No external id. ex external id is from rms
status sts_tsf_status 1 1 Current status Valid values are NEW, PENDING, REJECTED, CANCELED_REQUEST, IN_PROGRESS, DISPATCHED, SUBMITTED, RECEIVING, RECEIVED, CANCELED_TRANSFER, UNKNOWN. TRANSFER STATUS NUMBER 2,0 No The status of transfer. valid values: 5 - New Request, 10 - Awaiting Response, 15 - Inbond Rejected Request, 20 - Canceled Request, 25 - In progress Inbond - Picking, 26 - Submitted Inbond - Picking, 30 - In Transit 35 - Receiving, 40 - Received, 50 - Inbound Canceled
create_user_name varchar2128 1 1 User that created the transfer TRANSFER CREATE_USER VARCHAR2 128 No a person or personel create a transfer
update_user_name varchar2128 0 1 Last user that last updated the transfer. TRANSFER UPDATE_USER VARCHAR2 128 No the last user to update the transfer.
approval_user_name varchar2128 0 1 User that approved the transfer TRANSFER APPROVAL_USER VARCHAR2 128 No the user that approved the transfer.
ship_user_name varchar2128 0 1 User that shipped the transfer TRANSFER SHIPPED_USER VARCHAR2 128 No the user that shipped the transfer.
receive_user_name varchar2128 0 1 User that received the transfer TRANSFER RECEIVE_USER VARCHAR2 128 No the user that received the transfer.
create_date xs:dateTime 1 1 Date the transfer was created. TRANSFER CREATE_DATE Date No orginal or create date of a transfer
update_date xs:dateTime 0 1 Date the transfer was last updated. TRANSFER UPDATE_DATE Date No the date the transfer was last updated.
approve_date xs:dateTime 0 1 Date the transfer was approved. TRANSFER APPROVAL_DATE Date No the date the transfer was approved.
ship_date xs:dateTime 0 1 Date the transfer was shipped. TRANSFER SHIPPED_DATE Date No the date the transfer was shipped.
receive_date xs:dateTime 0 1 Date the transfer was received. TRANSFER RECEIVE_DATE Date No the date the transfer was received.
request_comments varchar22000 0 1 Comments associated to the transfer during the request stage. TRANSFER REQUEST_COMMENT VARCHAR2 2000 No comments associated with the original request.
transfer_comments varchar22000 0 1 Comments associated to the transfer during the transfer stage TRANSFER TRANSFER_COMMENT VARCHAR2 2000 No comments associated with the transfer.
delivery_slot_id varchar215 0 1 Identifier of the delivery time slot associated to the transfer TRANSFER DELIVERY_SLOT_ID VARCHAR2 15 No delivery slot id
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. ex PROM - Promotion
context_value varchar225 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, ex promotin number.
StsTsfBol * 0 1 Information about bill of lading for the transfer.
StsTsfItm * 0 unbounded Collection of transfer line items

XML-Schema Name:StsTsfBol 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 StsTsfBol 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_carrier_role 1 1 Bill of lading carrier role. Valid values are THIRD_PARTY, SENDER, UNKNOWN. 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 Yes not used in SIM
carrier_service_code varchar225 0 1 Bill of lading carrier service role Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
carrier_name varchar2240 0 1 Bill of lading carrier name Yes not used in SIM
carrier_address varchar22000 0 1 Bill of lading carrier address Yes not used in SIM
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:StsTsfItm 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 StsTsfItm 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 1 1 Unique identifier Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
item_id varchar225 1 1 Sku number Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
requested_quantity number20_4 0 1 Quantity requested by receiving store Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
approved_quantity number20_4 0 1 Quantity approved by sending store Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
transfer_quantity number20_4 0 1 Quantity shipped by sending store Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
received_quantity number20_4 0 1 Quantity received by receiving store Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
damaged_quantity number20_4 0 1 Quantity received as damaged by the receive store Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
case_size number10_2 1 1 Case size of the item Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
uin_col varchar2128 0 unbounded Collection of all the unique identifiers/serial numbers associated with the line item Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
StrInvExtAttDesc:StrInvExtAttDesc * 0 1000 Collection of extended attributes for the line item. 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