Ì 2
mm.pur.stats.abc.abc.data (abc.abc.data)
[abc.abc]
*MG.ABC["A",mgAB1]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abc.abc 1 CHOICE L mgAB1
abc.total.count 6 PINT R *MG.ABC["A",mgAB1]|0
abc.total.value 12 SMONEY R *MG.ABC["A",mgAB1]|1
Ì € 2
mm.pur.stats.abc.item.data (abc.item.data)
[abc.abc, abc.seq]
*MG.ABC["A",mgAB1]I[mgAB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abc.seq 6 PINT R mgAB
abc.item.urn 43 URN L MM.ITEM *MG.ABC["A",mgAB1]I[mgAB]|0
abc.value 10 SMONEY R *MG.ABC["A",mgAB1]I[mgAB]|1
Ì 2
mm.pur.stats (main)
[date]
*MG[mg]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date 8 DATE L mg
closed.date 8 DATE L *MG[mg]|1
closed.time 4 TIME L *MG[mg]|2
closing 7 FREE L *MG[mg]|0
period 10 FREE L MIS.GL.PERIOD VAL=MIS.GL.PERIOD.date.x[c.date]
Ì € 2
mm.pur.stats.buyers (buyers)
[date, buyer]
*MG[mg]E[gu]
Field Name Len Dat Typ J DPM Offset/Local/VAL
buyer 10 FREE L MIS.USER gu
buyer.no.lines 7 PINT R *MG[mg]E[gu]|3
buyer.no.pos 7 PINT R *MG[mg]E[gu]|2
buyer.no.return.pos 7 PINT R *MG[mg]E[gu]|8
buyer.order.value 10 SMONEY R *MG[mg]E[gu]|1
buyer.return.value 10 SMONEY R *MG[mg]E[gu]|7
buyer.ytd.no.lines 7 PINT R *MG[mg]E[gu]|6
buyer.ytd.no.pos 7 PINT R *MG[mg]E[gu]|5
buyer.ytd.no.return.pos 7 PINT R *MG[mg]E[gu]|10
buyer.ytd.order.value 10 SMONEY R *MG[mg]E[gu]|4
buyer.ytd.return.value 10 SMONEY R *MG[mg]E[gu]|9
Ì € 2
mm.pur.stats.depts (depts)
[date, dept]
*MG[mg]A[gd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dept 15 FREE L MIS.GL.DEPT gd
Ì € 2
mm.pur.ststs.dept.accts (dept.accts)
[date,dept, dept.acct]
*MG[mg]A[gd,ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dept.acct 25 FREE L MIS.GL.ACCOUNT ga
Ì € 2
mm.pur.stats.depts.accts.items (dept.acct.items)
[date,dept,dept.acct, dept.acct.item]
*MG[mg]A[gd,ga,mt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
dept.acct.item 43 URN L MM.ITEM mt
dai.no.pos 7 PINT R *MG[mg]A[gd,ga,mt]|4
dai.on.order.qty.up 10 INT R VAL=(@dai.on.order.qty.us!0^XX/(IF{@MM.ITEM.FAC.pvend.
VAL=up.us[@dept.acct.item,@Z.del];@dai.up.us}^SU)_IF{X
VAL=X\SU'=0^XX ";"_XX})
dai.on.order.qty.us 7 PINT R *MG[mg]A[gd,ga,mt]|5
dai.on.order.valu 10 SMONEY R VAL=(@dai.on.order.value!0)
dai.on.order.value 10 SMONEY R *MG[mg]A[gd,ga,mt]|6
dai.order.qty.up 7 INT R VAL=(@dai.order.qty.us^XX/(IF{@MM.ITEM.FAC.pvend.up.us
VAL=[@dept.acct.item,@Z.del];@dai.up.us}^SU)_IF{XX\SU'
VAL==0^XX ";"_XX})
dai.order.qty.us 7 PINT R *MG[mg]A[gd,ga,mt]|0
dai.order.value 10 SMONEY R *MG[mg]A[gd,ga,mt]|1
dai.rcv.qty.up 7 INT R VAL=(@dai.rcv.qty.us^XX/(IF{@MM.ITEM.FAC.pvend.up.us[@
VAL=dept.acct.item,@Z.del];@dai.up.us}^SU)_IF{XX\SU'=0
VAL=^XX ";"_XX})
dai.rcv.qty.us 7 PINT R *MG[mg]A[gd,ga,mt]|2
dai.rcv.value 10 SMONEY R *MG[mg]A[gd,ga,mt]|3
dai.up.us 7 FREE L *MG[mg]A[gd,ga,mt]|7
dai.ytd.no.pos 7 PINT R *MG[mg]A[gd,ga,mt]|10
dai.ytd.order.qty.up 7 INT R VAL=(@dai.ytd.order.qty.us^XX/(IF{@MM.ITEM.FAC.pvend.u
VAL=p.us[@dept.acct.item,@Z.del];@dai.up.us}^SU)_IF{XX
VAL=\SU'=0^XX ";"_XX})
dai.ytd.order.qty.us 7 PINT R *MG[mg]A[gd,ga,mt]|8
dai.ytd.order.value 10 SMONEY R *MG[mg]A[gd,ga,mt]|9
Ì € 2
mm.pur.stats.inv (inventories)
[date, inv]
*MG[mg]I[mi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv 10 FREE L MM.INVENT mi
Ì € 2
mm.pur.stats.inv.accts (inv.accts)
[date,inv, inv.acct]
*MG[mg]I[mi,ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv.acct 25 FREE L MIS.GL.ACCOUNT ga
Ì € 2
mm.pur.stats.inv.accts.items (inv.acct.items)
[date,inv,inv.acct, inv.acct.item]
*MG[mg]I[mi,ga,mt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv.acct.item 43 URN L MM.ITEM mt
iai.no.pos 7 PINT R *MG[mg]I[mi,ga,mt]|4
iai.on.order.qty.up 10 INT R VAL=(@iai.on.order.qty.us!0^XX/(IF{@MM.ITEM.FAC.pvend.
VAL=up.us[@inv.acct.item,@Z.del];@iai.up.us}^SU)_IF{XX
VAL=\SU'=0^XX ";"_XX})
iai.on.order.qty.us 7 PINT R *MG[mg]I[mi,ga,mt]|5
iai.on.order.valu 10 SMONEY R VAL=(@iai.on.order.value!0)
iai.on.order.value 10 SMONEY R *MG[mg]I[mi,ga,mt]|6
iai.order.qty.up 7 INT R VAL=(@iai.order.qty.us^XX/(IF{@MM.ITEM.FAC.pvend.up.us
VAL=[@inv.acct.item,@Z.del];@iai.up.us}^SU)_IF{XX\SU'=
VAL=0^XX ";"_XX})
iai.order.qty.us 7 PINT R *MG[mg]I[mi,ga,mt]|0
iai.order.value 10 SMONEY R *MG[mg]I[mi,ga,mt]|1
iai.rcv.qty.up 7 INT R VAL=(@iai.rcv.qty.us^XX/(IF{@MM.ITEM.FAC.pvend.up.us[@
VAL=inv.acct.item,@Z.del];@iai.up.us}^SU)_IF{XX\SU'=0^
VAL=XX ";"_XX})
iai.rcv.qty.us 7 PINT R *MG[mg]I[mi,ga,mt]|2
iai.rcv.value 10 SMONEY R *MG[mg]I[mi,ga,mt]|3
iai.up.us 7 FREE L *MG[mg]I[mi,ga,mt]|7
iai.ytd.no.pos 7 PINT R *MG[mg]I[mi,ga,mt]|10
iai.ytd.order.qty.up 7 INT R VAL=(@iai.ytd.order.qty.us^XX/(IF{@MM.ITEM.FAC.pvend.u
VAL=p.us[@inv.acct.item,@Z.del];@iai.up.us}^SU)_IF{XX\
VAL=SU'=0^XX ";"_XX})
iai.ytd.order.qty.us 7 PINT R *MG[mg]I[mi,ga,mt]|8
iai.ytd.order.value 10 SMONEY R *MG[mg]I[mi,ga,mt]|9
Ì € 2
mm.pur.stats.vendors (vendors)
[date, vendor]
*MG[mg]C[gr]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vendor 11 FREE L MIS.VEN gr
vend.cmplt.time.sum 7 PINT R *MG[mg]C[gr]|13
vend.comp.avg.time 6 PDEC2 R VAL=(@vend.cmplt.time.sum:5D/@vend.no.compl.pos:2D)
vend.first.avg.time 6 PDEC2 R VAL=(@vend.lead.sum:5D/@vend.first.dlvs:2D)
vend.first.dlvs 7 PINT R *MG[mg]C[gr]|7
vend.first.rcpts.count 7 PINT R *MG[mg]C[gr]|18
vend.first.rcpts.pct.tot 7 PDEC3 R *MG[mg]C[gr]|17
vend.first.rcpts.qty 7 PINT R *MG[mg]C[gr]|11
vend.first.rcts.ord.qty 7 PINT R *MG[mg]C[gr]|9
vend.lead.sum 7 PINT R *MG[mg]C[gr]|16
vend.no.compl.pos 7 PINT R *MG[mg]C[gr]|15
vend.no.late.dlvs 7 PINT R *MG[mg]C[gr]|12
vend.no.lines 7 PINT R *MG[mg]C[gr]|14
vend.no.pos 7 PINT R *MG[mg]C[gr]|8
vend.order.value 10 SMONEY R *MG[mg]C[gr]|1
vend.percent.late 6 PDEC2 R VAL=(@vend.no.late.dlvs:5D/@vend.first.dlvs*100:2D)
vend.percent.recd 6 PDEC2 R VAL=(@vend.first.rcpts.pct.tot:5D/@vend.first.rcpts.co
VAL=unt:2D)
vend.rcpts.per.line 6 PDEC2 R VAL=(@vend.reg.tot.rcpts:5D/@vend.reg.lns.compltd:2D)
vend.rcv.qty 7 PINT R *MG[mg]C[gr]|2
vend.rcv.value 10 SMONEY R *MG[mg]C[gr]|3
vend.reg.lns.compltd 7 PINT R *MG[mg]C[gr]|6
vend.reg.lns.ord 7 PINT R *MG[mg]C[gr]|6
vend.reg.tot.rcpts 7 PINT R *MG[mg]C[gr]|10
Ì € 2
mm.pur.stats.vendors.items (vend.items)
[date,vendor, vend.item]
*MG[mg]C[gr,mt]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vend.item 43 URN L MM.ITEM mt
vend.item.no.lines 7 PINT R *MG[mg]C[gr,mt]|2
vend.item.rcv.qty.up 7 INT R
vend.item.rcv.qty.us 7 PINT R *MG[mg]C[gr,mt]|0
vend.item.rcv.value 10 SMONEY R *MG[mg]C[gr,mt]|1
|
|
| | | | | | | | | |