using System;
|
using SqlSugar;
|
using System.Linq;
|
using System.ComponentModel;
|
using System.Collections.Generic;
|
using Tiger.Model.Minsun;
|
using Tiger.Model.Extensions;
|
using Microsoft.SqlServer.Server;
|
|
namespace Tiger.Model
|
{
|
/// <summary>
|
/// 实体：库存信息
|
/// </summary>
|
[Description("Primary:ID")]
|
[Serializable]
|
[SugarTable("V_WMS_ITEM_D")]
|
public class V_WMS_ITEM_D : iViewEntity,iTableHasAuth
|
{
|
#region 构造函数
|
/// <summary>
|
/// 实体：库存信息
|
/// </summary>
|
public V_WMS_ITEM_D() {}
|
#endregion
|
|
#region 公共属性
|
/// <summary>
|
/// ID
|
/// </summary>
|
public string ID { get; set; }
|
/// <summary>
|
/// 条码
|
/// </summary>
|
public string SN { get; set; }
|
/// <summary>
|
/// 物料编码
|
/// </summary>
|
public string ITEM_CODE { get; set; }
|
/// <summary>
|
/// 物料描述
|
/// </summary>
|
public string ITEM_NAME { get; set; }
|
/// <summary>
|
/// 条码类型(规则编码)
|
/// </summary>
|
public string SN_TYPE { get; set; }
|
/// <summary>
|
/// 储存状态(0NotExists不存在|10Incoming送货中|20WaitTest待检验|21Rejected需退货|30WaitIn待入库|40InStore在库|50OffShelf已下架|60Sended已发料|70Loaded已上料|80UseUp已耗尽|90Returned已退料|100Shipped已出货)
|
/// </summary>
|
public int STATUS { get; set; }
|
/// <summary>
|
/// 数量
|
/// </summary>
|
public double QTY { get; set; }
|
/// <summary>
|
/// 单位
|
/// </summary>
|
public string UNIT { get; set; }
|
/// <summary>
|
/// 生产日期
|
/// </summary>
|
public DateTime PROD_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 首次入库日期
|
/// </summary>
|
public DateTime FIRST_IN_DATE { get; set; } = DateTime.MinValue;
|
/// <summary>
|
/// 业务单据编码
|
/// </summary>
|
public string TRANS_CODE { get; set; }
|
/// <summary>
|
/// 业务单据号码
|
/// </summary>
|
public string TRANS_NO { get; set; }
|
/// <summary>
|
/// 业务单据行号
|
/// </summary>
|
public string TRANS_LINE { get; set; }
|
/// <summary>
|
/// 来源单据编码
|
/// </summary>
|
public string SOURCE_CODE { get; set; }
|
/// <summary>
|
/// 来源单据号码
|
/// </summary>
|
public string SOURCE_ORDER { get; set; }
|
/// <summary>
|
/// 来源单据行号
|
/// </summary>
|
public string SOURCE_LINE { get; set; }
|
/// <summary>
|
/// 供应商代码
|
/// </summary>
|
public string SUPP_CODE { get; set; }
|
/// <summary>
|
/// 供应商批次号
|
/// </summary>
|
public string SUPP_LOTNO { get; set; }
|
/// <summary>
|
/// 批次号
|
/// </summary>
|
public string LOTNO { get; set; }
|
/// <summary>
|
/// 箱号
|
/// </summary>
|
public string CARTON_NO { get; set; }
|
/// <summary>
|
/// 栈板号
|
/// </summary>
|
public string PALLET_NO { get; set; }
|
/// <summary>
|
/// 仓库代码
|
/// </summary>
|
public string WH_ID { get; set; }
|
/// <summary>
|
/// 储区代码
|
/// </summary>
|
public string REGION_ID { get; set; }
|
/// <summary>
|
/// 货架/料车编码
|
/// </summary>
|
public string SHELF_ID { get; set; }
|
/// <summary>
|
/// 储位代码
|
/// </summary>
|
public string LOCATION_ID { get; set; }
|
/// <summary>
|
/// ERP库位代码
|
/// </summary>
|
public string ERP_WH { get; set; }
|
/// <summary>
|
/// 是否被单据锁定(Y/N)
|
/// </summary>
|
public string IS_LOCKED { get; set; }
|
/// <summary>
|
/// 货架类型
|
/// </summary>
|
public int SHELF_TYPE { get; set; }
|
/// <summary>
|
/// 延期天数
|
/// </summary>
|
public int PostponeDays { get; set; }
|
/// <summary>
|
/// LEDID
|
/// </summary>
|
public int LEDID { get; set; }
|
/// <summary>
|
/// 备注
|
/// </summary>
|
public string REMARK { get; set; }
|
public string AUTH_ORG { get; set; }
|
public string AUTH_PROD { get; set; }
|
public string UPDATE_TIME { get; set; }
|
public string AUTH_WH { get; set; }
|
public string WH_CODE { get; set; }
|
public string WH_NAME { get; set; }
|
public string REGION_CODE { get; set; }
|
public string SHELF_CODE { get; set; }
|
public string LOCATION_CODE { get; set; }
|
#endregion
|
|
}//endClass
|
}
|
