using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 工单表
|
/// </summary>
|
[SugarTable("WOMCAA")]
|
public class Womcaa
|
{
|
/// <summary>
|
/// 默认值: (newid())
|
/// </summary>
|
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERPID")]
|
public int? Erpid { get; set; }
|
|
/// <summary>
|
/// 单据编号
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA001")]
|
public string? Caa001 { get; set; }
|
|
/// <summary>
|
/// 单据类型("1、直接入库-普通生产 2、直接入库-返工生产 3、工序汇报-普通生产 4、工序汇报-返工生产")
|
/// </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 int? 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 int? Caa017 { get; set; }
|
|
/// <summary>
|
/// ERP生产订单ID
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA018")]
|
public int? Caa018 { get; set; }
|
|
/// <summary>
|
/// ERP生产订单序号
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA019")]
|
public int? 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 int? 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 int? Caa022 { get; set; }
|
|
/// <summary>
|
/// 业务状态("1，计划，2、计划确认 2、下达 4、开工 5、完工 6、结案，7、结算")
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA023")]
|
public string? Caa023 { get; set; }
|
|
/// <summary>
|
/// 已入库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA024")]
|
public int? 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 = "ERP_SCZZ")]
|
public int? ErpSczz { get; set; }
|
|
/// <summary>
|
/// 是否委托
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_WTZZ")]
|
public int? ErpWtzz { get; set; }
|
|
// /// <summary>
|
// /// </summary>
|
// [SugarColumn(ColumnName = "MAIN_PRODUCT_NO")]
|
// public string? MainProductNo { get; set; }
|
|
// /// <summary>
|
// /// </summary>
|
// [SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
|
// public int? MainProductQty { get; set; }
|
|
// /// <summary>
|
// /// </summary>
|
// [SugarColumn(ColumnName = "CUSTOMER_ITEM_NUMBER")]
|
// public string? CustomerItemNumber { get; set; }
|
|
// /// <summary>
|
// /// </summary>
|
// [SugarColumn(ColumnName = "PACKING_LIST_NUMBER")]
|
// public string? PackingListNumber { get; set; }
|
|
// /// <summary>
|
// /// </summary>
|
// [SugarColumn(ColumnName = "CUSTOMER_NAME")]
|
// public string? CustomerName { get; set; }
|
|
// /// <summary>
|
// /// </summary>
|
// [SugarColumn(ColumnName = "CUSTOMER")]
|
// public string? Customer { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "TYPE")]
|
public string? Type { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "JA_BS")]
|
public string? JaBs { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "JA_TIME")]
|
public DateTime? JaTime { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "YP_NUM")]
|
public int? YpNum { get; set; }
|
|
/// <summary>
|
/// 预计完工时间备份
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA011_1")]
|
public string? Caa0111 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_GYZZ")]
|
public int? ErpGyzz { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_FLZZ")]
|
public int? ErpFlzz { get; set; }
|
|
/// <summary>
|
/// 是否入库
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_SLZZ")]
|
public int? ErpSlzz { get; set; }
|
|
/// <summary>
|
/// 是否退库
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_RKZZ")]
|
public int? ErpRkzz { get; set; }
|
|
/// <summary>
|
/// 是否换货
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_RKHZ")]
|
public int? ErpRkhz { get; set; }
|
|
/// <summary>
|
/// 是否寄售
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_JJDS")]
|
public int? ErpJjds { get; set; }
|
|
/// <summary>
|
/// 是否按款
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_BZDS")]
|
public int? ErpBzds { get; set; }
|
|
/// <summary>
|
/// 是否新建
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA025")]
|
public int? Caa025 { get; set; }
|
|
/// <summary>
|
/// 采购订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "FPURORDERNO")]
|
public string? Fpurorderno { get; set; }
|
|
/// <summary>
|
/// 采购订单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "FPURORDERENTRYSEQ")]
|
public string? Fpurorderentryseq { get; set; }
|
|
/// <summary>
|
/// 电气产品型号
|
/// </summary>
|
[SugarColumn(ColumnName = "ELECTRICAL_PRODUCT_MODEL")]
|
public string? ElectricalProductModel { get; set; }
|
|
/// <summary>
|
/// 电气产品名称
|
/// </summary>
|
[SugarColumn(ColumnName = "ELECTRICAL_PRODUCT_NAME")]
|
public string? ElectricalProductName { get; set; }
|
}
|
