Aktuelle Version vom 2. November 2013, 01:09 Uhr

[Bearbeiten] Views

[Bearbeiten] 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