using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 物料出库表
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_OUTS")]
|
public class MesInvItemOuts
|
{
|
/// <summary>
|
/// SEQ_INV_ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 出库单号
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_OUT_NO")]
|
public string? ItemOutNo { get; set; }
|
|
/// <summary>
|
/// 生产订单
|
/// </summary>
|
[SugarColumn(ColumnName = "TASK_NO")]
|
public string? TaskNo { get; set; }
|
|
/// <summary>
|
/// 工序号
|
/// </summary>
|
[SugarColumn(ColumnName = "PROC_NO")]
|
public string? ProcNo { get; set; }
|
|
/// <summary>
|
/// 状态|0-未审核1-审核
|
/// </summary>
|
[SugarColumn(ColumnName = "STATUS")]
|
public decimal? Status { 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>
|
/// 单据类型ID
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_TYPE_ID")]
|
public decimal? BillTypeId { get; set; }
|
|
/// <summary>
|
/// 事务类型
|
/// </summary>
|
[SugarColumn(ColumnName = "TRANSACTION_NO")]
|
public decimal? TransactionNo { get; set; }
|
|
/// <summary>
|
/// 备注信息
|
/// </summary>
|
[SugarColumn(ColumnName = "REMARK")]
|
public string? Remark { get; set; }
|
|
/// <summary>
|
/// 出库原因
|
/// </summary>
|
[SugarColumn(ColumnName = "REASON")]
|
public string? Reason { get; set; }
|
|
/// <summary>
|
/// 生产线编码
|
/// </summary>
|
[SugarColumn(ColumnName = "PRODUCE_LINE_NO")]
|
public string? ProduceLineNo { get; set; }
|
|
/// <summary>
|
/// 审核人
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_USER")]
|
public string? CheckUser { get; set; }
|
|
/// <summary>
|
/// 审核日期
|
/// </summary>
|
[SugarColumn(ColumnName = "CHECK_DATE")]
|
public DateTime? CheckDate { get; set; }
|
|
/// <summary>
|
/// 领料日期
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_DATE")]
|
public DateTime? OutDate { get; set; }
|
|
/// <summary>
|
/// 领料工段
|
/// </summary>
|
[SugarColumn(ColumnName = "MMLIST")]
|
public string? Mmlist { get; set; }
|
|
/// <summary>
|
/// 子库CODE
|
/// </summary>
|
[SugarColumn(ColumnName = "DEPOT_CODE")]
|
public string? DepotCode { 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 = "PROC_LINE_NO")]
|
public string? ProcLineNo { get; set; }
|
|
/// <summary>
|
/// 领料部门
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_PART")]
|
public string? OutPart { get; set; }
|
|
/// <summary>
|
/// 0 生产,1 委外
|
/// </summary>
|
[SugarColumn(ColumnName = "F_TYPE")]
|
public long? FType { get; set; }
|
|
/// <summary>
|
/// 录入提交
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_STATUS")]
|
public decimal? OutStatus { get; set; }
|
|
/// <summary>
|
/// 是否可见
|
/// </summary>
|
[SugarColumn(ColumnName = "IS_VISUAL")]
|
public decimal? IsVisual { get; set; }
|
|
/// <summary>
|
/// 接收人
|
/// </summary>
|
[SugarColumn(ColumnName = "RECEIVER")]
|
public string? Receiver { get; set; }
|
|
/// <summary>
|
/// 工厂编号
|
/// </summary>
|
[SugarColumn(ColumnName = "FACTORY")]
|
public string? Factory { get; set; }
|
|
/// <summary>
|
/// 公司编号
|
/// </summary>
|
[SugarColumn(ColumnName = "COMPANY")]
|
public string? Company { get; set; }
|
|
/// <summary>
|
/// 冲销事务类型编码
|
/// </summary>
|
[SugarColumn(ColumnName = "MTRANSCTION_NO")]
|
public decimal? MtransctionNo { get; set; }
|
|
/// <summary>
|
/// 任务单号
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_NO")]
|
public string? WorkNo { get; set; }
|
|
/// <summary>
|
/// 任务单号行号
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_LINE")]
|
public decimal? WorkLine { get; set; }
|
|
/// <summary>
|
/// 供应商编号
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPP_NO")]
|
public string? SuppNo { get; set; }
|
|
/// <summary>
|
/// 订单号
|
/// </summary>
|
[SugarColumn(ColumnName = "CMPOCODE")]
|
public string? Cmpocode { get; set; }
|
|
/// <summary>
|
/// 原物料出货标识
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_FLAG")]
|
public decimal? ItemFlag { get; set; }
|
|
/// <summary>
|
/// 1=半成品出货
|
/// </summary>
|
[SugarColumn(ColumnName = "BOARD_FLAG")]
|
public decimal? BoardFlag { get; set; }
|
|
/// <summary>
|
/// 出库类别
|
/// </summary>
|
[SugarColumn(ColumnName = "OUT_TYPE")]
|
public string? OutType { get; set; }
|
|
/// <summary>
|
/// 业务类型
|
/// </summary>
|
[SugarColumn(ColumnName = "BUSINESS_TYPE")]
|
public string? BusinessType { get; set; }
|
|
/// <summary>
|
/// 产品编号
|
/// </summary>
|
[SugarColumn(ColumnName = "BOARD_ITEM")]
|
public string? BoardItem { get; set; }
|
|
/// <summary>
|
/// 产量
|
/// </summary>
|
[SugarColumn(ColumnName = "PLAN_QTY")]
|
public decimal? PlanQty { get; set; }
|
|
/// <summary>
|
/// 领料编号/委外订单
|
/// </summary>
|
[SugarColumn(ColumnName = "PBILL_NO")]
|
public string? PbillNo { get; set; }
|
|
/// <summary>
|
/// 补料申请单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BBILL_NO")]
|
public string? BbillNo { get; set; }
|
|
/// <summary>
|
/// 标识 /1已推送
|
/// </summary>
|
[SugarColumn(ColumnName = "NFLAG")]
|
public short? Nflag { get; set; }
|
|
/// <summary>
|
/// 退料方式
|
/// </summary>
|
[SugarColumn(ColumnName = "FMRMODE")]
|
public string? Fmrmode { get; set; }
|
|
/// <summary>
|
/// erp返回信息
|
/// </summary>
|
[SugarColumn(ColumnName = "MSG")]
|
public string? Msg { get; set; }
|
|
/// <summary>
|
/// 状态
|
/// </summary>
|
[SugarColumn(ColumnName = "STATES")]
|
public string? States { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? CreateByFname { get; set; }
|
|
[SugarColumn(IsIgnore = true)] public string? CheckUserFname { get; set; }
|
}
|
