BILL_ORDERITEM.cs 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475
  1. using System;
  2. using System.Linq;
  3. using System.Text;
  4. using SqlSugar;
  5. namespace WMS.Core
  6. {
  7. ///<summary>
  8. ///
  9. ///</summary>
  10. [SugarTable("BILL_ORDERITEM")]
  11. public partial class BILL_ORDERITEM
  12. {
  13. public BILL_ORDERITEM()
  14. {
  15. }
  16. /// <summary>
  17. /// Desc:单据行
  18. /// Default:
  19. /// Nullable:False
  20. /// </summary>
  21. [SugarColumn(IsPrimaryKey = true)]
  22. public string F_ROWNO { get; set; }
  23. /// <summary>
  24. /// Desc:是否停用
  25. /// Default:
  26. /// Nullable:False
  27. /// </summary>
  28. public int F_ISSTOP { get; set; }
  29. /// <summary>
  30. /// Desc:是否删除
  31. /// Default:
  32. /// Nullable:False
  33. /// </summary>
  34. public int F_ISDELETE { get; set; }
  35. /// <summary>
  36. /// Desc:外部行号
  37. /// Default:
  38. /// Nullable:True
  39. /// </summary>
  40. public string F_OUTLINENO { get; set; }
  41. /// <summary>
  42. /// Desc:工厂
  43. /// Default:
  44. /// Nullable:True
  45. /// </summary>
  46. public string F_WERKS { get; set; }
  47. /// <summary>
  48. /// Desc:库存地点
  49. /// Default:
  50. /// Nullable:True
  51. /// </summary>
  52. public string F_LGORT { get; set; }
  53. /// <summary>
  54. /// Desc:项目类型
  55. /// Default:
  56. /// Nullable:True
  57. /// </summary>
  58. public string F_OUTLINETYPE { get; set; }
  59. /// <summary>
  60. /// Desc:订单编号
  61. /// Default:
  62. /// Nullable:True
  63. /// </summary>
  64. public string F_ORDERNO { get; set; }
  65. /// <summary>
  66. /// Desc:来源单号
  67. /// Default:
  68. /// Nullable:True
  69. /// </summary>
  70. public string F_FROMORDERNO { get; set; }
  71. /// <summary>
  72. /// Desc:来源行项目
  73. /// Default:
  74. /// Nullable:True
  75. /// </summary>
  76. public string F_FROMORDERITEMNO { get; set; }
  77. /// <summary>
  78. /// Desc:物料编号
  79. /// Default:
  80. /// Nullable:True
  81. /// </summary>
  82. public string F_MATNO { get; set; }
  83. /// <summary>
  84. /// Desc:物料名称
  85. /// Default:
  86. /// Nullable:True
  87. /// </summary>
  88. public string F_MATNAME { get; set; }
  89. /// <summary>
  90. /// Desc:物料类型
  91. /// Default:
  92. /// Nullable:False
  93. /// </summary>
  94. public int F_MATTYPENUM { get; set; }
  95. /// <summary>
  96. /// Desc:物料状态
  97. /// Default:
  98. /// Nullable:True
  99. /// </summary>
  100. public int F_MATSTATENUM { get; set; } = 0;
  101. /// <summary>
  102. /// Desc:移动类型
  103. /// Default:
  104. /// Nullable:True
  105. /// </summary>
  106. public string F_MOVETYPE { get; set; }
  107. /// <summary>
  108. /// Desc:物料条码
  109. /// Default:
  110. /// Nullable:True
  111. /// </summary>
  112. public string F_MATBARCODE { get; set; }
  113. /// <summary>
  114. /// Desc:工位编号
  115. /// Default:
  116. /// Nullable:True
  117. /// </summary>
  118. public string F_WORKPOSNO { get; set; }
  119. /// <summary>
  120. /// Desc:工位名称
  121. /// Default:
  122. /// Nullable:True
  123. /// </summary>
  124. public string F_WORKPOSNAME { get; set; }
  125. /// <summary>
  126. /// Desc:AGV站点
  127. /// Default:
  128. /// Nullable:True
  129. /// </summary>
  130. public string F_AGVWORK { get; set; }
  131. /// <summary>
  132. /// Desc:产线编号
  133. /// Default:
  134. /// Nullable:True
  135. /// </summary>
  136. public string F_PROLINENO { get; set; }
  137. /// <summary>
  138. /// Desc:产线名称
  139. /// Default:
  140. /// Nullable:True
  141. /// </summary>
  142. public string F_PROLINENAME { get; set; }
  143. /// <summary>
  144. /// Desc:批次号
  145. /// Default:
  146. /// Nullable:True
  147. /// </summary>
  148. public string F_BATCHNO { get; set; }
  149. /// <summary>
  150. /// Desc:版本号
  151. /// Default:
  152. /// Nullable:True
  153. /// </summary>
  154. public string F_VERSION { get; set; }
  155. /// <summary>
  156. /// Desc:档位
  157. /// Default:
  158. /// Nullable:True
  159. /// </summary>
  160. public string F_GEAR { get; set; }
  161. /// <summary>
  162. /// Desc:单位编号
  163. /// Default:
  164. /// Nullable:True
  165. /// </summary>
  166. public string F_UNITNO { get; set; }
  167. /// <summary>
  168. /// Desc:单位名称
  169. /// Default:
  170. /// Nullable:True
  171. /// </summary>
  172. public string F_UNITNAME { get; set; }
  173. /// <summary>
  174. /// Desc:计划量
  175. /// Default:
  176. /// Nullable:False
  177. /// </summary>
  178. public decimal F_FQTY { get; set; }
  179. /// <summary>
  180. /// Desc:实际量
  181. /// Default:
  182. /// Nullable:False
  183. /// </summary>
  184. public decimal F_AQTY { get; set; }
  185. /// <summary>
  186. /// Desc:已扫描入库量
  187. /// Default:
  188. /// Nullable:False
  189. /// </summary>
  190. public decimal F_CQTY { get; set; }
  191. /// <summary>
  192. /// Desc:上传量
  193. /// Default:
  194. /// Nullable:False
  195. /// </summary>
  196. public decimal F_UQTY { get; set; }
  197. /// <summary>
  198. /// Desc:mes使用
  199. /// Default:
  200. /// Nullable:False
  201. /// </summary>
  202. public decimal F_SQTY { get; set; }
  203. /// <summary>
  204. /// Desc:备注
  205. /// Default:
  206. /// Nullable:True
  207. /// </summary>
  208. public string F_MEMO { get; set; }
  209. /// <summary>
  210. /// Desc:创建用户编号
  211. /// Default:
  212. /// Nullable:False
  213. /// </summary>
  214. public string F_ADDUSERNO { get; set; }
  215. /// <summary>
  216. /// Desc:创建时间
  217. /// Default:
  218. /// Nullable:False
  219. /// </summary>
  220. public DateTime F_ADDTIME { get; set; }
  221. /// <summary>
  222. /// Desc:编辑用户编号
  223. /// Default:
  224. /// Nullable:False
  225. /// </summary>
  226. public string F_EDITUSERNO { get; set; }
  227. /// <summary>
  228. /// Desc:编辑时间
  229. /// Default:
  230. /// Nullable:False
  231. /// </summary>
  232. public DateTime? F_EDITTIME { get; set; }
  233. /// <summary>
  234. /// Desc:生产工单
  235. /// Default:
  236. /// Nullable:True
  237. /// </summary>
  238. public string F_DEFINE01 { get; set; }
  239. /// <summary>
  240. /// Desc:生产工单ID
  241. /// Default:
  242. /// Nullable:True
  243. /// </summary>
  244. public string F_DEFINE02 { get; set; }
  245. /// <summary>
  246. /// Desc:成品编号
  247. /// Default:
  248. /// Nullable:True
  249. /// </summary>
  250. public string F_DEFINE03 { get; set; }
  251. /// <summary>
  252. /// Desc:质检批
  253. /// Default:
  254. /// Nullable:True
  255. /// </summary>
  256. public string F_DEFINE04 { get; set; }
  257. /// <summary>
  258. /// Desc:质检ID
  259. /// Default:
  260. /// Nullable:True
  261. /// </summary>
  262. public string F_DEFINE05 { get; set; }
  263. /// <summary>
  264. /// Desc:原单位
  265. /// Default:
  266. /// Nullable:True
  267. /// </summary>
  268. public string F_DEFINE06 { get; set; }
  269. /// <summary>
  270. /// Desc:原数量
  271. /// Default:
  272. /// Nullable:True
  273. /// </summary>
  274. public string F_DEFINE07 { get; set; }
  275. /// <summary>
  276. /// Desc:条码
  277. /// Default:
  278. /// Nullable:True
  279. /// </summary>
  280. public string F_DEFINE08 { get; set; }
  281. /// <summary>
  282. /// Desc:备料数量
  283. /// Default:
  284. /// Nullable:True
  285. /// </summary>
  286. public string F_DEFINE09 { get; set; }
  287. /// <summary>
  288. /// Desc:EXECL 导入时,返回的错误信息
  289. /// Default:
  290. /// Nullable:True
  291. /// </summary>
  292. public string F_DEFINE10 { get; set; }
  293. /// <summary>
  294. /// Desc:包装方式
  295. /// Default:
  296. /// Nullable:True
  297. /// </summary>
  298. public string F_PACKMETHOD { get; set; }
  299. /// <summary>
  300. /// Desc:成本中心
  301. /// Default:
  302. /// Nullable:True
  303. /// </summary>
  304. public string F_COST { get; set; }
  305. /// <summary>
  306. /// Desc:
  307. /// Default:
  308. /// Nullable:False
  309. /// </summary>
  310. public decimal F_LOCKSTATUS { get; set; }
  311. /// <summary>
  312. /// Desc:
  313. /// Default:
  314. /// Nullable:True
  315. /// </summary>
  316. public string F_LOCKUSER { get; set; }
  317. /// <summary>
  318. /// Desc:
  319. /// Default:
  320. /// Nullable:True
  321. /// </summary>
  322. public DateTime? F_LOCKTIME { get; set; }
  323. /// <summary>
  324. /// Desc:供应商编码
  325. /// Default:
  326. /// Nullable:True
  327. /// </summary>
  328. public string F_SUPPLIERNO { get; set; }
  329. /// <summary>
  330. /// Desc:供应商名称
  331. /// Default:
  332. /// Nullable:True
  333. /// </summary>
  334. public string F_SUPPLIERNAME { get; set; }
  335. /// <summary>
  336. /// Desc:
  337. /// Default:
  338. /// Nullable:True
  339. /// </summary>
  340. public string F_DEFINE11 { get; set; }
  341. /// <summary>
  342. /// Desc:
  343. /// Default:
  344. /// Nullable:True
  345. /// </summary>
  346. public string F_DEFINE12 { get; set; }
  347. /// <summary>
  348. /// Desc:
  349. /// Default:
  350. /// Nullable:True
  351. /// </summary>
  352. public string F_DEFINE13 { get; set; }
  353. /// <summary>
  354. /// Desc:
  355. /// Default:
  356. /// Nullable:True
  357. /// </summary>
  358. public string F_DEFINE14 { get; set; }
  359. /// <summary>
  360. /// Desc:
  361. /// Default:
  362. /// Nullable:True
  363. /// </summary>
  364. public string F_DEFINE15 { get; set; }
  365. /// <summary>
  366. /// Desc:
  367. /// Default:
  368. /// Nullable:True
  369. /// </summary>
  370. public string F_DEFINE16 { get; set; }
  371. /// <summary>
  372. /// Desc:
  373. /// Default:
  374. /// Nullable:True
  375. /// </summary>
  376. public string F_DEFINE17 { get; set; }
  377. /// <summary>
  378. /// Desc:
  379. /// Default:
  380. /// Nullable:True
  381. /// </summary>
  382. public string F_DEFINE18 { get; set; }
  383. /// <summary>
  384. /// Desc:
  385. /// Default:
  386. /// Nullable:True
  387. /// </summary>
  388. public string F_DEFINE19 { get; set; }
  389. /// <summary>
  390. /// Desc:
  391. /// Default:
  392. /// Nullable:True
  393. /// </summary>
  394. public string F_DEFINE20 { get; set; }
  395. /// <summary>
  396. /// Desc:
  397. /// Default:
  398. /// Nullable:True
  399. /// </summary>
  400. public DateTime F_PROSTARTIME { get; set; } = DateTime.Now;
  401. /// <summary>
  402. /// Desc:
  403. /// Default:
  404. /// Nullable:True
  405. /// </summary>
  406. public DateTime F_PROENDTIME { get; set; } = DateTime.Now;
  407. }
  408. }