sppt_akrual.py.bak
3.45 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
class SpptAkrual(pbbBase, CommonModel):
__tablename__ = 'sppt_akrual'
__table_args__ = PBB_ARGS
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(Integer, primary_key=True)
siklus_sppt = Column(Integer)
kd_kanwil = Column(String(2))
kd_kantor = 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(timezone=False))
luas_bumi_sppt = Column(BigInteger)
luas_bng_sppt = Column(BigInteger)
njop_bumi_sppt = Column(BigInteger)
njop_bng_sppt = Column(BigInteger)
njop_sppt = Column(BigInteger)
njoptkp_sppt = Column(BigInteger)
pbb_terhutang_sppt = Column(BigInteger)
faktor_pengurang_sppt = Column(BigInteger)
pbb_yg_harus_dibayar_sppt = Column(BigInteger)
status_pembayaran_sppt = Column(String(1))
status_tagihan_sppt = Column(String(1))
status_cetak_sppt = Column(String(1))
tgl_terbit_sppt = Column(DateTime(timezone=False))
tgl_cetak_sppt = Column(DateTime(timezone=False))
nip_pencetak_sppt = Column(String(18))
posted = Column(Integer)
create_date = Column(DateTime(timezone=False))
def __init__(cls):
pass
class SpptRekap(pbbBase, CommonModel):
__tablename__ = 'sppt_rekap'
__table_args__ = PBB_ARGS
id = Column(BigInteger, primary_key=True)
tanggal = Column(DateTime)
kode = Column(String(30))
uraian = Column(String(200))
pokok = Column(BigInteger)
posted = Column(Integer)
created = Column(DateTime)
create_uid = Column(Integer)
updated = Column(DateTime)
update_uid = Column(Integer)
def __init__(cls):
pass