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 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 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 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 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 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 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)