cimahi.py
5.3 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
from sqlalchemy import (
Column,
Integer,
String,
DateTime,
Float,
Text,
UniqueConstraint,
ForeignKey,
)
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class Notaris(Base):
__tablename__ = 'r_ppat'
kd_ppat = Column(String(5), primary_key=True)
nama_ppat = Column(Text, nullable=False)
class Perolehan(Base):
__tablename__ = 'r_hak_perolehan'
kode = Column(String(2), primary_key=True)
uraian = Column(Text, nullable=False, unique=True)
class Invoice(Base):
__tablename__ = 'bookppat'
doc_id = Column(Integer, primary_key=True)
kd_ppat = Column(String(5), nullable=False)
th_booking = Column(String(4), nullable=False)
no_booking = Column(String(6))
no_booking2 = Column(String(6))
no_kunci = Column(String(8))
tgl_booking = Column(DateTime())
nop_dt1 = Column(String(2))
nop_dt2 = Column(String(2))
nop_camat = Column(String(3))
nop_lurah = Column(String(3))
nop_blok = Column(String(3))
nop_urut = Column(String(4))
nop_kode = Column(String(1))
nama_wp = Column(String(50))
alamat_wp = Column(String(50))
rtrw_wp = Column(String(7))
lurah_wp = Column(String(25))
camat_wp = Column(String(25))
kota_wp = Column(String(25))
kodepos = Column(String(5))
npwp_wp = Column(String(15))
nama_ow = Column(String(50))
alamat_ow = Column(String(50))
rtrw_ow = Column(String(7))
lurah_ow = Column(String(30))
camat_ow = Column(String(30))
kota_ow = Column(String(25))
kodepos_ow = Column(String(5))
npwp_ow = Column(String(15))
alamat_op = Column(String(50))
rtrw_op = Column(String(7))
lurah_op = Column(String(30))
camat_op = Column(String(30))
kota_op = Column(String(25))
no_serti = Column(String(100))
kd_strata = Column(Integer)
luas_tanah = Column(Float)
njop_tanah = Column(Integer)
nil_tanah = Column(Integer)
luas_bang = Column(Float)
njop_bang = Column(Integer)
nilai_bang = Column(Integer)
njop_pbb = Column(Integer)
harga_tran = Column(Integer)
kd_jphtb = Column(String(2), ForeignKey(Perolehan.kode))
pecah_bag = Column(Integer)
dari_bag = Column(Integer)
npop = Column(Integer)
npoptkp = Column(Integer)
npopkp = Column(Integer)
bphtb_utg = Column(Integer)
kd_prosen = Column(Float)
prosen_rp = Column(Integer)
denda_bln = Column(Integer)
denda_rp = Column(Integer)
pengenaan = Column(Integer)
kd_setor = Column(String(1))
sbb_kdset = Column(String(2))
nomor = Column(String(20))
tanggal = Column(DateTime)
kd_bayar = Column(String(1))
nil_setor = Column(Integer)
kd_tmpbyr = Column(String(2))
kd_terima = Column(Integer)
tgl_terima = Column(DateTime)
nm_terima = Column(String(30))
tgl_setor = Column(DateTime)
nm_setor = Column(String(30))
kd_pejabat = Column(String(1))
nm_pejabat = Column(String(30))
lt_kotor = Column(Float)
lb_kotor = Column(Float)
lb_efektif = Column(Float)
lb_unit = Column(Float)
lt_kotor_njop = Column(Integer)
lb_kotor_njop = Column(Integer)
lt_kotor_r = Column(Float)
lb_efektif_r = Column(Float)
lb_kotor_r = Column(Float)
lt_kotor_njop_r = Column(Integer)
lb_efektif_njop_r = Column(Integer)
lb_kotor_njop_r = Column(Integer)
lt_kotor_nil = Column(Integer)
lb_efektif_nil = Column(Integer)
lb_kotor_nil = Column(Integer)
njop_pbb_nil = Column(Integer)
fl_npopkp = Column(String(1))
Status = Column(String(1))
tgl_terima_berkas = Column(DateTime)
tgl_retrieve = Column(DateTime)
tgl_validasi = Column(DateTime)
tgl_diserahkan = Column(DateTime)
tgl_approve_bpn = Column(DateTime)
tgl_selesai_bpn = Column(DateTime)
NoBlanko = Column(String(10))
keterangan = Column(String(100))
tahun_ajb = Column(String(4))
petugas = Column(String(10))
th_skb = Column(String(4))
kd_skbkb = Column(String(6))
__table_args__ = (
UniqueConstraint(
kd_ppat, th_booking, no_booking, no_booking2, no_kunci),
)
class Payment(Base):
__tablename__ = 't_bank'
doc_id = Column(Integer, primary_key=True)
no_transaksi = Column(String(20))
nop_dt1 = Column(String(2))
nop_dt2 = Column(String(2))
nop_camat = Column(String(3))
nop_lurah = Column(String(3))
nop_blok = Column(String(3))
nop_urut = Column(String(4))
nop_kode = Column(String(1))
nama_wp = Column(String(50))
npwp = Column(String(15))
alamat_wp = Column(String(50))
lurah_wp = Column(String(25))
rtrw_wp = Column(String(7))
camat_wp = Column(String(25))
kota_wp = Column(String(25))
kodepos = Column(String(5))
alamat_op = Column(String(50))
nil_setor = Column(Integer)
kode_bank = Column(String(2))
tgl_transaksi = Column(DateTime)
nm_ptgs = Column(String(30))
no_seri = Column(String(10))
kd_ppat = Column(String(5))
th_booking = Column(String(4))
no_book = Column(String(6))
th_kb = Column(String(4))
no_kb = Column(String(6))
no_booking = Column(String(15))
ct = Column(Integer)
USERID = Column(String(12))
UPDATETIME = Column(DateTime)
# Tidak perlu mendapatkan nilai doc_id yang dipicu oleh trigger agar tidak
# error
__table_args__ = dict(implicit_returning=False)