--
--

\restrict vgaVUkipVuf7vr1aI9NtgMnL7ciD08trnkEgJyGTS7Yfl2XbTfjSTpt919n5dWe


SET transaction_timeout = 0;
SELECT pg_catalog.set_config('search_path', '', false);

--
-- Name: public; Type: SCHEMA; Schema: -; Owner: postgres
--

-- *not* creating schema, since initdb creates it


ALTER SCHEMA public OWNER TO postgres;

--
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: postgres
--

COMMENT ON SCHEMA public IS '';


--
-- Name: JenisLayanan; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public."JenisLayanan" AS ENUM (
    'FCL_TPP_BTD',
    'FCL_TPP_BDN',
    'LCL_TPP_BTD',
    'LCL_TPP_BDN',
    'GUDANG_FCL',
    'GUDANG_LCL',
    'FULL_EKSPOR',
    'FULL_IMPOR'
);


ALTER TYPE public."JenisLayanan" OWNER TO postgres;

--
-- Name: JenisTransaksi; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public."JenisTransaksi" AS ENUM (
    'FCL',
    'LCL'
);


ALTER TYPE public."JenisTransaksi" OWNER TO postgres;

--
-- Name: Role; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public."Role" AS ENUM (
    'STAFF',
    'SUPERVISOR',
    'ADMIN'
);


ALTER TYPE public."Role" OWNER TO postgres;

--
-- Name: StatusDokumen; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public."StatusDokumen" AS ENUM (
    'TERBUKA',
    'PROSES',
    'SELESAI'
);


ALTER TYPE public."StatusDokumen" OWNER TO postgres;

--
-- Name: StatusInvoice; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public."StatusInvoice" AS ENUM (
    'DRAFT',
    'TERBIT',
    'LUNAS',
    'BATAL'
);


ALTER TYPE public."StatusInvoice" OWNER TO postgres;

--
-- Name: StatusPembayaran; Type: TYPE; Schema: public; Owner: postgres
--

CREATE TYPE public."StatusPembayaran" AS ENUM (
    'BELUM_BAYAR',
    'SEBAGIAN',
    'LUNAS',
    'KADALUARSA'
);


ALTER TYPE public."StatusPembayaran" OWNER TO postgres;



--
-- Name: _prisma_migrations; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public._prisma_migrations (
    id character varying(36) NOT NULL,
    checksum character varying(64) NOT NULL,
    finished_at timestamp with time zone,
    migration_name character varying(255) NOT NULL,
    logs text,
    rolled_back_at timestamp with time zone,
    started_at timestamp with time zone DEFAULT now() NOT NULL,
    applied_steps_count integer DEFAULT 0 NOT NULL
);


ALTER TABLE public._prisma_migrations OWNER TO postgres;

