"""Ledger Reserve Taken model."""

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

from moneyhub.models.mysql_base import BaseModel


class LedgerReserveTaken(BaseModel):
    """Ledger Reserve Taken model."""

    __tablename__ = 'ledger_reserve_taken'
    ledger_reserve_taken_id = Column(Integer, primary_key=True)
    abacus_event_id = Column(Integer, nullable=False)
    contract_reserve_id = Column(Integer, nullable=False)
    accounting_run_id = Column(Integer, nullable=False)
    statement_period_id = Column(Integer, nullable=False)
    currency_code = Column(String(3), nullable=True)
    gross_sales = Column(Numeric(20, 2), nullable=True)
    gross_returns = Column(Numeric(20, 2), nullable=True)
    net_revenue = Column(Numeric(20, 2), nullable=True)
    reserve_amount = Column(Numeric(20, 2), nullable=True)
    net_revenue_after_reserve = Column(Numeric(20, 2), nullable=True)