using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using SqlSugar;
|
namespace MES.Service.Modes
|
{
|
/// <summary>
|
/// 库存交易记录表
|
///</summary>
|
[SugarTable("MES_INV_BUSINESS2")]
|
public class MesInvBusiness2
|
{
|
/// <summary>
|
/// ID(seq_inv_id)
|
///</summary>
|
[SugarColumn(ColumnName="ID",OracleSequenceName = "SEQ_ID",IsPrimaryKey = true )]
|
public decimal Id { get; set; }
|
/// <summary>
|
/// 状态|0-未交易1-已交易
|
///</summary>
|
[SugarColumn(ColumnName="STATUS" )]
|
public decimal? Status { get; set; }
|
/// <summary>
|
/// 单据类型ID
|
///</summary>
|
[SugarColumn(ColumnName="BILL_TYPE_ID" )]
|
public decimal? BillTypeId { get; set; }
|
/// <summary>
|
/// 事务类型编码
|
///</summary>
|
[SugarColumn(ColumnName="TRANSACTION_CODE" )]
|
public string TransactionCode { get; set; }
|
/// <summary>
|
/// 交易类型|1-入库0-转库-1出库
|
///</summary>
|
[SugarColumn(ColumnName="BUSINESS_TYPE" )]
|
public decimal? BusinessType { get; set; }
|
/// <summary>
|
/// 单据ID
|
///</summary>
|
[SugarColumn(ColumnName="BILL_ID" )]
|
public decimal? 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 decimal? 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 short? 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>
|
/// 超损统计标识
|
///</summary>
|
[SugarColumn(ColumnName="ULLAGE_STAT_FLAG" )]
|
public short? 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 decimal? 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 decimal? EbelnK3id { get; set; }
|
/// <summary>
|
/// 采购订单行id
|
///</summary>
|
[SugarColumn(ColumnName="LINE_K3ID" )]
|
public decimal? LineK3id { get; set; }
|
}
|
}
|
