物资管理产品.pdm

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

0
T_MM_purchase




PK_T_MM_PURCHASE



0
1609
0
0
0
3
861
861
6
物资采购计划明细
T_MM_purchase_detail



0
0
0
T_MM_purchase_detail




PK_T_MM_PURCHASE_DETAIL



0
1609
0
0
0
3
888
888
6
物资定额表
T_MM_ration



0
0
0
T_MM_ration




PK_T_MM_RATION



0
1609
0
0
0
3
901
901
6
物资定额明细表
T_MM_ration_detail



0
0
0
T_MM_ration_detail




PK_T_MM_RATION_DETAIL



0
1609
0
0
0
3
914
914
6
不合格品通知单明细表
T_MM_reject_detail



0
0
0
T_MM_reject_detail




PK_T_MM_REJECT_DETAIL



0
1609
0
0
0
3
925
925
6
不合格品通知单主表
T_MM_reject_master



0
0
0
T_MM_reject_master




PK_T_MM_REJECT_MASTER



0
1609
0
0
0
3
937
937
6
月度物资需求计划
T_MM_require_month



0
0
0
T_MM_require_month




PK_T_MM_REQUIRE_MONTH



0
1609
0
0
0
3
966
966
6
月度物资需求计划明细
T_MM_require_month_detail



0
0
0
T_MM_require_month_detail




PK_T_MM_REQUIRE_MONTH_DETAIL



0
1609
0
0
0
3
984
984
6
年度物资需求计划汇总
T_MM_require_year



0
0
0
T_MM_require_year




PK_T_MM_REQUIRE_YEAR



0
1609
0
0
0
3
1001
1001
6
年度物资需求计划汇总明细
T_MM_require_year_detail



0
0
0
T_MM_require_year_detail




PK_T_MM_REQUIRE_YEAR_DETAIL



0
1609
0
0
0
3
1013
1013
6
年度物资需求计划申请
T_MM_requireapp_year



0
0
0
T_MM_requireapp_year




PK_T_MM_REQUIREAPP_YEAR



0
1609
0
0
0
3
1039
1039
6
年度物资需求计申请划明细
T_MM_requireapp_year_detail



0
0
0
T_MM_requireapp_year_detail




PK_T_MM_REQUIREAPP_YEAR_DETAIL



0
1609
0
0
0
3
1052
1052
6
物资验收单
T_MM_spare_receipt



0
0
0
T_MM_spare_receipt




PK_T_MM_SPARE_RECEIPT



0
1609
0
0
0
3
1072
1072
6
库存控制表
T_MM_stock_batch



0
0
0
T_MM_stock_batch




PK_T_MM_STOCK_BATCH



0
1609
0
0
0
3
1087
1087
6
物资储备计划
T_MM_stockplan



0
0
0
T_MM_stockplan




PK_T_MM_STOCKPLAN



0
1609
0
0
0
3
1100
1100
6
物资储备计划明细
T_MM_stockplan_detail



0
0
0
T_MM_stockplan_detail




PK_T_MM_STOCKPLAN_DETAIL



0
1609
0
0
0
3
1119
1119
6
供应商信息主表
T_MM_supplier



0
0
0
T_MM_supplier




PK_T_MM_SUPPLIER



0
1609
0
0
0
3
1152
1152
6
供方评价记录表
T_MM_supplier_evaluate



0
0
0
T_MM_supplier_evaluate




PK_T_MM_SUPPLIER_EVALUATE



0
1609
0
0
0
3
1183
1183
6
供方评价记录明细表
T_MM_supplier_evaluate_detail



0
0
0
T_MM_supplier_evaluate_detail




PK_T_MM_SUPPLIER_EVALUATE_DETA



0
1609
0
0
0
3
1191
1191
6
供方资信调查
T_MM_supplier_inquiry



0
0
0
T_MM_supplier_inquiry




PK_T_MM_SUPPLIER_INQUIRY



0
1609
0
0
0
3
1220
1220
6
供应商物资供应
T_MM_supplier_mat



0
0
0
T_MM_supplier_mat




