"""Model for the SapPerpetualInventory."""

from sqlalchemy import Column, Date, Integer, String
from sqlalchemy.ext.declarative import declarative_base

BaseModel = declarative_base()


class SapPerpetualInventory(BaseModel):
    """SapPerpetualInventory."""

    __tablename__ = 'sap_perpetual_inventory'

    supply_chain_id = Column(
        Integer, nullable=True, name='SUPPLY_CHAIN_ID', primary_key=True
    )
    local_product_cd = Column(
        Integer, nullable=True, name='LOCAL_PRODUCT_CD', primary_key=True
    )
    reporting_dt = Column(
        Date, nullable=True, name='REPORTING_DT', primary_key=True
    )
    plant_code = Column(String(25), nullable=True, name='PLANT')

    opening_inventory = Column(Integer, nullable=True, name='UNIT_OPEN_BAL')
    incoming = Column(Integer, nullable=True, name='UNIT_RECEIPTS')
    shipped = Column(Integer, nullable=True, name='UNIT_GROSS_SHP')
    warehouse_scrap = Column(Integer, nullable=True, name='UNIT_WHS_SCRAP')
    shrinkage = Column(Integer, nullable=True, name='UNIT_SHRINKAGE')
    rework = Column(Integer, nullable=True, name='UNIT_REWORK')
    reval = Column(Integer, nullable=True, name='UNIT_REVAL')
    other = Column(Integer, nullable=True, name='UNIT_OTHER')
    closing_inventory = Column(Integer, nullable=True, name='UNIT_TOTAL')
    open_scrap_qt = Column(Integer, nullable=True, name='OPEN_SCRAP_QT')

    overstock_12_month_qt = Column(
        Integer, nullable=True, name='OVERSTOCK_12_MTH_QT'
    )
    overstock_24_month_qt = Column(
        Integer, nullable=True, name='OVERSTOCK_24_MTH_QT'
    )