class Entry(Model):
table_name = 'accounting_system_entry'
id_atr = IntField(blank=True)
date_to_execute_atr = DateTimeField()
description_atr = TextField(blank=True)
status_atr = IntField()
created_atr = DateTimeField()
class UserData(Model):
table_name = 'reconciliation_userdata'
id_atr = IntField(blank=True)
prev_month_net_atr = FloatField(is_encoded=False, blank=True)
account_atr = FloatField(is_encoded=False, blank=True)
zp_cash_atr = FloatField(is_encoded=False, blank=True)
podushka_atr = FloatField(is_encoded=False, blank=True)
account_plus_minus_atr = FloatField(is_encoded=False, blank=True)
cash_atr = FloatField(is_encoded=False, blank=True)
social_atr = FloatField(is_encoded=False, blank=True)
date_reports_atr = DateTimeField(blank=True)
date_services_atr = DateTimeField(blank=True)
date_income_data_atr = DateTimeField(blank=True)
date_account_atr = DateTimeField(blank=True)
date_reconciliation_atr = DateTimeField(blank=True)
qty_of_reconciliations_atr = IntField()
user_id_atr = ForeignKeyField(User)
compensations_total_atr = FloatField(is_encoded=False, blank=True)
deadline_atr = FloatField(is_encoded=False, blank=True)
office_fees_atr = FloatField(is_encoded=False, blank=True)
payout_rate_atr = FloatField(is_encoded=False, blank=True)
services_total_atr = FloatField(is_encoded=False, blank=True)
total_net_month_atr = FloatField(is_encoded=False, blank=True)
entries_created_atr = BoolField()
total_sterling_atr = FloatField(is_encoded=False, blank=True)
total_takion_atr = FloatField(is_encoded=False, blank=True)
custom_payout_rate_atr = FloatField(is_encoded=False, blank=True)
custom_podushka_atr = BoolField()
class HistoryCompanyBill(Model):
table_name = 'accounting_system_historycompanybill'
id_atr = IntField(blank=True)
model_id_atr = ForeignKeyField(CompanyBill)
history_date_atr = DateTimeField()
history_change_reason_atr = TextField(blank=True)
caused_by_transaction_atr = IntField(blank=True)
history_type_atr = TextField()
history_created_atr = DateTimeField()
amount_atr = FloatField(is_encoded=False)
name_atr = TextField()
entry_id_atr = ForeignKeyField(Entry, blank=True)
class AccountType(Model):
table_name = 'accounting_system_accounttype'
id_atr = IntField(blank=True)
account_regexp_atr = TextField()
company_id_atr = ForeignKeyField(Company)
broker_id_atr = ForeignKeyField(Broker)
clearing_id_atr = ForeignKeyField(Clearing)
propreports_subdomain_id_atr = ForeignKeyField(PropreportsSubdomain)
class ReconciliationUserPropaccounts(Model):
table_name = 'reconciliation_reconciliationuserpropaccount'
id_atr = IntField(blank=True)
account_atr = TextField(is_encoded=False)
month_adj_net_atr = FloatField(is_encoded=False, blank=True)
# summary_by_date_atr = TextField(is_encoded=False, blank=True)
updated_atr = DateTimeField()
user_id_atr = ForeignKeyField(User)
account_type_id_atr = ForeignKeyField(AccountType)
class Transaction(Model):
table_name = 'accounting_system_transaction'
id_atr = IntField(blank=True)
side_atr = IntField()
amount_atr = FloatField(is_encoded=False)
currency_atr = TextField()
rate_to_usd_atr = IntField()
amount_usd_atr = FloatField(is_encoded=False)
description_atr = TextField(blank=True)
created_atr = DateTimeField()
status_atr = IntField()
company_bill_id_atr = ForeignKeyField(CompanyBill, blank=True)
entry_id_atr = ForeignKeyField(Entry)
initiated_process_id_atr = ForeignKeyField(ASProcess, blank=True)
initiated_user_id_atr = ForeignKeyField(User, blank=True)
user_bill_id_atr = ForeignKeyField(UserBill, blank=True)
account_type_id_atr = ForeignKeyField(AccountType, blank=True)
account_atr = TextField(is_encoded=False, blank=True)
class Services(Model):
table_name = 'reconciliation_service'
id_atr = IntField(blank=True)
name_atr = TextField(is_encoded=False)
service_type_atr = TextField()
amount_atr = FloatField(is_encoded=False)
effective_datetime_atr = DateTimeField()
created_atr = DateTimeField(auto_fill=True)
user_id_atr = ForeignKeyField(User)
class User(Model):
table_name = 'index_customuser'
id_atr = IntField(blank=True)
password_atr = TextField()
last_login_atr = DateTimeField(blank=True)
is_superuser_atr = BoolField(blank=True)
username_atr = TextField()
first_name_atr = TextField(blank=True)
last_name_atr = TextField(blank=True)
email_atr = TextField(blank=True)
is_staff_atr = BoolField(blank=True)
is_active_atr = BoolField(blank=True)
date_joined_atr = DateTimeField(blank=True)
hr_id_atr = IntField(blank=True)
sb_id_atr = IntField(blank=True)
telegram_id_atr = IntField(blank=True)
first_work_day_atr = DateTimeField(blank=True)
fop_atr = BoolField(blank=True)
patronymic_atr = TextField(blank=True)
class UserPropaccounts(Model):
table_name = 'reconciliation_userpropaccount'
id_atr = IntField(blank=True)
account_atr = TextField(is_encoded=False)
daily_gross_atr = FloatField(is_encoded=False, blank=True)
daily_adj_net_atr = FloatField(is_encoded=False, blank=True)
daily_unreal_atr = FloatField(is_encoded=False, blank=True)
month_gross_atr = FloatField(is_encoded=False, blank=True)
month_unreal_atr = FloatField(is_encoded=False, blank=True)
month_adj_net_atr = FloatField(is_encoded=False, blank=True)
effective_date_atr = DateTimeField()
created_atr = DateTimeField(auto_fill=True)
user_id_atr = ForeignKeyField(User)
account_type_id_atr = ForeignKeyField(AccountType)
class Broker(Model):
table_name = 'accounting_system_broker'
id_atr = IntField(blank=True)
name_atr = TextField()
class Clearing(Model):
table_name = 'accounting_system_clearing'
id_atr = IntField(blank=True)
name_atr = TextField()
class PropreportsaccountId(Model):
table_name = 'reconciliation_propreportsaccountid'
id_atr = IntField(blank=True)
account_atr = TextField(is_encoded=False)
propreports_id_atr = IntField()
group_id_atr = IntField()
class UserGroup(Model):
table_name = 'index_customuser_groups'
id_atr = IntField(blank=True)
customuser_id_atr = ForeignKeyField(User)
group_id_atr = ForeignKeyField(Group)
class Group(Model):
table_name = 'auth_group'
id_atr = IntField(blank=True)
name_atr = TextField()
class UserMainData(Model):
table_name = 'accounting_system_usermaindata'
id_atr = IntField(blank=True)
unreal_month_atr = FloatField(is_encoded=False, blank=True)
gross_month_atr = FloatField(is_encoded=False, blank=True)
adj_net_month_atr = FloatField(is_encoded=False, blank=True)
services_total_atr = IntField(is_encoded=False, blank=True)
compensations_total_atr = IntField(is_encoded=False, blank=True)
office_fees_atr = IntField(is_encoded=False, blank=True)
prev_month_net_atr = IntField(is_encoded=False, blank=True)
total_net_month_atr = IntField(is_encoded=False, blank=True)
deadline_atr = IntField(is_encoded=False, blank=True)
payout_rate_atr = FloatField(is_encoded=False, blank=True)
change_plus_minus_atr = IntField(is_encoded=False, blank=True)
zp_cash_atr = IntField(is_encoded=False, blank=True)
company_cash_atr = IntField(is_encoded=False, blank=True)
social_atr = IntField(is_encoded=False, blank=True)
withdrawal_atr = IntField(is_encoded=False, blank=True)
effective_date_atr = DateTimeField()
created_atr = DateTimeField(auto_fill=True)
user_id_atr = ForeignKeyField(User)
class Company(Model):
table_name = 'accounting_system_company'
id_atr = IntField(blank=True)
name_atr = TextField()
class ASProcess(Model):
table_name = 'accounting_system_asprocess'
id_atr = IntField(blank=True)
name_atr = TextField()
description_atr = TextField()
class CompanyBill(Model):
table_name = 'accounting_system_companybill'
id_atr = IntField(blank=True)
name_atr = TextField()
amount_atr = FloatField(is_encoded=False)
class UserBill(Model):
table_name = 'accounting_system_userbill'
id_atr = IntField(blank=True)
amount_atr = FloatField(is_encoded=False)
bill_id_atr = ForeignKeyField(UserBillType)
user_id_atr = ForeignKeyField(User)
class UserBillType(Model):
table_name = 'accounting_system_userbilltypes'
id_atr = IntField(blank=True)
name_atr = TextField()
class PropreportsSubdomain(Model):
table_name = 'accounting_system_propreportssubdomain'
id_atr = IntField(blank=True)
subdomain_atr = TextField()
secrets_section_atr = TextField()