Views
Aus FreiBier
(Unterschied zwischen Versionen)
Tbayen (Diskussion | Beiträge) (Die Seite wurde neu angelegt: „= 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…“) |
Version vom 1. November 2013, 15:49 Uhr
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 = sr.c_salesregion_id