Ì i 2
mm.invoice.accrual.aging.file (accrual.aging)
[acc.ending.date,acc.po.urn,acc.po.line,acc.txn.urn]
: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 :MKAC[gpD,mp,mpL,mpT]|2
acc.cost.up 10 DEC4 R :MKAC[gpD,mp,mpL,mpT]|0
acc.partial.rcpt 1 YN L :MKAC[gpD,mp,mpL,mpT]|6
acc.po.up.us 7 PINT R :MKAC[gpD,mp,mpL,mpT]|4
acc.qty 11 INT R :MKAC[gpD,mp,mpL,mpT]|1
acc.tax.rate 6 DEC3 R :MKAC[gpD,mp,mpL,mpT]|5
acc.txn.date 8 DATE L :MKAC[gpD,mp,mpL,mpT]|3
Ì i 2
mm.invoice.batch.status (batch.status)
[ap.db]
:MKSTS[iaDA]
Field Name Len Dat Typ J DPM Offset/Local/VAL
ap.db 12 FREE L MIS.APPL iaDA
first.open.date 8 DATE L :MKSTS[iaDA]|0
reset 1 YN L :MKSTS[iaDA]|1
Ì i 2
mm.invoice.fa.link (fa.link)
[fa.link.no]
: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 :MKFA[mkFA]|1
fa.line.no 4 PINT R :MKFA[mkFA]|2
fa.line.qty 8 PINT R :MKFA[mkFA]|5
fa.po.num 10 FREE L :MKFA[mkFA]|4
fa.po.urn 30 URN L MM.PO :MKFA[mkFA]|0
fa.qty.used 8 PINT R :MKFA[mkFA]|3
Ì € i 2
fa.link.multiple.lines (fa.link.multiple)
[fa.link.no, fa.sec.item.no]
: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 :MKFA[mkFA]SI[mkFSI]|1
fa.s.line.no 4 PINT R :MKFA[mkFA]SI[mkFSI]|2
fa.s.line.qty 8 PINT R :MKFA[mkFA]SI[mkFSI]|3
fa.s.po.num 10 FREE L :MKFA[mkFA]SI[mkFSI]|4
fa.s.po.urn 30 URN L MM.PO :MKFA[mkFA]SI[mkFSI]|0
Ì € i 2
mm.invoice.fa.link.usage (fa.link.usage)
[fa.link.no, fa.seq.no]
: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 :MKFA[mkFA]S[mkFSQ]|1
fa.database 12 FREE L MIS.APPL :MKFA[mkFA]S[mkFSQ]|0
fa.link.date 8 DATE L :MKFA[mkFA]S[mkFSQ]|4
fa.link.user 10 FREE L MIS.USER :MKFA[mkFA]S[mkFSQ]|3
fa.quantity 8 PINT R :MKFA[mkFA]S[mkFSQ]|2
Ì i 2
mm.invoice.file (main)
[po.urn]
: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=/.MM.AP.ACCESS.FROM.AP
access.from.mm 1 FREE L VAL=/.MM.AP.ACCESS.FROM.MM
ap.database 12 FREE L MIS.APPL :MK[mp]|2
ap.db.in.slash 18 FREE L VAL=/.DB.SAVE.AP
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))
mm.db.in.slash 18 FREE L VAL=/.DB.SAVE.MM
name 1 CHOICE L
po.num 10 FREE L :MK[mp]|0
purch.facility 10 FREE L MIS.PUR.FAC :MK[mp]|5
return 1 YN L :MK[mp]|3
tax.type 3 FREE L :MK[mp]|4
vendor 11 FREE L MIS.VEN :MK[mp]|1
Ì € i 2
external.offsets (external.offsets)
[po.urn, xo.po.line]
: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 :MK[mp]X[mpL]|6
xo.adj.tot.qty.us 11 SINT R :MK[mp]X[mpL]|5
xo.line.date 8 DATE L :MK[mp]X[mpL]|3
xo.line.time 4 HHMM L :MK[mp]X[mpL]|4
xo.line.tot.qty.disp 10 FREE L :MK[mp]X[mpL]|1
xo.line.tot.qty.us 11 SINT R :MK[mp]X[mpL]|0
xo.line.user 10 FREE L :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
mm.invoice.external.offset.pl (external.off.pl)
[po.urn,xo.po.line, xop.pack.list,xop.date]
: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 :MK[mp]X[mpL]R[mpPL,mpPLD]|0
Ì € i 2
external.invoiced.receipts (external.receipts)
[po.urn, xr.pack.list,xr.date,xr.line,xr.txn]
: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 :MK[mp]XR[mpPL,mpPLD,mpL,mpT]|0
Ì € i 2
mm.invoice.general.info (invoices)
[po.urn, inv.num]
: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 :MK[mp]I[mk]|11
ap.batch.txn 3 PINT R :MK[mp]I[mk]|21
approved.date 8 DATE L :MK[mp]I[mk]|12
auto.match.fail 1 YN L :MK[mp]I[mk]|14
batch.num 3 PINT R :MK[mp]I[mk]|20
description 65 FREE L :MK[mp]I[mk]DN
discount 10 SMONEY R :MK[mp]I[mk]|9
freight 10 SMONEY R :MK[mp]I[mk]|8
frt.tax.1 10 SMONEY R :MK[mp]I[mk]|29
frt.tax.2 10 SMONEY R :MK[mp]I[mk]|30
frt.tax.code 3 FREE L MIS.TAX.CODE :MK[mp]I[mk]|28
gl.period 10 FREE L MIS.GL.PERIOD :MK[mp]I[mk]|16
gross 11 SMONEY R :MK[mp]I[mk]|6
inp.mm.batch.num 3 PINT R :MK[mp]I[mk]|22
inp.mm.batch.seq 3 PINT R :MK[mp]I[mk]|23
input.date 8 DATE L :MK[mp]I[mk]|4
inv.date 8 DATE L :MK[mp]I[mk]|1
inv.tax.type 3 FREE L :MK[mp]I[mk]|26
inv.type 3 CHOICE L :MK[mp]I[mk]|10
process 1 FREE L :MK[mp]I[mk]|18
rcv.date 8 DATE L :MK[mp]I[mk]|2
remit.addr.1 35 FREE L :MK[mp]I[mk]RA|2
remit.addr.2 35 FREE L :MK[mp]I[mk]RA|3
remit.addr.3 35 FREE L :MK[mp]I[mk]RA["A"]|0
remit.addr.alt 35 FREE L :MK[mp]I[mk]RA["ALT"]|0
remit.city 20 FREE L :MK[mp]I[mk]RA|4
remit.csz 35 FREE L VAL=IF{@remit.city @remit.city_", "}_@remit.state_" "_
VAL=@remit.postal.code
remit.name 35 FREE L :MK[mp]I[mk]RA|0
remit.name.2 35 FREE L :MK[mp]I[mk]RA|1
remit.postal.code 10 FREE L :MK[mp]I[mk]RA|6
remit.state 2 FREE L :MK[mp]I[mk]RA|5
status 1 FREE L :MK[mp]I[mk]|0
tax 10 SMONEY R :MK[mp]I[mk]|7
tax.1 10 SMONEY R :MK[mp]I[mk]|24
tax.2 10 SMONEY R :MK[mp]I[mk]|25
tax.flag.conv 1 YN L :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 :MK[mp]I[mk]|5
transfer.num 3 PINT R :MK[mp]I[mk]|17
try.auto.match 1 YN L :MK[mp]I[mk]|13
update.approval 1 YN L :MK[mp]I[mk]|19
use.invent.var.accts 1 YN L :MK[mp]I[mk]|15
voucher 6 FREE L :MK[mp]I[mk]|3
Ì € i 2
mm.invoice.amts.by.date (amts.by.date)
[po.urn,inv.num, date]
: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 :MK[mp]I[mk]D[mkD]|4
date.freight 10 SMONEY R :MK[mp]I[mk]D[mkD]|3
date.gross 11 SMONEY R :MK[mp]I[mk]D[mkD]|1
date.net 11 SMONEY R :MK[mp]I[mk]D[mkD]|5
date.status 1 FREE L :MK[mp]I[mk]D[mkD]|0
date.tax 10 SMONEY R :MK[mp]I[mk]D[mkD]|2
date.tax.1 10 SMONEY R :MK[mp]I[mk]D[mkD]|6
date.tax.2 10 SMONEY R :MK[mp]I[mk]D[mkD]|7
Ì € i 2
mm.invoice.gl.distribution (gl.dist)
[po.urn,inv.num, gl.acct]
: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 :MK[mp]I[mk]G[ga]|2
gl.gross 11 SMONEY R :MK[mp]I[mk]G[ga]|0
gl.tax 10 SMONEY R :MK[mp]I[mk]G[ga]|1
gl.tax.1 10 SMONEY R :MK[mp]I[mk]G[ga]|3
gl.tax.2 10 SMONEY R :MK[mp]I[mk]G[ga]|4
Ì € i 2
mm.invoice.gl.dist.line.amts (gl.dist.line)
[po.urn,inv.num,gl.acct, gl.line]
: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 :MK[mp]I[mk]G[ga]L[mpL]
Ì € i 2
mm.invoice.ap.lines (inv.ap.lines)
[po.urn,inv.num, ap.inv.line]
: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 :MK[mp]I[mk]H[kzL]|0
ap.inv.edit.1 1 SMONEY R :MK[mp]I[mk]H[kzL]|9
ap.inv.edit.2 1 SMONEY R :MK[mp]I[mk]H[kzL]|10
ap.inv.freight 10 SMONEY R :MK[mp]I[mk]H[kzL]|2
ap.inv.gross 11 SMONEY R :MK[mp]I[mk]H[kzL]|1
ap.inv.pfrt 10 SMONEY R :MK[mp]I[mk]H[kzL]|6
ap.inv.pfrt.t1 10 SMONEY R :MK[mp]I[mk]H[kzL]|7
ap.inv.pfrt.t2 10 SMONEY R :MK[mp]I[mk]H[kzL]|8
ap.inv.t1 10 SMONEY R :MK[mp]I[mk]H[kzL]|4
ap.inv.t2 10 SMONEY R :MK[mp]I[mk]H[kzL]|5
ap.inv.tax.code 3 FREE L MIS.TAX.CODE :MK[mp]I[mk]H[kzL]|3
Ì € i 2
mm.invoice.invoiced.receipts (invoiced.receipts)
[po.urn,inv.num, inv.rec.pack.list,inv.rec.date,inv.rec.line,inv.rec.txn]
: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 :MK[mp]I[mk]R[mpPL,mpPLD,mpL,mpT]|0
Ì € i 2
mm.invoice.po.lines (lines)
[po.urn,inv.num, po.line]
: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 :MK[mp]I[mk]L[mpL]|9
line.gr.amt 11 SMONEY R :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 :MK[mp]I[mk]L[mpL]|13
line.pr.dis 1 YN L :MK[mp]I[mk]L[mpL]|12
line.qty.dis 1 YN L :MK[mp]I[mk]L[mpL]|11
line.qty.up 8 SINT R :MK[mp]I[mk]L[mpL]|0
line.qty.us 8 SINT R :MK[mp]I[mk]L[mpL]|1
line.rcv.tax.us 8 SINT R :MK[mp]I[mk]L[mpL]|6
line.rcv.tax.us.pl 8 SINT R :MK[mp]I[mk]L[mpL]|8
line.rcv.us 8 SINT R :MK[mp]I[mk]L[mpL]|5
line.rcv.us.pl 8 SINT R :MK[mp]I[mk]L[mpL]|7
line.tax.1 10 SMONEY R :MK[mp]I[mk]L[mpL]|16
line.tax.2 10 SMONEY R :MK[mp]I[mk]L[mpL]|17
line.tax.amt 10 SMONEY R :MK[mp]I[mk]L[mpL]|10
line.tax.code 3 FREE L MIS.TAX.CODE :MK[mp]I[mk]L[mpL]|15
line.tax.extra.us 8 SINT R :MK[mp]I[mk]L[mpL]|14
line.tax.us 8 SINT R :MK[mp]I[mk]L[mpL]|4
line.taxable 1 YN L :MK[mp]I[mk]L[mpL]|18
line.tot.qty.us 8 SINT R :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
mm.invoice.packing.lists (packing.lists)
[po.urn,inv.num, packing.list]
:MK[mp]I[mk]P[mpPL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
packing.list 20 FREE L mpPL
Ì € i 2
mm.ap.payment.schedule (payment.schedule)
[po.urn,inv.num, pay.on.date]
: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 :MK[mp]I[mk]PS[kzPS]|2
pay.to.limit 11 PMONEY R :MK[mp]I[mk]PS[kzPS]|0
pay.with.discount 6 DEC R :MK[mp]I[mk]PS[kzPS]|1
pay.with.discount.amount 10 MONEY R :MK[mp]I[mk]PS[kzPS]|3
Ì € i 2
mm.invoice.reciepts.for.match (pl.date.units)
[po.urn,inv.num, pld.rec.no]
: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 :MK[mp]I[mk]PLD[recN]|1
pld.line 4 PINT R :MK[mp]I[mk]PLD[recN]|2
pld.pack.list 20 FREE L :MK[mp]I[mk]PLD[recN]|0
Ì € i 2
mm.invoice.remit.email.address (remit.email.address)
[po.urn,inv.num, remit.email.q]
:MK[mp]I[mk]RA["E",mkrEQ]
Field Name Len Dat Typ J DPM Offset/Local/VAL
remit.email.q 2 PINT R mkrEQ
remit.email.addr 40 FREE L :MK[mp]I[mk]RA["E",mkrEQ]|0
Ì € i 2
mm.invoice.line.summary (summary)
[po.urn, sum.po.line]
: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 :MK[mp]L[mpL]|0
sum.us.approved 8 SINT R :MK[mp]L[mpL]|2
sum.us.not.approved 8 SINT R :MK[mp]L[mpL]|3
sum.us.tax 8 SINT R :MK[mp]L[mpL]|1
Ì i 2
mm.invoice.batch.file (mm.batch)
[mm.batch.ap.db,mm.batch.date,mm.batch.number]
:MKB[iaDA,mkBD,mkBN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mm.batch.ap.db 12 FREE L MIS.APPL iaDA
mm.batch.date 8 DATE L mkBD
mm.batch.number 3 PINT R mkBN
mm.batch.comment 30 FREE L :MKB[iaDA,mkBD,mkBN]|3
mm.batch.ctrl.amt 11 SMONEY R :MKB[iaDA,mkBD,mkBN]|5
mm.batch.ctrl.num 3 PINT R :MKB[iaDA,mkBD,mkBN]|4
mm.batch.first.user 10 FREE L MIS.USER :MKB[iaDA,mkBD,mkBN]|1
mm.batch.last.user 10 FREE L MIS.USER :MKB[iaDA,mkBD,mkBN]|2
mm.batch.status 11 CHOICE L :MKB[iaDA,mkBD,mkBN]|0
Ì € i 2
mm.invoice.batch.invoice (mm.batch.invoice)
[mm.batch.ap.db,mm.batch.date,mm.batch.number, mm.batch.seq]
:MKB[iaDA,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 :MKB[iaDA,mkBD,mkBN]I[mkBS]|5
mm.batch.deleted.time 5 FREE L :MKB[iaDA,mkBD,mkBN]I[mkBS]|6
mm.batch.deleted.user 10 FREE L MIS.USER :MKB[iaDA,mkBD,mkBN]I[mkBS]|4
mm.batch.inv.deleted 1 YN L :MKB[iaDA,mkBD,mkBN]I[mkBS]|3
mm.batch.inv.num 15 FREE L :MKB[iaDA,mkBD,mkBN]I[mkBS]|1
mm.batch.po.urn 30 FREE L :MKB[iaDA,mkBD,mkBN]I[mkBS]|2
mm.batch.vendor 11 FREE L MIS.VEN :MKB[iaDA,mkBD,mkBN]I[mkBS]|0
Ì € i 2
mm.invoice.mm.batch.pur.facs (mm.batch.pur.facilities)
[mm.batch.ap.db,mm.batch.date,mm.batch.number, mm.batch.invoice.pur.fac]
:MKB[iaDA,mkBD,mkBN]PF[mw]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mm.batch.invoice.pur.fac 10 FREE L MIS.PUR.FAC mw
mm.batch.invoices.fac 5 INT R :MKB[iaDA,mkBD,mkBN]PF[mw]
Ì € i 2
mm.invoice.batch.transfers (mm.batch.transfer)
[mm.batch.ap.db,mm.batch.date,mm.batch.number, mm.batch.trans.date,mm.batch.trans.num]
:MKB[iaDA,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.1 VAL=>@mm.batch.transfer[mm.batch.ap.db,mm.batch.dat
VAL=e,mm.batch.number,""]
mm.batch.trans.2 VAL=<@mm.batch.transfer[mm.batch.ap.db,mm.batch.dat
VAL=e,mm.batch.number,""]
mm.batch.trans.status 10 FREE L :MKB[iaDA,mkBD,mkBN]T[mkTD,mkTN]
Ì i 2
mm.invoice.purge.status (purge.status)
[purge.ap.db]
:MKPD[iaD]
Field Name Len Dat Typ J DPM Offset/Local/VAL
purge.ap.db 12 FREE L MIS.APPL iaD
last.purge.date 8 DATE L :MKPD[iaD]|0
Ì i 2
mm.invoice.transfer.file (transfer)
[mm.db.trans,ap.db.trans,trans.date,trans.num]
:MKT[iaDM,iaDA,mkTD,mkTN]
Field Name Len Dat Typ J DPM Offset/Local/VAL
mm.db.trans 12 FREE L MIS.APPL iaDM
ap.db.trans 12 FREE L MIS.APPL iaDA
trans.date 8 DATE L mkTD
trans.num 3 PINT R mkTN
tr.ap.reject.inv.num 3 PINT R :MKT[iaDM,iaDA,mkTD,mkTN]|13
tr.mm.batch.date 8 DATE L :MKT[iaDM,iaDA,mkTD,mkTN]|8
tr.mm.batch.number 3 PINT R :MKT[iaDM,iaDA,mkTD,mkTN]|9
tr.new.fmt 1 YN L :MKT[iaDM,iaDA,mkTD,mkTN]|15
tr.old.trans.flag 1 YN L :MKT[iaDM,iaDA,mkTD,mkTN]A|2
tr.status 10 CHOICE L :MKT[iaDM,iaDA,mkTD,mkTN]|14
tr.tax.1 10 SMONEY R :MKT[iaDM,iaDA,mkTD,mkTN]|16
tr.tax.2 10 SMONEY R :MKT[iaDM,iaDA,mkTD,mkTN]|17
trans.batch.num 3 PINT R :MKT[iaDM,iaDA,mkTD,mkTN]|1
trans.dis 10 SMONEY R :MKT[iaDM,iaDA,mkTD,mkTN]|6
trans.failed 7 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]|10
trans.frt 10 SMONEY R :MKT[iaDM,iaDA,mkTD,mkTN]|5
trans.gr 11 SMONEY R :MKT[iaDM,iaDA,mkTD,mkTN]|3
trans.net 11 SMONEY R :MKT[iaDM,iaDA,mkTD,mkTN]|7
trans.queue.time 5 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]|11
trans.start.date 8 DATE L :MKT[iaDM,iaDA,mkTD,mkTN]|12
trans.start.time 5 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]|0
trans.tax 10 SMONEY R :MKT[iaDM,iaDA,mkTD,mkTN]|4
trans.user 10 FREE L MIS.USER :MKT[iaDM,iaDA,mkTD,mkTN]|2
Ì € i 2
mm.invoice.transfered.invoices (tr.invoices)
[mm.db.trans,ap.db.trans,trans.date,trans.num, tr.vendor,tr.invoice]
:MKT[iaDM,iaDA,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 :MKT[iaDM,iaDA,mkTD,mkTN]I[gr,mk]
Ì € i 2
mm.invoice.transfer.batch.seq (tr.mm.batch.sequence)
[mm.db.trans,ap.db.trans,trans.date,trans.num, tr.ap.batch.txn]
:MKT[iaDM,iaDA,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 :MKT[iaDM,iaDA,mkTD,mkTN]S[mkAS]
Ì € i 2
mm.invoice.transfer.errors (trans.errors)
[mm.db.trans,ap.db.trans,trans.date,trans.num, tr.err.num]
:MKT[iaDM,iaDA,mkTD,mkTN]E[maE]
Field Name Len Dat Typ J DPM Offset/Local/VAL
tr.err.num 3 PINT R maE
tr.err.balance 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|9
tr.err.bank 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|12
tr.err.bank.pt.ref.dis 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|16
tr.err.discount 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|8
tr.err.freight 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|7
tr.err.gross 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|5
tr.err.inv.activity 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|15
tr.err.inv.num 15 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|1
tr.err.itc 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|19
tr.err.new 1 YN L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|11
tr.err.po.num 10 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|2
tr.err.po.urn 30 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|10
tr.err.purgeable 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|13
tr.err.purged 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|14
tr.err.tax 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|6
tr.err.tax.1 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|17
tr.err.tax.2 1 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|18
tr.err.type.ap 3 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|4
tr.err.type.mm 3 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|3
tr.err.vendor 11 FREE L :MKT[iaDM,iaDA,mkTD,mkTN]E[maE]|0
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mm.invoice.database.index [ap.database,po.urn]
database.x ?MKDB[iaD,mp]
mm.invoice.fa.link.usage.x [fa.database,fa.link.date,fa.link.no,fa.seq.no] = fa.link.user
fa.link.usage.x ?MKFAX[iaD,dt,mkFA,mkFSQ]
mm.invoice.fa.link.x [fa.po.urn,fa.inv.num,fa.line.no,fa.link.no]
fa.link.x :MKFAI[mp,mk,mpL,mkFA]
mm.inv.vendor.index [inv.num,vendor] = po.urn
inv.ven.x ?MKIV[mk,gr]
mm.invoice.prepay.x [ap.database,po.urn]
prepay.x :MKPP[iaD,mp]
mm.invoice.status.index [ap.database,status,vendor,inv.num] = po.urn
status.x ?MKS[iaD,mkS,gr,mk]
mm.invoice.tax.code.x [tax.gl.period,tax.tax.code,vendor,inv.num] = po.urn
tax.code.x :MKTC[gpD,gea,gr,mk]
mm.invoice.vendor.index [vendor,inv.num] = po.urn
ven.inv.x ?MKVI[gr,mk]
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | | | | |