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

XML-Schema Name:StsTsfHdrCriVo 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 StsTsfHdrCriVo 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
store_id number10 1 1 Include only transfers for this store. TSF SOURCE_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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
ext_tsf_id varchar2128 0 1 External transfer identifier. Include only transfers with this external identifier. TSF EXTERNAL_ID RIB or/and RSB 128 No Fill this description.
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 No "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. RIB or/and RSB 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. Fill application table name. Fill table column name. RIB or/and RSB Fill column length. Yes Fill this description.
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. RIB or/and RSB 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 RIB or/and RSB 10 Yes Fill this description.
from_update_date xs:dateTime 0 1 Include only transfers updated on or after this date. n/a n/a RIB or/and RSB n/a No
to_update_date xs:dateTime 0 1 Include only transfers updated on or before this date. TSF ID RIB or/and RSB 15 Yes Fill this description.
item_id varchar2250 0 1 Include only transfers that contain this item. TSF_LINE_ITEM ITEM_ID VARCHAR2 25 Yes reference to item identifier
update_user varchar2250 0 1 Include only transfers last updated by this user. TSF UPDATE_USER RIB or/and RSB 128 Yes Fill this description.
context_type_id varchar215 0 1 Context type identifier. Include only transfers with this context type associated to them. 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. Include only transfers with this context type value associated to them. TSF CONTEXT_VALUE RIB or/and RSB 25 No Fill this description.
customer_order_id varchar2128 0 1 Include only transfers with this customer order external identifier associated to them. TSF CUST_ORD_EXTERNAL_ID RIB or/and RSB 128 No Fill this description.
fulfillment_order_id varchar2128 0 1 Include only transfers with this fulfillment order external identifier associated to them. TSF FUL_ORD_EXTERNAL_ID. RIB or/and RSB 128 No Fill this description.
all_customer_orders xs:boolean 1 1 Includes only transfers which are associated to fulfillment orders. n/a n/a RIB or/and RSB n/a No n/a