gyxt.pdb

医院管理系统

0



1
0
1
1
0
0
FFDH

1
3
104
104
科室代码
KSDM



71
0
numeric(4)
4
0
0
0





0
0
0



0
0
1
1
0
0
KSDM

2
3
105
105
发放日期
FFRQ



71
0
datetime
0
0
0
0





0
0
0



0
0
1
1
0
0
FFRQ

3
3
106
106
发放判别
FFPB



71
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
FFPB

4
3
253
253
领用人
LYR



71
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
LYR

5
3
107
107
操作工号
CZGH



71
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
CZGH

6
3
108
108
确认工号
QRGH



71
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
QRGH

7
3
109
109
备注
MEMO



71
0
varchar(100)
100
0
0
0





0
0
0



0
0
0
1
0
0
MEMO

8
3
111
111
发放单号
FFDH



110
0
numeric(6)
6
0
0
0





0
0
0



1
1
1
1
0
0
FFDH

1
3
112
112
物料序号
WLXH



110
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
WLXH

2
3
153
153
产地序号
CDXH



110
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
CDXH

3
3
113
113
回用判别
HYPB



110
0
numeric(1)
1
0
0
0




0
0
0
0



1
0
1
1
0
0
HYPB

4
3
114
114
发放数量
FFSL



110
0
numeric(4)
4
0
0
0





0
0
0



0
0
1
1
0
0
FFSL

5
3
115
115
进货价格
JHJG



110
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
1
1
0
0
JHJG

6
3
116
116
批发价格
PFJG



110
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
1
1
0
0
PFJG

7
3
117
117
零售价格
LSJG



110
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
1
1
0
0
LSJG

8
3
123
123
报损单号
BSDH



121
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
BSDH

1
3
124
124
报损日期
BSRQ



121
0
datetime
0
0
0
0





0
0
0



0
0
1
1
0
0
BSRQ

2
3
125
125
物料序号
WLXH



121
0
numeric(6)
6
0
0
0





0
0
0



0
0
1
1
0
0
WLXH

3
3
154
154
产地序号
CDXH



121
0
numeric(6)
6
0
0
0





0
0
0



0
0
1
1
0
0
CDXH

4
3
126
126
回用判别
HYPB



121
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
HYPB

5
3
127
127
报损数量
BSSL



121
0
numeric(4)
4
0
0
0





0
0
0



0
0
1
1
0
0
BSSL

6
3
133
133
进货价格
JHJG



121
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
1
1
0
0
JHJG

7
3
134
134
批发价格
PFJG



121
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
1
1
0
0
PFJG

8
3
135
135
零售价格
LSJG



121
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
1
1
0
0
LSJG

9
3
128
128
报损原因
BSYY



121
0
varchar(100)
100
0
0
0





0
0
0



0
0
0
1
0
0
BSYY

10
3
129
129
经手人
JSR



121
0
varchar(10)
10
0
0
0





0
0
0



0
0
0
1
0
0
JSR

11
3
130
130
报损判别
BSPB



121
0
numeric(1)
1
0
0
0

0



0
0
0



0
0
1
1
0
0
BSPB

12
3
131
131
操作工号
CZGH



121
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
CZGH

13
3
132
132
确认工号
QRGH



121
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
QRGH

14
3
136
136
盘点单号
PDDH



122
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
PDDH

1
3
137
137
盘点日期
PDRQ



122
0
datetime
0
0
0
0





0
0
0



0
0
1
1
0
0
PDRQ

2
3
138
138
执行判别
ZXPB



122
0
numeric(1)
1
0
0
0




0
0
0
0



0
0
1
1
0
0
ZXPB

3
3
139
139
操作工号
CZGH



122
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
CZGH

4
3
140
140
执行工号
ZXGH



