Ì i 2
abc.inventory.data
[abc.inventory]
*(M)MS.ABC[mi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abc.inventory 10 FREE L MM.INVENT mi
abc.compile.status 10 CHOICE L *(M)MS.ABC[mi]|1
abc.last.compiled 8 DATE L *(M)MS.ABC[mi]|0
abc.pi.list.by 8 CHOICE L *(M)MS.ABC[mi]|6
abc.pi.stock.count 5 PINT R *(M)MS.ABC[mi]|2
abc.pi.stock.count.a 4 PINT R *(M)MS.ABC[mi]|3
abc.pi.stock.count.b 4 PINT R *(M)MS.ABC[mi]|4
abc.pi.stock.count.c 4 PINT R *(M)MS.ABC[mi]|5
Ì € i 2
abc.abc.data
[abc.inventory, abc.abc]
*(M)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 *(M)MS.ABC[mi]A[msAB1]|0
abc.total.value 12 SMONEY R *(M)MS.ABC[mi]A[msAB1]|1
Ì € i 2
abc.stock.data
[abc.inventory,abc.abc, abc.seq]
*(M)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 *(M)MS.ABC[mi]A[msAB1]S[msAB]|0
abc.value 10 SMONEY R *(M)MS.ABC[mi]A[msAB1]S[msAB]|1
Ì € i 2
abc.pi.data
[abc.inventory, abc.pi.count]
*(M)MS.ABC[mi]PI[msABP]
Field Name Len Dat Typ J DPM Offset/Local/VAL
abc.pi.count 4 PINT R msABP
abc.pi.stock.urn 18 URN L MM.STOCK *(M)MS.ABC[mi]PI[msABP]|0
Ì i 2
audit.trail.top
[audit.stock]
&(M)MSAT[ms]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.stock 18 URN L MM.STOCK ms
Ì € i 2
audit.trail
[audit.stock, audit.date,audit.seq]
&(M)MSAT[ms]A[msAD,msAS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
audit.date 8 DATE L msAD
audit.seq 4 PINT R msAS
audit.client 30 FREE L &(M)MSAT[ms]A[msAD,msAS]|6
audit.field 6 CHOICE L &(M)MSAT[ms]A[msAD,msAS]|2
audit.from 40 FREE L &(M)MSAT[ms]A[msAD,msAS]|3
audit.source 24 CHOICE L &(M)MSAT[ms]A[msAD,msAS]|5
audit.time 5 HHMM L &(M)MSAT[ms]A[msAD,msAS]|1
audit.to 40 FREE L &(M)MSAT[ms]A[msAD,msAS]|4
audit.user 10 FREE L MIS.USER &(M)MSAT[ms]A[msAD,msAS]|0
Ì i 2
closing.list
[job.no,clos.inv]
*(M)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
lock
[locked.inventory]
*(M)MSLOCK[mi]
Field Name Len Dat Typ J DPM Offset/Local/VAL
locked.inventory 10 FREE L MM.INVENT mi
Ì € i 2
main
[urn]
&(M)MS[ms]
Field Name Len Dat Typ J DPM Offset/Local/VAL
urn 18 URN L ms
abc.status 1 CHOICE L &(M)MS[ms]C|4
active 1 YN L &(M)MS[ms]|0
asset.account 25 FREE L MIS.GL.ACCOUNT &(M)MS[ms]C|15
avg.cost 10 DEC R &(M)MS[ms]|18
avg.cost.ui 10 DEC4 R VAL=(@avg.cost*@ui.us:4D)
avg.usage 10 DEC2 R &(M)MS[ms]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 &(M)MS[ms]|15
comment 60 FREE L &(M)MS[ms]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 &(M)MS[ms]C|9
cur.rcv.date 8 DATE L &(M)MS[ms]|6
cur.rcv.urn 7 URN L &(M)MS[ms]|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 &(M)MS[ms]C|12
form.yn 1 YN L VAL=IF{@MM.ITEM.form[@item] "Y";"N"}
from.pha 1 YN L &(M)MS[ms]C|22
haz.mat 15 FREE L MM.HAZ.MAT &(M)MS[ms]C|24
id 18 URN L VAL=@stock.no
inv.sec.check 1 FREE L VAL=IF{/INV.NO.ACCESS[inventory] "N";"Y"}
inventory 10 FREE L MM.INVENT &(M)MS[ms]|1
item 43 URN L MM.ITEM &(M)MS[ms]|3
last.adjustment.date 8 DATE L VAL=-@transactions[urn,"A",""]
last.txn 7 URN L &(M)MS[ms]|5
last.update 10 FREE L &(M)MS[ms]UPD
lead.time 3 PINT R &(M)MS[ms]C|7
location 10 FREE L &(M)MS[ms]|12
main.inv.stock.urn 18 URN L MM.STOCK &(M)MS[ms]S|3
max.issue.qty.ui 5 PINT R &(M)MS[ms]C|2
max.shelf.qty.ui 5 PINT R &(M)MS[ms]C|1
mfr 10 FREE L MIS.MFR &(M)MS[ms]|19
mfr.description 43 FREE L VAL=(@mfr_" "_@MIS.MFR.name[@mfr]:43T)
min.issue.qty.ui 5 PINT R &(M)MS[ms]C|3
mrp 5 INT R &(M)MS[ms]|17
mrp.ui 5 INT R &(M)MS[ms]C|0
not.yet.used 1 FREE L &(M)MS[ms]S|8
number.chg.date 8 DATE L &(M)MS[ms]C|18
number.chg.qty.on.hand 7 PINT R &(M)MS[ms]C|19
number.chg.txn 4 URN L &(M)MS[ms]C|17
number.chg.value.on.hand 10 DEC4 R &(M)MS[ms]C|20
ooq.ui 5 PINT R &(M)MS[ms]C|5
order.on.po 1 YN L &(M)MS[ms]S|7
packaging 25 FREE L VAL=@MM.ITEM.package.string.disp
pha.db 12 FREE L MIS.APPL.DB &(M)MS[ms]C|23
primary.vendor 11 FREE L MIS.VEN &(M)MS[ms]|13
pt.eoc 7 FREE L MIS.GL.EOC &(M)MS[ms]S|6
pt.max.issue.qty.ui 5 PINT R &(M)MS[ms]S|4
pt.min.issue.qty.ui 5 PINT R &(M)MS[ms]S|5
pt.procedure.code 10 FREE L &(M)MS[ms]S|2
pt.ui.us 7 PINT R &(M)MS[ms]S|1
pt.unit.of.issue 4 FREE L &(M)MS[ms]S|0
qty.on.backorder 7 PINT R &(M)MS[ms]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 &(M)MS[ms]|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 &(M)MS[ms]|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(urn,1)
rec.order.qty.us 7 PINT R VAL=%MM.STOCK.get.rec.order.qty(urn)
safety.stock.ui 5 PINT R &(M)MS[ms]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 &(M)MS[ms]C|10
stock.conv.up 10 FREE L &(M)MS[ms]S|10
stock.no 18 FREE L &(M)MS[ms]|2
stock.up 4 FREE L &(M)MS[ms]S|9
transfer.item 1 YN L &(M)MS[ms]|4
ui.us 7 PINT R &(M)MS[ms]|8
unit.of.issue 4 FREE L &(M)MS[ms]|16
unit.of.issue.with.us 15 FREE L &(M)MS[ms]|20
value.on.hand 10 DEC4 R &(M)MS[ms]|10
vendor.cost.ui 10 DEC4 R &(M)MS[ms]|14
vendor.description 43 FREE L VAL=(@primary.vendor_" "_@MIS.VEN.name[@primary.vendor
VAL=]:43T)
Ì € i 2
except.dept.eocs
[urn, except.dept]
&(M)MS[ms]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 &(M)MS[ms]E[gd]|0
Ì € i 2
other.locations
[urn, other.location]
&(M)MS[ms]O[msOL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
other.location 10 FREE L msOL
Ì i 2
opt.inventory.data
[opt.inventory]
*(M)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 *(M)MS.OPT[mi]|1
opt.last.compiled 8 DATE L *(M)MS.OPT[mi]|0
Ì € i 2
opt.stock.data
[opt.inventory, opt.stock.urn]
*(M)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 *(M)MS.OPT[mi]S[ms]|6
opt.date.compiled 8 DATE L *(M)MS.OPT[mi]S[ms]|7
opt.date.updated 8 DATE L *(M)MS.OPT[mi]S[ms]|8
opt.days.bet.orders.avg 3 PINT R *(M)MS.OPT[mi]S[ms]|9
opt.days.bet.orders.opt 3 PINT R *(M)MS.OPT[mi]S[ms]|10
opt.lead.time 3 PINT R *(M)MS.OPT[mi]S[ms]|3
opt.mrp.ui 5 PINT R *(M)MS.OPT[mi]S[ms]|2
opt.num.months 3 PINT R *(M)MS.OPT[mi]S[ms]|4
opt.num.po 3 PINT R *(M)MS.OPT[mi]S[ms]|5
opt.ooq.ui 5 PINT R *(M)MS.OPT[mi]S[ms]|0
opt.safety.stock.ui 5 PINT R *(M)MS.OPT[mi]S[ms]|1
Ì i 2
period.end.vector
[pe.inventory,pe.urn,pe.date]
*(M)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
check.pe.inv 1 YN L VAL=IF{%MM.INVENT.security(MM.STOCK.pe.inventory,1,"",
VAL="") "N";"Y"}
pe.adjust.qty 7 PINT R *(M)MSPE[mi,ms,msPD]|14
pe.adjust.value 10 DEC2 R *(M)MSPE[mi,ms,msPD]|15
pe.dept.issue.qty 7 PINT R *(M)MSPE[mi,ms,msPD]|8
pe.dept.issue.value 10 DEC2 R *(M)MSPE[mi,ms,msPD]|9
pe.dept.return.qty 7 PINT R *(M)MSPE[mi,ms,msPD]|10
pe.dept.return.value 10 DEC2 R *(M)MSPE[mi,ms,msPD]|11
pe.init.qty 7 PINT R *(M)MSPE[mi,ms,msPD]|20
pe.init.value 10 DEC2 R *(M)MSPE[mi,ms,msPD]|21
pe.net.qty.in 7 PINT R *(M)MSPE[mi,ms,msPD]|2
pe.net.value.in 10 DEC2 R *(M)MSPE[mi,ms,msPD]|3
pe.patient.issue.qty 7 PINT R *(M)MSPE[mi,ms,msPD]|12
pe.patient.issue.value 10 DEC2 R *(M)MSPE[mi,ms,msPD]|13
pe.qty.on.hand 7 PINT R *(M)MSPE[mi,ms,msPD]|0
pe.rcpt.qty 7 PINT R *(M)MSPE[mi,ms,msPD]|4
pe.rcpt.value 10 DEC2 R *(M)MSPE[mi,ms,msPD]|5
pe.undist.tax 10 DEC2 R *(M)MSPE[mi,ms,msPD]|22
pe.usage.qty 7 PINT R *(M)MSPE[mi,ms,msPD]|18
pe.usage.value 10 DEC2 R *(M)MSPE[mi,ms,msPD]|19
pe.value.on.hand 10 DEC2 R *(M)MSPE[mi,ms,msPD]|1
pe.xfer.in.qty 7 PINT R *(M)MSPE[mi,ms,msPD]|6
pe.xfer.in.value 10 DEC2 R *(M)MSPE[mi,ms,msPD]|7
pe.xfer.out.qty 7 PINT R *(M)MSPE[mi,ms,msPD]|16
pe.xfer.out.value 10 DEC2 R *(M)MSPE[mi,ms,msPD]|17
Ì i 2
reports
[report]
*(M)MSW[msw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
report 10 FREE L msw
rep.compile.status 10 CHOICE L *(M)MSW[msw]C|0
rep.from.period 10 FREE L MIS.GL.PERIOD *(M)MSW[msw]C|16
rep.inquiry.format 1 CHOICE L *(M)MSW[msw]C|7
rep.new.page 5 CHOICE L *(M)MSW[msw]C|12
rep.num.records 6 PINT R *(M)MSW[msw]C|11
rep.report.format 1 CHOICE L *(M)MSW[msw]C|6
rep.selection 10 FREE L MM.SELECT *(M)MSW[msw]C|14
rep.sort.1 15 FREE L MM.FIELDS *(M)MSW[msw]C|8
rep.sort.2 15 FREE L MM.FIELDS *(M)MSW[msw]C|9
rep.sort.3 15 FREE L MM.FIELDS *(M)MSW[msw]C|10
rep.start.date 8 DATE L *(M)MSW[msw]C|1
rep.start.time 5 TIME L *(M)MSW[msw]C|2
rep.stop.date 8 DATE L *(M)MSW[msw]C|3
rep.stop.time 5 TIME L *(M)MSW[msw]C|4
rep.subtotal 5 CHOICE L *(M)MSW[msw]C|13
rep.thru.period 10 FREE L MIS.GL.PERIOD *(M)MSW[msw]C|17
rep.title 50 FREE L *(M)MSW[msw]C|5
rep.type 5 CHOICE L *(M)MSW[msw]C|15
Ì € i 2
report.inventories
[report, rep.inventory]
*(M)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
selections
[report, rep.sel.queue]
*(M)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 *(M)MSW[msw]C["S",mswS]|0
rep.select.from 30 FREE L *(M)MSW[msw]C["S",mswS]|1
rep.select.from.date 8 DATE L *(M)MSW[msw]C["S",mswS]|3
rep.select.to 30 FREE L *(M)MSW[msw]C["S",mswS]|2
rep.select.to.date 8 DATE L *(M)MSW[msw]C["S",mswS]|4
Ì € i 2
send.users
[report, rep.send.user]
*(M)MSW[msw]C["U",gu]
Field Name Len Dat Typ J DPM Offset/Local/VAL
rep.send.user 10 FREE L MIS.USER gu
rep.send.mark 1 FREE L *(M)MSW[msw]C["U",gu]|0
rep.send.tsk.num 10 FREE L *(M)MSW[msw]C["U",gu]|1
Ì € i 2
report.data
[report, rep.sort1,rep.sort2,rep.sort3,rep.stock.no,rep.stock.urn]
*(M)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
report.rcpts
[report,rep.sort1,rep.sort2,rep.sort3,rep.stock.no,rep.stock.urn, receipt.date,receipt.urn]
*(M)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
report.txns
[report,rep.sort1,rep.sort2,rep.sort3,rep.stock.no,rep.stock.urn, rep.txn.type,rep.txn.date,re
*(M)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
txn.top
[txn.id]
$(M2)MS[ms]
Field Name Len Dat Typ J DPM Offset/Local/VAL
txn.id 18 URN L MM.STOCK ms
pi.adj.txn.date 8 DATE L $(M2)MS[ms]PI|5
pi.date 8 DATE L $(M2)MS[ms]PI|0
pi.post.date 8 DATE L $(M2)MS[ms]PI|2
pi.qty 7 PINT R $(M2)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 $(M2)MS[ms]PI|4
pi.user 10 FREE L $(M2)MS[ms]PI|3
Ì € i 2
opening
[txn.id, open.date]
$(M2)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 $(M2)MS[ms]D[msOD]|0
open.value 10 DEC4 R $(M2)MS[ms]D[msOD]|1
Ì € i 2
rcv.transactions
[txn.id, rcv.date,rcv.urn]
$(M2)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 $(M2)MS[ms]R[msRD,msRU]|15
po.number 10 FREE L $(M2)MS[ms]R[msRD,msRU]|5
rcv.comment 60 FREE L $(M2)MS[ms]R[msRD,msRU]|13
rcv.cost.chg.lost 10 DEC4 R $(M2)MS[ms]R[msRD,msRU]|14
rcv.cost.per.um 10 DEC4 R $(M2)MS[ms]R[msRD,msRU]|7
rcv.last.allocate 8 DATE L $(M2)MS[ms]R[msRD,msRU]|16
rcv.neg.qty 7 INT R $(M2)MS[ms]R[msRD,msRU]|21
rcv.packaging.ptr 4 PINT R $(M2)MS[ms]R[msRD,msRU]|18
rcv.qty 7 INT R $(M2)MS[ms]R[msRD,msRU]|1
rcv.qty.left 7 INT R $(M2)MS[ms]R[msRD,msRU]|6
rcv.req.no 10 FREE L $(M2)MS[ms]R[msRD,msRU]|11
rcv.tax.code 3 FREE L MIS.TAX.CODE $(M2)MS[ms]R[msRD,msRU]|17
rcv.tax.rate 7 PDEC4 R $(M2)MS[ms]R[msRD,msRU]|8
rcv.tot.amt 12 DEC4 R $(M2)MS[ms]R[msRD,msRU]|4
rcv.type 1 CHOICE L $(M2)MS[ms]R[msRD,msRU]|0
rcv.ui.ator 4 FREE L $(M2)MS[ms]R[msRD,msRU]|19
rcv.ui.us.ator 7 INT R $(M2)MS[ms]R[msRD,msRU]|20
rcv.um 4 FREE L $(M2)MS[ms]R[msRD,msRU]|2
rcv.um.conv 7 PINT R $(M2)MS[ms]R[msRD,msRU]|3
rcv.user 10 FREE L $(M2)MS[ms]R[msRD,msRU]|12
rcv.xfer.inventory 10 FREE L MM.INVENT $(M2)MS[ms]R[msRD,msRU]|9
rcv.xfer.stock.no 18 URN L MM.STOCK $(M2)MS[ms]R[msRD,msRU]|10
Ì € i 2
transactions
[txn.id, txn.type,txn.date,txn.urn]
$(M2)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
dept 15 FREE L MIS.GL.DEPT $(M2)MS[ms]T[msTT,msTD,msTU]|5
dept.check 1 YN L VAL=IF{@dept^DCD_.=. "Y";DCD&(%MIS.GL.DEPT.user.ok(DCD
VAL=)) "Y";"N"}
receiving.txns 20 FREE L $(M2)MS[ms]T[msTT,msTD,msTU]|8
txn.comment 20 FREE L $(M2)MS[ms]T[msTT,msTD,msTU]|6
txn.dept 15 FREE L MIS.GL.DEPT VAL=IF{@dept;"?"}
txn.open.qty 7 PINT R $(M2)MS[ms]T[msTT,msTD,msTU]|12
txn.packaging.ptr 4 PINT R $(M2)MS[ms]T[msTT,msTD,msTU]|15
txn.qty 7 PINT R $(M2)MS[ms]T[msTT,msTD,msTU]|1
txn.req.no 17 FREE L $(M2)MS[ms]T[msTT,msTD,msTU]|9
txn.tax.code 3 FREE L MIS.TAX.CODE $(M2)MS[ms]T[msTT,msTD,msTU]|14
txn.tax.rate 7 PDEC4 R $(M2)MS[ms]T[msTT,msTD,msTU]|13
txn.tot.amt 12 DEC4 R $(M2)MS[ms]T[msTT,msTD,msTU]|4
txn.um 4 FREE L $(M2)MS[ms]T[msTT,msTD,msTU]|2
txn.um.conv 7 PINT R $(M2)MS[ms]T[msTT,msTD,msTU]|3
txn.user 10 FREE L $(M2)MS[ms]T[msTT,msTD,msTU]|7
txn.xfer.inventory 10 FREE L MM.INVENT $(M2)MS[ms]T[msTT,msTD,msTU]|10
txn.xfer.stock.no 18 URN L MM.STOCK $(M2)MS[ms]T[msTT,msTD,msTU]|11
Ì € i 2
consign.purch.info
[txn.id,txn.type,txn.date,txn.urn, consign.queue]
$(M2)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 $(M2)MS[ms]T[msTT,msTD,msTU]CP[msC]|1
consign.po 30 URN L MM.PO $(M2)MS[ms]T[msTT,msTD,msTU]CP[msC]|0
consign.qty.us 11 INT R $(M2)MS[ms]T[msTT,msTD,msTU]CP[msC]|3
consign.txn 5 URN L $(M2)MS[ms]T[msTT,msTD,msTU]CP[msC]|2
Index Files Subscripts/Physical Base
crit.x [inventory,urn]
&(M)MSC[mi,ms]
del.item.x [inventory,item] = urn
&(M)MSDI[mi,mt]
index [inventory,stock.no,urn]
&(M)MSX[mi,msN,ms]
item.x [inventory,item] = urn
&(M)MSI[mi,mt]
loc.x [inventory,location,urn]
&(M)MSL[mi,msL,ms]
mrp.x [inventory,urn]
&(M)MSM[mi,ms]
or.audit.x [or.data.type,or.stock.item.ptr]
&(M)MSAQ[msORD,ms]
proc.code.x [inventory,pt.procedure.code,urn]
&(M)MSBC[mi,bd,ms]
stand.x [inventory,urn]
&(M)MST[mi,ms]
stock.item.x [stock.no,item,urn]
&(M)MSB[msN,mt,ms]
stock.x [inventory,stock.no] = urn
&(M)MSS[mi,msN]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | |