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

XML-Schema Name:StsTsfHdrColDesc 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 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 transfer headers. NA NA NA NA NA NA
collection_size number4 1 1 Size of the collection. TSF n/a RIB or/and RSB n/a Yes Fill this description.

XML-Schema Name:StsTsfHdrDesc 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 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
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. TSF EXTERNAL_ID. RIB or/and RSB 128 No 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. TSF SOURCE_TYPE RIB or/and RSB 2 Yes source location type. 1- Store, 3 Warehouse, 4 - Finisher
src_loc_id number10 1 1 Identifier of the source of the transfer. TSF SOURCE_ID RIB or/and RSB 10 Yes Fill this description.
src_loc_name varchar2150 0 1 Name of the source of the transfer. STORE NAME RIB or/and RSB 150 No 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.
dest_loc_name varchar2150 0 1 Name of the destination of the transfer. STORE NAME RIB or/and RSB 150 Yes Fill this description.
status tsf_status 1 1 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. 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"
create_date xs:dateTime 1 1 Date the transfer was created. TSF CREATE_DATE RIB or/and RSB 7 Yes Fill this description.
not_after_date xs:dateTime 0 1 Date after which the transfer should no longer be processed. TSF NOT_AFTER_DATE RIB or/and RSB 7 No Fill this description.
number_of_line_items number10 1 1 Number of line items on the transfer. n/a .n/a RIB or/and RSB n/a Yes number of line items
fulfillment_order_related xs:boolean 1 1 True if the transfer is related to a fulfillment order, false otherwise. n/a n/a RIB or/and RSB n/a No Fill this description.