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 wms_stock_snapshot_details
|
{
|
[DatabaseGenerated(DatabaseGeneratedOption.None)]
|
public long Id { get; set; }
|
|
public long SnapshotId { get; set; }
|
|
[StringLength(50)]
|
public string SnapshotDate { get; set; }
|
|
public long? ContainerId { get; set; }
|
|
[StringLength(50)]
|
public string ContainerCode { get; set; }
|
|
[StringLength(50)]
|
public string RelationNo { get; set; }
|
|
[StringLength(50)]
|
public string SupplierCode { get; set; }
|
|
[StringLength(50)]
|
public string SupplierName { get; set; }
|
|
public DateTime? RecordInsertTime { get; set; }
|
|
public DateTime? OnShelvesTime { get; set; }
|
|
public DateTime? OffShelvesTime { get; set; }
|
|
[Required]
|
[StringLength(50)]
|
public string MaterialCode { get; set; }
|
|
[StringLength(50)]
|
public string MaterialName { get; set; }
|
|
[StringLength(50)]
|
public string MaterialUnit { get; set; }
|
|
public decimal Quantity { get; set; }
|
|
public int StockStatus { get; set; }
|
|
[Required]
|
[StringLength(50)]
|
public string StockStatusName { get; set; }
|
|
public int? OldStockStatus { get; set; }
|
|
[StringLength(50)]
|
public string OldStockStatusName { get; set; }
|
|
[StringLength(255)]
|
public string SN_1d { get; set; }
|
|
[StringLength(255)]
|
public string SN_2d { get; set; }
|
|
[Required]
|
[StringLength(255)]
|
public string SNCode { get; set; }
|
|
[Required]
|
[StringLength(255)]
|
public string SourceSNCode { get; set; }
|
|
public int MaxIndex { get; set; }
|
|
[StringLength(255)]
|
public string ErpVoucher { get; set; }
|
|
[StringLength(50)]
|
public string ErpOrderNo { get; set; }
|
|
[StringLength(50)]
|
public string ErpCode { get; set; }
|
|
[StringLength(50)]
|
public string SupplierBatch { get; set; }
|
|
[StringLength(255)]
|
public string Batch { get; set; }
|
|
public int? QCStatus { get; set; }
|
|
[StringLength(50)]
|
public string QCStatusName { get; set; }
|
|
[StringLength(50)]
|
public string WarehouseCode { get; set; }
|
|
[StringLength(50)]
|
public string WarehouseName { get; set; }
|
|
[StringLength(50)]
|
public string AreaCode { get; set; }
|
|
[StringLength(50)]
|
public string AreaName { get; set; }
|
|
[StringLength(50)]
|
public string PlaceCode { get; set; }
|
|
[StringLength(50)]
|
public string PlaceName { get; set; }
|
|
[StringLength(255)]
|
public string Remarks { get; set; }
|
|
public DateTime? CreateTime { get; set; }
|
|
public DateTime? UpdateTime { get; set; }
|
|
public long? CreateUserId { get; set; }
|
|
[StringLength(50)]
|
public string CreateUserName { get; set; }
|
|
public long? UpdateUserId { get; set; }
|
|
[StringLength(50)]
|
public string UpdateUserName { get; set; }
|
|
[StringLength(255)]
|
public string OperReason { get; set; }
|
|
[StringLength(50)]
|
public string OperUser { get; set; }
|
|
public DateTime? OperTime { get; set; }
|
|
[Required]
|
[StringLength(50)]
|
public string LockStatus { get; set; }
|
|
[StringLength(50)]
|
public string LockReason { get; set; }
|
|
[StringLength(50)]
|
public string LockUser { get; set; }
|
|
public DateTime? LockTime { get; set; }
|
|
public bool IsDelete { get; set; }
|
}
|
}
|
