namespace iWareSql.MyDbContext
{
    using System;
    using System.Collections.Generic;
    using System.ComponentModel.DataAnnotations;
    using System.ComponentModel.DataAnnotations.Schema;
    using System.Data.Entity.Spatial;

    public partial class v_wms_stock_quan_for_use
    {
        [Key]
        [Column(Order = 0)]
        public decimal AvailableQty { get; set; }

        [Key]
        [Column(Order = 1)]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public long Id { get; set; }

        [Key]
        [Column(Order = 2)]
        [StringLength(50)]
        public string MaterialCode { get; set; }

        [StringLength(50)]
        public string MaterialName { get; set; }

        [Key]
        [Column(Order = 3)]
        public decimal Quantity { get; set; }

        [Key]
        [Column(Order = 4)]
        public decimal LockedQty { get; set; }

        [StringLength(50)]
        public string ContainerCode { get; set; }

        [Key]
        [Column(Order = 5)]
        [StringLength(50)]
        public string StockStatusName { get; set; }

        [Key]
        [Column(Order = 6)]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public int StockStatus { get; set; }

        public int? QCStatus { get; set; }

        [StringLength(50)]
        public string QCStatusName { get; set; }

        [Key]
        [Column(Order = 7)]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public int LockStatus { get; set; }

        [StringLength(500)]
        public string LockReason { get; set; }

        [StringLength(500)]
        public string LockUser { get; set; }

        public DateTime? LockTime { get; set; }

        [StringLength(255)]
        public string OperReason { get; set; }

        [StringLength(50)]
        public string OperUser { get; set; }

        public DateTime? OperTime { get; set; }

        [StringLength(50)]
        public string RelationNo { get; set; }

        [StringLength(50)]
        public string POUnit { get; set; }

        [StringLength(50)]
        public string MaterialUnit { get; set; }

        [StringLength(50)]
        public string MaterialTypeCode { get; set; }

        [StringLength(50)]
        public string MaterialTypeName { get; set; }

        [StringLength(50)]
        public string SupplierCode { get; set; }

        [StringLength(50)]
        public string SupplierName { get; set; }

        [StringLength(255)]
        public string Batch { get; set; }

        [StringLength(50)]
        public string SupplierBatch { get; set; }

        [Key]
        [Column(Order = 8)]
        [StringLength(255)]
        public string SNCode { get; set; }

        [StringLength(255)]
        public string SourceSNCode { get; set; }

        [StringLength(255)]
        public string SN_1d { get; set; }

        [StringLength(255)]
        public string SN_2d { get; set; }

        [StringLength(50)]
        public string ErpCode { get; set; }

        [StringLength(50)]
        public string ErpOrderNo { get; set; }

        [StringLength(255)]
        public string ErpVoucher { get; set; }

        public DateTime? ActionTime { get; set; }

        [StringLength(255)]
        public string ActionRemark { get; set; }

        [StringLength(50)]
        public string ContainerName { get; set; }

        public bool? ContainerIsDisabled { get; set; }

        [Key]
        [Column(Order = 9)]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public long ContainerId { get; set; }

        [StringLength(50)]
        public string ContainerTypeCode { get; set; }

        [StringLength(50)]
        public string ContainerTypeName { get; set; }

        [StringLength(50)]
        public string PlaceCode { get; set; }

        [StringLength(50)]
        public string PlaceName { get; set; }

        public int? PlaceStatus { get; set; }

        public bool? IsVirtuallyArea { get; set; }

        [StringLength(50)]
        public string AreaCode { get; set; }

        [StringLength(50)]
        public string AreaName { get; set; }

        public int? AreaType { get; set; }

        [StringLength(50)]
        public string WarehouseCode { get; set; }

        [StringLength(50)]
        public string WarehouseName { get; set; }

        public DateTime? RecordInsertTime { get; set; }

        public DateTime? CreateTime { get; set; }

        public long? CreateUserId { get; set; }

        [StringLength(64)]
        public string CreateUserName { get; set; }

        public DateTime? UpdateTime { get; set; }

        public long? UpdateUserId { get; set; }

        [StringLength(64)]
        public string UpdateUserName { get; set; }

        [Key]
        [Column(Order = 10)]
        public bool IsDelete { get; set; }

        public bool? IsDisabledPlace { get; set; }

        public bool? IsVirtuallyPlace { get; set; }

        public bool? IsDisabledArea { get; set; }

        public int? PlaceType { get; set; }

        public int? MaxIndex { get; set; }

        [Key]
        [Column(Order = 11)]
        [StringLength(26)]
        public string DisabledReason { get; set; }

        [Key]
        [Column(Order = 12)]
        [StringLength(6)]
        public string UsableFlagStr { get; set; }

        [Key]
        [Column(Order = 13)]
        [DatabaseGenerated(DatabaseGeneratedOption.None)]
        public int UsableFlag { get; set; }
    }
}