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

XML-Schema Name:StsTsfCreVo 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 StsTsfCreVo 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 Identifier of store requesting the operation. TSF SOURCE_ID NUMBER 10 Yes the identifier of the source that will send the items on the transfer.
dest_loc_type tsf_location_type 1 1 Destination location type. Valid values are STORE, WAREHOUSE, FINISHER, UNKNOWN. TSF DESTINATION_TYPE NUMBER 2 Yes destination location type for the transfer. 1- Store, 3 Warehouse, 4 - Finisher
dest_loc_id number10 1 1 Destination location identifier. TSF DESTINATION_ID NUMBER 10 Yes the identifier of the destination that will receive the items on the transfer.
not_after_date xs:dateTime 0 1 Not after date for the transfer. TSF NOT_AFTER_DATE DATE No date after which the transfer is not valid.
auth_code varchar212 0 1 Authorization Number for the transfer. TSF AUTHORIZATION_CODE VARCHAR2 12 No Authorization number
context_id number18 0 1 Context type identifier. TSF CONTEXT_ID NUMBER 18 No The context identifier
context_value varchar225 0 1 Context type value. TSF CONTEXT_VALUE VARCHAR2 25 No This field holds value relating to the context type, e.g promotin number.
partial_delivery_allowed xs:boolean 1 1 True if partial delivery is allowed for the transfer. TSF ALLOW_PARTIAL_DELIVERY VARCHAR2 1 No Indicate if partial delivery is allowed
use_available xs:boolean 1 1 True if available inventory is to be transfers, false if unavailable. TSF USE_AVAILABLE VARCHAR2 1 Yes indicates if the transfer is for unavailable stock