using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 销售发货通知单
|
/// </summary>
|
[SugarTable("SALES_DELIVERY_NOTICE")]
|
public class SalesDeliveryNotice
|
{
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "ID",
|
OracleSequenceName = "SALES_DELIVERY_NOTICE_ID", IsPrimaryKey = true)]
|
public decimal? Id { get; set; }
|
|
/// <summary>
|
/// 单据类型
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_TYPE")]
|
public string BillType { get; set; }
|
|
/// <summary>
|
/// 单据编号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string BillNo { get; set; }
|
|
/// <summary>
|
/// 日期
|
/// </summary>
|
[SugarColumn(ColumnName = "F_DATE")]
|
public DateTime? FDate { get; set; }
|
|
/// <summary>
|
/// 结算币别
|
/// </summary>
|
[SugarColumn(ColumnName = "CURRENCY")]
|
public string? Currency { get; set; }
|
|
/// <summary>
|
/// 销售组织
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_ORG")]
|
public string? SalesOrg { get; set; }
|
|
/// <summary>
|
/// 销售部门
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_DEPT")]
|
public string? SalesDept { get; set; }
|
|
/// <summary>
|
/// 客户订单
|
/// </summary>
|
[SugarColumn(ColumnName = "CUSTOMER_ORDER_NO")]
|
public string? CustomerOrderNo { get; set; }
|
|
/// <summary>
|
/// 客户
|
/// </summary>
|
[SugarColumn(ColumnName = "CUSTOMER")]
|
public string? Customer { get; set; }
|
|
/// <summary>
|
/// 交货方式
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_METHOD")]
|
public string? DeliveryMethod { get; set; }
|
|
/// <summary>
|
/// 交货地点
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_LOCATION")]
|
public string? DeliveryLocation { get; set; }
|
|
/// <summary>
|
/// 承运商
|
/// </summary>
|
[SugarColumn(ColumnName = "CARRIER")]
|
public string? Carrier { get; set; }
|
|
/// <summary>
|
/// 运输单号
|
/// </summary>
|
[SugarColumn(ColumnName = "TRANSPORT_NO")]
|
public string? TransportNo { get; set; }
|
|
/// <summary>
|
/// 单据状态
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO_TYPE")]
|
public string? BillNoType { get; set; }
|
|
/// <summary>
|
/// 发货组织
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_ORG")]
|
public string? DeliveryOrg { get; set; }
|
|
/// <summary>
|
/// 发货部门
|
/// </summary>
|
[SugarColumn(ColumnName = "DELIVERY_DEPT")]
|
public string? DeliveryDept { get; set; }
|
|
/// <summary>
|
/// 库存组
|
/// </summary>
|
[SugarColumn(ColumnName = "INVENTORY_GROUP")]
|
public string? InventoryGroup { get; set; }
|
|
/// <summary>
|
/// 仓管员
|
/// </summary>
|
[SugarColumn(ColumnName = "WAREHOUSE_MANAGER")]
|
public string? WarehouseManager { get; set; }
|
|
/// <summary>
|
/// 销售组
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_GROUP")]
|
public string? SalesGroup { get; set; }
|
|
/// <summary>
|
/// 销售员
|
/// </summary>
|
[SugarColumn(ColumnName = "SALES_PERSON")]
|
public string? SalesPerson { get; set; }
|
|
/// <summary>
|
/// 收货方
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVER")]
|
public string? Receiver { get; set; }
|
|
/// <summary>
|
/// 收货方联系人
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVER_CONTACT")]
|
public string? ReceiverContact { get; set; }
|
|
/// <summary>
|
/// 收货方地址
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVER_ADDRESS")]
|
public string? ReceiverAddress { get; set; }
|
|
/// <summary>
|
/// 收货方姓名
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVER_NAME")]
|
public string? ReceiverName { get; set; }
|
|
/// <summary>
|
/// 联系电话
|
/// </summary>
|
[SugarColumn(ColumnName = "LINK_PHONE")]
|
public string? LinkPhone { get; set; }
|
|
/// <summary>
|
/// 结算方
|
/// </summary>
|
[SugarColumn(ColumnName = "SETTLE_PARTY")]
|
public string? SettleParty { get; set; }
|
|
/// <summary>
|
/// 付款方
|
/// </summary>
|
[SugarColumn(ColumnName = "PAYER_PARTY")]
|
public string? PayerParty { get; set; }
|
|
/// <summary>
|
/// 创建人
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATED_BY")]
|
public string? CreatedBy { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
/// </summary>
|
[SugarColumn(ColumnName = "CREATED_DATE")]
|
public DateTime? CreatedDate { get; set; }
|
|
/// <summary>
|
/// 修改人
|
/// </summary>
|
[SugarColumn(ColumnName = "MODIFIED_BY")]
|
public string? ModifiedBy { get; set; }
|
|
/// <summary>
|
/// 修改时间
|
/// </summary>
|
[SugarColumn(ColumnName = "MODIFIED_DATE")]
|
public DateTime? ModifiedDate { get; set; }
|
|
/// <summary>
|
/// 关闭人
|
/// </summary>
|
[SugarColumn(ColumnName = "CLOSED_BY")]
|
public string? ClosedBy { get; set; }
|
|
/// <summary>
|
/// 关闭原因
|
/// </summary>
|
[SugarColumn(ColumnName = "CLOSE_REASON")]
|
public string? CloseReason { get; set; }
|
|
/// <summary>
|
/// 关闭日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CLOSE_DATE")]
|
public DateTime? CloseDate { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "APPROVED_BY")]
|
public string? ApprovedBy { get; set; }
|
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
[SugarColumn(ColumnName = "APPROVED_DATE")]
|
public DateTime? ApprovedDate { get; set; }
|
|
/// <summary>
|
/// 作废状态
|
/// </summary>
|
[SugarColumn(ColumnName = "CANCEL_STATUS")]
|
public string? CancelStatus { get; set; }
|
|
/// <summary>
|
/// 作废人
|
/// </summary>
|
[SugarColumn(ColumnName = "CANCELLED_BY")]
|
public string? CancelledBy { get; set; }
|
|
/// <summary>
|
/// 作废日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CANCEL_DATE")]
|
public DateTime? CancelDate { get; set; }
|
|
/// <summary>
|
/// 关闭状态
|
/// </summary>
|
[SugarColumn(ColumnName = "CLOSE_STATUS")]
|
public string? CloseStatus { get; set; }
|
|
/// <summary>
|
/// 是否手动关闭
|
/// </summary>
|
[SugarColumn(ColumnName = "MANUAL_CLOSE_FLAG")]
|
public string? ManualCloseFlag { get; set; }
|
|
/// <summary>
|
/// ERP头ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ERP_ID")]
|
public string? ErpId { get; set; }
|
|
/// <summary>
|
/// 单据状态
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_STATUS")]
|
public string? BillStatus { get; set; }
|
|
//-----------------新增字段---------------------------------
|
/// <summary>
|
/// 来源类别
|
/// </summary>
|
[SugarColumn(ColumnName = "FSourceCategory", IsNullable = false)]
|
public string FSourceCategory { get; set; }
|
|
/// <summary>
|
/// 来源单据
|
/// </summary>
|
[SugarColumn(ColumnName = "FSourceDocument", IsNullable = false)]
|
public string FSourceDocument { get; set; }
|
|
/// <summary>
|
/// 交期
|
/// </summary>
|
[SugarColumn(ColumnName = "FDeliveryDate", IsNullable = true)]
|
public string? FDeliveryDate { get; set; }
|
|
/// <summary>
|
/// 项目
|
/// </summary>
|
[SugarColumn(ColumnName = "FProject", IsNullable = false)]
|
public string FProject { get; set; }
|
|
/// <summary>
|
/// 客户采购订单
|
/// </summary>
|
[SugarColumn(ColumnName = "FCustomerPo", IsNullable = false)]
|
public string FCustomerPo { get; set; }
|
|
/// <summary>
|
/// 出货原则
|
/// </summary>
|
[SugarColumn(ColumnName = "FShippingPolicy", IsNullable = false)]
|
public string FShippingPolicy { get; set; }
|
|
/// <summary>
|
/// 装运港
|
/// </summary>
|
[SugarColumn(ColumnName = "FShippingPort", IsNullable = false)]
|
public string FShippingPort { get; set; }
|
|
/// <summary>
|
/// 目的港
|
/// </summary>
|
[SugarColumn(ColumnName = "FDestinationPort", IsNullable = false)]
|
public string FDestinationPort { get; set; }
|
|
/// <summary>
|
/// 收货联系人
|
/// </summary>
|
[SugarColumn(ColumnName = "FReceiverContactID", IsNullable = true)]
|
public string? FReceiverContactID { get; set; }
|
|
/// <summary>
|
/// 表头备注
|
/// </summary>
|
[SugarColumn(ColumnName = "FEntryNote", IsNullable = true)]
|
public string? FEntryNote { get; set; }
|
|
/// <summary>
|
/// 版本号
|
/// </summary>
|
[SugarColumn(ColumnName = "FVersionNo", IsNullable = true)]
|
public string? FVersionNo { get; set; }
|
|
/// <summary>
|
/// 需求分类
|
/// </summary>
|
[SugarColumn(ColumnName = "FBusinessType", IsNullable = true)]
|
public string? FBusinessType { get; set; }
|
|
/// <summary>
|
/// 交货地点
|
/// </summary>
|
[SugarColumn(ColumnName = "FHEADLOCID", IsNullable = true)]
|
public string? FHEADLOCID { get; set; }
|
|
/// <summary>
|
/// 客户
|
/// </summary>
|
[SugarColumn(ColumnName = "FCustId", IsNullable = true)]
|
public string? FCustId { get; set; }
|
|
/// <summary>
|
/// 备注
|
/// </summary>
|
[SugarColumn(ColumnName = "FNote", IsNullable = true)]
|
public string? FNote { get; set; }
|
}
|