models.py
2.86 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 sqlalchemy import (
Column,
Integer,
Float,
String,
Date,
Time,
DateTime,
UniqueConstraint,
)
from sqlalchemy.ext.declarative import declarative_base
Base = declarative_base()
class Pad(Base):
__tablename__ = 'pad_report'
id = Column(Integer, primary_key=True)
# Bit 11
stan = Column(String(6), nullable=False)
# Bit 48
ntb = Column(String(32), nullable=False)
# pad.pad_sspd.create_date
tgl = Column(Date, nullable=False)
# pad.pad_sspd.sspdjam
jam = Column(Time, nullable=False)
# pad.pad_sspd.id
sspd_id = Column(Integer, nullable=False)
# Bit 61
nomor_bayar = Column(String(16), nullable=False)
# pad.pad_pajak.masapajak
masa_pajak = Column(Integer, nullable=False)
# pad.pad_customer
npwpd = Column(String(17), nullable=False)
# pad.pad_customer.customernm
nama_wp = Column(String(150), nullable=False)
# pad.pad_sspd.jml_bayar - pad.pad_sspd.denda
pokok = Column(Float, nullable=False)
# pad.pad_sspd.denda
denda = Column(Float, nullable=False)
# pad.pad_sspd.jml_bayar
jml_bayar = Column(Float, nullable=False)
# Bit 18
channel_id = Column(String(4), nullable=False)
# Bit 41 / 42 / 43
channel_name = Column(String(32), nullable=False)
# pad_reversal.tgl
tgl_batal = Column(DateTime(timezone=True))
__table_args__ = (
UniqueConstraint('stan', 'ntb'),
)
class Bphtb(Base):
__tablename__ = 'bphtb_report'
id = Column(Integer, primary_key=True)
# Bit 11
stan = Column(String(6), nullable=False)
# Bit 58
ntb = Column(String(32), nullable=False)
# bphtb.bphtb_bank.tanggal
tgl = Column(Date, nullable=False)
# bphtb.bphtb_bank.jam
jam = Column(Time, nullable=False)
# Bit 62
invoice_id = Column(String(16), nullable=False)
# Bit 61
nop = Column(String(22), nullable=False)
# bphtb.bphtb_bank.wp_nama
wp_nama = Column(String(50), nullable=False)
# bphtb.bphtb_bank.wp_alamat
wp_alamat = Column(String(100), nullable=False)
# bphtb.bphtb_sspd.op_alamat
op_alamat = Column(String(100), nullable=False)
# bphtb.bphtb_bank.npop
npop = Column(Float, nullable=False)
# bphtb.bphtb_bank.bumi_luas
bumi_luas = Column(Integer, nullable=False)
# bphtb.bphtb_bank.bng_luas
bng_luas = Column(Integer, nullable=False)
# Bit 4
nilai_bphtb = Column(Float, nullable=False)
# bphtb.bphtb_perolehan.nama
jenis_perolehan = Column(String(100), nullable=False)
# bphtb.bphtb_ppat.nama
ppat = Column(String(50), nullable=False)
# Bit 18
channel_id = Column(String(4), nullable=False)
# Bit 41 / 42 / 43
channel_nama = Column(String(32), nullable=False)
# bphtb.bphtb_reversal.tgl
tgl_batal = Column(DateTime(timezone=True))
__table_args__ = (
UniqueConstraint('stan', 'ntb'),
)