-- Auto-generated oleh scripts/gen_seeds_extra.py — JANGAN edit manual.
-- 102b_coa_extra.sql — ADR-004: 75 akun master (LAUNDRY/ICT/F&B/SPA/A&G/NOIE) tak ada di t_pos lama


INSERT INTO coa_account (id, code, name, ftype_id, tipe_biaya, divisi) VALUES
(427, '50.01.1.04', 'HPP F&B lain-lain - Cost of Other FB', 26, NULL, 'F&B'),
(428, '60.01.3.34', 'F&B POS System', 26, NULL, 'F&B'),
(429, '60.01.3.32', 'F&B Travel Agent', 26, NULL, 'F&B'),
(430, '60.01.3.33', 'F&B Promosi & Iklan', 26, NULL, 'F&B'),
(431, '60.01.4.29', 'SPA & Activities Pos System', 27, NULL, 'SPA & ACTIVITY'),
(432, '60.01.4.28', 'SPA & Activities Travel Agent', 27, NULL, 'SPA & ACTIVITY'),
(433, '63.01.1.01', 'Salaries & Wages', 80, NULL, 'LDY'),
(434, '63.01.1.02', 'Casual Worker', 80, NULL, 'LDY'),
(435, '63.01.1.03', 'THR / Bonus', 80, NULL, 'LDY'),
(436, '63.01.1.04', 'Tax Paid by Company (Gross Up)', 80, NULL, 'LDY'),
(437, '63.01.1.05', 'Supplemental Pay', 80, NULL, 'LDY'),
(438, '63.01.1.06', 'BPJS . TK (JKK,JKM)', 80, NULL, 'LDY'),
(439, '63.01.1.07', 'BJPS . TK (JHT&Pension)', 80, NULL, 'LDY'),
(440, '63.01.1.08', 'BPJS . Kesehatan / Medical Exp', 80, NULL, 'LDY'),
(441, '63.01.1.09', 'Employee Transports', 80, NULL, 'LDY'),
(442, '63.01.1.10', 'Employee Meal', 80, NULL, 'LDY'),
(443, '63.01.1.11', 'Employee Housing', 80, NULL, 'LDY'),
(444, '63.01.1.12', 'Severance Pay', 80, NULL, 'LDY'),
(445, '63.01.1.13', 'Other PTER Expenses', 80, NULL, 'LDY'),
(446, '63.01.2.01', 'Cleaning Supplies', 80, NULL, 'LDY'),
(447, '63.01.2.02', 'Guest Supplies', 80, NULL, 'LDY'),
(448, '63.01.2.03', 'Printing & Stationary', 80, NULL, 'LDY'),
(449, '63.01.2.04', 'Decoration & Florist', 80, NULL, 'LDY'),
(450, '63.01.2.05', 'Transportation', 80, NULL, 'LDY'),
(451, '63.01.2.06', 'Traveling Expenses', 80, NULL, 'LDY'),
(452, '63.01.2.07', 'Subscription & Newspaper', 80, NULL, 'LDY'),
(453, '63.01.2.08', 'Telecommunications', 80, NULL, 'LDY'),
(454, '63.01.2.09', 'Postage & Courier', 80, NULL, 'LDY'),
(455, '63.01.2.10', 'Internet Expenses', 80, NULL, 'LDY'),
(456, '63.01.2.11', 'Laundry Linen', 80, NULL, 'LDY'),
(457, '63.01.2.12', 'Contract Service', 80, NULL, 'LDY'),
(458, '63.01.2.13', 'Equipment Rental', 80, NULL, 'LDY'),
(459, '63.01.2.14', 'Supplies', 80, NULL, 'LDY'),
(460, '63.01.2.21', 'Program', 80, NULL, 'LDY'),
(461, '63.01.2.22', 'Guest Complain Expenses', 80, NULL, 'LDY'),
(462, '63.01.2.91', 'Loss & Damage', 80, NULL, 'LDY'),
(463, '63.01.2.92', 'Laundry Uniform', 80, NULL, 'LDY'),
(464, '63.01.2.93', 'Uniform Expenses', 80, NULL, 'LDY'),
(465, '63.01.2.99', 'Miscellaneous / Distribution', 80, NULL, 'LDY'),
(466, '60.01.5.26', 'A&G BO System', 28, NULL, 'A&G'),
(467, '60.01.5.25', 'A&G IT MAINTENANCE', 28, NULL, 'A&G'),
(468, '66.01.1.01', 'Salaries & Wages', 81, NULL, 'ICT'),
(469, '66.01.1.02', 'Casual Worker', 81, NULL, 'ICT'),
(470, '66.01.1.03', 'THR / Bonus', 81, NULL, 'ICT'),
(471, '66.01.1.04', 'Tax Paid by Company (Gross Up)', 81, NULL, 'ICT'),
(472, '66.01.1.05', 'Supplemental Pay', 81, NULL, 'ICT'),
(473, '66.01.1.06', 'BPJS . TK (JKK,JKM)', 81, NULL, 'ICT'),
(474, '66.01.1.07', 'BJPS . TK (JHT&Pension)', 81, NULL, 'ICT'),
(475, '66.01.1.08', 'BPJS . Kesehatan / Medical Exp', 81, NULL, 'ICT'),
(476, '66.01.1.09', 'Employee Transports', 81, NULL, 'ICT'),
(477, '66.01.1.10', 'Employee Meal', 81, NULL, 'ICT'),
(478, '66.01.1.11', 'Employee Housing', 81, NULL, 'ICT'),
(479, '66.01.1.12', 'Severance Pay', 81, NULL, 'ICT'),
(480, '66.01.1.13', 'Other PTER Expenses', 81, NULL, 'ICT'),
(481, '66.01.2.01', 'Cleaning Supplies', 81, NULL, 'ICT'),
(482, '66.01.2.03', 'Printing & Stationary', 81, NULL, 'ICT'),
(483, '66.01.2.04', 'Decoration & Florist', 81, NULL, 'ICT'),
(484, '66.01.2.05', 'Transportation', 81, NULL, 'ICT'),
(485, '66.01.2.06', 'Traveling Expenses', 81, NULL, 'ICT'),
(486, '66.01.2.07', 'Subscription & Newspaper', 81, NULL, 'ICT'),
(487, '66.01.2.08', 'Telecommunications', 81, NULL, 'ICT'),
(488, '66.01.2.09', 'Postage & Courier', 81, NULL, 'ICT'),
(489, '66.01.2.10', 'Internet Expenses', 81, NULL, 'ICT'),
(490, '66.01.2.11', 'Computer Maintenance', 81, NULL, 'ICT'),
(491, '66.01.2.12', 'Telecommunication Maintenance', 81, NULL, 'ICT'),
(492, '66.01.2.13', 'Software License & Maintenance', 81, NULL, 'ICT'),
(493, '66.01.2.14', 'E.Commerce Maintenance', 81, NULL, 'ICT'),
(494, '66.01.2.15', 'Tools', 81, NULL, 'ICT'),
(495, '66.01.2.91', 'Loss & Damage', 81, NULL, 'ICT'),
(496, '66.01.2.92', 'Laundry Uniform', 81, NULL, 'ICT'),
(497, '66.01.2.93', 'Uniform Expenses', 81, NULL, 'ICT'),
(498, '66.01.2.99', 'Miscellaneous', 81, NULL, 'ICT'),
(499, '70.01.0.00', 'Pendapatan Non-Operasional', 36, NULL, NULL),
(500, '80.01.0.00', 'Beban Non-Operasional', 36, NULL, NULL),
(501, '80.01.0.10', 'Penyesuain Stock', 36, NULL, NULL)
ON DUPLICATE KEY UPDATE code=VALUES(code), name=VALUES(name), ftype_id=VALUES(ftype_id),
  tipe_biaya=VALUES(tipe_biaya), divisi=VALUES(divisi);
