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