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; }
|
}
|
}
|
