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

XML-Schema Name:PayTermDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PayTermDesc 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
terms_xref_key varchar232 1 1 Description is not available. Fill application table name. Fill table column name. RIB or/and RSB or/and RSL Fill column length. Yes Fill this description.
terms varchar215 0 1 Unique id for this payment term. terms_head terms null null Yes Unique ID for this payment term.
terms_code varchar250 1 1 The alpha value which acts as the Term code in Oracle Financials. terms_head terms_code null null Yes An alpha value that serves as the Term code in Oracle financials systems.
terms_desc varchar2240 1 1 Description of the payment terms. terms_head terms_desc null null Yes Description of the payment terms.
due_days number3 0 1 Not used. Fill application table name. Fill table column name. null null No Not used by RMS.
enabled_flag varchar21 0 1 Not used. Fill application table name. Fill table column name. null null No Not used by RMS.
start_date_active xs:dateTime 0 1 Not used. Fill application table name. Fill table column name. null null No Not used by RMS.
end_date_active xs:dateTime 0 1 Not used. Fill application table name. Fill table column name. null null No Not used by RMS.
discdays number3 0 1 Not used. Fill application table name. Fill table column name. null null No Not used by RMS.
percent number12_4 0 1 Not used. Fill application table name. Fill table column name. null null No Not used by RMS.
PayTermDtl * 0 unbounded Child node.
rank number10 0 1 Unique rank to rate invoice payment terms against PO terms terms_head rank null null Yes Unique rank to rate invoice payment terms against PO terms.
ExtOfPayTermDesc:ExtOfPayTermDesc * 0 1 Provide an extension hook to customize PayTermDesc. NA NA NA NA NA NA
LocOfPayTermDesc:LocOfPayTermDesc * 0 unbounded Provide an extension hook to localize PayTermDesc. NA NA NA NA NA NA

XML-Schema Name:PayTermDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for PayTermDtl 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
due_days number3 1 1 The number of days until payment is due. terms_detail duedays null null Yes The number of days until payment is due.
due_max_amount number12_4 1 1 Maximum payment amount due by a certain date. terms_detail due_max_amount number 12 Yes Maximum payment amount due by a certain date.
due_dom number2 1 1 Day of month used to calculate due date. terms_detail due_dom null null Yes Day of month used to calculate due date.
discdays number3 1 1 Number of days in which payment must be made to get the discount. terms_detail discdays null null Yes Number of days in which payment must be made to get the discount.
percent number12_4 1 1 Percentage used to calculate discount available. terms_detail percent null null Yes Percentage used to calculate discount available.
disc_dom number2 1 1 Day of month used to calculate discount date. terms_detail disc_dom null null Yes Day of month used to calculate discount date.
disc_mm_fwd number3 1 1 Number of months ahead to calculate discount date. terms_detail disc_mm_fwd null null Yes Number of months ahead to calculate discount date.
fixed_date xs:dateTime 0 1 Fixed due date. terms_detail fixed_date null null No Fixed due date.
enabled_flag varchar21 1 1 Indicates whether the Payment terms are valid or invalid within the respective application. The values would be either (Y)es or (N)o. terms_detail enabled_flag null null Yes Indicates whether payment terms are valid within the respective application. Valid values are Y and N.
start_date_active xs:dateTime 0 1 Start date terms are in effect. terms_detail start_date_active null null No First day on which terms are in effect.
end_date_active xs:dateTime 0 1 End date terms are in effect. terms_detail end_date_active RIBDate Fill column length. No Last day on which terms are in effect.
terms_seq number10 1 1 Sequence for the discount percent and part of unique identifier for the detail line. terms_detail terms_seq null null No Sequence for the discount percent and part of the unique identifier for the detail line.
due_mm_fwd number3 1 1 Number of months ahead to calculate due date. terms_detail due_mm_fwd null null Yes Number of months ahead to calculate due date.
cutoff_day number2 1 1 Day of month after which the following month will be used for calculations. terms_detail cutoff_day null null No Day of month after which the following month will be used for calculations.
ExtOfPayTermDesc:ExtOfPayTermDtl * 0 1 Provide an extension hook to customize PayTermDtl. NA NA NA NA NA NA
LocOfPayTermDesc:LocOfPayTermDtl * 0 unbounded Provide an extension hook to localize PayTermDtl. NA NA NA NA NA NA

XML-Schema Name:ExtOfPayTermDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ExtOfPayTermDtl 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

XML-Schema Name:LocOfPayTermDtl Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfPayTermDtl 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
InPayTermDesc:InPayTermDtl * 0 unbounded India Localization. NA NA NA NA NA NA
BrPayTermDesc:BrPayTermDtl * 0 unbounded Brazil Localization. NA NA NA NA NA NA

XML-Schema Name:ExtOfPayTermDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for ExtOfPayTermDesc 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

XML-Schema Name:LocOfPayTermDesc Version:15.0.0 Return to Top
XSD Element Name XSD Element Data Type XSD Min Occurs XSD Max Occurs XSD Element Description Mapping for LocOfPayTermDesc 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
InPayTermDesc:InPayTermDesc * 0 unbounded India Localization. NA NA NA NA NA NA
BrPayTermDesc:BrPayTermDesc * 0 unbounded Brazil Localization. NA NA NA NA NA NA