Ì i 2
mm.fac.item.edits (audit.trail)
[audit.item,audit.fac]
*MTFED[mt,mw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.item 43 URN L MM.ITEM mt
audit.fac 10 FREE L MIS.PUR.FAC mw
Ì € i 2
mm.item.fac.audit.trail (audit.trail.item)
[audit.item,audit.fac, audit.date,audit.seq]
*MTFED[mt,mw]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 *MTFED[mt,mw]A[mtMD,mtAS]|2
audit.field 6 CHOICE L *MTFED[mt,mw]A[mtMD,mtAS]|3
audit.from 40 FREE L *MTFED[mt,mw]A[mtMD,mtAS]|4
audit.pkging.str 40 FREE L VAL=@MM.ITEM.packaging[@item.urn,@audit.crnt.pkging]
audit.source 20 CHOICE L *MTFED[mt,mw]A[mtMD,mtAS]|6
audit.time 5 HHMM L *MTFED[mt,mw]A[mtMD,mtAS]|1
audit.to 40 FREE L *MTFED[mt,mw]A[mtMD,mtAS]|5
audit.user 10 FREE L MIS.USER *MTFED[mt,mw]A[mtMD,mtAS]|0
Ì € i 2
mm.item.fac.audit.trail.vend (audit.trail.vendors)
[audit.item,audit.fac,audit.date,audit.seq, audit.vend.no]
*MTFED[mt,mw]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 *MTFED[mt,mw]A[mtMD,mtAS]V[gr]|3
audit.vend.from 40 FREE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]|4
audit.vend.pkg.no 4 INT R *MTFED[mt,mw]A[mtMD,mtAS]V[gr]|2
audit.vend.source 20 CHOICE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]|6
audit.vend.time 5 HHMM L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]|1
audit.vend.to 40 FREE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]|5
audit.vend.user 10 FREE L MIS.USER *MTFED[mt,mw]A[mtMD,mtAS]V[gr]|0
Ì € i 2
mm.item.audit.trail.alt.cat (audit.trail.alt.cat)
[audit.item,audit.fac,audit.date,audit.seq,audit.vend.no, audit.alt.cat.no]
*MTFED[mt,mw]A[mtMD,mtAS]V[gr]ALT[gvCAL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.alt.cat.no 15 FREE L gvCAL
audit.alt.field 6 CHOICE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]ALT[gvCAL]|2
audit.alt.from 40 FREE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]ALT[gvCAL]|3
audit.alt.source 20 CHOICE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]ALT[gvCAL]|5
audit.alt.time 5 HHMM L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]ALT[gvCAL]|1
audit.alt.to 40 FREE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]ALT[gvCAL]|4
audit.alt.user 10 FREE L MIS.USER *MTFED[mt,mw]A[mtMD,mtAS]V[gr]ALT[gvCAL]|0
Ì € i 2
mm.item.fac.aud.tr.vend.unit (audit.trail.vendors.unit)
[audit.item,audit.fac,audit.date,audit.seq,audit.vend.no, audit.vu.vend.unit]
*MTFED[mt,mw]A[mtMD,mtAS]V[gr]U[md]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.vu.vend.unit 4 FREE L md
audit.vu.field 6 CHOICE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]U[md]|3
audit.vu.from 40 FREE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]U[md]|4
audit.vu.pkg.no 4 INT R *MTFED[mt,mw]A[mtMD,mtAS]V[gr]U[md]|2
audit.vu.source 20 CHOICE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]U[md]|6
audit.vu.time 5 HHMM L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]U[md]|1
audit.vu.to 40 FREE L *MTFED[mt,mw]A[mtMD,mtAS]V[gr]U[md]|5
audit.vu.user 10 FREE L MIS.USER *MTFED[mt,mw]A[mtMD,mtAS]V[gr]U[md]|0
Ì i 2
mm.item.facility (top)
[item.urn,item.fac]
*MTF[mt,mw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
item.urn 43 URN L mt
item.fac 10 FREE L MIS.PUR.FAC mw
fac.active 1 YN L *MTF[mt,mw]M|0
fac.eoc 7 FREE L MIS.GL.EOC *MTF[mt,mw]M|1
fac.id.flag 1 FREE L VAL=IF{@p.fac.active[item.urn,CD];" "}
fac.mark.up.per 8 PDEC4 R *MTF[mt,mw]M|5
fac.proc.code 10 FREE L *MTF[mt,mw]M|2
fac.tax.code 3 FREE L MIS.TAX.CODE *MTF[mt,mw]M|6
fac.taxable 1 YN L *MTF[mt,mw]M|4
is.converted 1 FREE L VAL=@fac.active[,@Z.del]
item.disp 43 FREE L VAL=(@t.MM.ITEM.number_" - "_@t.MM.ITEM.description'="
VAL= - ")
item.id 43 URN L MM.ITEM
number 10 FREE L *MTF[mt,mw]M|3
pvend.cat.no 15 FREE L *MTF[mt,mw]PV|1
pvend.comment 60 FREE L *MTF[mt,mw]PV|12
pvend.cont.exp.date 8 DATE L *MTF[mt,mw]PV|11
pvend.cont.group 60 FREE L *MTF[mt,mw]PV|10
pvend.contract.no 10 FREE L *MTF[mt,mw]PV|9
pvend.conv.pkg.size 10 FREE L *MTF[mt,mw]PV|5
pvend.cost.up 10 DEC4 R *MTF[mt,mw]PV|4
pvend.cost.us 10 DEC4 R *MTF[mt,mw]PV|13
pvend.manuf 10 FREE L MIS.MFR *MTF[mt,mw]PV|2
pvend.manuf.cat.no 15 FREE L *MTF[mt,mw]PV|3
pvend.no 11 FREE L MIS.VEN *MTF[mt,mw]PV|0
pvend.unit.of.pur 10 FREE L *MTF[mt,mw]PV|6
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=(@t.MM.ITEM.FAC.pvend.unit.of.pur%(L(@t.MM.ITEM.FA
VAL=C.pvend.unit.of.pur," "))!@t.MM.ITEM.FAC.pvend.uni
VAL=t.of.pur)
pvend.up.us 5 PINT R *MTF[mt,mw]PV|8
pvend.up.with.us 15 FREE L *MTF[mt,mw]PV|7
sort.id 43 FREE L
Ì € i 2
mm.itemfac.vendor.order (vendor.order)
[item.urn,item.fac, vendor.order.no]
*MTF[mt,mw]O[mtV]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vendor.order.no 2 PINT R mtV
dis.vend.contract 1 FREE L VAL=IF{@vend.contract.no[@vendor.num] "Y";"N"}
dis.vend.cost 11 SMONEY R VAL=IF{@vend.unit.of.pur.unit[@vendor.num]^vend.unit,@
VAL=vu.cost.unit[@vendor.num,pkg.no,vend.unit]}
dis.vend.name 35 FREE L VAL=@MIS.VEN.name[@vendor.num]
dis.vend.up 10 FREE L VAL=@vend.unit.of.pur[@vendor.num]
vendor.num 11 FREE L MIS.VEN *MTF[mt,mw]O[mtV]|1
Ì € i 2
mm.itemfac.vendors (vendors)
[item.urn,item.fac, vendor.no]
*MTF[mt,mw]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 *MTF[mt,mw]V[gr]|0
vend.cat.no 15 FREE L *MTF[mt,mw]V[gr]|2
vend.comment 75 FREE L *MTF[mt,mw]V[gr]|8
vend.cont.exp.date 8 DATE L *MTF[mt,mw]V[gr]|7
vend.cont.group 60 FREE L *MTF[mt,mw]V[gr]|6
vend.contract.no 15 FREE L *MTF[mt,mw]V[gr]|5
vend.manuf 10 FREE L MIS.MFR *MTF[mt,mw]V[gr]|3
vend.manuf.cat.no 15 FREE L *MTF[mt,mw]V[gr]|4
vend.tx.cd 3 FREE L MIS.TAX.CODE *MTF[mt,mw]V[gr]|10
vend.unit.of.pur 10 FREE L *MTF[mt,mw]V[gr]|1
vend.unit.of.pur.unit 4 FREE L *MTF[mt,mw]V[gr]|9
Ì € i 2
mm.itemfac.edi.updates (edi.updates)
[item.urn,item.fac,vendor.no, eup.date]
*MTF[mt,mw]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 *MTF[mt,mw]V[gr]D[mtED]|2
eup.lin.seg 5 PINT R *MTF[mt,mw]V[gr]D[mtED]|1
eup.session 5 PINT R *MTF[mt,mw]V[gr]D[mtED]|0
eup.upd 6 PINT R *MTF[mt,mw]V[gr]D[mtED]|4
eup.view 15 FREE L *MTF[mt,mw]V[gr]D[mtED]|3
Ì € i 2
mm.itemfac.vend.alt (vendor.alternates)
[item.urn,item.fac,vendor.no, vend.alt.cat.no]
*MTF[mt,mw]V[gr]VA[gvCAL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vend.alt.cat.no 15 FREE L gvCAL
vend.alt.catalog.number 15 FREE L *MTF[mt,mw]V[gr]VA[gvCAL]|6
vend.alt.conv.unit 10 FREE L *MTF[mt,mw]V[gr]VA[gvCAL]|2
vend.alt.cost.up 10 DEC4 R *MTF[mt,mw]V[gr]VA[gvCAL]|3
vend.alt.manuf.number 15 FREE L *MTF[mt,mw]V[gr]VA[gvCAL]|5
vend.alt.manufacturer 10 FREE L MIS.MFR *MTF[mt,mw]V[gr]VA[gvCAL]|4
vend.alt.unit.of.purchase 10 FREE L *MTF[mt,mw]V[gr]VA[gvCAL]|1
vend.alt.view 1 FREE L VAL=IF{""^VW,IF{+@vendor.alternates[@t.item.urn,,,""]
VAL=1^VW,%MM.ITEM.FAC.view.addl.vend.cat.no(VW),VW} "Y
VAL=";"N"}
Ì € i 2
mm.itemfac.vend.contracts (vendor.contracts)
[item.urn,item.fac,vendor.no, cntr.eff.date]
*MTF[mt,mw]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 *MTF[mt,mw]V[gr]C[mtCD]|1
cntr.cost.up.unit 10 FREE L *MTF[mt,mw]V[gr]C[mtCD]|2
cntr.number 15 FREE L *MTF[mt,mw]V[gr]C[mtCD]|0
Ì € i 2
mm.itemfac.vendor.contracts.o (vendor.contracts.o)
[item.urn,item.fac,vendor.no,cntr.eff.date, vco.unit]
*MTF[mt,mw]V[gr]C[mtCD]O[md]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vco.unit 4 FREE L md
vco.cost.unit 10 PDEC4 R *MTF[mt,mw]V[gr]C[mtCD]O[md]|0
Ì € i 2
mm.itemfac.vend.purch.info (vendor.purch.info)
[item.urn,item.fac,vendor.no, vend.pkg.no,vend.unit]
*MTF[mt,mw]V[gr]A[mtT,md]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vend.pkg.no 4 URN L mtT
vend.unit 4 FREE L md
vu.active 1 YN L *MTF[mt,mw]V[gr]A[mtT,md]|0
vu.conv.pkg.size 10 FREE L *MTF[mt,mw]V[gr]A[mtT,md]|2
vu.cost.unit 10 DEC4 R *MTF[mt,mw]V[gr]A[mtT,md]|1
vu.cost.us 10 DEC4 R *MTF[mt,mw]V[gr]A[mtT,md]|5
vu.p.cnv.pkg 10 FREE L *MTF[mt,mw]V[gr]A[mtT,md]|14
vu.p.cost 10 FREE L *MTF[mt,mw]V[gr]A[mtT,md]|15
vu.p.up 10 FREE L *MTF[mt,mw]V[gr]A[mtT,md]|13
vu.psu.flag 1 FREE L *MTF[mt,mw]V[gr]A[mtT,md]|16
vu.qty1.cost 10 DEC4 R *MTF[mt,mw]V[gr]A[mtT,md]|10
vu.qty1.min 7 PINT R *MTF[mt,mw]V[gr]A[mtT,md]|9
vu.qty2.cost 10 DEC4 R *MTF[mt,mw]V[gr]A[mtT,md]|12
vu.qty2.min 7 PINT R *MTF[mt,mw]V[gr]A[mtT,md]|11
vu.unit.sizeno 4 PINT R *MTF[mt,mw]V[gr]A[mtT,md]|6
vu.unit.us 5 PINT R *MTF[mt,mw]V[gr]A[mtT,md]|4
vu.unit.with.us 15 FREE L *MTF[mt,mw]V[gr]A[mtT,md]|3
vu.up 10 FREE L *MTF[mt,mw]V[gr]A[mtT,md]|7
vu.upn 20 FREE L *MTF[mt,mw]V[gr]A[mtT,md]|8
Ì € i 2
mm.itemfac.vend.upn (vendor.upn)
[item.urn,item.fac,vendor.no, upn.pkg.no,upn.unit]
*MTF[mt,mw]V[gr]UPN[mtT,md]
Field Name Len Dat Typ J DPM Offset/Local/VAL
upn.pkg.no 4 URN L mtT
upn.unit 4 FREE L md
upn.iu.flag 1 FREE L *MTF[mt,mw]V[gr]UPN[mtT,md]|1
upn.upn 20 FREE L *MTF[mt,mw]V[gr]UPN[mtT,md]|0
Ì i 2
mm.itemfac.ven.active.cont (ven.active.contracts)
[vc.item.urn,vc.vendor,vc.fac]
*MTFCC[mt,gr,mw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vc.item.urn 43 URN L mt
vc.vendor 11 FREE L MIS.VEN gr
vc.fac 10 FREE L MIS.PUR.FAC mw
vc.contract 15 FREE L *MTFCC[mt,gr,mw]|0
vc.exp.date 10 DATE L *MTFCC[mt,gr,mw]|1
vc.up 10 FREE L *MTFCC[mt,gr,mw]|2
vc.up.unit 10 FREE L *MTFCC[mt,gr,mw]|3
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mm.item.fac.manuf.catlg.index [item.fac,pvend.manuf.cat.no,item.urn]
catlg.x ?MTFMC[mw,gmC,mt]
mm.item.fac.id.x [item.fac,sort.id,item.urn]
id.x ?MTFI[mw,mtI,mt]
mm.item.fac.manufacturer.index [item.fac,vend.manuf,item.urn]
manuf.x ?MTFM[mw,gm,mt]
mm.item.fac.number.index [item.fac,number,item.urn]
number.x ?MTFR[mw,mtR,mt]
mm.item.fac.upn.index [item.fac,upn.upn,item.urn]
upn.x ?MTFUPN[mw,mtUPN,mt]
mm.item.fac.vendor.catlg.index [item.fac,vend.cat.no,item.urn]
ven.catlg.x ?MTFVC[mw,gvC,mt]
mm.item.fac.vendor.index [item.fac,vendor.no,item.urn,vendor.order.no]
vendor.id.x ?MTFV[mw,gr,mt,mtV]
|
|
| | | | | | | | | | | | | |