using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <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 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>
|
/// 采购订单行号（K3系统）
|
/// </summary>
|
[SugarColumn(ColumnName = "EBELN_K3ID")]
|
public decimal? EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 备注1
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK1")]
|
public string? Remark1 { get; set; }
|
|
/// <summary>
|
/// 备注2
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK2")]
|
public string? Remark2 { get; set; }
|
|
/// <summary>
|
/// 备注3
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK3")]
|
public string? Remark3 { get; set; }
|
|
/// <summary>
|
/// 备注4
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK4")]
|
public string? Remark4 { get; set; }
|
|
/// <summary>
|
/// 备注5
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK5")]
|
public string? Remark5 { get; set; }
|
|
/// <summary>
|
/// 主键ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID")]
|
public int 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; }
|
|
/// <summary>
|
/// 预留字段CGB014
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "CGB014")]
|
public decimal? Cgb014 { get; set; }
|
|
/// <summary>
|
/// 工厂
|
/// </summary>
|
[SugarColumn(ColumnName = "FACTORY")]
|
public string? Factory { get; set; }
|
|
/// <summary>
|
/// 公司编号
|
/// </summary>
|
[SugarColumn(ColumnName = "COMPANY")]
|
public string? Company { 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 = "prearrivaldate")]
|
public DateTime? prearrivaldate { get; set; }
|
}
|
