using SqlSugar;
|
|
namespace NewPdaSqlServer.entity;
|
|
/// <summary>
|
/// 采购订单明细表
|
/// </summary>
|
[SugarTable("MES_ROH_IN_DATA")]
|
public class MesRohInData
|
{
|
/// <summary>
|
/// 默认值: (newid())
|
/// </summary>
|
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// 采购单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string BillNo { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_ORDER_ID")]
|
public string SalesOrderId { get; set; }
|
|
/// <summary>
|
/// 采购订单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "ORDER_LINE_ID")]
|
public string OrderLineId { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public string ItemId { get; set; }
|
|
/// <summary>
|
/// 采购单位
|
/// </summary>
|
[SugarColumn(ColumnName = "PURCHASE_UNIT")]
|
public string PurchaseUnit { get; set; }
|
|
/// <summary>
|
/// 采购数量
|
/// </summary>
|
[SugarColumn(ColumnName = "PURCHASE_QTY")]
|
public decimal? PurchaseQty { get; set; }
|
|
/// <summary>
|
/// 库存单位
|
/// </summary>
|
[SugarColumn(ColumnName = "INVENTORY_UNIT")]
|
public string InventoryUnit { get; set; }
|
|
/// <summary>
|
/// 计价单位
|
/// </summary>
|
[SugarColumn(ColumnName = "PRICING_UNIT")]
|
public string PricingUnit { get; set; }
|
|
/// <summary>
|
/// 计价数量
|
/// </summary>
|
[SugarColumn(ColumnName = "PRICING_QTY")]
|
public decimal? PricingQty { get; set; }
|
|
/// <summary>
|
/// 交货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_DATE")]
|
public DateTime? DeliveryDate { get; set; }
|
|
/// <summary>
|
/// 最早交货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "EARLIEST_DELIVERY_DATE")]
|
public DateTime? EarliestDeliveryDate { get; set; }
|
|
/// <summary>
|
/// 最晚交货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "LATEST_DELIVERY_DATE")]
|
public DateTime? LatestDeliveryDate { get; set; }
|
|
/// <summary>
|
/// 需求组织
|
/// </summary>
|
[SugarColumn(ColumnName = "DEMAND_ORG")]
|
public string DemandOrg { get; set; }
|
|
/// <summary>
|
/// 收料组织
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVING_ORG")]
|
public string ReceivingOrg { get; set; }
|
|
/// <summary>
|
/// 结算组织
|
/// </summary>
|
[SugarColumn(ColumnName = "SETTLEMENT_ORG")]
|
public string SettlementOrg { get; set; }
|
|
/// <summary>
|
/// 是否赠品
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_GIFT")]
|
public string IsGift { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARKS")]
|
public string Remarks { get; set; }
|
|
/// <summary>
|
/// 供应商物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLIER_ITEM_CODE")]
|
public string SupplierItemCode { get; set; }
|
|
/// <summary>
|
/// 供应商物料名称
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPPLIER_ITEM_NAME")]
|
public string SupplierItemName { get; set; }
|
|
/// <summary>
|
/// 委外订单编号
|
/// </summary>
|
[SugarColumn(ColumnName = "OUTSOURCING_ORDER_ID")]
|
public string OutsourcingOrderId { get; set; }
|
|
/// <summary>
|
/// 批号
|
/// </summary>
|
[SugarColumn(ColumnName = "BATCH_NUMBER")]
|
public string BatchNumber { get; set; }
|
|
/// <summary>
|
/// 业务关闭
|
/// </summary>
|
[SugarColumn(ColumnName = "BUSINESS_CLOSE")]
|
public string BusinessClose { get; set; }
|
|
/// <summary>
|
/// 业务冻结
|
/// </summary>
|
[SugarColumn(ColumnName = "BUSINESS_FREEZE")]
|
public string BusinessFreeze { get; set; }
|
|
/// <summary>
|
/// 冻结人
|
/// </summary>
|
[SugarColumn(ColumnName = "FREEZER")]
|
public string Freezer { get; set; }
|
|
/// <summary>
|
/// 冻结时间
|
/// </summary>
|
[SugarColumn(ColumnName = "FREEZE_TIME")]
|
public DateTime? FreezeTime { get; set; }
|
|
/// <summary>
|
/// 业务终止
|
/// </summary>
|
[SugarColumn(ColumnName = "BUSINESS_TERMINATE")]
|
public string BusinessTerminate { get; set; }
|
|
/// <summary>
|
/// 终止人
|
/// </summary>
|
[SugarColumn(ColumnName = "TERMINATOR")]
|
public string Terminator { get; set; }
|
|
/// <summary>
|
/// 终止时间
|
/// </summary>
|
[SugarColumn(ColumnName = "TERMINATE_TIME")]
|
public DateTime? TerminateTime { get; set; }
|
|
/// <summary>
|
/// 累计收料数量
|
/// </summary>
|
[SugarColumn(ColumnName = "TOTAL_RECEIVED_QTY")]
|
public int? TotalReceivedQty { get; set; }
|
|
/// <summary>
|
/// 剩余收料数量
|
/// </summary>
|
[SugarColumn(ColumnName = "REMAINING_RECEIVED_QTY")]
|
public decimal? RemainingReceivedQty { get; set; }
|
|
/// <summary>
|
/// 累计入库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "TOTAL_STORED_QTY")]
|
public int? TotalStoredQty { get; set; }
|
|
/// <summary>
|
/// 剩余入库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "REMAINING_STORED_QTY")]
|
public decimal? RemainingStoredQty { get; set; }
|
|
/// <summary>
|
/// 累计退料数量
|
/// </summary>
|
[SugarColumn(ColumnName = "TOTAL_RETURNED_QTY")]
|
public int? TotalReturnedQty { get; set; }
|
|
/// <summary>
|
/// 收料可退数量
|
/// </summary>
|
[SugarColumn(ColumnName = "RETURNABLE_RECEIVED_QTY")]
|
public int? ReturnableReceivedQty { get; set; }
|
|
/// <summary>
|
/// 库存可退数量
|
/// </summary>
|
[SugarColumn(ColumnName = "RETURNABLE_STORED_QTY")]
|
public int? ReturnableStoredQty { get; set; }
|
|
/// <summary>
|
/// 源单类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SOURCE_DOCUMENT_TYPE")]
|
public string SourceDocumentType { get; set; }
|
|
/// <summary>
|
/// 源单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SOURCE_DOCUMENT_ID")]
|
public string SourceDocumentId { get; set; }
|
|
/// <summary>
|
/// 需求跟踪号
|
/// </summary>
|
[SugarColumn(ColumnName = "DEMAND_TRACKING_ID")]
|
public string DemandTrackingId { get; set; }
|
|
/// <summary>
|
/// 计划跟踪号
|
/// </summary>
|
[SugarColumn(ColumnName = "PLAN_TRACKING_ID")]
|
public string PlanTrackingId { get; set; }
|
|
/// <summary>
|
/// 变更标志
|
/// </summary>
|
[SugarColumn(ColumnName = "CHANGE_FLAG")]
|
public string ChangeFlag { get; set; }
|
|
/// <summary>
|
/// 需求来源
|
/// </summary>
|
[SugarColumn(ColumnName = "DEMAND_SOURCE")]
|
public string DemandSource { get; set; }
|
|
/// <summary>
|
/// 需求单据编号
|
/// </summary>
|
[SugarColumn(ColumnName = "DEMAND_DOCUMENT_ID")]
|
public string DemandDocumentId { get; set; }
|
|
/// <summary>
|
/// 需求单据行号
|
/// </summary>
|
[SugarColumn(ColumnName = "DEMAND_DOCUMENT_LINE_ID")]
|
public string DemandDocumentLineId { get; set; }
|
|
/// <summary>
|
/// ERP的ID号
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN_K3ID")]
|
public int? EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 客户货号
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK1")]
|
public string Remark1 { get; set; }
|
|
/// <summary>
|
/// 包装单号
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK2")]
|
public string Remark2 { get; set; }
|
|
/// <summary>
|
/// 主产品
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK3")]
|
public string Remark3 { get; set; }
|
|
/// <summary>
|
/// SMT备注
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK4")]
|
public string Remark4 { get; set; }
|
|
/// <summary>
|
/// ERP的头ID号
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public int? ErpId { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "PURCHASE_ORDER_LINE_NUMBER")]
|
public string PurchaseOrderLineNumber { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "DEMAND")]
|
public string Demand { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVING")]
|
public string Receiving { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "SETTLEMENT")]
|
public string Settlement { get; set; }
|
|
/// <summary>
|
/// erp推来的已交货数量
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "CGB014")]
|
public int? Cgb014 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "DEMAND_DEPARTMENT")]
|
public string DemandDepartment { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVING_DEPARTMENT")]
|
public string ReceivingDepartment { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "FPREARRIVALDATE")]
|
public DateTime? Fprearrivaldate { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "FDEMANDBILLNO_LINE")]
|
public string FdemandbillnoLine { get; set; }
|
}
|
