using SqlSugar;
|
|
namespace NewPdaSqlServer.entity
|
{
|
/// <summary>
|
/// 库存交易记录表
|
///</summary>
|
[SugarTable("MES_INV_BUSINESS2")]
|
public class MesInvBusiness2
|
{
|
/// <summary>
|
/// ID(seq_inv_id)
|
/// 默认值: (newid())
|
///</summary>
|
[SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
|
public Guid Guid { get; set; }
|
|
/// <summary>
|
/// 状态|0-未交易1-已交易
|
///</summary>
|
[SugarColumn(ColumnName = "STATUS")]
|
public long? Status { get; set; }
|
|
/// <summary>
|
/// 单据类型ID
|
///</summary>
|
[SugarColumn(ColumnName = "BILL_TYPE_ID")]
|
public long? BillTypeId { get; set; }
|
|
/// <summary>
|
/// 事务类型编码
|
///</summary>
|
[SugarColumn(ColumnName = "TRANSACTION_CODE")]
|
public string? TransactionCode { get; set; }
|
|
/// <summary>
|
/// 交易类型|1-入库0-转库-1出库
|
///</summary>
|
[SugarColumn(ColumnName = "BUSINESS_TYPE")]
|
public long? BusinessType { get; set; }
|
|
/// <summary>
|
/// 单据ID
|
///</summary>
|
[SugarColumn(ColumnName = "BILL_ID")]
|
public long? BillId { get; set; }
|
|
/// <summary>
|
/// 单据编码
|
///</summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string? BillNo { get; set; }
|
|
/// <summary>
|
/// 生产订单号
|
///</summary>
|
[SugarColumn(ColumnName = "TASK_NO")]
|
public string? TaskNo { get; set; }
|
|
/// <summary>
|
/// 客户编号
|
///</summary>
|
[SugarColumn(ColumnName = "CUSTOMER_NO")]
|
public string? CustomerNo { get; set; }
|
|
/// <summary>
|
/// 单据行ID
|
///</summary>
|
[SugarColumn(ColumnName = "BILL_LINE_ID")]
|
public long? BillLineId { get; set; }
|
|
/// <summary>
|
/// 物料条码
|
///</summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE")]
|
public string? ItemBarcode { get; set; }
|
|
/// <summary>
|
/// 本司物料编码
|
///</summary>
|
[SugarColumn(ColumnName = "ITEM_NO")]
|
public string? ItemNo { get; set; }
|
|
/// <summary>
|
/// 客户物料编码
|
///</summary>
|
[SugarColumn(ColumnName = "C_ITEM_CODE")]
|
public string? CItemCode { get; set; }
|
|
/// <summary>
|
/// 厂家批次
|
///</summary>
|
[SugarColumn(ColumnName = "LOT_NO")]
|
public string? LotNo { get; set; }
|
|
/// <summary>
|
/// 是否环保(0:否,1:是)
|
///</summary>
|
[SugarColumn(ColumnName = "EP_FLAG")]
|
public bool? EpFlag { get; set; }
|
|
/// <summary>
|
/// 数量
|
///</summary>
|
[SugarColumn(ColumnName = "QUANTITY")]
|
public decimal? Quantity { get; set; }
|
|
/// <summary>
|
/// 源子库CODE
|
///</summary>
|
[SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")]
|
public string? FromInvDepotsCode { get; set; }
|
|
/// <summary>
|
/// 源货位CODE
|
///</summary>
|
[SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")]
|
public string? FromInvDepotSectionsCode { get; set; }
|
|
/// <summary>
|
/// 目的子库CODE
|
///</summary>
|
[SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")]
|
public string? ToInvDepotsCode { get; set; }
|
|
/// <summary>
|
/// 目的货位CODE
|
///</summary>
|
[SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")]
|
public string? ToInvDepotSectionsCode { get; set; }
|
|
/// <summary>
|
/// 交易异常信息
|
///</summary>
|
[SugarColumn(ColumnName = "DESCRIPTION")]
|
public string? Description { get; set; }
|
|
/// <summary>
|
/// 创建人
|
///</summary>
|
[SugarColumn(ColumnName = "CREATE_BY")]
|
public string? CreateBy { get; set; }
|
|
/// <summary>
|
/// 创建时间
|
///</summary>
|
[SugarColumn(ColumnName = "CREATE_DATE")]
|
public DateTime? CreateDate { get; set; }
|
|
/// <summary>
|
/// 最后更新人
|
///</summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_BY")]
|
public string? LastupdateBy { get; set; }
|
|
/// <summary>
|
/// 最后更新时间
|
///</summary>
|
[SugarColumn(ColumnName = "LASTUPDATE_DATE")]
|
public DateTime? LastupdateDate { get; set; }
|
|
/// <summary>
|
/// 超损统计标识
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName = "ULLAGE_STAT_FLAG")]
|
public bool? UllageStatFlag { get; set; }
|
|
/// <summary>
|
/// 分厂编码
|
///</summary>
|
[SugarColumn(ColumnName = "FACTORY")]
|
public string? Factory { get; set; }
|
|
/// <summary>
|
/// 公司代码
|
///</summary>
|
[SugarColumn(ColumnName = "COMPANY")]
|
public string? Company { get; set; }
|
|
/// <summary>
|
/// 箱号条码
|
///</summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE2")]
|
public string? ItemBarcode2 { get; set; }
|
|
/// <summary>
|
/// 卡板条码
|
///</summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE3")]
|
public string? ItemBarcode3 { get; set; }
|
|
/// <summary>
|
/// 任务单号
|
///</summary>
|
[SugarColumn(ColumnName = "WORK_NO")]
|
public string? WorkNo { get; set; }
|
|
/// <summary>
|
/// 任务单行号
|
///</summary>
|
[SugarColumn(ColumnName = "WORK_LINE")]
|
public int? WorkLine { get; set; }
|
|
/// <summary>
|
/// 供应商
|
///</summary>
|
[SugarColumn(ColumnName = "SUPP_NO")]
|
public string? SuppNo { get; set; }
|
|
/// <summary>
|
/// 生产线
|
///</summary>
|
[SugarColumn(ColumnName = "LINE_NO")]
|
public string? LineNo { get; set; }
|
|
/// <summary>
|
/// 采购订单id
|
///</summary>
|
[SugarColumn(ColumnName = "EBELN_K3ID")]
|
public long? EbelnK3id { get; set; }
|
|
/// <summary>
|
/// 采购订单行id
|
///</summary>
|
[SugarColumn(ColumnName = "LINE_K3ID")]
|
public long? LineK3id { get; set; }
|
|
/// <summary>
|
/// 物料ID
|
///</summary>
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public long? ItemId { get; set; }
|
}
|
}
|
