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

XML-Schema Name:StsTsfHdrColDesc 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 StsTsfHdrColDesc 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
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.030 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 BDI) 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 NUMBER 15 Yes unique identifier of the transfer
ext_tsf_id varchar2128 0 1 External transfer identifier. TSF EXTERNAL_ID. VARCHAR2 128 No external identifier for extenally requested transfers
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 NUMBER 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 NUMBER 10 Yes Identifier of the source of the transfer.
src_loc_name varchar2150 0 1 Name of the source of the transfer. STORE, WAREHOUSE, PARTNER NAME VARCHAR2 150, 150, 240 No Name of the source of the transfer.
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. NUMBER 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 NUMBER 10 Yes the identifier of the destination that will receive the items on the transfer.
dest_loc_name varchar2150 0 1 Name of the destination of the transfer. STORE, WAREHOUSE, PARTNER NAME VARCHAR2 150, 150, 240 Yes Name of the destination of the transfer.
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 DATE Yes orginal or create date of a transfer
not_after_date xs:dateTime 0 1 Date after which the transfer should no longer be processed. TSF NOT_AFTER_DATE DATE No date after which the transfer is not valid.
number_of_line_items number10 1 1 Number of line items on the transfer. No number of line items on transfer
fulfillment_order_related xs:boolean 1 1 True if the transfer is related to a fulfillment order, false otherwise. No True if the TSF.CUST_ORD_EXTERNAL_ID is null otherwise false.