PK_T_MM_SUPPLIER_MAT



0
1609
0
0
0
3
1233
1233
6
供应商评价标准
T_MM_supplier_standard



0
0
0
T_MM_supplier_standard




PK_T_MM_SUPPLIER_STANDARD



0
1609
0
0
0
3
1240
1240
6
系统控制主文件
T_MM_system_control



0
0
0
T_MM_system_control




PK_T_MM_SYSTEM_CONTROL



0
1609
0
0
0
3
1261
1261
6
物资采购评定标发标
T_MM_tender



0
0
0
T_MM_tender




PK_T_MM_TENDER



0
1609
0
0
0
3
1283
1283
6
物资采购评定标明细
T_MM_tender_detail



0
0
0
T_MM_tender_detail




PK_T_MM_TENDER_DETAIL



0
1609
0
0
0
3
1300
1300
6
工器具卡片明细表
T_MM_tool_card_detail



0
0
0
T_MM_tool_card_detail




PK_T_MM_TOOL_CARD_DETAIL



0
1609
0
0
0
3
1315
1315
6
工器具卡片
T_MM_tool_card_master



0
0
0
T_MM_tool_card_master




PK_T_MM_TOOL_CARD_MASTER



0
1609
0
0
0
3
1325
1325
6
物资移库表
T_MM_transfer



0
0
0
T_MM_transfer




PK_T_MM_TRANSFER



0
1609
0
0
0
3
1338
1338
6
物资移库表明细
T_MM_transfer_detail



0
0
0
T_MM_transfer_detail




PK_T_MM_TRANSFER_DETAIL



0
1609
0
0
0
3
1352
1352
6
供应商文档资料管理
T_MM_vendor_info



0
0
0
T_MM_vendor_info




PK_T_VENDOR_INFO



0
1609
0
0
0
3
1367
1367
6
物资库房
T_MM_warehouse



0
0
0
T_MM_warehouse




PK_T_MM_WAREHOUSE



0
1609
0
0
0
3
1376
1376
6
物资管理仓库
T_MM_warehouse_manage



0
0
0
T_MM_warehouse_manage




PK_T_MM_WAREHOUSE_MANAGE



0
1609
0
0
0
3
1385
1385
6
废旧物资台帐
T_MM_waste



0
0
0
T_MM_waste




PK_T_MM_WASTE



0
1609
0
0
0
3
1398
1398
6
报废物资申请
T_MM_waste_app



0
0
0
T_MM_waste_app




PK_T_MM_WASTE_APP



0
1609
0
0
0
3
1417
1417
6
报废物资申请明细
T_MM_waste_app_detail



0
0
0
T_MM_waste_app_detail




PK_T_MM_WASTE_APP_DETAIL



0
1609
0
0
0
3
1429
1429
6
废旧物资处理
T_MM_waste_disposal



0
0
0
T_MM_waste_disposal




PK_T_MM_WASTE_DISPOSAL



0
1609
0
0
0
/END_TABLE AMCTABL

/BEGIN_TABLE AMCCOLN
@       N5
OID     N10
COLN    N10
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL    N10
DOMN    N10
DTTP    A30
MLEN    N8
PREC    N2
IDNT    N1
WDEF    N1
UNIT    A8
FRMT    A20
LVAL    A20
HVAL    A20
DVAL    A80
UPPR    N1
LOWR    N1
NMDF    N1
VALS    TXT
CRUL    TXT
GRUL    TXT
PRIM    N1
FORN    N1
MAND    N1
DISP    N1
SOID    N10
TOBJ    N5
COBJ    A80
CKCN    A30
NUMR    N8
PROF    N10
REDU    N8
NULV    N5
AVLN    N8
ATYP    N10
ROPR    N1
/BEGIN_DATA AMCCOLN
3
64
64
物资编码
mat_id



63
26
varchar(96)
96
0
0
0





0
0
0



1
1
1
1
0
0
mat_id

1
0
-100
0
0
0
0
3
65
65
记账序号
deatil_no



63
0
varchar(8)
8
0
0
0





