using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using SqlSugar;
|
namespace MES.Service.Modes
|
{
|
/// <summary>
|
/// 销售发货通知单明细表
|
///</summary>
|
[SugarTable("SALES_DELIVERY_NOTICE_DETAIL")]
|
public class SalesDeliveryNoticeDetail
|
{
|
/// <summary>
|
///
|
///</summary>
|
[SugarColumn(ColumnName="ID", OracleSequenceName = "SEQ_DELIVERY_NOTICE_DETAIL", IsPrimaryKey = true)]
|
public decimal? Id { get; set; }
|
/// <summary>
|
/// 销售订单号
|
///</summary>
|
[SugarColumn(ColumnName="SALES_ORDER_ID" )]
|
public string SalesOrderId { get; set; }
|
/// <summary>
|
/// 物料编码
|
///</summary>
|
[SugarColumn(ColumnName="MATERIAL_ID" )]
|
public string MaterialId { get; set; }
|
/// <summary>
|
/// 物料名称
|
///</summary>
|
[SugarColumn(ColumnName="MATERIAL_NAME" )]
|
public string MaterialName { get; set; }
|
/// <summary>
|
/// 物料规格
|
///</summary>
|
[SugarColumn(ColumnName="MATERIAL_SPECIFICATION" )]
|
public string MaterialSpecification { get; set; }
|
/// <summary>
|
/// 销售单位
|
///</summary>
|
[SugarColumn(ColumnName="SALES_UNIT_ID" )]
|
public string SalesUnitId { get; set; }
|
/// <summary>
|
/// 销售数量
|
///</summary>
|
[SugarColumn(ColumnName="SALES_QUANTITY" )]
|
public decimal? SalesQuantity { get; set; }
|
/// <summary>
|
/// 是否赠品
|
///</summary>
|
[SugarColumn(ColumnName="IS_FREE" )]
|
public string IsFree { get; set; }
|
/// <summary>
|
/// 要货日期
|
///</summary>
|
[SugarColumn(ColumnName="DELIVERY_DATE" )]
|
public DateTime? DeliveryDate { get; set; }
|
/// <summary>
|
/// 出货仓库
|
///</summary>
|
[SugarColumn(ColumnName="WAREHOUSE" )]
|
public string Warehouse { get; set; }
|
/// <summary>
|
/// 计划跟踪号
|
///</summary>
|
[SugarColumn(ColumnName="PLAN_TRACKING_NUMBER" )]
|
public string PlanTrackingNumber { get; set; }
|
/// <summary>
|
/// 批号
|
///</summary>
|
[SugarColumn(ColumnName="LOT_NUMBER" )]
|
public string LotNumber { get; set; }
|
/// <summary>
|
/// 源单编号
|
///</summary>
|
[SugarColumn(ColumnName="SRC_BILL_NO" )]
|
public string SrcBillNo { get; set; }
|
/// <summary>
|
/// 计价数量
|
///</summary>
|
[SugarColumn(ColumnName="PRICE_QTY" )]
|
public decimal? PriceQty { get; set; }
|
/// <summary>
|
/// 货主
|
///</summary>
|
[SugarColumn(ColumnName="OWNER_ID" )]
|
public string OwnerId { get; set; }
|
/// <summary>
|
/// 库存单位
|
///</summary>
|
[SugarColumn(ColumnName="INVENTORY_UNIT" )]
|
public string InventoryUnit { get; set; }
|
/// <summary>
|
/// 库存数量
|
///</summary>
|
[SugarColumn(ColumnName="INVENTORY_QUANTITY" )]
|
public decimal? InventoryQuantity { get; set; }
|
/// <summary>
|
/// 物料类别
|
///</summary>
|
[SugarColumn(ColumnName="MATERIAL_CATEGORY" )]
|
public string MaterialCategory { get; set; }
|
/// <summary>
|
/// 计划发货日期
|
///</summary>
|
[SugarColumn(ColumnName="PLAN_DELIVERY_DATE" )]
|
public DateTime? PlanDeliveryDate { get; set; }
|
/// <summary>
|
/// 超发控制单位
|
///</summary>
|
[SugarColumn(ColumnName="OUT_LMT_UNIT" )]
|
public string OutLmtUnit { get; set; }
|
/// <summary>
|
/// 出库上限
|
///</summary>
|
[SugarColumn(ColumnName="OUT_MAX_QTY" )]
|
public decimal? OutMaxQty { get; set; }
|
/// <summary>
|
/// 出库下限
|
///</summary>
|
[SugarColumn(ColumnName="OUT_MIN_QTY" )]
|
public decimal? OutMinQty { get; set; }
|
/// <summary>
|
/// 交货地点
|
///</summary>
|
[SugarColumn(ColumnName="DELIVERY_LOC" )]
|
public string DeliveryLoc { get; set; }
|
/// <summary>
|
/// 交货地址
|
///</summary>
|
[SugarColumn(ColumnName="DELIVERYL_ADDRESS" )]
|
public string DeliverylAddress { get; set; }
|
/// <summary>
|
/// 源单单号
|
///</summary>
|
[SugarColumn(ColumnName="SOURCE_BILL_NO" )]
|
public string SourceBillNo { get; set; }
|
/// <summary>
|
/// 订单单号
|
///</summary>
|
[SugarColumn(ColumnName="ORDER_BILL_NO" )]
|
public string OrderBillNo { get; set; }
|
/// <summary>
|
/// 终止状态
|
///</summary>
|
[SugarColumn(ColumnName="TERMINATION_STATUS" )]
|
public string TerminationStatus { get; set; }
|
/// <summary>
|
/// 终止日期
|
///</summary>
|
[SugarColumn(ColumnName="TERMINATION_DATE" )]
|
public DateTime? TerminationDate { get; set; }
|
/// <summary>
|
/// 累计出库数量
|
///</summary>
|
[SugarColumn(ColumnName="SUM_OUT_QTY" )]
|
public decimal? SumOutQty { get; set; }
|
/// <summary>
|
/// 未出库数量
|
///</summary>
|
[SugarColumn(ColumnName="REMAIN_OUT_QTY" )]
|
public decimal? RemainOutQty { get; set; }
|
/// <summary>
|
/// ERP行ID
|
///</summary>
|
[SugarColumn(ColumnName="ERP_LINE_ID" )]
|
public string ErpLineId { get; set; }
|
/// <summary>
|
/// ERP头ID
|
///</summary>
|
[SugarColumn(ColumnName="ERP_HEAD_ID" )]
|
public string ErpHeadId { get; set; }
|
/// <summary>
|
/// ERP头ID
|
///</summary>
|
//[SugarColumn(ColumnName = "f_UNW_Base_GDY")]
|
//public string GDY { get; set; }
|
///// <summary>
|
///// 备注
|
/////</summary>
|
//[SugarColumn(ColumnName = "FEntrynote")]
|
//public string NOTE { get; set; }
|
/// <summary>
|
/// 要货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "FDELIVERYDATE", IsNullable = true)]
|
public string? FDeliveryDate { get; set; }
|
|
/// <summary>
|
/// 客户物料编码1
|
/// </summary>
|
[SugarColumn(ColumnName = "FMAPID", IsNullable = true)]
|
public string? FMapId { get; set; }
|
|
/// <summary>
|
/// 客户物料名称
|
/// </summary>
|
[SugarColumn(ColumnName = "FMAPNAME", IsNullable = true)]
|
public string? FMapName { get; set; }
|
|
/// <summary>
|
/// 客户料号2
|
/// </summary>
|
[SugarColumn(ColumnName = "FMAPID2", IsNullable = true)]
|
public string? FMapId2 { get; set; }
|
|
/// <summary>
|
/// 项目
|
/// </summary>
|
[SugarColumn(ColumnName = "FPROJECT", IsNullable = true)]
|
public string? FProject { get; set; }
|
|
/// <summary>
|
/// 存储地点
|
/// </summary>
|
[SugarColumn(ColumnName = "FSTORAGELOCATION", IsNullable = true)]
|
public string? FStorageLocation { get; set; }
|
|
/// <summary>
|
/// 免费品类型
|
/// </summary>
|
[SugarColumn(ColumnName = "FFREEITEMTYPE", IsNullable = true)]
|
public string? FFreeItemType { get; set; }
|
|
/// <summary>
|
/// 表体备注
|
/// </summary>
|
[SugarColumn(ColumnName = "FBODYNOTE", IsNullable = true)]
|
public string? FBodyNote { get; set; }
|
|
/// <summary>
|
/// 库存可用量
|
/// </summary>
|
[SugarColumn(ColumnName = "FAVAILABLESTOCK", IsNullable = true)]
|
public decimal? FAvailableStock { get; set; }
|
|
/// <summary>
|
/// 查询库存时间
|
/// </summary>
|
[SugarColumn(ColumnName = "FINVENTORYQUERYTIME", IsNullable = true)]
|
public string? FInventoryQueryTime { get; set; }
|
|
/// <summary>
|
/// 行状态
|
/// </summary>
|
[SugarColumn(ColumnName = "FLINESTATUS", IsNullable = true)]
|
public string? FLineStatus { get; set; }
|
|
/// <summary>
|
/// 收货地址全称
|
/// </summary>
|
[SugarColumn(ColumnName = "FRECEIVEADDRESSFULL", IsNullable = true)]
|
public string? FReceiveAddressFull { get; set; }
|
|
/// <summary>
|
/// 收货联系人
|
/// </summary>
|
[SugarColumn(ColumnName = "FRECEIVERCONTACT", IsNullable = true)]
|
public string? FReceiverContact { get; set; }
|
|
/// <summary>
|
/// 可退换
|
/// </summary>
|
[SugarColumn(ColumnName = "FRETURNEXCHANGEALLOWED", IsNullable = true)]
|
public string? FReturnExchangeAllowed { get; set; }
|
|
/// <summary>
|
/// 委外加工件数量
|
/// </summary>
|
[SugarColumn(ColumnName = "FOUTSOURCEDPROCESSQTY", IsNullable = true)]
|
public decimal? FOutsourcedProcessQty { get; set; }
|
|
/// <summary>
|
/// 可用日期
|
/// </summary>
|
[SugarColumn(ColumnName = "FAVAILABLEDATE", IsNullable = true)]
|
public string? FAvailableDate { get; set; }
|
|
/// <summary>
|
/// 承诺日期
|
/// </summary>
|
[SugarColumn(ColumnName = "FCOMMITMENTDATE", IsNullable = true)]
|
public string? FCommitmentDate { get; set; }
|
|
/// <summary>
|
/// 客户确认出货日
|
/// </summary>
|
[SugarColumn(ColumnName = "FCUSTOMERCONFIRMSHIPDATE", IsNullable = true)]
|
public string? FCustomerConfirmShipDate { get; set; }
|
|
/// <summary>
|
/// 计划组织
|
/// </summary>
|
[SugarColumn(ColumnName = "FPLANNEDORG", IsNullable = true)]
|
public string? FPlannedOrg { get; set; }
|
|
/// <summary>
|
/// 供应商直运
|
/// </summary>
|
[SugarColumn(ColumnName = "FVENDORDIRECTSHIP", IsNullable = true)]
|
public string? FVendorDirectShip { get; set; }
|
|
/// <summary>
|
/// 供应来源
|
/// </summary>
|
[SugarColumn(ColumnName = "FSUPPLYSOURCE", IsNullable = true)]
|
public string? FSupplySource { get; set; }
|
|
/// <summary>
|
/// 供应类型
|
/// </summary>
|
[SugarColumn(ColumnName = "FSUPPLYTYPE", IsNullable = true)]
|
public string? FSupplyType { get; set; }
|
|
/// <summary>
|
/// 供应组织
|
/// </summary>
|
[SugarColumn(ColumnName = "FSUPPLYORG", IsNullable = true)]
|
public string? FSupplyOrg { get; set; }
|
|
/// <summary>
|
/// 供应商
|
/// </summary>
|
[SugarColumn(ColumnName = "FSUPPLIER", IsNullable = true)]
|
public string? FSupplier { get; set; }
|
|
/// <summary>
|
/// 出货方式
|
/// </summary>
|
[SugarColumn(ColumnName = "FSHIPPINGMETHOD", IsNullable = true)]
|
public string? FShippingMethod { get; set; }
|
|
/// <summary>
|
/// MRP/DRP需求
|
/// </summary>
|
[SugarColumn(ColumnName = "FMRPDR", IsNullable = true)]
|
public string? FMRPDR { get; set; }
|
|
/// <summary>
|
/// 需求分类
|
/// </summary>
|
[SugarColumn(ColumnName = "FDEMANDCATEGORY", IsNullable = true)]
|
public string? FDemandCategory { get; set; }
|
|
/// <summary>
|
/// 库存规划
|
/// </summary>
|
[SugarColumn(ColumnName = "FINVENTORYPLANNING", IsNullable = true)]
|
public string? FInventoryPlanning { get; set; }
|
|
/// <summary>
|
/// 行备注
|
/// </summary>
|
[SugarColumn(ColumnName = "FLINEREMARK", IsNullable = true)]
|
public string? FLineRemark { get; set; }
|
|
/// <summary>
|
/// 来源单据类别
|
/// </summary>
|
[SugarColumn(ColumnName = "FSOURCEDOCCATEGORY", IsNullable = true)]
|
public string? FSourceDocCategory { get; set; }
|
|
/// <summary>
|
/// 来源单号
|
/// </summary>
|
[SugarColumn(ColumnName = "FSOURCEDOCNO", IsNullable = true)]
|
public string? FSourceDocNo { get; set; }
|
|
/// <summary>
|
/// 来源单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "FSOURCEDOCLINENO", IsNullable = true)]
|
public decimal? FSourceDocLineNo { get; set; }
|
|
/// <summary>
|
/// 行号
|
/// </summary>
|
[SugarColumn(ColumnName = "FLINE_NO", IsNullable = true)]
|
public string? FLINE_NO { get; set; }
|
|
}
|
}
|
