-- Auto-generated oleh scripts/gen_seeds.py — JANGAN edit manual.
-- 105_department_account.sql — mapping akun per departemen dari master


INSERT INTO department_account (department_id, account_id, section, sort_order) VALUES
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='40.01.1.01'), 'REVENUE', 10),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='40.01.1.02'), 'REVENUE', 20),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='40.01.1.03'), 'REVENUE', 30),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.01'), 'PTER', 40),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.02'), 'PTER', 50),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.03'), 'PTER', 60),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.04'), 'PTER', 70),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.05'), 'PTER', 80),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.06'), 'PTER', 90),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.07'), 'PTER', 100),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.08'), 'OTHER_EXP', 110),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.09'), 'OTHER_EXP', 120),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.10'), 'OTHER_EXP', 130),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.11'), 'OTHER_EXP', 140),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.12'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.13'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.14'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.15'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.16'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.17'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.18'), 'OTHER_EXP', 210),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.19'), 'OTHER_EXP', 220),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.20'), 'OTHER_EXP', 230),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.21'), 'OTHER_EXP', 240),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.22'), 'OTHER_EXP', 250),
((SELECT id FROM department WHERE code='FO'), (SELECT id FROM coa_account WHERE code='60.01.1.23'), 'OTHER_EXP', 260),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.01'), 'PTER', 10),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.02'), 'PTER', 20),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.03'), 'PTER', 30),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.04'), 'PTER', 40),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.05'), 'PTER', 50),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.06'), 'PTER', 60),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.07'), 'PTER', 70),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.08'), 'OTHER_EXP', 80),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.09'), 'OTHER_EXP', 90),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.10'), 'OTHER_EXP', 100),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.11'), 'OTHER_EXP', 110),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.12'), 'OTHER_EXP', 120),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.13'), 'OTHER_EXP', 130),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.14'), 'OTHER_EXP', 140),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.15'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.16'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.17'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.18'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.19'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.20'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.21'), 'OTHER_EXP', 210),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.22'), 'OTHER_EXP', 220),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.23'), 'OTHER_EXP', 230),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.24'), 'OTHER_EXP', 240),
((SELECT id FROM department WHERE code='HK'), (SELECT id FROM coa_account WHERE code='60.01.2.25'), 'OTHER_EXP', 250),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='50.01.1.01'), 'COS', 10),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='50.01.1.02'), 'COS', 20),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='50.01.1.04'), 'OTHER_EXP', 30),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.01'), 'PTER', 40),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.02'), 'PTER', 50),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.03'), 'PTER', 60),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.04'), 'PTER', 70),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.05'), 'PTER', 80),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.06'), 'PTER', 90),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.07'), 'PTER', 100),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.08'), 'OTHER_EXP', 110),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.09'), 'OTHER_EXP', 120),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.10'), 'OTHER_EXP', 130),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.11'), 'OTHER_EXP', 140),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.12'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.13'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.34'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.15'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.16'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.17'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.18'), 'OTHER_EXP', 210),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.19'), 'OTHER_EXP', 220),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.20'), 'OTHER_EXP', 230),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.21'), 'OTHER_EXP', 240),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.22'), 'OTHER_EXP', 250),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.23'), 'OTHER_EXP', 260),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.24'), 'OTHER_EXP', 270),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.25'), 'OTHER_EXP', 280),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.26'), 'OTHER_EXP', 290),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.27'), 'OTHER_EXP', 300),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.28'), 'OTHER_EXP', 310),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.29'), 'OTHER_EXP', 320),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.30'), 'OTHER_EXP', 330),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.31'), 'OTHER_EXP', 340),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.32'), 'OTHER_EXP', 350),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='60.01.3.33'), 'OTHER_EXP', 360),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.01'), 'REVENUE', 370),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.02'), 'REVENUE', 380),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.03'), 'REVENUE', 390),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.04'), 'REVENUE', 400),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.05'), 'REVENUE', 410),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.06'), 'REVENUE', 420),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.07'), 'REVENUE', 430),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.08'), 'REVENUE', 440),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.09'), 'REVENUE', 450),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.10'), 'REVENUE', 460),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.11'), 'REVENUE', 470),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.12'), 'REVENUE', 480),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.13'), 'REVENUE', 490),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.14'), 'REVENUE', 500),
((SELECT id FROM department WHERE code='FB'), (SELECT id FROM coa_account WHERE code='40.01.2.15'), 'REVENUE', 510),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='40.01.3.01'), 'REVENUE', 10),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='40.01.3.02'), 'REVENUE', 20),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='40.01.3.03'), 'REVENUE', 30),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='40.01.3.04'), 'REVENUE', 40),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='50.01.2.01'), 'COS', 50),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='50.01.2.02'), 'COS', 60),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='50.01.2.03'), 'COS', 70),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.01'), 'PTER', 80),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.02'), 'PTER', 90),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.03'), 'PTER', 100),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.04'), 'PTER', 110),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.05'), 'PTER', 120),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.06'), 'PTER', 130),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.07'), 'PTER', 140),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.08'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.09'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.10'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.11'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.12'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.13'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.29'), 'OTHER_EXP', 210),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.15'), 'OTHER_EXP', 220),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.16'), 'OTHER_EXP', 230),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.17'), 'OTHER_EXP', 240),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.18'), 'OTHER_EXP', 250),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.19'), 'OTHER_EXP', 260),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.20'), 'OTHER_EXP', 270),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.21'), 'OTHER_EXP', 280),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.22'), 'OTHER_EXP', 290),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.23'), 'OTHER_EXP', 300),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.24'), 'OTHER_EXP', 310),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.25'), 'OTHER_EXP', 320),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.26'), 'OTHER_EXP', 330),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.27'), 'OTHER_EXP', 340),
((SELECT id FROM department WHERE code='SPA'), (SELECT id FROM coa_account WHERE code='60.01.4.28'), 'OTHER_EXP', 350),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='40.01.4.01'), 'REVENUE', 10),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='40.01.4.02'), 'REVENUE', 20),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='50.01.3.00'), 'COS', 30),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.01'), 'PTER', 40),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.02'), 'PTER', 50),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.03'), 'PTER', 60),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.04'), 'PTER', 70),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.05'), 'PTER', 80),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.06'), 'PTER', 90),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.07'), 'PTER', 100),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.08'), 'PTER', 110),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.09'), 'PTER', 120),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.10'), 'PTER', 130),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.11'), 'PTER', 140),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.12'), 'PTER', 150),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.1.13'), 'PTER', 160),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.01'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.02'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.03'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.04'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.05'), 'OTHER_EXP', 210),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.06'), 'OTHER_EXP', 220),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.07'), 'OTHER_EXP', 230),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.08'), 'OTHER_EXP', 240),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.09'), 'OTHER_EXP', 250),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.10'), 'OTHER_EXP', 260),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.11'), 'OTHER_EXP', 270),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.12'), 'OTHER_EXP', 280),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.13'), 'OTHER_EXP', 290),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.14'), 'OTHER_EXP', 300),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.21'), 'OTHER_EXP', 310),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.22'), 'OTHER_EXP', 320),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.91'), 'OTHER_EXP', 330),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.92'), 'OTHER_EXP', 340),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.93'), 'OTHER_EXP', 350),
((SELECT id FROM department WHERE code='LDY'), (SELECT id FROM coa_account WHERE code='63.01.2.99'), 'OTHER_EXP', 360),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='40.01.5.01'), 'OOI', 10),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='40.01.5.02'), 'OOI', 20),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='40.01.5.03'), 'OOI', 30),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='40.01.5.04'), 'OOI', 40),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='50.01.4.00'), 'OOI', 50),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.01'), 'PTER', 60),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.02'), 'PTER', 70),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.03'), 'PTER', 80),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.04'), 'PTER', 90),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.05'), 'PTER', 100),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.06'), 'PTER', 110),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.07'), 'PTER', 120),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.08'), 'OTHER_EXP', 130),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.09'), 'OTHER_EXP', 140),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.10'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.11'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.12'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.13'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.14'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.15'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.16'), 'OTHER_EXP', 210),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.17'), 'OTHER_EXP', 220),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.18'), 'OTHER_EXP', 230),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.19'), 'OTHER_EXP', 240),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.20'), 'OTHER_EXP', 250),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.21'), 'OTHER_EXP', 260),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.22'), 'OTHER_EXP', 270),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.26'), 'OTHER_EXP', 280),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.24'), 'OTHER_EXP', 290),
((SELECT id FROM department WHERE code='AG'), (SELECT id FROM coa_account WHERE code='60.01.5.25'), 'OTHER_EXP', 300),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.01'), 'PTER', 10),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.02'), 'PTER', 20),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.03'), 'PTER', 30),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.04'), 'PTER', 40),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.05'), 'PTER', 50),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.06'), 'PTER', 60),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.07'), 'PTER', 70),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.08'), 'PTER', 80),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.09'), 'PTER', 90),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.10'), 'PTER', 100),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.11'), 'PTER', 110),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.12'), 'PTER', 120),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.1.13'), 'PTER', 130),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.01'), 'OTHER_EXP', 140),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.03'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.04'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.05'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.06'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.07'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.08'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.09'), 'OTHER_EXP', 210),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.10'), 'OTHER_EXP', 220),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.11'), 'OTHER_EXP', 230),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.12'), 'OTHER_EXP', 240),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.13'), 'OTHER_EXP', 250),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.14'), 'OTHER_EXP', 260),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.15'), 'OTHER_EXP', 270),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.91'), 'OTHER_EXP', 280),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.92'), 'OTHER_EXP', 290),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.93'), 'OTHER_EXP', 300),
((SELECT id FROM department WHERE code='ICT'), (SELECT id FROM coa_account WHERE code='66.01.2.99'), 'OTHER_EXP', 310),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.01'), 'PTER', 10),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.02'), 'PTER', 20),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.03'), 'PTER', 30),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.04'), 'PTER', 40),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.05'), 'PTER', 50),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.06'), 'PTER', 60),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.07'), 'PTER', 70),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.08'), 'OTHER_EXP', 80),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.09'), 'OTHER_EXP', 90),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.10'), 'OTHER_EXP', 100),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.11'), 'OTHER_EXP', 110),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.12'), 'OTHER_EXP', 120),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.13'), 'OTHER_EXP', 130),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.14'), 'OTHER_EXP', 140),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.15'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.16'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.17'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.18'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='HC'), (SELECT id FROM coa_account WHERE code='60.01.6.19'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.01'), 'PTER', 10),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.02'), 'PTER', 20),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.03'), 'PTER', 30),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.04'), 'PTER', 40),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.05'), 'PTER', 50),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.06'), 'PTER', 60),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.07'), 'PTER', 70),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.08'), 'OTHER_EXP', 80),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.09'), 'OTHER_EXP', 90),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.10'), 'OTHER_EXP', 100),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.11'), 'OTHER_EXP', 110),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.12'), 'OTHER_EXP', 120),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.13'), 'OTHER_EXP', 130),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.14'), 'OTHER_EXP', 140),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.15'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.16'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.17'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.18'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.19'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='SM'), (SELECT id FROM coa_account WHERE code='60.01.7.20'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.01'), 'PTER', 10),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.02'), 'PTER', 20),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.03'), 'PTER', 30),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.04'), 'PTER', 40),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.05'), 'PTER', 50),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.06'), 'PTER', 60),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.07'), 'PTER', 70),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.08'), 'OTHER_EXP', 80),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.09'), 'OTHER_EXP', 90),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.10'), 'OTHER_EXP', 100),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.11'), 'OTHER_EXP', 110),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.12'), 'OTHER_EXP', 120),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.13'), 'OTHER_EXP', 130),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.14'), 'OTHER_EXP', 140),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.15'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.16'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.17'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.18'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.19'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.20'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.21'), 'OTHER_EXP', 210),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.22'), 'OTHER_EXP', 220),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.23'), 'OTHER_EXP', 230),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.24'), 'OTHER_EXP', 240),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.25'), 'OTHER_EXP', 250),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.26'), 'OTHER_EXP', 260),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.27'), 'OTHER_EXP', 270),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.28'), 'OTHER_EXP', 280),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.29'), 'OTHER_EXP', 290),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.8.30'), 'OTHER_EXP', 300),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.9.01'), 'OTHER_EXP', 310),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.9.02'), 'OTHER_EXP', 320),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.9.03'), 'OTHER_EXP', 330),
((SELECT id FROM department WHERE code='POM'), (SELECT id FROM coa_account WHERE code='60.01.9.04'), 'OTHER_EXP', 340),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.11.01'), 'OTHER_EXP', 10),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.11.02'), 'OTHER_EXP', 20),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.11.04'), 'OTHER_EXP', 30),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.11.03'), 'OTHER_EXP', 40),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.01'), 'OTHER_EXP', 50),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.02'), 'OTHER_EXP', 60),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.03'), 'OTHER_EXP', 70),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.04'), 'OTHER_EXP', 80),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.05'), 'OTHER_EXP', 90),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.06'), 'OTHER_EXP', 100),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.07'), 'OTHER_EXP', 110),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.08'), 'OTHER_EXP', 120),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.09'), 'OTHER_EXP', 130),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.10'), 'OTHER_EXP', 140),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.11'), 'OTHER_EXP', 150),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.12'), 'OTHER_EXP', 160),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.13'), 'OTHER_EXP', 170),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.14'), 'OTHER_EXP', 180),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.15'), 'OTHER_EXP', 190),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='60.01.10.16'), 'OTHER_EXP', 200),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='70.01.0.00'), 'OTHER_EXP', 210),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='70.01.0.01'), 'OTHER_EXP', 220),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='70.01.0.02'), 'OTHER_EXP', 230),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='70.01.0.03'), 'OTHER_EXP', 240),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.00'), 'OTHER_EXP', 250),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.01'), 'OTHER_EXP', 260),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.02'), 'OTHER_EXP', 270),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.03'), 'OTHER_EXP', 280),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.04'), 'OTHER_EXP', 290),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.05'), 'OTHER_EXP', 300),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.06'), 'OTHER_EXP', 310),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.07'), 'OTHER_EXP', 320),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.08'), 'OTHER_EXP', 330),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.09'), 'OTHER_EXP', 340),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.0.10'), 'OTHER_EXP', 350),
((SELECT id FROM department WHERE code='FIXED'), (SELECT id FROM coa_account WHERE code='80.01.1.00'), 'OTHER_EXP', 360)
ON DUPLICATE KEY UPDATE section=VALUES(section), sort_order=VALUES(sort_order);