122
0
varchar(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
ZXGH

5
3
147
147
备注
MEMO



122
0
varchar(100)
100
0
0
0





0
0
0



0
0
0
1
0
0
MEMO

6
3
142
142
盘点单号
PDDH



141
0
numeric(6)
6
0
0
0





0
0
0



1
1
1
1
0
0
PDDH

1
3
143
143
物料序号
WLXH



141
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
WLXH

2
3
155
155
产地序号
CDXH



141
0
numeric(6)
6
0
0
0





0
0
0



1
0
1
1
0
0
CDXH

3
3
144
144
回用判别
HYPB



141
0
numeric(1)
1
0
0
0




0
0
0
0



1
0
1
1
0
0
HYPB

4
3
510
510
进货价格
JHJG



141
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
1
1
0
0
JHJG

5
3
511
511
批发价格
PFJG



141
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
1
1
0
0
PFJG

6
3
512
512
零售价格
LSJG



141
0
numeric(10,4)
10
4
0
0





0
0
0



0
0
1
1
0
0
LSJG

7
3
145
145
帐册数量
ZCSL



141
0
numeric(4)
4
0
0
0





0
0
0



0
0
1
1
0
0
ZCSL

8
3
146
146
实盘数量
SPSL



141
0
numeric(4)
4
0
0
0





0
0
0



0
0
0
1
0
0
SPSL

9
/END_TABLE AMCCOLN

/BEGIN_TABLE AMCREFR
@       N5
OID     N8
REFR    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL1   N8
TABL2   N8
URUL    N1
DRUL    N1
MAND    N1
CPRT    N1
SOID    N8
TOBJ    N5
COBJ    A80
FKCN    A30
CMIN    A10
CMAX    A10
NGEN    N1
/BEGIN_DATA AMCREFR
3
25
25
Ref_25
Ref_25



1
17
1
1
1
1
0
0
Ref_25

0
n
0
3
34
34
Ref_34
Ref_34



19
17
1
1
1
1
0
0
Ref_34

0
n
0
3
39
39
Ref_39
Ref_39



18
1
1
1
1
1
0
0
Ref_39

0
n
0
3
96
96
Ref_96
Ref_96



69
70
1
1
1
1
0
0
Ref_96

0
n
0
3
118
118
Ref_118
Ref_118



71
110
1
1
1
1
0
0
Ref_118

0
n
0
3
148
148
Ref_148
Ref_148



122
141
1
1
1
1
0
0
Ref_148

0
n
0
/END_TABLE AMCREFR

/BEGIN_TABLE AMCCCOL
@       N5
OID     N8
CCOL    N8
COLN1   N8
COLN2   N8
/BEGIN_DATA AMCCCOL
1
26
26
5
20
1
35
35
28
21
1
40
40
37
11
1
97
97
74
85
1
102
102
100
101
1
119
119
99
111
1
149
149
136
142
/END_TABLE AMCCCOL

/BEGIN_TABLE AMCCREF
@       N5
OID     N8
CREF    N8
REFR    N8
CCOL    N8
NUMR    N8
/BEGIN_DATA AMCCREF
3
27
27
25
26
1
3
36
36
34
35
1
3
41
41
39
40
1
3
98
98
96
97
1
3
103
103
96
102
2
3
120
120
118
119
1
3
150
150
148
149
1
/END_TABLE AMCCREF

/BEGIN_TABLE AMCINDX
@       N5
OID     N8
INDX    N8
NAME    A80
CODE    A80
TABL    N8
LABL    A254
DESC    TXT
NOTE    TXT
PRIM    N1
FORN    N1
UNIQ    N1
CLUS    N1
OPTS    TXT
COBJ    A80
NUMR    N8
TYPE    A40
/BEGIN_DATA AMCINDX
/END_TABLE AMCINDX

/BEGIN_TABLE AMCCIDX
@       N5
OID     N8
CIDX    N8
INDX    N8
COLN    N8
ASCD    N1
NUMR    N8
/BEGIN_DATA AMCCIDX
/END_TABLE AMCCIDX

/BEGIN_TABLE AMCAKEY
@       N5
OID     N8
AKEY    N8
NAME    A80
CODE    A80
TABL    N8
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
AKCN    A30
NUMR    N8
/BEGIN_DATA AMCAKEY
/END_TABLE AMCAKEY

/BEGIN_TABLE AMCCKEY
@       N5
OID     N8
CKEY    N8
AKEY    N8
COLN    N8
NUMR    N8
/BEGIN_DATA AMCCKEY
/END_TABLE AMCCKEY

/BEGIN_TABLE AMCTRGR
@       N5
TEMP    A30
TEXT    TXT
NAME    A30
TABL    N8
ALWS    N1
/BEGIN_DATA AMCTRGR
/END_TABLE AMCTRGR

/BEGIN_TABLE AMCPROC
@       N5
OID     N8
PROC    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TEXT    TXT
FUNC    N1
/BEGIN_DATA AMCPROC
/END_TABLE AMCPROC

/BEGIN_TABLE AMCVIEW
@       N5
OID     N8
VIEW    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
CUST    N1
LOBJ    TXT
QURY    TXT
UPDT    N1
GENE    N1
CHCK    N1
/BEGIN_DATA AMCVIEW
/END_TABLE AMCVIEW

/BEGIN_TABLE AMCRULE
@       N5
OID     N8
RULE    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TYPE    N5
FLAG    N5
CEXP    TXT
SEXP    TXT
LOBJ    TXT
SOID    N8
COBJ    A80
/BEGIN_DATA AMCRULE
/END_TABLE AMCRULE

/BEGIN_TABLE AMCTSPC
@       N5
OID     N8
TSPC    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
/BEGIN_DATA AMCTSPC
/END_TABLE AMCTSPC

/BEGIN_TABLE AMCSTOR
@       N5
OID     N8
STOR    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
/BEGIN_DATA AMCSTOR
/END_TABLE AMCSTOR

/BEGIN_TABLE AMCLTBL
@       N5
OID     N8
LTBL    N8
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
HEAD    TXT
FOOT    TXT
GENE    N1
TABL    N8
/BEGIN_DATA AMCLTBL
/END_TABLE AMCLTBL

/BEGIN_TABLE AMCLCOL
@       N5
OID     N8
LCOL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
LTBL    N8
COLN    N8
DTTP    A30
MLEN    N8
PREC    N2
MAND    N1
UNIQ    N1
DISP    N1
IQIX    N4
OPTFP   TXT
OPTLF   TXT
OPTLD   TXT
OPTHG   TXT
OPTHNG  TXT
NUMR    N8
/BEGIN_DATA AMCLCOL
/END_TABLE AMCLCOL

/BEGIN_TABLE AMCJREL
@       N5
OID     N8
JREL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
LTBL1   N8
LTBL2   N8
MANY    N1
/BEGIN_DATA AMCJREL
/END_TABLE AMCJREL

/BEGIN_TABLE AMCJIDX
@       N5
OID     N8
JIDX    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
OPTS    TXT
HEAD    TXT
FOOT    TXT
LTBL    N8
LOBJ    TXT
/BEGIN_DATA AMCJIDX
/END_TABLE AMCJIDX

/BEGIN_TABLE AMCJCCL
@       N5
OID     N8
JCCL    N8
LCOL1   N8
LCOL2   N8
/BEGIN_DATA AMCJCCL
/END_TABLE AMCJCCL

/BEGIN_TABLE AMCJCRL
@       N5
OID     N8
JCRL    N8
JREL    N8
JCCL    N8
NUMR    N8
/BEGIN_DATA AMCJCRL
/END_TABLE AMCJCRL

/BEGIN_TABLE AMCFACT
@       N5
OID     N8
FACT    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL    N8
/BEGIN_DATA AMCFACT
/END_TABLE AMCFACT

/BEGIN_TABLE AMCDIM
@       N5
OID     N8
DIM     N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TABL    N8
/BEGIN_DATA AMCDIM
/END_TABLE AMCDIM

/BEGIN_TABLE AMCHFCT
@       N5
OID     N8
HFCT    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
/BEGIN_DATA AMCHFCT
/END_TABLE AMCHFCT

/BEGIN_TABLE AMCHDIM
@       N5
OID     N8
HDIM    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
/BEGIN_DATA AMCHDIM
/END_TABLE AMCHDIM

/BEGIN_TABLE AMCMETR
@       N5
OID     N8
METR    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TTYP    N8
COLN    N8
/BEGIN_DATA AMCMETR
/END_TABLE AMCMETR

/BEGIN_TABLE AMCATTR
@       N5
OID     N8
ATTR    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
TTYP    N8
COLN    N8
/BEGIN_DATA AMCATTR
/END_TABLE AMCATTR

/BEGIN_TABLE AMCNODE
@       N5
OID     N8
NODE    N8
PNODE   N8
TYPE    N8
NUMR    N8
/BEGIN_DATA AMCNODE
/END_TABLE AMCNODE

/BEGIN_TABLE AMCDTBS
@       N5
OID     N8
DTBS    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
DEFF    A256
DTSC    A80
SRVN    A30
LOGN    A128
PASS    A256
/BEGIN_DATA AMCDTBS
/END_TABLE AMCDTBS

/BEGIN_TABLE AMCETBL
@       N5
OID     N8
ETBL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
DTBS    N8
/BEGIN_DATA AMCETBL
/END_TABLE AMCETBL

/BEGIN_TABLE AMCECOL
@       N5
OID     N8
ECOL    N8
NAME    A80
CODE    A80
LABL    A254
DESC    TXT
NOTE    TXT
ETBL    N8
DTTP    A30
MLEN    N8
PREC    N2
DISP    N1
NUMR    N8
/BEGIN_DATA AMCECOL
/END_TABLE AMCECOL

/BEGIN_TABLE AMCTSRC
@       N5
OID     N8
TSRC    N8
TABL    N8
DTBS    N8
SCRPT   TXT
INVLD   N1
LOBJ    TXT
/BEGIN_DATA AMCTSRC
/END_TABLE AMCTSRC

/BEGIN_TABLE AMCCSRC
@       N5
OID     N8
CSRC    N8
COLN    N8
TSRC    N8
ALIAS   A80
EXPR    TXT
INVLD   N1
LOBJ    TXT
/BEGIN_DATA AMCCSRC
/END_TABLE AMCCSRC

/BEGIN_TABLE AMCRPRT
@       N5
OID     N8
RPRT    N8
FLGS    N8
NAME    A64
DESC    A254
TMLT    BIN
/BEGIN_DATA AMCRPRT
/END_TABLE AMCRPRT

/BEGIN_TABLE AMCSLCT
RPRT    N8
MODL    N8
LOBJ    TXT
/BEGIN_DATA AMCSLCT
/END_TABLE AMCSLCT

/BEGIN_TABLE AMCCNST
@       N5
CNST    N8
MODL    N8
NAME    A30
TYPE    A20
VALE    A254
RSRV    N1
/BEGIN_DATA AMCCNST