"""Worksheet Account Contract Payable After Tax."""

from sqlalchemy import Column
from sqlalchemy import DateTime
from sqlalchemy import Integer
from sqlalchemy import Numeric
from sqlalchemy import String

from moneyhub.models.mysql_base import BaseModel


class WorksheetAccountContractPayableAfterTax(BaseModel):
    """Worksheet Account Contract Payable After Tax model."""

    __tablename__ = 'worksheet_account_contract_payable_after_tax'

    worksheet_account_contract_payable_after_tax_id = Column(Integer, primary_key=True)
    worksheet_account_contract_closing_balance_id = Column(Integer, nullable=False)
    account_id = Column(Integer, nullable=False)
    statement_period_id = Column(Integer, nullable=False)
    contract_id = Column(Integer, nullable=True)
    abacus_event_id = Column(Integer, nullable=False)
    payable_amount_pre_tax = Column(Numeric(20, 2), nullable=False)
    tax_withholding_amount = Column(Numeric(20, 2), nullable=False)
    vat_amount = Column(Numeric(20, 2), nullable=True)
    payable_amount_post_tax = Column(Numeric(20, 2), nullable=False)
    currency_code = Column(String(3), nullable=False)
    country_of_tax_residence = Column(String(180), nullable=False)
    country_of_tax_policy = Column(String(180), nullable=False)
    created_at = Column(DateTime, nullable=True)
    created_by = Column(String(180), nullable=False)
    last_modified = Column(DateTime, nullable=False)
    last_modified_by = Column(String(180), nullable=False)
    deleted_at = Column(DateTime, nullable=True)
    deleted_by = Column(String(180), nullable=True)