物资管理产品.pdm

物资管理系统设计仅供参考

部门名称
dpt_name



333
12
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
0
0
dpt_name

4
0
-100
0
0
0
0
3
338
338
专业编码
speciality_id



333
47
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
speciality_id

5
0
-100
0
0
0
0
3
339
339
专业名称
speciality_name



333
48
varchar(48)
48
0
0
0





0
0
0



0
0
0
1
0
0
speciality_name

6
0
-100
0
0
0
0
3
340
340
项目编码
item_id



333
38
varchar(48)
48
0
0
0





0
0
0



0
0
0
1
0
0
item_id

7
0
-100
0
0
0
0
3
341
341
项目名称
item_name



333
39
varchar(256)
256
0
0
0





0
0
0



0
0
0
1
0
0
item_name

8
0
-100
0
0
0
0
3
342
342
编制人
write_emp_id



333
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
write_emp_id

9
0
-100
0
0
0
0
3
343
343
编制人姓名
write_emp_name



333
19
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
write_emp_name

10
0
-100
0
0
0
0
3
344
344
编制日期
write_date



333
9
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
write_date

11
0
-100
0
0
0
0
3
345
345
审核人
auditing_emp_id



333
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
auditing_emp_id

12
0
-100
0
0
0
0
3
346
346
审核日期
auditing_date



333
9
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
auditing_date

13
0
-100
0
0
0
0
3
3797
3797
是否汇总
if_gather



