| | |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Linq; |
| | | using SqlSugar; |
| | | namespace MES.Service.Modes |
| | | { |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.Modes; |
| | | |
| | | /// <summary> |
| | | /// 物料成品入库申请条码明细 |
| | | ///</summary> |
| | |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )] |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库单id |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_IN_ID" ,IsPrimaryKey = true )] |
| | | public decimal ItemInId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料条码PSN |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_BARCODE" )] |
| | | public string? ItemBarcode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客户物料编码(无条码手工录入,有条码为冗余字段) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="C_ITEM_CODE" )] |
| | | public string? CItemCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客户物料条码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="C_ITEM_BARCODE" )] |
| | | public string? CItemBarcode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 验收数量 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="QUANTITY" )] |
| | | public decimal? Quantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库方式(1:有条码,0:无条码) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BARCODE_FLAG" )] |
| | | public short? BarcodeFlag { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 环保标志(0-非环保,1-环保.无条码手工录入,有条码为冗余字段) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="EP_FLAG" )] |
| | | public short? EpFlag { 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-有线条码枪1-无线条码枪 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WORK_TYPE" )] |
| | | public decimal? WorkType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 本司物料编码(无条码手工录入,有条码为冗余字段) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_NO" )] |
| | | public string? ItemNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 厂家批次 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="LOT_NO" )] |
| | | public string? LotNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 是否共管物料(0:否,1:是) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="COMANAGEMENT_FLAG" )] |
| | | public short? ComanagementFlag { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客户编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CUST_NO" )] |
| | | public string? CustNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 检验结果 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_RES" )] |
| | | public string? CheckRes { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 进货数量 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_QTY" )] |
| | | public decimal? CheckQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 检验状态 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_STATES" )] |
| | | public string? CheckStates { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 强制入库标记0无,1-强制入库 退料单使用 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FORCE_IN_FLAG" )] |
| | | public short? ForceInFlag { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOT_CODE" )] |
| | | public string? DepotCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 货位编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOT_SECTION_CODE" )] |
| | | public string? DepotSectionCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 特记事项 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="REMARK" )] |
| | | public string? Remark { 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="USE_QTY" )] |
| | | public decimal? UseQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 领料数量 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="OUT_QTY" )] |
| | | public decimal? OutQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料简称 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_SNAME" )] |
| | | public string? ItemSname { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 档位低值 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SPOSTION" )] |
| | | public decimal? Spostion { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 档位高值 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="EPOSTION" )] |
| | | public decimal? Epostion { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 检验日期 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_DATE" )] |
| | | public DateTime? CheckDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 单位 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="UNIT" )] |
| | | public string? Unit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 是否检验 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ISCHECK" )] |
| | | public decimal? Ischeck { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 采购订单 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="EBELN" )] |
| | | public string? Ebeln { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 生产日期 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="LOT_DATE" )] |
| | | public string? LotDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库单号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BILL_NO" )] |
| | | public string? BillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库审核标志 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="STOCK_OK" )] |
| | | public short? StockOk { 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="CB_NO" )] |
| | | public string? CbNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 箱号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BOX_NO" )] |
| | | public string? BoxNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOT_ID" )] |
| | | public decimal? DepotId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 货位ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOT_SECTION_ID" )] |
| | | public decimal? DepotSectionId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 行号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="LINE_NUM" )] |
| | | public string? LineNum { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 扫码数量 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SM_QTY" )] |
| | | public decimal? SmQty { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 销售订单 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="VGBEL" )] |
| | | public string? Vgbel { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 销售订单行号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="KDPOS" )] |
| | | public decimal? Kdpos { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 任务单号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WORK_NO" )] |
| | | public string? WorkNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 行号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="EBELN_LINE_NO" )] |
| | | public decimal? EbelnLineNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 到货单号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CBILL_NO" )] |
| | | public string? CbillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 急料标识 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="URGENT_FLAG" )] |
| | | public decimal? UrgentFlag { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 产品型号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BOARD_STYLE" )] |
| | | public string? BoardStyle { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 任务单行号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WORK_LINE" )] |
| | | public decimal? WorkLine { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 生产工单 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="TASK_NO" )] |
| | | public string? TaskNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 供应商 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SUPP_NO" )] |
| | | public string? SuppNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 任务汇报单 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="RBILL_NO" )] |
| | | public string? RbillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_ID" )] |
| | | public decimal? ItemId { get; set; } |
| | | } |
| | | } |