123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440 |
- using SqlSugar;
- using System;
- namespace wms.sqlsugar.model.fj
- {
- /// <summary>
- /// 库存表
- /// </summary>
- [Tenant("fj")]
- [SugarTable("Bill_InvNow")]
- public partial class BillInvnow : BaseModel
- {
- /// <summary>
- /// 仓库ID 关联仓库表 ID
- /// </summary>
- [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
- public long WarehouseId { get; set; }
- /// <summary>
- /// 组盘ID
- /// 创建库存的时候 获取条码表ContGrpId
- /// </summary>
- [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
- public long ContGrpId { get; set; }
- /// <summary>
- /// 容器条码 同联容器表容器条码 ContBarCode
- /// </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单号 关联投料单 帘线工序工单号 BillCode
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string BomDocsNo { get; set; }
- /// <summary>
- /// Bom物料ID
- /// </summary>
- [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
- public long BomMatId { get; set; }
- /// <summary>
- /// Bom物料编号
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string BomMatCode { get; set; }
- /// <summary>
- /// Bom物料
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
- public string BomMatName { get; set; }
- /// <summary>
- /// 垛形主表 ID
- /// </summary>
- [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
- public long BomSetId { get; set; }
- /// <summary>
- /// 库存状态码
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ExecStateCode { get; set; }
- /// <summary>
- /// 单据编号 关联单据表单据编号 DocsNo
- /// </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>
- /// 单据类型编号 同单据表TypeNum
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ExecDocsTypeCode { get; set; }
- /// <summary>
- /// 出入库标识 默认0 出库1 入库2
- /// </summary>
- [SugarColumn(ColumnDataType = "int", IsNullable = false)]
- public int InvInOut { get; set; }
- /// <summary>
- /// 执行人
- /// </summary>
- [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
- public string ExecWho { get; set; }
- /// <summary>
- /// 执行时间
- /// </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>
- /// 入库条码号 FJ材料号
- /// </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>
- /// 暂定
- /// </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; }
- }
- }
|