ic_item.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950
  1. using Business.Core.Attributes;
  2. using Microsoft.EntityFrameworkCore;
  3. using System;
  4. using System.ComponentModel;
  5. using System.ComponentModel.DataAnnotations;
  6. namespace Business.Domain
  7. {
  8. /// <summary>
  9. /// 物料详情
  10. /// </summary>
  11. [CollectionName("dopbase", "ic_item")]
  12. [Comment("物料详情")]
  13. [Index(nameof(number), nameof(fversion), nameof(tenant_id), nameof(company_id), nameof(factory_id), IsUnique = true)]
  14. public class ic_item : BaseEntity
  15. {
  16. public ic_item(long Id) : base(Id)
  17. {
  18. }
  19. /// <summary>
  20. /// 物料编码
  21. /// </summary>
  22. [StringLength(80)]
  23. [Comment("物料编码")]
  24. public string number { get; set; }
  25. /// <summary>
  26. /// 物料名称
  27. /// </summary>
  28. [StringLength(80)]
  29. [Comment("物料名称")]
  30. public string name { get; set; }
  31. /// <summary>
  32. /// 规格型号
  33. /// </summary>
  34. [StringLength(200)]
  35. [Comment("规格型号")]
  36. public string model { get; set; }
  37. /// <summary>
  38. /// 全名
  39. /// </summary>
  40. [StringLength(255)]
  41. [Comment("全名")]
  42. public string full_name { get; set; }
  43. /// <summary>
  44. /// fms旧料号
  45. /// </summary>
  46. [StringLength(80)]
  47. [Comment("fms旧料号")]
  48. public string fms_number { get; set; }
  49. /// <summary>
  50. /// erp旧料号
  51. /// </summary>
  52. [StringLength(80)]
  53. [Comment("erp旧料号")]
  54. public string erp_oldnumber { get; set; }
  55. /// <summary>
  56. /// 图号
  57. /// </summary>
  58. [StringLength(80)]
  59. [Comment("图号")]
  60. public string chart_number { get; set; }
  61. /// <summary>
  62. /// 版本号
  63. /// </summary>
  64. [StringLength(80)]
  65. [Comment("版本号")]
  66. public string fversion { get; set; }
  67. /// <summary>
  68. /// 盒贴规格
  69. /// </summary>
  70. [StringLength(200)]
  71. [Comment("盒贴规格")]
  72. public string box_model { get; set; }
  73. /// <summary>
  74. /// 物料属性
  75. /// </summary>
  76. [Comment("物料属性")]
  77. public int? erp_cls { get; set; }
  78. /// <summary>
  79. /// 物料属性名称
  80. /// </summary>
  81. [StringLength(80)]
  82. [Comment("物料属性")]
  83. public string erp_cls_name { get; set; }
  84. /// <summary>
  85. /// 单位
  86. /// </summary>
  87. [StringLength(80)]
  88. [Comment("单位")]
  89. public string unit { get; set; }
  90. /// <summary>
  91. /// 物料等级
  92. /// </summary>
  93. [Comment("物料等级")]
  94. public long? item_level { get; set; }
  95. /// <summary>
  96. /// 单位标准工时_小时
  97. /// </summary>
  98. [Precision(23, 10)]
  99. [Comment("单位标准工时_小时")]
  100. public decimal? standard_manhour { get; set; }
  101. /// <summary>
  102. /// 单位材料定额_元
  103. /// </summary>
  104. [Precision(23, 10)]
  105. [Comment("单位材料定额_元")]
  106. public decimal? unititem_amount { get; set; }
  107. /// <summary>
  108. /// 来源
  109. /// </summary>
  110. [StringLength(200)]
  111. [Comment("来源")]
  112. public string? source { get; set; }
  113. /// <summary>
  114. /// 是否为设备
  115. /// </summary>
  116. [Comment("是否为设备")]
  117. public int? is_equipment { get; set; }
  118. /// <summary>
  119. /// 单位包装数量
  120. /// </summary>
  121. [Precision(23, 10)]
  122. [Comment("单位包装数量")]
  123. public decimal? unit_qty { get; set; }
  124. /// <summary>
  125. /// 是否关键件
  126. /// </summary>
  127. [Comment("是否关键件")]
  128. public int? iskeyitem { get; set; }
  129. /// <summary>
  130. /// 毛重
  131. /// </summary>
  132. [Precision(23, 10)]
  133. [Comment("毛重")]
  134. public decimal? gross_weight { get; set; }
  135. /// <summary>
  136. /// 净重
  137. /// </summary>
  138. [Precision(23, 10)]
  139. [Comment("净重")]
  140. public decimal? net_weight { get; set; }
  141. /// <summary>
  142. /// 重量单位
  143. /// </summary>
  144. [StringLength(80)]
  145. [Comment("重量单位")]
  146. public string maund { get; set; }
  147. /// <summary>
  148. /// 长度
  149. /// </summary>
  150. [Precision(23, 10)]
  151. [Comment("长度")]
  152. public decimal? length { get; set; }
  153. /// <summary>
  154. /// 长度单位
  155. /// </summary>
  156. [StringLength(80)]
  157. [Comment("长度单位")]
  158. public string cubic_measure { get; set; }
  159. /// <summary>
  160. /// 宽度
  161. /// </summary>
  162. [Precision(23, 10)]
  163. [Comment("宽度")]
  164. public decimal? width { get; set; }
  165. /// <summary>
  166. /// 高度
  167. /// </summary>
  168. [Precision(23, 10)]
  169. [Comment("高度")]
  170. public decimal? height { get; set; }
  171. /// <summary>
  172. /// 体积
  173. /// </summary>
  174. [Precision(23, 10)]
  175. [Comment("体积")]
  176. public decimal? size { get; set; }
  177. /// <summary>
  178. /// 允许采购
  179. /// </summary>
  180. [Comment("允许采购")]
  181. public int? allowpur { get; set; }
  182. /// <summary>
  183. /// 允许销售
  184. /// </summary>
  185. [Comment("允许销售")]
  186. public int? allowsale { get; set; }
  187. /// <summary>
  188. /// 允许生产
  189. /// </summary>
  190. [Comment("允许生产")]
  191. public int? allowmanu { get; set; }
  192. /// <summary>
  193. /// 允许委外
  194. /// </summary>
  195. [Comment("允许委外")]
  196. public int? allowout { get; set; }
  197. /// <summary>
  198. /// 批号管理
  199. /// </summary>
  200. [Comment("批号管理")]
  201. public int? allowbatch { get; set; }
  202. /// <summary>
  203. /// 序列号管理
  204. /// </summary>
  205. [Comment("序列号管理")]
  206. public int? allowserial { get; set; }
  207. /// <summary>
  208. /// 图片
  209. /// </summary>
  210. [StringLength(80)]
  211. [Comment("图片")]
  212. public string photo { get; set; }
  213. /// <summary>
  214. /// 领料类型
  215. /// </summary>
  216. [Comment("领料类型")]
  217. public long? picktype { get; set; }
  218. /// <summary>
  219. /// 出库类型
  220. /// </summary>
  221. [Comment("出库类型")]
  222. public long? output_type_id { get; set; }
  223. /// <summary>
  224. /// 启用预警
  225. /// </summary>
  226. [Comment("启用预警")]
  227. public int? enable_warning { get; set; }
  228. /// <summary>
  229. /// 生命周期状态:1-成熟品,2-新品,3-重点新品,4-退市
  230. /// </summary>
  231. [Comment("生命周期状态")]
  232. public int? life_state { get; set; }
  233. /// <summary>
  234. /// 经济生产批量
  235. /// </summary>
  236. [Comment("经济生产批量")]
  237. [Precision(23, 10)]
  238. public decimal? moq { get; set; }
  239. /// <summary>
  240. /// 最大生产批量
  241. /// </summary>
  242. [Comment("最大生产批量")]
  243. [Precision(23, 10)]
  244. public decimal? maq { get; set; }
  245. /// <summary>
  246. /// 是否备料前预处理
  247. /// </summary>
  248. [Comment("是否备料前预处理")]
  249. public int? is_clean { get; set; }
  250. /// <summary>
  251. /// 预处理提前期(天)
  252. /// </summary>
  253. [Comment("预处理提前期")]
  254. [Precision(23, 10)]
  255. public decimal? clean_leadtime { get; set; }
  256. /// <summary>
  257. /// 工序委外提前期/灭菌提前期(天)
  258. /// </summary>
  259. [Comment("工序委外提前期")]
  260. [Precision(23, 10)]
  261. public decimal? sterilize_leadtime { get; set; }
  262. /// <summary>
  263. /// 平台调拨提前期(天)
  264. /// </summary>
  265. [Comment("平台调拨提前期")]
  266. [Precision(23, 10)]
  267. public decimal? transfer_leadtime { get; set; }
  268. /// <summary>
  269. /// 标准工期(天)
  270. /// </summary>
  271. [Comment("标准工期")]
  272. [Precision(23, 10)]
  273. public decimal? standard_period { get; set; }
  274. /// <summary>
  275. /// FMR分类:F-F类,M-M类,R-R类
  276. /// </summary>
  277. [Comment("FMR分类")]
  278. [StringLength(80)]
  279. public string fmr { get; set; }
  280. /// <summary>
  281. /// ABC分类:A-A类,B-B类,C-C类
  282. /// </summary>
  283. [Comment("ABC分类")]
  284. [StringLength(80)]
  285. public string abc { get; set; }
  286. //ic_plan
  287. ///// <summary>
  288. ///// 物料id
  289. ///// </summary>
  290. //[Required]
  291. //[Comment("物料id")]
  292. //public long icitem_id { get; set; }
  293. ///// <summary>
  294. ///// 物料名称
  295. ///// </summary>
  296. //[StringLength(80)]
  297. //[Comment("物料名称")]
  298. //public string? icitem_name { get; set; }
  299. ///// <summary>
  300. ///// 计划员
  301. ///// </summary>
  302. //[StringLength(80)]
  303. //[Comment("计划员")]
  304. //public string? planner_name { get; set; }
  305. ///// <summary>
  306. ///// 计划员_工号
  307. ///// </summary>
  308. //[StringLength(80)]
  309. //[Comment("计划员_工号")]
  310. //public string? planner_num { get; set; }
  311. ///// <summary>
  312. ///// 工厂编码
  313. ///// </summary>
  314. //[StringLength(80)]
  315. //[Comment("工厂编码")]
  316. //public string? factory_code { get; set; }
  317. /// <summary>
  318. /// 固定提前期(天)
  319. /// </summary>
  320. [Precision(23, 10)]
  321. [Comment("固定提前期(天)")]
  322. public decimal? fix_leadtime { get; set; }
  323. /// <summary>
  324. /// 计划策略
  325. /// </summary>
  326. [Comment("计划策略")]
  327. public int? plan_trategy { get; set; }
  328. /// <summary>
  329. /// 订货策略
  330. /// </summary>
  331. [Comment("订货策略")]
  332. public int? order_trategy { get; set; }
  333. /// <summary>
  334. /// 订货间隔期_天
  335. /// </summary>
  336. [Precision(23, 10)]
  337. [Comment("订货间隔期_天")]
  338. public decimal? order_inter_val { get; set; }
  339. /// <summary>
  340. /// 变动提前期
  341. /// </summary>
  342. [Precision(23, 10)]
  343. [Comment("变动提前期")]
  344. public decimal? lead_time { get; set; }
  345. /// <summary>
  346. /// 变动提前期批量
  347. /// </summary>
  348. [Precision(23, 10)]
  349. [Comment("变动提前期批量")]
  350. public decimal? bat_change_economy { get; set; }
  351. /// <summary>
  352. /// 累计提前期
  353. /// </summary>
  354. [Precision(23, 10)]
  355. [Comment("累计提前期")]
  356. public decimal? total_tqq { get; set; }
  357. /// <summary>
  358. /// 再订货点
  359. /// </summary>
  360. [Precision(23, 10)]
  361. [Comment("再订货点")]
  362. public decimal? order_point { get; set; }
  363. /// <summary>
  364. /// 设置为固定再订货点
  365. /// </summary>
  366. [Comment("设置为固定再订货点")]
  367. public int? isfixedreorder { get; set; }
  368. /// <summary>
  369. /// 安全库存数量
  370. /// </summary>
  371. [Precision(23, 10)]
  372. [Comment("安全库存数量")]
  373. public decimal? secinv { get; set; }
  374. /// <summary>
  375. /// 安全库存触发采购比例
  376. /// </summary>
  377. [Precision(23, 10)]
  378. [Comment("安全库存触发采购比例")]
  379. public decimal? secinv_ratio { get; set; }
  380. /// <summary>
  381. /// 是否需要进行订补货计划的运算
  382. /// </summary>
  383. //[Comment("是否需要进行订补货计划的运算")]
  384. //public int? book_plan { get; set; }
  385. /// <summary>
  386. /// 辅助属性参与计划运算
  387. /// </summary>
  388. //[Comment("辅助属性参与计划运算")]
  389. //public int? aux_prop_plan { get; set; }
  390. /// <summary>
  391. /// 计划备注
  392. /// </summary>
  393. //[StringLength(1000)]
  394. //[Comment("计划备注")]
  395. //public string? plannote { get; set; }
  396. /// <summary>
  397. /// 计算ID
  398. /// </summary>
  399. [Comment("计算id")]
  400. public long? bang_id { get; set; }
  401. /// <summary>
  402. /// 批量数量
  403. /// </summary>
  404. [Precision(18, 8)]
  405. [Comment("批量数量")]
  406. public decimal? batch_qty { get; set; }
  407. /// <summary>
  408. /// 物料业务id
  409. /// </summary>
  410. [Comment("物料业务id")]
  411. public long? icitem_id { get; set; }
  412. /// <summary>
  413. /// 物料业务名称
  414. /// </summary>
  415. [StringLength(255)]
  416. [Comment("物料业务名称")]
  417. public string? icitem_name { get; set; }
  418. /// <summary>
  419. /// 计划员
  420. /// </summary>
  421. [StringLength(255)]
  422. [Comment("计划员")]
  423. public string? planner_name { get; set; }
  424. /// <summary>
  425. /// 计划员工号
  426. /// </summary>
  427. [StringLength(255)]
  428. [Comment("计划员工号")]
  429. public string? planner_num { get; set; }
  430. /// <summary>
  431. /// 工厂编码
  432. /// </summary>
  433. [StringLength(255)]
  434. [Comment("工厂编码")]
  435. public string? factory_code { get; set; }
  436. /// <summary>
  437. /// 是否参与订补货计划运算
  438. /// </summary>
  439. [Comment("是否参与订补货计划运算")]
  440. public int? book_plan { get; set; }
  441. /// <summary>
  442. /// 辅助属性参与计划运算
  443. /// </summary>
  444. [Comment("辅助属性参与计划运算")]
  445. public int? aux_prop_plan { get; set; }
  446. /// <summary>
  447. /// 计划备注
  448. /// </summary>
  449. [StringLength(255)]
  450. [Comment("计划备注")]
  451. public string? plannote { get; set; }
  452. /// <summary>
  453. /// 工厂代码
  454. /// </summary>
  455. [StringLength(255)]
  456. [Comment("工厂代码")]
  457. public string? factory_fode { get; set; }
  458. /// <summary>
  459. /// 备注
  460. /// </summary>
  461. [StringLength(255)]
  462. [Comment("备注")]
  463. public string? note { get; set; }
  464. /// <summary>
  465. /// 领料类型
  466. /// </summary>
  467. [Comment("领料类型")]
  468. public long? pick_type { get; set; }
  469. /// <summary>
  470. /// 是否需要库龄管理
  471. /// </summary>
  472. [Comment("是否需要库龄管理")]
  473. public int? stock_time { get; set; }
  474. /// <summary>
  475. /// 盘点周期单位
  476. /// </summary>
  477. [StringLength(255)]
  478. [Comment("盘点周期单位")]
  479. public string? check_cycunit { get; set; }
  480. /// <summary>
  481. /// 盘点周期
  482. /// </summary>
  483. [Precision(18, 6)]
  484. [Comment("盘点周期")]
  485. public decimal? check_cycle { get; set; }
  486. /// <summary>
  487. /// 每周或每月第几天
  488. /// </summary>
  489. [Comment("每周或每月第几天")]
  490. public int? days_per { get; set; }
  491. /// <summary>
  492. /// 上次盘点日期
  493. /// </summary>
  494. [Comment("上次盘点日期")]
  495. public DateTime? last_checkdate { get; set; }
  496. /// <summary>
  497. /// 默认待检仓库
  498. /// </summary>
  499. [Comment("默认待检仓库")]
  500. public long? default_chkloc { get; set; }
  501. /// <summary>
  502. /// 默认待检仓位
  503. /// </summary>
  504. [Comment("默认待检仓位")]
  505. public long? default_chksp { get; set; }
  506. /// <summary>
  507. /// 默认仓库
  508. /// </summary>
  509. [Comment("默认仓库")]
  510. public long? default_loc { get; set; }
  511. /// <summary>
  512. /// 默认仓位
  513. /// </summary>
  514. [Comment("默认仓位")]
  515. public long? default_sp { get; set; }
  516. /// <summary>
  517. /// 货架信息
  518. /// </summary>
  519. [StringLength(255)]
  520. [Comment("货架信息")]
  521. public string? item_shelve { get; set; }
  522. /// <summary>
  523. /// 默认仓管员
  524. /// </summary>
  525. [StringLength(255)]
  526. [Comment("默认仓管员")]
  527. public string? default_manager { get; set; }
  528. /// <summary>
  529. /// 最低存量
  530. /// </summary>
  531. [Precision(18, 6)]
  532. [Comment("最低存量")]
  533. public decimal? low_limit { get; set; }
  534. /// <summary>
  535. /// 最高存量
  536. /// </summary>
  537. [Precision(18, 6)]
  538. [Comment("最高存量")]
  539. public decimal? high_limit { get; set; }
  540. /// <summary>
  541. /// 最大订货量
  542. /// </summary>
  543. [Precision(18, 6)]
  544. [Comment("最大订货量")]
  545. public decimal? qty_max { get; set; }
  546. /// <summary>
  547. /// 日消耗量
  548. /// </summary>
  549. [Precision(18, 6)]
  550. [Comment("日消耗量")]
  551. public decimal? daily_consume { get; set; }
  552. /// <summary>
  553. /// 库存备注
  554. /// </summary>
  555. [StringLength(255)]
  556. [Comment("库存备注")]
  557. public string? warehouse_note { get; set; }
  558. /// <summary>
  559. /// 原材料收货处理时间
  560. /// </summary>
  561. [Precision(18, 6)]
  562. [Comment("原材料收货处理时间")]
  563. public decimal? raw_matreceiv_days { get; set; }
  564. /// <summary>
  565. /// 成品入库时间
  566. /// </summary>
  567. [Precision(18, 6)]
  568. [Comment("成品入库时间")]
  569. public decimal? prdenter_days { get; set; }
  570. /// <summary>
  571. /// 原材料入库时间
  572. /// </summary>
  573. [Precision(18, 6)]
  574. [Comment("原材料入库时间")]
  575. public decimal? mat_enter_days { get; set; }
  576. /// <summary>
  577. /// 成品发货时间
  578. /// </summary>
  579. [Precision(18, 6)]
  580. [Comment("成品发货时间")]
  581. public decimal? prd_out_days { get; set; }
  582. /// <summary>
  583. /// 生产负责人
  584. /// </summary>
  585. [StringLength(255)]
  586. [Comment("生产负责人")]
  587. public string? product_principal { get; set; }
  588. /// <summary>
  589. /// 倒冲仓库
  590. /// </summary>
  591. [StringLength(255)]
  592. [Comment("倒冲仓库")]
  593. public string? back_flush_stock { get; set; }
  594. /// <summary>
  595. /// 倒冲仓位
  596. /// </summary>
  597. [StringLength(255)]
  598. [Comment("倒冲仓位")]
  599. public string? back_flush_sp { get; set; }
  600. /// <summary>
  601. /// 自检提前期
  602. /// </summary>
  603. [Precision(23, 10)]
  604. [Comment("自检提前期")]
  605. public decimal? self_inspection_date { get; set; }
  606. /// <summary>
  607. /// 入库提前期
  608. /// </summary>
  609. [Precision(23, 10)]
  610. [Comment("入库提前期")]
  611. public decimal? Warehousing_date { get; set; }
  612. /// <summary>
  613. /// 发运提前期
  614. /// </summary>
  615. [Precision(23, 10)]
  616. [Comment("发运提前期")]
  617. public decimal? Shipping_date { get; set; }
  618. //ic_factory_details
  619. /// <summary>
  620. /// 物料id
  621. /// </summary>
  622. //[Required]
  623. //[Comment("物料id")]
  624. //public long icitem_id { get; set; }
  625. ///// <summary>
  626. ///// 物料名称
  627. ///// </summary>
  628. //[StringLength(80)]
  629. //[Comment("物料名称")]
  630. //public string? icitem_name { get; set; }
  631. /// <summary>
  632. /// 工厂编码
  633. /// </summary>
  634. //[StringLength(80)]
  635. //[Comment("工厂编码")]
  636. //public string? factory_fode { get; set; }
  637. /// <summary>
  638. /// 特殊备注
  639. /// </summary>
  640. //[StringLength(1000)]
  641. //[Comment("特殊备注")]
  642. //public string? note { get; set; }
  643. /// <summary>
  644. /// 产品线
  645. /// </summary>
  646. [StringLength(80)]
  647. [Comment("产品线")]
  648. public string product_line { get; set; }
  649. /// <summary>
  650. /// 领料类型
  651. /// </summary>
  652. //[Required]
  653. //[Comment("领料类型")]
  654. //public long pick_type { get; set; }
  655. /// <summary>
  656. /// 是否采用业务批次管理
  657. /// </summary>
  658. [Comment("是否采用业务批次管理")]
  659. public int batch_manager { get; set; }
  660. /// <summary>
  661. /// 是否需要库龄管理
  662. /// </summary>
  663. //[Comment("是否需要库龄管理")]
  664. //public int stock_time { get; set; }
  665. /// <summary>
  666. /// 盘点周期单位
  667. /// </summary>
  668. //[StringLength(80)]
  669. //[Comment("盘点周期单位")]
  670. //public string? check_cycunit { get; set; }
  671. /// <summary>
  672. /// 盘点周期
  673. /// </summary>
  674. //[Precision(23, 10)]
  675. //[Comment("盘点周期")]
  676. //public decimal? check_cycle { get; set; }
  677. /// <summary>
  678. /// 每周_月第天
  679. /// </summary>
  680. //[Comment("每周_月第天")]
  681. //public int days_per { get; set; }
  682. /// <summary>
  683. /// 上次盘点日期
  684. /// </summary>
  685. //[Comment("上次盘点日期")]
  686. //public DateTime? last_checkdate { get; set; }
  687. ///// <summary>
  688. /// 默认待检仓库
  689. /// </summary>
  690. //[Required]
  691. //[Comment("默认待检仓库")]
  692. //public long default_chkloc { get; set; }
  693. /// <summary>
  694. /// 默认待检仓位
  695. /// </summary>
  696. //[Required]
  697. //[Comment("默认待检仓位")]
  698. //public long default_chksp { get; set; }
  699. /// <summary>
  700. /// 默认仓库
  701. /// </summary>
  702. //[Required]
  703. //[Comment("默认仓库")]
  704. //public long default_loc { get; set; }
  705. /// <summary>
  706. /// 默认仓位
  707. /// </summary>
  708. //[Required]
  709. //[Comment("默认仓位")]
  710. //public long default_sp { get; set; }
  711. /// <summary>
  712. /// 货架信息
  713. /// </summary>
  714. //[StringLength(80)]
  715. //[Comment("货架信息")]
  716. //public string? item_shelve { get; set; }
  717. /// <summary>
  718. /// 默认仓管员
  719. /// </summary>
  720. //[StringLength(80)]
  721. //[Comment("默认仓管员")]
  722. //public string? default_manager { get; set; }
  723. /// <summary>
  724. /// 最低存量
  725. /// </summary>
  726. //[Precision(23, 10)]
  727. //[Comment("最低存量")]
  728. //public decimal? low_limit { get; set; }
  729. /// <summary>
  730. /// 最高存量
  731. /// </summary>
  732. //[Precision(23, 10)]
  733. //[Comment("最高存量")]
  734. //public decimal? high_limit { get; set; }
  735. /// <summary>
  736. /// 最大订货量
  737. /// </summary>
  738. //[Precision(23, 10)]
  739. //[Comment("最大订货量")]
  740. //public decimal? qty_max { get; set; }
  741. /// <summary>
  742. /// 日消耗量
  743. /// </summary>
  744. //[Precision(23, 10)]
  745. //[Comment("日消耗量")]
  746. //public decimal? daily_consume { get; set; }
  747. /// <summary>
  748. /// 库存备注
  749. /// </summary>
  750. //[StringLength(1000)]
  751. //[Comment("库存备注")]
  752. //public string? warehouse_note { get; set; }
  753. /// <summary>
  754. /// 工单发料时间/天
  755. /// </summary>
  756. [Precision(23, 10)]
  757. [Comment("工单发料时间/天")]
  758. public decimal? ordissu_days { get; set; }
  759. ///// <summary>
  760. ///// 原材料收货处理时间/天
  761. ///// </summary>
  762. //[Precision(23, 10)]
  763. //[Comment("原材料收货处理时间/天")]
  764. //public decimal? raw_matreceiv_days { get; set; }
  765. ///// <summary>
  766. ///// 成品入库时间/天
  767. ///// </summary>
  768. //[Precision(23, 10)]
  769. //[Comment("成品入库时间/天")]
  770. //public decimal? prdenter_days { get; set; }
  771. ///// <summary>
  772. ///// 原材料入库时间/天
  773. ///// </summary>
  774. //[Precision(23, 10)]
  775. //[Comment("原材料入库时间/天")]
  776. //public decimal? mat_enter_days { get; set; }
  777. ///// <summary>
  778. ///// 成品发货时间/天
  779. ///// </summary>
  780. //[Precision(23, 10)]
  781. //[Comment("成品发货时间/天")]
  782. //public decimal? prd_out_days { get; set; }
  783. /// <summary>
  784. /// 运输中提前期_天
  785. /// </summary>
  786. [Comment("运输中提前期_天")]
  787. [Required]
  788. [DefaultValue(0)]
  789. [Precision(23, 10)]
  790. public decimal? transportation_leadtime { get; set; }
  791. /// <summary>
  792. /// 仓库中提前期_天
  793. /// </summary>
  794. [Comment("仓库中提前期_天")]
  795. [Required]
  796. [DefaultValue(0)]
  797. [Precision(23, 10)]
  798. public decimal? stock_leadtime { get; set; }
  799. /// <summary>
  800. /// 生产中提前期_天
  801. /// </summary>
  802. [Comment("生产中提前期_天")]
  803. [Required]
  804. [DefaultValue(0)]
  805. [Precision(23, 10)]
  806. public decimal? production_leadtime { get; set; }
  807. /// <summary>
  808. /// 下单前置期_天
  809. /// </summary>
  810. [Comment("下单前置期_天")]
  811. [Required]
  812. [DefaultValue(0)]
  813. [Precision(23, 10)]
  814. public decimal? order_leadtime { get; set; }
  815. /// <summary>
  816. /// 最小包装量
  817. /// </summary>
  818. [Comment("最小包装量")]
  819. [Required]
  820. [DefaultValue(0)]
  821. [Precision(23, 10)]
  822. public decimal? minpackqty { get; set; }
  823. /// <summary>
  824. /// 最小订单量
  825. /// </summary>
  826. [Comment("最小订单量")]
  827. [Required]
  828. [DefaultValue(0)]
  829. [Precision(23, 10)]
  830. public decimal? minorderqty { get; set; }
  831. /// <summary>
  832. /// 是否倒冲
  833. /// </summary>
  834. [Comment("是否倒冲")]
  835. public int? isbackflush { get; set; }
  836. /// <summary>
  837. /// 生产负责人
  838. /// </summary>
  839. //[StringLength(80)]
  840. //[Comment("生产负责人")]
  841. //public string? product_principal { get; set; }
  842. /// <summary>
  843. /// 倒冲仓库
  844. /// </summary>
  845. //[StringLength(80)]
  846. //[Comment("倒冲仓库")]
  847. //public string? back_flush_stock { get; set; }
  848. /// <summary>
  849. /// 倒冲仓位
  850. /// </summary>
  851. //[StringLength(80)]
  852. //[Comment("倒冲仓位")]
  853. //public string? back_flush_sp { get; set; }
  854. /// <summary>
  855. /// 投料自动取整
  856. /// </summary>
  857. [Comment("投料自动取整")]
  858. public int? put_integer { get; set; }
  859. /// <summary>
  860. /// RS50成品 RS30 组件 RS11 原材料 RS12 零件 RS13 包装材料 RS14 辅料 RS15 低值易耗品 RS99 虚拟物料
  861. /// </summary>
  862. [StringLength(80)]
  863. [Comment("物料类型")]
  864. public string? item_type { get; set; }
  865. /// <summary>
  866. /// 供应提前期
  867. /// </summary>
  868. [Comment("供应提前期")]
  869. [Required]
  870. [DefaultValue(0)]
  871. [Precision(23, 10)]
  872. public int PurLT { get; set; }
  873. /// <summary>
  874. /// bom设计时间
  875. /// </summary>
  876. [Comment("bom设计时间")]
  877. [DefaultValue(0)]
  878. public decimal? BOMDesignTime { get; set; }
  879. /// <summary>
  880. /// 工艺设计时间
  881. /// </summary>
  882. [Comment("工艺设计时间")]
  883. [DefaultValue(0)]
  884. public decimal? RoutingDesignTime { get; set; }
  885. }
  886. }