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