Ì i 2
mm.item.abc.data (abc.data)
[abc]
*MT.ABC[mtABC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abc 10 FREE L mtABC
abc.compiled.status 10 CHOICE L *MT.ABC[mtABC]|1
abc.last.compiled 8 DATE L *MT.ABC[mtABC]|0
Ì € i 2
mm.item.abc.abc.data (abc.abc.data)
[abc, abc.abc]
*MT.ABC[mtABC]A[mtAB1]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abc.abc 1 CHOICE L mtAB1
abc.total.count 6 PINT R *MT.ABC[mtABC]A[mtAB1]|0
abc.total.valuse 12 SMONEY R *MT.ABC[mtABC]A[mtAB1]|1
Ì € i 2
mm.abc.item.data (abc.item.data)
[abc,abc.abc, abc.sequence]
*MT.ABC[mtABC]A[mtAB1]I[mtAB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abc.sequence 6 PINT R mtAB
abc.item.urn 43 URN L MM.ITEM *MT.ABC[mtABC]A[mtAB1]I[mtAB]|0
abc.value 10 SMONEY R *MT.ABC[mtABC]A[mtAB1]I[mtAB]|1
Ì i 2
mm.item.edits (audit.trail)
[audit.item]
*MTED[mt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.item 43 URN L MM.ITEM mt
Ì € i 2
mm.item.audit.trail (audit.trail.item)
[audit.item, audit.date,audit.seq]
*MTED[mt]A[mtMD,mtAS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.date 8 DATE L mtMD
audit.seq 4 PINT R mtAS
audit.crnt.pkging 4 INT R *MTED[mt]A[mtMD,mtAS]|2
audit.field 6 CHOICE L *MTED[mt]A[mtMD,mtAS]|3
audit.from 40 FREE L *MTED[mt]A[mtMD,mtAS]|4
audit.pkging.str 40 FREE L VAL=@packaging[@item.urn,@audit.crnt.pkging]
audit.source 20 CHOICE L *MTED[mt]A[mtMD,mtAS]|6
audit.time 5 HHMM L *MTED[mt]A[mtMD,mtAS]|1
audit.to 40 FREE L *MTED[mt]A[mtMD,mtAS]|5
audit.user 10 FREE L MIS.USER *MTED[mt]A[mtMD,mtAS]|0
Ì € i 2
mm.item.audit.trail.vendors (audit.trail.vendors)
[audit.item,audit.date,audit.seq, audit.vend.no]
*MTED[mt]A[mtMD,mtAS]V[gr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.vend.no 11 FREE L MIS.VEN gr
audit.vend.field 6 CHOICE L *MTED[mt]A[mtMD,mtAS]V[gr]|3
audit.vend.from 40 FREE L *MTED[mt]A[mtMD,mtAS]V[gr]|4
audit.vend.pkg.no 4 INT R *MTED[mt]A[mtMD,mtAS]V[gr]|2
audit.vend.source 20 CHOICE L *MTED[mt]A[mtMD,mtAS]V[gr]|6
audit.vend.time 5 HHMM L *MTED[mt]A[mtMD,mtAS]V[gr]|1
audit.vend.to 40 FREE L *MTED[mt]A[mtMD,mtAS]V[gr]|5
audit.vend.user 10 FREE L MIS.USER *MTED[mt]A[mtMD,mtAS]V[gr]|0
Ì € i 2
mm.item.audit.trail.vpi (audit.trail.vpi)
[audit.item,audit.date,audit.seq,audit.vend.no, audit.vend.pkg.no]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.vend.pkg.no 4 INT R *MTED[mt]A[mtMD,mtAS]V[gr]|2
Ì i 2
mm.item (main)
[item.urn]
*MT[mt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
item.urn 43 URN L mt
abc.status 1 CHOICE L *MT[mt]C|2
active 1 YN L *MT[mt]|0
category 8 FREE L MM.CATEGORY *MT[mt]|3
cd.screen 15 FREE L MIS.SCREEN *MT[mt]CD|0
crnt.pkging 4 INT R *MT[mt]|20
desc.line2 30 FREE L *MT[mt]|5
description 30 FREE L *MT[mt]|4
disc.comment 30 FREE L *MT[mt]|9
form 8 FREE L MM.FORM.DICT *MT[mt]|12
from.pha 1 YN L *MT[mt]|17
hazardous.material 15 FREE L MM.HAZ.MAT *MT[mt]C|4
id 43 URN L MM.ITEM VAL=(@MM.ITEM.number_" - "_@MM.ITEM.description'=" - "
VAL=)
implantable 1 YN L *MT[mt]|21
int.id 43 URN L VAL=@number
largest.common.unit 4 INT R *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 *MT[mt]|14
last.update 10 FREE L *MT[mt]UPD
name 30 FREE L *MT[mt]|2
not.used.yet 1 YN L *MT[mt]C|3
number 10 FREE L *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 *MT[mt]|19
pha.drug 10 FREE L PHA.DRUG *MT[mt]|18
pha.generic.name 30 FREE L *MT[mt]C|0
pha.ndc.din.number 12 FREE L *MT[mt]C|1
print.cd.scree.verbatim 0 FREE L VAL=IF{@cd.screen %MIS.SCREEN.print(@cd.screen,^@custo
VAL=mer.defined.fields,1,0)}
print.cd.screen 0 FREE L VAL=IF{@cd.screen %MIS.SCREEN.print(@cd.screen,^@custo
VAL=mer.defined.fields,"",0)}
smallest.unit 4 FREE L *MT[mt]|11
sort.id 43 FREE L
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_")"}
xxold.exp.obj.code 7 FREE L MIS.GL.EOC *MT[mt]|6
xxold.mark.up.per 8 PDEC4 R *MT[mt]|16
xxold.procedure.code 10 FREE L *MT[mt]|8
xxold.tax.code 3 FREE L MIS.TAX.CODE *MT[mt]|15
xxold.taxable 1 YN L *MT[mt]|10
Ì € i 2
mm.item.customer.def.queries (customer.defined.queries)
[item.urn, cd.query]
*MT[mt]CD[ggv]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cd.query 10 FREE L MIS.QUERY ggv
cd.response 75 QRY.RESP L *MT[mt]CD[ggv]|0
Ì € i 2
mm.item.cust.def.mult.queries (customer.def.mult.queries)
[item.urn,cd.query, cdm.seq.no]
*MT[mt]CD[ggv]M[ggvN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
cdm.seq.no 3 PINT R ggvN
cdm.response 75 QRY.RESP L *MT[mt]CD[ggv]M[ggvN]|0
Ì € i 2
mm.item.hazards.allergens (hazards.allergens)
[item.urn, hazal.i]
*MT[mt]C["HZ",mzhi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
hazal.i 2 PINT R mzhi
haz.aller 15 FREE L MM.HAZ.MAT *MT[mt]C["HZ",mzhi]|0
Ì € i 2
mm.item.packaging.tree (packaging.tree)
[item.urn, pkg.no]
*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 *MT[mt]T[mtT]|2
date.string.activated 8 DATE L *MT[mt]T[mtT]|1
date.string.retired 8 DATE L *MT[mt]T[mtT]|3
disc.reason 30 FREE L *MT[mt]T[mtT]|5
packaging 40 FREE L *MT[mt]T[mtT]|0
retired.by.user 10 FREE L *MT[mt]T[mtT]|4
Ì € i 2
mm.item.unit (unit)
[item.urn,pkg.no, sizeno]
*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 *MT[mt]T[mtT]U[mtU]|2
pkg.size 4 FREE L *MT[mt]T[mtT]U[mtU]|0
units.per 5 PINT R *MT[mt]T[mtT]U[mtU]|1
Ì € i 2
mm.item.substitutes (substitutes)
[item.urn, substitute.number]
*MT[mt]SB[mtSUB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
substitute.number 43 FREE L mtSUB
edit.substitutes 1 YN L
substitute.urn URN L *MT[mt]SB[mtSUB]
view.substitutes 1 FREE L VAL=IF{""^VW,IF{+@substitutes[@t.item.urn,,""] 1^VW,%M
VAL=M.ITEM.view.substitutes(VW),VW} "Y";"N"}
Ì i 2
mm.item.pha.queue (pha.queue)
[pha.date,pha.q]
*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 *MTPQ[mtpd,mtpq]|4
pha.conv.pkg.size 10 FREE L *MTPQ[mtpd,mtpq]|9
pha.cost.up 10 DEC4 R *MTPQ[mtpd,mtpq]|6
pha.database 12 FREE L MIS.APPL *MTPQ[mtpd,mtpq]|0
pha.flag 10 FREE L *MTPQ[mtpd,mtpq]|10
pha.inventory 10 FREE L MM.INVENT *MTPQ[mtpd,mtpq]|8
pha.item 43 URN L MM.ITEM *MTPQ[mtpd,mtpq]|2
pha.purch.fac 10 FREE L MIS.PUR.FAC *MTPQ[mtpd,mtpq]|11
pha.type 1 CHOICE L *MTPQ[mtpd,mtpq]|1
pha.up 10 FREE L *MTPQ[mtpd,mtpq]|5
pha.updated 1 YN L *MTPQ[mtpd,mtpq]|7
pha.vendor 11 FREE L MIS.VEN *MTPQ[mtpd,mtpq]|3
Ì i 2
mm.item.pkg.copy (pkg.copy)
*MTPC
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.copy.created 10 FREE L *MTPC|0
pkg.copy.last.edit 10 FREE L *MTPC|1
Ì i 2
mm.item.pkg.copy.list (pkg.copy.list)
[pkg.copy.string]
*MTPC[mtP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.copy.string 40 FREE L mtP
Ì i 2
mm.item.pkg.templates (pkg.templates)
[pkg.string]
*MTP[mtP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pkg.string 40 mtP
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mm.item.category.index [category,item.urn]
categ.x ?MTC[ma,mt]
mm.item.component.indexc [component,item.urn]
component.x ?MTCX[mtC,mt]
mm.item.description.number.x [description,number] = item.urn
desc.number.x ?MTDN[mtD,mtR]
mm.item.description.index [description,item.urn]
desc.x ?MTD[mtD,mt]
mm.item.drug.index [pha.drug,item.urn]
drug.x ?MTG[tf,mt]
mm.item.forms.index [form,item.urn]
forms.x ?MTFX[mv,mt]
mm.item.generic.name.index [pha.generic.name,item.urn]
generic.name.x ?MTGN[tdgN,mt]
mm.item.id.x [sort.id,item.urn]
id.x ?MTI[mtI,mt]
mm.item.intersect.list [item.urn]
intersect.list /MTLX[mt]
mm.item.key.pointer.value.list [key,key.urn,key.value]
key.pointer.value.list /MTK[mtK,mt,mtKV]
mm.item.key.value.list [key,key.value]
key.value.list /MTVK[mtK,mtKV]
mm.item.ndc.din.index [pha.ndc.din.number,item.urn]
ndc.din.x ?MTND[tfND,mt]
mm.item.number.index [number,item.urn]
number.x ?MTR[mtR,mt]
mm.item.trade.name.index [name,item.urn]
trade.name.x ?MTTN[mtN,mt]
|
|
| | | | | | | | | | | | | | | | |