Views
Aus FreiBier
Version vom 2. November 2013, 01:09 Uhr von Tbayen (Diskussion | Beiträge)
Views
rv_fact_acct_bay
I used the definition of rv_fact_acct as a base and added the following things:
ev.oldname, "substring"(ev.value::text, 1, 1) AS accountclass, sr.value AS sr_value, sr.name AS sr_name, co.value AS co_value, co.name AS co_name, cosr.value AS cosr_value, cosr.name AS cosr_name
LEFT JOIN adempiere.c_salesregion sr ON f.c_salesregion_id = sr.c_salesregion_id LEFT JOIN adempiere.bay_contract co ON f.userelement1_id = co.bay_contract_id; LEFT JOIN adempiere.c_salesregion cosr ON co.c_salesregion_id = cosr.c_salesregion_id