"""Passthru Processed model."""

from sqlalchemy import BigInteger
from sqlalchemy import Column
from sqlalchemy import Date
from sqlalchemy import DECIMAL
from sqlalchemy import Integer
from sqlalchemy import VARCHAR

from ows_accounting.connectors import accountingflat


class PassthruProcessed(accountingflat.BaseModel):
    """Class for passthru_processed model."""

    __tablename__ = 'passthru_processed'

    statement_detail_id = Column(BigInteger, nullable=False, primary_key=True)
    vendor_id = Column(Integer)
    period_id = Column(Integer)
    dms_customer_id = Column(Integer)
    date = Column(Date)
    upc = Column(Integer)
    cd = Column(Integer)
    track_id = Column(Integer)
    qty = Column(Integer)
    amount = Column(DECIMAL(18, 6))
    trans_type = Column(VARCHAR(length=2))
    payout_currency_id = Column(Integer)
    fx_adjusted_exchange_rate = Column(
        DECIMAL(18, 6), nullable=False, default=1.0)
    original_price = Column(DECIMAL(18, 6))