using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 工单子表
|
/// </summary>
|
[SugarTable("WOMCAB")]
|
public class Womcab
|
{
|
/// <summary>
|
/// 自增列
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true,
|
OracleSequenceName = "SEQ_CAB")]
|
public decimal? Id { get; set; }
|
|
/// <summary>
|
/// ERPID
|
/// </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 string? Cab014 { get; set; }
|
|
/// <summary>
|
/// PID
|
/// </summary>
|
[SugarColumn(ColumnName = "PID")]
|
public decimal? Pid { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </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>
|
/// 供应类型
|
/// </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 = "Must_Qty")]
|
public decimal? MustQty { get; set; }
|
|
/// <summary>
|
/// 项次号
|
/// </summary>
|
[SugarColumn(ColumnName = "FREPLACEGROUP")]
|
public int? Freplacegroup { 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; }
|
|
/// <summary>
|
/// A，创建 B，审核中 C，已审核 D，重新审核 Z，暂存
|
/// </summary>
|
[SugarColumn(ColumnName = "TYPEB")]
|
public string? Typeb { get; set; }
|
|
|
|
/////----委外新增
|
|
/// <summary>
|
/// 是否发损耗 -- 委外新增
|
/// </summary>
|
[SugarColumn(ColumnName = "FISGETSCRAP")]
|
public string? Fisgetscrap { get; set; }
|
|
/// <summary>
|
/// 是否关键件 -- 委外新增
|
/// </summary>
|
[SugarColumn(ColumnName = "FISKEYCOMPONENT")]
|
public string? Fiskeycomponent { get; set; }
|
|
/// <summary>
|
/// 拨出组织 -- 委外新增
|
/// </summary>
|
[SugarColumn(ColumnName = "FSRCTRANSORGID")]
|
public string? Fsrctransorgid { get; set; }
|
|
/// <summary>
|
/// 拨出仓库 -- 委外新增
|
/// </summary>
|
[SugarColumn(ColumnName = "FSRCTRANSSTOCKID")]
|
public string? Fsrctransstockid { get; set; }
|
|
/// <summary>
|
/// 库存状态 -- 委外新增
|
/// </summary>
|
[SugarColumn(ColumnName = "FSTOCKSTATUSID")]
|
public string? Fstockstatusid { get; set; }
|
|
/// <summary>
|
/// 需求日期 -- 委外新增
|
/// </summary>
|
[SugarColumn(ColumnName = "FNEEDDATE")]
|
public DateTime? Fneeddate { get; set; }
|
|
/// <summary>
|
/// 预留类型 -- 委外新增
|
/// </summary>
|
[SugarColumn(ColumnName = "FRESERVETYPE")]
|
public string? Freservetype { get; set; }
|
|
/// <summary>
|
/// 用料清单备注 -- 委外新增
|
/// </summary>
|
[SugarColumn(ColumnName = "FMEMO")]
|
public string? Fmemo { get; set; }
|
|
/// <summary>
|
/// ERP生产订单分录内码 -- 委外新增
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
|
public string? ErpProductionEntryCode { get; set; }
|
|
/// <summary>
|
/// 货主类型
|
/// </summary>
|
[SugarColumn(ColumnName = "FOWNERTYPEID")]
|
public string? FOWNERTYPEID { get; set; }
|
|
|
|
/// <summary>
|
/// 子项单位
|
/// </summary>
|
[SugarColumn(ColumnName = "FUNITID2")]
|
public string? FUNITID2 { get; set; }
|
|
/// <summary>
|
/// 子项单位
|
/// </summary>
|
[SugarColumn(ColumnName = "FUNITID3")]
|
public string? FUNITID3 { get; set; }
|
}
|
