sukabumi_kota.py
6.57 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
from sqlalchemy import (
Column,
String,
Integer,
Float,
DateTime,
ForeignKey,
ForeignKeyConstraint,
)
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class Propinsi(Base):
__tablename__ = 'REF_PROPINSI'
KD_PROPINSI = Column(String(2), primary_key=True)
NM_PROPINSI = Column(String(30))
class Kabupaten(Base):
__tablename__ = 'REF_DATI2'
KD_PROPINSI = Column(
String(2), ForeignKey(Propinsi.KD_PROPINSI), primary_key=True)
KD_DATI2 = Column(String(2), primary_key=True)
NM_DATI2 = Column(String(30))
class Kecamatan(Base):
__tablename__ = 'REF_KECAMATAN'
KD_PROPINSI = Column(String(2), primary_key=True)
KD_DATI2 = Column(String(2), primary_key=True)
KD_KECAMATAN = Column(String(3), primary_key=True)
NM_KECAMATAN = Column(String(30))
__table_args__ = (
ForeignKeyConstraint([
KD_PROPINSI, KD_DATI2], [
Kabupaten.KD_PROPINSI, Kabupaten.KD_DATI2]),)
class Kelurahan(Base):
__tablename__ = 'REF_KELURAHAN'
KD_PROPINSI = Column(String(2), primary_key=True)
KD_DATI2 = Column(String(2), primary_key=True)
KD_KECAMATAN = Column(String(3), primary_key=True)
KD_KELURAHAN = Column(String(3), primary_key=True)
KD_SEKTOR = Column(String(2))
NM_KELURAHAN = Column(String(30))
NO_KELURAHAN = Column(Float)
KD_POS_KELURAHAN = Column(String(5))
__table_args__ = (
ForeignKeyConstraint([
KD_PROPINSI, KD_DATI2, KD_KECAMATAN], [
Kecamatan.KD_PROPINSI, Kecamatan.KD_DATI2,
Kecamatan.KD_KECAMATAN]),)
class Objek(Base):
__tablename__ = 'DAT_OBJEK_PAJAK'
KD_PROPINSI = Column(String(2), primary_key=True)
KD_DATI2 = Column(String(2), primary_key=True)
KD_KECAMATAN = Column(String(3), primary_key=True)
KD_KELURAHAN = Column(String(3), primary_key=True)
KD_BLOK = Column(String(3), primary_key=True)
NO_URUT = Column(String(4), primary_key=True)
KD_JNS_OP = Column(String(1), primary_key=True)
SUBJEK_PAJAK_ID = Column(String(30))
NO_FORMULIR_SPOP = Column(String(11))
NO_PERSIL = Column(String(5))
JALAN_OP = Column(String(30))
BLOK_KAV_NO_OP = Column(String(15))
RW_OP = Column(String(2))
RT_OP = Column(String(3))
KD_STATUS_CABANG = Column(Float)
KD_STATUS_WP = Column(String(1))
TOTAL_LUAS_BUMI = Column(Float)
TOTAL_LUAS_BNG = Column(Float)
NJOP_BUMI = Column(Float)
NJOP_BNG = Column(Float)
STATUS_PETA_OP = Column(Float)
JNS_TRANSAKSI_OP = Column(String(1))
TGL_PENDATAAN_OP = Column(DateTime)
NIP_PENDATA = Column(String(9))
TGL_PEMERIKSAAN_OP = Column(DateTime)
NIP_PEMERIKSA_OP = Column(String(9))
TGL_PEREKAMAN_OP = Column(DateTime)
NIP_PEREKAM_OP = Column(String(9))
STATUS_WP = Column(Integer, nullable=False)
STATUS_PROSES = Column(Integer, nullable=False)
THN_PENILAIAN = Column(Integer, nullable=False)
class Sppt(Base):
__tablename__ = 'SPPT'
KD_PROPINSI = Column(String(2), primary_key=True)
KD_DATI2 = Column(String(2), primary_key=True)
KD_KECAMATAN = Column(String(3), primary_key=True)
KD_KELURAHAN = Column(String(3), primary_key=True)
KD_BLOK = Column(String(3), primary_key=True)
NO_URUT = Column(String(4), primary_key=True)
KD_JNS_OP = Column(String(1), primary_key=True)
THN_PAJAK_SPPT = Column(String(4), primary_key=True)
SIKLUS_SPPT = Column(Float)
KD_KANWIL_BANK = Column(String(2))
KD_KPPBB_BANK = Column(String(2))
KD_BANK_TUNGGAL = Column(String(2))
KD_BANK_PERSEPSI = Column(String(2))
KD_TP = Column(String(2))
NM_WP_SPPT = Column(String(30))
JLN_WP_SPPT = Column(String(30))
BLOK_KAV_NO_WP_SPPT = Column(String(15))
RW_WP_SPPT = Column(String(2))
RT_WP_SPPT = Column(String(3))
KELURAHAN_WP_SPPT = Column(String(30))
KOTA_WP_SPPT = Column(String(30))
KD_POS_WP_SPPT = Column(String(5))
NPWP_SPPT = Column(String(15))
NO_PERSIL_SPPT = Column(String(5))
KD_KLS_TANAH = Column(String(3))
THN_AWAL_KLS_TANAH = Column(String(4))
KD_KLS_BNG = Column(String(3))
THN_AWAL_KLS_BNG = Column(String(4))
TGL_JATUH_TEMPO_SPPT = Column(DateTime)
LUAS_BUMI_SPPT = Column(Float)
LUAS_BNG_SPPT = Column(Float)
NJOP_BUMI_SPPT = Column(Float)
NJOP_BNG_SPPT = Column(Float)
NJOP_SPPT = Column(Float)
NJOPTKP_SPPT = Column(Float)
NJKP_SPPT = Column(Float)
PBB_TERHUTANG_SPPT = Column(Float)
FAKTOR_PENGURANG_SPPT = Column(Float)
PBB_YG_HARUS_DIBAYAR_SPPT = Column(Float)
STATUS_PEMBAYARAN_SPPT = Column(String(1))
STATUS_TAGIHAN_SPPT = Column(String(1))
STATUS_CETAK_SPPT = Column(String(1))
TGL_TERBIT_SPPT = Column(DateTime)
TGL_CETAK_SPPT = Column(DateTime)
NIP_PENCETAK_SPPT = Column(String(9))
STATUS_WP = Column(Integer, nullable=False)
STATUS_PENYEBARAN = Column(Integer)
STATUS_BUKTI_BAYAR = Column(Integer)
TGL_UPDATE_BUKTI = Column(DateTime)
__table_args__ = (
ForeignKeyConstraint([
KD_PROPINSI, KD_DATI2, KD_KECAMATAN, KD_KELURAHAN, KD_BLOK,
NO_URUT, KD_JNS_OP], [
Objek.KD_PROPINSI, Objek.KD_DATI2, Objek.KD_KECAMATAN,
Objek.KD_KELURAHAN, Objek.KD_BLOK, Objek.NO_URUT,
Objek.KD_JNS_OP]),)
class PembayaranSppt(Base):
__tablename__ = 'PEMBAYARAN_SPPT'
KD_PROPINSI = Column(String(2), primary_key=True)
KD_DATI2 = Column(String(2), primary_key=True)
KD_KECAMATAN = Column(String(3), primary_key=True)
KD_KELURAHAN = Column(String(3), primary_key=True)
KD_BLOK = Column(String(3), primary_key=True)
NO_URUT = Column(String(4), primary_key=True)
KD_JNS_OP = Column(String(1), primary_key=True)
THN_PAJAK_SPPT = Column(String(4), primary_key=True)
PEMBAYARAN_SPPT_KE = Column(Float, primary_key=True)
KD_KANWIL_BANK = Column(String(2), nullable=False)
KD_KPPBB_BANK = Column(String(2), nullable=False)
KD_BANK_TUNGGAL = Column(String(2), nullable=False)
KD_BANK_PERSEPSI = Column(String(2), nullable=False)
KD_TP = Column(String(2), nullable=False)
DENDA_SPPT = Column(Float)
JML_SPPT_YG_DIBAYAR = Column(Float)
TGL_PEMBAYARAN_SPPT = Column(DateTime)
TGL_REKAM_BYR_SPPT = Column(DateTime)
NIP_REKAM_BYR_SPPT = Column(String(9))
__table_args__ = (
ForeignKeyConstraint([
KD_PROPINSI, KD_DATI2, KD_KECAMATAN, KD_KELURAHAN, KD_BLOK,
NO_URUT, KD_JNS_OP, THN_PAJAK_SPPT], [
Sppt.KD_PROPINSI, Sppt.KD_DATI2, Sppt.KD_KECAMATAN,
Sppt.KD_KELURAHAN, Sppt.KD_BLOK, Sppt.NO_URUT, Sppt.KD_JNS_OP,
Sppt.THN_PAJAK_SPPT]),)