using SqlSugar;

namespace MES.Service.Modes;

/// <summary>
///     任务单表
/// </summary>
[SugarTable("WOMCAA")]
public class Womcaa
{
    /// <summary>
    ///     自增列
    /// </summary>
    [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_CAA", IsPrimaryKey = true)]
    public decimal Id { get; set; }

    /// <summary>
    ///     生产订单行内码
    /// </summary>
    [SugarColumn(ColumnName = "ERPID")]
    public decimal? Erpid { get; set; }

    /// <summary>
    ///     单据编号
    /// </summary>
    [SugarColumn(ColumnName = "CAA001")]
    public string? Caa001 { get; set; }

    /// <summary>
    ///     单据类型
    /// </summary>
    [SugarColumn(ColumnName = "CAA004")]
    public string? Caa004 { get; set; }

    /// <summary>
    ///     计划下达日期
    /// </summary>
    [SugarColumn(ColumnName = "CAA005")]
    public string? Caa005 { get; set; }

    /// <summary>
    ///     产品编码
    /// </summary>
    [SugarColumn(ColumnName = "CAA006")]
    public string? Caa006 { get; set; }

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

    /// <summary>
    ///     预计开工时间
    /// </summary>
    [SugarColumn(ColumnName = "CAA010")]
    public string? Caa010 { get; set; }

    /// <summary>
    ///     预计完工时间
    /// </summary>
    [SugarColumn(ColumnName = "CAA011")]
    public string? Caa011 { get; set; }

    /// <summary>
    ///     工单数量
    /// </summary>
    [SugarColumn(ColumnName = "CAA012")]
    public decimal? Caa012 { get; set; }

    /// <summary>
    ///     BOM版次
    /// </summary>
    [SugarColumn(ColumnName = "CAA013")]
    public string? Caa013 { get; set; }

    /// <summary>
    ///     销售订单号
    /// </summary>
    [SugarColumn(ColumnName = "CAA015")]
    public string? Caa015 { get; set; }

    /// <summary>
    ///     备注
    /// </summary>
    [SugarColumn(ColumnName = "CAA016")]
    public string? Caa016 { get; set; }

    /// <summary>
    ///     已排数量
    /// </summary>
    [SugarColumn(ColumnName = "CAA017")]
    public decimal? Caa017 { get; set; }

    /// <summary>
    ///     ERP生产订单ID
    /// </summary>
    [SugarColumn(ColumnName = "CAA018")]
    public decimal? Caa018 { get; set; }

    /// <summary>
    ///     ERP生产订单序号
    /// </summary>
    [SugarColumn(ColumnName = "CAA019")]
    public decimal? Caa019 { get; set; }

    /// <summary>
    ///     ERP生产订单单号
    /// </summary>
    [SugarColumn(ColumnName = "CAA020")]
    public string? Caa020 { get; set; }

    /// <summary>
    ///     生产车间
    /// </summary>
    [SugarColumn(ColumnName = "CAA021")]
    public string? Caa021 { get; set; }

    /// <summary>
    ///     审核码
    /// </summary>
    [SugarColumn(ColumnName = "FSTATUS")]
    public decimal? Fstatus { get; set; }

    /// <summary>
    ///     审核日期
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_DATE")]
    public DateTime? CheckDate { get; set; }

    /// <summary>
    ///     审核人
    /// </summary>
    [SugarColumn(ColumnName = "CHECK_USER")]
    public string? CheckUser { get; set; }

    /// <summary>
    ///     未排数量
    /// </summary>
    [SugarColumn(ColumnName = "CAA022")]
    public decimal? Caa022 { get; set; }

    /// <summary>
    ///     业务状态
    /// </summary>
    [SugarColumn(ColumnName = "CAA023")]
    public string? Caa023 { get; set; }

    /// <summary>
    ///     已入库数量
    /// </summary>
    [SugarColumn(ColumnName = "CAA024")]
    public decimal? Caa024 { get; set; }

    /// <summary>
    ///     工艺路线
    /// </summary>
    [SugarColumn(ColumnName = "ROUTING_ID")]
    public string? RoutingId { get; set; }

    /// <summary>
    ///     产线
    /// </summary>
    [SugarColumn(ColumnName = "WORK_SHOP_ID")]
    public string? WorkShopId { get; set; }

    /// <summary>
    ///     仓库
    /// </summary>
    [SugarColumn(ColumnName = "DEPOT_CODE")]
    public string? DepotCode { get; set; }

    /// <summary>
    ///     单据日期
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_DATE")]
    public string? CreateDate { get; set; }

    /// <summary>
    ///     计划组
    /// </summary>
    [SugarColumn(ColumnName = "WORK_GROUP_ID")]
    public string? WorkGroupId { get; set; }

    /// <summary>
    ///     计划员
    /// </summary>
    [SugarColumn(ColumnName = "PLAN_ID")]
    public string? PlanId { get; set; }

    /// <summary>
    ///     入库上限
    /// </summary>
    [SugarColumn(ColumnName = "STOCK_INLIMITH")]
    public string? StockInlimith { get; set; }

    /// <summary>
    ///     入库下限
    /// </summary>
    [SugarColumn(ColumnName = "STOCK_INLIMITL")]
    public string? StockInlimitl { get; set; }

    /// <summary>
    ///     计划跟踪号
    /// </summary>
    [SugarColumn(ColumnName = "MTONO")]
    public string? Mtono { get; set; }

    /// <summary>
    ///     批号
    /// </summary>
    [SugarColumn(ColumnName = "LOT")]
    public string? Lot { get; set; }

    /// <summary>
    ///     销售订单行号
    /// </summary>
    [SugarColumn(ColumnName = "CAA015_HEAD")]
    public string? Caa015Head { get; set; }

    /// <summary>
    ///     生成方式
    /// </summary>
    [SugarColumn(ColumnName = "CREATE_TYPE")]
    public string? CreateType { get; set; }

    /// <summary>
    ///     源单类型
    /// </summary>
    [SugarColumn(ColumnName = "SRC_BILL_TYPE")]
    public string? SrcBillType { get; set; }

    /// <summary>
    ///     源单编码
    /// </summary>
    [SugarColumn(ColumnName = "SRC_BILL_NO")]
    public string? SrcBillNo { get; set; }

    /// <summary>
    ///     源单分录行号
    /// </summary>
    [SugarColumn(ColumnName = "SRC_BILLENTRYSEQ")]
    public string? SrcBillentryseq { get; set; }

    /// <summary>
    ///     需求单据号
    /// </summary>
    [SugarColumn(ColumnName = "SALE_ORDER_NO")]
    public string? SaleOrderNo { get; set; }

    /// <summary>
    ///     需求单据行号
    /// </summary>
    [SugarColumn(ColumnName = "SALE_ORDER_ENTRYSEQ")]
    public string? SaleOrderEntryseq { get; set; }

    /// <summary>
    ///     结案人
    /// </summary>
    [SugarColumn(ColumnName = "FORCE_CLOSERID")]
    public string? ForceCloserid { get; set; }

    /// <summary>
    ///     结案类型
    /// </summary>
    [SugarColumn(ColumnName = "CLOSE_TYPE")]
    public string? CloseType { get; set; }

    /// <summary>
    ///     源拆分订单编号
    /// </summary>
    [SugarColumn(ColumnName = "SRC_SPLIT_BILLNO")]
    public string? SrcSplitBillno { get; set; }

    /// <summary>
    ///     生产组织
    /// </summary>
    [SugarColumn(ColumnName = "PRD_ORG")]
    public string? PrdOrg { get; set; }

    /// <summary>
    ///     委托组织
    /// </summary>
    [SugarColumn(ColumnName = "TRUST_ORG")]
    public string? TrustOrg { get; set; }

    /// <summary>
    ///     同步时间
    /// </summary>
    [SugarColumn(ColumnName = "TB_TIME")]
    public DateTime? TbTime { get; set; }

    /// <summary>
    ///     结案时间
    /// </summary>
    [SugarColumn(ColumnName = "JA_TIME")]
    public DateTime? JaTime { get; set; }

    /// <summary>
    ///     结案标识
    /// </summary>
    [SugarColumn(ColumnName = "JA_BS")]
    public decimal? JaBs { get; set; }

    /// <summary>
    ///     旧物料编码
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")]
    public string? FwwcBaseproperty { get; set; }

    /// <summary>
    ///     计划完工携带日期
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_DATETIME")]
    public DateTime? FwwcDatetime { get; set; }

    /// <summary>
    ///     生产入库日期
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_SCRKRQ")]
    public DateTime? FwwcScrkrq { get; set; }

    /// <summary>
    ///     工时
    /// </summary>
    [SugarColumn(ColumnName = "FGS")]
    public decimal? Fgs { get; set; }

    /// <summary>
    ///     产线人数
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_DECIMAL")]
    public decimal? FwwcDecimal { get; set; }

    /// <summary>
    ///     线别
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_XB")]
    public string? FwwcXb { get; set; }

    /// <summary>
    ///     销售员
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_BASE")]
    public string? FwwcBase { get; set; }

    /// <summary>
    ///     修改标识
    /// </summary>
    [SugarColumn(ColumnName = "IS_XG")]
    public decimal? IsXg { get; set; }

    /// <summary>
    ///     委外采购订单
    /// </summary>
    [SugarColumn(ColumnName = "FPURORDERNO")]
    public string? Fpurorderno { get; set; }

    /// <summary>
    ///     委外采购订单行号
    /// </summary>
    [SugarColumn(ColumnName = "FPURORDERENTRYSEQ")]
    public decimal? Fpurorderentryseq { get; set; }

    /// <summary>
    ///     委外订单分录内码
    /// </summary>
    [SugarColumn(ColumnName = "FSUBENTRYID")]
    public decimal? Fsubentryid { get; set; }

    /// <summary>
    ///     委外入库数
    /// </summary>
    [SugarColumn(ColumnName = "FSTOCKINQTY")]
    public decimal? Fstockinqty { get; set; }

    /// <summary>
    ///     委外未入库数
    /// </summary>
    [SugarColumn(ColumnName = "FNOSTOCKINQTY")]
    public decimal? Fnostockinqty { get; set; }

    /// <summary>
    ///     客户
    /// </summary>
    [SugarColumn(ColumnName = "F_ZSXG_KH")]
    public string? FZsxgKh { get; set; }

    /// <summary>
    ///     要货日期
    /// </summary>
    [SugarColumn(ColumnName = "F_ZJXF_YHRQ")]
    public string? FZjxfYhrq { get; set; }

    /// <summary>
    ///     BOM类型
    /// </summary>
    [SugarColumn(ColumnName = "BOMTYPE")]
    public string? Bomtype { get; set; }

    /// <summary>
    ///     BOM母项
    /// </summary>
    [SugarColumn(ColumnName = "BOMMASTER")]
    public decimal? Bommaster { get; set; }

    /// <summary>
    ///     BOM生产目的
    /// </summary>
    [SugarColumn(ColumnName = "BOMALTRNATE")]
    public string? Bomaltrnate { get; set; }

    /// <summary>
    ///     BOM有效日期
    /// </summary>
    [SugarColumn(ColumnName = "BOMEFFEDATE")]
    public string? Bomeffedate { get; set; }

    /// <summary>
    ///     工艺生产目的
    /// </summary>
    [SugarColumn(ColumnName = "ROUTINGALTERNATE")]
    public string? Routingalternate { get; set; }

    /// <summary>
    ///     工艺有效日期
    /// </summary>
    [SugarColumn(ColumnName = "ROUTINGEFFEDATE")]
    public string? Routingeffedate { get; set; }

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

    /// <summary>
    ///     业务开始时间
    /// </summary>
    [SugarColumn(ColumnName = "ACTUALSTARTDATE")]
    public DateTime? Actualstartdate { get; set; }

    /// <summary>
    ///     业务结束时间
    /// </summary>
    [SugarColumn(ColumnName = "ACTUALCOMPLETEDATE")]
    public DateTime? Actualcompletedate { get; set; }

    /// <summary>
    ///     来源类型
    /// </summary>
    [SugarColumn(ColumnName = "MOSOURCEDOCTYPE")] 
    public string? Mosourcedoctype { get; set; }

    /// <summary>
    ///     项目
    /// </summary>
    [SugarColumn(ColumnName = "PROJECT")]
    public decimal? Project { get; set; }

    /// <summary>
    ///     货主组织
    /// </summary>
    [SugarColumn(ColumnName = "OWNERORG")]
    public decimal? Ownerorg { get; set; }

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

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

    /// <summary>
    ///     开工数量
    /// </summary>
    [SugarColumn(ColumnName = "TOTALSTARTQTY")]
    public decimal? Totalstartqty { get; set; }

    /// <summary>
    ///     完工数量
    /// </summary>
    [SugarColumn(ColumnName = "TOTALCOMPLETEQTY")]
    public decimal? Totalcompleteqty { get; set; }

    /// <summary>
    ///     入库数量
    /// </summary>
    [SugarColumn(ColumnName = "TOTALRCVQTY")]
    public decimal? Totalrcvqty { get; set; }

    /// <summary>
    ///     返工数量
    /// </summary>
    [SugarColumn(ColumnName = "TOTALREWORKINGQTY")]
    public decimal? Totalreworkingqty { get; set; }

    /// <summary>
    ///     返工原因
    /// </summary>
    [SugarColumn(ColumnName = "REASONFORREWORK")]
    public string? Reasonforrework { get; set; }

    /// <summary>
    ///     强制齐套
    /// </summary>
    [SugarColumn(ColumnName = "ISFORCEWHOLESET")]
    public decimal? Isforcewholeset { get; set; }

    /// <summary>
    ///    分割前原订单编号
    /// </summary>
    [SugarColumn(ColumnName = "PREVMO")]
    public string? PREVMO { get; set; }

    /// <summary>
    ///     1，新增；2，变更
    /// </summary>
    [SugarColumn(ColumnName = "TYPEA")]
    public string? Typea { get; set; }
}