333
0
varchar(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
if_gather

14
0
-100
0
0
0
0
3
347
347
备注
remark



333
42
varchar(96)
96
0
0
0





0
0
0



0
0
0
1
0
0
remark

15
0
-100
0
0
0
0
3
351
351
定额编号
ration_no



350
14
varchar(32)
32
0
0
0





0
0
0



1
1
1
1
0
0
ration_no

1
0
-100
0
0
0
0
3
352
352
物资编码
material_id



350
26
varchar(96)
96
0
0
0





0
0
0



1
0
1
1
0
0
material_id

2
0
-100
0
0
0
0
3
353
353
物资名称
material_name



350
27
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
0
0
material_name

3
0
-100
0
0
0
0
3
354
354
专业编码
speciality_id



350
47
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
speciality_id

4
0
-100
0
0
0
0
3
355
355
专业名称
speciality_name



350
48
varchar(48)
48
0
0
0





0
0
0



0
0
0
1
0
0
speciality_name

5
0
-100
0
0
0
0
3
356
356
项目编码
item_id



350
38
varchar(48)
48
0
0
0





0
0
0



0
0
0
1
0
0
item_id

6
0
-100
0
0
0
0
3
357
357
项目名称
item_name



350
39
varchar(256)
256
0
0
0





0
0
0



0
0
0
1
0
0
item_name

7
0
-100
0
0
0
0
3
358
358
最高储备定额
high_num



350
25
numeric(14,4)
14
4
0
0





0
0
0



0
0
0
1
0
0
high_num

8
0
-100
0
0
0
0
3
359
359
最低储备定额
low_num



350
25
numeric(14,4)
14
4
0
0





0
0
0



0
0
0
1
0
0
low_num

9
0
-100
0
0
0
0
3
360
360
备注
remark



350
0
varchar(32)
32
0
0
0





0
0
0



0
0
0
1
0
0
remark

10
0
-100
0
0
0
0
3
365
365
费用编号
fare_id



364
14
varchar(32)
32
0
0
0





0
0
0



1
0
1
1
0
0
fare_id

1
0
-100
0
0
0
0
3
366
366
费用名称
fare_name



364
0
varchar(64)
64
0
0
0





0
0
0



0
0
0
1
0
0
fare_name

2
0
-100
0
0
0
0
3
367
367
是否采用
is_use



364
0
char(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
is_use

3
0
-100
0
0
0
0
3
368
368
备注
remark



364
0
varchar(64)
64
0
0
0





0
0
0



0
0
0
1
0
0
remark

4
0
-100
0
0
0
0
3
372
372
入库单号
inpect_id



371
14
varchar(32)
32
0
0
0





0
0
0



1
0
1
1
0
0
inpect_id

1
0
-100
0
0
0
0
3
373
373
入库类型
in_type



371
23
varchar(2)
2
0
0
0





0
0
0



0
0
1
1
0
0
in_type

2
0
-100
0
0
0
0
3
374
374
日期
inpect_date



371
9
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
inpect_date

3
0
-100
0
0
0
0
3
375
375
专业
spe_id



371
47
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
spe_id

4
0
-100
0
0
0
0
3
376
376
专业名称
spe_name



371
48
varchar(48)
48
0
0
0





0
0
0



0
0
0
1
0
0
spe_name

5
0
-100
0
0
0
0
3
377
377
发票号
invoice_no



371
0
varchar(15)
15
0
0
0





0
0
0



0
0
0
1
0
0
invoice_no

6
0
-100
0
0
0
0
3
378
378
支票号
check_no



371
0
varchar(15)
15
0
0
0





0
0
0



0
0
0
1
0
0
check_no

7
0
-100
0
0
0
0
3
379
379
运单号
waybill_no



371
0
varchar(15)
15
0
0
0





0
0
0



0
0
0
1
0
0
waybill_no

8
0
-100
0
0
0
0
3
380
380
合同号
contract_id



371
0
varchar(15)
15
0
0
0





0
0
0



0
0
0
1
0
0
contract_id

9
0
-100
0
0
0
0
3
381
381
部门
in_dep



371
11
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
in_dep

10
0
-100
0
0
0
0
3
382
382
部门名称
in_depname



371
12
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
0
0
in_depname

11
0
-100
0
0
0
0
3
8690
8690
需求计划号
require_id



371
0
varchar(32)
32
0
0
0





0
0
0



0
0
0
1
0
0
require_id

12
0
-100
0
0
0
0
3
383
383
手续费
handling_cost



371
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
handling_cost

13
0
-100
0
0
0
0
3
384
384
维修费
maintenance_cost



371
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
maintenance_cost

14
0
-100
0
0
0
0
3
385
385
其它费用
other_cost



371
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
other_cost

15
0
-100
0
0
0
0
3
386
386
分摊费用
share_cost



371
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
share_cost

16
0
-100
0
0
0
0
3
387
387
折扣
discount



371
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
discount

17
0
-100
0
0
0
0
3
388
388
结算方式
balance_kind



371
2
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
balance_kind

18
0
-100
0
0
0
0
3
389
389
结算方式名称
balance_name



371
3
varchar(48)
48
0
0
0





0
0
0



0
0
0
1
0
0
balance_name

19
0
-100
0
0
0
0
3
390
390
所属设备
affiliated_equipment



371
20
varchar(48)
48
0
0
0





0
0
0



0
0
0
1
0
0
affiliated_equipment

20
0
-100
0
0
0
0
3
391
391
所属设备名称
affiliated_equipmentname



371
21
varchar(128)
128
0
0
0





0
0
0



0
0
0
1
0
0
affiliated_equipmentname

21
0
-100
0
0
0
0
3
392
392
总金额
total_sum



371
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
total_sum

22
0
-100
0
0
0
0
3
393
393
供应商
supplier_id



371
14
varchar(32)
32
0
0
0





0
0
0



0
0
0
1
0
0
supplier_id

23
0
-100
0
0
0
0
3
394
394
供应商名称
supplier_name



371
53
varchar(56)
56
0
0
0





0
0
0



0
0
0
1
0
0
supplier_name

24
0
-100
0
0
0
0
3
395
395
质保书
assure_number



371
0
int
0
0
0
0





0
0
0



0
0
0
1
0
0
assure_number

25
0
-100
0
0
0
0
3
396
396
厂长签字
dir_man



371
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
dir_man

26
0
-100
0
0
0
0
3
397
397
审核人签字
audit_man



371
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
audit_man

27
0
-100
0
0
0
0
3
398
398
保管员签字
store_man



371
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
store_man

28
0
-100
0
0
0
0
3
399
399
经办人签字
handle_man



371
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
handle_man

29
0
-100
0
0
0
0
3
400
400
经办人姓名
handle_manname



371
19
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
handle_manname

30
0
-100
0
0
0
0
3
401
401
财务签字
finance_man



371
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
finance_man

31
0
-100
0
0
0
0
3
402
402
入库原因
reason



371
42
varchar(96)
96
0
0
0





0
0
0



0
0
0
1
0
0
reason

32
0
-100
0
0
0
0
3
403
403
状态代码
status_flow_id



371
49
varchar(2)
2
0
0
0





0
0
0



0
0
0
1
0
0
status_flow_id

33
0
-100
0
0
0
0
3
404
404
状态名称
status_flow_name



371
50
varchar(16)
16
0
0
0





0
0
0



0
0
0
1
0
0
status_flow_name

34
0
-100
0
0
0
0
3
405
405
仓库编码
wareh_id



371
59
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
wareh_id

35
0
-100
0
0
0
0
3
406
406
货架编码
shelf_id



371
45
varchar(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
shelf_id

36
0
-100
0
0
0
0
3
407
407
备注
remark



371
42
varchar(96)
96
0
0
0





0
0
0



0
0
0
1
0
0
remark

37
0
-100
0
0
0
0
3
412
412
入库单号
inpect_id



411
14
varchar(32)
32
0
0
0





0
0
0



1
1
1
1
0
0
inpect_id

1
0
-100
0
0
0
0
3
413
413
入库类型
in_type



411
23
varchar(2)
2
0
0
0





0
0
0



0
0
0
1
0
0
in_type

2
0
-100
0
0
0
0
3
414
414
物资代码
mat_id



411
26
varchar(96)
96
0
0
0





0
0
0



1
0
1
1
0
0
mat_id

3
0
-100
0
0
0
0
3
415
415
物资名称
mat_name



411
27
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
0
0
mat_name

4
0
-100
0
0
0
0
3
416
416
批次
batch



411
0
varchar(24)
24
0
0
0





0
0
0



1
0
1
1
0
0
batch

5
0
-100
0
0
0
0
3
417
417
数量
mat_amount



411
25
numeric(14,4)
14
4
0
0





0
0
0



0
0
0
1
0
0
mat_amount

6
0
-100
0
0
0
0
3
418
418
币种
money_kind



411
0
varchar(3)
3
0
0
0





0
0
0



0
0
0
1
0
0
money_kind

7
0
-100
0
0
0
0
3
419
419
单价
price



411
37
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
price

8
0
-100
0
0
0
0
3
420
420
税率
tax_rate



411
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
tax_rate

9
0
-100
0
0
0
0
3
421
421
总价
total_sum



411
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
total_sum

10
0
-100
0
0
0
0
3
422
422
手续费
handling_cost



411
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
handling_cost

11
0
-100
0
0
0
0
3
423
423
维修费
maintenance_cost



411
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
maintenance_cost

12
0
-100
0
0
0
0
3
424
424
其它费用
other_cost



411
31
numeric(16,4)
16
4
0
0





0
0
0



0
0
0
1
0
0
other_cost

13
0
-100
0
0
0
0
3
425
425
分摊费用
share_cost



411
31