-- Auto-generated oleh scripts/gen_seeds.py — JANGAN edit manual.
-- 101_ftype.sql — tabel ftype dari sheet 'ftype sanggra'


INSERT INTO ftype (id, name, weight, weight2, level1, level2, normal_balance, report) VALUES
(1, 'Cash & Bank', 100, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(2, 'Piutang Usaha', 101, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(3, 'Guest Ledger', 103, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(4, 'City Ledger', 104, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(5, 'Card & Online', 105, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(6, 'Cadangan Kerugian Piutang', 106, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(7, 'Inventory', 107, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(8, 'Uang Muka Pajak', 108, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(9, 'Uang Muka Pembelian', 109, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(10, 'Other Current Assets', 110, 11, 'Aset', 'Aset Lancar', 'D-K', 'BS'),
(11, 'Aset Tetap', 201, 12, 'Aset', 'Aset tidak Lancar', 'D-K', 'BS'),
(12, 'Pajak Dibayar Dimuka', 202, 12, 'Aset', 'Aset tidak Lancar', 'D-K', 'BS'),
(13, 'Depreciation & Amortization', 203, 12, 'Aset', 'Aset tidak Lancar', 'D-K', 'BS'),
(14, 'Aset Lain-Lain', 204, 12, 'Aset', 'Aset tidak Lancar', 'D-K', 'BS'),
(15, 'Hutang Bank', 301, 13, 'Liability dan Ekuitas', 'Liability', 'K-D', 'BS'),
(16, 'Hutang Usaha', 302, 13, 'Liability dan Ekuitas', 'Liability', 'K-D', 'BS'),
(17, 'A/P Others', 303, 13, 'Liability dan Ekuitas', 'Liability', 'K-D', 'BS'),
(18, 'Deposit', 304, 13, 'Liability dan Ekuitas', 'Liability', 'K-D', 'BS'),
(19, 'Hutang Pajak', 305, 13, 'Liability dan Ekuitas', 'Liability', 'K-D', 'BS'),
(20, 'Modal Saham', 306, 14, 'Liability dan Ekuitas', 'Ekuitas', 'K-D', 'BS'),
(21, 'Ekuitas Lainnya', 307, 14, 'Liability dan Ekuitas', 'Ekuitas', 'K-D', 'BS'),
(22, 'Retained Earning', 308, 14, 'Liability dan Ekuitas', 'Ekuitas', 'K-D', 'BS'),
(23, 'Beban Akrual - dibayar dimuka', 205, 12, 'Aset', 'Aset Tidak Lancar', 'D-K', 'BS'),
(24, 'Beban Room Front Office (RFO)', 401, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(25, 'Beban Room House Keeping (RHK)', 402, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(26, 'Beban Food & Beverage (F&B)', 403, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(27, 'Beban SPA & Activities', 404, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(28, 'Beban Admin & General (A&G)', 405, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(29, 'Beban Human Resources Department (HRD)', 406, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(30, 'Beban Sales & Marketing (S&M)', 407, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(31, 'Beban Property Power Maintanance (POM)', 408, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(32, 'Beban Utilities Energy Cost', 409, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(33, 'Beban Depresiasi & Amortisasi', 410, 4, NULL, 'Beban Usaha', 'D-K', 'PL'),
(34, 'Insentif & Management Fee', 523, 7, NULL, 'Insentif & Management Fee', 'D-K', 'PL'),
(35, 'Beban Pajak', 521, 8, NULL, 'Beban Pajak', 'D-K', 'PL'),
(36, 'Beban lain-lain', 522, 8, NULL, 'Beban Lain', 'D-K', 'PL'),
(37, 'HPP F&B', 411, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(38, 'HPP Makanan', 412, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(39, 'HPP Minuman', 413, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(40, 'HPP Breakfast', 414, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(41, 'HPP SPA', 415, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(42, 'HPP SPA Treatment', 416, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(43, 'HPP SPA Retail', 417, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(44, 'HPP Activities', 418, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(45, 'HPP Laundry', 419, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(46, 'HPP Usaha Lainnya', 420, 2, NULL, 'Beban Pokok Pendapatan', 'D-K', 'PL'),
(47, 'Laba Tahun Berjalan', 520, 14, 'Liability dan Ekuitas', 'Ekuitas', 'K-D', 'BS'),
(48, 'Laba Kotor', 421, 3, NULL, 'Laba Kotor', 'D-K', 'PL'),
(49, 'Laba Sebelum Pajak', 524, 5, NULL, 'Laba Usaha', 'D-K', 'PL'),
(52, 'Penjualan Kamar', 701, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(53, 'Penjualan Kamar Lainnya', 702, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(55, 'Penjualan Makanan di Restoran', 703, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(56, 'Penjualan Makanan di Bar', 704, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(57, 'Penjualan Makanan Layanan Kamar', 705, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(58, 'Penjualan Makanan Kelas Memasak', 706, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(59, 'Penjualan Makanan Banquet', 707, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(60, 'Penjualan Breakfast (Alokasi Room untuk Breakfast)', 708, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(62, 'Penjualan Minuman di Restoran', 709, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(63, 'Penjualan Minuman di Bar', 710, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(64, 'Penjualan Minuman Layanan Kamar', 711, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(65, 'Penjualan Minuman Kelas Memasak', 712, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(66, 'Penjualan Minuman Banquet', 713, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(68, 'Pendapatan Sewa', 714, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(69, 'Pendapatan F&B Lain-lain', 715, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(70, 'Penjualan SPA Treatment', 716, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(71, 'Penjualan SPA Retail', 717, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(72, 'Penjualan Activities', 718, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(74, 'Laundry Tamu', 719, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(76, 'Pendapatan Transportasi', 720, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(77, 'Pendapatan Tur', 721, 1, NULL, 'Pendapatan', 'K-D', 'PL'),
(78, 'Other Income', 525, 6, NULL, 'Penghasilan Lain', 'K-D', 'PL'),
(79, 'Diskon', 722, 1, NULL, 'Penghasilan Lain', 'K-D', 'PL')
ON DUPLICATE KEY UPDATE name=VALUES(name), weight=VALUES(weight), weight2=VALUES(weight2),
  level1=VALUES(level1), level2=VALUES(level2), normal_balance=VALUES(normal_balance), report=VALUES(report);
