XSD Element Name |
XSD Element Data Type |
XSD Min Occurs |
XSD Max Occurs |
XSD Element Description |
Mapping for FrtTermDesc in RMS application. |
RMS's Table Name |
RMS's Column Name |
Integration API(RIB or/and RSB or/and RSL) |
RMS's Column Length |
Is Column Required in RMS's API? |
RMS's 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. |