BillInvinit.cs 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451
  1. using SqlSugar;
  2. namespace WCS.WorkEngineering.Model.WMS
  3. {
  4. /// <summary>
  5. /// 条码表
  6. /// </summary>
  7. [Tenant("fj")]
  8. [SugarTable("Bill_InvInit")]
  9. public partial class BillInvinit : BaseModel
  10. {
  11. /// <summary>
  12. /// 仓库ID 关联仓库表 ID
  13. /// </summary>
  14. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  15. public long WarehouseId { get; set; }
  16. /// <summary>
  17. /// 组盘ID
  18. /// 创建条码表时生成 同库存表组盘ID ContGrpId
  19. /// </summary>
  20. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  21. public long ContGrpId { get; set; }
  22. /// <summary>
  23. /// 容器条码 同联容器表容器条码 ContBarCode
  24. /// </summary>
  25. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  26. public string ContGrpBarCode { get; set; }
  27. /// <summary>
  28. /// 箱条码
  29. /// </summary>
  30. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  31. public string BoxBarCode { get; set; }
  32. /// <summary>
  33. /// Bom单号 关联投料单 帘线工序工单号 BillCode
  34. /// </summary>
  35. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  36. public string BomDocsNo { get; set; }
  37. /// <summary>
  38. /// Bom物料ID
  39. /// </summary>
  40. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  41. public long BomMatId { get; set; }
  42. /// <summary>
  43. /// Bom物料编号
  44. /// </summary>
  45. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  46. public string BomMatCode { get; set; }
  47. /// <summary>
  48. /// Bom物料
  49. /// </summary>
  50. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  51. public string BomMatName { get; set; }
  52. /// <summary>
  53. /// 垛形主表 ID
  54. /// </summary>
  55. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  56. public long BomSetId { get; set; }
  57. /// <summary>
  58. /// 垛型编码
  59. /// </summary>
  60. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  61. public string SetGrpCode { get; set; }
  62. /// <summary>
  63. /// 库存状态码
  64. /// </summary>
  65. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  66. public string ExecStateCode { get; set; }
  67. /// <summary>
  68. /// 单据编号 关联单据表单据编号 DocsNo
  69. /// </summary>
  70. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  71. public string ExecDocsNo { get; set; }
  72. /// <summary>
  73. /// 单据行号
  74. /// </summary>
  75. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  76. public string ExecDocsRowNo { get; set; }
  77. /// <summary>
  78. /// 单据类型编号 同单据表TypeNum
  79. /// </summary>
  80. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  81. public string ExecDocsTypeCode { get; set; }
  82. /// <summary>
  83. /// 出入库标识
  84. /// </summary>
  85. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  86. public FJInvInOutType InvInOut { get; set; }
  87. /// <summary>
  88. /// 执行人
  89. /// </summary>
  90. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  91. public string ExecWho { get; set; }
  92. /// <summary>
  93. /// 执行时间
  94. /// </summary>
  95. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  96. public DateTime ExecTime { get; set; }
  97. /// <summary>
  98. /// 行
  99. /// </summary>
  100. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  101. public int PutRow { get; set; }
  102. /// <summary>
  103. /// 列
  104. /// </summary>
  105. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  106. public int PutCol { get; set; }
  107. /// <summary>
  108. /// 层
  109. /// </summary>
  110. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  111. public int PutLayer { get; set; }
  112. /// <summary>
  113. /// 入库条码号 FJ材料号
  114. /// </summary>
  115. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  116. public string InvBarCode { get; set; }
  117. /// <summary>
  118. /// 库存状态
  119. /// </summary>
  120. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  121. public string InvStateCode { get; set; }
  122. /// <summary>
  123. /// 入库单号
  124. /// </summary>
  125. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  126. public string InDocsNo { get; set; }
  127. /// <summary>
  128. /// 入库单行号
  129. /// </summary>
  130. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  131. public string InDocsRowNo { get; set; }
  132. /// <summary>
  133. /// 供应编号
  134. /// </summary>
  135. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  136. public string SuppCode { get; set; }
  137. /// <summary>
  138. /// 供应商名称
  139. /// </summary>
  140. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  141. public string SuppName { get; set; }
  142. /// <summary>
  143. /// 海关编号
  144. /// </summary>
  145. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  146. public string CustCode { get; set; }
  147. /// <summary>
  148. /// 海关名称
  149. /// </summary>
  150. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  151. public string CustName { get; set; }
  152. /// <summary>
  153. /// 物料ID
  154. /// </summary>
  155. [SugarColumn(ColumnDataType = "bigint", IsNullable = false)]
  156. public long MatId { get; set; }
  157. /// <summary>
  158. /// 物料编号
  159. /// </summary>
  160. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  161. public string MatCode { get; set; }
  162. /// <summary>
  163. /// 物料名称
  164. /// </summary>
  165. [SugarColumn(ColumnDataType = "nvarchar", Length = 100, IsNullable = true)]
  166. public string MatName { get; set; }
  167. /// <summary>
  168. /// 总重量
  169. /// </summary>
  170. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  171. public decimal TolWQty { get; set; }
  172. /// <summary>
  173. /// 净重
  174. /// </summary>
  175. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  176. public decimal NetWQty { get; set; }
  177. /// <summary>
  178. /// 皮重
  179. /// </summary>
  180. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  181. public decimal TareWQty { get; set; }
  182. /// <summary>
  183. /// 总长
  184. /// </summary>
  185. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  186. public decimal LengthQty { get; set; }
  187. /// <summary>
  188. /// 碳当量
  189. /// </summary>
  190. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  191. public decimal CaQty { get; set; }
  192. /// <summary>
  193. /// 销售总量
  194. /// </summary>
  195. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = false)]
  196. public decimal SolderQty { get; set; }
  197. /// <summary>
  198. /// 暂定
  199. /// </summary>
  200. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  201. public int ContUsageQty { get; set; }
  202. /// <summary>
  203. /// 批次号
  204. /// </summary>
  205. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  206. public string BatchNo { get; set; }
  207. /// <summary>
  208. /// 生产时间
  209. /// </summary>
  210. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  211. public DateTime ProductTime { get; set; }
  212. /// <summary>
  213. /// 第一次入库时间
  214. /// </summary>
  215. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  216. public DateTime OneInTime { get; set; }
  217. /// <summary>
  218. /// 盘条条码
  219. /// </summary>
  220. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  221. public string RodBarCode { get; set; }
  222. /// <summary>
  223. /// 工字轮条码
  224. /// </summary>
  225. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  226. public string HWBarCode { get; set; }
  227. /// <summary>
  228. /// RFID条码
  229. /// </summary>
  230. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  231. public string RFIDBarCode { get; set; }
  232. /// <summary>
  233. /// 材料号
  234. /// </summary>
  235. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  236. public string CLBarCode { get; set; }
  237. /// <summary>
  238. /// 工字轮条码类型
  239. /// </summary>
  240. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  241. public string HWTypeCode { get; set; }
  242. /// <summary>
  243. /// 炉号
  244. /// </summary>
  245. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  246. public string BoilerNo { get; set; }
  247. /// <summary>
  248. /// 包号
  249. /// </summary>
  250. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  251. public string PackNo { get; set; }
  252. /// <summary>
  253. /// 牌号
  254. /// </summary>
  255. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  256. public string BrandNo { get; set; }
  257. /// <summary>
  258. /// 执行标准
  259. /// </summary>
  260. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  261. public string ExecStd { get; set; }
  262. /// <summary>
  263. /// 许可证号
  264. /// </summary>
  265. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  266. public string LicenceCode { get; set; }
  267. /// <summary>
  268. /// 改手盘标记
  269. /// </summary>
  270. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  271. public bool IsSurplus { get; set; }
  272. /// <summary>
  273. /// 返工标记
  274. /// </summary>
  275. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  276. public bool IsRework { get; set; }
  277. /// <summary>
  278. /// 是否黑盘
  279. /// </summary>
  280. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  281. public bool IsBlack { get; set; }
  282. /// <summary>
  283. /// 是否芯股
  284. /// </summary>
  285. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  286. public bool IsCore { get; set; }
  287. /// <summary>
  288. /// 快投标记
  289. /// </summary>
  290. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  291. public bool IsFast { get; set; }
  292. /// <summary>
  293. /// 是否异常
  294. /// </summary>
  295. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  296. public bool IsFail { get; set; }
  297. /// <summary>
  298. /// 异常原因
  299. /// </summary>
  300. [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
  301. public string FailReason { get; set; }
  302. /// <summary>
  303. /// 单/双丝
  304. /// </summary>
  305. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  306. public string SilkTypeCode { get; set; }
  307. /// <summary>
  308. /// 等级
  309. /// </summary>
  310. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  311. public string Grade { get; set; }
  312. /// <summary>
  313. /// 是否退料
  314. /// </summary>
  315. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  316. public bool IsBack { get; set; }
  317. /// <summary>
  318. /// 退料原因
  319. /// </summary>
  320. [SugarColumn(ColumnDataType = "nvarchar", Length = 200, IsNullable = true)]
  321. public string BackReason { get; set; }
  322. /// <summary>
  323. /// 是否扭转检测
  324. /// </summary>
  325. [SugarColumn(ColumnDataType = "bit", IsNullable = false)]
  326. public bool IsTorsChk { get; set; }
  327. /// <summary>
  328. /// 扭转次数
  329. /// </summary>
  330. [SugarColumn(ColumnDataType = "int", IsNullable = false)]
  331. public int TorsChkQty { get; set; }
  332. /// <summary>
  333. /// 扭转检测时间
  334. /// </summary>
  335. [SugarColumn(ColumnDataType = "datetime", IsNullable = false)]
  336. public DateTime TorsChkTime { get; set; }
  337. /// <summary>
  338. /// 扭转检测结果值
  339. /// </summary>
  340. [SugarColumn(ColumnDataType = "decimal", Length = 18, IsNullable = true)]
  341. public decimal? TorsChkValue { get; set; }
  342. /// <summary>
  343. /// 扭转检测设备号
  344. /// </summary>
  345. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  346. public string TorsChkMachCode { get; set; }
  347. /// <summary>
  348. /// 工序订单号
  349. /// </summary>
  350. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  351. public string ProcessDocsCode { get; set; }
  352. /// <summary>
  353. /// 生产机台号
  354. /// </summary>
  355. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  356. public string ProductMachCode { get; set; }
  357. /// <summary>
  358. /// 生成产线号
  359. /// </summary>
  360. [SugarColumn(ColumnDataType = "nvarchar", Length = 50, IsNullable = true)]
  361. public string ProductLineNo { get; set; }
  362. /// <summary>
  363. /// 货物大小
  364. /// </summary>
  365. [SugarColumn(IsNullable = false)]
  366. public int Size { get; set; }
  367. /// <summary>
  368. /// 托盘类型
  369. /// </summary>
  370. [SugarColumn(IsNullable = true, ColumnDescription = "托盘类型")]
  371. public FJPalletType PalletType { get; set; }
  372. /// <summary>
  373. /// 组盘类型
  374. /// </summary>
  375. [SugarColumn(IsNullable = true)]
  376. public FJContGrpType ContGrpType { get; set; }
  377. }
  378. }