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)