Ì i 2
mm.od.po.top (po.top)
[po.od.urn]
/MYP[myp]
Field Name Len Dat Typ J DPM Offset/Local/VAL
po.od.urn 10 FREE L myp
po.buyer 10 FREE L MIS.USER /MYP[myp]M2|4
po.buyer.name 30 FREE L /MYP[myp]M2|5
po.cancel.date 8 DATE L /MYP[myp]M2|3
po.close.date 8 DATE L /MYP[myp]M2|1
po.cycle.period 3 PINT R /MYP[myp]M2|7
po.cycles 3 PINT R /MYP[myp]M2|8
po.cycles.completed 3 PINT R /MYP[myp]M2|9
po.deliv.date 8 DATE L /MYP[myp]M|6
po.fac.addr.1 30 FREE L /MYP[myp]FA|0
po.fac.addr.2 30 FREE L /MYP[myp]FA|1
po.fac.addr.3 30 FREE L /MYP[myp]FA|2
po.fac.deliv.addr.1 30 FREE L /MYP[myp]FD|0
po.fac.deliv.addr.2 30 FREE L /MYP[myp]FD|1
po.fac.deliv.addr.3 30 FREE L /MYP[myp]FD|2
po.fac.exempt.pur.cert 20 FREE L /MYP[myp]F|2
po.fac.exempt.pur.state 5 FREE L /MYP[myp]F|3
po.fac.inv.addr.1 30 FREE L /MYP[myp]FI|0
po.fac.inv.addr.2 30 FREE L /MYP[myp]FI|1
po.fac.inv.addr.3 30 FREE L /MYP[myp]FI|2
po.fac.name 35 FREE L /MYP[myp]F|1
po.facility 10 FREE L /MYP[myp]F|0
po.file.version 2 INT R /MYP[myp]M|0
po.first.rcv.date 8 DATE L /MYP[myp]M2|2
po.fob 35 FREE L /MYP[myp]M|8
po.inventory 10 FREE L MM.INVENT /MYP[myp]M|3
po.inventory.name 30 FREE L /MYP[myp]M|4
po.mam.date.purge 8 DATE L
po.number 10 FREE L /MYP[myp]M|1
po.open.date 8 DATE L /MYP[myp]M2|0
po.order.date 8 DATE L /MYP[myp]M|5
po.order.type 8 FREE L /MYP[myp]M2|6
po.tax.type 3 FREE L /MYP[myp]M|10
po.terms 35 FREE L /MYP[myp]M|9
po.total 11 DEC4 R /MYP[myp]M|7
po.type 9 CHOICE L /MYP[myp]M|2
po.vendor 11 FREE L MIS.VEN /MYP[myp]V|0
po.vendor.addr.1 35 FREE L /MYP[myp]V|3
po.vendor.addr.2 35 FREE L /MYP[myp]V|4
po.vendor.addr.3 35 FREE L /MYP[myp]V|5
po.vendor.name 35 FREE L /MYP[myp]V|1
po.vendor.name.2 35 FREE L /MYP[myp]V|2
po.vendor.tax.rate 6 DEC3 R /MYP[myp]V|6
Ì € i 2
mm.od.po.cds (po.cds)
[po.od.urn, po.cds.line.num]
/MYP[myp]C[mypC]
Field Name Len Dat Typ J DPM Offset/Local/VAL
po.cds.line.num 5 PINT R mypC
po.cds.line 92 FREE L /MYP[myp]C[mypC]
Ì € i 2
mm.od.po.invoices (po.invoices)
[po.od.urn, po.inv.num]
/MYP[myp]I[mkS]
Field Name Len Dat Typ J DPM Offset/Local/VAL
po.inv.num 15 FREE L mkS
po.inv.date 8 DATE L /MYP[myp]I[mkS]|0
po.inv.discount 10 SMONEY R /MYP[myp]I[mkS]|7
po.inv.freight 10 SMONEY R /MYP[myp]I[mkS]|6
po.inv.gross 11 SMONEY R /MYP[myp]I[mkS]|3
po.inv.rcv.date 8 DATE L /MYP[myp]I[mkS]|1
po.inv.tax.1 10 SMONEY R /MYP[myp]I[mkS]|4
po.inv.tax.2 10 SMONEY R /MYP[myp]I[mkS]|5
po.inv.type 3 FREE L /MYP[myp]I[mkS]|2
Ì € i 2
mm.od.po.lines (po.lines)
[po.od.urn, po.line]
/MYP[myp]L[mpL]
Field Name Len Dat Typ J DPM Offset/Local/VAL
po.line 4 PINT R mpL
po.asset.tag 10 FREE L /MYP[myp]L[mpL]|8
po.cost.up 10 DEC4 R /MYP[myp]L[mpL]|0
po.department 15 FREE L MIS.GL.DEPT /MYP[myp]L[mpL]|9
po.gl.account 25 FREE L MIS.GL.ACCOUNT /MYP[myp]L[mpL]|12
po.item.category 8 FREE L MM.CATEGORY /MYP[myp]L[mpL]I|3
po.item.category.name 30 FREE L /MYP[myp]L[mpL]I|4
po.item.desc 30 FREE L /MYP[myp]L[mpL]I|5
po.item.desc.2 30 FREE L /MYP[myp]L[mpL]I|6
po.item.mfr 10 FREE L MIS.MFR /MYP[myp]L[mpL]I2|2
po.item.mfr.cat.no 15 FREE L /MYP[myp]L[mpL]I2|4
po.item.mfr.name 30 FREE L /MYP[myp]L[mpL]I2|3
po.item.name 30 FREE L /MYP[myp]L[mpL]I|2
po.item.number 10 FREE L /MYP[myp]L[mpL]I|1
po.item.pkg.string 40 FREE L /MYP[myp]L[mpL]I2|0
po.item.urn 43 URN L MM.ITEM /MYP[myp]L[mpL]I|0
po.item.ven.cat.no 15 FREE L /MYP[myp]L[mpL]I2|1
po.line.inv 10 FREE L MM.INVENT /MYP[myp]L[mpL]|10
po.line.inv.name 30 FREE L /MYP[myp]L[mpL]|11
po.qty.up 7 INT R /MYP[myp]L[mpL]|4
po.smallest.unit 10 FREE L /MYP[myp]L[mpL]|2
po.tax.code 3 FREE L MIS.TAX.CODE /MYP[myp]L[mpL]|13
po.tax.code.name 25 FREE L /MYP[myp]L[mpL]|14
po.tot.canc.us 7 INT R /MYP[myp]L[mpL]|7
po.tot.ord.us 7 INT R /MYP[myp]L[mpL]|5
po.tot.rcv.us 7 INT R /MYP[myp]L[mpL]|6
po.unit.of.pur 10 FREE L /MYP[myp]L[mpL]|1
po.up.us 10 PINT R /MYP[myp]L[mpL]|3
Ì € i 2
mm.od.po.transactions (po.transactions)
[po.od.urn,po.line, po.txn.urn]
/MYP[myp]L[mpL]T[mpT]
Field Name Len Dat Typ J DPM Offset/Local/VAL
po.txn.urn 5 INT R mpT
po.txn.amt 11 DEC4 R /MYP[myp]L[mpL]T[mpT]|5
po.txn.comment 75 FREE L /MYP[myp]L[mpL]T[mpT]|7
po.txn.date 8 DATE L /MYP[myp]L[mpL]T[mpT]|1
po.txn.packing.list 20 FREE L /MYP[myp]L[mpL]T[mpT]|4
po.txn.qty.us 11 INT R /MYP[myp]L[mpL]T[mpT]|6
po.txn.type 1 CHOICE L /MYP[myp]L[mpL]T[mpT]|0
po.txn.user 10 FREE L MIS.USER /MYP[myp]L[mpL]T[mpT]|2
po.txn.user.name 30 FREE L /MYP[myp]L[mpL]T[mpT]|3
Ì 2
INDEX FILE/INTERNAL NAME SUBSCRIPTS/PHYSICAL BASE
mm.od.po.buyer.x [po.buyer,po.number]
po.buyer.x ?MYPB[gu,mpR]
mm.od.po.department.x [po.department,po.number,po.line]
po.department.x ?MYPD[gd,mpR,mpL]
mm.po.inventory.x [po.inventory,po.number,po.line]
po.inventory.x ?MYPI[mi,mpR,mpL]
mm.od.po.invoices.x [po.inv.num,po.number]
po.invoices.x ?MYPIN[mkS,mpR]
mm.od.po.item.x [po.item.urn,po.number,po.line]
po.item.x ?MYPIT[mt,mpR,mpL]
mm.od.po.number.x [po.number] = po.od.urn
po.number.x ?MYPN[mpR]
mm.od.po.ord.date.x [po.order.date,po.number]
po.ord.date.x ?MYPO[mpDD,mpR]
mm.po.pack.list.x [po.txn.packing.list,po.number,po.line]
po.pack.list.x ?MYPPL[mpPL,mpR,mpL]
mm.od.po.type.x [po.type,po.number]
po.type.x ?MYPT[mpS,mpR]
mm.od.po.vendor.x [po.vendor,po.number]
po.vendor.x ?MYPV[gr,mpR]
|
|
| | | |