sppt.py
3.6 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
from sqlalchemy import (
Column,
String,
Integer,
Date,
Float,
DateTime,
)
from sqlalchemy.ext.declarative import declared_attr
class BaseSpptMixin:
@declared_attr
def __tablename__(self):
return 'sppt'
@declared_attr
def kd_propinsi(self):
return Column(String(2), primary_key=True)
@declared_attr
def kd_dati2(self):
return Column(String(2), primary_key=True)
@declared_attr
def kd_kecamatan(self):
return Column(String(3), primary_key=True)
@declared_attr
def kd_kelurahan(self):
return Column(String(3), primary_key=True)
@declared_attr
def kd_blok(self):
return Column(String(3), primary_key=True)
@declared_attr
def no_urut(self):
return Column(String(4), primary_key=True)
@declared_attr
def kd_jns_op(self):
return Column(String(1), primary_key=True)
@declared_attr
def thn_pajak_sppt(self):
return Column(String(4), primary_key=True)
@declared_attr
def siklus_sppt(self):
return Column(Integer)
@declared_attr
def kd_tp(self):
return Column(String(2))
@declared_attr
def nm_wp_sppt(self):
return Column(String(30))
@declared_attr
def jln_wp_sppt(self):
return Column(String(30))
@declared_attr
def blok_kav_no_wp_sppt(self):
return Column(String(15))
@declared_attr
def rw_wp_sppt(self):
return Column(String(2))
@declared_attr
def rt_wp_sppt(self):
return Column(String(3))
@declared_attr
def kelurahan_wp_sppt(self):
return Column(String(30))
@declared_attr
def kota_wp_sppt(self):
return Column(String(30))
@declared_attr
def kd_pos_wp_sppt(self):
return Column(String(5))
@declared_attr
def npwp_sppt(self):
return Column(String(15))
@declared_attr
def no_persil_sppt(self):
return Column(String(5))
@declared_attr
def kd_kls_tanah(self):
return Column(String(3))
@declared_attr
def thn_awal_kls_tanah(self):
return Column(String(4))
@declared_attr
def kd_kls_bng(self):
return Column(String(3))
@declared_attr
def thn_awal_kls_bng(self):
return Column(String(4))
@declared_attr
def tgl_jatuh_tempo_sppt(self):
return Column(Date)
@declared_attr
def luas_bumi_sppt(self):
return Column(Float)
@declared_attr
def luas_bng_sppt(self):
return Column(Float)
@declared_attr
def njop_bumi_sppt(self):
return Column(Float)
@declared_attr
def njop_bng_sppt(self):
return Column(Float)
@declared_attr
def njop_sppt(self):
return Column(Float)
@declared_attr
def njoptkp_sppt(self):
return Column(Integer)
@declared_attr
def pbb_terhutang_sppt(self):
return Column(Float)
@declared_attr
def faktor_pengurang_sppt(self):
return Column(Float)
@declared_attr
def status_pembayaran_sppt(self):
return Column(String(1))
@declared_attr
def status_tagihan_sppt(self):
return Column(String(1))
@declared_attr
def status_cetak_sppt(self):
return Column(String(1))
@declared_attr
def tgl_terbit_sppt(self):
return Column(Date)
@declared_attr
def tgl_cetak_sppt(self):
return Column(DateTime)
@declared_attr
def nip_pencetak_sppt(self):
return Column(String(18))
class SpptMixin(BaseSpptMixin):
@declared_attr
def pbb_yg_harus_dibayar_sppt(self):
return Column(Float)