dafnom.py
3.65 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
from tangsel.pbb.models.base_table import BaseSppt, BaseNop
from sqlalchemy import (Column, String, DateTime, Float)
from ..models import PbbBase, PBB_ARGS, BasePbb
class DafnomOp(PbbBase, BaseNop):
__tablename__ = 'dafnom_op'
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_pembentukan = Column(String(4), primary_key=True)
jalan_op = Column(String(30))
blok_kav_no_op = Column(String(15))
rw_op = Column(String(2))
rt_op = Column(String(3))
jns_bumi = Column(String(1))
kd_jpb = Column(String(2))
kd_status_wp = Column(String(1))
kategori_op = Column(String(1))
keterangan = Column(String(255))
no_formulir = Column(String(30))
tgl_pembentukan = Column(DateTime)
nip_pembentuk = Column(String(18))
tgl_pemutakhiran = Column(DateTime)
nip_pemutakhir = Column(String(18))
status_verifikasi = Column(String(1))
__table_args__ = (PBB_ARGS,)
class DafnomPiutang(PbbBase, BaseNop):
__tablename__ = 'dafnom_piutang'
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)
thn_pembentukan = Column(String(4), primary_key=True)
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))
luas_bumi_sppt = Column(Float)
luas_bng_sppt = Column(Float)
njop_bumi_sppt = Column(Float)
njop_bng_sppt = Column(Float)
pbb_yg_harus_dibayar_sppt = Column(Float)
tgl_jatuh_tempo_sppt = Column(DateTime)
status_bayar = Column(String(1))
keterangan = Column(String(255))
no_formulir = Column(String(30))
tgl_pembentukan = Column(DateTime)
nip_pembentuk = Column(String(18))
tgl_pemutakhiran = Column(DateTime)
nip_pemutakhir = Column(String(18))
__table_args__ = (PBB_ARGS,)
class DafnomGelondongan(PbbBase, BasePbb):
__tablename__ = 'dafnom_gelondongan'
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)
thn_pembentukan = Column(String(4), primary_key=True)
jumlah_gelondongan = Column(Float)
jumlah_sismiop = Column(Float)
saldo_gelondongan = Column(Float)
jumlah_lembar = Column(Float)
__table_args__ = (PBB_ARGS,)
class DafnomRinciGelondongan(PbbBase, BasePbb):
__tablename__ = 'dafnom_rinci_gelondongan'
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)
thn_pembentukan = Column(String(4), primary_key=True)
thn_pajak = Column(String(4), primary_key=True)
nm_dokumen = Column(String(50))
jumlah_gelondongan = Column(Float)
jumlah_sismiop = Column(Float)
saldo_gelondongan = Column(Float)
__table_args__ = (PBB_ARGS,)