AR Payment Terms

Description
Categories: Enginatics, Toolkit - Setup & Support
Repository: Github Columns: Term Name, Description, Partial Payment Discount, Prepayment, Credit Check, Billing Cycle, Base Amount, Discount Basis, Printing Lead Days, Installment Options ...
Master data report showing the payment terms codes with their respective profile options.
select
rtt.name term_name,
rtt.description,
decode(rtb.partial_discount_flag,'Y','Yes') partial_payment_discount,
decode(rtb.prepayment_flag,'Y','Yes') prepayment,
decode(rtb.credit_check_flag,'Y','Yes') credit_check,
acbct.cycle_name billing_cycle,
rtb.base_amount,
xxen_util.meaning(decode(rtb.calc_discount_on_lines_flag,'Y','L','N','I',rtb.calc_discount_on_lines_flag),'DISCOUNT_BASIS',222) discount_basis,
rtb.printing_lead_days,
xxen_util.meaning(rtb.first_installment_code,'INSTALLMENT_OPTION',222) installment_options,
rtl.relative_amount,
rtl.due_days,
rtl.due_day_of_month day_of_month,
rtl.due_months_forward months_ahead,
(select distinct listagg(rtld.discount_percent||'%/'||nvl(rtld.discount_days,nvl(rtld.discount_day_of_month,rtld.discount_months_forward)),', ') within group (order by rtld.discount_days) over (partition by rtld.term_id) from ra_terms_lines_discounts rtld where rtb.term_id=rtld.term_id) cash_discount,
xxen_util.user_name(rtb.created_by) created_by,
xxen_util.client_time(rtb.creation_date) creation_date,
xxen_util.user_name(rtb.last_updated_by) last_updated_by,
xxen_util.client_time(rtb.last_update_date) last_update_date
from
ra_terms_b rtb,
ra_terms_tl rtt,
ar_cons_bill_cycles_tl acbct,
ra_terms_lines rtl
where
1=1 and
rtb.term_id=rtt.term_id and
rtt.language=userenv('lang') and
rtb.billing_cycle_id=acbct.billing_cycle_id(+) and
acbct.language(+)=userenv('lang') and
rtb.term_id=rtl.term_id
order by
rtt.name,
rtl.sequence_num