iDempiere

Specify EntityType based on roles.

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

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

Leave a Reply

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