View: core.payment_term_scrud_view

 CREATE OR REPLACE VIEW core.payment_term_scrud_view
 AS
 SELECT payment_terms.payment_term_id,
    payment_terms.payment_term_code,
    payment_terms.payment_term_name,
    payment_terms.due_on_date,
    payment_terms.due_days,
    ((due_frequency.frequency_code::text || ' ('::text) || due_frequency.frequency_name::text) || ')'::text AS due_frequency,
    payment_terms.grace_peiod,
    ((late_fee.late_fee_code::text || '('::text) || late_fee.late_fee_name::text) || ')'::text AS late_fee,
    ((late_fee_posting_frequency.frequency_code::text || ' ('::text) || late_fee_posting_frequency.frequency_name::text) || ')'::text AS late_fee_posting_frequency
   FROM core.payment_terms
   LEFT JOIN core.frequencies due_frequency ON payment_terms.due_frequency_id = due_frequency.frequency_id
   LEFT JOIN core.frequencies late_fee_posting_frequency ON payment_terms.late_fee_posting_frequency_id = late_fee_posting_frequency.frequency_id
   LEFT JOIN core.late_fee ON payment_terms.late_fee_id = late_fee.late_fee_id;