using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     物料条码表
/// </summary>
[SugarTable("MES_INV_ITEM_BARCODES")]
public class MesInvItemBarcodes
{
    /// <summary>
    ///     SEQ_BARCODE_PSN_ID
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_EQBASE",
        IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    /// 物料条码 
    ///</summary>
    [SugarColumn(ColumnName = "ITEM_BARCODE")]
    public string ItemBarcode { get; set; }

    /// <summary>
    /// 客户成品编码 
    ///</summary>
    [SugarColumn(ColumnName = "C_PRODUCT_CODE")]
    public string CProductCode { get; set; }

    /// <summary>
    /// 客户物料条码 
    ///</summary>
    [SugarColumn(ColumnName = "C_ITEM_BARCODE")]
    public string CItemBarcode { get; set; }

    /// <summary>
    /// 客户物料编码 
    ///</summary>
    [SugarColumn(ColumnName = "C_ITEM_CODE")]
    public string CItemCode { get; set; }

    /// <summary>
    /// 本司物料编码 
    ///</summary>
    [SugarColumn(ColumnName = "ITEM_NO")]
    public string ItemNo { get; set; }

    /// <summary>
    /// 厂家批次 
    ///</summary>
    [SugarColumn(ColumnName = "LOT_NO")]
    public string LotNo { get; set; }

    /// <summary>
    /// 数量 
    ///</summary>
    [SugarColumn(ColumnName = "QUANTITY")]
    public decimal? Quantity { get; set; }

    /// <summary>
    /// 是否环保(0:否,1:是) 
    ///</summary>
    [SugarColumn(ColumnName = "EP_FLAG")]
    public short? EpFlag { get; set; }

    /// <summary>
    /// 生产工单 
    ///</summary>
    [SugarColumn(ColumnName = "TASK_NO")]
    public string TaskNo { get; set; }

    /// <summary>
    /// 创建人 
    ///</summary>
    [SugarColumn(ColumnName = "CREATE_BY")]
    public string CreateBy { get; set; }

    /// <summary>
    /// 创建时间 
    ///</summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public DateTime? CreateDate { get; set; }

    /// <summary>
    /// 最后更新人 
    ///</summary>
    [SugarColumn(ColumnName = "LASTUPDATE_BY")]
    public string LastupdateBy { get; set; }

