Ì i 2
accrual.aging
[acc.ending.date,acc.po.urn,acc.po.line,acc.txn.urn]
*(M)MKAC[gpD,mp,mpL,mpT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
acc.ending.date 8 FREE L gpD
acc.po.urn 4 PINT R mp
acc.po.line 4 PINT R mpL
acc.txn.urn 5 PINT R mpT
acc.amt 11 SMONEY R *(M)MKAC[gpD,mp,mpL,mpT]|2
acc.cost.up 10 DEC4 R *(M)MKAC[gpD,mp,mpL,mpT]|0
acc.partial.rcpt 1 YN L *(M)MKAC[gpD,mp,mpL,mpT]|6
acc.po.up.us 7 PINT R *(M)MKAC[gpD,mp,mpL,mpT]|4
acc.qty 11 INT R *(M)MKAC[gpD,mp,mpL,mpT]|1
acc.tax.rate 6 DEC3 R *(M)MKAC[gpD,mp,mpL,mpT]|5
acc.txn.date 8 DATE L *(M)MKAC[gpD,mp,mpL,mpT]|3
Ì € i 2
batch.status
[ap.db]
*(M)MKSTS[gnA]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ap.db 12 FREE L MIS.APPL.DB gnA
first.open.date 8 DATE L *(M)MKSTS[gnA]|0
reset 1 YN L *(M)MKSTS[gnA]|1
Ì i 2
control.disp
[con.sec,con.ven.name,con.ven,con.sub.3,con.sub.4,
/MKR[mkR]I[grN,gr,mkRT,mkRF]D
Field Name Len Dat Typ J DPM Offset/Local/VAL
cd.fld.3 15 FREE L /MKR[mkR]I[grN,gr,mkRT,mkRF]D|0
cd.fld.3.a 15 FREE L /MKR[mkR]I[grN,gr,mkRT,mkRF]D|1
cd.fld.4 15 FREE L /MKR[mkR]I[grN,gr,mkRT,mkRF]D|2
Ì i 2
fa.link
[fa.link.no]
*(M)MKFA[mkFA]
Field Name Len Dat Typ J DPM Offset/Local/VAL
fa.link.no 10 FREE L mkFA
fa.inv.num 15 FREE L *(M)MKFA[mkFA]|1
fa.line.no 4 PINT R *(M)MKFA[mkFA]|2
fa.line.qty 8 PINT R *(M)MKFA[mkFA]|5
fa.po.num 10 FREE L *(M)MKFA[mkFA]|4
fa.po.urn 30 URN L MM.PO *(M)MKFA[mkFA]|0
fa.pur.fac 10 FREE L MIS.PUR.FAC *(M)MKFA[mkFA]|6
fa.qty.used 8 PINT R *(M)MKFA[mkFA]|3
Ì € i 2
fa.link.multiple
[fa.link.no, fa.sec.item.no]
*(M)MKFA[mkFA]SI[mkFSI]
Field Name Len Dat Typ J DPM Offset/Local/VAL
fa.sec.item.no 4 PINT R mkFSI
fa.s.inv.num 15 FREE L *(M)MKFA[mkFA]SI[mkFSI]|1
fa.s.line.no 4 PINT R *(M)MKFA[mkFA]SI[mkFSI]|2
fa.s.line.qty 8 PINT R *(M)MKFA[mkFA]SI[mkFSI]|3
fa.s.po.num 10 FREE L *(M)MKFA[mkFA]SI[mkFSI]|4
fa.s.po.urn 30 URN L MM.PO *(M)MKFA[mkFA]SI[mkFSI]|0
Ì € i 2
fa.link.usage
[fa.link.no, fa.seq.no]
*(M)MKFA[mkFA]S[mkFSQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
fa.seq.no 5 PINT R mkFSQ
fa.asset.number 10 FREE L *(M)MKFA[mkFA]S[mkFSQ]|1
fa.database 12 FREE L MIS.APPL.DB *(M)MKFA[mkFA]S[mkFSQ]|0
fa.link.date 8 DATE L *(M)MKFA[mkFA]S[mkFSQ]|4
fa.link.user 10 FREE L MIS.USER *(M)MKFA[mkFA]S[mkFSQ]|3
fa.quantity 8 PINT R *(M)MKFA[mkFA]S[mkFSQ]|2
Ì € i 2
main
[po.urn]
$(M3)MK[mp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
po.urn 30 URN L MM.PO mp
access.from.ap 1 FREE L VAL=/(.D)MM.AP.ACCESS.FROM.AP
access.from.mm 1 FREE L VAL=/(.D)MM.AP.ACCESS.FROM.MM
ap.database 12 FREE L MIS.APPL.DB $(M3)MK[mp]|2
ap.db.in.slash 18 FREE L VAL=/(.D)AP.DB.SAVE
database.title 65 FREE L VAL="MM DATABASE: "_@mm.db.in.slash_" AP DATABASE: "
VAL=_@ap.db.in.slash
exc.rpt.sort 35 FREE L VAL=(%MM.INVOICE.exc.rpt.sort(ap.database,po.urn,inv.n
VAL=um,vendor))
fac.type 1 FREE L
is.fac 10 FREE L MIS.PUR.FAC VAL=IF{c.fac.type="M" @purch.facility;@map.fac}
map.fac 10 FREE L MIS.PUR.FAC $(M3)MK[mp]|6
mm.db.in.slash 18 FREE L VAL=/(.D)MM.DB.SAVE
name 1 CHOICE L
par.fac 10 FREE L MIS.PUR.FAC VAL=IF{@map.fac'=@purch.facility @map.fac}
po.num 10 FREE L $(M3)MK[mp]|0
purch.facility 10 FREE L MIS.PUR.FAC $(M3)MK[mp]|5
return 1 YN L $(M3)MK[mp]|3
tax.type 3 FREE L $(M3)MK[mp]|4
vendor 11 FREE L MIS.VEN $(M3)MK[mp]|1
Ì € i 2
external.offsets
[po.urn, xo.po.line]
$(M3)MK[mp]X[mpL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xo.po.line 4 PINT R mpL
xo.adj.tot.qty.disp 10 FREE L $(M3)MK[mp]X[mpL]|6
xo.adj.tot.qty.us 11 SINT R $(M3)MK[mp]X[mpL]|5
xo.line.date 8 DATE L $(M3)MK[mp]X[mpL]|3
xo.line.time 4 HHMM L $(M3)MK[mp]X[mpL]|4
xo.line.tot.qty.disp 10 FREE L $(M3)MK[mp]X[mpL]|1
xo.line.tot.qty.us 11 SINT R $(M3)MK[mp]X[mpL]|0
xo.line.user 10 FREE L $(M3)MK[mp]X[mpL]|2
xo.up.num.us 18 FREE L VAL=IF{@MM.PO.item.urn^MM.PO.item.urn,@MM.PO.po.unit.o
VAL=f.pur_"/"_@MM.PO.po.up.us_" "_@MM.PO.smallest.unit
VAL='="/ "}
Ì € i 2
external.off.pl
[po.urn,xo.po.line, xop.pack.list,xop.date]
$(M3)MK[mp]X[mpL]R[mpPL,mpPLD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xop.pack.list 20 FREE L mpPL
xop.date 8 DATE L mpPLD
xop.qty.us 11 SINT R $(M3)MK[mp]X[mpL]R[mpPL,mpPLD]|0
Ì € i 2
external.receipts
[po.urn, xr.pack.list,xr.date,xr.line,xr.txn]
$(M3)MK[mp]XR[mpPL,mpPLD,mpL,mpT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
xr.pack.list 20 FREE L mpPL
xr.date 8 DATE L mpPLD
xr.line 4 PINT R mpL
xr.txn 5 INT R mpT
xr.qty.us 11 INT R $(M3)MK[mp]XR[mpPL,mpPLD,mpL,mpT]|0
Ì € i 2
invoices
[po.urn, inv.num]
$(M3)MK[mp]I[mk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv.num 15 FREE L mk
all.receipts 1 YN L $(M3)MK[mp]I[mk]|11
ap.batch.txn 3 PINT R $(M3)MK[mp]I[mk]|21
approved.date 8 DATE L $(M3)MK[mp]I[mk]|12
auto.match.fail 1 YN L $(M3)MK[mp]I[mk]|14
batch.num 3 PINT R $(M3)MK[mp]I[mk]|20
description 65 FREE L $(M3)MK[mp]I[mk]DN
discount 10 SMONEY R $(M3)MK[mp]I[mk]|9
exc.rpt.sort.process 35 VAL=(%MM.INVOICE.exception.process.sort(po.urn,inv.num
VAL=))
freight 10 SMONEY R $(M3)MK[mp]I[mk]|8
frt.tax.1 10 SMONEY R $(M3)MK[mp]I[mk]|29
frt.tax.2 10 SMONEY R $(M3)MK[mp]I[mk]|30
frt.tax.code 3 FREE L MIS.TAX.CODE $(M3)MK[mp]I[mk]|28
gl.period 10 FREE L MIS.GL.PERIOD $(M3)MK[mp]I[mk]|16
gross 11 SMONEY R $(M3)MK[mp]I[mk]|6
inp.mm.batch.num 3 PINT R $(M3)MK[mp]I[mk]|22
inp.mm.batch.seq 3 PINT R $(M3)MK[mp]I[mk]|23
input.date 8 DATE L $(M3)MK[mp]I[mk]|4
inv.date 8 DATE L $(M3)MK[mp]I[mk]|1
inv.tax.type 3 FREE L $(M3)MK[mp]I[mk]|26
inv.type 3 CHOICE L $(M3)MK[mp]I[mk]|10
over.pur.fac 10 FREE L MIS.PUR.FAC $(M3)MK[mp]I[mk]|31
process 1 FREE L $(M3)MK[mp]I[mk]|18
rcv.date 8 DATE L $(M3)MK[mp]I[mk]|2
remit.addr.1 35 FREE L $(M3)MK[mp]I[mk]RA|2
remit.addr.2 35 FREE L $(M3)MK[mp]I[mk]RA|3
remit.addr.3 35 FREE L $(M3)MK[mp]I[mk]RA|4
remit.addr.alt 35 FREE L $(M3)MK[mp]I[mk]RA["ALT"]|0
remit.city 20 FREE L $(M3)MK[mp]I[mk]RE|0
remit.name 35 FREE L $(M3)MK[mp]I[mk]RA|0
remit.name.2 35 FREE L $(M3)MK[mp]I[mk]RA|1
remit.postal.code 10 FREE L $(M3)MK[mp]I[mk]RE|2
remit.state 2 FREE L $(M3)MK[mp]I[mk]RE|1
status 1 FREE L $(M3)MK[mp]I[mk]|0
tax 10 SMONEY R $(M3)MK[mp]I[mk]|7
tax.1 10 SMONEY R $(M3)MK[mp]I[mk]|24
tax.2 10 SMONEY R $(M3)MK[mp]I[mk]|25
tax.flag.conv 1 YN L $(M3)MK[mp]I[mk]|27
tax.gl.period 10 GLPERIOD L
tax.tax.code 3 FREE L MIS.TAX.CODE
transfer.date 8 DATE L $(M3)MK[mp]I[mk]|5
transfer.num 3 PINT R $(M3)MK[mp]I[mk]|17
try.auto.match 1 YN L $(M3)MK[mp]I[mk]|13
tsk.num 10 PINT R $(M3)MK[mp]I[mk]T|0
txn.comment 65 FREE L $(M3)MK[mp]I[mk]|32
update.approval 1 YN L $(M3)MK[mp]I[mk]|19
use.invent.var.accts 1 YN L $(M3)MK[mp]I[mk]|15
voucher 6 FREE L $(M3)MK[mp]I[mk]|3
Ì € i 2
amts.by.date
[po.urn,inv.num, date]
$(M3)MK[mp]I[mk]D[mkD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
date 8 DATE L mkD
date.discount 10 SMONEY R $(M3)MK[mp]I[mk]D[mkD]|4
date.freight 10 SMONEY R $(M3)MK[mp]I[mk]D[mkD]|3
date.gross 11 SMONEY R $(M3)MK[mp]I[mk]D[mkD]|1
date.net 11 SMONEY R $(M3)MK[mp]I[mk]D[mkD]|5
date.status 1 FREE L $(M3)MK[mp]I[mk]D[mkD]|0
date.tax 10 SMONEY R $(M3)MK[mp]I[mk]D[mkD]|2
date.tax.1 10 SMONEY R $(M3)MK[mp]I[mk]D[mkD]|6
date.tax.2 10 SMONEY R $(M3)MK[mp]I[mk]D[mkD]|7
Ì € i 2
gl.dist
[po.urn,inv.num, gl.acct]
$(M3)MK[mp]I[mk]G[ga]
Field Name Len Dat Typ J DPM Offset/Local/VAL
gl.acct 25 FREE L MIS.GL.ACCOUNT ga
gl.frt 10 SMONEY R $(M3)MK[mp]I[mk]G[ga]|2
gl.gross 11 SMONEY R $(M3)MK[mp]I[mk]G[ga]|0
gl.tax 10 SMONEY R $(M3)MK[mp]I[mk]G[ga]|1
gl.tax.1 10 SMONEY R $(M3)MK[mp]I[mk]G[ga]|3
gl.tax.2 10 SMONEY R $(M3)MK[mp]I[mk]G[ga]|4
Ì € i 2
gl.dist.line
[po.urn,inv.num,gl.acct, gl.line]
$(M3)MK[mp]I[mk]G[ga]L[mpL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
gl.line 4 FREE L mpL
gl.line.amt 11 SMONEY R $(M3)MK[mp]I[mk]G[ga]L[mpL]
Ì € i 2
inv.ap.lines
[po.urn,inv.num, ap.inv.line]
$(M3)MK[mp]I[mk]H[kzL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ap.inv.line 4 PINT R kzL
ap.inv.account 25 FREE L MIS.GL.ACCOUNT $(M3)MK[mp]I[mk]H[kzL]|0
ap.inv.edit.1 1 SMONEY R $(M3)MK[mp]I[mk]H[kzL]|9
ap.inv.edit.2 1 SMONEY R $(M3)MK[mp]I[mk]H[kzL]|10
ap.inv.freight 10 SMONEY R $(M3)MK[mp]I[mk]H[kzL]|2
ap.inv.gross 11 SMONEY R $(M3)MK[mp]I[mk]H[kzL]|1
ap.inv.pfrt 10 SMONEY R $(M3)MK[mp]I[mk]H[kzL]|6
ap.inv.pfrt.t1 10 SMONEY R $(M3)MK[mp]I[mk]H[kzL]|7
ap.inv.pfrt.t2 10 SMONEY R $(M3)MK[mp]I[mk]H[kzL]|8
ap.inv.t1 10 SMONEY R $(M3)MK[mp]I[mk]H[kzL]|4
ap.inv.t2 10 SMONEY R $(M3)MK[mp]I[mk]H[kzL]|5
ap.inv.tax.code 3 FREE L MIS.TAX.CODE $(M3)MK[mp]I[mk]H[kzL]|3
Ì € i 2
invoiced.receipts
[po.urn,inv.num, inv.rec.pack.list,inv.rec.date,inv.rec.line,inv.rec.txn]
$(M3)MK[mp]I[mk]R[mpPL,mpPLD,mpL,mpT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
inv.rec.pack.list 20 FREE L mpPL
inv.rec.date 8 DATE L mpPLD
inv.rec.line 4 PINT R mpL
inv.rec.txn 5 URN L mpT
inv.rec.qty.us 11 INT R $(M3)MK[mp]I[mk]R[mpPL,mpPLD,mpL,mpT]|0
Ì € i 2
lines
[po.urn,inv.num, po.line]
$(M3)MK[mp]I[mk]L[mpL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
po.line 4 PINT R mpL
line.cost.up 8 PDEC4 R $(M3)MK[mp]I[mk]L[mpL]|9
line.gr.amt 11 SMONEY R $(M3)MK[mp]I[mk]L[mpL]|2
line.invent.dis 2 FREE L VAL=IF{@MM.PO.line.inventory " I"}
line.invent.dis.color 1 FREE L VAL=IF{@MM.PO.line.inventory "I"}
line.item 10 FREE L VAL=@MM.PO.item.no
line.ok 1 YN L $(M3)MK[mp]I[mk]L[mpL]|13
line.pr.dis 1 YN L $(M3)MK[mp]I[mk]L[mpL]|12
line.qty.dis 1 YN L $(M3)MK[mp]I[mk]L[mpL]|11
line.qty.up 8 SINT R $(M3)MK[mp]I[mk]L[mpL]|0
line.qty.us 8 SINT R $(M3)MK[mp]I[mk]L[mpL]|1
line.rcv.tax.us 8 SINT R $(M3)MK[mp]I[mk]L[mpL]|6
line.rcv.tax.us.pl 8 SINT R $(M3)MK[mp]I[mk]L[mpL]|8
line.rcv.us 8 SINT R $(M3)MK[mp]I[mk]L[mpL]|5
line.rcv.us.pl 8 SINT R $(M3)MK[mp]I[mk]L[mpL]|7
line.tax.1 10 SMONEY R $(M3)MK[mp]I[mk]L[mpL]|16
line.tax.2 10 SMONEY R $(M3)MK[mp]I[mk]L[mpL]|17
line.tax.amt 10 SMONEY R $(M3)MK[mp]I[mk]L[mpL]|10
line.tax.code 3 FREE L MIS.TAX.CODE $(M3)MK[mp]I[mk]L[mpL]|15
line.tax.extra.us 8 SINT R $(M3)MK[mp]I[mk]L[mpL]|14
line.tax.us 8 SINT R $(M3)MK[mp]I[mk]L[mpL]|4
line.taxable 1 YN L $(M3)MK[mp]I[mk]L[mpL]|18
line.temp 0 FREE L $(M3)MK[mp]I[mk]L[mpL]|19
line.tot.qty.us 8 SINT R $(M3)MK[mp]I[mk]L[mpL]|3
line.up.num.us 18 FREE L VAL=IF{@MM.PO.item.urn^MM.PO.item.urn,@MM.PO.po.unit.o
VAL=f.pur_"/"_@MM.PO.po.up.us_" "_@MM.PO.smallest.unit
VAL='="/ "}
Ì € i 2
packing.lists
[po.urn,inv.num, packing.list]
$(M3)MK[mp]I[mk]P[mpPL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
packing.list 20 FREE L mpPL
Ì € i 2
payment.schedule
[po.urn,inv.num, pay.on.date]
$(M3)MK[mp]I[mk]PS[kzPS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pay.on.date 8 DATE L kzPS
pay.then.hold 1 YN L $(M3)MK[mp]I[mk]PS[kzPS]|2
pay.to.limit 11 PMONEY R $(M3)MK[mp]I[mk]PS[kzPS]|0
pay.with.discount 6 DEC R $(M3)MK[mp]I[mk]PS[kzPS]|1
pay.with.discount.amount 10 MONEY R $(M3)MK[mp]I[mk]PS[kzPS]|3
Ì € i 2
pl.date.units
[po.urn,inv.num, pld.rec.no]
$(M3)MK[mp]I[mk]PLD[recN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
pld.rec.no 3 PINT R recN
pld.date 8 DATE L $(M3)MK[mp]I[mk]PLD[recN]|1
pld.line 4 PINT R $(M3)MK[mp]I[mk]PLD[recN]|2
pld.pack.list 20 FREE L $(M3)MK[mp]I[mk]PLD[recN]|0
Ì € i 2
summary
[po.urn, sum.po.line]
$(M3)MK[mp]L[mpL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
sum.po.line 4 PINT R mpL
sum.us 8 SINT R $(M3)MK[mp]L[mpL]|0
sum.us.approved 8 SINT R $(M3)MK[mp]L[mpL]|2
sum.us.not.approved 8 SINT R $(M3)MK[mp]L[mpL]|3
sum.us.tax 8 SINT R $(M3)MK[mp]L[mpL]|1
Ì i 2
mm.batch
[mm.batch.ap.db,mm.batch.date,mm.batch.number]
*(M)MKB[gnA,mkBD,mkBN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mm.batch.ap.db 12 FREE L MIS.APPL.DB gnA
mm.batch.date 8 DATE L mkBD
mm.batch.number 3 PINT R mkBN
mm.batch.comment 30 FREE L *(M)MKB[gnA,mkBD,mkBN]|3
mm.batch.ctrl.amt 11 SMONEY R *(M)MKB[gnA,mkBD,mkBN]|5
mm.batch.ctrl.num 3 PINT R *(M)MKB[gnA,mkBD,mkBN]|4
mm.batch.first.user 10 FREE L MIS.USER *(M)MKB[gnA,mkBD,mkBN]|1
mm.batch.last.user 10 FREE L MIS.USER *(M)MKB[gnA,mkBD,mkBN]|2
mm.batch.pur.fac 10 FREE L MIS.PUR.FAC *(M)MKB[gnA,mkBD,mkBN]|6
mm.batch.status 11 CHOICE L *(M)MKB[gnA,mkBD,mkBN]|0
Ì € i 2
mm.batch.invoice
[mm.batch.ap.db,mm.batch.date,mm.batch.number, mm.batch.seq]
*(M)MKB[gnA,mkBD,mkBN]I[mkBS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mm.batch.seq 3 PINT R mkBS
mm.batch.deleted.date 8 DATE L *(M)MKB[gnA,mkBD,mkBN]I[mkBS]|5
mm.batch.deleted.time 5 FREE L *(M)MKB[gnA,mkBD,mkBN]I[mkBS]|6
mm.batch.deleted.user 10 FREE L MIS.USER *(M)MKB[gnA,mkBD,mkBN]I[mkBS]|4
mm.batch.inv.deleted 1 YN L *(M)MKB[gnA,mkBD,mkBN]I[mkBS]|3
mm.batch.inv.num 15 FREE L *(M)MKB[gnA,mkBD,mkBN]I[mkBS]|1
mm.batch.po.urn 30 FREE L *(M)MKB[gnA,mkBD,mkBN]I[mkBS]|2
mm.batch.vendor 11 FREE L MIS.VEN *(M)MKB[gnA,mkBD,mkBN]I[mkBS]|0
Ì € i 2
mm.batch.transfer
[mm.batch.ap.db,mm.batch.date,mm.batch.number, mm.batch.trans.date,mm.batch.trans.num]
*(M)MKB[gnA,mkBD,mkBN]T[mkTD,mkTN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mm.batch.trans.date 8 DATE L mkTD
mm.batch.trans.num 3 PINT R mkTN
mm.batch.trans.status 10 FREE L *(M)MKB[gnA,mkBD,mkBN]T[mkTD,mkTN]
Ì i 2
purge.status
[purge.ap.db]
*(M)MKPD[gn]
Field Name Len Dat Typ J DPM Offset/Local/VAL
purge.ap.db 12 FREE L MIS.APPL.DB gn
last.purge.date 8 DATE L *(M)MKPD[gn]|0
Ì i 2
transfer
[mm.db.trans,ap.db.trans,trans.date,trans.num]
*(M)MKT[gnM,gnA,mkTD,mkTN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mm.db.trans 12 FREE L MIS.APPL.DB gnM
ap.db.trans 12 FREE L MIS.APPL.DB gnA
trans.date 8 DATE L mkTD
trans.num 3 PINT R mkTN
tr.ap.reject.inv.num 3 PINT R *(M)MKT[gnM,gnA,mkTD,mkTN]|13
tr.mm.batch.date 8 DATE L *(M)MKT[gnM,gnA,mkTD,mkTN]|8
tr.mm.batch.fac 10 FREE L MIS.PUR.FAC *(M)MKT[gnM,gnA,mkTD,mkTN]A|1
tr.mm.batch.number 3 PINT R *(M)MKT[gnM,gnA,mkTD,mkTN]|9
tr.new.fmt 1 YN L *(M)MKT[gnM,gnA,mkTD,mkTN]|15
tr.old.trans.flag 1 YN L *(M)MKT[gnM,gnA,mkTD,mkTN]A|2
tr.pur.fac.override 10 FREE L MIS.PUR.FAC *(M)MKT[gnM,gnA,mkTD,mkTN]A|0
tr.status 10 CHOICE L *(M)MKT[gnM,gnA,mkTD,mkTN]|14
tr.tax.1 10 SMONEY R *(M)MKT[gnM,gnA,mkTD,mkTN]|16
tr.tax.2 10 SMONEY R *(M)MKT[gnM,gnA,mkTD,mkTN]|17
trans.batch.num 3 PINT R *(M)MKT[gnM,gnA,mkTD,mkTN]|1
trans.dis 10 SMONEY R *(M)MKT[gnM,gnA,mkTD,mkTN]|6
trans.failed 7 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]|10
trans.frt 10 SMONEY R *(M)MKT[gnM,gnA,mkTD,mkTN]|5
trans.gr 11 SMONEY R *(M)MKT[gnM,gnA,mkTD,mkTN]|3
trans.net 11 SMONEY R *(M)MKT[gnM,gnA,mkTD,mkTN]|7
trans.queue.time 5 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]|11
trans.start.date 8 DATE L *(M)MKT[gnM,gnA,mkTD,mkTN]|12
trans.start.time 5 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]|0
trans.tax 10 SMONEY R *(M)MKT[gnM,gnA,mkTD,mkTN]|4
trans.user 10 FREE L MIS.USER *(M)MKT[gnM,gnA,mkTD,mkTN]|2
Ì € i 2
tr.invoices
[mm.db.trans,ap.db.trans,trans.date,trans.num, tr.vendor,tr.invoice]
*(M)MKT[gnM,gnA,mkTD,mkTN]I[gr,mk]
Field Name Len Dat Typ J DPM Offset/Local/VAL
tr.vendor 11 FREE L MIS.VEN gr
tr.invoice 15 FREE L mk
tr.invoice.po.urn 30 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]I[gr,mk]
Ì € i 2
tr.mm.batch.sequence
[mm.db.trans,ap.db.trans,trans.date,trans.num, tr.ap.batch.txn]
*(M)MKT[gnM,gnA,mkTD,mkTN]S[mkAS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
tr.ap.batch.txn 3 PINT R mkAS
tr.mm.batch.seq 3 PINT R *(M)MKT[gnM,gnA,mkTD,mkTN]S[mkAS]
Ì € i 2
trans.errors
[mm.db.trans,ap.db.trans,trans.date,trans.num, tr.err.num]
*(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]
Field Name Len Dat Typ J DPM Offset/Local/VAL
tr.err.num 3 PINT R maE
tr.err.bad.facility 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|20
tr.err.balance 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|9
tr.err.bank 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|12
tr.err.bank.pt.ref.dis 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|16
tr.err.discount 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|8
tr.err.freight 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|7
tr.err.gross 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|5
tr.err.inv.activity 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|15
tr.err.inv.num 15 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|1
tr.err.itc 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|19
tr.err.new 1 YN L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|11
tr.err.po.num 10 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|2
tr.err.po.urn 30 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|10
tr.err.purgeable 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|13
tr.err.purged 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|14
tr.err.tax 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|6
tr.err.tax.1 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|17
tr.err.tax.2 1 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|18
tr.err.type.ap 3 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|4
tr.err.type.mm 3 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|3
tr.err.vendor 11 FREE L *(M)MKT[gnM,gnA,mkTD,mkTN]E[maE]|0
Ì i 2
view.temp.exc.lines
[vt.qxl]
/MKVTXL[mkxlVT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
vt.qxl 4 PINT R mkxlVT
vt.exc.cost.inv 11 MONEY R /MKVTXL[mkxlVT]|5
vt.exc.cost.po 11 MONEY R /MKVTXL[mkxlVT]|4
vt.exc.item.desc 30 FREE L /MKVTXL[mkxlVT]|9
vt.exc.item.num 10 FREE L /MKVTXL[mkxlVT]|10
vt.exc.line 4 PINT R /MKVTXL[mkxlVT]|0
vt.exc.manuf.catlg 15 FREE L /MKVTXL[mkxlVT]|12
vt.exc.ok 1 YN L /MKVTXL[mkxlVT]|8
vt.exc.pr.dis 1 YN L /MKVTXL[mkxlVT]|7
vt.exc.qty.cancelled 10 FREE L /MKVTXL[mkxlVT]|19
vt.exc.qty.dis 1 YN L /MKVTXL[mkxlVT]|6
vt.exc.qty.ext.offsets 10 FREE L /MKVTXL[mkxlVT]|15
vt.exc.qty.inv 10 FREE L /MKVTXL[mkxlVT]|3
vt.exc.qty.ordered 10 FREE L /MKVTXL[mkxlVT]|16
vt.exc.qty.other.inv 10 FREE L /MKVTXL[mkxlVT]|14
vt.exc.qty.po 10 FREE L /MKVTXL[mkxlVT]|2
vt.exc.qty.rcvd.not.inv 10 FREE L /MKVTXL[mkxlVT]|18
vt.exc.qty.recvd 10 FREE L /MKVTXL[mkxlVT]|17
vt.exc.qty.returned 10 FREE L /MKVTXL[mkxlVT]|20
vt.exc.qty.this.inv 10 FREE L /MKVTXL[mkxlVT]|13
vt.exc.qty.total.inv 10 FREE L /MKVTXL[mkxlVT]|21
vt.exc.sort.num 15 FREE L /MKVTXL[mkxlVT]|1
vt.exc.vend.catlg 15 FREE L /MKVTXL[mkxlVT]|11
Index Files Subscripts/Physical Base
database.x [ap.database,po.urn]
?(M)MKDB[gnA,mp]
fa.link.usage.x [fa.database,fa.link.date,fa.link.no,fa.seq.no] = fa.link.user
?(M)MKFAX[gnF,dt,mkFA,mkFSQ]
fa.link.x [fa.po.urn,fa.inv.num,fa.line.no,fa.link.no]
?(M)MKFAI[mp,mk,mpL,mkFA]
fac.x [fac.type,purch.facility,vendor,inv.num] = po.urn
?(M)MKVF[mwFT,mw,gr,mk]
prepay.x [ap.database,po.urn]
?(M)MKPP[gnA,mp]
status.x [ap.database,status,vendor,inv.num] = po.urn
?(M)MKS[gnA,mkS,gr,mk]
tax.code.x [tax.gl.period,tax.tax.code,vendor,inv.num] = po.urn
?(M)MKTC[gpD,gea,gr,mk]
ven.inv.x [vendor,inv.num] = po.urn
?(M)MKVI[gr,mk]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | |