Ì € i 2
mm.stock.abc.data (abc.abc.data)
[abc.inventory, abc.abc]
*MS.ABC[mi]A[msAB1]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abc.abc 1 CHOICE L msAB1
abc.total.count 6 PINT R *MS.ABC[mi]A[msAB1]|0
abc.total.value 12 SMONEY R *MS.ABC[mi]A[msAB1]|1
Ì € i 2
mm.stock.abc.stock.data (abc.stock.data)
[abc.inventory,abc.abc, abc.seq]
*MS.ABC[mi]A[msAB1]S[msAB]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abc.seq 6 PINT R msAB
abc.stock.urn 18 URN L MM.STOCK *MS.ABC[mi]A[msAB1]S[msAB]|0
abc.value 10 SMONEY R *MS.ABC[mi]A[msAB1]S[msAB]|1
Ì i 2
mm.stock.closing.list (closing.list)
[job.no,clos.inv]
*MSCLO[msJOB,mi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
job.no 3 PINT R msJOB
clos.inv 10 FREE L MM.INVENT mi
Ì i 2
mm.stock.lock (lock)
[locked.inventory]
:MSLOCK[mi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
locked.inventory 10 FREE L MM.INVENT mi
Ì i 2
mm.stock.opt.inventory.data (opt.inventory.data)
[opt.inventory]
*MS.OPT[mi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
opt.inventory 10 FREE L MM.INVENT mi
opt.compile.status 10 CHOICE L *MS.OPT[mi]|1
opt.last.compiled 8 DATE L *MS.OPT[mi]|0
Ì € i 2
mm.stock.opt.stock.data (opt.stock.data)
[opt.inventory, opt.stock.urn]
*MS.OPT[mi]S[ms]
Field Name Len Dat Typ J DPM Offset/Local/VAL
opt.stock.urn 18 URN L MM.STOCK ms
opt.avg.usage.ui 7 PINT R *MS.OPT[mi]S[ms]|6
opt.date.compiled 8 DATE L *MS.OPT[mi]S[ms]|7
opt.date.updated 8 DATE L *MS.OPT[mi]S[ms]|8
opt.days.bet.orders.avg 3 PINT R *MS.OPT[mi]S[ms]|9
opt.days.bet.orders.opt 3 PINT R *MS.OPT[mi]S[ms]|10
opt.lead.time 3 PINT R *MS.OPT[mi]S[ms]|3
opt.mrp.ui 5 PINT R *MS.OPT[mi]S[ms]|2
opt.num.months 3 PINT R *MS.OPT[mi]S[ms]|4
opt.num.po 3 PINT R *MS.OPT[mi]S[ms]|5
opt.ooq.ui 5 PINT R *MS.OPT[mi]S[ms]|0
opt.safety.stock.ui 5 PINT R *MS.OPT[mi]S[ms]|1
Ì i 2
mm.stock.period.end.vector (period.end.vector)
[pe.inventory,pe.urn,pe.date]
*MSPE[mi,ms,msPD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pe.inventory 10 FREE L MM.INVENT mi
pe.urn 18 URN L MM.STOCK ms
pe.date 8 DATE L msPD
pe.adjust.qty 7 PINT R *MSPE[mi,ms,msPD]|14
pe.adjust.value 10 DEC2 R *MSPE[mi,ms,msPD]|15
pe.dept.issue.qty 7 PINT R *MSPE[mi,ms,msPD]|8
pe.dept.issue.value 10 DEC2 R *MSPE[mi,ms,msPD]|9
pe.dept.return.qty 7 PINT R *MSPE[mi,ms,msPD]|10
pe.dept.return.value 10 DEC2 R *MSPE[mi,ms,msPD]|11
pe.init.qty 7 PINT R *MSPE[mi,ms,msPD]|20
pe.init.value 10 DEC2 R *MSPE[mi,ms,msPD]|21
pe.net.qty.in 7 PINT R *MSPE[mi,ms,msPD]|2
pe.net.value.in 10 DEC2 R *MSPE[mi,ms,msPD]|3
pe.patient.issue.qty 7 PINT R *MSPE[mi,ms,msPD]|12
pe.patient.issue.value 10 DEC2 R *MSPE[mi,ms,msPD]|13
pe.qty.on.hand 7 PINT R *MSPE[mi,ms,msPD]|0
pe.rcpt.qty 7 PINT R *MSPE[mi,ms,msPD]|4
pe.rcpt.value 10 DEC2 R *MSPE[mi,ms,msPD]|5
pe.undist.tax 10 DEC2 R *MSPE[mi,ms,msPD]|22
pe.usage.qty 7 PINT R *MSPE[mi,ms,msPD]|18
pe.usage.value 10 DEC2 R *MSPE[mi,ms,msPD]|19
pe.value.on.hand 10 DEC2 R *MSPE[mi,ms,msPD]|1
pe.xfer.in.qty 7 PINT R *MSPE[mi,ms,msPD]|6
pe.xfer.in.value 10 DEC2 R *MSPE[mi,ms,msPD]|7
pe.xfer.out.qty 7 PINT R *MSPE[mi,ms,msPD]|16
pe.xfer.out.value 10 DEC2 R *MSPE[mi,ms,msPD]|17
Ì i 2
mm.stock.compiled.reports (reports)
[report]
*MSW[msw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
report 10 FREE L msw
rep.compile.status 10 CHOICE L *MSW[msw]C|0
rep.from.period 10 FREE L MIS.GL.PERIOD *MSW[msw]C|16
rep.inquiry.format 1 CHOICE L *MSW[msw]C|7
rep.new.page 5 CHOICE L *MSW[msw]C|12
rep.num.records 6 PINT R *MSW[msw]C|11
rep.report.format 1 CHOICE L *MSW[msw]C|6
rep.selection 10 FREE L MM.SELECT *MSW[msw]C|14
rep.sort.1 15 FREE L MM.FIELDS *MSW[msw]C|8
rep.sort.2 15 FREE L MM.FIELDS *MSW[msw]C|9
rep.sort.3 15 FREE L MM.FIELDS *MSW[msw]C|10
rep.start.date 8 DATE L *MSW[msw]C|1
rep.start.time 5 TIME L *MSW[msw]C|2
rep.stop.date 8 DATE L *MSW[msw]C|3
rep.stop.time 5 TIME L *MSW[msw]C|4
rep.subtotal 5 CHOICE L *MSW[msw]C|13
rep.thru.period 10 FREE L MIS.GL.PERIOD *MSW[msw]C|17
rep.title 50 FREE L *MSW[msw]C|5
rep.type 5 CHOICE L *MSW[msw]C|15
Ì € i 2
mm.stock.report.inventories (report.inventories)
[report, rep.inventory]
*MSW[msw]C["I",mi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rep.inventory 10 FREE L MM.INVENT mi
Ì € i 2
mm.stock.reports.selections (selections)
[report, rep.sel.queue]
*MSW[msw]C["S",mswS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rep.sel.queue 2 PINT R mswS
rep.select.field 15 FREE L MM.FIELDS *MSW[msw]C["S",mswS]|0
rep.select.from 30 FREE L *MSW[msw]C["S",mswS]|1
rep.select.from.date 8 DATE L *MSW[msw]C["S",mswS]|3
rep.select.to 30 FREE L *MSW[msw]C["S",mswS]|2
rep.select.to.date 8 DATE L *MSW[msw]C["S",mswS]|4
Ì € i 2
mm.stock.compiled.report.data (report.data)
[report, rep.sort1,rep.sort2,rep.sort3,rep.stock.no,rep.stock.urn]
*MSW[msw]R[msS1,msS2,msS3,msSN,ms]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rep.sort1 15 FREE L msS1
rep.sort2 15 FREE L msS2
rep.sort3 15 FREE L msS3
rep.stock.no 18 FREE L msSN
rep.stock.urn 10 URN L ms
Ì € i 2
mm.stock.report.rcpts (report.rcpts)
[report,rep.sort1,rep.sort2,rep.sort3,rep.stock.no,rep.stock.urn, receipt.date,receipt.urn]
*MSW[msw]R[msS1,msS2,msS3,msSN,ms]R[msRD,msRU]
Field Name Len Dat Typ J DPM Offset/Local/VAL
receipt.date 8 DATE L msRD
receipt.urn 5 URN L msRU
Ì € i 2
mm.stock.report.txns (report.txns)
[report,rep.sort1,rep.sort2,rep.sort3,rep.stock.no,rep.stock.urn, rep.txn.type,rep.txn.date,rep.txn.urn]
*MSW[msw]R[msS1,msS2,msS3,msSN,ms]T[msTT,msTD,msTU]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rep.txn.type 1 CHOICE L msTT
rep.txn.date 8 DATE L msTD
rep.txn.urn 4 URN L msTU
Ì i 2
mm.stock (top)
[urn]
:MS[ms]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 18 URN L ms
abc.status 1 CHOICE L :MS[ms]A["C"]|4
active 1 YN L :MS[ms]A|0
asset.account 25 FREE L MIS.GL.ACCOUNT :MS[ms]A["C"]|15
avg.cost 10 DEC R :MS[ms]A|18
avg.cost.ui 10 DEC4 R VAL=(@avg.cost*@ui.us:4D)
avg.usage 10 DEC2 R :MS[ms]A["C"]|16
avg.usage.ui 7 PINT R VAL=(IF{@avg.usage/@ui.us:0D'="-0";0})
avg.usage.ui.per.month 7 PINT R VAL=((365/%MIS.GL.PERIOD.periods.in.fy(@MM.STATUS.inv.
VAL=last.date.closed))*@avg.usage/@ui.us:0D)
below.mrp 1 YN L VAL=IF{0+@qty.on.hand+@qty.on.order-@qty.on.backorder-
VAL=@mrp'>0 "Y";"N"}
below.mrp.qoh.only 1 YN L VAL=IF{0+@qty.on.hand-@qty.on.backorder-@mrp'>0 "Y"
VAL=;"N"}
below.mrp.qoo 1 YN L VAL=IF{0+@qty.on.hand+IF{c.incl.qoo="Y" @qty.on.order}
VAL=-@qty.on.backorder-@mrp'>0 "Y";"N"}
category 8 FREE L MM.CATEGORY :MS[ms]A|15
comment 60 FREE L :MS[ms]A["C"]|11
comment.disp 60 FREE L VAL=IF{@comment#0="#"&@MM.COMMENT.main[@comment%0] @MM
VAL=.COMMENT.comment[@comment%0,1];@comment}
critical.item 1 YN L :MS[ms]A["C"]|9
crnt.packaging 25 FREE L VAL=@MM.ITEM.packaging[@MM.STOCK.item,@MM.ITEM.crnt.pk
VAL=ging[@MM.STOCK.item]]
cur.rcv.date 8 DATE L :MS[ms]A|6
cur.rcv.urn 7 URN L :MS[ms]A|7
days.on.hand 4 PINT R VAL=IF{@avg.usage-0>0 @qty.on.hand/@avg.usage:0D}
desc.and.pkg 58 FREE L VAL=IF{urn @MM.ITEM.description[@item]_" - "_@MM.ITEM.
VAL=packaging[@item]}
description 30 FREE L VAL=@MM.ITEM.description[@MM.STOCK.item]
dollar.value.on.hand 10 DEC2 R VAL=(@value.on.hand:2D)
eoc 7 FREE L MIS.GL.EOC :MS[ms]A["C"]|12
form.yn 1 YN L VAL=IF{@MM.ITEM.form[@item] "Y";"N"}
from.pha 1 YN L :MS[ms]A["C"]|22
id 18 URN L MM.STOCK VAL=@stock.no
inventory 10 FREE L MM.INVENT :MS[ms]A|1
item 43 URN L MM.ITEM :MS[ms]A|3
last.adjustment.date 8 DATE L VAL=-@transactions[urn,"A",""]
last.txn 7 URN L :MS[ms]A|5
last.update 10 FREE L :MS[ms]A["UPD"]
lead.time 3 PINT R :MS[ms]A["C"]|7
location 10 FREE L :MS[ms]A|12
main.inv.stock.urn 18 URN L MM.STOCK :MS[ms]A["S"]|3
max.issue.qty.ui 5 PINT R :MS[ms]A["C"]|2
max.shelf.qty.ui 5 PINT R :MS[ms]A["C"]|1
mfr 10 FREE L MIS.MFR :MS[ms]A|19
mfr.description 43 FREE L VAL=(@mfr_" "_@MIS.MFR.name[@mfr]:43T)
min.issue.qty.ui 5 PINT R :MS[ms]A["C"]|3
mrp 5 INT R :MS[ms]A|17
mrp.ui 5 INT R :MS[ms]A["C"]|0
number.chg.date 8 DATE L :MS[ms]A["C"]|18
number.chg.qty.on.hand 7 PINT R :MS[ms]A["C"]|19
number.chg.txn 4 URN L :MS[ms]A["C"]|17
number.chg.value.on.hand 10 DEC4 R :MS[ms]A["C"]|20
ooq.ui 5 PINT R :MS[ms]A["C"]|5
order.on.po 1 YN L :MS[ms]A["S"]|7
packaging 25 FREE L VAL=@MM.ITEM.package.string.disp$25
pha.db 12 FREE L MIS.APPL :MS[ms]A["C"]|23
pi.adj.txn.date 8 DATE L :MS[ms]PI|5
pi.date 8 DATE L :MS[ms]PI|0
pi.post.date 8 DATE L :MS[ms]PI|2
pi.qty 7 PINT R :MS[ms]PI|1
pi.qty.ui.partial 10 FREE L VAL=(@pi.qty^XX/@ui.us_IF{XX\@ui.us^XX'=0 ";"_XX})
pi.system.qty 7 INT R :MS[ms]PI|4
pi.user 10 FREE L :MS[ms]PI|3
pkging.ptr 4 INT R VAL=@MM.ITEM.crnt.pkging[@MM.STOCK.item]
primary.vendor 11 FREE L MIS.VEN :MS[ms]A|13
pt.eoc 7 FREE L MIS.GL.EOC :MS[ms]A["S"]|6
pt.max.issue.qty.ui 5 PINT R :MS[ms]A["S"]|4
pt.min.issue.qty.ui 5 PINT R :MS[ms]A["S"]|5
pt.procedure.code 10 FREE L :MS[ms]A["S"]|2
pt.ui.us 7 PINT R :MS[ms]A["S"]|1
pt.unit.of.issue 4 FREE L :MS[ms]A["S"]|0
qty.on.backorder 7 PINT R :MS[ms]A["C"]|21
qty.on.backorder.ui 7 PINT R VAL=(@qty.on.backorder/@ui.us)
qty.on.backorder.ui.part 10 FREE L VAL=(@qty.on.backorder^XX/@ui.us_IF{XX\@ui.us^XX'=0 ";
VAL="_XX})
qty.on.hand 7 PINT R :MS[ms]A|9
qty.on.hand.ui 7 PINT R VAL=(@qty.on.hand/@ui.us)
qty.on.hand.ui.partial 10 FREE L VAL=(@qty.on.hand^XX/@ui.us_IF{XX\@ui.us^XX'=0 ";"_XX}
VAL=)
qty.on.order 7 PINT R :MS[ms]A|11
qty.on.order.ui 7 PINT R VAL=(@qty.on.order/@ui.us)
qty.on.order.ui.partial 10 FREE L VAL=(@qty.on.order^XX/@ui.us_IF{XX\@ui.us^XX'=0 ";"_XX
VAL=})
rec.order.qty.ui 5 PINT R VAL=%MM.STOCK.get.rec.order.qty.ui(urn)
rec.order.qty.us 7 PINT R VAL=%MM.STOCK.get.rec.order.qty(urn)
restock.from.inventory 10 FREE L MM.INVENT :MS[ms]A["S"]|8
safety.stock.ui 5 PINT R :MS[ms]A["C"]|6
sort.generic.name 31 FREE L VAL=" "_@MM.ITEM.pha.generic.name[@item]
sort.location 11 FREE L VAL=" "_@MM.STOCK.location
stand.order.item 1 YN L :MS[ms]A["C"]|10
stock.conv.up 10 FREE L :MS[ms]A["S"]|10
stock.no 18 FREE L :MS[ms]A|2
stock.up 4 FREE L :MS[ms]A["S"]|9
transfer.item 1 YN L :MS[ms]A|4
ui.us 7 PINT R :MS[ms]A|8
unit.of.issue 4 FREE L :MS[ms]A|16
unit.of.issue.with.us 15 FREE L :MS[ms]A|20
value.on.hand 10 DEC4 R :MS[ms]A|10
vendor.cost.ui 10 DEC4 R :MS[ms]A|14
vendor.description 43 FREE L VAL=(@primary.vendor_" "_@MIS.VEN.name[@primary.vendor
VAL=]:43T)
Ì € i 2
mm.stock.exception.eocs (except.dept.eocs)
[urn, except.dept]
:MS[ms]A["E",gd]
Field Name Len Dat Typ J DPM Offset/Local/VAL
except.dept 15 FREE L MIS.GL.DEPT gd
except.dept.eoc 7 FREE L MIS.GL.EOC :MS[ms]A["E",gd]|0
Ì € i 2
mm.stock.other.locations (other.locations)
[urn, other.location]
:MS[ms]A["O",msOL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
other.location 10 FREE L msOL
Ì € i 2
mm.stock.opening (opening)
[urn, open.date]
:MS[ms]D[msOD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
open.date 8 DATE L msOD
open.qty 7 PINT R :MS[ms]D[msOD]|0
open.value 10 DEC4 R :MS[ms]D[msOD]|1
Ì € i 2
mm.receipts (rcv.transactions)
[urn, rcv.date,rcv.urn]
:MS[ms]R[msRD,msRU]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rcv.date 8 DATE L msRD
rcv.urn 5 URN L msRU
po.line.no 4 PINT R :MS[ms]R[msRD,msRU]|15
po.number 10 FREE L :MS[ms]R[msRD,msRU]|5
rcv.comment 60 FREE L :MS[ms]R[msRD,msRU]|13
rcv.cost.chg.lost 10 DEC4 R :MS[ms]R[msRD,msRU]|14
rcv.cost.per.um 10 DEC4 R :MS[ms]R[msRD,msRU]|7
rcv.last.allocate 8 DATE L :MS[ms]R[msRD,msRU]|16
rcv.neg.qty 7 INT R :MS[ms]R[msRD,msRU]|21
rcv.packaging.ptr 4 PINT R :MS[ms]R[msRD,msRU]|18
rcv.qty 7 INT R :MS[ms]R[msRD,msRU]|1
rcv.qty.left 7 INT R :MS[ms]R[msRD,msRU]|6
rcv.req.no 10 FREE L :MS[ms]R[msRD,msRU]|11
rcv.tax.code 3 FREE L MIS.TAX.CODE :MS[ms]R[msRD,msRU]|17
rcv.tax.rate 7 DEC4 R :MS[ms]R[msRD,msRU]|8
rcv.tot.amt 12 DEC4 R :MS[ms]R[msRD,msRU]|4
rcv.type 1 CHOICE L :MS[ms]R[msRD,msRU]|0
rcv.ui.ator 4 FREE L :MS[ms]R[msRD,msRU]|19
rcv.ui.us.ator 7 INT R :MS[ms]R[msRD,msRU]|20
rcv.um 4 FREE L :MS[ms]R[msRD,msRU]|2
rcv.um.conv 7 PINT R :MS[ms]R[msRD,msRU]|3
rcv.user 10 FREE L :MS[ms]R[msRD,msRU]|12
rcv.xfer.inventory 10 FREE L MM.INVENT :MS[ms]R[msRD,msRU]|9
rcv.xfer.stock.no 18 URN L MM.STOCK :MS[ms]R[msRD,msRU]|10
Ì € i 2
mm.stock.transactions (transactions)
[urn, txn.type,txn.date,txn.urn]
:MS[ms]T[msTT,msTD,msTU]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.type 1 CHOICE L msTT
txn.date 8 DATE L msTD
txn.urn 4 URN L msTU
deliver.to 15 FREE L MM.DELIVER :MS[ms]T[msTT,msTD,msTU]D|0
dept 15 FREE L MIS.GL.DEPT :MS[ms]T[msTT,msTD,msTU]|5
receiving.txns 20 FREE L :MS[ms]T[msTT,msTD,msTU]|8
txn.comment 20 FREE L :MS[ms]T[msTT,msTD,msTU]|6
txn.dept 15 FREE L MIS.GL.DEPT VAL=IF{@dept;"?"}
txn.open.qty 7 PINT R :MS[ms]T[msTT,msTD,msTU]|12
txn.packaging.ptr 4 PINT R :MS[ms]T[msTT,msTD,msTU]|15
txn.qty 7 PINT R :MS[ms]T[msTT,msTD,msTU]|1
txn.req.no 17 FREE L :MS[ms]T[msTT,msTD,msTU]|9
txn.tax.code 3 FREE L MIS.TAX.CODE :MS[ms]T[msTT,msTD,msTU]|14
txn.tax.rate 7 DEC4 R :MS[ms]T[msTT,msTD,msTU]|13
txn.tot.amt 12 DEC4 R :MS[ms]T[msTT,msTD,msTU]|4
txn.um 4 FREE L :MS[ms]T[msTT,msTD,msTU]|2
txn.um.conv 7 PINT R :MS[ms]T[msTT,msTD,msTU]|3
txn.user 10 FREE L :MS[ms]T[msTT,msTD,msTU]|7
txn.xfer.inventory 10 FREE L MM.INVENT :MS[ms]T[msTT,msTD,msTU]|10
txn.xfer.stock.no 18 URN L MM.STOCK :MS[ms]T[msTT,msTD,msTU]|11
Ì € i 2
mm.stock.consign.purch.info (consign.purch.info)
[urn,txn.type,txn.date,txn.urn, consign.queue]
:MS[ms]T[msTT,msTD,msTU]CP[msC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
consign.queue 3 PINT R msC
consign.line 4 PINT R :MS[ms]T[msTT,msTD,msTU]CP[msC]|1
consign.po 30 URN L MM.PO :MS[ms]T[msTT,msTD,msTU]CP[msC]|0
consign.qty.us 11 INT R :MS[ms]T[msTT,msTD,msTU]CP[msC]|3
consign.txn 5 URN L :MS[ms]T[msTT,msTD,msTU]CP[msC]|2
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mm.stock.audit.index [urn]
audit.x ?MSAQ[ms]
mm.stock.critical.item.index [inventory,urn]
crit.x ?MSC[mi,ms]
mm.stock.del.item.x [inventory,item] = urn
del.item.x ?MSDI[mi,mt]
mm.stock.index [inventory,stock.no,urn]
index ?MSX[mi,msN,ms]
mm.stock.item.index [inventory,item] = urn
item.x ?MSI[mi,mt]
mm.stock.location.index [inventory,location,urn]
loc.x ?MSL[mi,msL,ms]
mm.stock.below.mrp.index [inventory,urn]
mrp.x ?MSM[mi,ms]
mm.stock.proc.code.x [inventory,pt.procedure.code,urn]
proc.code.x ?MSBC[mi,bd,ms]
mm.stock.stand.order.index [inventory,urn]
stand.x ?MST[mi,ms]
mm.stock.no.item.index [stock.no,item,urn]
stock.item.x ?MSB[msN,mt,ms]
mm.stock.number.index [inventory,stock.no] = urn
stock.x ?MSS[mi,msN]
|
|
| | | | | | | | | | | | | | | | | | |