--
-- Name: audit_log; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.audit_log (
    id text NOT NULL,
    "userId" text NOT NULL,
    aksi text NOT NULL,
    entitas text NOT NULL,
    "entitasId" text,
    "dataBefore" jsonb,
    "dataAfter" jsonb,
    "ipAddress" text,
    "userAgent" text,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.audit_log OWNER TO postgres;

--
-- Name: bdn_dokumen; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.bdn_dokumen (
    id text NOT NULL,
    "nomorKepBdn" text NOT NULL,
    "tanggalKepBdn" timestamp(3) without time zone,
    "nomorPib" text,
    "tanggalPib" timestamp(3) without time zone,
    "nomorPersetujuan" text,
    "tanggalPersetujuan" timestamp(3) without time zone,
    "pemilikBarang" text NOT NULL,
    "klienId" text,
    "jumlahJenisKemasan" text,
    "uraianBarang" text,
    "tppTujuan" text DEFAULT 'PT. Sarana Gemilang'::text NOT NULL,
    "jenisTransaksi" public."JenisTransaksi" NOT NULL,
    status public."StatusDokumen" DEFAULT 'TERBUKA'::public."StatusDokumen" NOT NULL,
    containers jsonb DEFAULT '[]'::jsonb NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "createdBy" text
);


ALTER TABLE public.bdn_dokumen OWNER TO postgres;

--
-- Name: btd_dokumen; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.btd_dokumen (
    id text NOT NULL,
    "nomorBcf" text NOT NULL,
    "tanggalBcf" timestamp(3) without time zone,
    "nomorBc11" text,
    "tanggalBc11" timestamp(3) without time zone,
    "posBc11" text,
    "saranaPengangkut" text,
    "pemilikBarang" text NOT NULL,
    "klienId" text,
    "jumlahJenisKemasan" text,
    "uraianBarang" text,
    "tppTujuan" text DEFAULT 'PT. Sarana Gemilang'::text NOT NULL,
    "jenisTransaksi" public."JenisTransaksi" NOT NULL,
    status public."StatusDokumen" DEFAULT 'TERBUKA'::public."StatusDokumen" NOT NULL,
    containers jsonb DEFAULT '[]'::jsonb NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "createdBy" text
);


ALTER TABLE public.btd_dokumen OWNER TO postgres;

--
-- Name: gudang_dokumen; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.gudang_dokumen (
    id text NOT NULL,
    "blNomor" text NOT NULL,
    consignee text NOT NULL,
    "klienId" text,
    party text,
    "jenisTransaksi" public."JenisTransaksi" NOT NULL,
    status public."StatusDokumen" DEFAULT 'TERBUKA'::public."StatusDokumen" NOT NULL,
    catatan text,
    "nomorHBL" text,
    cbm numeric(10,3),
    "tglMasuk" timestamp(3) without time zone,
    "tglKeluar" timestamp(3) without time zone,
    containers jsonb DEFAULT '[]'::jsonb NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "createdBy" text,
    pengeluaran jsonb DEFAULT '[]'::jsonb NOT NULL
);


ALTER TABLE public.gudang_dokumen OWNER TO postgres;

--
-- Name: invoice_baris; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.invoice_baris (
    id text NOT NULL,
    "invoiceId" text NOT NULL,
    urutan integer NOT NULL,
    label text NOT NULL,
    qty20 integer,
    qty40 integer,
    hari integer,
    cbm numeric(10,3),
    tarif numeric(15,2) NOT NULL,
    jumlah numeric(15,2) NOT NULL
);


ALTER TABLE public.invoice_baris OWNER TO postgres;

--
-- Name: invoices; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.invoices (
    id text NOT NULL,
    "nomorKW" text NOT NULL,
    tahun integer NOT NULL,
    bulan integer NOT NULL,
    sequence integer NOT NULL,
    "tanggalInvoice" timestamp(3) without time zone NOT NULL,
    "jenisLayanan" public."JenisLayanan" NOT NULL,
    tujuan text,
    "btdDokumenId" text,
    "bdnDokumenId" text,
    "gudangDokumenId" text,
    "klienId" text,
    consignee text NOT NULL,
    "subTotal" numeric(15,2) NOT NULL,
    ppn numeric(15,2) NOT NULL,
    "grandTotal" numeric(15,2) NOT NULL,
    "tpsAsal" numeric(15,2) DEFAULT 0 NOT NULL,
    "totalAkhir" numeric(15,2) NOT NULL,
    "detailSnapshot" jsonb NOT NULL,
    status public."StatusInvoice" DEFAULT 'TERBIT'::public."StatusInvoice" NOT NULL,
    "statusPembayaran" public."StatusPembayaran" DEFAULT 'BELUM_BAYAR'::public."StatusPembayaran" NOT NULL,
    catatan text,
    "createdById" text NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "deletedAt" timestamp(3) without time zone,
    "deletedById" text,
    "alasanHapus" text,
    "paymentId" text,
    "paymentUrl" text,
    "paidAt" timestamp(3) without time zone,
    CONSTRAINT invoices_must_have_parent CHECK ((("btdDokumenId" IS NOT NULL) OR ("bdnDokumenId" IS NOT NULL) OR ("gudangDokumenId" IS NOT NULL)))
);


ALTER TABLE public.invoices OWNER TO postgres;

--
-- Name: klien; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.klien (
    id text NOT NULL,
    kode text NOT NULL,
    nama text NOT NULL,
    alamat text,
    npwp text,
    telepon text,
    email text,
    aktif boolean DEFAULT true NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "freeTimeDays" integer
);


ALTER TABLE public.klien OWNER TO postgres;

--
-- Name: nomor_kw_sequence; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.nomor_kw_sequence (
    tahun integer NOT NULL,
    terakhir integer DEFAULT 0 NOT NULL
);


ALTER TABLE public.nomor_kw_sequence OWNER TO postgres;

--
-- Name: refresh_tokens; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.refresh_tokens (
    id text NOT NULL,
    token text NOT NULL,
    "userId" text NOT NULL,
    "expiresAt" timestamp(3) without time zone NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL
);


ALTER TABLE public.refresh_tokens OWNER TO postgres;

--
-- Name: tarif_global; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tarif_global (
    id text NOT NULL,
    kategori text NOT NULL,
    field text NOT NULL,
    nilai numeric(15,2) NOT NULL,
    keterangan text,
    "updatedAt" timestamp(3) without time zone NOT NULL,
    "updatedBy" text
);


ALTER TABLE public.tarif_global OWNER TO postgres;

--
-- Name: tarif_khusus; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.tarif_khusus (
    id text NOT NULL,
    "klienId" text NOT NULL,
    kategori text NOT NULL,
    field text NOT NULL,
    nilai numeric(15,2) NOT NULL,
    catatan text,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL
);


ALTER TABLE public.tarif_khusus OWNER TO postgres;

--
-- Name: users; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.users (
    id text NOT NULL,
    nama text NOT NULL,
    email text NOT NULL,
    "passwordHash" text NOT NULL,
    role public."Role" DEFAULT 'STAFF'::public."Role" NOT NULL,
    aktif boolean DEFAULT true NOT NULL,
    "createdAt" timestamp(3) without time zone DEFAULT CURRENT_TIMESTAMP NOT NULL,
    "updatedAt" timestamp(3) without time zone NOT NULL
);


ALTER TABLE public.users OWNER TO postgres;

--
-- Data for Name: _prisma_migrations; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public._prisma_migrations (id, checksum, finished_at, migration_name, logs, rolled_back_at, started_at, applied_steps_count) FROM stdin;
d8a6ea9c-3215-4e26-9f14-6da469493317	79fc05d0781f0e4aae5136c084a8d7d87275c814378a158daff1e89d67198a1a	2026-05-06 12:22:47.44993+07	20260328155722_init	\N	\N	2026-05-06 12:22:47.32308+07	1
ca6896d9-d311-4c89-8ec3-31f01e88d0de	df43f500eb1f1742d2c18f484f2fbb657a4e93b5a28059335a19f9ddce9c3b31	2026-05-06 12:22:47.452678+07	20260504083343_add_klien_free_time_days	\N	\N	2026-05-06 12:22:47.45089+07	1
2f34eb17-beaa-4fa8-8dab-f24e335ccf42	aec00f9349de43283a1fca52edc6284e816756aefb5d472657a5eb03a7322db3	2026-05-06 12:22:47.456168+07	20260505070526_add_gudang_pengeluaran	\N	\N	2026-05-06 12:22:47.453219+07	1
6be9dfb7-f72d-497b-aef3-c9bcb787feb4	c291da4b888b84aadd286fc4ba5e30ed56678834de208c7cd9a9a93f611194ec	2026-05-06 12:22:47.468031+07	20260506000002_fix_createdby_and_invoice_constraint	\N	\N	2026-05-06 12:22:47.45675+07	1
39691bba-23a4-47a2-894c-2e2207d778dd	e4798c0baa03392cd79e1105e791bad2b044509a9247d4726d0149f6543994d5	2026-05-06 12:22:48.846352+07	20260506052248_fix_createdby_and_invoice_constraint	\N	\N	2026-05-06 12:22:48.820714+07	1
\.


--
-- Data for Name: audit_log; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.audit_log (id, "userId", aksi, entitas, "entitasId", "dataBefore", "dataAfter", "ipAddress", "userAgent", "createdAt") FROM stdin;
cmotm4sk90003nq5aifumpkt1	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-06 05:24:40.473
cmotnxu4n0005zyz4zm59859p	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-06 06:15:15.143
cmotnzvjf0007zyz4bv6vfbfu	cmotm2f970000ov4i1nvtm4rv	LOGOUT	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	\N	\N	2026-05-06 06:16:50.283
cmou18uy7000318labi44wa37	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-06 12:27:44.431
cmou1imjx0003b6efzf8hol1z	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-06 12:35:20.109
cmou22aeo0004g3dxxim75hnk	cmotm2f970000ov4i1nvtm4rv	CREATE_BTD	BtdDokumen	cmou22aef0002g3dx1i1wutek	\N	{"nomorBcf": "8"}	\N	\N	2026-05-06 12:50:37.488
cmou24dsx000cg3dxx8phialn	cmotm2f970000ov4i1nvtm4rv	CREATE_INVOICE	Invoice	cmou24ds70007g3dx6a5gm2cx	\N	{"nomorKW": "KW-001/SG/BTD/V/2026", "consignee": "PT INDO PRATAMA MANDIRI", "grandTotal": 23529917}	\N	\N	2026-05-06 12:52:15.201
cmou2867b000fg3dxnu25jwpd	cmotm2f970000ov4i1nvtm4rv	LUNAS_INVOICE	Invoice	cmou24ds70007g3dx6a5gm2cx	\N	{"paidAt": "2026-05-06T12:55:11.571Z"}	\N	\N	2026-05-06 12:55:11.975
cmou2naad000og3dxu2xwnv6t	cmotm2f970000ov4i1nvtm4rv	CREATE_INVOICE	Invoice	cmou2na9x000kg3dxdl5cs8cg	\N	{"nomorKW": "KW-002/SG/BTD/V/2026", "consignee": "PT INDO PRATAMA MANDIRI", "grandTotal": 9412800}	\N	\N	2026-05-06 13:06:57.109
cmou2nu5w000rg3dxvnll9cfn	cmotm2f970000ov4i1nvtm4rv	DELETE_INVOICE	Invoice	cmou2na9x000kg3dxdl5cs8cg	{"nomorKW": "KW-002/SG/BTD/V/2026", "grandTotal": 9412800.0}	{"alasanHapus": "Dihapus oleh admin"}	\N	\N	2026-05-06 13:07:22.868
cmou2obfd000zg3dxv3a2zkle	cmotm2f970000ov4i1nvtm4rv	CREATE_INVOICE	Invoice	cmou2obex000ug3dxopti1ney	\N	{"nomorKW": "KW-003/SG/BTD/V/2026", "consignee": "PT INDO PRATAMA MANDIRI", "grandTotal": 9629250}	\N	\N	2026-05-06 13:07:45.242
cmouctkkx0005pk5r41fs7oce	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-06 17:51:46.545
cmoucuspe0008pk5rfv61vfgb	cmotm2f970000ov4i1nvtm4rv	CREATE_BTD	BtdDokumen	cmoucuspa0006pk5rj578l9n9	\N	{"nomorBcf": "8"}	\N	\N	2026-05-06 17:52:43.731
cmoucz1ts000epk5r2ufd1538	cmotm2f970000ov4i1nvtm4rv	LOGOUT	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	\N	\N	2026-05-06 17:56:02.176
cmoucz3c0000ipk5rlg83y764	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-06 17:56:04.128
cmoud8s4w000npk5rrgwg8h0j	cmotm2f970000ov4i1nvtm4rv	CREATE_BTD	BtdDokumen	cmoud8s4p000lpk5ru4v6nmxc	\N	{"nomorBcf": "65"}	\N	\N	2026-05-06 18:03:36.177
cmoudtk210003ntp81tm86bo4	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-06 18:19:45.482
cmoudzqrd000cntp87x9a1s2j	cmotm2f970000ov4i1nvtm4rv	CREATE_BTD	BtdDokumen	cmoudzqqm000antp8uxcu8v4i	\N	{"nomorBcf": "83"}	\N	\N	2026-05-06 18:24:34.106
cmoue09sq000ontp8eohypre2	cmotm2f970000ov4i1nvtm4rv	CREATE_INVOICE	Invoice	cmoue09rm000fntp8qf6f7ucl	\N	{"nomorKW": "KW-004/SG/BTD/V/2026", "consignee": "CV. SYAVA MANDIRI JAYA", "grandTotal": 12852800}	\N	\N	2026-05-06 18:24:58.778
cmoue1plu000rntp8ay6dhcxk	cmotm2f970000ov4i1nvtm4rv	LUNAS_INVOICE	Invoice	cmoue09rm000fntp8qf6f7ucl	\N	{"paidAt": "2026-05-06T18:26:05.871Z"}	\N	\N	2026-05-06 18:26:05.923
cmouwi6ag0005xtxrd1t5bowe	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-07 03:02:47.128
cmouwk791000kxtxrp359cwbl	cmotm2f970000ov4i1nvtm4rv	CREATE_INVOICE	Invoice	cmouwk77r0008xtxrgfowcqb5	\N	{"nomorKW": "KW-005/SG/BTD/V/2026", "consignee": "CV. SYAVA MANDIRI JAYA", "grandTotal": 18237800}	\N	\N	2026-05-07 03:04:21.686
cmouy4ng2000qxtxrdb2omcrn	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-07 03:48:15.41
cmouyefpq000txtxr8m79iclj	cmotm2f970000ov4i1nvtm4rv	CREATE_BDN	BdnDokumen	cmouyefoh000rxtxrwvn7khyd	\N	{"nomorKepBdn": "KEP-90/KBC.0201/2026"}	\N	\N	2026-05-07 03:55:51.95
cmouym28m000vxtxrrniizigc	cmotm2f970000ov4i1nvtm4rv	LOGOUT	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	\N	\N	2026-05-07 04:01:47.734
cmouym39p000zxtxr7ck6ajus	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-07 04:01:49.069
cmouywkye0012xtxrhiss7gvi	cmotm2f970000ov4i1nvtm4rv	CREATE_BDN	BdnDokumen	cmouywky60010xtxrj11nsb5j	\N	{"nomorKepBdn": "KEP-17/SBC"}	\N	\N	2026-05-07 04:09:58.55
cmouz0wik0015xtxr5qzi7iue	cmotm2f970000ov4i1nvtm4rv	CREATE_BTD	BtdDokumen	cmouz0wi70013xtxread2im3g	\N	{"nomorBcf": "91"}	\N	\N	2026-05-07 04:13:20.156
cmouz342y001dxtxr7yc814v0	cmotm2f970000ov4i1nvtm4rv	CREATE_INVOICE	Invoice	cmouz34230018xtxr0jceswgk	\N	{"nomorKW": "KW-006/SG/BTD/V/2026", "consignee": "PT ABC", "grandTotal": 7825500}	\N	\N	2026-05-07 04:15:03.274
cmouz3k4d001fxtxrctny74ax	cmotm2f970000ov4i1nvtm4rv	LOGOUT	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	\N	\N	2026-05-07 04:15:24.062
cmouz3mnn001jxtxruly8z789	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-07 04:15:27.348
cmouz4wl5001xxtxrmvs6cy0l	cmotm2f970000ov4i1nvtm4rv	CREATE_INVOICE	Invoice	cmouz4wkr001mxtxrumrwqtjq	\N	{"nomorKW": "KW-007/SG/BDN/V/2026", "consignee": "PT ABC", "grandTotal": 17492500}	\N	\N	2026-05-07 04:16:26.874
cmov0ddnb0005juhl2x0yqrab	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-07 04:51:01.847
cmov0s1un00023j1jzvsdegck	cmotm2f970000ov4i1nvtm4rv	CREATE_GUDANG	GudangDokumen	cmov0s1tt00003j1jfi7m6guv	\N	{"blNomor": "SJ/001"}	\N	\N	2026-05-07 05:02:26.399
cmov10vfu0005twbsywmscaig	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-07 05:09:17.994
cmov13u50000ctwbslt3arrrb	cmotm2f970000ov4i1nvtm4rv	CREATE_INVOICE	Invoice	cmov13u450008twbsjneqhg9u	\N	{"nomorKW": "KW-008/SG/GU/V/2026", "consignee": "PT ABC", "grandTotal": 1559550}	\N	\N	2026-05-07 05:11:36.276
cmov14nex000etwbsyq4lukzf	cmotm2f970000ov4i1nvtm4rv	LOGOUT	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	\N	\N	2026-05-07 05:12:14.217
cmov7lw0v0003vc345vbi6gg6	cmotm2f970000ov4i1nvtm4rv	LOGIN	User	cmotm2f970000ov4i1nvtm4rv	\N	\N	127.0.0.1	Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/147.0.0.0 Safari/537.36 Edg/147.0.0.0	2026-05-07 08:13:36.224
\.


--
-- Data for Name: bdn_dokumen; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.bdn_dokumen (id, "nomorKepBdn", "tanggalKepBdn", "nomorPib", "tanggalPib", "nomorPersetujuan", "tanggalPersetujuan", "pemilikBarang", "klienId", "jumlahJenisKemasan", "uraianBarang", "tppTujuan", "jenisTransaksi", status, containers, "createdAt", "updatedAt", "createdBy") FROM stdin;
cmouyefoh000rxtxrwvn7khyd	KEP-90/KBC.0201/2026	2026-03-16 00:00:00	005809	2026-02-20 00:00:00		\N	PT Suriatama Cantik Abadi	\N	1x40 Feet/FCL/ MSNU6835060	1 CT / Women Dress blackforest 6975\n2 CT / Women Dress blackforest 6966\n2 CT / Women Dress blackforest 6971	PT. Sarana Gemilang	FCL	TERBUKA	[{"id": 1778126115674.056, "kapal": "INTEGRA", "ukuran": "40'", "voyage": "163E", "tglMasuk": "2026-03-18", "tglKeluar": "2026-03-25", "nomorContainer": "MSNU6835060"}]	2026-05-07 03:55:51.85	2026-05-07 03:55:51.85	cmotm2f970000ov4i1nvtm4rv
cmouywky60010xtxrj11nsb5j	KEP-17/SBC	2026-02-20 00:00:00	123123	2026-02-10 00:00:00		\N	PT ABC	\N	WHSU789098	45 ROLLS	PT. Sarana Gemilang	FCL	PROSES	[{"id": 1778126598065.102, "kapal": "INTEGRA", "ukuran": "40'", "voyage": "163E", "tglMasuk": "2026-02-26", "tglKeluar": "2026-03-01", "nomorContainer": "WHSU789098"}]	2026-05-07 04:09:58.48	2026-05-07 04:16:26.867	cmotm2f970000ov4i1nvtm4rv
\.


--
-- Data for Name: btd_dokumen; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.btd_dokumen (id, "nomorBcf", "tanggalBcf", "nomorBc11", "tanggalBc11", "posBc11", "saranaPengangkut", "pemilikBarang", "klienId", "jumlahJenisKemasan", "uraianBarang", "tppTujuan", "jenisTransaksi", status, containers, "createdAt", "updatedAt", "createdBy") FROM stdin;
cmou22aef0002g3dx1i1wutek	8	2026-02-04 00:00:00	002760	2025-12-28 00:00:00	0040.0014.0000	ONE THESEUS	PT INDO PRATAMA MANDIRI	\N	1 x 20 Feet/ CSLU2225797 / LCL / SEAL NUMBER OOLKUF0654	2 PK/ SELF-COUPLING SUBMERSIBLE PUMP	PT. Sarana Gemilang	LCL	PROSES	[]	2026-05-06 12:50:37.479	2026-05-06 13:07:45.236	cmotm2f970000ov4i1nvtm4rv
cmoucuspa0006pk5rj578l9n9	8	2026-02-04 00:00:00	002760	2025-12-28 00:00:00	0040.0014.0000	ONE THESEUS	PT INDO PRATAMA MANDIRI	\N	1 x 20 Feet/ CSLU2225797 / LCL / SEAL NUMBER OOLKUF0654	2 PK/ SELF-COUPLING SUBMERSIBLE PUMP	PT. Sarana Gemilang	LCL	TERBUKA	[]	2026-05-06 17:52:43.726	2026-05-06 17:52:43.726	cmotm2f970000ov4i1nvtm4rv
cmoud8s4p000lpk5ru4v6nmxc	65	2025-08-28 00:00:00	001522	2025-07-25 00:00:00	0042.0000	UNAYZAH EXPRESS	PT PODANA LIMA BATAM	\N	3 x 40 Feet/ MAEU3510108, MRSU7234347, MAEU3451366 / FCL / SEAL NUMBER NOSEAL, CN3482728, NOSEAL	5 PK PYROLYSIS PLANT	PT. Sarana Gemilang	FCL	TERBUKA	[{"id": 1778090544608.392, "kapal": "UNAYZAH EXPRESS", "ukuran": "40'", "voyage": "asdas", "tglMasuk": "2025-08-12", "tglKeluar": "2025-08-17", "nomorContainer": "MAEU3510108"}, {"id": 1778090544608.394, "kapal": "UNAYZAH EXPRESS", "ukuran": "40'", "voyage": "asdas", "tglMasuk": "2025-08-12", "tglKeluar": "2025-08-17", "nomorContainer": "MRSU7234347"}, {"id": 1778090544608.788, "kapal": "UNAYZAH EXPRESS", "ukuran": "40'", "voyage": "asdas", "tglMasuk": "2025-08-12", "tglKeluar": "2025-08-17", "nomorContainer": "MAEU3451366"}, {"id": 1778090544608.001, "kapal": "UNAYZAH EXPRESS", "ukuran": "40'", "voyage": "asdas", "tglMasuk": "2025-08-12", "tglKeluar": "2025-08-17", "nomorContainer": "CN3482728"}]	2026-05-06 18:03:36.122	2026-05-06 18:03:36.122	cmotm2f970000ov4i1nvtm4rv
cmoudzqqm000antp8uxcu8v4i	83	2025-12-24 00:00:00	002473	2025-11-19 00:00:00	0007.0000.0000	BEIJING BRIDGE	CV. SYAVA MANDIRI JAYA	\N	1 x 20 Feet/ VMLU3602070 / FCL / SEAL NUMBER 483191/74987	58 PK TOBACCO	PT. Sarana Gemilang	FCL	PROSES	[{"id": 1778091852863.476, "kapal": "BEIJING BRIDGE", "ukuran": "20'", "voyage": "", "tglMasuk": "2025-12-25", "tglKeluar": "2026-01-01", "nomorContainer": "VMLU3602070"}]	2026-05-06 18:24:34.078	2026-05-07 03:04:21.671	cmotm2f970000ov4i1nvtm4rv
cmouz0wi70013xtxread2im3g	91	2026-01-01 00:00:00	000000	2025-12-12 00:00:00	0042.000	INTEGRA	PT ABC	\N	3 COIL	HOT ROLLED	PT. Sarana Gemilang	LCL	PROSES	[]	2026-05-07 04:13:20.142	2026-05-07 04:15:03.262	cmotm2f970000ov4i1nvtm4rv
\.


--
-- Data for Name: gudang_dokumen; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.gudang_dokumen (id, "blNomor", consignee, "klienId", party, "jenisTransaksi", status, catatan, "nomorHBL", cbm, "tglMasuk", "tglKeluar", containers, "createdAt", "updatedAt", "createdBy", pengeluaran) FROM stdin;
cmov0s1tt00003j1jfi7m6guv	SJ/001	PT ABC	\N	full_ekspor	FCL	PROSES	1 X 20	\N	\N	\N	\N	[{"id": 1778130112248.43, "kapal": "BEIJING", "ukuran": "20'", "voyage": "2505E", "tglMasuk": "2026-02-03", "tglKeluar": "", "sealNumber": "CN1029831", "nomorContainer": "MAEU1923180"}]	2026-05-07 05:02:26.369	2026-05-07 05:11:36.265	cmotm2f970000ov4i1nvtm4rv	[]
\.


--
-- Data for Name: invoice_baris; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.invoice_baris (id, "invoiceId", urutan, label, qty20, qty40, hari, cbm, tarif, jumlah) FROM stdin;
cmou24dsl0008g3dxu03tbx66	cmou24ds70007g3dx6a5gm2cx	1	Jasa TPP	\N	\N	\N	\N	500000.00	500000.00
cmou24dsl0009g3dx98jg0voz	cmou24ds70007g3dx6a5gm2cx	2	Administrasi	\N	\N	\N	\N	150000.00	150000.00
cmou24dsl000ag3dxq33f82a7	cmou24ds70007g3dx6a5gm2cx	3	sew	\N	\N	\N	\N	0.00	13123123.00
cmou2naa5000lg3dxhynzqh6a	cmou2na9x000kg3dxdl5cs8cg	1	Jasa TPP	\N	\N	\N	\N	500000.00	500000.00
cmou2naa5000mg3dx05tgfyc8	cmou2na9x000kg3dxdl5cs8cg	2	Administrasi	\N	\N	\N	\N	150000.00	150000.00
cmou2obf5000vg3dx1s0638g1	cmou2obex000ug3dxopti1ney	1	Jasa TPP	\N	\N	\N	\N	500000.00	500000.00
cmou2obf5000wg3dxad4kdknz	cmou2obex000ug3dxopti1ney	2	Administrasi	\N	\N	\N	\N	150000.00	150000.00
cmou2obf5000xg3dxxsx8qb06	cmou2obex000ug3dxopti1ney	3	sewa	\N	\N	\N	\N	0.00	150000.00
cmoue09s2000gntp8pyvfxpf9	cmoue09rm000fntp8qf6f7ucl	1	Storage Container 1 (20') — 8 hari	\N	\N	8	\N	0.00	8180000.00
cmoue09s2000hntp8fatidgqy	cmoue09rm000fntp8qf6f7ucl	2	Jasa TPP	\N	\N	\N	\N	1050000.00	1050000.00
cmoue09s2000intp89uexlm5s	cmoue09rm000fntp8qf6f7ucl	3	Administrasi	\N	\N	\N	\N	500000.00	500000.00
cmoue09s2000jntp8q69zwmgh	cmoue09rm000fntp8qf6f7ucl	4	Materai	\N	\N	\N	\N	10000.00	10000.00
cmoue09s2000kntp8z0e7nysh	cmoue09rm000fntp8qf6f7ucl	5	Potong Seal Karantina	\N	1	\N	\N	750000.00	750000.00
cmoue09s2000lntp8dwjm6a8e	cmoue09rm000fntp8qf6f7ucl	6	Penumpukan Lolo Terminal Asal	\N	\N	\N	\N	0.00	100000.00
cmoue09s2000mntp8rpj9loul	cmoue09rm000fntp8qf6f7ucl	7	Lainnya	\N	\N	\N	\N	0.00	1000000.00
cmouwk78h0009xtxrxx369ver	cmouwk77r0008xtxrgfowcqb5	1	Storage Container 1 (20') — 8 hari	\N	\N	8	\N	0.00	8180000.00
cmouwk78h000axtxr6rvoqdpb	cmouwk77r0008xtxrgfowcqb5	2	Jasa TPP	\N	\N	\N	\N	1050000.00	1050000.00
cmouwk78h000bxtxr5x1tj0jn	cmouwk77r0008xtxrgfowcqb5	3	Administrasi	\N	\N	\N	\N	500000.00	500000.00
cmouwk78h000cxtxr40n7ifjh	cmouwk77r0008xtxrgfowcqb5	4	Materai	\N	\N	\N	\N	10000.00	10000.00
cmouwk78h000dxtxrydtdg6rg	cmouwk77r0008xtxrgfowcqb5	5	Potong Seal Karantina	\N	1	\N	\N	750000.00	750000.00
cmouwk78h000extxrrivvhgsy	cmouwk77r0008xtxrgfowcqb5	6	DG DOC FEE	\N	\N	\N	\N	1500000.00	1500000.00
cmouwk78h000fxtxrq0rvrmk2	cmouwk77r0008xtxrgfowcqb5	7	Pemotongan Seal & Sampel	\N	1	\N	\N	1000000.00	1000000.00
cmouwk78h000gxtxrg35p9s2q	cmouwk77r0008xtxrgfowcqb5	8	Penumpukan Terminal Asal	\N	\N	\N	\N	0.00	1500000.00
cmouwk78h000hxtxrygunr3ze	cmouwk77r0008xtxrgfowcqb5	9	Penumpukan Lolo Terminal Asal	\N	\N	\N	\N	0.00	100000.00
cmouwk78h000ixtxritdx2137	cmouwk77r0008xtxrgfowcqb5	10	Lainnya	\N	\N	\N	\N	0.00	2000000.00
cmouz342e0019xtxr6p18vuvy	cmouz34230018xtxr0jceswgk	1	Jasa TPP	\N	\N	\N	\N	500000.00	500000.00
cmouz342e001axtxr9w0hoz9l	cmouz34230018xtxr0jceswgk	2	Administrasi	\N	\N	\N	\N	150000.00	150000.00
cmouz342e001bxtxrzmx17bvy	cmouz34230018xtxr0jceswgk	3	Lainnya	\N	\N	\N	\N	0.00	1000000.00
cmouz4wkw001nxtxr26rjxhum	cmouz4wkr001mxtxrumrwqtjq	1	Storage Container 1 (40') — 4 hari	\N	\N	4	\N	0.00	9300000.00
cmouz4wkw001oxtxrsarvrr8v	cmouz4wkr001mxtxrumrwqtjq	2	Jasa TPP	\N	\N	\N	\N	1050000.00	1050000.00
cmouz4wkw001pxtxrm44q7yzl	cmouz4wkr001mxtxrumrwqtjq	3	Administrasi	\N	\N	\N	\N	500000.00	500000.00
cmouz4wkw001qxtxry57mxguh	cmouz4wkr001mxtxrumrwqtjq	4	Materai	\N	\N	\N	\N	10000.00	10000.00
cmouz4wkw001rxtxr96aq6fmf	cmouz4wkr001mxtxrumrwqtjq	5	Lift On Full	\N	1	\N	\N	1200000.00	1200000.00
cmouz4wkw001sxtxruqbqg5ft	cmouz4wkr001mxtxrumrwqtjq	6	Lift Off Full	\N	1	\N	\N	1200000.00	1200000.00
cmouz4wkw001txtxrlj3az3tq	cmouz4wkr001mxtxrumrwqtjq	7	Lift On Empty	\N	1	\N	\N	1000000.00	1000000.00
cmouz4wkw001uxtxr9jytqnwq	cmouz4wkr001mxtxrumrwqtjq	8	Lift Off Empty	\N	1	\N	\N	1000000.00	1000000.00
cmouz4wkw001vxtxrjn9lytf4	cmouz4wkr001mxtxrumrwqtjq	9	Moving Cargo	\N	\N	\N	\N	500000.00	500000.00
cmov13u4h0009twbspkext06w	cmov13u450008twbsjneqhg9u	1	Storage Container 1 (20') — 8 hari	\N	\N	8	\N	0.00	1305000.00
cmov13u4h000atwbskxf4jrmn	cmov13u450008twbsjneqhg9u	2	lAINNYA	\N	\N	\N	\N	0.00	100000.00
\.


--
-- Data for Name: invoices; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.invoices (id, "nomorKW", tahun, bulan, sequence, "tanggalInvoice", "jenisLayanan", tujuan, "btdDokumenId", "bdnDokumenId", "gudangDokumenId", "klienId", consignee, "subTotal", ppn, "grandTotal", "tpsAsal", "totalAkhir", "detailSnapshot", status, "statusPembayaran", catatan, "createdById", "createdAt", "updatedAt", "deletedAt", "deletedById", "alasanHapus", "paymentId", "paymentUrl", "paidAt") FROM stdin;
cmou24ds70007g3dx6a5gm2cx	KW-001/SG/BTD/V/2026	2026	5	1	2026-05-06 12:52:15.124	FCL_TPP_BTD	Full Ekspor	cmou22aef0002g3dx1i1wutek	\N	\N	\N	PT INDO PRATAMA MANDIRI	21198123.00	2331794.00	23529917.00	0.00	23529917.00	{"doc": {"id": "cmou22aef0002g3dx1i1wutek", "nomorBcf": "8", "containers": [], "pemilikBarang": "PT INDO PRATAMA MANDIRI", "jenisTransaksi": "LCL", "saranaPengangkut": "ONE THESEUS"}, "form": {"diskon": "", "tujuan": "ekspor", "catatan": "", "cbmOverride": "15.5", "pakaiDGDocs": false, "tipeDokumen": "btd", "pakaiMekanik": true, "pakaiStorage": true, "biayaLainLain": [{"nama": "sew", "nominal": "13123123"}], "pakaiBehandle": true, "includeJasaTPP": true, "penumpukanTpsAsal": "", "includeAdministrasi": true, "penumpukanLoloTpsAsal": "", "pakaiStrippingStuffing": true, "penumpukanTerminalAsal": "", "penumpukanLoloTerminalAsal": ""}, "npwp": "", "klien": null, "alamat": "", "tujuan": "Full Ekspor", "kalkulasi": {"cbm": 15.5, "dpp": 21198123, "mek": 3875000, "ppn": 2331794, "str": 3100000, "stor": 0, "admin": 150000, "dgDocs": 0, "diskon": 0, "jasaTPP": 500000, "behandle": 450000, "subTotal": 21198123, "grandTotal": 23529917, "hariStorage": 0, "penumpukanAsal": 0, "penumpukanLolo": 0, "passThroughTotal": 0, "penumpukanTpsAsal": 0, "totalBiayaLainLain": 13123123, "penumpukanLoloTpsAsal": 0}, "jenisLayanan": "LCL TPP â€” BTD", "jumlahContainer": 1}	LUNAS	LUNAS	\N	cmotm2f970000ov4i1nvtm4rv	2026-05-06 12:52:15.175	2026-05-06 12:55:11.96	\N	\N	\N	\N	\N	2026-05-06 12:55:11.571
cmou2na9x000kg3dxdl5cs8cg	KW-002/SG/BTD/V/2026	2026	5	2	2026-05-06 13:06:57.084	LCL_TPP_BTD	WH Importir	cmou22aef0002g3dx1i1wutek	\N	\N	\N	PT INDO PRATAMA MANDIRI	8480000.00	932800.00	9412800.00	0.00	9412800.00	{"doc": {"id": "cmou22aef0002g3dx1i1wutek", "nomorBcf": "8", "containers": [], "pemilikBarang": "PT INDO PRATAMA MANDIRI", "jenisTransaksi": "LCL", "saranaPengangkut": "ONE THESEUS"}, "form": {"diskon": "", "tujuan": "importir", "catatan": "", "cbmOverride": "15.4", "pakaiDGDocs": true, "tipeDokumen": "btd", "pakaiMekanik": true, "pakaiStorage": true, "biayaLainLain": [], "pakaiBehandle": true, "includeJasaTPP": true, "penumpukanTpsAsal": "", "includeAdministrasi": true, "penumpukanLoloTpsAsal": "", "pakaiStrippingStuffing": true, "penumpukanTerminalAsal": "", "penumpukanLoloTerminalAsal": ""}, "npwp": "", "klien": null, "alamat": "", "tujuan": "WH Importir", "kalkulasi": {"cbm": 15.4, "dpp": 8480000, "mek": 3850000, "ppn": 932800, "str": 3080000, "stor": 0, "admin": 150000, "dgDocs": 450000, "diskon": 0, "jasaTPP": 500000, "behandle": 450000, "subTotal": 8480000, "grandTotal": 9412800, "hariStorage": 0, "penumpukanAsal": 0, "penumpukanLolo": 0, "passThroughTotal": 0, "penumpukanTpsAsal": 0, "totalBiayaLainLain": 0, "penumpukanLoloTpsAsal": 0}, "jenisLayanan": "LCL TPP — BTD", "jumlahContainer": 1}	BATAL	BELUM_BAYAR	\N	cmotm2f970000ov4i1nvtm4rv	2026-05-06 13:06:57.094	2026-05-06 13:07:22.857	2026-05-06 13:07:22.853	cmotm2f970000ov4i1nvtm4rv	Dihapus oleh admin	\N	\N	\N
cmou2obex000ug3dxopti1ney	KW-003/SG/BTD/V/2026	2026	5	3	2026-05-06 13:07:45.19	LCL_TPP_BTD	WH Importir	cmou22aef0002g3dx1i1wutek	\N	\N	\N	PT INDO PRATAMA MANDIRI	8675000.00	954250.00	9629250.00	0.00	9629250.00	{"doc": {"id": "cmou22aef0002g3dx1i1wutek", "nomorBcf": "8", "containers": [], "pemilikBarang": "PT INDO PRATAMA MANDIRI", "jenisTransaksi": "LCL", "saranaPengangkut": "ONE THESEUS"}, "form": {"diskon": "", "tujuan": "importir", "catatan": "", "cbmOverride": "15.5", "pakaiDGDocs": true, "tipeDokumen": "btd", "pakaiMekanik": true, "pakaiStorage": true, "biayaLainLain": [{"nama": "sewa", "nominal": "150000"}], "pakaiBehandle": true, "includeJasaTPP": true, "penumpukanTpsAsal": "", "includeAdministrasi": true, "penumpukanLoloTpsAsal": "", "pakaiStrippingStuffing": true, "penumpukanTerminalAsal": "", "penumpukanLoloTerminalAsal": ""}, "npwp": "", "klien": null, "alamat": "", "tujuan": "WH Importir", "kalkulasi": {"cbm": 15.5, "dpp": 8675000, "mek": 3875000, "ppn": 954250, "str": 3100000, "stor": 0, "admin": 150000, "dgDocs": 450000, "diskon": 0, "jasaTPP": 500000, "behandle": 450000, "subTotal": 8675000, "grandTotal": 9629250, "hariStorage": 0, "penumpukanAsal": 0, "penumpukanLolo": 0, "passThroughTotal": 0, "penumpukanTpsAsal": 0, "totalBiayaLainLain": 150000, "penumpukanLoloTpsAsal": 0}, "jenisLayanan": "LCL TPP — BTD", "jumlahContainer": 1}	TERBIT	BELUM_BAYAR	\N	cmotm2f970000ov4i1nvtm4rv	2026-05-06 13:07:45.225	2026-05-06 13:07:45.225	\N	\N	\N	\N	\N	\N
cmoue09rm000fntp8qf6f7ucl	KW-004/SG/BTD/V/2026	2026	5	4	2026-05-06 18:24:58.67	FCL_TPP_BTD	WH Importir	cmoudzqqm000antp8uxcu8v4i	\N	\N	\N	CV. SYAVA MANDIRI JAYA	11480000.00	1262800.00	12852800.00	100000.00	12852800.00	{"doc": {"id": "cmoudzqqm000antp8uxcu8v4i", "nomorBcf": "83", "containers": [{"id": 1778091852863.476, "kapal": "BEIJING BRIDGE", "ukuran": "20'", "voyage": "", "tglMasuk": "2025-12-25", "tglKeluar": "2026-01-01", "nomorContainer": "VMLU3602070"}], "pemilikBarang": "CV. SYAVA MANDIRI JAYA", "jenisTransaksi": "FCL", "saranaPengangkut": "BEIJING BRIDGE"}, "form": {"diskon": "", "tujuan": "importir", "catatan": "", "tipeDokumen": "btd", "biayaLainLain": [{"nama": "Lainnya", "nominal": "1000000"}], "includeJasaTPP": true, "includeMaterai": true, "includeDgDocFee": false, "includeLiftOnFull": false, "penumpukanTpsAsal": "", "includeLiftOffFull": false, "includeLiftOnEmpty": false, "includeMovingCargo": false, "includeAdministrasi": true, "includeLiftOffEmpty": false, "includeMuatForklift": false, "includeMuatManPower": false, "penumpukanLoloTpsAsal": "", "includeBongkarForklift": false, "includeBongkarManPower": false, "penumpukanTerminalAsal": "", "includePotongSealKarantina": true, "penumpukanLoloTerminalAsal": "100000", "includePemotonganSealSampel": false}, "npwp": "", "klien": null, "alamat": "", "tujuan": "WH Importir", "kalkulasi": {"dpp": 11480000, "ppn": 1262800, "admin": 500000, "diskon": 0, "extras": 0, "jasaTPP": 1050000, "materai": 10000, "dgDocFee": 0, "subTotal": 11480000, "grandTotal": 12852800, "liftOnFull": 0, "liftOffFull": 0, "liftOnEmpty": 0, "movingCargo": 0, "dgDocFeeRate": 1500000, "liftOffEmpty": 0, "muatForklift": 0, "muatManPower": 0, "perContainer": [{"hari": 8, "baris": [{"label": "Handling", "qty20": 1, "qty40": "", "tarif": 1000000, "jumlah": 1000000}, {"label": "Mekanik", "qty20": 1, "qty40": "", "tarif": 4000000, "jumlah": 4000000}, {"label": "Receiving & Delivery", "qty20": 1, "qty40": "", "tarif": 1500000, "jumlah": 1500000}, {"hari": 8, "label": "Pengelolaan Penyimpanan", "qty20": 1, "qty40": "", "tarif": 210000, "jumlah": 1680000}], "ukuran": "20'", "subTotal": 8180000, "tarifRef": {"jasaTPP": 1050000, "materai": 10000, "mekanik": 4000000, "dgDocFee": 1500000, "handling": 1000000, "liftOnFull": 1000000, "liftOffFull": 1000000, "liftOnEmpty": 850000, "movingCargo": 500000, "administrasi": 500000, "liftOffEmpty": 850000, "muatForklift": 1000000, "muatManPower": 1500000, "storagePerHari": 210000, "bongkarForklift": 1000000, "bongkarManPower": 1500000, "receivingDelivery": 1500000, "potongSealKarantina": 750000, "pemotonganSealSampel": 1000000}, "nomorContainer": "VMLU3602070"}], "bongkarForklift": 0, "bongkarManPower": 0, "movingCargoRate": 500000, "passThroughTotal": 100000, "penumpukanTpsAsal": 0, "totalBiayaLainLain": 1000000, "potongSealKarantina": 750000, "pemotonganSealSampel": 0, "penumpukanLoloTpsAsal": 0, "penumpukanTerminalAsal": 0, "potongSealKarantinaRate": 750000, "pemotonganSealSampelRate": 1000000, "penumpukanLoloTerminalAsal": 100000}, "jenisLayanan": "FCL TPP — BTD", "jumlahContainer": 1}	LUNAS	LUNAS	\N	cmotm2f970000ov4i1nvtm4rv	2026-05-06 18:24:58.738	2026-05-06 18:26:05.883	\N	\N	\N	\N	\N	2026-05-06 18:26:05.871
cmouwk77r0008xtxrgfowcqb5	KW-005/SG/BTD/V/2026	2026	5	5	2026-05-07 03:04:21.591	FCL_TPP_BTD	WH Importir	cmoudzqqm000antp8uxcu8v4i	\N	\N	\N	CV. SYAVA MANDIRI JAYA	14980000.00	1647800.00	18237800.00	1600000.00	18237800.00	{"doc": {"id": "cmoudzqqm000antp8uxcu8v4i", "nomorBcf": "83", "containers": [{"id": 1778091852863.476, "kapal": "BEIJING BRIDGE", "ukuran": "20'", "voyage": "", "tglMasuk": "2025-12-25", "tglKeluar": "2026-01-01", "nomorContainer": "VMLU3602070"}], "pemilikBarang": "CV. SYAVA MANDIRI JAYA", "jenisTransaksi": "FCL", "saranaPengangkut": "BEIJING BRIDGE"}, "form": {"diskon": "", "tujuan": "importir", "catatan": "", "tipeDokumen": "btd", "biayaLainLain": [{"nama": "Lainnya", "nominal": "2000000"}], "includeJasaTPP": true, "includeMaterai": true, "includeDgDocFee": true, "includeLiftOnFull": false, "penumpukanTpsAsal": "", "includeLiftOffFull": false, "includeLiftOnEmpty": false, "includeMovingCargo": false, "includeAdministrasi": true, "includeLiftOffEmpty": false, "includeMuatForklift": false, "includeMuatManPower": false, "penumpukanLoloTpsAsal": "", "includeBongkarForklift": false, "includeBongkarManPower": false, "penumpukanTerminalAsal": "1500000", "includePotongSealKarantina": true, "penumpukanLoloTerminalAsal": "100000", "includePemotonganSealSampel": true}, "npwp": "", "klien": null, "alamat": "", "tujuan": "WH Importir", "kalkulasi": {"dpp": 14980000, "ppn": 1647800, "admin": 500000, "diskon": 0, "extras": 0, "jasaTPP": 1050000, "materai": 10000, "dgDocFee": 1500000, "subTotal": 14980000, "grandTotal": 18237800, "liftOnFull": 0, "liftOffFull": 0, "liftOnEmpty": 0, "movingCargo": 0, "dgDocFeeRate": 1500000, "liftOffEmpty": 0, "muatForklift": 0, "muatManPower": 0, "perContainer": [{"hari": 8, "baris": [{"label": "Handling", "qty20": 1, "qty40": "", "tarif": 1000000, "jumlah": 1000000}, {"label": "Mekanik", "qty20": 1, "qty40": "", "tarif": 4000000, "jumlah": 4000000}, {"label": "Receiving & Delivery", "qty20": 1, "qty40": "", "tarif": 1500000, "jumlah": 1500000}, {"hari": 8, "label": "Pengelolaan Penyimpanan", "qty20": 1, "qty40": "", "tarif": 210000, "jumlah": 1680000}], "ukuran": "20'", "subTotal": 8180000, "tarifRef": {"jasaTPP": 1050000, "materai": 10000, "mekanik": 4000000, "dgDocFee": 1500000, "handling": 1000000, "liftOnFull": 1000000, "liftOffFull": 1000000, "liftOnEmpty": 850000, "movingCargo": 500000, "administrasi": 500000, "liftOffEmpty": 850000, "muatForklift": 1000000, "muatManPower": 1500000, "storagePerHari": 210000, "bongkarForklift": 1000000, "bongkarManPower": 1500000, "receivingDelivery": 1500000, "potongSealKarantina": 750000, "pemotonganSealSampel": 1000000}, "nomorContainer": "VMLU3602070"}], "bongkarForklift": 0, "bongkarManPower": 0, "movingCargoRate": 500000, "passThroughTotal": 1600000, "penumpukanTpsAsal": 0, "totalBiayaLainLain": 2000000, "potongSealKarantina": 750000, "pemotonganSealSampel": 1000000, "penumpukanLoloTpsAsal": 0, "penumpukanTerminalAsal": 1500000, "potongSealKarantinaRate": 750000, "pemotonganSealSampelRate": 1000000, "penumpukanLoloTerminalAsal": 100000}, "jenisLayanan": "FCL TPP — BTD", "jumlahContainer": 1}	TERBIT	BELUM_BAYAR	\N	cmotm2f970000ov4i1nvtm4rv	2026-05-07 03:04:21.639	2026-05-07 03:04:21.639	\N	\N	\N	\N	\N	\N
cmouz34230018xtxr0jceswgk	KW-006/SG/BTD/V/2026	2026	5	6	2026-05-07 04:15:03.172	LCL_TPP_BTD	Full Ekspor	cmouz0wi70013xtxread2im3g	\N	\N	\N	PT ABC	7050000.00	775500.00	7825500.00	0.00	7825500.00	{"doc": {"id": "cmouz0wi70013xtxread2im3g", "nomorBcf": "91", "tglKeluar": "2026-02-10", "containers": [], "pemilikBarang": "PT ABC", "jenisTransaksi": "LCL", "saranaPengangkut": "INTEGRA"}, "form": {"diskon": "", "tujuan": "ekspor", "catatan": "", "cbmOverride": "12", "pakaiDGDocs": false, "tipeDokumen": "btd", "pakaiMekanik": true, "pakaiStorage": true, "biayaLainLain": [{"nama": "Lainnya", "nominal": "1000000"}], "pakaiBehandle": false, "includeJasaTPP": true, "penumpukanTpsAsal": "", "includeAdministrasi": true, "penumpukanLoloTpsAsal": "", "pakaiStrippingStuffing": true, "penumpukanTerminalAsal": "", "penumpukanLoloTerminalAsal": ""}, "npwp": "", "klien": null, "alamat": "", "tujuan": "Full Ekspor", "kalkulasi": {"cbm": 12, "dpp": 7050000, "mek": 3000000, "ppn": 775500, "str": 2400000, "stor": 0, "admin": 150000, "dgDocs": 0, "diskon": 0, "jasaTPP": 500000, "behandle": 0, "subTotal": 7050000, "grandTotal": 7825500, "hariStorage": 0, "biayaLainLain": [{"nama": "Lainnya", "nominal": "1000000"}], "penumpukanAsal": 0, "penumpukanLolo": 0, "passThroughTotal": 0, "penumpukanTpsAsal": 0, "totalBiayaLainLain": 1000000, "penumpukanLoloTpsAsal": 0}, "jenisLayanan": "LCL TPP — BTD", "jumlahContainer": 1}	TERBIT	BELUM_BAYAR	\N	cmotm2f970000ov4i1nvtm4rv	2026-05-07 04:15:03.243	2026-05-07 04:15:03.243	\N	\N	\N	\N	\N	\N
cmouz4wkr001mxtxrumrwqtjq	KW-007/SG/BDN/V/2026	2026	5	7	2026-05-07 04:16:26.846	FCL_TPP_BDN	WH Importir	\N	cmouywky60010xtxrj11nsb5j	\N	\N	PT ABC	15750000.00	1732500.00	17492500.00	0.00	17492500.00	{"doc": {"id": "cmouywky60010xtxrj11nsb5j", "containers": [{"id": 1778126598065.102, "kapal": "INTEGRA", "ukuran": "40'", "voyage": "163E", "tglMasuk": "2026-02-26", "tglKeluar": "2026-03-01", "nomorContainer": "WHSU789098"}], "nomorKepBdn": "KEP-17/SBC", "pemilikBarang": "PT ABC", "jenisTransaksi": "FCL"}, "form": {"diskon": "", "tujuan": "importir", "catatan": "", "tipeDokumen": "bdn", "biayaLainLain": [], "includeJasaTPP": true, "includeMaterai": true, "includeDgDocFee": false, "includeLiftOnFull": true, "penumpukanTpsAsal": "", "includeLiftOffFull": true, "includeLiftOnEmpty": true, "includeMovingCargo": true, "includeAdministrasi": true, "includeLiftOffEmpty": true, "includeMuatForklift": false, "includeMuatManPower": false, "penumpukanLoloTpsAsal": "", "includeBongkarForklift": false, "includeBongkarManPower": false, "penumpukanTerminalAsal": "", "includePotongSealKarantina": false, "penumpukanLoloTerminalAsal": "", "includePemotonganSealSampel": false}, "npwp": "", "klien": null, "alamat": "", "tujuan": "WH Importir", "kalkulasi": {"dpp": 15750000, "ppn": 1732500, "admin": 500000, "diskon": 0, "extras": 4400000, "jasaTPP": 1050000, "materai": 10000, "dgDocFee": 0, "subTotal": 15750000, "grandTotal": 17492500, "liftOnFull": 1200000, "liftOffFull": 1200000, "liftOnEmpty": 1000000, "movingCargo": 500000, "dgDocFeeRate": 1500000, "liftOffEmpty": 1000000, "muatForklift": 0, "muatManPower": 0, "perContainer": [{"hari": 4, "baris": [{"label": "Handling", "qty20": "", "qty40": 1, "tarif": 1000000, "jumlah": 1000000}, {"label": "Mekanik", "qty20": "", "qty40": 1, "tarif": 5000000, "jumlah": 5000000}, {"label": "Receiving & Delivery", "qty20": "", "qty40": 1, "tarif": 1700000, "jumlah": 1700000}, {"hari": 4, "label": "Pengelolaan Penyimpanan", "qty20": "", "qty40": 1, "tarif": 400000, "jumlah": 1600000}], "ukuran": "40'", "subTotal": 9300000, "tarifRef": {"jasaTPP": 1050000, "materai": 10000, "mekanik": 5000000, "dgDocFee": 1500000, "handling": 1000000, "liftOnFull": 1200000, "liftOffFull": 1200000, "liftOnEmpty": 1000000, "movingCargo": 500000, "administrasi": 500000, "liftOffEmpty": 1000000, "muatForklift": 1500000, "muatManPower": 2500000, "storagePerHari": 400000, "bongkarForklift": 1500000, "bongkarManPower": 2500000, "receivingDelivery": 1700000, "potongSealKarantina": 750000, "pemotonganSealSampel": 1000000}, "nomorContainer": "WHSU789098"}], "biayaLainLain": [], "bongkarForklift": 0, "bongkarManPower": 0, "movingCargoRate": 500000, "passThroughTotal": 0, "penumpukanTpsAsal": 0, "totalBiayaLainLain": 0, "potongSealKarantina": 0, "pemotonganSealSampel": 0, "penumpukanLoloTpsAsal": 0, "penumpukanTerminalAsal": 0, "potongSealKarantinaRate": 750000, "pemotonganSealSampelRate": 1000000, "penumpukanLoloTerminalAsal": 0}, "jenisLayanan": "FCL TPP — BDN", "jumlahContainer": 1}	TERBIT	BELUM_BAYAR	\N	cmotm2f970000ov4i1nvtm4rv	2026-05-07 04:16:26.859	2026-05-07 04:16:26.859	\N	\N	\N	\N	\N	\N
cmov13u450008twbsjneqhg9u	KW-008/SG/GU/V/2026	2026	5	8	2026-05-07 05:11:36.159	GUDANG_FCL	Full Ekspor	\N	\N	cmov0s1tt00003j1jfi7m6guv	\N	PT ABC	1405000.00	154550.00	1559550.00	0.00	1559550.00	{"doc": {"id": "cmov0s1tt00003j1jfi7m6guv", "cbm": null, "nomorHBL": null, "tglMasuk": null, "consignee": "PT ABC", "tglKeluar": null, "containers": [{"id": 1778130112248.43, "kapal": "BEIJING", "ukuran": "20'", "voyage": "2505E", "tglMasuk": "2026-02-03", "tglKeluar": "2026-02-10", "sealNumber": "CN1029831", "nomorContainer": "MAEU1923180"}], "pemilikBarang": "PT ABC", "jenisTransaksi": "FCL"}, "form": {"diskon": "", "tujuan": "full_ekspor", "catatan": "", "biayaLainLain": [{"nama": "lAINNYA", "nominal": "100000"}], "includeFumigasi": false, "includeJasaGudang": false, "includeAdministrasi": false}, "npwp": "", "klien": null, "alamat": "", "tujuan": "Full Ekspor", "kalkulasi": {"dpp": 1405000, "ppn": 154550, "diskon": 0, "fumigasi": 0, "subTotal": 1405000, "grandTotal": 1559550, "jasaGudang": 0, "administrasi": 0, "perContainer": [{"hari": 8, "baris": [{"label": "Paket Lolo dan Trucking", "qty20": 1, "qty40": "", "tarif": 1200000, "jumlah": 1200000}, {"hari": 3, "label": "Pengelolaan Penyimpanan", "qty20": 1, "qty40": "", "tarif": 35000, "jumlah": 105000}], "ukuran": "20'", "loloStd": 1200000, "storStd": 35000, "subTotal": 1305000, "tglMasuk": "2026-02-03", "tglKeluar": "2026-02-10", "hariCharge": 3, "nomorContainer": "MAEU1923180"}], "biayaLainLain": [{"nama": "lAINNYA", "nominal": "100000"}], "totalBiayaLainLain": 100000}, "jenisLayanan": "Gudang Umum FCL", "jumlahContainer": 1}	TERBIT	BELUM_BAYAR	\N	cmotm2f970000ov4i1nvtm4rv	2026-05-07 05:11:36.245	2026-05-07 05:11:36.245	\N	\N	\N	\N	\N	\N
\.


--
-- Data for Name: klien; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.klien (id, kode, nama, alamat, npwp, telepon, email, aktif, "createdAt", "updatedAt", "freeTimeDays") FROM stdin;
\.


--
-- Data for Name: nomor_kw_sequence; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.nomor_kw_sequence (tahun, terakhir) FROM stdin;
2026	8
\.


--
-- Data for Name: refresh_tokens; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.refresh_tokens (id, token, "userId", "expiresAt", "createdAt") FROM stdin;
cmotnx4wh0001zyz45ytu0joz	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJjbW90bTJmOTcwMDAwb3Y0aTFudnRtNHJ2IiwidHlwZSI6InJlZnJlc2giLCJpYXQiOjE3NzgwNDgwODIsImV4cCI6MTc3ODY1Mjg4Mn0.Iko-jbtDOczGQv4oLCKTL76NIjHQgRTSxSJ54sZWK_M	cmotm2f970000ov4i1nvtm4rv	2026-05-13 06:14:42.447	2026-05-06 06:14:42.449
cmou18uxo000118laz2255qou	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJjbW90bTJmOTcwMDAwb3Y0aTFudnRtNHJ2IiwidHlwZSI6InJlZnJlc2giLCJpYXQiOjE3NzgwNzA0NjQsImV4cCI6MTc3ODY3NTI2NH0.xZHkWHcY0aaLBiiRZXvOHKUX6k0HxON8gaT-gVb4OP4	cmotm2f970000ov4i1nvtm4rv	2026-05-13 12:27:44.373	2026-05-06 12:27:44.374
cmouctj7q0001pk5r2ggf2qp1	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJjbW90bTJmOTcwMDAwb3Y0aTFudnRtNHJ2IiwidHlwZSI6InJlZnJlc2giLCJpYXQiOjE3NzgwODk5MDQsImV4cCI6MTc3ODY5NDcwNH0.aDoW8T30HgE8lEdA-IjhTvaQbubvCexrLOjjqJsnHQw	cmotm2f970000ov4i1nvtm4rv	2026-05-13 17:51:44.772	2026-05-06 17:51:44.773
cmoudpvcx0001havmal24e1ez	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJjbW90bTJmOTcwMDAwb3Y0aTFudnRtNHJ2IiwidHlwZSI6InJlZnJlc2giLCJpYXQiOjE3NzgwOTE0MTMsImV4cCI6MTc3ODY5NjIxM30.cWjrZj9up8ORNAPZAk9RydNCIvp9OMRc-UpjsCxIxYE	cmotm2f970000ov4i1nvtm4rv	2026-05-13 18:16:53.502	2026-05-06 18:16:53.505
cmouwi4uv0001xtxrd1xg8qc6	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJjbW90bTJmOTcwMDAwb3Y0aTFudnRtNHJ2IiwidHlwZSI6InJlZnJlc2giLCJpYXQiOjE3NzgxMjI5NjUsImV4cCI6MTc3ODcyNzc2NX0.Sx4dyJdMrL2JCDk7Huzrp-wYT4I3wzmsVym1C8jGnKk	cmotm2f970000ov4i1nvtm4rv	2026-05-14 03:02:45.267	2026-05-07 03:02:45.269
cmouxwnm2000mxtxrre0vszxo	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJjbW90bTJmOTcwMDAwb3Y0aTFudnRtNHJ2IiwidHlwZSI6InJlZnJlc2giLCJpYXQiOjE3NzgxMjUzMjIsImV4cCI6MTc3ODczMDEyMn0.pN4bJ5ozo63nuGtUOTfOilPkuRijs0i_9Z3Pn46EJgw	cmotm2f970000ov4i1nvtm4rv	2026-05-14 03:42:02.376	2026-05-07 03:42:02.378
cmov092as0001juhlohiiby17	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJjbW90bTJmOTcwMDAwb3Y0aTFudnRtNHJ2IiwidHlwZSI6InJlZnJlc2giLCJpYXQiOjE3NzgxMjkyNjAsImV4cCI6MTc3ODczNDA2MH0.wH_y7uoemJlxlCI1gcRClfTMrZHS4dvov8J9iqrSba4	cmotm2f970000ov4i1nvtm4rv	2026-05-14 04:47:40.516	2026-05-07 04:47:40.517
cmov0xdbo0001twbs0254k2s0	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJjbW90bTJmOTcwMDAwb3Y0aTFudnRtNHJ2IiwidHlwZSI6InJlZnJlc2giLCJpYXQiOjE3NzgxMzAzOTQsImV4cCI6MTc3ODczNTE5NH0.W3qfKOQuiRRB6BjN9HRbs6PXiD9_x1pOXkjUQETOnsE	cmotm2f970000ov4i1nvtm4rv	2026-05-14 05:06:34.547	2026-05-07 05:06:34.548
cmov8xdw50005vc34kgh4zig6	eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VySWQiOiJjbW90bTJmOTcwMDAwb3Y0aTFudnRtNHJ2IiwidHlwZSI6InJlZnJlc2giLCJpYXQiOjE3NzgxNDM4MzIsImV4cCI6MTc3ODc0ODYzMn0.TqWJke5l0LuxBWRewu-qF1ljrnDObuYmqi-B_RAwzu8	cmotm2f970000ov4i1nvtm4rv	2026-05-14 08:50:32.212	2026-05-07 08:50:32.213
\.


--
-- Data for Name: tarif_global; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tarif_global (id, kategori, field, nilai, keterangan, "updatedAt", "updatedBy") FROM stdin;
cmotm2f9i0003ov4i115vkobt	tppFcl20	handling	1000000.00	\N	2026-05-06 05:22:49.926	\N
cmotm2f9m0004ov4i309flbzs	tppFcl20	mekanik	4000000.00	\N	2026-05-06 05:22:49.931	\N
cmotm2f9o0005ov4ikt990dd7	tppFcl20	receivingDelivery	1500000.00	\N	2026-05-06 05:22:49.932	\N
cmotm2f9p0006ov4ii1xhq2na	tppFcl20	storagePerHari	210000.00	\N	2026-05-06 05:22:49.934	\N
cmotm2f9r0007ov4imwo3m02g	tppFcl20	jasaTPP	1050000.00	\N	2026-05-06 05:22:49.936	\N
cmotm2f9t0008ov4ilkd317wo	tppFcl20	administrasi	500000.00	\N	2026-05-06 05:22:49.937	\N
cmotm2f9u0009ov4i752mohfc	tppFcl20	liftOffFull	1000000.00	\N	2026-05-06 05:22:49.939	\N
cmotm2f9w000aov4inpv1cory	tppFcl20	liftOnFull	1000000.00	\N	2026-05-06 05:22:49.94	\N
cmotm2f9x000bov4i8k88w13d	tppFcl20	liftOffEmpty	850000.00	\N	2026-05-06 05:22:49.942	\N
cmotm2f9z000cov4id2hq3hp2	tppFcl20	liftOnEmpty	850000.00	\N	2026-05-06 05:22:49.943	\N
cmotm2fa0000dov4i85yjk61u	tppFcl20	potongSealKarantina	750000.00	\N	2026-05-06 05:22:49.944	\N
cmotm2fa1000eov4irjsfkqsy	tppFcl20	dgDocFee	1500000.00	\N	2026-05-06 05:22:49.946	\N
cmotm2fa3000fov4ir859vlxd	tppFcl20	pemotonganSealSampel	1000000.00	\N	2026-05-06 05:22:49.947	\N
cmotm2fa5000gov4i3y8abdml	tppFcl20	movingCargo	500000.00	\N	2026-05-06 05:22:49.949	\N
cmotm2fa6000hov4ivx348gw5	tppFcl20	bongkarManPower	1500000.00	\N	2026-05-06 05:22:49.95	\N
cmotm2fa7000iov4iv4d25d6l	tppFcl20	muatManPower	1500000.00	\N	2026-05-06 05:22:49.952	\N
cmotm2fa9000jov4ipbj46gho	tppFcl20	bongkarForklift	1000000.00	\N	2026-05-06 05:22:49.954	\N
cmotm2faa000kov4imk4xzgt4	tppFcl20	muatForklift	1000000.00	\N	2026-05-06 05:22:49.955	\N
cmotm2fab000lov4i3njiuk6s	tppFcl40	handling	1000000.00	\N	2026-05-06 05:22:49.956	\N
cmotm2fad000mov4ijf3wm8pk	tppFcl40	mekanik	5000000.00	\N	2026-05-06 05:22:49.957	\N
cmotm2fae000nov4i5wsefq24	tppFcl40	receivingDelivery	1700000.00	\N	2026-05-06 05:22:49.958	\N
cmotm2faf000oov4ioag2pf37	tppFcl40	storagePerHari	400000.00	\N	2026-05-06 05:22:49.96	\N
cmotm2fah000pov4i8p5ufy3d	tppFcl40	jasaTPP	1050000.00	\N	2026-05-06 05:22:49.961	\N
cmotm2fai000qov4iodwu6a9k	tppFcl40	administrasi	500000.00	\N	2026-05-06 05:22:49.962	\N
cmotm2faj000rov4ieqhmsytg	tppFcl40	liftOnFull	1200000.00	\N	2026-05-06 05:22:49.963	\N
cmotm2fak000sov4ic6sjpo82	tppFcl40	liftOffFull	1200000.00	\N	2026-05-06 05:22:49.965	\N
cmotm2fal000tov4ic56elwhk	tppFcl40	liftOnEmpty	1000000.00	\N	2026-05-06 05:22:49.966	\N
cmotm2fam000uov4iajecjblk	tppFcl40	liftOffEmpty	1000000.00	\N	2026-05-06 05:22:49.967	\N
cmotm2fao000vov4igpp6pric	tppFcl40	potongSealKarantina	750000.00	\N	2026-05-06 05:22:49.968	\N
cmotm2fap000wov4iijbo2umv	tppFcl40	dgDocFee	1500000.00	\N	2026-05-06 05:22:49.97	\N
cmotm2faq000xov4i07crq5zu	tppFcl40	pemotonganSealSampel	1000000.00	\N	2026-05-06 05:22:49.971	\N
cmotm2fas000yov4i1oj6w4iq	tppFcl40	movingCargo	500000.00	\N	2026-05-06 05:22:49.972	\N
cmotm2fat000zov4ipy1azq3d	tppFcl40	bongkarManPower	2500000.00	\N	2026-05-06 05:22:49.974	\N
cmotm2fau0010ov4ixiiq73es	tppFcl40	muatManPower	2500000.00	\N	2026-05-06 05:22:49.975	\N
cmotm2faw0011ov4i00fbp7qm	tppFcl40	bongkarForklift	1500000.00	\N	2026-05-06 05:22:49.976	\N
cmotm2fax0012ov4i9dz66z89	tppFcl40	muatForklift	1500000.00	\N	2026-05-06 05:22:49.978	\N
cmotm2fay0013ov4iyxegijz1	tppFclFR	handling	1000000.00	\N	2026-05-06 05:22:49.979	\N
cmotm2fb00014ov4inpllc6kw	tppFclFR	mekanik	8000000.00	\N	2026-05-06 05:22:49.98	\N
cmotm2fb10015ov4ipu7x19v8	tppFclFR	receivingDelivery	2200000.00	\N	2026-05-06 05:22:49.981	\N
cmotm2fb20016ov4ixrxqbf3f	tppFclFR	storagePerHari	800000.00	\N	2026-05-06 05:22:49.982	\N
cmotm2fb30017ov4in66wloda	tppFclFR	jasaTPP	2050000.00	\N	2026-05-06 05:22:49.984	\N
cmotm2fb50018ov4ij28lvqfz	tppFclFR	administrasi	500000.00	\N	2026-05-06 05:22:49.985	\N
cmotm2fb60019ov4i8kljixdm	lcl	strippingStuffingPerCBM	200000.00	\N	2026-05-06 05:22:49.987	\N
cmotm2fb8001aov4ibuywluu1	lcl	strippingMinCBM	3.00	\N	2026-05-06 05:22:49.988	\N
cmotm2fb9001bov4irw633jw1	lcl	mekanikPerCBM	250000.00	\N	2026-05-06 05:22:49.99	\N
cmotm2fba001cov4i36gmgz1e	lcl	storagePerCBMPerHari	15000.00	\N	2026-05-06 05:22:49.991	\N
cmotm2fbc001dov4ied3hnw9e	lcl	jasaTPP	500000.00	\N	2026-05-06 05:22:49.992	\N
cmotm2fbe001eov4i6kawmpxv	lcl	administrasi	150000.00	\N	2026-05-06 05:22:49.994	\N
cmotm2fbf001fov4ifubzdmza	lcl	behandle	450000.00	\N	2026-05-06 05:22:49.995	\N
cmotm2fbg001gov4i26gpovot	lcl	dgDocs	450000.00	\N	2026-05-06 05:22:49.997	\N
cmotm2fbi001hov4ifu6b2uwv	gudangUmum	paketLoloTrucking20	1200000.00	\N	2026-05-06 05:22:49.998	\N
cmotm2fbj001iov4izirks2y0	gudangUmum	paketLoloTrucking40	1300000.00	\N	2026-05-06 05:22:49.999	\N
cmotm2fbk001jov4iike95gw2	gudangUmum	storage20PerHari	35000.00	\N	2026-05-06 05:22:50	\N
cmotm2fbl001kov4im2h5eg16	gudangUmum	storage40PerHari	35000.00	\N	2026-05-06 05:22:50.002	\N
cmotm2fbn001lov4iejhplmdi	gudangUmum	fumigasi	100000.00	\N	2026-05-06 05:22:50.003	\N
cmotm2fbo001mov4itwfh6o4m	gudangUmum	freeTimeDays	5.00	\N	2026-05-06 05:22:50.004	\N
cmotm2fbp001nov4igxresko4	gudangUmumLCL	strippingStuffingPerCBM	200000.00	\N	2026-05-06 05:22:50.006	\N
cmotm2fbr001oov4i5euf8dri	gudangUmumLCL	strippingMinCBM	3.00	\N	2026-05-06 05:22:50.007	\N
cmotm2fbs001pov4ibwna8coy	gudangUmumLCL	mekanikPerCBM	250000.00	\N	2026-05-06 05:22:50.009	\N
cmotm2fbu001qov4ijssff8vx	gudangUmumLCL	storagePerCBMPerHari	15000.00	\N	2026-05-06 05:22:50.01	\N
cmotm2fbv001rov4ic3xoi0ca	gudangUmumLCL	jasaGudang	500000.00	\N	2026-05-06 05:22:50.011	\N
cmotm2fbw001sov4iq72rhv7s	gudangUmumLCL	administrasi	150000.00	\N	2026-05-06 05:22:50.013	\N
cmotm2fby001tov4iqjqn36p0	gudangUmumLCL	behandle	450000.00	\N	2026-05-06 05:22:50.014	\N
\.


--
-- Data for Name: tarif_khusus; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.tarif_khusus (id, "klienId", kategori, field, nilai, catatan, "createdAt", "updatedAt") FROM stdin;
\.


--
-- Data for Name: users; Type: TABLE DATA; Schema: public; Owner: postgres
--

COPY public.users (id, nama, email, "passwordHash", role, aktif, "createdAt", "updatedAt") FROM stdin;
cmotm2f970000ov4i1nvtm4rv	Administrator	admin@saranagemilang.com	$2b$12$1nfwW8oSILqo9RuqQDHD3.3GQTaA5AGFB4LNli7B.i1ksKDxttfPq	ADMIN	t	2026-05-06 05:22:49.916	2026-05-06 05:22:49.916
cmotm2f9f0001ov4ioidic5lf	Supervisor	supervisor@saranagemilang.com	$2b$12$PrrpIgkoCeyaamc/6BM4SeHOLoKd1GpdPvrhhpXAP4Gv2QIa0pfmC	SUPERVISOR	t	2026-05-06 05:22:49.923	2026-05-06 05:22:49.923
cmotm2f9g0002ov4ii2ts4wrv	Staff Finance	staff@saranagemilang.com	$2b$12$PrrpIgkoCeyaamc/6BM4SeHOLoKd1GpdPvrhhpXAP4Gv2QIa0pfmC	STAFF	t	2026-05-06 05:22:49.925	2026-05-06 05:22:49.925
\.


--
-- Name: _prisma_migrations _prisma_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public._prisma_migrations
    ADD CONSTRAINT _prisma_migrations_pkey PRIMARY KEY (id);


--
-- Name: audit_log audit_log_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_log
    ADD CONSTRAINT audit_log_pkey PRIMARY KEY (id);


--
-- Name: bdn_dokumen bdn_dokumen_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bdn_dokumen
    ADD CONSTRAINT bdn_dokumen_pkey PRIMARY KEY (id);


--
-- Name: btd_dokumen btd_dokumen_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.btd_dokumen
    ADD CONSTRAINT btd_dokumen_pkey PRIMARY KEY (id);


--
-- Name: gudang_dokumen gudang_dokumen_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.gudang_dokumen
    ADD CONSTRAINT gudang_dokumen_pkey PRIMARY KEY (id);


--
-- Name: invoice_baris invoice_baris_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoice_baris
    ADD CONSTRAINT invoice_baris_pkey PRIMARY KEY (id);


--
-- Name: invoices invoices_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT invoices_pkey PRIMARY KEY (id);


--
-- Name: klien klien_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.klien
    ADD CONSTRAINT klien_pkey PRIMARY KEY (id);


--
-- Name: nomor_kw_sequence nomor_kw_sequence_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.nomor_kw_sequence
    ADD CONSTRAINT nomor_kw_sequence_pkey PRIMARY KEY (tahun);


--
-- Name: refresh_tokens refresh_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.refresh_tokens
    ADD CONSTRAINT refresh_tokens_pkey PRIMARY KEY (id);


--
-- Name: tarif_global tarif_global_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tarif_global
    ADD CONSTRAINT tarif_global_pkey PRIMARY KEY (id);


--
-- Name: tarif_khusus tarif_khusus_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tarif_khusus
    ADD CONSTRAINT tarif_khusus_pkey PRIMARY KEY (id);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: audit_log_createdAt_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "audit_log_createdAt_idx" ON public.audit_log USING btree ("createdAt");


--
-- Name: audit_log_entitas_entitasId_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "audit_log_entitas_entitasId_idx" ON public.audit_log USING btree (entitas, "entitasId");


--
-- Name: audit_log_userId_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "audit_log_userId_idx" ON public.audit_log USING btree ("userId");


--
-- Name: bdn_dokumen_nomorKepBdn_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "bdn_dokumen_nomorKepBdn_idx" ON public.bdn_dokumen USING btree ("nomorKepBdn");


--
-- Name: bdn_dokumen_pemilikBarang_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "bdn_dokumen_pemilikBarang_idx" ON public.bdn_dokumen USING btree ("pemilikBarang");


--
-- Name: btd_dokumen_nomorBcf_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "btd_dokumen_nomorBcf_idx" ON public.btd_dokumen USING btree ("nomorBcf");


--
-- Name: btd_dokumen_pemilikBarang_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "btd_dokumen_pemilikBarang_idx" ON public.btd_dokumen USING btree ("pemilikBarang");


--
-- Name: btd_dokumen_status_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX btd_dokumen_status_idx ON public.btd_dokumen USING btree (status);


--
-- Name: gudang_dokumen_blNomor_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "gudang_dokumen_blNomor_idx" ON public.gudang_dokumen USING btree ("blNomor");


--
-- Name: gudang_dokumen_consignee_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX gudang_dokumen_consignee_idx ON public.gudang_dokumen USING btree (consignee);


--
-- Name: invoice_baris_invoiceId_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "invoice_baris_invoiceId_idx" ON public.invoice_baris USING btree ("invoiceId");


--
-- Name: invoices_deletedAt_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "invoices_deletedAt_idx" ON public.invoices USING btree ("deletedAt");


--
-- Name: invoices_nomorKW_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "invoices_nomorKW_idx" ON public.invoices USING btree ("nomorKW");


--
-- Name: invoices_nomorKW_key; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX "invoices_nomorKW_key" ON public.invoices USING btree ("nomorKW");


--
-- Name: invoices_status_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoices_status_idx ON public.invoices USING btree (status);


--
-- Name: invoices_tahun_sequence_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX invoices_tahun_sequence_idx ON public.invoices USING btree (tahun, sequence);


--
-- Name: invoices_tanggalInvoice_idx; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX "invoices_tanggalInvoice_idx" ON public.invoices USING btree ("tanggalInvoice");


--
-- Name: klien_kode_key; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX klien_kode_key ON public.klien USING btree (kode);


--
-- Name: refresh_tokens_token_key; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX refresh_tokens_token_key ON public.refresh_tokens USING btree (token);


--
-- Name: tarif_global_kategori_field_key; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX tarif_global_kategori_field_key ON public.tarif_global USING btree (kategori, field);


--
-- Name: tarif_khusus_klienId_kategori_field_key; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX "tarif_khusus_klienId_kategori_field_key" ON public.tarif_khusus USING btree ("klienId", kategori, field);


--
-- Name: users_email_key; Type: INDEX; Schema: public; Owner: postgres
--

CREATE UNIQUE INDEX users_email_key ON public.users USING btree (email);


--
-- Name: audit_log audit_log_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.audit_log
    ADD CONSTRAINT "audit_log_userId_fkey" FOREIGN KEY ("userId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: bdn_dokumen bdn_dokumen_klienId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.bdn_dokumen
    ADD CONSTRAINT "bdn_dokumen_klienId_fkey" FOREIGN KEY ("klienId") REFERENCES public.klien(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: btd_dokumen btd_dokumen_klienId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.btd_dokumen
    ADD CONSTRAINT "btd_dokumen_klienId_fkey" FOREIGN KEY ("klienId") REFERENCES public.klien(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: invoice_baris invoice_baris_invoiceId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoice_baris
    ADD CONSTRAINT "invoice_baris_invoiceId_fkey" FOREIGN KEY ("invoiceId") REFERENCES public.invoices(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: invoices invoices_bdnDokumenId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT "invoices_bdnDokumenId_fkey" FOREIGN KEY ("bdnDokumenId") REFERENCES public.bdn_dokumen(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: invoices invoices_btdDokumenId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT "invoices_btdDokumenId_fkey" FOREIGN KEY ("btdDokumenId") REFERENCES public.btd_dokumen(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: invoices invoices_createdById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT "invoices_createdById_fkey" FOREIGN KEY ("createdById") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: invoices invoices_deletedById_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT "invoices_deletedById_fkey" FOREIGN KEY ("deletedById") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: invoices invoices_gudangDokumenId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT "invoices_gudangDokumenId_fkey" FOREIGN KEY ("gudangDokumenId") REFERENCES public.gudang_dokumen(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: invoices invoices_klienId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.invoices
    ADD CONSTRAINT "invoices_klienId_fkey" FOREIGN KEY ("klienId") REFERENCES public.klien(id) ON UPDATE CASCADE ON DELETE SET NULL;


--
-- Name: refresh_tokens refresh_tokens_userId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.refresh_tokens
    ADD CONSTRAINT "refresh_tokens_userId_fkey" FOREIGN KEY ("userId") REFERENCES public.users(id) ON UPDATE CASCADE ON DELETE CASCADE;


--
-- Name: tarif_khusus tarif_khusus_klienId_fkey; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.tarif_khusus
    ADD CONSTRAINT "tarif_khusus_klienId_fkey" FOREIGN KEY ("klienId") REFERENCES public.klien(id) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: SCHEMA public; Type: ACL; Schema: -; Owner: postgres
--

REVOKE USAGE ON SCHEMA public FROM PUBLIC;


--
--

\unrestrict vgaVUkipVuf7vr1aI9NtgMnL7ciD08trnkEgJyGTS7Yfl2XbTfjSTpt919n5dWe

