using Estsh.Core.Base;
using System.ComponentModel;
using System.ComponentModel.DataAnnotations.Schema;

namespace Estsh.Core.Models
{
    /// <summary>
    /// ，数据实体对象
    /// </summary>
    [Table("sys_stock_snapshot")]
    [Serializable]
    public class SysStockSnapshot : BaseEntity
    {
        [Column("ruid")]
        [DisplayName(" ")]
        public int Ruid { get; set; }

        [Column("order_no")]
        [DisplayName(" ")]
        public string OrderNo { get; set; }

        [Column("weekly_order_no")]
        [DisplayName(" ")]
        public string WeeklyOrderNo { get; set; }

        [Column("type_id")]
        [DisplayName(" ")]
        public int TypeId { get; set; }

        [Column("buy_no")]
        [DisplayName(" ")]
        public string BuyNo { get; set; }

        [Column("buy_item")]
        [DisplayName(" ")]
        public int BuyItem { get; set; }

        [Column("gr_type")]
        [DisplayName(" ")]
        public string GrType { get; set; }

        [Column("buy_type")]
        [DisplayName(" ")]
        public string BuyType { get; set; }

        [Column("buy_version")]
        [DisplayName(" ")]
        public string BuyVersion { get; set; }

        [Column("vendor_id")]
        [DisplayName(" ")]
        public int VendorId { get; set; }

        [Column("se_date")]
        [DisplayName(" ")]
        public string SeDate { get; set; }

        [Column("se_time")]
        [DisplayName(" ")]
        public string SeTime { get; set; }

        [Column("part_id")]
        [DisplayName(" ")]
        public int PartId { get; set; }

        [Column("part_no")]
        [DisplayName(" ")]
        public string PartNo { get; set; }

        [Column("carton_no")]
        [DisplayName(" ")]
        public string CartonNo { get; set; }

        [Column("lot_no")]
        [DisplayName(" ")]
        public string LotNo { get; set; }

        [Column("qty")]
        [DisplayName(" ")]
        public decimal Qty { get; set; }

        [Column("snp_qty")]
        [DisplayName(" ")]
        public decimal SnpQty { get; set; }

        [Column("plan_qty")]
        [DisplayName(" ")]
        public decimal PlanQty { get; set; }

        [Column("trans_qty")]
        [DisplayName(" ")]
        public decimal TransQty { get; set; }

        [Column("status")]
        [DisplayName(" ")]
        public string Status { get; set; }

        [Column("iss_seq")]
        [DisplayName(" ")]
        public string IssSeq { get; set; }

        [Column("group_no")]
        [DisplayName(" ")]
        public string GroupNo { get; set; }

        [Column("locate_id")]
        [DisplayName(" ")]
        public int? LocateId { get; set; }

        [Column("erp_warehouse")]
        [DisplayName(" ")]
        public string ErpWarehouse { get; set; }

        [Column("date_code")]
        [DisplayName(" ")]
        public string DateCode { get; set; }

        [Column("type")]
        [DisplayName(" ")]
        public string Type { get; set; }

        [Column("factory_id")]
        [DisplayName(" ")]
        public int FactoryId { get; set; }

        [Column("prd_lot_no")]
        [DisplayName(" ")]
        public string PrdLotNo { get; set; }

        [Column("ship_no")]
        [DisplayName(" ")]
        public string ShipNo { get; set; }

        [Column("version_no")]
        [DisplayName(" ")]
        public string VersionNo { get; set; }

        [Column("pick_no")]
        [DisplayName(" ")]
        public string PickNo { get; set; }

        [Column("unit")]
        [DisplayName(" ")]
        public string Unit { get; set; }

        [Column("dock")]
        [DisplayName(" ")]
        public string Dock { get; set; }

        [Column("sta_order_no")]
        [DisplayName(" ")]
        public string StaOrderNo { get; set; }

        [Column("snap_ymd")]
        [DisplayName(" ")]
        public string SnapYmd { get; set; }

        [Column("snap_hms")]
        [DisplayName(" ")]
        public string SnapHms { get; set; }


    }
}