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