Retail Integration Bus Mappings Report Release:13.1.1

(Retail Merchandising System)

 

 

 

 

Application

Retail Merchandising 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.1.1

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

null

No

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.

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



XML-Schema Name:ExtOfFrtTermDesc

Version:13.1.1

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