objek_pajak.py
2.62 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
from sqlalchemy import (
Column,
String,
Integer,
Float,
Date,
DateTime,
)
from sqlalchemy.ext.declarative import declared_attr
class BaseObjekPajakMixin:
@declared_attr
def __tablename__(self):
return 'dat_objek_pajak'
@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 subjek_pajak_id(self):
return Column(String(30))
@declared_attr
def no_formulir_spop(self):
return Column(String(11))
@declared_attr
def no_persil(self):
return Column(String(5))
@declared_attr
def jalan_op(self):
return Column(String(30))
@declared_attr
def blok_kav_no_op(self):
return Column(String(15))
@declared_attr
def rw_op(self):
return Column(String(2))
@declared_attr
def rt_op(self):
return Column(String(3))
@declared_attr
def kd_status_cabang(self):
return Column(Integer)
@declared_attr
def kd_status_wp(self):
return Column(String(1))
@declared_attr
def total_luas_bumi(self):
return Column(Float)
@declared_attr
def total_luas_bng(self):
return Column(Float)
@declared_attr
def njop_bumi(self):
return Column(Float)
@declared_attr
def njop_bng(self):
return Column(Float)
@declared_attr
def status_peta_op(self):
return Column(Integer)
@declared_attr
def jns_transaksi_op(self):
return Column(String(1))
@declared_attr
def tgl_pendataan_op(self):
return Column(Date)
@declared_attr
def tgl_pemeriksaan_op(self):
return Column(Date)
@declared_attr
def nip_pemeriksa_op(self):
return Column(String(18))
@declared_attr
def tgl_perekaman_op(self):
return Column(DateTime)
@declared_attr
def nip_perekam_op(self):
return Column(String(18))
class ObjekPajakMixin(BaseObjekPajakMixin):
@declared_attr
def nip_pendata(self):
return Column(String(18))