Views

Aus FreiBier
Version vom 1. November 2013, 14:49 Uhr von Tbayen (Diskussion | Beiträge)

(Unterschied) ← Nächstältere Version | Aktuelle Version (Unterschied) | Nächstjüngere Version → (Unterschied)
Wechseln zu: Navigation, Suche

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
Meine Werkzeuge
Namensräume

Varianten
Aktionen
Navigation
Werkzeuge