Retail Integration Mappings Report Release:14.0.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.0.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 StsTsfStatus 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.0.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 StsTsfCarrierRole 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
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.0.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 universal 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.