using System;
using System.Collections.Generic;
using System.Linq;
using SqlSugar;
namespace MES.Service.Modes
{
    /// <summary>
    /// 调拨申请单
    ///</summary>
    [SugarTable("MES_INV_ITEM_DBSQ")]
    public class MesInvItemDbsq
    {
        /// <summary>
        /// SEQ_INV_ID 
        ///</summary> 
        [SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_DBSQ")]
        //[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
        public decimal Id { get; set; }
        /// <summary>
        /// 调拨申请单号 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_NO")]
        public string? BillNo { get; set; }
        /// <summary>
        /// 移入子库id 
        ///</summary>
        [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
        public decimal? InvDepotsId { get; set; }
        /// <summary>
        /// 移入货位id 
        ///</summary>
        [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
        public decimal? InvDepotSectionsId { 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>
        /// 状态|0-制单1-审核2-过账 
        ///</summary>
        [SugarColumn(ColumnName = "STATUS")]
        public decimal? Status { get; set; }
        /// <summary>
        /// 备注 
        ///</summary>
        [SugarColumn(ColumnName = "REMARK")]
        public string? Remark { get; set; }
        /// <summary>
        /// 单据类型ID 
        ///</summary>
        [SugarColumn(ColumnName = "BILL_TYPE_ID")]
        public decimal? BillTypeId { get; set; }
        /// <summary>
        /// 事务类型ID 
        ///</summary>
        [SugarColumn(ColumnName = "TRANSACTION_ID")]
        public decimal? TransactionId { get; set; }
        /// <summary>
        /// 审核人 
        ///</summary>
        [SugarColumn(ColumnName = "CHECKUSER")]
        public string? Checkuser { get; set; }
        /// <summary>
        /// 审核日期 
        ///</summary>
        [SugarColumn(ColumnName = "CHECKDATE")]
        public DateTime? Checkdate { get; set; }
        /// <summary>
        /// 移入子库code 
        ///</summary>
        [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
        public string? InvDepotsCode { get; set; }
        /// <summary>
        /// 移入货位code 
        ///</summary>
        [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
        public string? InvDepotSectionsCode { get; set; }
        /// <summary>
        /// 事务类型编码 
        ///</summary>
        [SugarColumn(ColumnName = "TRANSACTION_NO")]
        public decimal? TransactionNo { get; set; }
        /// <summary>
        /// 移出子库code 
        ///</summary>
        [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
        public string? FromDepotsCode { get; set; }
        /// <summary>
        /// 工厂编码 
        ///</summary>
        [SugarColumn(ColumnName = "FACTORY_CODE")]
        public string? FactoryCode { get; set; }
        /// <summary>
        /// SAP返回单据 
        ///</summary>
        [SugarColumn(ColumnName = "SAPNO")]
        public string? Sapno { get; set; }
        /// <summary>
        /// 已回写SAP 
        ///</summary>
        [SugarColumn(ColumnName = "SAPSTATUS")]
        public short? Sapstatus { get; set; }
        /// <summary>
        /// SAP返回年份 
        ///</summary>
        [SugarColumn(ColumnName = "SAPYEAR")]
        public short? Sapyear { get; set; }
        /// <summary>
        /// SAP返回信息 
        ///</summary>
        [SugarColumn(ColumnName = "SAPTEXT")]
        public string? Saptext { get; set; }
        /// <summary>
        /// 分厂编码 
        ///</summary>
        [SugarColumn(ColumnName = "FACTORY")]
        public string? Factory { get; set; }
        /// <summary>
        /// 公司代码 
        ///</summary>
        [SugarColumn(ColumnName = "COMPANY")]
        public string? Company { get; set; }
        /// <summary>
        /// 是否推送ERP1-是，2-否 
        ///</summary>
        [SugarColumn(ColumnName = "TS")]
        public decimal? Ts { get; set; }
        /// <summary>
        /// 0未调拨1已调拨 
        ///</summary>
        [SugarColumn(ColumnName = "DB_STATUS")]
        public string? DbStatus { get; set; }
        /// <summary>
        /// 调出组织 
        ///</summary>
        [SugarColumn(ColumnName = "FSTOCKOUTORGID")]
        public decimal? Fstockoutorgid { get; set; }
        /// <summary>
        /// 调入组织 
        ///</summary>
        [SugarColumn(ColumnName = "FSTOCKORGID")]
        public decimal? Fstockorgid { get; set; }
        /// <summary>
        /// 单据类型 
        ///</summary>
        [SugarColumn(ColumnName = "DJ_LX")]
        public string? Djlx { get; set; }
        /// <summary>
        /// 调拨类型 
        ///</summary>
        [SugarColumn(ColumnName = "DB_LX1")]
        public string? DbLx1 { get; set; }
        /// <summary>
        /// 调拨方向 
        ///</summary>
        [SugarColumn(ColumnName = "DB_FX")]
        public string? DbFx { get; set; }
        /// <summary>
        /// 调拨类型 
        ///</summary>
        [SugarColumn(ColumnName = "DB_LX")]
        public string? DbLx { get; set; }
        /// <summary>
        /// 业务类型 
        ///</summary>
        [SugarColumn(ColumnName = "YW_LX")]
        public string? YwLx { get; set; }
        /// <summary>
        /// 单据状态 
        ///</summary>
        [SugarColumn(ColumnName = "DJ_ZT")]
        public string? DjZt { get; set; }
        /// <summary>
        /// 申请部门 
        ///</summary>
        [SugarColumn(ColumnName = "SQ_BM")]
        public string? SqBm { get; set; }
        /// <summary>
        /// 申请组织 
        ///</summary>
        [SugarColumn(ColumnName = "SQ_ZZ")]
        public string? SqZz { get; set; }
        /// <summary>
        /// 申请日期 
        ///</summary>
        [SugarColumn(ColumnName = "SQ_TIME")]
        public string? SqTime { get; set; }
        /// <summary>
        /// 调出货主类型 
        ///</summary>
        [SugarColumn(ColumnName = "DC_HZ")]
        public string? DcHz { get; set; }
        /// <summary>
        ///  
        ///</summary>
        [SugarColumn(ColumnName = "ERPID")]
        public string? Erpid { get; set; }
    }
}