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

XML-Schema Name:StsTsfHdrCriVo Version:16.0.030 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for StsTsfHdrCriVo in SIM application.
SIM's Table Name SIM's Column Name Integration API(RIB or/and RSB or/and BDI) SIM's Column Length Is Column Required in SIM's API? SIM's API Description
store_id number10 1 1 Include only transfers for this store. TSF SOURCE_ID, DESTINATION_ID NUMBER 10,0 Yes the identifier of the store that will receive/send the items on the transfer.
tsf_id number15 0 1 Transfer internal identifier. Include only transfers with this identifier. TSF ID NUMBER 15 Yes unique identifier of the transfer
ext_tsf_id varchar2128 0 1 External transfer identifier. Include only transfers with this external identifier. TSF EXTERNAL_ID VARCHAR2 128 No external identifier for extenally requested transfers
status tsf_cri_status 1 1 Include only transfers of this status. Valid values are NEW_REQUEST, REQUESTED, REQUEST_IN_PROGRESS, REJECTED, CANCELED_REQUEST, TRANSFER_IN_PROGRESS, APPROVED, IN_SHIPPING, COMPLETED, CANCELED, ACTIVE, NO_VALUE. TSF STATUS NUMBER 2,0 Yes "The status of transfer.1 - New Request, 2-Requested, 3-Request In Progress,4-Rejected Request, 5-Canceled Request,6-Transfer In Progress,7-Approved, 8-In Shipping,9-Completed Transfer,10-Canceled Transfer"
src_loc_type tsf_cri_location_type 1 1 Include only transfers source by this location type. Valid values are STORE, WAREHOUSE, FINISHER, NO_VALUE. TSF SOURCE_TYPE. NUMBER 2 Yes source location type. 1- Store, 3 Warehouse, 4 - Finisher
src_loc_id number10 0 1 Include only transfers source by this location identifier depending on the source location type. TSF SOURCE_ID NUMBER 10 Yes the identifier of the source that will send the items on the transfer.
dest_loc_type tsf_cri_location_type 1 1 Include only transfers where destination is this location type. Valid values are STORE, WAREHOUSE, FINISHER, NO_VALUE. TSF DESTINATION_TYPE. NUMBER 2 Yes destination location type for the transfer. 1- Store, 3 Warehouse, 4 - Finisher
dest_loc_id number10 0 1 Include only transfers where destination is this location identifier depending on the destination location type. TSF DESTINATION_ID NUMBER 10 Yes the identifier of the destination that will receive the items on the transfer.
from_update_date xs:dateTime 0 1 Include only transfers updated on or after this date. TSF UPDATE_DATE DATE Yes the date the transfer was last updated.
to_update_date xs:dateTime 0 1 Include only transfers updated on or before this date. TSF UPDATE_DATE DATE Yes the date the transfer was last updated.
item_id varchar2250 0 1 Include only transfers that contain this item. TSF_LINE_ITEM ITEM_ID VARCHAR2 25 Yes item identifier
update_user varchar2250 0 1 Include only transfers last updated by this user. TSF UPDATE_USER VARCHAR2 128 Yes the last user to update the transfer.
context_id number18 0 1 Context type identifier. Include only transfers with this context type associated to them. TSF CONTEXT_ID NUMBER 18 No Context identifier.
context_value varchar225 0 1 Context type value. Include only transfers with this context type value associated to them. TSF CONTEXT_VALUE VARCHAR2 25 No Context Value
customer_order_id varchar2128 0 1 Include only transfers with this customer order external identifier associated to them. TSF CUST_ORD_EXTERNAL_ID VARCHAR2 128 No Customer order identifier.
fulfillment_order_id varchar2128 0 1 Include only transfers with this fulfillment order external identifier associated to them. TSF FUL_ORD_EXTERNAL_ID. VARCHAR2 128 No Fulfillment order external identifier
all_customer_orders xs:boolean 1 1 Includes only transfers which are associated to fulfillment orders. No Flag to denote if customer order related transfers are to be selected.