using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using SqlSugar;
|
namespace MES.Service.Modes
|
{
|
/// <summary>
|
/// 调拨申请单
|
///</summary>
|
[SugarTable("MES_INV_ITEM_DBSQ")]
|
public class MesInvItemDbsq
|
{
|
/// <summary>
|
/// SEQ_INV_ID
|
///</summary>
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_DBSQ")]
|
//[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
/// <summary>
|
/// 调拨申请单号
|
///</summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string? BillNo { get; set; }
|
/// <summary>
|
/// 移入子库id
|
///</summary>
|
[SugarColumn(ColumnName = "INV_DEPOTS_ID")]
|
public decimal? InvDepotsId { get; set; }
|
/// <summary>
|
/// 移入货位id
|
///</summary>
|
[SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
|
public decimal? InvDepotSectionsId { get; set; }
|
/// <summary>
|
/// 创建人
|
///</summary>
|
[SugarColumn(ColumnName = "CREATE_BY")]
|
public string? CreateBy { get; set; }
|
/// <summary>
|
/// 创建时间
|
///</summary>
|
[SugarColumn(ColumnName = "CREATE_DATE")]
|
public DateTime? CreateDate { get; set; }
|
/// <summary>
|
/// 最后更新人
|
///</summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
|
public string? LastupdateBy { get; set; }
|
/// <summary>
|
/// 最后更新时间
|
///</summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_DATE")]
|
public DateTime? LastupdateDate { get; set; }
|
/// <summary>
|
/// 状态|0-制单1-审核2-过账
|
///</summary>
|
[SugarColumn(ColumnName = "STATUS")]
|
public decimal? Status { get; set; }
|
/// <summary>
|
/// 备注
|
///</summary>
|
[SugarColumn(ColumnName = "REMARK")]
|
public string? Remark { get; set; }
|
/// <summary>
|
/// 单据类型ID
|
///</summary>
|
[SugarColumn(ColumnName = "BILL_TYPE_ID")]
|
public decimal? BillTypeId { get; set; }
|
/// <summary>
|
/// 事务类型ID
|
///</summary>
|
[SugarColumn(ColumnName = "TRANSACTION_ID")]
|
public decimal? TransactionId { get; set; }
|
/// <summary>
|
/// 审核人
|
///</summary>
|
[SugarColumn(ColumnName = "CHECKUSER")]
|
public string? Checkuser { get; set; }
|
/// <summary>
|
/// 审核日期
|
///</summary>
|
[SugarColumn(ColumnName = "CHECKDATE")]
|
public DateTime? Checkdate { get; set; }
|
/// <summary>
|
/// 移入子库code
|
///</summary>
|
[SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
|
public string? InvDepotsCode { get; set; }
|
/// <summary>
|
/// 移入货位code
|
///</summary>
|
[SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
|
public string? InvDepotSectionsCode { get; set; }
|
/// <summary>
|
/// 事务类型编码
|
///</summary>
|
[SugarColumn(ColumnName = "TRANSACTION_NO")]
|
public decimal? TransactionNo { get; set; }
|
/// <summary>
|
/// 移出子库code
|
///</summary>
|
[SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
|
public string? FromDepotsCode { get; set; }
|
/// <summary>
|
/// 工厂编码
|
///</summary>
|
[SugarColumn(ColumnName = "FACTORY_CODE")]
|
public string? FactoryCode { get; set; }
|
/// <summary>
|
/// SAP返回单据
|
///</summary>
|
[SugarColumn(ColumnName = "SAPNO")]
|
public string? Sapno { get; set; }
|
/// <summary>
|
/// 已回写SAP
|
///</summary>
|
[SugarColumn(ColumnName = "SAPSTATUS")]
|
public short? Sapstatus { get; set; }
|
/// <summary>
|
/// SAP返回年份
|
///</summary>
|
[SugarColumn(ColumnName = "SAPYEAR")]
|
public short? Sapyear { get; set; }
|
/// <summary>
|
/// SAP返回信息
|
///</summary>
|
[SugarColumn(ColumnName = "SAPTEXT")]
|
public string? Saptext { get; set; }
|
/// <summary>
|
/// 分厂编码
|
///</summary>
|
[SugarColumn(ColumnName = "FACTORY")]
|
public string? Factory { get; set; }
|
/// <summary>
|
/// 公司代码
|
///</summary>
|
[SugarColumn(ColumnName = "COMPANY")]
|
public string? Company { get; set; }
|
/// <summary>
|
/// 是否推送ERP1-是，2-否
|
///</summary>
|
[SugarColumn(ColumnName = "TS")]
|
public decimal? Ts { get; set; }
|
/// <summary>
|
/// 0未调拨1已调拨
|
///</summary>
|
[SugarColumn(ColumnName = "DB_STATUS")]
|
public string? DbStatus { get; set; }
|
/// <summary>
|
/// 调出组织
|
///</summary>
|
[SugarColumn(ColumnName = "FSTOCKOUTORGID")]
|
public decimal? Fstockoutorgid { get; set; }
|
/// <summary>
|
/// 调入组织
|
///</summary>
|
[SugarColumn(ColumnName = "FSTOCKORGID")]
|
public decimal? Fstockorgid { get; set; }
|
/// <summary>
|
/// 单据类型
|
///</summary>
|
[SugarColumn(ColumnName = "DJ_LX")]
|
public string? Djlx { get; set; }
|
/// <summary>
|
/// 调拨类型
|
///</summary>
|
[SugarColumn(ColumnName = "DB_LX1")]
|
public string? DbLx1 { get; set; }
|
/// <summary>
|
/// 调拨方向
|
///</summary>
|
[SugarColumn(ColumnName = "DB_FX")]
|
public string? DbFx { get; set; }
|
/// <summary>
|
/// 调拨类型
|
///</summary>
|
[SugarColumn(ColumnName = "DB_LX")]
|
public string? DbLx { get; set; }
|
/// <summary>
|
/// 业务类型
|
///</summary>
|
[SugarColumn(ColumnName = "YW_LX")]
|
public string? YwLx { get; set; }
|
/// <summary>
|
/// 单据状态
|
///</summary>
|
[SugarColumn(ColumnName = "DJ_ZT")]
|
public string? DjZt { get; set; }
|
/// <summary>
|
/// 申请部门
|
///</summary>
|
[SugarColumn(ColumnName = "SQ_BM")]
|
public string? SqBm { get; set; }
|
/// <summary>
|
/// 申请组织
|
///</summary>
|
[SugarColumn(ColumnName = "SQ_ZZ")]
|
public string? SqZz { get; set; }
|
/// <summary>
|
/// 申请日期
|
///</summary>
|
[SugarColumn(ColumnName = "SQ_TIME")]
|
public string? SqTime { get; set; }
|
/// <summary>
|
/// 调出货主类型
|
///</summary>
|
[SugarColumn(ColumnName = "DC_HZ")]
|
public string? DcHz { get; set; }
|
/// <summary>
|
///
|
///</summary>
|
[SugarColumn(ColumnName = "ERPID")]
|
public string? Erpid { get; set; }
|
}
|
}
|
