Ì i 2
audit.trail.top
[audit.item]
&(M)MTAT[mt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.item 43 URN L MM.ITEM mt
Ì € i 2
audit.trail
[audit.item, audit.date,audit.seq]
&(M)MTAT[mt]A[mtAD,mtAS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.date 8 DATE L mtAD
audit.seq 4 PINT R mtAS
audit.client 30 FREE L &(M)MTAT[mt]A[mtAD,mtAS]|6
audit.field 6 CHOICE L &(M)MTAT[mt]A[mtAD,mtAS]|2
audit.from 40 FREE L &(M)MTAT[mt]A[mtAD,mtAS]|3
audit.source 24 CHOICE L &(M)MTAT[mt]A[mtAD,mtAS]|5
audit.time 5 HHMM L &(M)MTAT[mt]A[mtAD,mtAS]|1
audit.to 40 FREE L &(M)MTAT[mt]A[mtAD,mtAS]|4
audit.user 10 FREE L MIS.USER &(M)MTAT[mt]A[mtAD,mtAS]|0
Ì € i 2
audit.trail.vendors
[audit.item,audit.date,audit.seq, audit.vend.no]
&(M)MTAT[mt]A[mtAD,mtAS]V[gr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.vend.no 11 FREE L MIS.VEN gr
audit.vend.client 30 FREE L &(M)MTAT[mt]A[mtAD,mtAS]V[gr]|6
audit.vend.field 6 CHOICE L &(M)MTAT[mt]A[mtAD,mtAS]V[gr]|2
audit.vend.from 40 FREE L &(M)MTAT[mt]A[mtAD,mtAS]V[gr]|3
audit.vend.source 24 CHOICE L &(M)MTAT[mt]A[mtAD,mtAS]V[gr]|5
audit.vend.time 5 HHMM L &(M)MTAT[mt]A[mtAD,mtAS]V[gr]|1
audit.vend.to 40 FREE L &(M)MTAT[mt]A[mtAD,mtAS]V[gr]|4
audit.vend.user 10 FREE L MIS.USER &(M)MTAT[mt]A[mtAD,mtAS]V[gr]|0
Ì i 2
copy.item
[ci.q]
*(M)MTIC[mtCI]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ci.q 3 PINT R mtCI
ci.bkg.count 3 PINT R *(M)MTIC[mtCI]A|7
ci.bkg.start.yn 1 YN L *(M)MTIC[mtCI]A|5
ci.date 8 DATE L *(M)MTIC[mtCI]|1
ci.f.con 1 FREE L *(M)MTIC[mtCI]|18
ci.f.edi.main 1 FREE L *(M)MTIC[mtCI]|19
ci.f.edi.update 1 FREE L *(M)MTIC[mtCI]|21
ci.f.edi.view 1 FREE L *(M)MTIC[mtCI]|20
ci.f.irq 1 FREE L *(M)MTIC[mtCI]|16
ci.f.irt 1 FREE L *(M)MTIC[mtCI]|17
ci.f.nonstk 1 FREE L *(M)MTIC[mtCI]|12
ci.f.pha.q 1 FREE L *(M)MTIC[mtCI]|14
ci.f.po 1 FREE L *(M)MTIC[mtCI]|10
ci.f.po.req 1 FREE L *(M)MTIC[mtCI]|11
ci.f.stk 1 FREE L *(M)MTIC[mtCI]|9
ci.f.wo 1 FREE L *(M)MTIC[mtCI]|13
ci.fn 1 FREE L *(M)MTIC[mtCI]|8
ci.fo 1 FREE L *(M)MTIC[mtCI]|7
ci.job 30 FREE L *(M)MTIC[mtCI]A|0
ci.last.bkg.run 10 FREE L *(M)MTIC[mtCI]A|6
ci.launch.result 25 FREE L *(M)MTIC[mtCI]A|3
ci.lockouts 5 PINT R *(M)MTIC[mtCI]A|2
ci.msg 70 FREE L *(M)MTIC[mtCI]A|1
ci.new.num 10 FREE L *(M)MTIC[mtCI]|6
ci.new.urn 43 URN L MM.ITEM *(M)MTIC[mtCI]|4
ci.old.num 10 FREE L *(M)MTIC[mtCI]|5
ci.old.urn 43 URN L MM.ITEM *(M)MTIC[mtCI]|3
ci.process 8 PINT R MIS.PROCESS *(M)MTIC[mtCI]A|4
ci.status 9 CHOICE L *(M)MTIC[mtCI]|15
ci.time 10 FREE L *(M)MTIC[mtCI]|2
ci.user 10 FREE L MIS.USER *(M)MTIC[mtCI]|0
Ì € i 2
ci.irq
[ci.q, ciirq.urn]
*(M)MTIC[mtCI]IRQ[mcu]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ciirq.urn 30 URN L MM.ITEM.REQ mcu
ciirq.done 1 YN L *(M)MTIC[mtCI]IRQ[mcu]|2
ciirq.lk.dev 20 FREE L *(M)MTIC[mtCI]IRQ[mcu]|1
ciirq.lk.user 10 FREE L MIS.USER *(M)MTIC[mtCI]IRQ[mcu]|0
Ì € i 2
ci.irt
[ci.q, ciirt.id]
*(M)MTIC[mtCI]IRT[mcti]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ciirt.id 15 FREE L MM.IREQ.TEMP mcti
ciirt.done 1 YN L *(M)MTIC[mtCI]IRT[mcti]|2
ciirt.lk.dev 20 FREE L *(M)MTIC[mtCI]IRT[mcti]|1
ciirt.lk.user 10 FREE L MIS.USER *(M)MTIC[mtCI]IRT[mcti]|0
Ì € i 2
ci.nonstk.reqs
[ci.q, cinr.id]
*(M)MTIC[mtCI]NR[ml]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cinr.id 15 FREE L MM.NONSTK.REQ ml
cinr.done 1 YN L *(M)MTIC[mtCI]NR[ml]|2
Ì € i 2
ci.poreqs
[ci.q, cipor.urn]
*(M)MTIC[mtCI]POR[mr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cipor.urn 30 URN L MM.PO.REQ mr
cipor.done 1 YN L *(M)MTIC[mtCI]POR[mr]|2
cipor.lk.dev 20 FREE L *(M)MTIC[mtCI]POR[mr]|1
cipor.lk.user 10 FREE L MIS.USER *(M)MTIC[mtCI]POR[mr]|0
Ì € i 2
ci.pos
[ci.q, cip.po]
*(M)MTIC[mtCI]PO[mp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cip.po 30 URN L MM.PO mp
cip.done 1 YN L *(M)MTIC[mtCI]PO[mp]|2
cip.lk.dev 20 FREE L *(M)MTIC[mtCI]PO[mp]|1
cip.lk.user 10 FREE L MIS.USER *(M)MTIC[mtCI]PO[mp]|0
Ì € i 2
ci.stocks
[ci.q, cis.inv.top,cis.itype,cis.inv]
*(M)MTIC[mtCI]I[miTOP,miTYP,mi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cis.inv.top 10 FREE L miTOP
cis.itype 1 FREE L miTYP
cis.inv 10 FREE L mi
cis.f.pr 1 FREE L *(M)MTIC[mtCI]I[miTOP,miTYP,mi]|7
cis.f.rr 1 FREE L *(M)MTIC[mtCI]I[miTOP,miTYP,mi]|6
cis.f.sr 1 FREE L *(M)MTIC[mtCI]I[miTOP,miTYP,mi]|5
cis.f.stk 1 FREE L *(M)MTIC[mtCI]I[miTOP,miTYP,mi]|4
cis.new.num 18 FREE L *(M)MTIC[mtCI]I[miTOP,miTYP,mi]|3
cis.new.urn 18 FREE L *(M)MTIC[mtCI]I[miTOP,miTYP,mi]|1
cis.not.done 1 FREE L *(M)MTIC[mtCI]I[miTOP,miTYP,mi]|8
cis.old.num 18 FREE L *(M)MTIC[mtCI]I[miTOP,miTYP,mi]|2
cis.old.urn 18 FREE L *(M)MTIC[mtCI]I[miTOP,miTYP,mi]|0
Ì € i 2
ci.wo.types
[ci.q, ciwt.id]
*(M)MTIC[mtCI]WOT[mup]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ciwt.id 10 FREE L MM.EQP.WO.TYPE mup
ciwt.done 1 YN L *(M)MTIC[mtCI]WOT[mup]|2
Ì € i 2
ci.wos
[ci.q, ciwo.no]
*(M)MTIC[mtCI]WO[muw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ciwo.no 6 PINT R MM.EQP.WO muw
ciwo.done 1 YN L *(M)MTIC[mtCI]WO[muw]|2
Ì € i 2
cis.irq
[ci.q, cisirq.urn,cisirq.line]
*(M)MTIC[mtCI]SIRQ[mcu,mcuL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cisirq.urn 30 URN L MM.ITEM.REQ mcu
cisirq.line 3 FREE L mcuL
cisirq.done 1 FREE L *(M)MTIC[mtCI]SIRQ[mcu,mcuL]|0
Ì € i 2
cis.irt
[ci.q, cis.irt.id,cis.irt.line]
*(M)MTIC[mtCI]SIRT[mcti,mctL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cis.irt.id 15 FREE L MM.IREQ.TEMP mcti
cis.irt.line 3 FREE L mctL
cis.irt.done 1 FREE L *(M)MTIC[mtCI]SIRT[mcti,mctL]|0
Ì € i 2
cis.pt.reqs
[ci.q, cipr.inv,cipr.num]
*(M)MTIC[mtCI]PR[mi,mh]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cipr.inv 10 FREE L MM.INVENT mi
cipr.num 6 FREE L mh
cipr.done 1 YN L *(M)MTIC[mtCI]PR[mi,mh]|2
cipr.lk.dev 20 FREE L *(M)MTIC[mtCI]PR[mi,mh]|1
cipr.lk.user 10 FREE L MIS.USER *(M)MTIC[mtCI]PR[mi,mh]|0
Ì € i 2
cis.rec.reqs
[ci.q, cirr.inv,cirr.id]
*(M)MTIC[mtCI]RR[mi,mb]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cirr.inv 10 FREE L MM.INVENT mi
cirr.id 15 FREE L MM.REC.REQ mb
cirr.done 1 YN L *(M)MTIC[mtCI]RR[mi,mb]|2
Ì € i 2
cis.stk.reqs
[ci.q, cisr.inv,cisr.srnum]
*(M)MTIC[mtCI]SR[mi,mq]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cisr.inv 10 FREE L MM.INVENT mi
cisr.srnum 6 FREE L mq
cisr.done 1 YN L *(M)MTIC[mtCI]SR[mi,mq]|2
cisr.lk.dev 20 FREE L *(M)MTIC[mtCI]SR[mi,mq]|1
cisr.lk.user 10 FREE L MIS.USER *(M)MTIC[mtCI]SR[mi,mq]|0
Ì € i 2
main
[item.urn]
&(M)MT[mt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
item.urn 43 URN L mt
active 1 YN L &(M)MT[mt]|0
category 8 FREE L MM.CATEGORY &(M)MT[mt]|3
crnt.pkging 4 FREE L &(M)MT[mt]|20
desc.line2 30 FREE L &(M)MT[mt]|5
description 30 FREE L &(M)MT[mt]|4
disc.comment 30 FREE L &(M)MT[mt]|9
exp.obj.code 7 FREE L MIS.GL.EOC &(M)MT[mt]|6
form 8 FREE L MM.FORM.DICT &(M)MT[mt]|12
from.pha 1 YN L &(M)MT[mt]|17
haz.mat 15 FREE L MM.HAZ.MAT &(M)MT[mt]C|2
id 43 URN L MM.ITEM VAL=(@MM.ITEM.number_" - "_@MM.ITEM.description'=" - "
VAL=)
largest.common.unit 4 INT R &(M)MT[mt]|13
largest.common.unit.disp 4 FREE L VAL=IF{@MM.ITEM.largest.common.unit=0 @MM.ITEM.smalles
VAL=t.unit;@MM.ITEM.pkg.size[@MM.ITEM.crnt.pkging,@MM.
VAL=ITEM.largest.common.unit]}
largest.common.unit.us 7 PINT R &(M)MT[mt]|14
last.update 10 FREE L &(M)MT[mt]UPD
mark.up.per 8 PDEC4 R &(M)MT[mt]|16
name 30 FREE L &(M)MT[mt]|2
number 10 FREE L &(M)MT[mt]|1
package.string 40 FREE L VAL=@packaging[@item.urn,@crnt.pkging]
package.string.disp 40 FREE L VAL=@MM.ITEM.packaging[@MM.ITEM.item.urn,@MM.ITEM.crnt
VAL=.pkging]
pha.db 12 FREE L MIS.APPL.DB &(M)MT[mt]|19
pha.drug 10 FREE L PHA.DRUG &(M)MT[mt]|18
pha.generic.name 30 FREE L &(M)MT[mt]C|0
pha.ndc.din.number 12 FREE L &(M)MT[mt]C|1
procedure.code 10 FREE L &(M)MT[mt]|8
pvend.cat.no 15 FREE L &(M)MT[mt]PV|1
pvend.comment 60 FREE L &(M)MT[mt]PV|13
pvend.cont.exp.date 8 DATE L &(M)MT[mt]PV|12
pvend.cont.group 60 FREE L &(M)MT[mt]PV|11
pvend.contract.no 10 FREE L &(M)MT[mt]PV|10
pvend.conv.pkg.size 10 FREE L &(M)MT[mt]PV|6
pvend.cost.up 10 DEC4 R &(M)MT[mt]PV|5
pvend.cost.us 10 DEC4 R &(M)MT[mt]PV|14
pvend.manuf 10 FREE L MIS.MFR &(M)MT[mt]PV|3
pvend.manuf.cat.no 15 FREE L &(M)MT[mt]PV|4
pvend.no 11 FREE L MIS.VEN &(M)MT[mt]PV|0
pvend.unit.of.pur 10 FREE L &(M)MT[mt]PV|7
pvend.unit.of.pur.num 4 FREE L VAL=(@pvend.unit.of.pur$(L(@pvend.unit.of.pur," "))?0N
VAL=!1)
pvend.unit.of.pur.unit 5 FREE L VAL=(@pvend.unit.of.pur%(L(@pvend.unit.of.pur," "))!@p
VAL=vend.unit.of.pur)
pvend.up.us 5 PINT R &(M)MT[mt]PV|9
pvend.up.with.us 15 FREE L &(M)MT[mt]PV|8
smallest.unit 4 FREE L &(M)MT[mt]|11
stock.id.desc 79 FREE L VAL=@MM.ITEM.number_IF{@MM.ITEM.disc.comment " **DISCO
VAL=NT'D**"}_" "_@MM.ITEM.description_IF{@MM.ITEM.name
VAL= " ("_@MM.ITEM.name_")"}
tax.code 3 FREE L MIS.TAX.CODE &(M)MT[mt]|15
taxable 1 YN L &(M)MT[mt]|10
Ì € i 2
hazards.allergens
[item.urn, hazal.i]
&(M)MT[mt]C["HZ",mahi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
hazal.i 2 PINT R mahi
haz.aller 15 FREE L MM.HAZ.MAT &(M)MT[mt]C["HZ",mahi]|0
Ì € i 2
packaging.tree
[item.urn, pkg.no]
&(M)MT[mt]T[mtT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.no 3 URN L mtT
activated.by.user 10 FREE L &(M)MT[mt]T[mtT]|2
date.string.activated 8 DATE L &(M)MT[mt]T[mtT]|1
date.string.retired 8 DATE L &(M)MT[mt]T[mtT]|3
disc.reason 30 FREE L &(M)MT[mt]T[mtT]|5
packaging 40 FREE L &(M)MT[mt]T[mtT]|0
retired.by.user 10 FREE L &(M)MT[mt]T[mtT]|4
Ì € i 2
unit
[item.urn,pkg.no, sizeno]
&(M)MT[mt]T[mtT]U[mtU]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sizeno 3 URN L mtU
conv.factor 5 PINT R &(M)MT[mt]T[mtT]U[mtU]|2
pkg.size 4 FREE L &(M)MT[mt]T[mtT]U[mtU]|0
units.per 5 PINT R &(M)MT[mt]T[mtT]U[mtU]|1
Ì € i 2
vendor.order
[item.urn, vendor.order.no]
&(M)MT[mt]O[mtV]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vendor.order.no 2 PINT R mtV
vendor.num 11 FREE L MIS.VEN &(M)MT[mt]O[mtV]|1
Ì € i 2
vendors
[item.urn, vendor.no]
&(M)MT[mt]V[gr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vendor.no 11 FREE L MIS.VEN gr
vend.active 1 YN L &(M)MT[mt]V[gr]|0
vend.cat.no 15 FREE L &(M)MT[mt]V[gr]|1
vend.comment 75 FREE L &(M)MT[mt]V[gr]|13
vend.cont.exp.date 8 DATE L &(M)MT[mt]V[gr]|12
vend.cont.group 60 FREE L &(M)MT[mt]V[gr]|11
vend.contract.no 15 FREE L &(M)MT[mt]V[gr]|10
vend.manuf 10 FREE L MIS.MFR &(M)MT[mt]V[gr]|3
vend.manuf.cat.no 15 FREE L &(M)MT[mt]V[gr]|4
Ì € i 2
edi.updates
[item.urn,vendor.no, eup.date]
&(M)MT[mt]V[gr]D[mtED]
Field Name Len Dat Typ J DPM Offset/Local/VAL
eup.date 8 DATE L mtED
eup.cost.up 10 PDEC4 R &(M)MT[mt]V[gr]D[mtED]|2
eup.lin.seg 5 PINT R &(M)MT[mt]V[gr]D[mtED]|1
eup.session 5 PINT R &(M)MT[mt]V[gr]D[mtED]|0
eup.upd 6 PINT R &(M)MT[mt]V[gr]D[mtED]|4
eup.view 15 FREE L &(M)MT[mt]V[gr]D[mtED]|3
Ì € i 2
vendor.contracts
[item.urn,vendor.no, cntr.eff.date]
&(M)MT[mt]V[gr]C[mtCD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cntr.eff.date 8 DATE L mtCD
cntr.cost.up 10 PDEC4 R &(M)MT[mt]V[gr]C[mtCD]|1
cntr.number 15 FREE L &(M)MT[mt]V[gr]C[mtCD]|0
Ì € i 2
vendor.purch.info
[item.urn,vendor.no, vend.pkg.no]
&(M)MT[mt]V[gr]A[mtT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vend.pkg.no 4 URN L mtT
vend.conv.pkg.size 10 FREE L &(M)MT[mt]V[gr]A[mtT]|2
vend.cost.up 10 DEC4 R &(M)MT[mt]V[gr]A[mtT]|1
vend.cost.us 10 DEC4 R &(M)MT[mt]V[gr]A[mtT]|5
vend.unit.of.pur 10 FREE L &(M)MT[mt]V[gr]A[mtT]|0
vend.unit.sizeno 4 PINT R &(M)MT[mt]V[gr]A[mtT]|6
vend.up.us 5 PINT R &(M)MT[mt]V[gr]A[mtT]|4
vend.up.with.us 15 FREE L &(M)MT[mt]V[gr]A[mtT]|3
Ì i 2
pha.queue
[pha.date,pha.q]
&(M)MTPQ[mtpd,mtpq]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pha.date 8 DATE L mtpd
pha.q 3 PINT R mtpq
pha.cat.no 15 FREE L &(M)MTPQ[mtpd,mtpq]|4
pha.conv.pkg.size 10 FREE L &(M)MTPQ[mtpd,mtpq]|9
pha.cost.up 10 DEC4 R &(M)MTPQ[mtpd,mtpq]|6
pha.database 12 FREE L MIS.APPL.DB &(M)MTPQ[mtpd,mtpq]|0
pha.flag 10 FREE L &(M)MTPQ[mtpd,mtpq]|10
pha.inventory 10 FREE L MM.INVENT &(M)MTPQ[mtpd,mtpq]|8
pha.item 43 URN L MM.ITEM &(M)MTPQ[mtpd,mtpq]|2
pha.type 1 CHOICE L &(M)MTPQ[mtpd,mtpq]|1
pha.up 10 FREE L &(M)MTPQ[mtpd,mtpq]|5
pha.updated 1 YN L &(M)MTPQ[mtpd,mtpq]|7
pha.vendor 11 FREE L MIS.VEN &(M)MTPQ[mtpd,mtpq]|3
Ì i 2
pkg.copy
&(M)MTPC
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.copy.created 10 FREE L &(M)MTPC|0
pkg.copy.last.edit 10 FREE L &(M)MTPC|1
Ì € i 2
pkg.copy.list
[pkg.copy.string]
&(M)MTPC[mtP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.copy.string 40 FREE L mtP
Ì i 2
pkg.templates
[pkg.string]
&(M)MTP[mtP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.string 40 mtP
Index Files Subscripts/Physical Base
categ.x [category,item.urn]
&(M)MTC[ma,mt]
catlg.x [pvend.manuf.cat.no,item.urn]
&(M)MTMC[gmC,mt]
component.x [component,item.urn]
&(M)MTCX[mtC,mt]
desc.number.x [description,number] = item.urn
&(M)MTDN[mtD,mtR]
desc.x [description,item.urn]
&(M)MTD[mtD,mt]
drug.x [pha.drug,item.urn]
&(M)MTG[tf,mt]
forms.x [form,item.urn]
&(M)MTFX[mv,mt]
generic.name.x [pha.generic.name,item.urn]
&(M)MTGN[tdgN,mt]
id.x [sort.id,item.urn]
&(M)MTI[mtI,mt]
intersect.list [item.urn]
/MTLX[mt]
key.pointer.value.list [key,key.urn,key.value]
/MTK[mtK,mt,mtKV]
key.value.list [key,key.value]
/MTVK[mtK,mtKV]
manuf.x [vend.manuf,item.urn]
&(M)MTM[gm,mt]
ndc.din.x [pha.ndc.din.number,item.urn]
&(M)MTND[tfND,mt]
number.x [number,item.urn]
&(M)MTR[mtR,mt]
proc.code.x [procedure.code,item.urn]
&(M)MTBC[bd,mt]
tax.code.x [tax.code,item.urn]
&(M)MTTX[gea,mt]
trade.name.x [name,item.urn]
&(M)MTTN[mtN,mt]
ven.catlg.x [vend.cat.no,item.urn]
&(M)MTVC[gvC,mt]
vendor.id.x [vendor.no,item.urn,vendor.order.no]
&(M)MTV[gr,mt,mtV]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | |