| | |
| | | [SugarTable("MES_INV_ITEM_STOCKS")] |
| | | public class MesInvItemStocks |
| | | { |
| | | /// <summary> |
| | | /// <summary> |
| | | /// |
| | | /// 默认值: (newid()) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="guid" ,IsPrimaryKey = true )] |
| | | public Guid Guid { get; set; } |
| | | [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)] |
| | | public Guid Guid { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 生产订单 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="TASK_NO" )] |
| | | public string? TaskNo { get; set; } |
| | | [SugarColumn(ColumnName = "TASK_NO")] |
| | | public string? TaskNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 物料条码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_BARCODE" )] |
| | | public string? ItemBarcode { get; set; } |
| | | [SugarColumn(ColumnName = "ITEM_BARCODE")] |
| | | public string? ItemBarcode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 客户物料编码(无条码手工录入,有条码为冗余字段) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="C_ITEM_CODE" )] |
| | | public string? CItemCode { get; set; } |
| | | [SugarColumn(ColumnName = "C_ITEM_CODE")] |
| | | public string? CItemCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 本司物料编码(无条码手工录入,有条码为冗余字段) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_NO" )] |
| | | public string? ItemNo { get; set; } |
| | | [SugarColumn(ColumnName = "ITEM_NO")] |
| | | public string? ItemNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 子库id |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOTS_ID" )] |
| | | public long? DepotsId { get; set; } |
| | | [SugarColumn(ColumnName = "DEPOTS_ID")] |
| | | public long? DepotsId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 货位id |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOT_SECTIONS_ID" )] |
| | | public long? DepotSectionsId { get; set; } |
| | | [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")] |
| | | public long? DepotSectionsId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 厂家批次 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="LOT_NO" )] |
| | | public string? LotNo { get; set; } |
| | | [SugarColumn(ColumnName = "LOT_NO")] |
| | | public string? LotNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 数量 |
| | | /// 默认值: ((0)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="QUANTITY" )] |
| | | public decimal? Quantity { get; set; } |
| | | [SugarColumn(ColumnName = "QUANTITY")] |
| | | public decimal? Quantity { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 环保标志(无条码手工录入,有条码为冗余字段)(0-否,1-是) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="EP_FLAG" )] |
| | | public byte? EpFlag { get; set; } |
| | | [SugarColumn(ColumnName = "EP_FLAG")] |
| | | public byte? EpFlag { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 客户编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CUSTOMER_NO" )] |
| | | public string? CustomerNo { get; set; } |
| | | [SugarColumn(ColumnName = "CUSTOMER_NO")] |
| | | public string? CustomerNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 重量 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_WT" )] |
| | | public decimal? ItemWt { get; set; } |
| | | [SugarColumn(ColumnName = "ITEM_WT")] |
| | | public decimal? ItemWt { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 子库CODE |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOTS_CODE" )] |
| | | public string? DepotsCode { get; set; } |
| | | [SugarColumn(ColumnName = "DEPOTS_CODE")] |
| | | public string? DepotsCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 货位CODE |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="DEPOT_SECTIONS_CODE" )] |
| | | public string? DepotSectionsCode { get; set; } |
| | | [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")] |
| | | public string? DepotSectionsCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 检验日期 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="CHECK_DATE" )] |
| | | public DateTime? CheckDate { get; set; } |
| | | [SugarColumn(ColumnName = "CHECK_DATE")] |
| | | public DateTime? CheckDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 0 物料 1 半成品 2 成品 |
| | | /// 默认值: ((0)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_TYPE" )] |
| | | public byte? ItemType { get; set; } |
| | | [SugarColumn(ColumnName = "ITEM_TYPE")] |
| | | public byte? ItemType { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 入库日期 |
| | | /// 默认值: (getdate()) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="INDEP_DATE" )] |
| | | public DateTime? IndepDate { get; set; } |
| | | [SugarColumn(ColumnName = "INDEP_DATE")] |
| | | public DateTime? IndepDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 工厂编号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FACTORY" )] |
| | | public string? Factory { get; set; } |
| | | [SugarColumn(ColumnName = "FACTORY")] |
| | | public string? Factory { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 公司编号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="COMPANY" )] |
| | | public string? Company { get; set; } |
| | | [SugarColumn(ColumnName = "COMPANY")] |
| | | public string? Company { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 质量状态 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="IQC_STATUS" )] |
| | | public string? IqcStatus { get; set; } |
| | | [SugarColumn(ColumnName = "IQC_STATUS")] |
| | | public string? IqcStatus { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// F卡 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="FCAR" )] |
| | | public string? Fcar { get; set; } |
| | | [SugarColumn(ColumnName = "FCAR")] |
| | | public string? Fcar { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 可见提交标志(0-否,1-是) |
| | | /// 默认值: ((0)) |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="VISABLE_SUBMIT" )] |
| | | public byte? VisableSubmit { get; set; } |
| | | [SugarColumn(ColumnName = "VISABLE_SUBMIT")] |
| | | public byte? VisableSubmit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 可见提交人 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="VISABLE_SUBMIT_BY" )] |
| | | public string? VisableSubmitBy { get; set; } |
| | | [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")] |
| | | public string? VisableSubmitBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 可见提交时间 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="VISABLE_SUBMIT_DATE" )] |
| | | public DateTime? VisableSubmitDate { get; set; } |
| | | [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")] |
| | | public DateTime? VisableSubmitDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 板型 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BOARD_STYLE" )] |
| | | public string? BoardStyle { get; set; } |
| | | [SugarColumn(ColumnName = "BOARD_STYLE")] |
| | | public string? BoardStyle { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 工单号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WORK_NO" )] |
| | | public string? WorkNo { get; set; } |
| | | [SugarColumn(ColumnName = "WORK_NO")] |
| | | public string? WorkNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 工单行号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="WORK_LINE" )] |
| | | public int? WorkLine { get; set; } |
| | | [SugarColumn(ColumnName = "WORK_LINE")] |
| | | public int? WorkLine { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 供应商编码 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="SUPP_NO" )] |
| | | public string? SuppNo { get; set; } |
| | | [SugarColumn(ColumnName = "SUPP_NO")] |
| | | public string? SuppNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 行号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="LINE_NO" )] |
| | | public string? LineNo { get; set; } |
| | | [SugarColumn(ColumnName = "LINE_NO")] |
| | | public string? LineNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 单据编号 |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="BILL_NO" )] |
| | | public string? BillNo { get; set; } |
| | | [SugarColumn(ColumnName = "BILL_NO")] |
| | | public string? BillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// K3ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="EBELN_K3ID" )] |
| | | public long? EbelnK3id { get; set; } |
| | | [SugarColumn(ColumnName = "EBELN_K3ID")] |
| | | public long? EbelnK3id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 行K3ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="LINE_K3ID" )] |
| | | public long? LineK3id { get; set; } |
| | | [SugarColumn(ColumnName = "LINE_K3ID")] |
| | | public long? LineK3id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// <summary> |
| | | /// 物料ID |
| | | ///</summary> |
| | | [SugarColumn(ColumnName="ITEM_ID" )] |
| | | public long? ItemId { get; set; } |
| | | [SugarColumn(ColumnName = "ITEM_ID")] |
| | | public long? ItemId { get; set; } |
| | | |
| | | [SugarColumn(ColumnName = "SUPP_ID")] |
| | | public string? SuppId { get; set; } |
| | | } |
| | | } |
| | | } |