0
0
0



1
0
1
1
0
0
deatil_no

2
0
-100
0
0
0
0
3
66
66
记账期间
periodid



63
0
varchar(6)
6
0
0
0





0
0
0



0
1
0
1
0
0
periodid

3
0
-100
0
0
0
0
3
67
67
日期
io_date



63
9
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
io_date

4
0
-100
0
0
0
0
3
68
68
仓库编码
wareh_id



63
59
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
wareh_id

5
0
-100
0
0
0
0
3
69
69
货架编码
location_id



63
45
varchar(6)
6
0
0
0





0
0
0



0
0
0
1
0
0
location_id

6
0
-100
0
0
0
0
3
70
70
出入库类型
inout_type



63
23
varchar(2)
2
0
0
0





0
0
0



0
0
1
1
0
0
inout_type

7
0
-100
0
0
0
0
3
71
71
出入单编号
io_no



63
0
varchar(24)
24
0
0
0





0
0
0



0
0
0
1
0
0
io_no

8
0
-100
0
0
0
0
3
72
72
入库数量
in_num



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





0
0
0



0
0
0
1
0
0
in_num

9
0
-100
0
0
0
0
3
73
73
入库金额
in_sum



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





0
0
0



0
0
0
1
0
0
in_sum

10
0
-100
0
0
0
0
3
74
74
出库数量
out_num



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





0
0
0



0
0
0
1
0
0
out_num

11
0
-100
0
0
0
0
3
75
75
出库金额
out_sum



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





0
0
0



0
0
0
1
0
0
out_sum

12
0
-100
0
0
0
0
3
76
76
结转数量
stock_num



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





0
0
0



0
0
0
1
0
0
stock_num

13
0
-100
0
0
0
0
3
77
77
结转金额
stock_sum



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





0
0
0



0
0
0
1
0
0
stock_sum

14
0
-100
0
0
0
0
3
78
78
财务稽核人
audit_emp_id



63
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
audit_emp_id

15
0
-100
0
0
0
0
3
79
79
实际价格
fact_price



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





0
0
0



0
0
0
1
0
0
fact_price

16
0
-100
0
0
0
0
3
80
80
摘要
digest



63
42
varchar(96)
96
0
0
0





0
0
0



0
0
0
1
0
0
digest

17
0
-100
0
0
0
0
3
85
85
登记号
bill_id



84
14
varchar(32)
32
0
0
0





0
0
0



1
0
1
1
0
0
bill_id

1
0
-100
0
0
0
0
3
86
86
发货单号
invoice



84
0
varchar(15)
15
0
0
0





0
0
0



0
0
0
1
0
0
invoice

2
0
-100
0
0
0
0
3
87
87
到货日期
arrive_date



84
9
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
arrive_date

3
0
-100
0
0
0
0
3
88
88
合同号
contract_id



84
0
varchar(15)
15
0
0
0





0
0
0



0
0
0
1
0
0
contract_id

4
0
-100
0
0
0
0
3
89
89
发票号
invoice_no



84
0
varchar(15)
15
0
0
0





0
0
0



0
0
0
1
0
0
invoice_no

5
0
-100
0
0
0
0
3
90
90
供应商
supplier_id



84
14
varchar(32)
32
0
0
0





0
0
0



0
0
0
1
0
0
supplier_id

6
0
-100
0
0
0
0
3
91
91
供应商名称
supplier_name



84
53
varchar(56)
56
0
0
0





0
0
0



0
0
0
1
0
0
supplier_name

7
0
-100
0
0
0
0
3
92
92
送货单位
deliverer



84
0
varchar(56)
56
0
0
0





0
0
0



0
0
0
1
0
0
deliverer

8
0
-100
0
0
0
0
3
93
93
经办人签字
handle_man



84
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
handle_man

9
0
-100
0
0
0
0
3
94
94
经办人姓名
handle_manname



84
19
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
handle_manname

10
0
-100
0
0
0
0
3
95
95
始发站
station



84
58
varchar(48)
48
0
0
0





0
0
0



0
0
0
1
0
0
station

11
0
-100
0
0
0
0
3
96
96
提货人
pick_emp



84
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
pick_emp

12
0
-100
0
0
0
0
3
97
97
提货人姓名
pick_empname



84
19
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
pick_empname

13
0
-100
0
0
0
0
3
98
98
收货人
incept_emp



84
18
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
incept_emp

14
0
-100
0
0
0
0
3
99
99
收货人姓名
incept_empname



84
19
varchar(20)
20
0
0
0





0
0
0



0
0
0
1
0
0
incept_empname

15
0
-100
0
0
0
0
3
100
100
备注
remark



84
42
varchar(96)
96
0
0
0





0
0
0



0
0
0
1
0
0
remark

16
0
-100
0
0
0
0
3
104
104
登记号
bill_id



103
14
varchar(32)
32
0
0
0





0
0
0



1
1
1
1
0
0
bill_id

1
0
-100
0
0
0
0
3
105
105
物资编码
mat_id



103
26
varchar(96)
96
0
0
0





0
0
0



1
0
1
1
0
0
mat_id

2
0
-100
0
0
0
0
3
106
106
物资名称
mat_name



103
27
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
0
0
mat_name

3
0
-100
0
0
0
0
3
107
107
数量
pur_amount



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





0
0
0



0
0
0
1
0
0
pur_amount

4
0
-100
0
0
0
0
3
108
108
是否免检
is_avoid



103
0
char(1)
1
0
0
0





0
0
0



0
0
0
1
0
0
is_avoid

5
0
-100
0
0
0
0
3
109
109
包装情况
package



103
42
varchar(96)
96
0
0
0





0
0
0



0
0
0
1
0
0
package

6
0
-100
0
0
0
0
3
110
110
开箱日期
open_date



103
9
datetime
0
0
0
0





0
0
0



0
0
0
1
0
0
open_date

7
0
-100
0
0
0
0
3
111
111
备注
remark



103
42
varchar(96)
96
0
0
0





0
0
0



0
0
0
1
0
0
remark

8
0
-100
0
0
0
0
3
116
116
招标编号
tender_id



115
14
varchar(32)
32
0
0
0





0
0
0



1
1
1
1
0
0
tender_id

1
0
-100
0
0
0
0
3
117
117
物资编码
mat_id



115
26
varchar(96)
96
0
0
0





0
0
0



1
1
1
1
0
0
mat_id

2
0
-100
0
0
0
0
3
118
118
供应商
supplier_id



115
14
varchar(32)
32
0
0
0





0
0
0



1
0
1
1
0
0
supplier_id

3
0
-100
0
0
0
0
3
119
119
投标编号
quo_id



115
0
varchar(15)
15
0
0
0





0
0
0



0
0
1
1
0
0
quo_id

4
0
-100
0
0
0
0
3
120
120
物资名称
mat_name



115
27
varchar(50)
50
0
0
0





0
0
0



0
0
0
1
0
0
mat_name

5
0
-100
0
0
0
0
3
121
121
物资规格
mat_spec



115
28
varchar(30)
30
0
0
0





0
0
0



0
0
0
1
0
0
mat_spec

6
0
-100
0
0
0
0
3
122
122
计量单位
unit_id



115
57
varchar(8)
8
0
0
0





0
0
0



0
0
0
1
0
0
unit_id

7
0
-100
0
0
0
0
3
123
123
投标单价
bid_price



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





0
0
0



0
0
0
1
0
0
bid_price

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



115
0
numeric(4,2)
4
2
0
0





0
0
0



0
0
0
1
0
0
tax_rate

9
0
-100
0
0
0
0
3
125
125
运杂费
freight



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





0
0
0



0
0
0
1
0
0
freight

10
0
-100
0
0
0
0
3
126
126
明细说明
explain



115
0
varchar(30)
30
0
0
0





0
0
0



0
0
0
1
0
0
explain

11
0
-100
0
0
0
0
3
127
127
交货日期
supply_date



115
9
datetime
0
0
0
0





0
0
0