Inventory.cs 7.99 KB
using System;
using System.ComponentModel.DataAnnotations.Schema;

namespace WebRepository
{
    /// <summary>
	/// 库存表
	/// </summary>
    [Table("inventory")]
    public partial class Inventory : SysEntity
    {
        public Inventory()
        {
        }
        /// <summary>
        /// 仓库类型
        /// </summary>
        [Column("warehouseType")]
        public string WarehouseType { get; set; }
        /// <summary>
	    /// 库位id
	    /// </summary>
        [Column("locationId")]
        public int? LocationId { get; set; }
        /// <summary>
	    /// 库位编号
	    /// </summary>
        [Column("locationCode")]
        public string LocationCode { get; set; }
        /// <summary>
	    /// 容器编码
	    /// </summary>
        [Column("containerCode")]
        public string ContainerCode { get; set; }
        /// <summary>
        /// 铜箔桁架任务步骤
        /// PP卷打包机任务步骤:0:无任务或正在任务中,1:单笔复核成功,2:托盘上全部符合成功,3:装箱机装箱正在装箱
        /// </summary>
        [Column("Tasksteps")]
        public int? TaskSteps { get; set; }
        /// <summary>
        /// 物料位置
        /// </summary>
        [Column("Position")]
        public int? Position { get; set; }
        /// <summary>
	    /// 上游系统单号
	    /// </summary>
        [Column("sourceCode")]
        public string SourceCode { get; set; }
        /// <summary>
	    /// 上游系统行号
	    /// </summary>
        [Column("sourceLine")]
        public string SourceLine { get; set; }
        /// <summary>
	    /// 物料Id
	    /// </summary>
        [Column("materialId")]
        public int? MaterialId { get; set; }
        /// <summary>
        /// 二维码
        /// </summary>
        [Column("qrCode")]
        public string QrCode { get; set; }
        /// <summary>
	    /// 物料编码
	    /// </summary>
        [Column("materialCode")]
        public string MaterialCode { get; set; }
        /// <summary>
	    /// 入库单id
	    /// </summary>
        [Column("receiptId")]
        public int? ReceiptId { get; set; }
        /// <summary>
	    /// 入库单编码
	    /// </summary>
        [Column("receiptCode")]
        public string ReceiptCode { get; set; }
        /// <summary>
	    /// 入库单明细id
	    /// </summary>
        [Column("receiptDetailId")]
        public int? ReceiptDetailId { get; set; }
        /// <summary>
	    /// 批次
	    /// </summary>
        [Column("batch")]
        public string Batch { get; set; }
        /// <summary>
        /// 原始批次
        /// </summary>
        [Column("oldBatch")]
        public string OldBatch { get; set; }
        /// <summary>
	    /// 批号
	    /// </summary>
        [Column("lot")]
        public string Lot { get; set; }
        /// <summary>
	    /// 项目号
	    /// </summary>
        [Column("project")]
        public string Project { get; set; }
        /// <summary>
	    /// 生产日期
	    /// </summary>
        [Column("manufactureDate")]
        public System.DateTime? ManufactureDate { get; set; }
        /// <summary>
	    /// 失效日期
	    /// </summary>
        [Column("expirationDate")]
        public System.DateTime? ExpirationDate { get; set; }
        /// <summary>
	    /// 库存状态
	    /// </summary>
        [Column("status")]
        public string Status { get; set; }
        /// <summary>
	    /// 任务状态
	    /// </summary>
        [Column("taskStatus")]
        public string TaskStatus { get; set; }
        /// <summary>
	    /// 容器状态
	    /// </summary>
        [Column("containerStatus")]
        public string ContainerStatus { get; set; }
        /// <summary>
	    /// 数量
	    /// </summary>
        [Column("qty")]
        public decimal? Qty { get; set; }
        /// <summary>
	    /// 
	    /// </summary>
        [Column("taskQty")]
        public decimal? TaskQty { get; set; }
        /// <summary>
	    /// 成本
	    /// </summary>
        [Column("costPrice")]
        public decimal? CostPrice { get; set; }
        /// <summary>
	    /// 标价
	    /// </summary>
        [Column("listPrice")]
        public decimal? ListPrice { get; set; }
        /// <summary>
	    /// 净价
	    /// </summary>
        [Column("netPrice")]
        public decimal? NetPrice { get; set; }
        /// <summary>
        /// 是否打包
        /// </summary>
        [Column("isPack")]
        public string IsPack { get; set; }
        /// <summary>
        /// 叠托数量
        /// </summary>
        [Column("Combo")]
        public string Combo { get; set; }
        /// <summary>
        /// 是否排板
        /// </summary>
        [Column("isFold")]
        public string IsFold { get; set; }
        /// <summary>
        /// 供应商
        /// </summary>
        [Column("supplier")]
        public string Supplier { get; set; }
        /// <summary>
        /// 厚度
        /// </summary>
        [Column("ResidualWeight")]
        public decimal? ResidualWeight { get; set; }
        /// <summary>
        /// 退料人
        /// </summary>
        [Column("Retreat")]
        public string Retreat { get; set; }
        /// <summary>
        /// 规格
        /// </summary>
        [Column("specification")]
        public string Specification { get; set; }
        /// <summary>
        /// 品名
        /// </summary>
        [Column("nameDescription")]
        public string NameDescription { get; set; }
        /// <summary>
        /// 单位
        /// </summary>
        [Column("unit")]
        public string Unit { get; set; }
        /// <summary>
        /// 尺寸
        /// </summary>
        [Column("size")]
        public string Size { get; set; }
        /// <summary>
        /// 张数
        /// </summary>
        [Column("NumberofSheets")]
        public decimal? NumberofSheets { get; set; }
        /// <summary>
        /// 组数
        /// </summary>
        [Column("Groupnum")]
        public decimal? Groupnum { get; set; }
        /// <summary>
        /// 错叠张数
        /// </summary>
        [Column("StackingNumber")]
        public decimal? StackingNumber { get; set; }
        /// <summary>
        /// 客户编号
        /// </summary>
        [Column("customer")]
        public string Customer { get; set; }
        /// <summary>
        /// 物料正反
        /// </summary>
        [Column("checkud")]
        public string Checkud { get; set; }
        /// <summary>
	    /// 备注
	    /// </summary>
        [Column("remark")]
        public string Remark { get; set; }
        /// <summary>
	    /// PP卷物料大小
	    /// </summary>
        [Column("Height")]
        public int? Height { get; set; }
        /// <summary>
        /// ERP仓库
        /// </summary>
        [Column("SpecialWarehouse")]
        public string SpecialWarehouse { get; set; }
        /// <summary>
        /// 物性卡控:Y不允许出库
        /// </summary>
        [Column("IsoutControl")]
        public string IsoutControl { get; set; }

        /// <summary>
        /// ERP库位
        /// </summary>
        [Column("ErpWareCell")]
        public string ErpWareCell { get; set; }
        
        /// <summary>
        /// 等级判定(A级,B级,E级)
        /// </summary>
        [Column("Grade")]
        public string Grade { get; set; }

        /// <summary>
        /// 处理意见(0:良品,1:不良品,2:特采)
        /// </summary>
        [Column("Result")]
        public string Result { get; set; }

        /// <summary>
        /// 入库仓
        /// </summary>
        [Column("WH")]
        public string WH { get; set; }

        /// <summary>
        /// 线边仓
        /// </summary>
        [Column("LWH")]
        public string LWH { get; set; }

        /// <summary>
        /// 线边仓储位
        /// </summary>
        [Column("LWHSL")]
        public string LWHSL { get; set; }

        /// <summary>
        /// 大批号
        /// </summary>
        [Column("BLot")]
        public string BLot { get; set; }
    }
}