using SqlSugar;
namespace NewPdaSqlServer.entity
{
///
/// 任务单表
///
[SugarTable("WOMCAA")]
public class Womcaa
{
///
///
/// 默认值: (newid())
///
[SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
public Guid Guid { get; set; }
///
/// ERPID
///
[SugarColumn(ColumnName="ERPID" )]
public int? Erpid { get; set; }
///
/// 单据编号
///
[SugarColumn(ColumnName="CAA001" )]
public string Caa001 { get; set; }
///
/// 单据类型("1、直接入库-普通生产 2、直接入库-返工生产 3、工序汇报-普通生产 4、工序汇报-返工生产")
///
[SugarColumn(ColumnName="CAA004" )]
public string Caa004 { get; set; }
///
/// 计划下达日期
///
[SugarColumn(ColumnName="CAA005" )]
public string Caa005 { get; set; }
///
/// 产品编码
///
[SugarColumn(ColumnName="CAA006" )]
public string Caa006 { get; set; }
///
/// 单位
///
[SugarColumn(ColumnName="CAA009" )]
public string Caa009 { get; set; }
///
/// 预计开工时间
///
[SugarColumn(ColumnName="CAA010" )]
public string Caa010 { get; set; }
///
/// 预计完工时间
///
[SugarColumn(ColumnName="CAA011" )]
public string Caa011 { get; set; }
///
/// 工单数量
///
[SugarColumn(ColumnName="CAA012" )]
public decimal? Caa012 { get; set; }
///
/// BOM版次
///
[SugarColumn(ColumnName="CAA013" )]
public string Caa013 { get; set; }
///
/// 销售订单号
///
[SugarColumn(ColumnName="CAA015" )]
public string Caa015 { get; set; }
///
/// 备注
///
[SugarColumn(ColumnName="CAA016" )]
public string Caa016 { get; set; }
///
/// 已排数量(弃用)
///
[SugarColumn(ColumnName="CAA017" )]
public int? Caa017 { get; set; }
///
/// ERP生产订单ID
///
[SugarColumn(ColumnName="CAA018" )]
public int? Caa018 { get; set; }
///
/// ERP生产订单序号
///
[SugarColumn(ColumnName="CAA019" )]
public int? Caa019 { get; set; }
///
/// ERP生产订单单号
///
[SugarColumn(ColumnName="CAA020" )]
public string Caa020 { get; set; }
///
/// 生产车间
///
[SugarColumn(ColumnName="CAA021" )]
public string Caa021 { get; set; }
///
/// 审核码
///
[SugarColumn(ColumnName="FSTATUS" )]
public int? Fstatus { get; set; }
///
/// 审核日期
///
[SugarColumn(ColumnName="CHECK_DATE" )]
public DateTime? CheckDate { get; set; }
///
/// 审核人
///
[SugarColumn(ColumnName="CHECK_USER" )]
public string CheckUser { get; set; }
///
/// 未排数量(弃用)
///
[SugarColumn(ColumnName="CAA022" )]
public int? Caa022 { get; set; }
///
/// 业务状态("1,计划,2、计划确认 2、下达 4、开工 5、完工 6、结案,7、结算")
///
[SugarColumn(ColumnName="CAA023" )]
public string Caa023 { get; set; }
///
/// 已入库数量
///
[SugarColumn(ColumnName="CAA024" )]
public int? Caa024 { get; set; }
///
/// 工艺路线
///
[SugarColumn(ColumnName="ROUTING_ID" )]
public string RoutingId { get; set; }
///
/// 产线
///
[SugarColumn(ColumnName="WORK_SHOP_ID" )]
public string WorkShopId { get; set; }
///
/// 仓库
///
[SugarColumn(ColumnName="DEPOT_CODE" )]
public string DepotCode { get; set; }
///
/// 单据日期
///
[SugarColumn(ColumnName="CREATE_DATE" )]
public string CreateDate { get; set; }
///
/// 计划组
///
[SugarColumn(ColumnName="WORK_GROUP_ID" )]
public string WorkGroupId { get; set; }
///
/// 计划员
///
[SugarColumn(ColumnName="PLAN_ID" )]
public string PlanId { get; set; }
///
/// 入库上限
///
[SugarColumn(ColumnName="STOCK_INLIMITH" )]
public string StockInlimith { get; set; }
///
/// 入库下限
///
[SugarColumn(ColumnName="STOCK_INLIMITL" )]
public string StockInlimitl { get; set; }
///
/// 主车间调度单
///
[SugarColumn(ColumnName="MTONO" )]
public string Mtono { get; set; }
///
/// 批次
///
[SugarColumn(ColumnName="LOT" )]
public string Lot { get; set; }
///
/// 引用单号
///
[SugarColumn(ColumnName="CAA015_HEAD" )]
public string Caa015Head { get; set; }
///
/// 制单类型
///
[SugarColumn(ColumnName="CREATE_TYPE" )]
public string CreateType { get; set; }
///
/// 来源单据类型
///
[SugarColumn(ColumnName="SRC_BILL_TYPE" )]
public string SrcBillType { get; set; }
///
/// 来源单号
///
[SugarColumn(ColumnName="SRC_BILL_NO" )]
public string SrcBillNo { get; set; }
///
/// 来源行号
///
[SugarColumn(ColumnName="SRC_BILLENTRYSEQ" )]
public string SrcBillentryseq { get; set; }
///
/// 销售订单号
///
[SugarColumn(ColumnName="SALE_ORDER_NO" )]
public string SaleOrderNo { get; set; }
///
/// 销售订单行号
///
[SugarColumn(ColumnName="SALE_ORDER_ENTRYSEQ" )]
public string SaleOrderEntryseq { get; set; }
///
/// 强制关闭人
///
[SugarColumn(ColumnName="FORCE_CLOSERID" )]
public string ForceCloserid { get; set; }
///
/// 关闭类型
///
[SugarColumn(ColumnName="CLOSE_TYPE" )]
public string CloseType { get; set; }
///
/// 分单号
///
[SugarColumn(ColumnName="SRC_SPLIT_BILLNO" )]
public string SrcSplitBillno { get; set; }
///
/// 是否管控
///
[SugarColumn(ColumnName="ERP_SCZZ" )]
public int? ErpSczz { get; set; }
///
/// 是否委托
///
[SugarColumn(ColumnName="ERP_WTZZ" )]
public int? ErpWtzz { get; set; }
///
///
///
[SugarColumn(ColumnName="MAIN_PRODUCT_NO" )]
public string MainProductNo { get; set; }
///
///
///
[SugarColumn(ColumnName="MAIN_PRODUCT_QTY" )]
public int? MainProductQty { get; set; }
///
///
///
[SugarColumn(ColumnName="CUSTOMER_ITEM_NUMBER" )]
public string CustomerItemNumber { get; set; }
///
///
///
[SugarColumn(ColumnName="PACKING_LIST_NUMBER" )]
public string PackingListNumber { get; set; }
///
///
///
[SugarColumn(ColumnName="CUSTOMER_NAME" )]
public string CustomerName { get; set; }
///
///
///
[SugarColumn(ColumnName="CUSTOMER" )]
public string Customer { get; set; }
///
///
///
[SugarColumn(ColumnName="TYPE" )]
public string Type { get; set; }
///
///
///
[SugarColumn(ColumnName="JA_BS" )]
public string JaBs { get; set; }
///
///
///
[SugarColumn(ColumnName="JA_TIME" )]
public DateTime? JaTime { get; set; }
///
///
///
[SugarColumn(ColumnName="YP_NUM" )]
public int? YpNum { get; set; }
///
///
///
[SugarColumn(ColumnName="CAA011_1" )]
public string Caa0111 { get; set; }
///
///
///
[SugarColumn(ColumnName="ERP_GYZZ" )]
public int? ErpGyzz { get; set; }
///
///
///
[SugarColumn(ColumnName="ERP_FLZZ" )]
public int? ErpFlzz { get; set; }
///
/// 是否入库
///
[SugarColumn(ColumnName="ERP_SLZZ" )]
public int? ErpSlzz { get; set; }
///
/// 是否退库
///
[SugarColumn(ColumnName="ERP_RKZZ" )]
public int? ErpRkzz { get; set; }
///
/// 是否换货
///
[SugarColumn(ColumnName="ERP_RKHZ" )]
public int? ErpRkhz { get; set; }
///
/// 是否寄售
///
[SugarColumn(ColumnName="ERP_JJDS" )]
public int? ErpJjds { get; set; }
///
/// 是否按款
///
[SugarColumn(ColumnName="ERP_BZDS" )]
public int? ErpBzds { get; set; }
///
/// 是否新建
///
[SugarColumn(ColumnName="CAA025" )]
public int? Caa025 { get; set; }
///
/// 采购订单号
///
[SugarColumn(ColumnName="FPURORDERNO" )]
public string Fpurorderno { get; set; }
///
/// 采购订单行号
///
[SugarColumn(ColumnName="FPURORDERENTRYSEQ" )]
public string Fpurorderentryseq { get; set; }
///
/// 备注(表体)
///
[SugarColumn(ColumnName="Btbz" )]
public string Btbz { get; set; }
}
}