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")]
	public class V_WMS_ITEM : iViewEntity,iTableHasAuth
	{
		#region 构造函数
		/// <summary>
		/// 实体：库存信息
		/// </summary>
		public V_WMS_ITEM() {}
        #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待检验|30WaitIn待入库|40InStore在库|50OffShelf已下架|60Sended已发料|70Loaded已上料|80UseUp已耗尽|90Returned已退料|100Shipped已出货)
        /// </summary>
        public int STATUS { get; set; }
		/// <summary>
		/// 数量
		/// </summary>
		public decimal 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>
        /// 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
}