Retail Integration Bus Mappings Report Release:13.2.0 (Retail Merchandizing System)
Application Retail Merchandizing System
Target Name Space http://www.oracle.com/retail/integration/base/bo/FrtTermDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:FrtTermDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For FrtTermDesc
Table Name Column Name API Type Column Length API Required API Description
freight_terms varchar230 1 1 Contains a number that uniquely identifies the freight terms. freight_terms freight_terms null null Yes Contains a number that uniquely identifies the freight terms.
term_desc varchar2240 1 1 Contains a description of the freight terms used in the system. freight_terms term_desc varchar2 240 Yes Contains a description of the freight terms used in the system.
enabled_flag varchar21 1 1 Indicates whether the freight terms are valid or invalid within the respective application. Valid values are 'Y'es or 'N'o. NOTE: if interface is from Oracle Financials, the Check_Enabled logic will be bypassed which means field would not be required. freight_terms enabled_flag null if interface is from Oracle Financials, the Check_Enabled logic will be bypassed which means field would not be required. No Indicates whether the freight terms are valid for the application. Valid values are Y or N.
start_date_active xs:dateTime 0 1 Indicates the date for assigning an active date to the Freight Terms. freight_terms start_date_active RIBDate * No Indicates the date for assigning an active date to the Freight Terms.
end_date_active xs:dateTime 0 1 Indicates the date for assigning an inactive date to the Freight Terms. freight_terms end_date_active RIBDate * No Indicates the date for assigning an inactive date to the Freight Terms.
ExtOfFrtTermDesc:ExtOfFrtTermDesc * 0 1 Provide an extension hook to customize FrtTermDesc. NA NA NA NA NA NA
LocOfFrtTermDesc:LocOfFrtTermDesc * 0 1 Provide an extension hook to localize FrtTermDesc. NA NA NA NA NA NA

XML-Schema Name:ExtOfFrtTermDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfFrtTermDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfFrtTermDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfFrtTermDesc
Table Name Column Name API Type Column Length API Required API Description
InFrtTermDesc:InFrtTermDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrFrtTermDesc:BrFrtTermDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA