BILL_SAPORDERITEM.cs 12 KB

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