using SqlSugar;
|
namespace MES.Service.Modes
|
{
|
/// <summary>
|
/// 任务单表
|
///</summary>
|
[SugarTable("WOMCAA")]
|
public class Womcaa
|
{
|
/// <summary>
|
/// 自增列
|
///</summary>
|
[SugarColumn(ColumnName="ID", IsPrimaryKey = true,
|
OracleSequenceName = "SEQ_AOI")]
|
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>
|
/// 单据类型
|
///</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>
|
/// "工单状态 1、计划 2、计划确认 3、下达 4、开工 5、完工 6、结案 7、结算"
|
///</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="FMOENTRYID" )]
|
public decimal? Fmoentryid { get; set; }
|
/// <summary>
|
/// 排产线别
|
///</summary>
|
[SugarColumn(ColumnName="PROD_LINE" )]
|
public string? ProdLine { get; set; }
|
}
|
}
|