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_ware_inventory_by_container
|
{
|
[StringLength(50)]
|
public string RegionName { get; set; }
|
|
[Key]
|
[Column(Order = 0)]
|
[DatabaseGenerated(DatabaseGeneratedOption.None)]
|
public long Id { get; set; }
|
|
[StringLength(50)]
|
public string WareLocationCode { get; set; }
|
|
public long? LocTypeId { get; set; }
|
|
[StringLength(50)]
|
public string LocTypeName { get; set; }
|
|
[StringLength(50)]
|
public string Lane { get; set; }
|
|
public int? Layer { get; set; }
|
|
public int? Column { get; set; }
|
|
public int? Row { get; set; }
|
|
[StringLength(50)]
|
public string WareContainerCode { get; set; }
|
|
[StringLength(50)]
|
public string WareContainerName { get; set; }
|
|
[StringLength(50)]
|
public string WareMaterialCode { get; set; }
|
|
[StringLength(200)]
|
public string WareMaterialName { get; set; }
|
|
[StringLength(50)]
|
public string OrdersNo { get; set; }
|
|
[StringLength(5)]
|
public string OrderType { get; set; }
|
|
[StringLength(50)]
|
public string PurchaseNo { get; set; }
|
|
[StringLength(50)]
|
public string DeliveryNo { get; set; }
|
|
[StringLength(50)]
|
public string CollectNo { get; set; }
|
|
public decimal? Quantity { get; set; }
|
|
[Key]
|
[Column(Order = 1)]
|
[DatabaseGenerated(DatabaseGeneratedOption.None)]
|
public int OCCQuantity { get; set; }
|
|
[StringLength(100)]
|
public string ItemBatchNo { get; set; }
|
|
[StringLength(50)]
|
public string BarCode { get; set; }
|
|
[StringLength(50)]
|
public string Unit { get; set; }
|
|
[StringLength(500)]
|
public string Remarks { get; set; }
|
|
public bool? IsLocked { get; set; }
|
|
public bool? IsDeleted { get; set; }
|
|
public long? UpdatedUserId { get; set; }
|
|
[StringLength(20)]
|
public string UpdatedUserName { get; set; }
|
|
public DateTimeOffset? UpdatedTime { get; set; }
|
|
public long? CreatedUserId { get; set; }
|
|
[StringLength(20)]
|
public string CreatedUserName { get; set; }
|
|
public DateTimeOffset? CreatedTime { get; set; }
|
}
|
}
|
