Table Struktur
CREATE TABLE jenis_pemda (
id serial NOT NULL ,
uraian varchar ,
CONSTRAINT pk_jenis_pemda_id PRIMARY KEY ( id )
);
CREATE TABLE ketetapan (
id bigserial NOT NULL ,
jns_pemda varchar(16) ,
kd_pemda varchar(8) ,
nm_pemda varchar(128) ,
kd_rek_objek varchar(32) ,
nm_rek_objek varchar(128) ,
kd_rek_rinci varchar(16) ,
nm_rek_rinci varchar(128) ,
kelompok varchar(32) ,
nop varchar(32) ,
nm_op varchar ,
alamat_op varchar(128) ,
alamat_op2 varchar(128) ,
kelurahan_op varchar(64) ,
kecamatan_op varchar(64) ,
kota_op varchar(64) ,
propinsi_op varchar(64) ,
kd_wp varchar(32) ,
nm_wp varchar(128) ,
npwpd varchar(32) ,
alamat_wp varchar(128) ,
alamat_wp2 varchar(128) ,
kelurahan_wp varchar(64) ,
kecamatan_wp varchar(64) ,
kota_wp varchar(64) ,
propinsi_wp varchar(64) ,
njop bigint ,
persen_pajak smallint ,
pokok bigint ,
denda bigint ,
tgl_tetap timestamp ,
periode_awal timestamp ,
periode_akhir timestamp ,
tahun_pajak smallint ,
bulan_pajak smallint ,
tahun_tetap smallint ,
bulan_tetap smallint ,
tanggal_tetap smallint ,
jns_tetap varchar(8) ,
CONSTRAINT pk_ketetapan_id PRIMARY KEY ( id )
);
COMMENT ON COLUMN ketetapan.nm_rek_objek IS 'nm_objek';
COMMENT ON COLUMN ketetapan.jns_tetap IS 'Jenis Ketetapan\nSelfAssesment/SA\nOfficialAssessment/OA\nKB\nLB\nKBT\nSTPD';
CREATE TABLE objek_pajak (
id bigserial NOT NULL ,
jns_pemda varchar(16) ,
kd_pemda varchar(8) ,
nm_pemda varchar(128) ,
kd_rek_objek varchar(32) ,
nm_rek_objek varchar(128) ,
kd_rek_rinci varchar(16) ,
nm_rek_rinci varchar(128) ,
kelompok varchar(64) ,
nop varchar(32) ,
nm_op varchar(128) ,
alamat_op varchar(128) ,
alamat_op2 varchar(128) ,
kelurahan_op varchar(64) ,
kecamatan_op varchar(64) ,
kota_op varchar(64) ,
propinsi_op varchar(64) ,
kd_wp varchar(32) ,
nm_wp varchar(128) ,
npwpd varchar(32) ,
alamat_wp varchar(128) ,
alamat_wp2 varchar(128) ,
kelurahan_wp varchar(64) ,
kecamatan_wp varchar(64) ,
kota_wp varchar(64) ,
propinsi_wp varchar(64) ,
njop bigint ,
persen_pajak smallint ,
pokok bigint ,
denda bigint ,
tgl_tetap timestamp ,
CONSTRAINT pk_objek_pajak_id PRIMARY KEY ( id )
);
CREATE TABLE pajak (
id serial NOT NULL ,
kode varchar(32) ,
nama varchar(128) ,
CONSTRAINT pk_pajak_id PRIMARY KEY ( id )
);
CREATE TABLE pemda (
id serial NOT NULL ,
kode varchar(32) ,
nama varchar(64) ,
CONSTRAINT pk_pemda_id PRIMARY KEY ( id )
);
CREATE TABLE t_mstkb (
no_polisi char(9) ,
kd_status char(1) ,
kd_mohon1 char(1) ,
kd_mohon2 char(1) ,
kd_mohon3 char(1) ,
kd_mohon4 char(1) ,
kd_mohon5 char(1) ,
kd_mohon6 char(1) ,
nm_pemilik char(40) ,
al_pemilik char(60) ,
kd_wil char(5) ,
kd_kecamatan char(2) ,
kd_pos char(6) ,
kd_wil_proses char(5) ,
kd_jenis_kb char(3) ,
kd_merek_kb char(9) ,
nm_merek_kb char(15) ,
nm_model_kb char(40) ,
th_buatan char(4) ,
th_rakitan char(4) ,
warna_kb char(25) ,
jumlah_cc char(5) ,
no_rangka char(25) ,
no_mesin char(25) ,
no_bpkb char(12) ,
kd_bbm char(1) ,
bbm char(10) ,
kd_plat char(1) ,
warna_tnkb char(10) ,
no_pol_lama char(9) ,
no_skpd char(10) ,
no_stnkb integer ,
no_urut_daf integer ,
no_skum char(16) ,
no_kohir1 char(30) ,
no_kohir2 integer ,
kd_bank char(3) ,
bea_bbnkb1_pok numeric(10,0) ,
bea_bbnkb1_den numeric(10,0) ,
bea_bbnkb1_tgk numeric(10,0) ,
bea_bbnkb2_pok numeric(10,0) ,
bea_bbnkb2_den numeric(10,0) ,
bea_bbnkb2_tgk numeric(10,0) ,
bea_pkb_pok numeric(10,0) ,
bea_pkb_den numeric(10,0) ,
bea_pkb_tgk1 numeric(10,0) ,
bea_pkb_den1 numeric(10,0) ,
bea_pkb_tgk2 numeric(10,0) ,
bea_pkb_den2 numeric(10,0) ,
bea_pkb_tgk3 numeric(10,0) ,
bea_pkb_den3 numeric(10,0) ,
bea_pkb_tgk4 numeric(10,0) ,
bea_pkb_den4 numeric(10,0) ,
bea_swdkllj_pok numeric(8,0) ,
bea_swdkllj_den numeric(8,0) ,
bea_swdkllj_tgk1 numeric(8,0) ,
bea_swdkllj_den1 numeric(8,0) ,
bea_swdkllj_tgk2 numeric(8,0) ,
bea_swdkllj_den2 numeric(8,0) ,
bea_swdkllj_tgk3 numeric(8,0) ,
bea_swdkllj_den3 numeric(8,0) ,
bea_swdkllj_tgk4 numeric(8,0) ,
bea_swdkllj_den4 numeric(8,0) ,
bea_adm_stnk numeric(8,0) ,
bea_adm_tnkb numeric(8,0) ,
bea_adm_bpkb numeric(12,0) ,
milik_ke smallint ,
tg_kepemilikan date ,
tg_faktur date ,
tg_kwitansi date ,
tg_fiskal date ,
tg_uben date ,
tg_gntmesin date ,
tg_akhir_pajak date ,
tg_akhir_pjklm date ,
tg_akhir_pjkbr date ,
tg_akhir_stnkb date ,
tg_pros_daftar date ,
tg_pros_tetap date ,
tg_pros_bayar date ,
tg_cetak_stnkb date ,
tg_tera_stnkb date ,
kd_trf_swdkllj char(1) ,
kd_cetak_stnk char(1) ,
kd_cetak_tnkb char(1) ,
kd_blockir char(1) ,
kd_kasir char(1) ,
kd_stnk_habis char(1) ,
kd_keringanan char(1) ,
kd_plat_lama char(1) ,
nm_operator char(20) ,
jam_proses char(10) ,
tty_id char(20) ,
kd_fungsi char(2) ,
no_ktp char(18) ,
kd_dealer char(3) ,
no_antrian smallint ,
st_antrian char(1) ,
nm_pengurus char(15) ,
glr_dpn char(12) ,
glr_blk char(12) ,
rt char(2) ,
rw char(2) ,
npwpd char(16)
);