-- Auto-generated oleh scripts/gen_seeds.py — JANGAN edit manual.
-- 102_coa.sql — tabel coa_account dari sheet 't_pos sanggra'


INSERT INTO coa_account (id, code, name, ftype_id, tipe_biaya, divisi) VALUES
(1, '10.01.1.01', 'Kas Kecil - General Cashier', 1, 'KAS', NULL),
(2, '10.01.1.02', 'Kas Kecil - Purchasing', 1, 'KAS', NULL),
(3, '10.01.1.03', 'House Bank - Front Office', 1, 'KAS', NULL),
(4, '10.01.1.04', 'House Bank - Restaurant', 1, 'KAS', NULL),
(5, '10.01.1.05', 'House Bank - Bar', 1, 'KAS', NULL),
(6, '10.01.1.06', 'House Bank - Spa', 1, 'KAS', NULL),
(7, '10.01.1.07', 'Cash In Transit', 1, 'KAS', NULL),
(8, '10.01.2.01', 'BCA Main (3429768889)', 1, 'BCA', NULL),
(9, '10.01.2.02', 'BCA Income (3428866900)', 1, 'BCA', NULL),
(10, '10.01.2.03', 'BCA Kredit (3427866800)', 1, 'BCA', NULL),
(11, '10.01.2.04', 'BCA Bali Expense (7725898088)', 1, 'BCA', NULL),
(12, '10.01.2.05', 'Bank Mandiri Giro (126-00-1193263-8)', 1, 'MANDIRI', NULL),
(13, '10.01.2.06', 'Bank Mandiri Bisnis (126-00-1193264-6)', 1, 'MANDIRI', NULL),
(14, '10.01.2.07', 'Maybank Kredit  (2003001211)', 1, 'MAYBANK', NULL),
(15, '10.01.2.08', 'Maybank (2003001311)', 1, 'MAYBANK', NULL),
(16, '10.01.3.01', 'Deposito Berjangka IDR', 1, NULL, NULL),
(17, '10.01.3.02', 'Deposito Berjangka Mata Uang Asing', 1, NULL, NULL),
(18, '11.01.1.01', 'FO Cash Clearance', 1, 'KAS', NULL),
(19, '11.01.1.02', 'FB Cash Clerance', 1, 'KAS', NULL),
(20, '11.01.1.03', 'SPA Cash Clerance', 1, 'KAS', NULL),
(21, '11.01.1.04', 'OTHER Cash Sales Clerance', 1, 'KAS', NULL),
(22, '11.01.1.05', 'Bank Transfer Clerance', 1, NULL, NULL),
(23, '11.01.1.06', 'Xendit in Transit', 1, 'XENDIT', NULL),
(24, '12.01.1.00', 'Piutang Usaha', 2, NULL, NULL),
(25, '12.01.1.01', 'Guest Ledger', 3, NULL, NULL),
(26, '12.01.1.02', 'City Ledger', 4, NULL, NULL),
(27, '12.01.1.03', 'Card & Online', 5, NULL, NULL),
(28, '12.01.1.04', 'Cadangan Kerugian Piutang', 6, NULL, NULL),
(29, '12.01.2.01', 'AR Other', 10, NULL, NULL),
(30, '12.01.2.02', 'AR Clearance', 10, NULL, NULL),
(31, '12.01.2.03', 'Due From..', 10, NULL, NULL),
(32, '13.01.1.01', 'Inventory Food', 7, NULL, NULL),
(33, '13.01.1.02', 'Inventory Beverage', 7, NULL, NULL),
(34, '13.01.1.03', 'Inventory Material', 7, NULL, NULL),
(35, '13.01.1.04', 'Inventory Engineering', 7, NULL, NULL),
(36, '13.01.1.05', 'Inventory Empty Bottle & Container', 7, NULL, NULL),
(37, '13.01.2.02', 'OE China & Glassware', 7, NULL, NULL),
(38, '13.01.2.03', 'OE Plastic Ware', 7, NULL, NULL),
(39, '13.01.2.04', 'OE Silverware & Cutleries', 7, NULL, NULL),
(40, '13.01.2.05', 'OE Utensil', 7, NULL, NULL),
(41, '13.01.2.06', 'OE Uniform', 7, NULL, NULL),
(42, '13.01.2.07', 'OE Others', 7, NULL, NULL),
(43, '13.01.2.08', 'Reserved OE Linen', 7, NULL, NULL),
(44, '13.01.2.09', 'Reserved OE China & Glass Ware', 7, NULL, NULL),
(45, '13.01.2.10', 'Reserved OE Plastic Ware', 7, NULL, NULL),
(46, '13.01.2.11', 'Reserved OE Silver & Cutleries', 7, NULL, NULL),
(47, '13.01.2.12', 'Reserved OE Utensil', 7, NULL, NULL),
(48, '13.01.2.13', 'Reserved OE Uniform', 7, NULL, NULL),
(49, '13.01.2.14', 'Reserved OE Others', 7, NULL, NULL),
(50, '13.01.2.01', 'OE Linen', 7, NULL, NULL),
(51, '14.01.1.01', 'Prepaid Contract & Maintenance', 12, NULL, NULL),
(52, '14.01.1.02', 'Prepaid Insurance', 12, NULL, NULL),
(53, '14.01.1.03', 'Prepaid License & Permit', 12, NULL, NULL),
(54, '14.01.1.04', 'Prepaid TV Channel, Internet, Online/Hotel System', 12, NULL, NULL),
(55, '14.01.1.05', 'Prepaid Advertising & Promotion', 12, NULL, NULL),
(56, '14.01.1.06', 'Prepaid Rent', 12, NULL, NULL),
(57, '14.01.1.07', 'Prepaid Others', 12, NULL, NULL),
(58, '14.01.1.08', 'Prepaid Tax PBB (Pajak Bumi & Bangunan)', 8, NULL, NULL),
(59, '14.01.1.09', 'Prepaid Tax Local (Daerah)', 8, NULL, NULL),
(60, '14.01.1.10', 'Prepaid Tax Pph 23', 8, NULL, NULL),
(61, '14.01.1.11', 'Prepaid Tax Pph 25', 8, NULL, NULL),
(62, '15.01.0.01', 'Uang Muka Pembelian', 9, NULL, NULL),
(63, '15.01.0.02', 'Uang Muka Perjalanan', 9, NULL, NULL),
(64, '15.01.0.03', 'Uang Muka Lain-lain', 9, NULL, NULL),
(65, '16.01.1.01', 'Land', 11, NULL, NULL),
(66, '16.01.1.02', 'Landscape & Garden', 11, NULL, NULL),
(67, '16.01.1.03', 'Building', 11, NULL, NULL),
(68, '16.01.1.04', 'Building Facilities', 11, NULL, NULL),
(69, '16.01.1.05', 'Building Not Permanent', 11, NULL, NULL),
(70, '16.01.1.06', 'Machinery/Installation/Metal & HVAC', 11, NULL, NULL),
(71, '16.01.1.07', 'Automobile', 11, NULL, NULL),
(72, '16.01.1.08', 'FFE Motorcycle', 11, NULL, NULL),
(73, '16.01.1.09', 'FFE Wood', 11, NULL, NULL),
(74, '16.01.1.11', 'FFE Office Equipment', 11, NULL, NULL),
(75, '16.01.1.12', 'FFE Kitchen Equipment', 11, NULL, NULL),
(76, '16.01.1.13', 'FFE Other Equipment', 11, NULL, NULL),
(77, '16.01.1.14', 'FA Transient', 11, NULL, NULL),
(78, '16.01.1.15', 'Sewa Tanah', 11, NULL, NULL),
(79, '16.01.2.01', 'CIP Landscape & Garden', 11, NULL, NULL),
(80, '16.01.2.02', 'CIP Building', 11, NULL, NULL),
(81, '16.01.2.03', 'CIP Building Facilities', 11, NULL, NULL),
(82, '16.01.2.04', 'CIP Lain-lain', 11, NULL, NULL),
(83, '17.01.1.01', 'Akumulasi Depresiasi Landscape & Garden', 13, NULL, NULL),
(84, '17.01.1.02', 'Akumulasi Depresiasi Building', 13, NULL, NULL),
(85, '17.01.1.03', 'Akumulasi Depresiasi Building Facilities', 13, NULL, NULL),
(86, '17.01.1.04', 'Akumulasi Depresiasi Building Not Permanent', 13, NULL, NULL),
(87, '17.01.1.05', 'Akumulasi Depresiasi Machinery/Installation/Metal & HVAC', 13, NULL, NULL),
(88, '17.01.1.06', 'Akumulasi Depresiasi Automobile', 13, NULL, NULL),
(89, '17.01.1.07', 'Akumulasi Depresiasi FFE Motorcycle', 13, NULL, NULL),
(90, '17.01.1.08', 'Akumulasi Depresiasi FFE Wood', 13, NULL, NULL),
(91, '17.01.1.09', 'Akumulasi Depresiasi FFE Office Equipment', 13, NULL, NULL),
(92, '17.01.1.10', 'Akumulasi Depresiasi FFE Kitchen Equipment', 13, NULL, NULL),
(93, '17.01.1.11', 'Akumulasi Depresiasi FFE Other Equipment', 13, NULL, NULL),
(94, '17.01.1.12', 'Akumulasi Depresiasi FA Transient', 13, NULL, NULL),
(95, '17.01.1.13', 'Akumulasi Depresiasi Sewa Tanah', 13, NULL, NULL),
(96, '18.01.1.02', 'Software', 14, NULL, NULL),
(97, '18.01.1.03', 'Jaminan', 14, NULL, NULL),
(98, '18.01.1.04', 'Lain-lain', 14, NULL, NULL),
(99, '18.01.1.01', 'Pre-Opening Expenses', 14, NULL, NULL),
(100, '19.01.1.01', 'Akumulasi Amortisasi Pre-Opening Expenses', 13, NULL, NULL),
(101, '19.01.1.02', 'Akumulasi Amortisasi Software', 13, NULL, NULL),
(102, '19.01.1.03', 'Akumulasi Amortisasi Lain-lain', 13, NULL, NULL),
(103, '20.01.1.01', 'A/P Trade', 16, NULL, NULL),
(104, '20.01.1.02', 'A/P Non Trade', 16, NULL, NULL),
(105, '20.01.1.03', 'A/P Others', 17, NULL, NULL),
(106, '20.01.2.01', 'A/P Service Charge', 17, NULL, NULL),
(107, '20.01.2.02', 'A/P Loss & Breakage', 17, NULL, NULL),
(108, '20.01.2.03', 'A/P Man Power Development', 17, NULL, NULL),
(109, '20.01.2.04', 'A/P Payment Clerance', 17, NULL, NULL),
(110, '20.01.2.05', 'A/P Receiving Clerance', 17, NULL, NULL),
(111, '20.01.2.06', 'A/P Offset Clearance', 17, NULL, NULL),
(112, '20.01.2.07', 'Due To..', 17, NULL, NULL),
(113, '20.02.1.02', 'Guest Deposit Package', 18, NULL, NULL),
(114, '20.02.1.03', 'Guest Deposit AR', 18, NULL, NULL),
(115, '20.02.1.01', 'Guest Deposit FO (Interface from System)', 18, NULL, NULL),
(116, '20.03.1.01', 'Hutang PPN', 19, NULL, NULL),
(117, '20.03.1.02', 'Hutang PPh 21/26', 19, NULL, NULL),
(118, '20.03.1.03', 'Hutang PPh 23', 19, NULL, NULL),
(119, '20.03.1.04', 'Hutang Pasal 4 Ayat 2', 19, NULL, NULL),
(120, '20.03.1.05', 'Hutang Pph 25/29', 19, NULL, NULL),
(121, '20.03.1.06', 'Hutang PBB', 19, NULL, NULL),
(122, '20.03.1.07', 'Hutang Local (Daerah)', 19, NULL, NULL),
(123, '20.03.1.08', 'Hutang PB1 (PBJT)', 19, NULL, NULL),
(124, '20.03.1.09', 'Hutang Pajak Lain-lain', 19, NULL, NULL),
(125, '20.04.1.01', 'Beban Akrual Utilitas', 23, NULL, NULL),
(126, '20.04.1.02', 'Beban Akrual Gaji (THR/BONUS/BPJS/Makan Karyawan)', 23, NULL, NULL),
(127, '20.04.1.03', 'Beban Akrual Travel Agent', 23, NULL, NULL),
(128, '20.04.1.04', 'Beban Akrual Music & Entertainment', 23, NULL, NULL),
(129, '20.04.1.05', 'Beban Akrual Limbah', 23, NULL, NULL),
(130, '20.04.1.06', 'Beban Akrual Rumah Tangga', 23, NULL, NULL),
(131, '20.04.1.07', 'Beban Akrual Transport', 23, NULL, NULL),
(132, '20.04.1.08', 'Beban Akrual Marketing/Iklan', 23, NULL, NULL),
(133, '20.04.1.09', 'Beban Akrual Asuransi', 23, NULL, NULL),
(134, '20.04.1.10', 'Beban Akrual Lain-lain', 23, NULL, NULL),
(135, '20.05.1.01', 'Bank Loan BCA', 15, NULL, NULL),
(136, '20.05.1.02', 'Bank Loan Mandiri', 15, NULL, NULL),
(137, '20.05.1.03', 'Leasing', 15, NULL, NULL),
(138, '20.05.1.04', 'Interest Loan', 15, NULL, NULL),
(139, '20.05.1.05', 'Head Office Account', 15, NULL, NULL),
(140, '20.05.1.06', 'Share Holder Loan Dian Anggraeni', 15, NULL, NULL),
(141, '20.05.1.07', 'Share Holder Loan Suhendrik', 15, NULL, NULL),
(142, '20.05.1.08', 'Share Holder Loan Harijadi Ramli', 15, NULL, NULL),
(143, '20.05.1.09', 'Hutang Jangka Panjang Lain-lain', 15, NULL, NULL),
(144, '20.05.1.10', 'Bank Loan Maybank', 15, NULL, NULL),
(145, '30.01.1.00', 'Modal Saham', 20, NULL, NULL),
(146, '30.01.1.01', 'Capital Stock', 20, NULL, NULL),
(147, '30.01.1.02', 'Share Holder Account', 20, NULL, NULL),
(148, '30.01.1.03', 'Chip In Capitals', 20, NULL, NULL),
(149, '30.01.2.01', 'Retained Earning', 22, NULL, NULL),
(150, '30.01.2.02', 'Dividends', 22, NULL, NULL),
(151, '30.01.2.03', 'Adjustment Prior Year', 22, NULL, NULL),
(152, '30.01.2.04', 'Current Monthly Profit and Loss', 22, NULL, NULL),
(153, '40.01.1.01', 'Penjualan Kamar', 52, NULL, NULL),
(154, '40.01.1.02', 'Penjualan Kamar Lainnya', 53, NULL, NULL),
(155, '40.01.1.03', 'Diskon Kamar', 79, NULL, NULL),
(156, '40.01.2.01', 'Penjualan Makanan di Restoran', 55, 'INCOME', NULL),
(157, '40.01.2.02', 'Penjualan Makanan di Bar', 56, 'INCOME', NULL),
(158, '40.01.2.03', 'Penjualan Makanan Layanan Kamar', 57, 'INCOME', NULL),
(159, '40.01.2.04', 'Penjualan Makanan Kelas Memasak', 58, 'INCOME', NULL),
(160, '40.01.2.05', 'Penjualan Makanan Banquet', 59, 'INCOME', NULL),
(161, '40.01.2.06', 'Penjualan Breakfast (Alokasi Room untuk Breakfast)', 60, 'INCOME', NULL),
(162, '40.01.2.07', 'Diskon Makanan', 79, 'INCOME', NULL),
(163, '40.01.2.08', 'Penjualan Minuman di Restoran', 62, 'INCOME', NULL),
(164, '40.01.2.09', 'Penjualan Minuman di Bar', 63, 'INCOME', NULL),
(165, '40.01.2.10', 'Penjualan Minuman Layanan Kamar', 64, 'INCOME', NULL),
(166, '40.01.2.11', 'Penjualan Minuman Kelas Memasak', 65, 'INCOME', NULL),
(167, '40.01.2.12', 'Penjualan Minuman Banquet', 66, 'INCOME', NULL),
(168, '40.01.2.13', 'Diskon Minuman', 79, 'INCOME', NULL),
(169, '40.01.2.14', 'Pendapatan Sewa', 68, 'INCOME', NULL),
(170, '40.01.2.15', 'Pendapatan F&B Lain-lain', 69, 'INCOME', NULL),
(171, '40.01.3.01', 'Penjualan SPA Treatment', 70, 'INCOME', NULL),
(172, '40.01.3.02', 'Penjualan SPA Retail', 71, 'INCOME', NULL),
(173, '40.01.3.03', 'Penjualan Activities', 72, 'INCOME', NULL),
(174, '40.01.3.04', 'Diskon SPA', 79, 'INCOME', NULL),
(175, '40.01.4.01', 'Laundry Tamu', 74, 'INCOME', NULL),
(176, '40.01.4.02', 'Diskon Laundry', 79, 'INCOME', NULL),
(177, '40.01.5.01', 'Pendapatan Transportasi', 76, 'INCOME', NULL),
(178, '40.01.5.02', 'Pendapatan Tur', 77, 'INCOME', NULL),
(179, '40.01.5.03', 'Pendapatan atas Kehilangan/Kerusakan', 78, 'INCOME', NULL),
(180, '40.01.5.04', 'Other Income', 78, 'INCOME', NULL),
(181, '50.01.1.01', 'HPP Makanan', 38, 'HPP', 'F&B'),
(182, '50.01.1.02', 'HPP Minuman', 39, 'HPP', 'F&B'),
(183, '50.01.1.03', 'HPP Breakfast', 40, 'HPP', 'F&B'),
(184, '50.01.2.01', 'HPP SPA Treatment', 41, 'HPP', 'SPA & ACTIVITY'),
(185, '50.01.2.02', 'HPP SPA Retail', 42, 'HPP', 'SPA & ACTIVITY'),
(186, '50.01.2.03', 'HPP Activities', 43, 'HPP', 'SPA & ACTIVITY'),
(187, '50.01.3.00', 'HPP Laundry', 44, 'HPP', 'RHK'),
(188, '50.01.4.00', 'HPP Usaha Lainnya', 45, 'HPP', NULL),
(189, '60.01.1.01', 'RFO Gaji & Upah (tetap, kontrak, harian)', 24, 'UPAH', 'RFO'),
(190, '60.01.1.02', 'RFO THR / Bonus', 24, 'UPAH', 'RFO'),
(191, '60.01.1.03', 'RFO Pajak ditanggung Perusahaan', 24, 'UPAH', 'RFO'),
(192, '60.01.1.04', 'RFO BPJS (JKK, JKM, JHT, Pensiun)', 24, 'UPAH', 'RFO'),
(193, '60.01.1.05', 'RFO Pesangon', 24, 'UPAH', 'RFO'),
(194, '60.01.1.06', 'RFO Tunjangan', 24, 'UPAH', 'RFO'),
(195, '60.01.1.07', 'RFO Makan/Suplemen/Seragam/Pengobatan/dll Karyawan', 24, 'UPAH', 'RFO'),
(196, '60.01.1.08', 'RFO Cleaning Supplies', 24, 'MATERIAL', 'RFO'),
(197, '60.01.1.09', 'RFO Guest Supplies', 24, 'MATERIAL', 'RFO'),
(198, '60.01.1.10', 'RFO Alat Tulis Kantor & Cetakan', 24, 'MATERIAL', 'RFO'),
(199, '60.01.1.11', 'RFO Dekorasi', 24, 'JASA', 'RFO'),
(200, '60.01.1.12', 'RFO Transportasi/Perjalanan', 24, 'JASA', 'RFO'),
(201, '60.01.1.13', 'RFO Berlangganan (Internet, telepon, koran, dll)', 24, 'JASA', 'RFO'),
(202, '60.01.1.14', 'RFO Pengiriman', 24, 'JASA', 'RFO'),
(203, '60.01.1.15', 'RFO Welcome Drink', 24, 'MATERIAL', 'RFO'),
(204, '60.01.1.16', 'RFO Fruit Basket', 24, 'MATERIAL', 'RFO'),
(205, '60.01.1.17', 'RFO Cake', 24, 'MATERIAL', 'RFO'),
(206, '60.01.1.18', 'RFO Guest Activities', 24, 'JASA', 'RFO'),
(207, '60.01.1.19', 'RFO Entertainment (Music, dll)', 24, 'JASA', 'RFO'),
(208, '60.01.1.20', 'RFO Barang Rusak & Hilang', 24, 'MATERIAL', 'RFO'),
(209, '60.01.1.21', 'RFO Travel Agent', 24, 'JASA', 'RFO'),
(210, '60.01.1.22', 'RFO Reservasi', 24, 'JASA', 'RFO'),
(211, '60.01.1.23', 'RFO Lain-lain', 24, NULL, 'RFO'),
(212, '60.01.2.01', 'RHK Gaji & Upah (tetap, kontrak, harian)', 25, 'UPAH', 'RHK'),
(213, '60.01.2.02', 'RHK THR / Bonus', 25, 'UPAH', 'RHK'),
(214, '60.01.2.03', 'RHK Pajak ditanggung Perusahaan', 25, 'UPAH', 'RHK'),
(215, '60.01.2.04', 'RHK BPJS (JKK, JKM, JHT, Pensiun)', 25, 'UPAH', 'RHK'),
(216, '60.01.2.05', 'RHK Pesangon', 25, 'UPAH', 'RHK'),
(217, '60.01.2.06', 'RHK Tunjangan', 25, 'UPAH', 'RHK'),
(218, '60.01.2.07', 'RHK Makan/Suplemen/Seragam/Pengobatan/dll Karyawan', 25, 'UPAH', 'RHK'),
(219, '60.01.2.08', 'RHK Cleaning Supplies', 25, 'MATERIAL', 'RHK'),
(220, '60.01.2.09', 'RHK Guest Supplies', 25, 'MATERIAL', 'RHK'),
(221, '60.01.2.10', 'RHK Alat Tulis Kantor & Cetakan', 25, 'MATERIAL', 'RHK'),
(222, '60.01.2.11', 'RHK Dekorasi', 25, 'JASA', 'RHK'),
(223, '60.01.2.12', 'RHK Transportasi/Perjalanan', 25, 'JASA', 'RHK'),
(224, '60.01.2.13', 'RHK Berlangganan (Internet, telepon, koran, dll)', 25, 'JASA', 'RHK'),
(225, '60.01.2.14', 'RHK Pengiriman', 25, 'JASA', 'RHK'),
(226, '60.01.2.15', 'RHK Barang Rusak & Hilang', 25, 'MATERIAL', 'RHK'),
(227, '60.01.2.16', 'RHK Laundry Linen', 25, 'JASA', 'RHK'),
(228, '60.01.2.17', 'RHK Sewa', 25, 'JASA', 'RHK'),
(229, '60.01.2.18', 'RHK Room Cost Allocation', 25, NULL, 'RHK'),
(230, '60.01.2.19', 'RHK OE Linen', 25, 'MATERIAL', 'RHK'),
(231, '60.01.2.20', 'RHK OE China & Glass Ware', 25, 'MATERIAL', 'RHK'),
(232, '60.01.2.21', 'RHK OE Plastic Ware', 25, 'MATERIAL', 'RHK'),
(233, '60.01.2.22', 'RHK OE Silver & Cutleries', 25, 'MATERIAL', 'RHK'),
(234, '60.01.2.23', 'RHK OE Utensil', 25, 'MATERIAL', 'RHK'),
(235, '60.01.2.24', 'RHK OE Others', 25, 'MATERIAL', 'RHK'),
(236, '60.01.2.25', 'RHK Lain-lain', 25, NULL, 'RHK'),
(237, '60.01.3.01', 'F&B Gaji & Upah (tetap, kontrak, harian)', 26, 'UPAH', 'F&B'),
(238, '60.01.3.02', 'F&B THR / Bonus', 26, 'UPAH', 'F&B'),
(239, '60.01.3.03', 'F&B Pajak ditanggung Perusahaan', 26, 'UPAH', 'F&B'),
(240, '60.01.3.04', 'F&B BPJS (JKK, JKM, JHT, Pensiun)', 26, 'UPAH', 'F&B'),
(241, '60.01.3.05', 'F&B Pesangon', 26, 'UPAH', 'F&B'),
(242, '60.01.3.06', 'F&B Tunjangan', 26, 'UPAH', 'F&B'),
(243, '60.01.3.07', 'F&B Makan/Suplemen/Seragam/Pengobatan/dll Karyawan', 26, 'UPAH', 'F&B'),
(244, '60.01.3.08', 'F&B Cleaning Supplies', 26, 'MATERIAL', 'F&B'),
(245, '60.01.3.09', 'F&B Guest Supplies', 26, 'MATERIAL', 'F&B'),
(246, '60.01.3.10', 'F&B Alat Tulis Kantor & Cetakan', 26, 'MATERIAL', 'F&B'),
(247, '60.01.3.11', 'F&B Dekorasi', 26, 'JASA', 'F&B'),
(248, '60.01.3.12', 'F&B Transportasi/Perjalanan', 26, 'JASA', 'F&B'),
(249, '60.01.3.13', 'F&B Berlangganan (Internet, telepon, koran, dll)', 26, 'JASA', 'F&B'),
(250, '60.01.3.14', 'F&B Pengiriman', 26, 'JASA', 'F&B'),
(251, '60.01.3.15', 'F&B Guest Activities', 26, 'MATERIAL', 'F&B'),
(252, '60.01.3.16', 'F&B Barang Rusak & Hilang', 26, 'MATERIAL', 'F&B'),
(253, '60.01.3.17', 'F&B Laundry Linen', 26, 'JASA', 'F&B'),
(254, '60.01.3.18', 'F&B Sewa', 26, 'JASA', 'F&B'),
(255, '60.01.3.19', 'F&B Entertainment (Music, dll)', 26, 'JASA', 'F&B'),
(256, '60.01.3.20', 'F&B Bar Supplies', 26, 'MATERIAL', 'F&B'),
(257, '60.01.3.21', 'F&B Kitchen Supplies', 26, 'MATERIAL', 'F&B'),
(258, '60.01.3.22', 'F&B Kitchen Fuels', 26, 'MATERIAL', 'F&B'),
(259, '60.01.3.23', 'F&B Product Testing', 26, 'MATERIAL', 'F&B'),
(260, '60.01.3.24', 'F&B Kompensasi & Komplain', 26, 'JASA', 'F&B'),
(261, '60.01.3.25', 'F&B OE Linen', 26, 'MATERIAL', 'F&B'),
(262, '60.01.3.26', 'F&B OE China & Glass Ware', 26, 'MATERIAL', 'F&B'),
(263, '60.01.3.27', 'F&B OE Plastic Ware', 26, 'MATERIAL', 'F&B'),
(264, '60.01.3.28', 'F&B OE Silver & Cutleries', 26, 'MATERIAL', 'F&B'),
(265, '60.01.3.29', 'F&B OE Utensil', 26, 'MATERIAL', 'F&B'),
(266, '60.01.3.30', 'F&B OE Others', 26, 'MATERIAL', 'F&B'),
(267, '60.01.3.31', 'F&B Lain-lain', 26, NULL, 'F&B'),
(268, '60.01.4.01', 'SPA & Activities Gaji & Upah (tetap, kontrak, harian)', 27, 'UPAH', 'SPA & ACTIVITY'),
(269, '60.01.4.02', 'SPA & Activities THR / Bonus', 27, 'UPAH', 'SPA & ACTIVITY'),
(270, '60.01.4.03', 'SPA & Activities Pajak ditanggung Perusahaan', 27, 'UPAH', 'SPA & ACTIVITY'),
(271, '60.01.4.04', 'SPA & Activities BPJS (JKK, JKM, JHT, Pensiun)', 27, 'UPAH', 'SPA & ACTIVITY'),
(272, '60.01.4.05', 'SPA & Activities Pesangon', 27, 'UPAH', 'SPA & ACTIVITY'),
(273, '60.01.4.06', 'SPA & Activities Tunjangan', 27, 'UPAH', 'SPA & ACTIVITY'),
(274, '60.01.4.07', 'SPA & Activities Makan/Suplemen/Seragam/Pengobatan/dll Karyawan', 27, 'UPAH', 'SPA & ACTIVITY'),
(275, '60.01.4.08', 'SPA & Activities Cleaning Supplies', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(276, '60.01.4.09', 'SPA & Activities Guest Supplies', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(277, '60.01.4.10', 'SPA & Activities Alat Tulis Kantor & Cetakan', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(278, '60.01.4.11', 'SPA & Activities Dekorasi', 27, 'JASA', 'SPA & ACTIVITY'),
(279, '60.01.4.12', 'SPA & Activities Transportasi/Perjalanan', 27, 'JASA', 'SPA & ACTIVITY'),
(280, '60.01.4.13', 'SPA & Activities Berlangganan (Internet, telepon, koran, dll)', 27, 'JASA', 'SPA & ACTIVITY'),
(281, '60.01.4.14', 'SPA & Activities Pengiriman', 27, 'JASA', 'SPA & ACTIVITY'),
(282, '60.01.4.15', 'SPA & Activities Welcome Drink', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(283, '60.01.4.16', 'SPA & Activities Product Testing', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(284, '60.01.4.17', 'SPA & Activities Guest Activities', 27, 'JASA', 'SPA & ACTIVITY'),
(285, '60.01.4.18', 'SPA & Activities Barang Rusak & Hilang', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(286, '60.01.4.19', 'SPA & Activities Laundry Linen', 27, 'JASA', 'SPA & ACTIVITY'),
(287, '60.01.4.20', 'SPA & Activities Kompensasi & Komplain', 27, 'JASA', 'SPA & ACTIVITY'),
(288, '60.01.4.21', 'SPA & Activities OE Linen', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(289, '60.01.4.22', 'SPA & Activities OE China & Glass Ware', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(290, '60.01.4.23', 'SPA & Activities OE Plastic Ware', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(291, '60.01.4.24', 'SPA & Activities OE Silver & Cutleries', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(292, '60.01.4.25', 'SPA & Activities OE Utensil', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(293, '60.01.4.26', 'SPA & Activities OE Others', 27, 'MATERIAL', 'SPA & ACTIVITY'),
(294, '60.01.4.27', 'PA & Activities Lain-lain', 27, NULL, 'SPA & ACTIVITY'),
(295, '60.01.5.01', 'A&G Gaji & Upah (tetap, kontrak, harian)', 28, 'UPAH', 'A&G'),
(296, '60.01.5.02', 'A&G THR / Bonus', 28, 'UPAH', 'A&G'),
(297, '60.01.5.03', 'A&G Pajak ditanggung Perusahaan', 28, 'UPAH', 'A&G'),
(298, '60.01.5.04', 'A&G BPJS (JKK, JKM, JHT, Pensiun)', 28, 'UPAH', 'A&G'),
(299, '60.01.5.05', 'A&G Pesangon', 28, 'UPAH', 'A&G'),
(300, '60.01.5.06', 'A&G Tunjangan', 28, 'UPAH', 'A&G'),
(301, '60.01.5.07', 'A&G Makan/Suplemen/Seragam/Pengobatan/dll Karyawan', 28, 'UPAH', 'A&G'),
(302, '60.01.5.08', 'A&G Alat Tulis Kantor & Cetakan', 28, 'MATERIAL', 'A&G'),
(303, '60.01.5.09', 'A&G Transportasi/Perjalanan', 28, 'JASA', 'A&G'),
(304, '60.01.5.10', 'A&G Berlangganan (Internet, telepon, koran, dll)', 28, 'JASA', 'A&G'),
(305, '60.01.5.11', 'A&G Pengiriman', 28, 'JASA', 'A&G'),
(306, '60.01.5.12', 'A&G Barang Rusak & Hilang', 28, 'MATERIAL', 'A&G'),
(307, '60.01.5.13', 'A&G Jasa (maintanance, training, pengembangan SDM, audit, dll)', 28, 'JASA', 'A&G'),
(308, '60.01.5.14', 'A&G Sewa', 28, 'JASA', 'A&G'),
(309, '60.01.5.15', 'A&G Entertain', 28, 'JASA', 'A&G'),
(310, '60.01.5.16', 'A&G Donasi', 28, 'JASA', 'A&G'),
(311, '60.01.5.17', 'A&G Kegiatan Sosial', 28, 'JASA', 'A&G'),
(312, '60.01.5.18', 'A&G Upacara', 28, 'JASA', 'A&G'),
(313, '60.01.5.19', 'A&G Biaya Bank', 28, 'JASA', 'A&G'),
(314, '60.01.5.20', 'A&G Kartu Kredit', 28, 'JASA', 'A&G'),
(315, '60.01.5.21', 'A&G Perizinan', 28, 'JASA', 'A&G'),
(316, '60.01.5.22', 'A&G Biaya Penagihan', 28, 'JASA', 'A&G'),
(317, '60.01.5.23', 'A&G Lain-lain', 28, NULL, 'A&G'),
(318, '60.01.5.24', 'A&G Retribusi', 28, 'JASA', 'A&G'),
(319, '60.01.6.01', 'HRD Gaji & Upah (tetap, kontrak, harian)', 29, 'UPAH', 'HRD'),
(320, '60.01.6.02', 'HRD THR / Bonus', 29, 'UPAH', 'HRD'),
(321, '60.01.6.03', 'HRD Pajak ditanggung Perusahaan', 29, 'UPAH', 'HRD'),
(322, '60.01.6.04', 'HRD BPJS (JKK, JKM, JHT, Pensiun)', 29, 'UPAH', 'HRD'),
(323, '60.01.6.05', 'HRD Pesangon', 29, 'UPAH', 'HRD'),
(324, '60.01.6.06', 'HRD Tunjangan', 29, 'UPAH', 'HRD'),
(325, '60.01.6.07', 'HRD Makan/Suplemen/Seragam/Pengobatan/dll Karyawan', 29, 'UPAH', 'HRD'),
(326, '60.01.6.08', 'HRD Alat Tulis Kantor & Cetakan', 29, 'MATERIAL', 'HRD'),
(327, '60.01.6.09', 'HRD Dekorasi', 29, 'JASA', 'HRD'),
(328, '60.01.6.10', 'HRD Transportasi/Perjalanan', 29, 'JASA', 'HRD'),
(329, '60.01.6.11', 'HRD Berlangganan (Internet, telepon, koran, dll)', 29, 'JASA', 'HRD'),
(330, '60.01.6.12', 'HRD Pengiriman', 29, 'JASA', 'HRD'),
(331, '60.01.6.13', 'HRD Barang Rusak & Hilang', 29, 'MATERIAL', 'HRD'),
(332, '60.01.6.14', 'HRD Jasa (maintanance, training, pengembangan SDM, audit, dll)', 29, 'JASA', 'HRD'),
(333, '60.01.6.15', 'HRD Sewa', 29, 'JASA', 'HRD'),
(334, '60.01.6.16', 'HRD Kegiatan Karyawan (Suka-Duka)', 29, 'JASA', 'HRD'),
(335, '60.01.6.17', 'HRD P3K', 29, 'JASA', 'HRD'),
(336, '60.01.6.18', 'HRD Lain-lain', 29, NULL, 'HRD'),
(337, '60.01.6.19', 'HRD Training/Pelatihan', 29, 'JASA', 'HRD'),
(338, '60.01.7.01', 'S&M Gaji & Upah (tetap, kontrak, harian)', 30, 'UPAH', 'S&M'),
(339, '60.01.7.02', 'S&M THR / Bonus', 30, 'UPAH', 'S&M'),
(340, '60.01.7.03', 'S&M Pajak ditanggung Perusahaan', 30, 'UPAH', 'S&M'),
(341, '60.01.7.04', 'S&M BPJS (JKK, JKM, JHT, Pensiun)', 30, 'UPAH', 'S&M'),
(342, '60.01.7.05', 'S&M Pesangon', 30, 'UPAH', 'S&M'),
(343, '60.01.7.06', 'S&M Tunjangan', 30, 'UPAH', 'S&M'),
(344, '60.01.7.07', 'S&M Makan/Suplemen/Seragam/Pengobatan/dll Karyawan', 30, 'UPAH', 'S&M'),
(345, '60.01.7.08', 'S&M Alat Tulis Kantor & Cetakan', 30, 'MATERIAL', 'S&M'),
(346, '60.01.7.09', 'S&M Transportasi/Perjalanan', 30, 'JASA', 'S&M'),
(347, '60.01.7.10', 'S&M Berlangganan (Internet, telepon, koran, dll)', 30, 'JASA', 'S&M'),
(348, '60.01.7.11', 'S&M Pengiriman', 30, 'JASA', 'S&M'),
(349, '60.01.7.12', 'S&M Barang Rusak & Hilang', 30, 'MATERIAL', 'S&M'),
(350, '60.01.7.13', 'S&M Entertain', 30, 'JASA', 'S&M'),
(351, '60.01.7.14', 'S&M Promosi & Iklan', 30, 'JASA', 'S&M'),
(352, '60.01.7.15', 'S&M Sponsorship', 30, 'JASA', 'S&M'),
(353, '60.01.7.16', 'S&M Joint Marketing', 30, 'JASA', 'S&M'),
(354, '60.01.7.17', 'S&M Trade Shows', 30, 'JASA', 'S&M'),
(355, '60.01.7.18', 'S&M Sales Call / Sales Trip', 30, 'JASA', 'S&M'),
(356, '60.01.7.19', 'S&M Public Relation', 30, 'JASA', 'S&M'),
(357, '60.01.7.20', 'S&M Lain-lain', 30, NULL, 'S&M'),
(358, '60.01.8.01', 'POM Gaji & Upah (tetap, kontrak, harian)', 31, 'UPAH', 'POM'),
(359, '60.01.8.02', 'POM THR / Bonus', 31, 'UPAH', 'POM'),
(360, '60.01.8.03', 'POM Pajak ditanggung Perusahaan', 31, 'UPAH', 'POM'),
(361, '60.01.8.04', 'POM BPJS (JKK, JKM, JHT, Pensiun)', 31, 'UPAH', 'POM'),
(362, '60.01.8.05', 'POM Pesangon', 31, 'UPAH', 'POM'),
(363, '60.01.8.06', 'POM Tunjangan', 31, 'UPAH', 'POM'),
(364, '60.01.8.07', 'POM Makan/Suplemen/Seragam/Pengobatan/dll Karyawan', 31, 'UPAH', 'POM'),
(365, '60.01.8.08', 'POM Alat Tulis Kantor & Cetakan', 31, 'MATERIAL', 'POM'),
(366, '60.01.8.09', 'POM Transportasi/Perjalanan', 31, 'JASA', 'POM'),
(367, '60.01.8.10', 'POM Berlangganan (Internet, telepon, koran, dll)', 31, 'JASA', 'POM'),
(368, '60.01.8.11', 'POM Pengiriman', 31, 'JASA', 'POM'),
(369, '60.01.8.12', 'POM Barang Rusak & Hilang', 31, 'MATERIAL', 'POM'),
(370, '60.01.8.13', 'POM Jasa (Pemeliharaan dan Perbaikan )', 31, 'JASA', 'POM'),
(371, '60.01.8.14', 'POM Sewa', 31, 'JASA', 'POM'),
(372, '60.01.8.15', 'POM Limbah', 31, 'JASA', 'POM'),
(373, '60.01.8.16', 'POM Plumbing', 31, 'JASA', 'POM'),
(374, '60.01.8.17', 'POM Light Bulbs', 31, 'JASA', 'POM'),
(375, '60.01.8.18', 'POM Power Plant', 31, 'JASA', 'POM'),
(376, '60.01.8.19', 'POM Tools', 31, 'JASA', 'POM'),
(377, '60.01.8.20', 'POM Life / Safety', 31, 'JASA', 'POM'),
(378, '60.01.8.21', 'POM Building & Painting', 31, 'JASA', 'POM'),
(379, '60.01.8.22', 'POM Vehicle', 31, 'JASA', 'POM'),
(380, '60.01.8.23', 'POM Swimming Pool & Pond', 31, 'JASA', 'POM'),
(381, '60.01.8.24', 'POM Kitchen Equipment', 31, 'JASA', 'POM'),
(382, '60.01.8.25', 'POM Furniture Equipment', 31, 'JASA', 'POM'),
(383, '60.01.8.26', 'POM HVAC Equipment', 31, 'JASA', 'POM'),
(384, '60.01.8.27', 'POM Electric & Mechanical Equipment', 31, 'JASA', 'POM'),
(385, '60.01.8.28', 'POM General Operating Equipment', 31, 'JASA', 'POM'),
(386, '60.01.8.29', 'POM Lift & Escalator', 31, 'JASA', 'POM'),
(387, '60.01.8.30', 'POM Farm', 31, 'JASA', 'POM'),
(388, '60.01.9.01', 'UEC Listrik', 32, 'JASA', NULL),
(389, '60.01.9.02', 'UEC Bahan Bakar', 32, 'MATERIAL', NULL),
(390, '60.01.9.03', 'UEC Air', 32, 'JASA', NULL),
(391, '60.01.9.04', 'UEC Gas', 32, 'MATERIAL', NULL),
(392, '60.01.10.01', 'Biaya Depresiasi Landscape & Garden', 33, NULL, NULL),
(393, '60.01.10.02', 'Biaya Depresiasi Building', 33, NULL, NULL),
(394, '60.01.10.03', 'Biaya Depresiasi Building Facilities', 33, NULL, NULL),
(395, '60.01.10.04', 'Biaya Depresiasi Building Not Permanent', 33, NULL, NULL),
(396, '60.01.10.05', 'Biaya Depresiasi Machinery/Installation/Metal & HVAC', 33, NULL, NULL),
(397, '60.01.10.06', 'Biaya Depresiasi Automobile', 33, NULL, NULL),
(398, '60.01.10.07', 'Biaya Depresiasi FFE Motorcycle', 33, NULL, NULL),
(399, '60.01.10.08', 'Biaya Depresiasi FFE Wood', 33, NULL, NULL),
(400, '60.01.10.09', 'Biaya Depresiasi FFE Office Equipment', 33, NULL, NULL),
(401, '60.01.10.10', 'Biaya Depresiasi FFE Kitchen Equipment', 33, NULL, NULL),
(402, '60.01.10.11', 'Biaya Depresiasi FFE Other Equipment', 33, NULL, NULL),
(403, '60.01.10.12', 'Biaya Depresiasi FA Transient', 33, NULL, NULL),
(404, '60.01.10.13', 'Biaya Depresiasi Sewa Tanah', 33, NULL, NULL),
(405, '60.01.10.14', 'Biaya Amortisasi Pre-Opening Expenses', 33, NULL, NULL),
(406, '60.01.10.15', 'Biaya Amortisasi Software', 33, NULL, NULL),
(407, '60.01.10.16', 'Biaya Amortisasi Lain-lain', 33, NULL, NULL),
(408, '60.01.11.01', 'Insentif & Management Fee', 34, 'JASA', NULL),
(409, '60.01.11.02', 'Beban Pajak PBB', 35, NULL, NULL),
(410, '60.01.11.03', 'Beban Asuransi', 36, NULL, NULL),
(411, '60.01.11.04', 'Kewajiban Pihak Ketiga', 36, NULL, NULL),
(412, '60.01.11.05', 'Beban Pajak', 35, NULL, NULL),
(413, '70.01.0.01', 'Pendapatan Bunga', 78, 'INCOME', NULL),
(414, '70.01.0.02', 'Pendapatan atas Penjualan Aset', 78, 'INCOME', NULL),
(415, '70.01.0.03', 'Pendapatan Lain-lain', 78, 'INCOME', NULL),
(416, '80.01.0.01', 'Beban Bunga', 36, NULL, NULL),
(417, '80.01.0.02', 'Beban Bungan Pinjaman', 36, NULL, NULL),
(418, '80.01.0.03', 'Pembulatan', 36, NULL, NULL),
(419, '80.01.0.04', 'Beban Pajak (Denda, STP, dll)', 35, NULL, NULL),
(420, '80.01.0.05', 'Beban Pajak (Final)', 35, NULL, NULL),
(421, '80.01.0.06', 'Donasi', 36, NULL, NULL),
(422, '80.01.0.07', 'Kegiatan Sosial', 36, NULL, NULL),
(423, '80.01.0.08', 'Upacara', 36, NULL, NULL),
(424, '80.01.0.09', 'Retribusi', 36, NULL, NULL),
(425, '80.01.1.00', 'Laba (Rugi) Pelepasan Aset Tetap', 78, NULL, NULL),
(426, '90.01.1.00', 'Corporate Income Tax', 78, 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);
