-- -- PostgreSQL database dump -- \restrict vgaVUkipVuf7vr1aI9NtgMnL7ciD08trnkEgJyGTS7Yfl2XbTfjSTpt919n5dWe -- Dumped from database version 18.3 -- Dumped by pg_dump version 18.3 SET statement_timeout = 0; SET lock_timeout = 0; SET idle_in_transaction_session_timeout = 0; SET transaction_timeout = 0; SET client_encoding = 'UTF8'; SET standard_conforming_strings = on; SELECT pg_catalog.set_config('search_path', '', false); SET check_function_bodies = false; SET xmloption = content; SET client_min_messages = warning; SET row_security = off; -- -- 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; SET default_tablespace = ''; SET default_table_access_method = heap; -- -- 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; -- -- PostgreSQL database dump complete -- \unrestrict vgaVUkipVuf7vr1aI9NtgMnL7ciD08trnkEgJyGTS7Yfl2XbTfjSTpt919n5dWe