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

XML-Schema Name:StsTsfDesc 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 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
tsf_id number15 1 1 Transfer Unique internal identifier. TSF ID RIB or/and RSB 15 Yes Fill this description.
ext_tsf_id varchar2128 0 1 External transfer identifier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
store_id number10 1 1 Identifier of store requesting the operation. TSF SOURCE_ID RIB or/and RSB 10 Yes Fill this description.
src_loc_type tsf_location_type 1 1 Location type of the source of the transfer. Valid values are STORE, WAREHOUSE, FINISHER, UNKNOWN. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
src_loc_id number10 1 1 Identifier of the source of the transfer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
dest_loc_type tsf_location_type 1 1 Location type of the destination of the transfer. Valid values are STORE, WAREHOUSE, FINISHER, UNKNOWN. TSF DESTINATION_TYPE. RIB or/and RSB 2 Yes destination location type for the transfer. 1- Store, 3 Warehouse, 4 - Finisher
dest_loc_id number10 1 1 Identifier of the destination of the transfer. TSF DESTINATION_ID RIB or/and RSB 10 Yes Fill this description.
orgin_type tsf_origin_type 1 1 Transfer origin type. Valid values are EXTERNAL, INTERNAL, ADHOC, UNKNOWN. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
status tsf_status 1 1 Current status of the transfer. Valid values are NEW_REQUEST, REQUESTED, REQUEST_IN_PROGRESS, REJECTED, CANCELED_REQUEST, TRANSFER_IN_PROGRESS, APPROVED, IN_SHIPPING, COMPLETED, CANCELED, 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
not_after_date xs:dateTime 0 1 NDate after which the transfer should no longer be processed. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
auth_code varchar212 0 1 Authorization Number for the transfer. TSF AUTHORIZATION_CODE RIB or/and RSB 12 No Fill this description.
context_type_id varchar215 0 1 Context type identifier. TSF 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 Context type value. TSF CONTEXT_VALUE VARCHAR2 25 No This field holds value relating to the context type, ex promotin number.
partial_delivery_allowed xs:boolean 1 1 True if partial delivery is allowed for the transfer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
customer_order_id varchar2128 0 1 Customer order external identifier. TSF CUST_ORD_EXTERNAL_ID RIB or/and RSB 128 No Fill this description.
fulfillment_order_id varchar2128 0 1 Fulfillment order external identifier. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
request_user varchar2250 0 1 User requested the transfer. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
approval_user varchar2250 0 1 User approved the transfer. TSF APPROVAL_USER RIB or/and RSB 128 No Fill this description.
create_user varchar2250 1 1 User created the transfer. TSF CREATE_USER. RIB or/and RSB 128 Yes Fill this description.
update_user varchar2250 1 1 User last updated the transfer. TSF UPDATE_USER RIB or/and RSB 128 Yes Fill this description.
request_date xs:dateTime 0 1 Date on which transfer was requested. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
approval_date xs:dateTime 0 1 Date on which transfer was approved. TSF APPROVAL_DATE RIB or/and RSB 7 Yes Fill this description.
create_date xs:dateTime 1 1 Date on which transfer was created. TSF CREATE_DATE Date Fill column length. No orginal or create date of a transfer
update_date xs:dateTime 1 1 Last update date for the transfer. TSF UPDATE_DATE Date 7 No the date the transfer was last updated.
use_available xs:boolean 1 1 True if available inventory is to be used for shipment, false if unavailable inventory.. TSF USE_AVAILABLE RIB or/and RSB 1 Yes Fill this description.
StsTsfItm * 0 5000 Collection of transfer line items.
StsTsfDescNote * 0 1000 Notes associated to the transfer.

XML-Schema Name:StsTsfItm 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 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 TSF_LINE_ITEM ID RIB or/and RSB 15 Yes Transfer line identifier
item_id varchar225 1 1 Sku number. TSF_LINE_ITEM ITEM_ID RIB or/and RSB 20,4. Yes Fill this description.
requested_quantity number20_4 0 1 Quantity requested by destination. TSF_LINE_ITEM QUANTITY_REQUESTED RIB or/and RSB 20,4 No Fill this description.
approved_quantity number20_4 0 1 Quantity approved by source. TSF_LINE_ITEM QUANTITY_APPROVED RIB or/and RSB 20,4 No Fill this description.
shipping_quantity number20_4 0 1 Quantity in shipping at source. TSF_LINE_ITEM QUANTITY_SHIPPING RIB or/and RSB 20,4 No Fill this description.
shipped_quantity number20_4 0 1 Quantity shipped by source. TSF_LINE_ITEM QUANTITY_SHIPPED RIB or/and RSB 20,4 No Fill this description.
received_quantity number20_4 0 1 Quantity received by destination. TSF_LINE_ITEM QUANTITY_RECEIVED RIB or/and RSB 20,4 No Fill this description.
damaged_quantity number20_4 0 1 Quantity received as damaged at the destination. TSF_LINE_ITEM QUANTITY_DAMAGED. RIB or/and RSB 20,4 No Fill this description.
case_size number10_2 1 1 Case size of the item. TSF_LINE_ITEM CASE_SIZE RIB or/and RSB 10,2 No Fill this description.

XML-Schema Name:StsTsfDescNote 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 StsTsfDescNote 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 The contents of the note. NOTES TEXT RIB or/and RSB 2000 No The contents of the note