Clone Initial Accounting Tree from another Client

 

select
    u.value as "Account_Value",
    u."name" as "Account_Name",
    u.description as "Account_Description",
    adempiere.fnt_getref_listname(117, u.accounttype) as "Account_Type",
    adempiere.fnt_getref_listname(118, u.nat) as "Account_Sign",
    ''::varchar as "Account_Document",
    case u.issummary
        when 'Y' then 'Yes' else 'No'
    end::varchar as "Account_Summary",
    adempiere.fnt_getacctschema_default(u.c_elementvalue_id) as "Default_Account",
    u.parent_value as "Account_Parent",
    ''::varchar as "Balance Sheet",
    ''::varchar as "Balance Sheet_Name",
    ''::varchar as "US 1120 Balance Sheet",
    ''::varchar as "US 1120 Balance Sheet_Name",
    ''::varchar as "Profit & Loss",
    ''::varchar as "Profit & Loss_Name",
    ''::varchar as "US 1120 Income Statement",
    ''::varchar as "US 1120 Income Statement_Name",
    ''::varchar as "Cash Flow",
    ''::varchar as "Cash Flow_Name"
from usr_v_vcc u;

 

Referencias:

http://bseni.blogspot.com/2022/07/get-reference-list-name.html

http://bseni.blogspot.com/2022/07/get-accounting-schema-default.html