using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 任务单物料表
|
/// </summary>
|
[SugarTable("WOMCAB")]
|
public class Womcab
|
{
|
/// <summary>
|
/// 自增列
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_CAB", IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 生产用料清单行内码
|
/// </summary>
|
[SugarColumn(ColumnName = "ERPID")]
|
public decimal? Erpid { get; set; }
|
|
/// <summary>
|
/// 工单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB001")]
|
public string? Cab001 { get; set; }
|
|
/// <summary>
|
/// 序号
|
/// </summary>
|
[SugarColumn(ColumnName = "CAB002")]
|
public string? 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 decimal? Cab014 { get; set; }
|
|
/// <summary>
|
/// 生产订单行内码
|
/// </summary>
|
[SugarColumn(ColumnName = "PID")]
|
public decimal? Pid { get; set; }
|
|
/// <summary>
|
/// 生产订单行内码
|
/// </summary>
|
[SugarColumn(ColumnName = "EID")]
|
public decimal? 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>
|
/// 发料方式
|
/// </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 decimal? Numerator { get; set; }
|
|
/// <summary>
|
/// 分母
|
/// </summary>
|
[SugarColumn(ColumnName = "DENOMINATOR")]
|
public decimal? Denominator { get; set; }
|
|
/// <summary>
|
/// 固定损耗
|
/// </summary>
|
[SugarColumn(ColumnName = "SCRAPQTY")]
|
public decimal? Scrapqty { get; set; }
|
|
/// <summary>
|
/// 变动损耗率
|
/// </summary>
|
[SugarColumn(ColumnName = "SCRAPRATE")]
|
public decimal? Scraprate { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_ORDER")]
|
public string? SalesOrder { get; set; }
|
|
/// <summary>
|
/// 需求单据
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_TEXT1")]
|
public string? FWwcText1 { get; set; }
|
|
/// <summary>
|
/// 计划完工日期
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_DATE")]
|
public DateTime? FWwcDate { get; set; }
|
|
/// <summary>
|
/// 旧物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")]
|
public string? FwwcBaseproperty { get; set; }
|
|
/// <summary>
|
/// 使用比例
|
/// </summary>
|
[SugarColumn(ColumnName = "FUSERATE")]
|
public decimal? Fuserate { get; set; }
|
|
/// <summary>
|
/// 子项类型 1标准件 2返还件 3替代件
|
/// </summary>
|
[SugarColumn(ColumnName = "FMATERIALTYPE")]
|
public decimal? Fmaterialtype { get; set; }
|
|
/// <summary>
|
/// 子项类型（1-标准件 2-返还件 3-替代件）
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_TYPE", Length = 1)]
|
public string? MaterialType { get; set; }
|
|
/// <summary>
|
/// 使用比例（%）
|
/// </summary>
|
[SugarColumn(ColumnName = "USE_RATE", ColumnDataType = "NUMBER(5,2)")]
|
public decimal? UseRate { get; set; }
|
|
/// <summary>
|
/// 项次
|
/// </summary>
|
[SugarColumn(ColumnName = "FREPLACEGROUP", ColumnDataType = "NUMBER(5,2)")]
|
public decimal? FreplaceGroup { get; set; }
|
|
/// <summary>
|
/// 应发数量
|
/// </summary>
|
[SugarColumn(ColumnName = "MUST_QTY", ColumnDataType = "NUMBER(18,3)")]
|
public decimal? MustQty { get; set; }
|
|
/// <summary>
|
/// 用料清单状态（A-创建，B-审核中，C-已审核，D-重新审核，Z-暂存）
|
/// </summary>
|
[SugarColumn(ColumnName = "TYPEB", Length = 2)]
|
public string? TypeB { get; set; }
|
|
/// <summary>
|
/// 项目
|
/// </summary>
|
[SugarColumn(ColumnName = "PROJECT")]
|
public string? Project { get; set; }
|
|
/// <summary>
|
/// BOM需求量
|
/// </summary>
|
[SugarColumn(ColumnName = "BOMREQQTY")]
|
public decimal? Bomreqqty { get; set; }
|
|
/// <summary>
|
/// 超额类型
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIALTYPE")]
|
public string? Materialtype { get; set; }
|
|
/// <summary>
|
/// 超额发料
|
/// </summary>
|
[SugarColumn(ColumnName = "ISOVERISSUE")]
|
public decimal? IsOverIssue { get; set; }
|
|
/// <summary>
|
/// 超额比例
|
/// </summary>
|
[SugarColumn(ColumnName = "STANDARD_MATERIALSCALE")]
|
public decimal? StandardMaterialscale { get; set; }
|
|
/// <summary>
|
/// 固定超额量
|
/// </summary>
|
[SugarColumn(ColumnName = "FIXEDMATERIALNUM")]
|
public decimal? Fixedmaterialnum { get; set; }
|
|
/// <summary>
|
/// 替代料
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUBSTITUTE")]
|
public decimal? IsSubstitute { get; set; }
|
|
/// <summary>
|
/// 被替代料品
|
/// </summary>
|
[SugarColumn(ColumnName = "SUBSTITUTEDITEM")]
|
public decimal? Substituteditem { get; set; }
|
|
/// <summary>
|
/// 发料单位
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUEUOM")]
|
public decimal? Issueuom { get; set; }
|
|
/// <summary>
|
/// 每装配件数量
|
/// </summary>
|
[SugarColumn(ColumnName = "QPA")]
|
public decimal? Qpa { get; set; }
|
|
/// <summary>
|
/// 损耗类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SCRAPTYPE")]
|
public string? Scraptype { get; set; }
|
|
/// <summary>
|
/// 倒冲时机
|
/// </summary>
|
[SugarColumn(ColumnName = "BFOPOPPORTUNITY")]
|
public string? Bfopportunity { get; set; }
|
|
/// <summary>
|
/// 供应地点
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLYWH")]
|
public string? Supplywh { get; set; }
|
|
/// <summary>
|
/// 订单开工齐套检查
|
/// </summary>
|
[SugarColumn(ColumnName = "MOCOMPLETESETCHECK")]
|
public decimal? Mocompletesetcheck { get; set; }
|
|
/// <summary>
|
/// 订单完工齐套检查
|
/// </summary>
|
[SugarColumn(ColumnName = "MOSTARTSETCHECK")]
|
public decimal? Mostartsetcheck { get; set; }
|
|
/// <summary>
|
/// 齐套发料
|
/// </summary>
|
[SugarColumn(ColumnName = "ISCOUPLEISSUE")]
|
public decimal? Iscoupleissue { get; set; }
|
|
/// <summary>
|
/// 表行备注
|
/// </summary>
|
[SugarColumn(ColumnName = "MEMO")]
|
public string? FDescription { get; set; }
|
}
|
