using SqlSugar;
|
|
namespace NewPdaSqlServer.entity;
|
|
/// <summary>
|
/// 任务单物料表bom
|
/// </summary>
|
[SugarTable("WOMCAB")]
|
public class Womcab
|
{
|
/// <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 = "CAB001")]
|
public string Cab001 { get; set; }
|
|
/// <summary>
|
/// 序号
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB002")]
|
public int? Cab002 { get; set; }
|
|
/// <summary>
|
/// 材料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB003")]
|
public string Cab003 { get; set; }
|
|
/// <summary>
|
/// 需领用量
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB006")]
|
public decimal? Cab006 { get; set; }
|
|
/// <summary>
|
/// 已领用量
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB007")]
|
public decimal? Cab007 { get; set; }
|
|
/// <summary>
|
/// 工艺
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB008")]
|
public string Cab008 { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB009")]
|
public string Cab009 { get; set; }
|
|
/// <summary>
|
/// 组成用量
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB012")]
|
public decimal? Cab012 { get; set; }
|
|
/// <summary>
|
/// 是否替料
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB014")]
|
public string Cab014 { get; set; }
|
|
/// <summary>
|
/// PID
|
/// </summary>
|
[SugarColumn(ColumnName = "PID")]
|
public int? Pid { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </summary>
|
[SugarColumn(ColumnName = "EID")]
|
public int? Eid { get; set; }
|
|
/// <summary>
|
/// 位置号
|
/// </summary>
|
[SugarColumn(ColumnName = "POSITION_NO")]
|
public string PositionNo { get; set; }
|
|
/// <summary>
|
/// 发料组织
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUING_ORGANIZATION")]
|
public string IssuingOrganization { get; set; }
|
|
/// <summary>
|
/// 供应组织
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLY_ORGANIZATION")]
|
public string SupplyOrganization { get; set; }
|
|
/// <summary>
|
/// 货主
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER_ID")]
|
public string OwnerId { 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 = "DEPOT_CODE")]
|
public string DepotCode { get; set; }
|
|
/// <summary>
|
/// 发料方式 1、直接领料；2、直接倒冲；3、调拨领料；4、调拨到冲；7、不发料
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUE_TYPE")]
|
public string IssueType { get; set; }
|
|
/// <summary>
|
/// 供应类型(C采购 Z自制 W委外)
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLY_TYPE")]
|
public string SupplyType { get; set; }
|
|
/// <summary>
|
/// 分子
|
/// </summary>
|
[SugarColumn(ColumnName = "NUMERATOR")]
|
public string Numerator { get; set; }
|
|
/// <summary>
|
/// 分母
|
/// </summary>
|
[SugarColumn(ColumnName = "DENOMINATOR")]
|
public string Denominator { get; set; }
|
|
/// <summary>
|
/// 固定损耗
|
/// </summary>
|
[SugarColumn(ColumnName = "SCRAPQTY")]
|
public string Scrapqty { get; set; }
|
|
/// <summary>
|
/// 变动损耗率
|
/// </summary>
|
[SugarColumn(ColumnName = "SCRAPRATE")]
|
public string Scraprate { 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 = "MAIN_PRODUCT")]
|
public string MainProduct { get; set; }
|
|
/// <summary>
|
/// 主产品数量
|
/// </summary>
|
[SugarColumn(ColumnName = "MAIN_PRODUCT_QTY")]
|
public int? MainProductQty { get; set; }
|
|
/// <summary>
|
/// 父项物料名称
|
/// </summary>
|
[SugarColumn(ColumnName = "PARENT_ITEM_NAME")]
|
public string ParentItemName { get; set; }
|
|
/// <summary>
|
/// 销售订单
|
/// </summary>
|
[SugarColumn(ColumnName = "FSALEORDERNO")]
|
public string Fsaleorderno { get; set; }
|
|
/// <summary>
|
/// 货主类型
|
/// </summary>
|
[SugarColumn(ColumnName = "FOWNERTYPEID")]
|
public string Fownertypeid { get; set; }
|
|
/// <summary>
|
/// 项次号
|
/// </summary>
|
[SugarColumn(ColumnName = "FREPLACEGROUP")]
|
public int? Freplacegroup { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_XSDDH")]
|
public string ErpXsddh { get; set; }
|
|
/// <summary>
|
/// 子项类型
|
/// </summary>
|
[SugarColumn(ColumnName = "FMATERIALTYPE")]
|
public string Fmaterialtype { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "FUNITID")]
|
public string Funitid { get; set; }
|
|
/// <summary>
|
/// 应发数量
|
/// </summary>
|
[SugarColumn(ColumnName = "Must_Qty")]
|
public decimal? MustQty { get; set; }
|
|
/// <summary>
|
/// 使用比例（%）
|
/// </summary>
|
[SugarColumn(ColumnName = "Use_Rate")]
|
public decimal? UseRate { get; set; }
|
|
/// <summary>
|
/// 子项类型 1标准件 2返还件 3替代件
|
/// </summary>
|
[SugarColumn(ColumnName = "Material_Type")]
|
public string MaterialType { get; set; }
|
}
|
