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>
    ///     生产用料清单行内码
    /// </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>
    ///     生产订单行内码
    /// </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? F_WWC_TEXT1 { get; set; }

    /// <summary>
    ///     计划完工日期
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_DATE")]
    public DateTime? F_WWC_DATE { get; set; }

    /// <summary>
    ///     旧物料编码
    /// </summary>
    [SugarColumn(ColumnName = "F_WWC_BASEPROPERTY")]
    public string? F_WWC_BASEPROPERTY { get; set; }

    /// <summary>
    ///     使用比例
    /// </summary>
    [SugarColumn(ColumnName = "FUSERATE")]
    public string? FUSERATE { get; set; }

    /// <summary>
    ///     子项类型 1标准件 2返还件 3替代件
    /// </summary>
    [SugarColumn(ColumnName = "FMATERIALTYPE")]
    public string? FMATERIALTYPE { get; set; }
}