using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using SqlSugar;
|
namespace MES.Service.Modes
|
{
|
/// <summary>
|
/// 调拨申请单明细表
|
///</summary>
|
[SugarTable("MES_INV_ITEM_DBSQ_ITEMS")]
|
public class MesInvItemDbsqItems
|
{
|
/// <summary>
|
/// SEQ_MOVE_DETAIL
|
///</summary>
|
|
[SugarColumn(ColumnName = "ID", IsPrimaryKey = true, OracleSequenceName = "SEQ_DBSQ_DETAIL")]
|
//[SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
/// <summary>
|
/// 主表id
|
///</summary>
|
[SugarColumn(ColumnName = "ITEM_MOVE_ID")]
|
public decimal? ItemMoveId { get; set; }
|
/// <summary>
|
/// 物料内码
|
///</summary>
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public decimal? ItemId { get; set; }
|
/// <summary>
|
/// 物料编码
|
///</summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string? ItemNo { get; set; }
|
/// <summary>
|
/// 申请数量
|
///</summary>
|
[SugarColumn(ColumnName = "SQ_NUM")]
|
public decimal? SqNum { get; set; }
|
/// <summary>
|
/// 调出数量
|
///</summary>
|
[SugarColumn(ColumnName = "DC_NUM")]
|
public decimal? DcNum { get; set; }
|
/// <summary>
|
/// 调入数量
|
///</summary>
|
[SugarColumn(ColumnName = "DR_NUM")]
|
public decimal? DrNum { get; set; }
|
/// <summary>
|
/// 当前库存数
|
///</summary>
|
[SugarColumn(ColumnName = "KC")]
|
public decimal? Kc { get; set; }
|
/// <summary>
|
/// 备注
|
///</summary>
|
[SugarColumn(ColumnName = "REMARK")]
|
public string? Remark { get; set; }
|
/// <summary>
|
/// 项次
|
///</summary>
|
[SugarColumn(ColumnName = "LINE_NO")]
|
public decimal? LineNo { get; set; }
|
/// <summary>
|
/// 调拨申请单号
|
///</summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string? BillNo { get; set; }
|
/// <summary>
|
/// 调出状态
|
///</summary>
|
[SugarColumn(ColumnName = "MOVE_OUT")]
|
public decimal? MoveOut { get; set; }
|
/// <summary>
|
/// 调入状态
|
///</summary>
|
[SugarColumn(ColumnName = "MOVE_IN")]
|
public decimal? MoveIn { 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>
|
/// 单位
|
///</summary>
|
[SugarColumn(ColumnName = "ITEM_UNIT")]
|
public decimal? ItemUnit { get; set; }
|
/// <summary>
|
/// 是否同步ERP
|
///</summary>
|
[SugarColumn(ColumnName = "IS_TB")]
|
public decimal? IsTb { get; set; }
|
/// <summary>
|
/// 调出组织
|
///</summary>
|
[SugarColumn(ColumnName = "DC_ORG")]
|
public string? DcOrg { get; set; }
|
/// <summary>
|
/// 调出仓库
|
///</summary>
|
[SugarColumn(ColumnName = "DC_DEPOT")]
|
public string? DcDepot { get; set; }
|
/// <summary>
|
/// 调入组织
|
///</summary>
|
[SugarColumn(ColumnName = "DR_ORG")]
|
public string? DrOrg { get; set; }
|
/// <summary>
|
/// 调入仓库
|
///</summary>
|
[SugarColumn(ColumnName = "DR_DEPOT")]
|
public string? DrDepot { get; set; }
|
/// <summary>
|
/// 调出货主
|
///</summary>
|
[SugarColumn(ColumnName = "DC_HZ")]
|
public string? DcHz { get; set; }
|
/// <summary>
|
/// 调入货主
|
///</summary>
|
[SugarColumn(ColumnName = "DR_HZ")]
|
public string? DrHz { get; set; }
|
/// <summary>
|
/// erpid
|
///</summary>
|
[SugarColumn(ColumnName = "ERPID")]
|
public string? Erpid { get; set; }
|
/// <summary>
|
/// erp头id
|
///</summary>
|
[SugarColumn(ColumnName = "EID")]
|
public string? Eid { get; set; }
|
}
|
}
|