/*
 Navicat Premium Data Transfer

 Source Server         : LOCAL-POSTGRES
 Source Server Type    : PostgreSQL
 Source Server Version : 130004
 Source Host           : 127.0.0.1:5432
 Source Catalog        : klinikkeuanganklinik
 Source Schema         : public

 Target Server Type    : PostgreSQL
 Target Server Version : 130004
 File Encoding         : 65001

 Date: 15/01/2022 18:05:19
*/


-- ----------------------------
-- Table structure for ref_akun
-- ----------------------------
DROP TABLE IF EXISTS "public"."ref_akun";
CREATE TABLE "public"."ref_akun" (
  "id" int8 PRIMARY KEY,
  "id_induk" int8,
  "kode_akun" varchar(255) COLLATE "pg_catalog"."default",
  "nama_akun" varchar(255) COLLATE "pg_catalog"."default",
  "posisi" CHAR(1),
  "tingkat_akun" int8,
  "saldo_awal" BIGINT
)
;
ALTER TABLE "public"."ref_akun" OWNER TO "postgres";

-- ----------------------------
-- Records of ref_akun
-- ----------------------------
BEGIN;
INSERT INTO "public"."ref_akun" VALUES (1, NULL, '10000', 'ASET', 'd', 1, null);
INSERT INTO "public"."ref_akun" VALUES (2, 1, '10100', 'KAS DAN BANK', 'd', 2, null);
INSERT INTO "public"."ref_akun" VALUES (3, 2, '10101', 'Kas Tunai', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (4, 2, '10102', 'Kas Bank', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (5, 1, '10200', 'PIUTANG', 'd', 2, null);
INSERT INTO "public"."ref_akun" VALUES (6, 5, '10201', 'Piutang Usaha', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (7, 5, '10202', 'Piutang Karyawan', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (8, 5, '10203', 'Piutang Lain-lain', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (9, 1, '10300', 'PERSEDIAAN', 'd', 2, null);
INSERT INTO "public"."ref_akun" VALUES (10, 9, '10301', 'Persediaan Barang', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (11, 1, '10400', 'BIAYA DIBAYAR DIMUKA (BDD)', 'd', 2, null);
INSERT INTO "public"."ref_akun" VALUES (12, 11, '10401', 'BDD-Sewa', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (13, 1, '18000', 'AKTIVA TETAP', 'd', 2, null);
INSERT INTO "public"."ref_akun" VALUES (14, 13, '18001', 'Tanah dan Bangunan', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (15, 13, '18002', 'Kendaraan', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (16, 13, '18003', 'Mesin-mesin', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (17, 13, '18004', 'Peralatan', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (18, 1, '18100', 'AKUMULASI PENYUSUTAN AKTIVA TETAP', 'd', 2, null);
INSERT INTO "public"."ref_akun" VALUES (19, 18, '18101', 'Akum. Pnyst. Bangunan', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (20, 18, '18102', 'Akum. Pnyst. Kendaraan', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (21, 18, '18103', 'Akum. Pnyst. Mesin-mesin', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (22, 18, '18104', 'Akum. Pnyst. Penyusutan', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (23, NULL, '20000', 'HUTANG', 'k', 1, null);
INSERT INTO "public"."ref_akun" VALUES (24, 23, '20100', 'HUTANG JANGKA PENDEK', 'k', 2, null);
INSERT INTO "public"."ref_akun" VALUES (25, 24, '20101', 'Hutang Usaha', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (26, 24, '20102', 'Hutang Gaji', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (27, 24, '20103', 'Hutang Insentif Dokter', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (28, 24, '20104', 'Hutang Insentif Terapis', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (29, 24, '20105', 'Hutang Insentif Konsultasi Dokter', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (30, 24, '20106', 'Hutang Persediaan', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (31, 23, '20200', 'HUTANG JANGKA PANJANG', 'k', 2, null);
INSERT INTO "public"."ref_akun" VALUES (32, 31, '20201', 'Hutang pada Bank', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (33, 31, '20202', 'Hutang pada Leasing', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (34, NULL, '30000', 'MODAL', 'k', 1, null);
INSERT INTO "public"."ref_akun" VALUES (35, 34, '30100', 'MODAL', 'k', 2, null);
INSERT INTO "public"."ref_akun" VALUES (36, 35, '30101', 'Modal', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (37, 35, '30102', 'Laba Ditahan', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (38, 35, '30103', 'Prive', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (39, NULL, '40000', 'PENDAPATAN', 'k', 1, null);
INSERT INTO "public"."ref_akun" VALUES (40, 39, '40100', 'PENDAPATAN USAHA', 'k', 2, null);
INSERT INTO "public"."ref_akun" VALUES (41, 40, '40101', 'Pendapatan Jasa Konsultasi', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (42, 40, '40102', 'Pendapatan Jasa Penanganan', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (43, 40, '40103', 'Harga Pokok Penjualan (HPP)', 'k', 3, null);
INSERT INTO "public"."ref_akun" VALUES (44, NULL, '50000', 'BIAYA', 'd' ,1, null);
INSERT INTO "public"."ref_akun" VALUES (45, 44, '50100', 'BEBAN OPERASIONAL', 'd' ,2, null);
INSERT INTO "public"."ref_akun" VALUES (46, 45, '50101', 'Beban Gaji', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (47, 45, '50102', 'Beban Listrik', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (48, 45, '50103', 'Beban Air', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (49, 45, '50104', 'Beban Internet dan Telekomunikasi', 'd', 3, null);
INSERT INTO "public"."ref_akun" VALUES (50, 45, '50105', 'Beban Kebersihan', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (51, 45, '50106', 'Beban Perlengkapan', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (52, 45, '50107', 'Beban Keamanan', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (53, 45, '50108', 'Beban Sewa', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (54, 45, '50109', 'Beban Pemeliharaan Kantor', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (55, 45, '50110', 'Beban ATK', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (56, 45, '50199', 'Beban Lain-lain', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (57, 44, '50200', 'BEBAN PENYUSUTAN', 'd' ,2, null);
INSERT INTO "public"."ref_akun" VALUES (58, 57, '50101', 'Beban Penyusutan Bangunan', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (59, 57, '50102', 'Beban Penyusutan Kendaraan', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (60, 57, '50103', 'Beban Penyusutan Mesin-mesin', 'd' ,3, null);
INSERT INTO "public"."ref_akun" VALUES (61, 57, '50104', 'Beban Penyusutan Peralatan', 'd' ,3, null);
COMMIT;
