FbsMomOrderdetail.java 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512
  1. package org.jeecg.modules.fbsMomOrder.entity;
  2. import java.io.Serializable;
  3. import java.util.Date;
  4. import com.baomidou.mybatisplus.annotation.IdType;
  5. import com.baomidou.mybatisplus.annotation.TableField;
  6. import com.baomidou.mybatisplus.annotation.TableId;
  7. import com.baomidou.mybatisplus.annotation.TableName;
  8. import lombok.Data;
  9. import com.fasterxml.jackson.annotation.JsonFormat;
  10. import org.springframework.format.annotation.DateTimeFormat;
  11. import org.jeecgframework.poi.excel.annotation.Excel;
  12. /**
  13. * @Description: 生产订单子表
  14. * @author: jeecg-boot
  15. * @date: 2020-10-16
  16. * @version: V1.0
  17. */
  18. @Data
  19. @TableName("mom_orderdetail")
  20. public class FbsMomOrderdetail implements Serializable {
  21. private static final long serialVersionUID = 1L;
  22. /**id*/
  23. @Excel(name = "id", width = 15)
  24. @TableField(exist = false)
  25. private String id;
  26. /**modid*/
  27. @Excel(name = "modid", width = 15)
  28. private String modid;
  29. // private Integer modid;SAP-update
  30. /**moid*/
  31. @Excel(name = "moid", width = 15)
  32. private String moid;
  33. // private Integer moid;SAP-update
  34. /**sortseq*/
  35. @Excel(name = "sortseq", width = 15)
  36. private Integer sortseq;
  37. /**moclass*/
  38. @Excel(name = "moclass", width = 15)
  39. private Integer moclass;
  40. /**motypeid*/
  41. @Excel(name = "motypeid", width = 15)
  42. private Integer motypeid;
  43. /**qty*/
  44. @Excel(name = "qty", width = 15)
  45. private Object qty;
  46. /**mrpqty*/
  47. @Excel(name = "mrpqty", width = 15)
  48. private Object mrpqty;
  49. /**auxunitcode*/
  50. @Excel(name = "auxunitcode", width = 15)
  51. private String auxunitcode;
  52. /**auxqty*/
  53. @Excel(name = "auxqty", width = 15)
  54. private Object auxqty;
  55. /**changerate*/
  56. @Excel(name = "changerate", width = 15)
  57. private Object changerate;
  58. /**molotcode*/
  59. @Excel(name = "molotcode", width = 15)
  60. private String molotcode;
  61. /**whcode*/
  62. @Excel(name = "whcode", width = 15)
  63. private String whcode;
  64. /**mdeptcode*/
  65. @Excel(name = "mdeptcode", width = 15)
  66. private String mdeptcode;
  67. /**sotype*/
  68. @Excel(name = "sotype", width = 15)
  69. private Integer sotype;
  70. /**sodid*/
  71. @Excel(name = "sodid", width = 15)
  72. private String sodid;
  73. /**socode*/
  74. @Excel(name = "socode", width = 15)
  75. private String socode;
  76. /**soseq*/
  77. @Excel(name = "soseq", width = 15)
  78. private Integer soseq;
  79. /**declaredqty*/
  80. @Excel(name = "declaredqty", width = 15)
  81. private Object declaredqty;
  82. /**qualifiedinqty*/
  83. @Excel(name = "qualifiedinqty", width = 15)
  84. private Object qualifiedinqty;
  85. /**status*/
  86. @Excel(name = "status", width = 15)
  87. private Integer status;
  88. /**orgstatus*/
  89. @Excel(name = "orgstatus", width = 15)
  90. private Integer orgstatus;
  91. /**bomid*/
  92. @Excel(name = "bomid", width = 15)
  93. private Integer bomid;
  94. /**routingid*/
  95. @Excel(name = "routingid", width = 15)
  96. private Integer routingid;
  97. /**custbomid*/
  98. @Excel(name = "custbomid", width = 15)
  99. private Integer custbomid;
  100. /**demandid*/
  101. @Excel(name = "demandid", width = 15)
  102. private Integer demandid;
  103. /**plancode*/
  104. @Excel(name = "plancode", width = 15)
  105. private String plancode;
  106. /**partid*/
  107. @Excel(name = "partid", width = 15)
  108. private Integer partid;
  109. /**invcode*/
  110. @Excel(name = "invcode", width = 15)
  111. private String invcode;
  112. /**free1*/
  113. @Excel(name = "free1", width = 15)
  114. private String free1;
  115. /**free2*/
  116. @Excel(name = "free2", width = 15)
  117. private String free2;
  118. /**free3*/
  119. @Excel(name = "free3", width = 15)
  120. private String free3;
  121. /**free4*/
  122. @Excel(name = "free4", width = 15)
  123. private String free4;
  124. /**free5*/
  125. @Excel(name = "free5", width = 15)
  126. private String free5;
  127. /**free6*/
  128. @Excel(name = "free6", width = 15)
  129. private String free6;
  130. /**free7*/
  131. @Excel(name = "free7", width = 15)
  132. private String free7;
  133. /**free8*/
  134. @Excel(name = "free8", width = 15)
  135. private String free8;
  136. /**free9*/
  137. @Excel(name = "free9", width = 15)
  138. private String free9;
  139. /**free10*/
  140. @Excel(name = "free10", width = 15)
  141. private String free10;
  142. /**sfcflag*/
  143. @Excel(name = "sfcflag", width = 15)
  144. private Object sfcflag;
  145. /**crpflag*/
  146. @Excel(name = "crpflag", width = 15)
  147. private Object crpflag;
  148. /**qcflag*/
  149. @Excel(name = "qcflag", width = 15)
  150. private Object qcflag;
  151. /**relsdate*/
  152. @Excel(name = "relsdate", width = 20, format = "yyyy-MM-dd HH:mm:ss")
  153. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
  154. @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
  155. private Date relsdate;
  156. /**relsuser*/
  157. @Excel(name = "relsuser", width = 15)
  158. private String relsuser;
  159. /**closedate*/
  160. @Excel(name = "closedate", width = 20, format = "yyyy-MM-dd HH:mm:ss")
  161. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
  162. @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
  163. private Date closedate;
  164. /**orgclsdate*/
  165. @Excel(name = "orgclsdate", width = 20, format = "yyyy-MM-dd HH:mm:ss")
  166. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
  167. @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
  168. private Date orgclsdate;
  169. /**ufts*/
  170. private Date ufts;
  171. /**define22*/
  172. @Excel(name = "define22", width = 15)
  173. private String define22;
  174. /**define23*/
  175. @Excel(name = "define23", width = 15)
  176. private String define23;
  177. /**define24*/
  178. @Excel(name = "define24", width = 15)
  179. private String define24;
  180. /**define25*/
  181. @Excel(name = "define25", width = 15)
  182. private String define25;
  183. /**define26*/
  184. @Excel(name = "define26", width = 15)
  185. private Float define26;
  186. /**define27*/
  187. @Excel(name = "define27", width = 15)
  188. private Float define27;
  189. /**define28*/
  190. @Excel(name = "define28", width = 15)
  191. private String define28;
  192. /**define29*/
  193. @Excel(name = "define29", width = 15)
  194. private String define29;
  195. /**define30*/
  196. @Excel(name = "define30", width = 15)
  197. private String define30;
  198. /**define31*/
  199. @Excel(name = "define31", width = 15)
  200. private String define31;
  201. /**define32*/
  202. @Excel(name = "define32", width = 15)
  203. private String define32;
  204. /**define33*/
  205. @Excel(name = "define33", width = 15)
  206. private String define33;
  207. /**define34*/
  208. @Excel(name = "define34", width = 15)
  209. private Integer define34;
  210. /**define35*/
  211. @Excel(name = "define35", width = 15)
  212. private Integer define35;
  213. /**define36*/
  214. @Excel(name = "define36", width = 20, format = "yyyy-MM-dd HH:mm:ss")
  215. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
  216. @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
  217. private Date define36;
  218. /**define37*/
  219. @Excel(name = "define37", width = 20, format = "yyyy-MM-dd HH:mm:ss")
  220. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
  221. @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
  222. private Date define37;
  223. /**leadtime*/
  224. @Excel(name = "leadtime", width = 15)
  225. private Integer leadtime;
  226. /**opscheduletype*/
  227. @Excel(name = "opscheduletype", width = 15)
  228. private Integer opscheduletype;
  229. /**ordflag*/
  230. @Excel(name = "ordflag", width = 15)
  231. private Object ordflag;
  232. /**wiptype*/
  233. @Excel(name = "wiptype", width = 15)
  234. private Integer wiptype;
  235. /**supplywhcode*/
  236. @Excel(name = "supplywhcode", width = 15)
  237. private String supplywhcode;
  238. /**reasoncode*/
  239. @Excel(name = "reasoncode", width = 15)
  240. private String reasoncode;
  241. /**iswfcontrolled*/
  242. @Excel(name = "iswfcontrolled", width = 15)
  243. private Integer iswfcontrolled;
  244. /**iverifystate*/
  245. @Excel(name = "iverifystate", width = 15)
  246. private Integer iverifystate;
  247. /**ireturncount*/
  248. @Excel(name = "ireturncount", width = 15)
  249. private Integer ireturncount;
  250. /**remark*/
  251. @Excel(name = "remark", width = 15)
  252. private String remark;
  253. /**sourcemocode*/
  254. @Excel(name = "sourcemocode", width = 15)
  255. private String sourcemocode;
  256. /**sourcemoseq*/
  257. @Excel(name = "sourcemoseq", width = 15)
  258. private Integer sourcemoseq;
  259. /**sourcemoid*/
  260. @Excel(name = "sourcemoid", width = 15)
  261. private Integer sourcemoid;
  262. /**sourcemodid*/
  263. @Excel(name = "sourcemodid", width = 15)
  264. private Integer sourcemodid;
  265. /**sourceqccode*/
  266. @Excel(name = "sourceqccode", width = 15)
  267. private String sourceqccode;
  268. /**sourceqcid*/
  269. @Excel(name = "sourceqcid", width = 15)
  270. private Integer sourceqcid;
  271. /**sourceqcdid*/
  272. @Excel(name = "sourceqcdid", width = 15)
  273. private Integer sourceqcdid;
  274. /**costitemcode*/
  275. @Excel(name = "costitemcode", width = 15)
  276. private String costitemcode;
  277. /**costitemname*/
  278. @Excel(name = "costitemname", width = 15)
  279. private String costitemname;
  280. /**relstime*/
  281. @Excel(name = "relstime", width = 20, format = "yyyy-MM-dd HH:mm:ss")
  282. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
  283. @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
  284. private Date relstime;
  285. /**closeuser*/
  286. @Excel(name = "closeuser", width = 15)
  287. private String closeuser;
  288. /**closetime*/
  289. @Excel(name = "closetime", width = 20, format = "yyyy-MM-dd HH:mm:ss")
  290. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
  291. @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
  292. private Date closetime;
  293. /**orgclstime*/
  294. @Excel(name = "orgclstime", width = 20, format = "yyyy-MM-dd HH:mm:ss")
  295. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd HH:mm:ss")
  296. @DateTimeFormat(pattern="yyyy-MM-dd HH:mm:ss")
  297. private Date orgclstime;
  298. /**auditstatus*/
  299. @Excel(name = "auditstatus", width = 15)
  300. private Integer auditstatus;
  301. /**pallocateid*/
  302. @Excel(name = "pallocateid", width = 15)
  303. private Integer pallocateid;
  304. /**demandcode*/
  305. @Excel(name = "demandcode", width = 15)
  306. private String demandcode;
  307. /**collectiveflag*/
  308. @Excel(name = "collectiveflag", width = 15)
  309. private Integer collectiveflag;
  310. /**ordertype*/
  311. @Excel(name = "ordertype", width = 15)
  312. private Integer ordertype;
  313. /**orderdid*/
  314. @Excel(name = "orderdid", width = 15)
  315. private Integer orderdid;
  316. /**ordercode*/
  317. @Excel(name = "ordercode", width = 15)
  318. private String ordercode;
  319. /**orderseq*/
  320. @Excel(name = "orderseq", width = 15)
  321. private Integer orderseq;
  322. /**manualcode*/
  323. @Excel(name = "manualcode", width = 15)
  324. private String manualcode;
  325. /**reformflag*/
  326. @Excel(name = "reformflag", width = 15)
  327. private Object reformflag;
  328. /**sourceqcvouchtype*/
  329. @Excel(name = "sourceqcvouchtype", width = 15)
  330. private Integer sourceqcvouchtype;
  331. /**orgqty*/
  332. @Excel(name = "orgqty", width = 15)
  333. private Object orgqty;
  334. /**fmflag*/
  335. @Excel(name = "fmflag", width = 15)
  336. private Object fmflag;
  337. /**minsn*/
  338. @Excel(name = "minsn", width = 15)
  339. private String minsn;
  340. /**maxsn*/
  341. @Excel(name = "maxsn", width = 15)
  342. private String maxsn;
  343. /**sourcesvccode*/
  344. @Excel(name = "sourcesvccode", width = 15)
  345. private String sourcesvccode;
  346. /**sourcesvcid*/
  347. @Excel(name = "sourcesvcid", width = 15)
  348. private String sourcesvcid;
  349. /**sourcesvcdid*/
  350. @Excel(name = "sourcesvcdid", width = 15)
  351. private String sourcesvcdid;
  352. /**bomtype*/
  353. @Excel(name = "bomtype", width = 15)
  354. private Integer bomtype;
  355. /**routingtype*/
  356. @Excel(name = "routingtype", width = 15)
  357. private Integer routingtype;
  358. /**busflowid*/
  359. @Excel(name = "busflowid", width = 15)
  360. private Integer busflowid;
  361. /**runcardflag*/
  362. @Excel(name = "runcardflag", width = 15)
  363. private Object runcardflag;
  364. /**requisitionflag*/
  365. @Excel(name = "requisitionflag", width = 15)
  366. private Object requisitionflag;
  367. /**allovtid*/
  368. @Excel(name = "allovtid", width = 15)
  369. private Integer allovtid;
  370. /**relsallovtid*/
  371. @Excel(name = "relsallovtid", width = 15)
  372. private Integer relsallovtid;
  373. /**iprintcount*/
  374. @Excel(name = "iprintcount", width = 15)
  375. private Integer iprintcount;
  376. /**cbsysbarcode*/
  377. @Excel(name = "cbsysbarcode", width = 15)
  378. private String cbsysbarcode;
  379. /**ccurrentauditor*/
  380. @Excel(name = "ccurrentauditor", width = 15)
  381. private String ccurrentauditor;
  382. /**custcode*/
  383. @Excel(name = "custcode", width = 15)
  384. private String custcode;
  385. /**lplancode*/
  386. @Excel(name = "lplancode", width = 15)
  387. private String lplancode;
  388. /**sourcesvcvouchtype*/
  389. @Excel(name = "sourcesvcvouchtype", width = 15)
  390. private Integer sourcesvcvouchtype;
  391. /**factorycode*/
  392. @Excel(name = "factorycode", width = 15)
  393. private String factorycode;
  394. //产品名称
  395. @TableField(exist = false)
  396. private String cinvname;
  397. //产品编码
  398. @TableField(exist = false)
  399. private String cinvcode;
  400. //产品规格
  401. @TableField(exist = false)
  402. private String cinvstd;
  403. //生产订单号
  404. @TableField(exist = false)
  405. private String mocode;
  406. //总数量
  407. @TableField(exist = false)
  408. private Integer total;
  409. //总料数
  410. @TableField(exist = false)
  411. private Integer materialPreparationTotal;
  412. //备料数量
  413. @TableField(exist = false)
  414. private Integer materialPreparationNumber;
  415. //未完成数量
  416. @TableField(exist = false)
  417. private Integer unfinishedQuantity;
  418. //应领数量
  419. @TableField(exist = false)
  420. private Integer qtys;
  421. //已领数量
  422. @TableField(exist = false)
  423. private Integer issQty;
  424. //缺料数量
  425. @TableField(exist = false)
  426. private Integer shortageQuantity;
  427. //项目名称
  428. @TableField(exist = false)
  429. private String define12;
  430. //申请人
  431. @TableField(exist = false)
  432. private String cmaker;
  433. //部门名称
  434. @TableField(exist = false)
  435. private String cdepName;
  436. //领料时间
  437. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
  438. @DateTimeFormat(pattern="yyyy-MM-dd")
  439. @TableField(exist = false)
  440. private Date ddate;
  441. //标准工时
  442. @TableField(exist = false)
  443. private String cinvDefine13;
  444. //已投入工时
  445. @TableField(exist = false)
  446. private String manHoursInvested;
  447. //年月标识 查询当月订单用
  448. @TableField(exist = false)
  449. private String yearMonth;
  450. //产品名称
  451. @TableField(exist = false)
  452. private String mocinvname;
  453. //子子件物料名称
  454. @TableField(exist = false)
  455. private String mcinvname;
  456. //子子件物料编码
  457. @TableField(exist = false)
  458. private String mcinvcode;
  459. //子件物料编码
  460. @TableField(exist = false)
  461. private String mInvCode;
  462. //erp开工时间
  463. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
  464. @DateTimeFormat(pattern="yyyy-MM-dd")
  465. @TableField(exist = false)
  466. private Date startDate;
  467. //rep完工时间
  468. @JsonFormat(timezone = "GMT+8",pattern = "yyyy-MM-dd")
  469. @DateTimeFormat(pattern="yyyy-MM-dd")
  470. @TableField(exist = false)
  471. private Date dueDate;
  472. @TableField(exist = false)
  473. private Object modQty;
  474. //项目编码
  475. @TableField(exist = false)
  476. private String costItemCode;
  477. //项目编码
  478. @TableField(exist = false)
  479. private String itemCode;
  480. //工作中心
  481. @TableField(exist = false)
  482. private String workCenter;
  483. //工艺顺序
  484. @TableField(exist = false)
  485. private String processSequence;
  486. //工艺id
  487. @TableField(exist = false)
  488. private String fbsTechnologicalProcessId;
  489. // @TableField(exist = false)
  490. // private String sortseq;
  491. @TableField(exist = false)
  492. private String SAPStatus;
  493. //工艺名称
  494. @TableField(exist = false)
  495. private String fbsTechnologicalProcessName;
  496. }