using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 采购订单明细表
|
/// </summary>
|
[SugarTable("MES_ROH_IN_DATA")]
|
public class MesRohInData
|
{
|
/// <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 = "ITEM_NAME")]
|
[SugarColumn(IsIgnore = true)]
|
public string? ItemName { get; set; }
|
|
/// <summary>
|
/// 物料规格
|
/// </summary>
|
// [SugarColumn(ColumnName = "ITEM_SPEC")]
|
[SugarColumn(IsIgnore = true)]
|
public string? ItemSpec { 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>
|
/// 业务关闭 A:正常，B:业务终止
|
/// </summary>
|
[SugarColumn(ColumnName = "BUSINESS_CLOSE")]
|
public string? BusinessClose { get; set; }
|
|
/// <summary>
|
/// 业务冻结 A:正常，B:业务终止
|
/// </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 decimal? TotalReceivedQty { get; set; }
|
|
/// <summary>
|
/// 剩余收料数量
|
/// </summary>
|
[SugarColumn(ColumnName = "REMAINING_RECEIVED_QTY")]
|
public decimal? RemainingReceivedQty { get; set; }
|
|
/// <summary>
|
/// 累计入库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "TOTAL_STORED_QTY")]
|
public decimal? TotalStoredQty { get; set; }
|
|
/// <summary>
|
/// 剩余入库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "REMAINING_STORED_QTY")]
|
public decimal? RemainingStoredQty { get; set; }
|
|
/// <summary>
|
/// 累计退料数量
|
/// </summary>
|
[SugarColumn(ColumnName = "TOTAL_RETURNED_QTY")]
|
public decimal? TotalReturnedQty { get; set; }
|
|
/// <summary>
|
/// 收料可退数量
|
/// </summary>
|
[SugarColumn(ColumnName = "RETURNABLE_RECEIVED_QTY")]
|
public decimal? ReturnableReceivedQty { get; set; }
|
|
/// <summary>
|
/// 库存可退数量
|
/// </summary>
|
[SugarColumn(ColumnName = "RETURNABLE_STORED_QTY")]
|
public decimal? 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 decimal? 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>
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK4")]
|
public string? Remark4 { get; set; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK5")]
|
public string? Remark5 { get; set; }
|
|
/// <summary>
|
/// SEQ_BASEINFO_ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_BASEINFO_ID",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public decimal? 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; }
|
}
|
