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

XML-Schema Name:StsTsfHdrColDesc 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 StsTsfHdrColDesc 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
StsTsfHdrDesc:StsTsfHdrDesc * 0 unbounded Collection of store-to-store transfer headers NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.

XML-Schema Name:StsTsfHdrDesc 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 StsTsfHdrDesc 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 Unique internal identifier TRANSFER ID number 12,0 Yes unique identifier of the transfer
external_id varchar2128 0 1 External identifier TRANSFER EXTERNAL_ID varchar2 128 No external id. ex external id is from rms
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.
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
status_date xs:dateTime 1 1 Date current status occurred through processing. TRANSFER CREATE_DATE, SHIPPED_DATE, RECEIVE_DATE date No the date transfer was created/ shipped/ received
create_user_name varchar2128 1 1 User that created the transfer. TRANSFER CREATE_USER varchar2 128 No a person or personel create a transfer
approval_user_name varchar2128 0 1 User that approved the transfer. TRANSFER APPROVAL_USER varchar2 128 No the user that approved 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.
number_of_line_items number10 1 1 Number of line items on the transfer. . Yes number of line items