using System;
using SqlSugar;
using System.Linq;
using System.ComponentModel;
using System.Collections.Generic;
using System.Security.Cryptography;
namespace Tiger.Model
{
///
/// 实体:库存历史
///
[Description("Primary:ID")]
[Serializable]
[SugarTable("V_WMS_ITEM_HIS")]
public class V_WMS_ITEM_HIS : iViewEntity, iTableHasAuth
{
#region 构造函数
///
/// 实体:库存历史
///
public V_WMS_ITEM_HIS() {}
#endregion
#region 公共属性
///
/// 创建时间
///
public string CREATE_TIME { get; set; }
///
/// 修改时间
///
public string UPDATE_TIME { get; set; }
///
/// 更新者
///
public string UPDATE_USER { get; set; }
///
/// 条码
///
public string SN { get; set; }
///
/// 物料编码
///
public string ITEM_CODE { get; set; }
///
/// 条码类型(规则编码)
///
public string SN_TYPE { get; set; }
///
/// 储存状态(0NotExists不存在|10Incoming送货中|20WaitTest待检验|30WaitIn待入库|40InStore在库|50OffShelf已下架|60Sended已发料|70Loaded已上料|80UseUp已耗尽|90Returned已退料|100Shipped已出货)
///
public int STATUS { get; set; }
///
/// 数量
///
public decimal QTY { get; set; }
///
/// 单位
///
public string UNIT { get; set; }
///
/// 生产日期
///
public DateTime PROD_DATE { get; set; } = DateTime.MinValue;
///
/// 首次入库日期
///
public DateTime FIRST_IN_DATE { get; set; } = DateTime.MinValue;
///
/// 业务单据编码
///
public string TRANS_CODE { get; set; }
///
/// 业务单据号码
///
public string TRANS_NO { get; set; }
///
/// 业务单据行号
///
public string TRANS_LINE { get; set; }
///
/// 来源单据编码
///
public string SOURCE_CODE { get; set; }
///
/// 来源单据号码
///
public string SOURCE_ORDER { get; set; }
///
/// 来源单据行号
///
public string SOURCE_LINE { get; set; }
///
/// 供应商代码
///
public string SUPP_CODE { get; set; }
///
/// 供应商批次号
///
public string SUPP_LOTNO { get; set; }
///
/// 批次号
///
public string LOTNO { get; set; }
///
/// 箱号
///
public string CARTON_NO { get; set; }
///
/// 栈板号
///
public string PALLET_NO { get; set; }
///
/// 仓库代码
///
public string WH_ID { get; set; }
///
/// 储区代码
///
public string REGION_ID { get; set; }
///
/// 货架/料车编码
///
public string SHELF_ID { get; set; }
///
/// 储位代码
///
public string LOCATION_ID { get; set; }
///
/// ERP库位代码
///
public string ERP_WH { get; set; }
///
/// 是否被单据锁定(Y/N)
///
public string IS_LOCKED { get; set; }
///
/// 备注
///
public string REMARK { get; set; }
///
/// 追溯信息
///
public string TRACE_INFO { get; set; }
///
/// 备注
///
public string AUTH_ORG { get; set; }
public string AUTH_PROD { 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
#region 虚拟属性
/*例子
[SugarColumn(IsIgnore = true)]
public string FieldName { get; set; }
*/
#endregion
#region 外键属性
/*例子
//一对一外键导航
[Navigate(NavigateType.OneToOne, nameof(ClassAId))]//一对一 ClassAId是WMS_ITEM_HIS类里面的外键ID字段
public ClassA ClassA { get; set; } //注意禁止手动赋值,只能是null
//一对多外键导航
[Navigate(NavigateType.OneToMany, nameof(ClassA.WMS_ITEM_HISId))]//ClassA表中的WMS_ITEM_HISId
public List ClassAList { get; set; }//注意禁止手动赋值,只能是null
//多对多外键导航
[Navigate(typeof(MappingClass), nameof(MappingClass.WMS_ITEM_HISId), nameof(MappingClass.ClassAId))]//注意顺序
public List ClassAList { get; set; } //注意禁止手动赋值,只能是null
*/
#endregion
#region 枚举变量
/*例子
public enum FieldNames
{
[Description("枚举描述0")]
Enum0,
[Description("枚举描述1")]
Enum1,
}
*/
#endregion
#region 公共方法
#endregion
}//endClass
}