using System; using System.ComponentModel.DataAnnotations.Schema; namespace WebRepository { /// <summary> /// 库存交易表 /// </summary> [Table("inventory_transaction")] public partial class InventoryTransaction : SysEntity { public InventoryTransaction() { } /// <summary> /// 仓库类型 /// </summary> [Column("warehouseType")] public string WarehouseType { get; set; } /// <summary> /// 库位id /// </summary> [Column("locationId")] public int? LocationId { get; set; } /// <summary> /// 库位编号 /// </summary> [Column("locationCode")] public string LocationCode { get; set; } /// <summary> /// 容器编码 /// </summary> [Column("containerCode")] public string ContainerCode { get; set; } /// <summary> /// 上游系统单号 /// </summary> [Column("sourceCode")] public string SourceCode { get; set; } /// <summary> /// 上游系统行号 /// </summary> [Column("sourceLine")] public string SourceLine { get; set; } /// <summary> /// 交易类型 /// </summary> [Column("type")] public string Type { get; set; } /// <summary> /// 物料Id /// </summary> [Column("materialId")] public int? MaterialId { get; set; } /// <summary> /// 物料名称 /// </summary> [Column("materialName")] public string MaterialName { get; set; } /// <summary> /// 物料编码 /// </summary> [Column("materialCode")] public string MaterialCode { get; set; } /// <summary> /// 单头 /// </summary> [Column("billId")] public int? BillId { get; set; } /// <summary> /// 单编码 /// </summary> [Column("billCode")] public string BillCode { get; set; } /// <summary> /// 单明细id /// </summary> [Column("billDetailId")] public int? BillDetailId { get; set; } /// <summary> /// 批次 /// </summary> [Column("batch")] public string Batch { get; set; } /// <summary> /// 批号 /// </summary> [Column("lot")] public string Lot { get; set; } /// <summary> /// 项目号 /// </summary> [Column("project")] public string Project { get; set; } /// <summary> /// 生产日期 /// </summary> [Column("manufactureDate")] public System.DateTime? ManufactureDate { get; set; } /// <summary> /// 失效日期 /// </summary> [Column("expirationDate")] public System.DateTime? ExpirationDate { get; set; } /// <summary> /// 库存状态 /// </summary> [Column("status")] public string Status { get; set; } /// <summary> /// 数量 /// </summary> [Column("qty")] public decimal? Qty { get; set; } /// <summary> /// 执行预定数量 /// </summary> [Column("taskQty")] public decimal? TaskQty { get; set; } /// <summary> /// 成本 /// </summary> [Column("costPrice")] public decimal? CostPrice { get; set; } /// <summary> /// 标价 /// </summary> [Column("listPrice")] public decimal? ListPrice { get; set; } /// <summary> /// 净价 /// </summary> [Column("netPrice")] public decimal? NetPrice { get; set; } /// <summary> /// 自定义字段1 /// </summary> [Column("userDef1")] public string UserDef1 { get; set; } /// <summary> /// 自定义字段2 /// </summary> [Column("userDef2")] public string UserDef2 { get; set; } /// <summary> /// 自定义字段3 /// </summary> [Column("userDef3")] public string UserDef3 { get; set; } } }