using SqlSugar;
|
|
namespace MES.Service.Modes;
|
|
/// <summary>
|
/// 物料条码表
|
/// </summary>
|
[SugarTable("MES_INV_ITEM_BARCODES")]
|
public class MesInvItemBarcodes
|
{
|
/// <summary>
|
/// SEQ_BARCODE_PSN_ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_EQBASE",
|
IsPrimaryKey = true)]
|
public decimal Id { get; set; }
|
|
/// <summary>
|
/// 物料条码
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE")]
|
public string ItemBarcode { get; set; }
|
|
/// <summary>
|
/// 客户成品编码
|
/// </summary>
|
[SugarColumn(ColumnName = "C_PRODUCT_CODE")]
|
public string CProductCode { get; set; }
|
|
/// <summary>
|
/// 客户物料条码
|
/// </summary>
|
[SugarColumn(ColumnName = "C_ITEM_BARCODE")]
|
public string CItemBarcode { get; set; }
|
|
/// <summary>
|
/// 客户物料编码
|
/// </summary>
|
[SugarColumn(ColumnName = "C_ITEM_CODE")]
|
public string CItemCode { 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>
|
/// 数量
|
/// </summary>
|
[SugarColumn(ColumnName = "QUANTITY")]
|
public decimal? Quantity { get; set; }
|
|
/// <summary>
|
/// 是否环保(0:否,1:是)
|
/// </summary>
|
[SugarColumn(ColumnName = "EP_FLAG")]
|
public short? EpFlag { get; set; }
|
|
/// <summary>
|
/// 生产工单
|
/// </summary>
|
[SugarColumn(ColumnName = "TASK_NO")]
|
public string TaskNo { 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 = "CUST_NO")]
|
public string CustNo { get; set; }
|
|
/// <summary>
|
/// 物料条码注释行[冗余，条码重打使用]
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")]
|
public string ItemBarcodeText { get; set; }
|
|
/// <summary>
|
/// 原PSN物料条码
|
/// </summary>
|
[SugarColumn(ColumnName = "OLD_ITEM_BARCODE")]
|
public string OldItemBarcode { get; set; }
|
|
/// <summary>
|
/// SAP收货物料凭证号 --采购单号
|
/// </summary>
|
[SugarColumn(ColumnName = "MBLNR")]
|
public string Mblnr { get; set; }
|
|
/// <summary>
|
/// SAP收货物料凭证行号 --采购单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "ZEILE")]
|
public decimal? Zeile { get; set; }
|
|
/// <summary>
|
/// 收料表ID
|
/// </summary>
|
[SugarColumn(ColumnName = "ROH_IN_ID")]
|
public decimal? RohInId { get; set; }
|
|
/// <summary>
|
/// 0为有效条码；1为无效条码
|
/// </summary>
|
[SugarColumn(ColumnName = "BARCODESTATUS")]
|
public short? Barcodestatus { get; set; }
|
|
/// <summary>
|
/// 原始数量
|
/// </summary>
|
[SugarColumn(ColumnName = "OLDQTY")]
|
public decimal? Oldqty { get; set; }
|
|
/// <summary>
|
/// 使用数量
|
/// </summary>
|
[SugarColumn(ColumnName = "USEQTY")]
|
public decimal? Useqty { get; set; }
|
|
/// <summary>
|
/// 0在库，1在线，2作废
|
/// </summary>
|
[SugarColumn(ColumnName = "LOCATION")]
|
public short? Location { get; set; }
|
|
/// <summary>
|
/// 单位
|
/// </summary>
|
[SugarColumn(ColumnName = "UNIT")]
|
public string Unit { get; set; }
|
|
/// <summary>
|
/// 重量（单位：公斤）
|
/// </summary>
|
[SugarColumn(ColumnName = "WEIGHT_UNIT")]
|
public decimal? WeightUnit { get; set; }
|
|
/// <summary>
|
/// 单价
|
/// </summary>
|
[SugarColumn(ColumnName = "PRICE")]
|
public decimal? Price { get; set; }
|
|
/// <summary>
|
/// 原条码数量
|
/// </summary>
|
[SugarColumn(ColumnName = "OLD_BAR_QUANTITY")]
|
public decimal? OldBarQuantity { get; set; }
|
|
/// <summary>
|
/// 汇总条码
|
/// </summary>
|
[SugarColumn(ColumnName = "SUM_BARCODE")]
|
public string SumBarcode { get; set; }
|
|
/// <summary>
|
/// 生产日期
|
/// </summary>
|
[SugarColumn(ColumnName = "LOT_DATE")]
|
public string LotDate { get; set; }
|
|
/// <summary>
|
/// 模号
|
/// </summary>
|
[SugarColumn(ColumnName = "MOCODE")]
|
public string Mocode { get; set; }
|
|
/// <summary>
|
/// 来源
|
/// </summary>
|
[SugarColumn(ColumnName = "MEMO")]
|
public string Memo { get; set; }
|
|
/// <summary>
|
/// 供应商编码
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPP_NO")]
|
public string SuppNo { get; set; }
|
|
/// <summary>
|
/// 档位低值
|
/// </summary>
|
[SugarColumn(ColumnName = "SPOSTION")]
|
public string Spostion { get; set; }
|
|
/// <summary>
|
/// 档位高值
|
/// </summary>
|
[SugarColumn(ColumnName = "EPOSTION")]
|
public string Epostion { get; set; }
|
|
/// <summary>
|
/// 物料简称
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_SNAME")]
|
public string ItemSname { get; set; }
|
|
/// <summary>
|
/// 是否已冻结,1冻结
|
/// </summary>
|
[SugarColumn(ColumnName = "VISABLE")]
|
public short? Visable { get; set; }
|
|
/// <summary>
|
/// 供应商批次
|
/// </summary>
|
[SugarColumn(ColumnName = "TR_LOTNO")]
|
public string TrLotno { get; set; }
|
|
/// <summary>
|
/// 冻结时间
|
/// </summary>
|
[SugarColumn(ColumnName = "FLEZZ_DATE")]
|
public DateTime? FlezzDate { get; set; }
|
|
/// <summary>
|
/// 冻结原因
|
/// </summary>
|
[SugarColumn(ColumnName = "FLEZZ_REASON")]
|
public string FlezzReason { get; set; }
|
|
/// <summary>
|
/// 冻结人
|
/// </summary>
|
[SugarColumn(ColumnName = "FLEZZ_BY")]
|
public string FlezzBy { get; set; }
|
|
/// <summary>
|
/// 延长保质期
|
/// </summary>
|
[SugarColumn(ColumnName = "DELANY_MONTH")]
|
public decimal? DelanyMonth { get; set; }
|
|
/// <summary>
|
/// 最小包装标识
|
/// </summary>
|
[SugarColumn(ColumnName = "MINPACK_FLAG")]
|
public short? MinpackFlag { get; set; }
|
|
/// <summary>
|
/// 打印ID，用来区分打印次数
|
/// </summary>
|
[SugarColumn(ColumnName = "PRINT_ID")]
|
public string PrintId { get; set; }
|
|
/// <summary>
|
/// 环保项目
|
/// </summary>
|
[SugarColumn(ColumnName = "EP_ITEM")]
|
public string EpItem { 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 = "LINFLINE")]
|
public string Linfline { get; set; }
|
|
/// <summary>
|
/// 有效期
|
/// </summary>
|
[SugarColumn(ColumnName = "VALID_TIME")]
|
public DateTime? ValidTime { get; set; }
|
|
/// <summary>
|
/// 质检结果
|
/// </summary>
|
[SugarColumn(ColumnName = "IQC_STATUS")]
|
public string IqcStatus { get; set; }
|
|
/// <summary>
|
/// 小车条码
|
/// </summary>
|
[SugarColumn(ColumnName = "FCAR")]
|
public string Fcar { get; set; }
|
|
/// <summary>
|
/// 毛重
|
/// </summary>
|
[SugarColumn(ColumnName = "GWEIGHT")]
|
public string Gweight { get; set; }
|
|
/// <summary>
|
/// 净重
|
/// </summary>
|
[SugarColumn(ColumnName = "NWEIGHT")]
|
public string Nweight { get; set; }
|
|
/// <summary>
|
/// 保质期
|
/// </summary>
|
[SugarColumn(ColumnName = "EXT_DATE")]
|
public decimal? ExtDate { get; set; }
|
|
/// <summary>
|
/// 供应商、赠品、客供料、委外
|
/// </summary>
|
[SugarColumn(ColumnName = "BARCODETYPE")]
|
public string Barcodetype { get; set; }
|
|
/// <summary>
|
/// 供应商名称
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPP_NAME")]
|
public string SuppName { get; set; }
|
|
/// <summary>
|
/// 到货单号/入库单号
|
/// </summary>
|
[SugarColumn(ColumnName = "BILL_NO")]
|
public string BillNo { get; set; }
|
|
/// <summary>
|
/// 急料标识
|
/// </summary>
|
[SugarColumn(ColumnName = "URGENT_FLAG")]
|
public short? UrgentFlag { get; set; }
|
|
/// <summary>
|
/// 颜色
|
/// </summary>
|
[SugarColumn(ColumnName = "COLOR_NAME")]
|
public string ColorName { get; set; }
|
|
/// <summary>
|
/// 产品型号
|
/// </summary>
|
[SugarColumn(ColumnName = "BOARD_STYLE")]
|
public string BoardStyle { get; set; }
|
|
/// <summary>
|
/// 来料日期
|
/// </summary>
|
[SugarColumn(ColumnName = "INS_DATE")]
|
public DateTime? InsDate { get; set; }
|
|
/// <summary>
|
/// 到货单行号
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_LINE")]
|
public decimal? WorkLine { get; set; }
|
|
/// <summary>
|
/// 不良原因
|
/// </summary>
|
[SugarColumn(ColumnName = "MEMO_BAD")]
|
public string MemoBad { get; set; }
|
|
/// <summary>
|
/// 任务单号
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_NO")]
|
public string WorkNo { get; set; }
|
|
/// <summary>
|
/// 条码来源标识，0-初期物料,1-采购入库，2、生产退料，3、其它入库，4-客供料,5-在库分料，6-制程条码
|
/// </summary>
|
[SugarColumn(ColumnName = "COME_FLG")]
|
public short? ComeFlg { get; set; }
|
|
/// <summary>
|
/// 生产线体
|
/// </summary>
|
[SugarColumn(ColumnName = "LINE_NO")]
|
public string LineNo { get; set; }
|
|
/// <summary>
|
/// 丝印次数
|
/// </summary>
|
[SugarColumn(ColumnName = "SILK_PQTY")]
|
public decimal? SilkPqty { get; set; }
|
|
/// <summary>
|
/// 丝印次数比
|
/// </summary>
|
[SugarColumn(ColumnName = "SILK")]
|
public string Silk { get; set; }
|
|
/// <summary>
|
/// 丝印派工从表ID
|
/// </summary>
|
[SugarColumn(ColumnName = "SILK_ID")]
|
public decimal? SilkId { get; set; }
|
|
/// <summary>
|
/// 已报工标识
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_FLG")]
|
public decimal? WorkFlg { get; set; }
|
|
/// <summary>
|
/// 最后工序
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_LAST")]
|
public decimal? WorkLast { get; set; }
|
|
/// <summary>
|
/// 0-未合并打印，1-合并打印
|
/// </summary>
|
[SugarColumn(ColumnName = "HBDY")]
|
public decimal? Hbdy { get; set; }
|
|
/// <summary>
|
/// 0-有效条码，1-合并拆分的条码，无效
|
/// </summary>
|
[SugarColumn(ColumnName = "HBDYTM")]
|
public decimal? Hbdytm { get; set; }
|
|
/// <summary>
|
/// 报工时间
|
/// </summary>
|
[SugarColumn(ColumnName = "WORK_FLGTIME")]
|
public string WorkFlgtime { 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; }
|
|
/// <summary>
|
/// </summary>
|
[SugarColumn(ColumnName = "ITEM_ID")]
|
public decimal? ItemId { get; set; }
|
|
/// <summary>
|
/// 生产工序ID
|
/// </summary>
|
[SugarColumn(ColumnName = "GX_ID")]
|
public decimal? GxId { get; set; }
|
|
/// <summary>
|
/// 组织id
|
/// </summary>
|
[SugarColumn(ColumnName = "ORG_NAME")]
|
public string OrgName { get; set; }
|
|
/// <summary>
|
/// 货主id
|
/// </summary>
|
[SugarColumn(ColumnName = "ORG_OWNER")]
|
public string OrgOwner { get; set; }
|
}
|
