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; }
|
}
|
}
|
