In iDempiere ERP, the data structure is classified by EntityType. To specify EntityType based on roles, you can use the following SQL in the default value of the column.

@SQL=SELECT
    CASE
        WHEN  @#AD_Role_ID@=1000207 THEN 'L'
        WHEN  @#AD_Role_ID@=1000208 THEN 'T'
        ELSE 'U'
    END 
FROM DUAL

By Ray Lee (System Analyst)

iDempeire ERP Contributor, 經濟部中小企業處財務管理顧問 李寶瑞

Leave a Reply

Your email address will not be published. Required fields are marked *