using SqlSugar;
|
|
namespace NewPdaSqlServer.entity
|
{
|
/// <summary>
|
/// 物料条码表
|
///</summary>
|
[SugarTable("MES_INV_ITEM_BARCODES")]
|
public class MesInvItemBarcodes
|
{
|
/// <summary>
|
///
|
/// 默认值: (newid())
|
///</summary>
|
[SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )]
|
public Guid Guid { 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>
|
/// 数量
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="QUANTITY" )]
|
public decimal? Quantity { get; set; }
|
/// <summary>
|
/// 是否环保(0:否,1:是)
|
///</summary>
|
[SugarColumn(ColumnName="EP_FLAG" )]
|
public bool? 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 int? Zeile { get; set; }
|
/// <summary>
|
/// 收料表ID
|
///</summary>
|
[SugarColumn(ColumnName="ROH_IN_ID" )]
|
public long? RohInId { get; set; }
|
/// <summary>
|
/// 0为有效条码；1为无效条码
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="BARCODESTATUS" )]
|
public bool? Barcodestatus { get; set; }
|
/// <summary>
|
/// 原始数量
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="OLDQTY" )]
|
public long? Oldqty { get; set; }
|
/// <summary>
|
/// 使用数量
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="USEQTY" )]
|
public long? Useqty { get; set; }
|
/// <summary>
|
/// 0在库，1在线，2作废
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="LOCATION" )]
|
public byte? Location { get; set; }
|
/// <summary>
|
/// 单位
|
///</summary>
|
[SugarColumn(ColumnName="UNIT" )]
|
public string Unit { get; set; }
|
/// <summary>
|
/// 重量（单位：公斤）
|
/// 默认值: ((0))
|
///</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 long? 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>
|
/// 是否可见
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="VISABLE" )]
|
public bool? 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>
|
/// 发货月
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="DELANY_MONTH" )]
|
public int? DelanyMonth { get; set; }
|
/// <summary>
|
/// 是否最小包装
|
///</summary>
|
[SugarColumn(ColumnName="MINPACK_FLAG" )]
|
public bool? 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 long? 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 bool? 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 int? 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))
|
///</summary>
|
[SugarColumn(ColumnName="COME_FLG" )]
|
public bool? ComeFlg { get; set; }
|
/// <summary>
|
/// 行号
|
///</summary>
|
[SugarColumn(ColumnName="LINE_NO" )]
|
public string LineNo { get; set; }
|
/// <summary>
|
/// 丝印数量
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="SILK_PQTY" )]
|
public long? SilkPqty { get; set; }
|
/// <summary>
|
/// 丝印规格
|
///</summary>
|
[SugarColumn(ColumnName="SILK" )]
|
public string Silk { get; set; }
|
/// <summary>
|
/// 丝印ID
|
///</summary>
|
[SugarColumn(ColumnName="SILK_ID" )]
|
public long? SilkId { get; set; }
|
/// <summary>
|
/// 工单状态
|
/// 默认值: ((0))
|
///</summary>
|
[SugarColumn(ColumnName="WORK_FLG" )]
|
public bool? WorkFlg { get; set; }
|
/// <summary>
|
/// 工单最后行
|
///</summary>
|
[SugarColumn(ColumnName="WORK_LAST" )]
|
public int? WorkLast { get; set; }
|
/// <summary>
|
/// HBDY
|
///</summary>
|
[SugarColumn(ColumnName="HBDY" )]
|
public int? Hbdy { get; set; }
|
/// <summary>
|
/// HBDYTM
|
///</summary>
|
[SugarColumn(ColumnName="HBDYTM" )]
|
public int? Hbdytm { get; set; }
|
/// <summary>
|
/// 工序时间
|
///</summary>
|
[SugarColumn(ColumnName="WORK_FLGTIME" )]
|
public string WorkFlgtime { get; set; }
|
/// <summary>
|
/// K3ID订单
|
///</summary>
|
[SugarColumn(ColumnName="EBELN_K3ID" )]
|
public long? EbelnK3id { get; set; }
|
/// <summary>
|
/// K3ID行
|
///</summary>
|
[SugarColumn(ColumnName="LINE_K3ID" )]
|
public long? LineK3id { get; set; }
|
/// <summary>
|
/// 物料ID
|
///</summary>
|
[SugarColumn(ColumnName="ITEM_ID" )]
|
public long? ItemId { get; set; }
|
/// <summary>
|
///
|
///</summary>
|
[SugarColumn(ColumnName="GX_ID" )]
|
public long? GxId { get; set; }
|
/// <summary>
|
/// 临时批量guid
|
///</summary>
|
[SugarColumn(ColumnName="tmpGuid" )]
|
public Guid? TmpGuid { get; set; }
|
/// <summary>
|
/// 供应商id
|
///</summary>
|
[SugarColumn(ColumnName="supp_id" )]
|
public string SuppId { get; set; }
|
}
|
}
|