    /// <summary>
    /// 最后更新时间 
    ///</summary>
    [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
    public DateTime? LastupdateDate { get; set; }

    /// <summary>
    /// 客户编号 
    ///</summary>
    [SugarColumn(ColumnName = "CUST_NO")]
    public string CustNo { get; set; }

    /// <summary>
    /// 物料条码注释行[冗余，条码重打使用] 
    ///</summary>
    [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")]
    public string ItemBarcodeText { get; set; }

    /// <summary>
    /// 原PSN物料条码 
    ///</summary>
    [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")]
    public string OldItemBarcode { get; set; }

    /// <summary>
    /// SAP收货物料凭证号    --采购单号 
    ///</summary>
    [SugarColumn(ColumnName = "MBLNR")]
    public string Mblnr { get; set; }

    /// <summary>
    /// SAP收货物料凭证行号  --采购单行号 
    ///</summary>
    [SugarColumn(ColumnName = "ZEILE")]
    public decimal? Zeile { get; set; }

    /// <summary>
    /// 收料表ID 
    ///</summary>
    [SugarColumn(ColumnName = "ROH_IN_ID")]
    public decimal? RohInId { get; set; }

    /// <summary>
    /// 0为有效条码；1为无效条码 
    ///</summary>
    [SugarColumn(ColumnName = "BARCODESTATUS")]
    public short? Barcodestatus { get; set; }

    /// <summary>
    /// 原始数量 
    ///</summary>
    [SugarColumn(ColumnName = "OLDQTY")]
    public decimal? Oldqty { get; set; }

    /// <summary>
    /// 使用数量 
    ///</summary>
    [SugarColumn(ColumnName = "USEQTY")]
    public decimal? Useqty { get; set; }

    /// <summary>
    /// 0在库，1在线，2作废 
    ///</summary>
    [SugarColumn(ColumnName = "LOCATION")]
    public short? Location { get; set; }

    /// <summary>
    /// 单位 
    ///</summary>
    [SugarColumn(ColumnName = "UNIT")]
    public string Unit { get; set; }

    /// <summary>
    /// 重量（单位：公斤） 
    ///</summary>
    [SugarColumn(ColumnName = "WEIGHT_UNIT")]
    public decimal? WeightUnit { get; set; }

    /// <summary>
    /// 单价 
    ///</summary>
    [SugarColumn(ColumnName = "PRICE")]
    public decimal? Price { get; set; }

    /// <summary>
    /// 原条码数量 
    ///</summary>
    [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")]
    public decimal? OldBarQuantity { get; set; }

    /// <summary>
    /// 汇总条码 
    ///</summary>
    [SugarColumn(ColumnName = "SUM_BARCODE")]
    public string SumBarcode { get; set; }

    /// <summary>
    /// 生产日期 
    ///</summary>
    [SugarColumn(ColumnName = "LOT_DATE")]
    public string LotDate { get; set; }

    /// <summary>
    /// 模号 
    ///</summary>
    [SugarColumn(ColumnName = "MOCODE")]
    public string Mocode { get; set; }

    /// <summary>
    /// 来源 
    ///</summary>
    [SugarColumn(ColumnName = "MEMO")]
    public string Memo { get; set; }

    /// <summary>
    /// 供应商编码 
    ///</summary>
    [SugarColumn(ColumnName = "SUPP_NO")]
    public string SuppNo { get; set; }

    /// <summary>
    /// 档位低值 
    ///</summary>
    [SugarColumn(ColumnName = "SPOSTION")]
    public string Spostion { get; set; }

    /// <summary>
    /// 档位高值 
    ///</summary>
    [SugarColumn(ColumnName = "EPOSTION")]
    public string Epostion { get; set; }

    /// <summary>
    /// 物料简称 
    ///</summary>
    [SugarColumn(ColumnName = "ITEM_SNAME")]
    public string ItemSname { get; set; }

    /// <summary>
    /// 是否已冻结,1冻结 
    ///</summary>
    [SugarColumn(ColumnName = "VISABLE")]
    public short? Visable { get; set; }

    /// <summary>
    /// 供应商批次 
    ///</summary>
    [SugarColumn(ColumnName = "TR_LOTNO")]
    public string TrLotno { get; set; }

    /// <summary>
    /// 冻结时间 
    ///</summary>
    [SugarColumn(ColumnName = "FLEZZ_DATE")]
    public DateTime? FlezzDate { get; set; }

    /// <summary>
    /// 冻结原因 
    ///</summary>
    [SugarColumn(ColumnName = "FLEZZ_REASON")]
    public string FlezzReason { get; set; }

    /// <summary>
    /// 冻结人 
    ///</summary>
    [SugarColumn(ColumnName = "FLEZZ_BY")]
    public string FlezzBy { get; set; }

    /// <summary>
    /// 延长保质期 
    ///</summary>
    [SugarColumn(ColumnName = "DELANY_MONTH")]
    public decimal? DelanyMonth { get; set; }

    /// <summary>
    /// 最小包装标识 
    ///</summary>
    [SugarColumn(ColumnName = "MINPACK_FLAG")]
    public short? MinpackFlag { get; set; }

    /// <summary>
    /// 打印ID，用来区分打印次数 
    ///</summary>
    [SugarColumn(ColumnName = "PRINT_ID")]
    public string PrintId { get; set; }

    /// <summary>
    /// 环保项目 
    ///</summary>
    [SugarColumn(ColumnName = "EP_ITEM")]
    public string EpItem { get; set; }

    /// <summary>
    /// 工厂编号 
    ///</summary>
    [SugarColumn(ColumnName = "FACTORY")]
    public string Factory { get; set; }

    /// <summary>
    /// 公司编号 
    ///</summary>
    [SugarColumn(ColumnName = "COMPANY")]
    public string Company { get; set; }

    /// <summary>
    /// 卡板编码 
    ///</summary>
    [SugarColumn(ColumnName = "CB_NO")]
    public string CbNo { get; set; }

    /// <summary>
    /// 厂家生产线 
    ///</summary>
    [SugarColumn(ColumnName = "LINFLINE")]
    public string Linfline { get; set; }

    /// <summary>
    /// 有效期 
    ///</summary>
    [SugarColumn(ColumnName = "VALID_TIME")]
    public DateTime? ValidTime { get; set; }

    /// <summary>
    /// 质检结果 
    ///</summary>
    [SugarColumn(ColumnName = "IQC_STATUS")]
    public string IqcStatus { get; set; }

    /// <summary>
    /// 小车条码 
    ///</summary>
    [SugarColumn(ColumnName = "FCAR")]
    public string Fcar { get; set; }

    /// <summary>
    /// 毛重 
    ///</summary>
    [SugarColumn(ColumnName = "GWEIGHT")]
    public string Gweight { get; set; }

    /// <summary>
    /// 净重 
    ///</summary>
    [SugarColumn(ColumnName = "NWEIGHT")]
    public string Nweight { get; set; }

    /// <summary>
    /// 保质期 
    ///</summary>
    [SugarColumn(ColumnName = "EXT_DATE")]
    public decimal? ExtDate { get; set; }

    /// <summary>
    /// 供应商、赠品、客供料、委外 
    ///</summary>
    [SugarColumn(ColumnName = "BARCODETYPE")]
    public string Barcodetype { get; set; }

    /// <summary>
    /// 供应商名称 
    ///</summary>
    [SugarColumn(ColumnName = "SUPP_NAME")]
    public string SuppName { get; set; }

    /// <summary>
    /// 到货单号/入库单号 
    ///</summary>
    [SugarColumn(ColumnName = "BILL_NO")]
    public string BillNo { get; set; }

    /// <summary>
    /// 急料标识 
    ///</summary>
    [SugarColumn(ColumnName = "URGENT_FLAG")]
    public short? UrgentFlag { get; set; }

    /// <summary>
    /// 颜色 
    ///</summary>
    [SugarColumn(ColumnName = "COLOR_NAME")]
    public string ColorName { get; set; }

    /// <summary>
    /// 产品型号 
    ///</summary>
    [SugarColumn(ColumnName = "BOARD_STYLE")]
    public string BoardStyle { get; set; }

    /// <summary>
    /// 来料日期 
    ///</summary>
    [SugarColumn(ColumnName = "INS_DATE")]
    public DateTime? InsDate { get; set; }

    /// <summary>
    /// 到货单行号 
    ///</summary>
    [SugarColumn(ColumnName = "WORK_LINE")]
    public decimal? WorkLine { get; set; }

    /// <summary>
    /// 不良原因 
    ///</summary>
    [SugarColumn(ColumnName = "MEMO_BAD")]
    public string MemoBad { get; set; }

    /// <summary>
    /// 任务单号 
    ///</summary>
    [SugarColumn(ColumnName = "WORK_NO")]
    public string WorkNo { get; set; }

    /// <summary>
    /// 条码来源标识，0-初期物料,1-采购入库，2、生产退料，3、其它入库，4-客供料,5-在库分料，6-制程条码 
    ///</summary>
    [SugarColumn(ColumnName = "COME_FLG")]
    public short? ComeFlg { get; set; }

    /// <summary>
    /// 生产线体 
    ///</summary>
    [SugarColumn(ColumnName = "LINE_NO")]
    public string LineNo { get; set; }

    /// <summary>
    /// 丝印次数 
    ///</summary>
    [SugarColumn(ColumnName = "SILK_PQTY")]
    public decimal? SilkPqty { get; set; }

    /// <summary>
    /// 丝印次数比 
    ///</summary>
    [SugarColumn(ColumnName = "SILK")]
    public string Silk { get; set; }

    /// <summary>
    /// 丝印派工从表ID 
    ///</summary>
    [SugarColumn(ColumnName = "SILK_ID")]
    public decimal? SilkId { get; set; }

    /// <summary>
    /// 已报工标识 
    ///</summary>
    [SugarColumn(ColumnName = "WORK_FLG")]
    public decimal? WorkFlg { get; set; }

    /// <summary>
    /// 最后工序 
    ///</summary>
    [SugarColumn(ColumnName = "WORK_LAST")]
    public decimal? WorkLast { get; set; }

    /// <summary>
    /// 0-未合并打印，1-合并打印 
    ///</summary>
    [SugarColumn(ColumnName = "HBDY")]
    public decimal? Hbdy { get; set; }

    /// <summary>
    /// 0-有效条码，1-合并拆分的条码，无效 
    ///</summary>
    [SugarColumn(ColumnName = "HBDYTM")]
    public decimal? Hbdytm { get; set; }

    /// <summary>
    /// 报工时间 
    ///</summary>
    [SugarColumn(ColumnName = "WORK_FLGTIME")]
    public string WorkFlgtime { get; set; }

    /// <summary>
    /// 采购订单ID 
    ///</summary>
    [SugarColumn(ColumnName = "EBELN_K3ID")]
    public decimal? EbelnK3id { get; set; }

    /// <summary>
    /// 采购订单行ID 
    ///</summary>
    [SugarColumn(ColumnName = "LINE_K3ID")]
    public decimal? LineK3id { get; set; }

    /// <summary>
    ///  
    ///</summary>
    [SugarColumn(ColumnName = "ITEM_ID")]
    public decimal? ItemId { get; set; }

    /// <summary>
    /// 生产工序ID 
    ///</summary>
    [SugarColumn(ColumnName = "GX_ID")]
    public decimal? GxId { get; set; }

    /// <summary>
    /// 组织id 
    ///</summary>
    [SugarColumn(ColumnName = "ORG_NAME")]
    public string OrgName { get; set; }

    /// <summary>
    /// 货主id 
    ///</summary>
    [SugarColumn(ColumnName = "ORG_OWNER")]
    public string OrgOwner { get; set; }
}