Database Neuviz (PT. Piranti Prestasi Informasi)

Toxy · Jun 7, 2025

You must be registered for see images attach

SAMPLE

Code:

SERT INTO `ags_tpsonline_gatein` (`id`, `KD_DOK`, `KD_TPS`, `NM_ANGKUT`, `NO_VOY_FLIGHT`, `CALL_SIGN`, `TGL_TIBA`, `KD_GUDANG`, `REF_NUMBER`, `NO_BL_AWB`, `TGL_BL_AWB`, `NO_MASTER_BL_AWB`, `TGL_MASTER_BL_AWB`, `ID_CONSIGNEE`, `CONSIGNEE`, `BRUTO`, `NO_BC11`, `TGL_BC11`, `NO_POS_BC11`, `CONT_ASAL`, `SERI_KEMAS`, `KD_KEMAS`, `JML_KEMAS`, `KD_TIMBUN`, `JENIS`, `CAR`, `KD_DOK_INOUT`, `NO_DOK_INOUT`, `TGL_DOK_INOUT`, `WK_INOUT`, `KD_SAR_ANGKUT_INOUT`, `NO_POL`, `PEL_MUAT`, `PEL_TRANSIT`, `PEL_BONGKAR`, `GUDANG_TUJUAN`, `KODE_KANTOR`, `NO_DAFTAR_PABEAN`, `TGL_DAFTAR_PABEAN`, `NO_SEGEL_BC`, `TGL_SEGEL_BC`, `NO_IJIN_TPS`, `TGL_IJIN_TPS`, `waktu_penegahan`, `waktu_release`, `remarks_penegahan`, `nama_beacukai`, `UraianBarang`, `KETERANGAN`, `NOMOR_PLP`, `TANGGAL_PLP`, `ConsigneeAddress`, `remarks_release`, `nama_beacukai_release`) VALUES
(1, '5', 'RCI1', 'SAUDI ARABIAN AIRLINES', '4', NULL, '2019-05-12', 'TB10', 'TB10190522000227', '2019E00007X', '2019-05-12', '065-17006916', '2019-05-02', '000000000000000', 'PT.UBK MANUFAKTUR INDONESIA', '147.00', '020679', '2019-05-12', '0300010000', NULL, NULL, 'PK', 1, NULL, NULL, NULL, '3', '044702', '2019-05-17', '2019-05-22 10:35', NULL, '', 'SAJED', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(2, '5', 'RCI1', 'CHINA AIRLINES', '4', NULL, '2020-08-30', 'TB10', 'TB10200907000199', '297-49317144', '2020-08-27', '297-49317144', '2020-08-27', '000000000000000', 'PT. TELESINDO PRATAMA', '13.00', '017003', '2020-08-30', '6900010000', NULL, NULL, 'PK', 3, NULL, NULL, NULL, '3', '062131', '2020-09-01', '2020-09-07 09:58', NULL, '', 'USCHI', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(3, '5', 'RCI1', 'GARUDA INDONESIA', '4', NULL, '2021-11-25', 'TB10', 'TB10211126000316', 'A21120422', '2021-11-24', '126-85973370', '2021-11-24', '000000000000000', '-PT.MEDISON JAYA RAYA (025273046014000)', '110.00', '018792', '2021-11-25', '0300010000', NULL, NULL, 'PK', 10, NULL, NULL, NULL, '3', '185488', '2021-11-26', '2021-11-26 15:54', NULL, '', 'SGSIN', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(4, '5', 'RCI1', 'CHINA AIRLINES', '4', NULL, '2023-05-04', 'TB10', 'TB10230505000253', 'AMA000042634', '2023-04-26', '297-85217941', '2023-04-28', '000000000000000', 'PT.ESSENCE INDONESIA ', '2.00', '014932', '2023-05-04', '003400010000', NULL, NULL, 'PK', 1, NULL, NULL, NULL, '3', '028606', '2023-05-04', '2023-05-05 14:19', NULL, '', 'TWTPE', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(5, '5', 'RCI1', 'QATAR AIRWAYS', '4', NULL, '2023-05-01', 'TB10', 'TB10230502000245', 'AMA000042649', '2023-04-28', '157-65560180', '2023-04-28', '000000000000000', 'PT.ESSENCE INDONESIA ', '48.00', '014485', '2023-05-01', '001600010000', NULL, NULL, 'PK', 5, NULL, NULL, NULL, '3', '028048', '2023-05-02', '2023-05-02 17:06', NULL, '', 'QADOH', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(6, '5', 'RCI1', 'CHINA AIRLINES', '4', NULL, '2023-05-04', 'TB10', 'TB10230505000252', 'AMA000042654', '2023-04-28', '297-85217941', '2023-04-28', '000000000000000', 'PT.ESSENCE INDONESIA ', '30.00', '014932', '2023-05-04', '003400020000', NULL, NULL, 'PK', 1, NULL, NULL, NULL, '3', '028606', '2023-05-04', '2023-05-05 14:19', NULL, '', 'TWTPE', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(7, '5', 'RCI1', 'QATAR AIRWAYS ', '4', NULL, '2023-05-08', 'TB10', 'TB10230509000269', 'AMA000042689', '2023-05-04', '157-65560261', '2023-05-05', '000000000000000', 'PT.ESSENCE INDONESIA ', '54.00', '015519', '2023-05-08', '002200010000', NULL, NULL, 'PK', 4, NULL, NULL, NULL, '3', '029660', '2023-05-09', '2023-05-09 14:44', NULL, '', 'QADOH', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(8, '5', 'RCI1', 'CHINA AIRLINES', '4', NULL, '2017-06-02', 'TB10', 'TB10170706000108', 'CEI-160176', '2017-05-27', '297-6703 8764', '2017-05-27', '000000000000000', 'PT. MASTRADA', '467.00', '022794', '2017-06-02', '2200010000', NULL, NULL, 'PK', 2, NULL, NULL, NULL, '3', '1462', '2017-06-06', '2017-07-06 15:09', NULL, '', 'USCHI', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(9, '5', 'RCI1', 'CHINA AIRLINES', '4', NULL, '2017-06-24', 'TB10', 'TB10170720000118', 'CEI-160530', '2017-06-22', '297-6703 9523', '2017-06-22', '000000000000000', 'PT. MASTRADA', '310.00', '026148', '2017-06-24', '0100010000', NULL, NULL, 'PK', 8, NULL, NULL, NULL, '3', '804', '2017-07-04', '2017-07-20 14:29', NULL, '', 'USCHI', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(10, '5', 'RCI1', 'JAPAN AIRLINES', '4', NULL, '2019-07-20', 'TB10', 'TB10190724000362', 'CEL21632483', '2019-07-19', '131-53622133', '2019-07-19', '000000000000000', 'PT.MITRABINA REKANIAGA', '85.00', '031486', '2019-07-20', '2200010000', NULL, NULL, 'PK', 8, NULL, NULL, NULL, '3', '066218', '2019-07-22', '2019-07-24 09:46', NULL, '', 'JPNRT', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(11, '5', 'RCI1', 'ALL NIPPON AIRWAYS', '4', NULL, '2019-08-26', 'TB10', 'TB10190829000411', 'CIA000037863', '2019-08-16', '205-84328355', '2019-08-24', '000000000000000', 'PT.INTAV PRIMA SOLUSINDO', '335.00', '037464', '2019-08-26', '0400010000', NULL, NULL, 'PK', 2, NULL, NULL, NULL, '3', '079493', '2019-08-27', '2019-08-29 13:12', NULL, '', 'JPNRT', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(12, '5', 'RCI1', 'CATHAY PACIFIC AIRWAYS', '4', NULL, '2017-12-10', 'TB10', 'TB10171228000277', 'CNL/000020993', '2017-12-09', '160-5742 0016', '2017-12-09', '000000000000000', 'PT.BETARI SEJATI INDONESIA', '190.00', '052528', '2017-12-10', '2600010000', NULL, NULL, 'PK', 1, NULL, NULL, NULL, '3', '', '0000-00-00', '2017-12-28 11:08', NULL, '', 'ITMXP', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(13, '5', 'RCI1', 'CATHAY PACIFIC AIRWAYS', '4', NULL, '2021-09-05', 'TB10', 'TB10210906000224', 'CPL-008755', '2021-09-04', '160-63301895', '2021-09-03', '000000000000000', 'PT.LAUTAN LUAS TBK (013159009054000)', '394.00', '013905', '2021-09-05', '2600010000', NULL, NULL, 'PK', 2, NULL, NULL, NULL, '3', '164550', '2021-09-06', '2021-09-06 15:59', NULL, '', 'HKHKG', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(14, '5', 'RCI1', 'ASIANA AIRLINES', '4', NULL, '2019-01-29', 'TB10', 'TB10190204000051', 'DA000010676', '2019-01-25', '988-87630815', '2019-01-25', '000000000000000', 'PT.INDOFOOD FRITOLAY MAKMUR', '844.00', '004606', '2019-01-29', '0700010000', NULL, NULL, 'PK', 1, NULL, NULL, NULL, '3', '009132', '2019-01-30', '2019-02-04 10:33', NULL, '', 'KRINC', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(15, '5', 'RCI1', 'EVA AIRWAYS', '4', NULL, '2020-12-25', 'TB10', 'TB10201229000327', 'FRA-600051487', '2020-12-15', '695-23252180', '2020-12-15', '000000000000000', 'PT. MIRICI (013438049028000)', '100.00', '023347', '2020-12-25', '0300010000', NULL, NULL, 'PK', 1, NULL, NULL, NULL, '3', '095698', '2020-12-28', '2020-12-29 11:00', NULL, '', 'TWTPE', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(16, '5', 'RCI1', 'EMIRATES', '4', NULL, '2019-02-18', 'TB10', 'TB10190221000088', 'FRA-600404118', '2019-02-15', '176-97177150', '2019-02-15', '000000000000000', 'PT.MIRICI', '140.00', '007728', '2019-02-18', '2400010000', NULL, NULL, 'PK', 1, NULL, NULL, NULL, '3', '014836', '2019-02-19', '2019-02-21 10:51', NULL, '', 'AEDXB', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(17, '5', 'RCI1', 'ALL NIPPON AIRWAYS', '4', NULL, '2023-05-07', 'TB10', 'TB10230508000261', 'GLAE23050063', '2023-05-06', '205-89255736', '2023-05-06', '000000000000000', 'PT. SK GLOVE INDONESIA', '422.00', '015403', '2023-05-07', '000400010000', NULL, NULL, 'PK', 24, NULL, NULL, NULL, '3', '029343', '2023-05-08', '2023-05-08 11:57', NULL, '', 'JPNRT', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(18, '5', 'RCI1', 'ASIANA AIRLINES', '4', NULL, '2019-10-07', 'TB10', 'TB10191009000483', 'HOA000003145', '2019-10-01', '988-21242196', '2019-10-01', '000000000000000', 'PT. MEDICI GRAHA INDONESIA', '64.00', '044238', '2019-10-07', '0100010000', NULL, NULL, 'PK', 1, NULL, NULL, NULL, '3', '095312', '2019-10-09', '2019-10-09 16:09', NULL, '', 'KRINC', '', 'IDCGK', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),

👋 Welcome to Our Community!

Database Neuviz (PT. Piranti Prestasi Informasi)

Toxy