using SqlSugar;
|
|
namespace PadApplication.Entites.DbModels;
|
|
/// <summary>
|
/// 工单表
|
/// </summary>
|
[SugarTable("WOMCAA")]
|
public class Womcaa
|
{
|
/// <summary>
|
/// 自增列
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERPID")]
|
public decimal? Erpid { get; set; }
|
|
/// <summary>
|
/// 单号
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA001")]
|
public string? Caa001 { get; set; }
|
|
/// <summary>
|
/// ERP工单批次
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA002")]
|
public string? Caa002 { get; set; }
|
|
/// <summary>
|
/// 客户编号
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA003")]
|
public string? Caa003 { 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 = "CAA007")]
|
public string? Caa007 { get; set; }
|
|
/// <summary>
|
/// 产品规格
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA008")]
|
public string? Caa008 { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA009")]
|
public string? Caa009 { get; set; }
|
|
/// <summary>
|
/// 预计开工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA010")]
|
public DateTime? Caa010 { get; set; }
|
|
/// <summary>
|
/// 预计完工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA011")]
|
public DateTime? 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 = "CAA014")]
|
public string? Caa014 { 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>
|
/// T100母工单
|
/// </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 = "CAA025")]
|
public string? Caa025 { get; set; }
|
|
/// <summary>
|
/// 资料创建日
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA026")]
|
public string? Caa026 { get; set; }
|
|
/// <summary>
|
/// 资料录入者
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA027")]
|
public string? Caa027 { get; set; }
|
|
/// <summary>
|
/// 最近更改日
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA028")]
|
public string? Caa028 { get; set; }
|
|
/// <summary>
|
/// 资料更改者
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA029")]
|
public string? Caa029 { get; set; }
|
|
/// <summary>
|
/// 状态码（C:结案F:已发出X:作废）
|
/// </summary>
|
[SugarColumn(ColumnName = "STATE")]
|
public string? State { get; set; }
|
|
/// <summary>
|
/// 部门供应商
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPP_NO")]
|
public string? SuppNo { get; set; }
|
|
/// <summary>
|
/// 转工序人
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA031")]
|
public string? Caa031 { get; set; }
|
|
/// <summary>
|
/// 转工序时间
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA032")]
|
public DateTime? Caa032 { get; set; }
|
|
/// <summary>
|
/// 拆单数
|
/// </summary>
|
[SugarColumn(ColumnName = "SPLIT")]
|
public decimal? Split { get; set; }
|
|
/// <summary>
|
/// 机台编号
|
/// </summary>
|
[SugarColumn(ColumnName = "MACHINE_NO")]
|
public string? MachineNo { get; set; }
|
|
/// <summary>
|
/// 是否排产
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_PC")]
|
public decimal? IsPc { get; set; }
|
|
/// <summary>
|
/// 据点
|
/// </summary>
|
[SugarColumn(ColumnName = "ADDRESS_CODE")]
|
public string? AddressCode { get; set; }
|
|
/// <summary>
|
/// 最后排产人
|
/// </summary>
|
[SugarColumn(ColumnName = "PC_USER")]
|
public string? PcUser { get; set; }
|
|
/// <summary>
|
/// 最后排产时间
|
/// </summary>
|
[SugarColumn(ColumnName = "PC_DATE")]
|
public DateTime? PcDate { get; set; }
|
|
/// <summary>
|
/// 是否转工序工单
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_GX")]
|
public decimal? IsGx { get; set; }
|
|
/// <summary>
|
/// 工艺编号
|
/// </summary>
|
[SugarColumn(ColumnName = "CAA030")]
|
public string? Caa030 { get; set; }
|
|
/// <summary>
|
/// 是否是工艺工单
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_GY")]
|
public decimal? IsGy { get; set; }
|
|
/// <summary>
|
/// 工序编号
|
/// </summary>
|
[SugarColumn(ColumnName = "PROC_NO")]
|
public string? ProcNo { get; set; }
|
|
/// <summary>
|
/// 工序序号
|
/// </summary>
|
[SugarColumn(ColumnName = "PROC_NUM")]
|
public string? ProcNum { get; set; }
|
|
/// <summary>
|
/// 部门
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPARTMENT_NO")]
|
public string? DepartmentNo { get; set; }
|
|
/// <summary>
|
/// 来源单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SOURCE_NO")]
|
public string? SourceNo { get; set; }
|
|
/// <summary>
|
/// 来源单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "SLINE_NO")]
|
public decimal? SlineNo { get; set; }
|
|
/// <summary>
|
/// 是否快排
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_KP")]
|
public decimal? IsKp { 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 = "CAA004")]
|
public decimal? Caa004 { get; set; }
|
|
/// <summary>
|
/// 批号
|
/// </summary>
|
[SugarColumn(ColumnName = "LOT_NO")]
|
public string? LotNo { get; set; }
|
|
/// <summary>
|
/// 工单是否变更
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_CHANGE")]
|
public decimal? IsChange { get; set; }
|
|
/// <summary>
|
/// 是否抽样
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_SAMPLE")]
|
public decimal? IsSample { get; set; }
|
|
/// <summary>
|
/// 抽样个数
|
/// </summary>
|
[SugarColumn(ColumnName = "SAMPLE_NUM")]
|
public decimal? SampleNum { get; set; }
|
|
/// <summary>
|
/// 餐椅工资型号
|
/// </summary>
|
[SugarColumn(ColumnName = "CY_MODEL")]
|
public string? CyModel { get; set; }
|
}
|
