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/PayTermDesc/v1
Version 1.0
Description This is root element of this document which contains name space definitions for the document elements.

XML-Schema Name:PayTermDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For PayTermDesc
Table Name Column Name API Type Column Length API Required API Description
terms_xref_key varchar232 1 1 Description is not available. NA NA NA NA NA NA
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. null null No Not used by RMS.
enabled_flag varchar21 0 1 Not used. null null No Not used by RMS.
start_date_active xs:dateTime 0 1 Not used. null null No Not used by RMS.
end_date_active xs:dateTime 0 1 Not used. null null No Not used by RMS.
discdays number3 0 1 Not used. null null No Not used by RMS.
percent number12_4 0 1 Not used. 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 1 Provide an extension hook to localize PayTermDesc. NA NA NA NA NA NA

XML-Schema Name:PayTermDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For PayTermDtl
Table Name Column Name API Type Column Length API Required 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 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 1 Provide an extension hook to localize PayTermDtl. NA NA NA NA NA NA

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

XML-Schema Name:LocOfPayTermDtl Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfPayTermDtl
Table Name Column Name API Type Column Length API Required 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:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For ExtOfPayTermDesc
Table Name Column Name API Type Column Length API Required API Description

XML-Schema Name:LocOfPayTermDesc Version:13.2.0 Return to Top
Tag Name Type Min Occurs Max Occurs Description rms Mapping For LocOfPayTermDesc
Table Name Column Name API Type Column Length API Required 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