using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售订单明细表
|
/// </summary>
|
[SugarTable("SALES_ORDER_DETAIL")]
|
public class SalesOrderDetail
|
{
|
/// <summary>
|
/// SEQ_sales序列
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_sales",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// ERPID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public decimal? ErpID { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </summary>
|
[SugarColumn(ColumnName = "E_HID")]
|
public decimal? EHID { get; set; }
|
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MATERIAL_ID")]
|
public string? MaterialId { get; set; }
|
|
/// <summary>
|
/// 销售单位
|
/// </summary>
|
[SugarColumn(ColumnName = "UNIT_ID")]
|
public string? UnitId { get; set; }
|
|
/// <summary>
|
/// 销售数量
|
/// </summary>
|
[SugarColumn(ColumnName = "QTY")]
|
public decimal? Qty { get; set; }
|
|
/// <summary>
|
/// 计价单位
|
/// </summary>
|
[SugarColumn(ColumnName = "PRICE_UNIT_ID")]
|
public string? PriceUnitId { get; set; }
|
|
/// <summary>
|
/// 计价数量
|
/// </summary>
|
[SugarColumn(ColumnName = "PRICE_UNIT_QTY")]
|
public decimal? PriceUnitQty { get; set; }
|
|
/// <summary>
|
/// 要货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_DATE")]
|
public DateTime? DeliveryDate { get; set; }
|
|
/// <summary>
|
/// 是否赠品
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_FREE")]
|
public string? IsFree { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "UNW_TEXT_XSDDH")]
|
public string? SalesOrderNo { get; set; }
|
|
/// <summary>
|
/// 跟单员
|
/// </summary>
|
[SugarColumn(ColumnName = "UNW_BASE_GDY")]
|
public string? SalesFollowUp { get; set; }
|
|
/// <summary>
|
/// 货主类型
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER_TYPE_ID")]
|
public string? OwnerTypeId { get; set; }
|
|
/// <summary>
|
/// 货主
|
/// </summary>
|
[SugarColumn(ColumnName = "OWNER_ID")]
|
public string? OwnerId { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "ENTRY_NOTE")]
|
public string? EntryNote { get; set; }
|
|
/// <summary>
|
/// 计划跟踪号
|
/// </summary>
|
[SugarColumn(ColumnName = "MTO_NO")]
|
public string? MtoNo { get; set; }
|
|
/// <summary>
|
/// 批号
|
/// </summary>
|
[SugarColumn(ColumnName = "LOT")]
|
public string? Lot { get; set; }
|
|
/// <summary>
|
/// 发货上限
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_MAX_QTY")]
|
public decimal? DeliveryMaxQty { get; set; }
|
|
/// <summary>
|
/// 发货下限
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_MIN_QTY")]
|
public decimal? DeliveryMinQty { get; set; }
|
|
/// <summary>
|
/// 超发控制单位
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_LMT_UNIT_ID")]
|
public string? OutLmtUnitId { get; set; }
|
|
/// <summary>
|
/// 业务关闭
|
/// </summary>
|
[SugarColumn(ColumnName = "MRP_CLOSE_STATUS")]
|
public string? MrpCloseStatus { get; set; }
|
|
/// <summary>
|
/// 业务终止
|
/// </summary>
|
[SugarColumn(ColumnName = "MRP_TERMINATE_STATUS")]
|
public string? MrpTerminateStatus { get; set; }
|
|
/// <summary>
|
/// 终止日期
|
/// </summary>
|
[SugarColumn(ColumnName = "TERMINATE_DATE")]
|
public DateTime? TerminateDate { get; set; }
|
|
/// <summary>
|
/// 终止人
|
/// </summary>
|
[SugarColumn(ColumnName = "TERMINATER_ID")]
|
public string? TerminaterId { get; set; }
|
|
/// <summary>
|
/// 源单类型
|
/// </summary>
|
[SugarColumn(ColumnName = "SRC_TYPE")]
|
public string? SrcType { get; set; }
|
|
/// <summary>
|
/// 源单单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SRC_BILL_NO")]
|
public string? SrcBillNo { get; set; }
|
|
/// <summary>
|
/// 累计发货通知数量
|
/// </summary>
|
[SugarColumn(ColumnName = "DELI_QTY")]
|
public decimal? DeliQty { get; set; }
|
|
/// <summary>
|
/// 累计出库数量
|
/// </summary>
|
[SugarColumn(ColumnName = "STOCK_OUT_QTY")]
|
public decimal? StockOutQty { get; set; }
|
|
/// <summary>
|
/// 累计退货通知数量（销售基本）
|
[SugarColumn(ColumnName = "BASE_RET_NOTICE_QTY")]
|
public decimal? BaseRetNoticeQty { get; set; } /// </summary>
|
|
/// <summary>
|
/// 累计退货数量（销售基本）
|
/// </summary>
|
[SugarColumn(ColumnName = "BASE_RETURN_QTY")]
|
public decimal? BaseReturnQty { get; set; }
|
|
/// <summary>
|
/// 剩余未出数量（销售基本）
|
/// </summary>
|
[SugarColumn(ColumnName = "BASE_REMAIN_OUT_QTY")]
|
public decimal? BaseRemainOutQty { get; set; }
|
|
/// <summary>
|
/// 累计应收数量（销售基本）
|
/// </summary>
|
[SugarColumn(ColumnName = "BASEARQTY")]
|
public decimal? BASEARQTY { get; set; }
|
|
/// <summary>
|
/// 销售订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_ORDER")]
|
public string? SalesOrder { get; set; }
|
|
/// <summary>
|
/// 客户订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "CUST_ORDER")]
|
public string? CustOrder { get; set; }
|
|
/// <summary>
|
/// 销售合同编号
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_CONTRACT_NO")]
|
public string? SalesContractNo { get; set; }
|
|
/// <summary>
|
/// 成品料号
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 成品名称
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_NAME")]
|
public string? ItemName { get; set; }
|
|
/// <summary>
|
/// 客户
|
/// </summary>
|
[SugarColumn(ColumnName = "CUST_ID")]
|
public string? CustId { get; set; }
|
|
/// <summary>
|
/// 采购到货日期
|
/// </summary>
|
[SugarColumn(ColumnName = "ARRIVAL_DATE")]
|
|
public DateTime? ArrivalDate { get; set; }
|
|
/// <summary>
|
/// 客户物料规格型号
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_MODEL")]
|
public string? ItemModel { get; set; }
|
|
/// <summary>
|
/// 订单来源
|
/// </summary>
|
[SugarColumn(ColumnName = "DDLY")]
|
public string? Ddly { get; set; }
|
|
|
}
|
