| | |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID", |
| | | IsPrimaryKey = true)] |
| | | public decimal? Id { get; set; } |
| | | public decimal Id { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库单id |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] |
| | | public decimal? ItemInId { get; set; } |
| | | public decimal ItemInId { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料条码PSN |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ITEM_BARCODE")] |
| | | public string? ItemBarcode { get; set; } |
| | | public string ItemBarcode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客户物料编码(无条码手工录入,有条码为冗余字段) |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "C_ITEM_CODE")] |
| | | public string? CItemCode { get; set; } |
| | | public string CItemCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 客户物料条码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "C_ITEM_BARCODE")] |
| | | public string? CItemBarcode { get; set; } |
| | | public string CItemBarcode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 验收数量 |
| | |
| | | /// 创建人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CREATE_BY")] |
| | | public string? CreateBy { get; set; } |
| | | public string CreateBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 创建时间 |
| | |
| | | /// 最后更新人 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LASTUPDATE_BY")] |
| | | public string? LastupdateBy { get; set; } |
| | | public string LastupdateBy { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 最后更新时间 |
| | |
| | | /// 本司物料编码(无条码手工录入,有条码为冗余字段) |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ITEM_NO")] |
| | | public string? ItemNo { get; set; } |
| | | public string ItemNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 厂家批次 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LOT_NO")] |
| | | public string? LotNo { get; set; } |
| | | public string LotNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 是否共管物料(0:否,1:是) |
| | |
| | | /// 客户编码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CUST_NO")] |
| | | public string? CustNo { get; set; } |
| | | public string CustNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 检验结果 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CHECK_RES")] |
| | | public string? CheckRes { get; set; } |
| | | public string CheckRes { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 进货数量 |
| | |
| | | /// 检验状态 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CHECK_STATES")] |
| | | public string? CheckStates { get; set; } |
| | | public string CheckStates { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 强制入库标记0无,1-强制入库 退料单使用 |
| | |
| | | /// 仓库编码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEPOT_CODE")] |
| | | public string? DepotCode { get; set; } |
| | | public string DepotCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 货位编码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] |
| | | public string? DepotSectionCode { get; set; } |
| | | public string DepotSectionCode { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 特记事项 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "REMARK")] |
| | | public string? Remark { get; set; } |
| | | public string Remark { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 物料条码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ITEM_BARCODE2")] |
| | | public string? ItemBarcode2 { get; set; } |
| | | public string ItemBarcode2 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 新条码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ITEM_BARCODE3")] |
| | | public string? ItemBarcode3 { get; set; } |
| | | public string ItemBarcode3 { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 使用数量 |
| | |
| | | /// 物料简称 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ITEM_SNAME")] |
| | | public string? ItemSname { get; set; } |
| | | public string ItemSname { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 档位低值 |
| | |
| | | /// 单位 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "UNIT")] |
| | | public string? Unit { get; set; } |
| | | public string Unit { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 是否检验 |
| | |
| | | /// 采购订单 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "EBELN")] |
| | | public string? Ebeln { get; set; } |
| | | public string Ebeln { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 生产日期 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LOT_DATE")] |
| | | public string? LotDate { get; set; } |
| | | public string LotDate { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库单号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BILL_NO")] |
| | | public string? BillNo { get; set; } |
| | | public string BillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 入库审核标志 |
| | |
| | | /// 分厂编码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "FACTORY")] |
| | | public string? Factory { get; set; } |
| | | public string Factory { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 公司代码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "COMPANY")] |
| | | public string? Company { get; set; } |
| | | public string Company { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 卡板编码 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CB_NO")] |
| | | public string? CbNo { get; set; } |
| | | public string CbNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 箱号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BOX_NO")] |
| | | public string? BoxNo { get; set; } |
| | | public string BoxNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 仓库ID |
| | |
| | | /// 行号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "LINE_NUM")] |
| | | public string? LineNum { get; set; } |
| | | public string LineNum { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 扫码数量 |
| | |
| | | /// 销售订单 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "VGBEL")] |
| | | public string? Vgbel { get; set; } |
| | | public string Vgbel { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 销售订单行号 |
| | |
| | | /// 任务单号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "WORK_NO")] |
| | | public string? WorkNo { get; set; } |
| | | public string WorkNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 行号 |
| | |
| | | /// 到货单号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "CBILL_NO")] |
| | | public string? CbillNo { get; set; } |
| | | public string CbillNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 急料标识 |
| | |
| | | /// 产品型号 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "BOARD_STYLE")] |
| | | public string? BoardStyle { get; set; } |
| | | public string BoardStyle { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 任务单行号 |
| | |
| | | /// 生产工单 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "TASK_NO")] |
| | | public string? TaskNo { get; set; } |
| | | public string TaskNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 供应商 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "SUPP_NO")] |
| | | public string? SuppNo { get; set; } |
| | | public string SuppNo { get; set; } |
| | | |
| | | /// <summary> |
| | | /// 任务汇报单 |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "RBILL_NO")] |
| | | public string? RbillNo { 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> |
| | | /// 物料id |
| | | /// </summary> |
| | | [SugarColumn(ColumnName = "ITEM_ID")] |
| | | public decimal? ItemId { get; set; } |
| | | public string RbillNo { get; set; } |
| | | |
| | | // 添加的字段,并且它们不属于数据库表 |
| | | [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; } |