using SqlSugar;
|
|
namespace NewPdaSqlServer.entity;
|
|
/// <summary>
|
/// 生产订单表(委外) 子表
|
/// </summary>
|
[SugarTable("PRODUCTION_ORDER_SUB")]
|
public class ProductionOrderSub
|
{
|
/// <summary>
|
/// 默认值: (newid())
|
/// </summary>
|
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// 工单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_ORDER_NO")]
|
public string? WorkOrderNo { get; set; }
|
|
/// <summary>
|
/// 序号
|
/// </summary>
|
[SugarColumn(ColumnName = "SEQUENCE_NO")]
|
public int? SequenceNo { get; set; }
|
|
/// <summary>
|
/// 材料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_CODE")]
|
public string? MaterialCode { get; set; }
|
|
/// <summary>
|
/// 需领用量
|
/// </summary>
|
[SugarColumn(ColumnName = "REQUIRED_QTY")]
|
public decimal? RequiredQty { get; set; }
|
|
/// <summary>
|
/// 已领用量
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUED_QTY")]
|
public decimal? IssuedQty { get; set; }
|
|
/// <summary>
|
/// 位置号
|
/// </summary>
|
[SugarColumn(ColumnName = "LOCATION_NO")]
|
public string? LocationNo { get; set; }
|
|
/// <summary>
|
/// 供应组织
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLYING_ORG")]
|
public string? SupplyingOrg { get; set; }
|
|
/// <summary>
|
/// 发料组织
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUING_ORG")]
|
public string? IssuingOrg { get; set; }
|
|
/// <summary>
|
/// 货主
|
/// </summary>
|
[SugarColumn(ColumnName = "STOCK_OWNER")]
|
public string? StockOwner { get; set; }
|
|
/// <summary>
|
/// 计划跟踪号
|
/// </summary>
|
[SugarColumn(ColumnName = "TRACKING_NO")]
|
public string? TrackingNo { get; set; }
|
|
/// <summary>
|
/// 批号
|
/// </summary>
|
[SugarColumn(ColumnName = "BATCH_NO")]
|
public string? BatchNo { get; set; }
|
|
/// <summary>
|
/// 仓库
|
/// </summary>
|
[SugarColumn(ColumnName = "WAREHOUSE")]
|
public string? Warehouse { get; set; }
|
|
/// <summary>
|
/// 发料方式
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUING_METHOD")]
|
public string? IssuingMethod { get; set; }
|
|
/// <summary>
|
/// 工艺
|
/// </summary>
|
[SugarColumn(ColumnName = "PROCESS")]
|
public string? Process { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[SugarColumn(ColumnName = "UNIT")]
|
public string? Unit { get; set; }
|
|
/// <summary>
|
/// 供应类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLYING_TYPE")]
|
public string? SupplyingType { get; set; }
|
|
/// <summary>
|
/// 组成用量
|
/// </summary>
|
[SugarColumn(ColumnName = "COMPOSITION_QTY")]
|
public decimal? CompositionQty { get; set; }
|
|
/// <summary>
|
/// 是否替料
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_SUBSTITUTE")]
|
public string? IsSubstitute { get; set; }
|
|
/// <summary>
|
/// 分子
|
/// </summary>
|
[SugarColumn(ColumnName = "NUMERATOR")]
|
public decimal? Numerator { get; set; }
|
|
/// <summary>
|
/// 分母
|
/// </summary>
|
[SugarColumn(ColumnName = "DENOMINATOR")]
|
public decimal? Denominator { get; set; }
|
|
/// <summary>
|
/// ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public string? ErpId { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_HEADER_ID")]
|
public string? ErpHeaderId { get; set; }
|
|
/// <summary>
|
/// 固定损耗
|
/// </summary>
|
[SugarColumn(ColumnName = "FIXED_LOSS")]
|
public decimal? FixedLoss { get; set; }
|
|
/// <summary>
|
/// 变动损耗率%
|
/// </summary>
|
[SugarColumn(ColumnName = "VARIABLE_LOSS_RATE")]
|
public decimal? VariableLossRate { get; set; }
|
|
/// <summary>
|
/// 子项类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SUB_ITEM_TYPE")]
|
public string? SubItemType { get; set; }
|
|
/// <summary>
|
/// 子项单位
|
/// </summary>
|
[SugarColumn(ColumnName = "SUB_ITEM_UNIT")]
|
public string? SubItemUnit { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_ORDER_NO")]
|
public string? SalesOrderNo { get; set; }
|
|
/// <summary>
|
/// 项次号
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 发料组织
|
/// </summary>
|
[SugarColumn(ColumnName = "ISSUING_ORG_2")]
|
public string? IssuingOrg2 { get; set; }
|
|
/// <summary>
|
/// 货主类型
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER_TYPE")]
|
public string? OwnerType { get; set; }
|
|
/// <summary>
|
/// 货主
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER")]
|
public string? Owner { get; set; }
|
|
/// <summary>
|
/// 供应组织
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLYING_ORG_2")]
|
public string? SupplyingOrg2 { get; set; }
|
|
/// <summary>
|
/// 制程不良退料数量
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "TLNUM1")]
|
public int? Tlnum1 { get; set; }
|
|
/// <summary>
|
/// 来料不良退料数量
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "TLNUM2")]
|
public int? Tlnum2 { get; set; }
|
|
/// <summary>
|
/// 良品退料数量
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "TLNUM3")]
|
public int? Tlnum3 { get; set; }
|
|
/// <summary>
|
/// 补料数量
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "BLNUM")]
|
public int? Blnum { get; set; }
|
|
/// <summary>
|
/// ERP生产订单分录内码
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_PRODUCTION_ENTRY_CODE")]
|
public string? ErpProductionEntryCode { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "UNIT2")]
|
public string? Unit2 { 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>
|
/// A，创建 B，审核中 C，已审核 D，重新审核 Z，暂存
|
/// </summary>
|
[SugarColumn(ColumnName = "TYPEB")]
|
public string? Typeb { get; set; }
|
}
|
