using SqlSugar;
|
|
namespace Gs.Entity.Warehouse;
|
|
/// <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 decimal? Oldqty { get; set; }
|
|
/// <summary>
|
/// 使用数量
|
/// 默认值: ((0))
|
/// </summary>
|
[SugarColumn(ColumnName = "USEQTY")]
|
public decimal? 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 int 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>
|
/// 生产工序ID(表MES_DAA_GX的ID)
|
/// </summary>
|
[SugarColumn(ColumnName = "GX_ID")]
|
public long? GxId { get; set; }
|
|
|
/// <summary>
|
/// 供应商id
|
/// </summary>
|
[SugarColumn(ColumnName = "SUPP_ID")]
|
public string? SuppID { 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; }
|
|
|
/// <summary>
|
/// 入库位
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string? DepotSectionsCode { get; set; }
|
|
|
/// <summary>
|
/// 入库仓库
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string? DepotsCode { get; set; }
|
|
|
/// <summary>
|
/// 入库仓库
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public string? DepotName { get; set; }
|
|
/// <summary>
|
/// 入库人
|
/// </summary>
|
|
[SugarColumn(IsIgnore = true)]
|
public string? RkUser { get; set; }
|
|
/// <summary>
|
/// 入库时间
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public DateTime? RkDate { get; set; }
|
|
|
/// <summary>
|
/// 是否入库
|
/// </summary>
|
[SugarColumn(IsIgnore = true)]
|
public bool InChk { get; set; }
|
}
|
