123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449 |
- using SqlSugar;
- using System;
- using System.Collections.Generic;
- using System.Text;
- namespace wms.sqlsugar.model.pt
- {
- [Tenant("pt")]
- [SugarTable("Bill_InvNow", "库存表")]
- public class ptBillInvnow : BaseModel
- {
- /// <summary>
- /// WarehouseId
- /// </summary>
- [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
- public long WarehouseId { get; set; }
- /// <summary>
- /// 容器ID
- /// </summary>
- [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
- public long ContGrpId { get; set; }
- /// <summary>
- /// 容器条码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ContGrpBarCode { get; set; }
- /// <summary>
- /// 组盘类型(1物料盘 2空盘)
- /// </summary>
- //[SugarColumn(ColumnDataType = "int", IsNullable = false)]
- //public int ContGrpType { get; set; }
- /// <summary>
- /// 成品箱条码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string BoxBarCode { get; set; }
- /// <summary>
- /// Bom工单号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string BomDocsNo { get; set; }
- /// <summary>
- /// BomMatId
- /// </summary>
- [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
- public long BomMatId { get; set; }
- /// <summary>
- /// BomMatCode
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string BomMatCode { get; set; }
- /// <summary>
- /// BomMatName
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
- public string BomMatName { get; set; }
- /// <summary>
- /// BomSetId
- /// </summary>
- [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
- public long BomSetId { get; set; }
- /// <summary>
- /// ExecStateCode
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ExecStateCode { get; set; }
- /// <summary>
- /// 执行单据号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ExecDocsNo { get; set; }
- /// <summary>
- /// 执行单据行号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ExecDocsRowNo { get; set; }
- /// <summary>
- /// 执行单据类型代码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ExecDocsTypeCode { get; set; }
- /// <summary>
- /// InvInOut
- /// </summary>
- [SugarColumn(ColumnDataType = "int", IsNullable = false)]
- public int InvInOut { get; set; }
- /// <summary>
- /// ExecWho
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ExecWho { get; set; }
- /// <summary>
- /// ExecTime
- /// </summary>
- [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
- public DateTime ExecTime { get; set; }
- /// <summary>
- /// 摆放行
- /// </summary>
- [SugarColumn(ColumnDataType = "int", IsNullable = false)]
- public int PutRow { get; set; }
- /// <summary>
- /// 摆放列
- /// </summary>
- [SugarColumn(ColumnDataType = "int", IsNullable = false)]
- public int PutCol { get; set; }
- /// <summary>
- /// 摆放层
- /// </summary>
- [SugarColumn(ColumnDataType = "int", IsNullable = false)]
- public int PutLayer { get; set; }
- /// <summary>
- /// 材料号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string InvBarCode { get; set; }
- /// <summary>
- /// 组盘状态
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string InvStateCode { get; set; }
- /// <summary>
- /// 入库单据号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string InDocsNo { get; set; }
- /// <summary>
- /// 入库单据行号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string InDocsRowNo { get; set; }
- /// <summary>
- /// 供应商编码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string SuppCode { get; set; }
- /// <summary>
- /// 供应商名称
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string SuppName { get; set; }
- /// <summary>
- /// 客户编码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string CustCode { get; set; }
- /// <summary>
- /// 客户名称
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string CustName { get; set; }
- /// <summary>
- /// 物料ID
- /// </summary>
- [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
- public long MatId { get; set; }
- /// <summary>
- /// 物料编码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string MatCode { get; set; }
- /// <summary>
- /// 物料名称
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
- public string MatName { get; set; }
- /// <summary>
- /// 包重
- /// </summary>
- [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
- public decimal TolWQty { get; set; }
- /// <summary>
- /// 净重
- /// </summary>
- [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
- public decimal NetWQty { get; set; }
- /// <summary>
- /// 皮重
- /// </summary>
- [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
- public decimal TareWQty { get; set; }
- /// <summary>
- /// 长度
- /// </summary>
- [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
- public decimal LengthQty { get; set; }
- /// <summary>
- /// 碳当量
- /// </summary>
- [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
- public decimal CaQty { get; set; }
- /// <summary>
- /// 焊点数量
- /// </summary>
- [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
- public decimal SolderQty { get; set; }
- /// <summary>
- /// ContUsageQty
- /// </summary>
- [SugarColumn(ColumnDataType = "int", IsNullable = false)]
- public int ContUsageQty { get; set; }
- /// <summary>
- /// 生产批号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string BatchNo { get; set; }
- /// <summary>
- /// 生产时间
- /// </summary>
- [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
- public DateTime ProductTime { get; set; }
- /// <summary>
- /// 第一次入库时间
- /// </summary>
- [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
- public DateTime OneInTime { get; set; }
- /// <summary>
- /// 盘条条码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string RodBarCode { get; set; }
- /// <summary>
- /// 工字轮条码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string HWBarCode { get; set; }
- /// <summary>
- /// RFID条码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string RFIDBarCode { get; set; }
- /// <summary>
- /// 材料号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string CLBarCode { get; set; }
- /// <summary>
- /// 工字轮规格
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string HWTypeCode { get; set; }
- /// <summary>
- /// 炉号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string BoilerNo { get; set; }
- /// <summary>
- /// 包号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string PackNo { get; set; }
- /// <summary>
- /// 牌号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string BrandNo { get; set; }
- /// <summary>
- /// 执行标准
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ExecStd { get; set; }
- /// <summary>
- /// 许可证号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string LicenceCode { get; set; }
- /// <summary>
- /// 改手盘标记(余料)
- /// </summary>
- [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
- public bool IsSurplus { get; set; }
- /// <summary>
- /// 返工标记
- /// </summary>
- [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
- public bool IsRework { get; set; }
- /// <summary>
- /// 是否黑盘
- /// </summary>
- [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
- public bool IsBlack { get; set; }
- /// <summary>
- /// 是否芯股
- /// </summary>
- [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
- public bool IsCore { get; set; }
- /// <summary>
- /// 快投标记
- /// </summary>
- [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
- public bool IsFast { get; set; }
- /// <summary>
- /// 是否异常
- /// </summary>
- [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
- public bool IsFail { get; set; }
- /// <summary>
- /// 异常原因
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
- public string FailReason { get; set; }
- /// <summary>
- /// 单/双丝
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string SilkTypeCode { get; set; }
- /// <summary>
- /// 等级
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string Grade { get; set; }
- /// <summary>
- /// 是否退料
- /// </summary>
- [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
- public bool IsBack { get; set; }
- /// <summary>
- /// 退料原因
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
- public string BackReason { get; set; }
- /// <summary>
- /// 是否 扭转检测
- /// </summary>
- [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
- public bool IsTorsChk { get; set; }
- /// <summary>
- /// 扭转次数
- /// </summary>
- [SugarColumn(ColumnDataType = "int", IsNullable = false)]
- public int TorsChkQty { get; set; }
- /// <summary>
- /// 扭转检测时间
- /// </summary>
- [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
- public DateTime TorsChkTime { get; set; }
- /// <summary>
- /// 扭转检测结果值
- /// </summary>
- [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
- public decimal? TorsChkValue { get; set; }
- /// <summary>
- /// 扭转检测设备号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string TorsChkMachCode { get; set; }
- /// <summary>
- /// 工序订单号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ProcessDocsCode { get; set; }
- /// <summary>
- /// 生产机台号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ProductMachCode { get; set; }
- /// <summary>
- /// 生产产线号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ProductLineNo { get; set; }
- /// <summary>
- /// 货物大小
- /// </summary>
- [SugarColumn(IsNullable = false)]
- public int Size { get; set; }
- /// <summary>
- /// 规格
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
- public string Describe { get; set; }
- /// <summary>
- /// 时效期
- /// </summary>
- [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
- public decimal HoldDuration { get; set; }
- }
- }
|