Lawson Insight Technical Documentation

Generated by:
ERDs
Tables
PO25


PO25.1 - Vendor Agreement

**Form Purpose
Use Vendor Agreement (PO25.1) to create and maintain vendor price agreements.

**More Information
There are five kinds of vendor agreements that you can create: Contract,
Blanket, Catalog or Quote, Standing, and Service.

Vendor price agreements can have several dated price structure records
attached to them to allow future pricing to be held in the Purchase Order
application. This also allows historical price information to be stored. The
records will show markups or markdowns from a base price, and price break
levels.




Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    COCOMP     -

    COLINE     -

    COSGBLK    -

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    ICCOMPANY  -

    ICHISTORY  -

    ICLOCATION -

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    -

    ITSERIAL   -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    POAGMTPART -

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGLNERR -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APCOMPANY  -

    APDISTHDR  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    APVENMAST  -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCODES    -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    CUSTORDER  -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    FBDETAIL   -

    FBFUNDDTL  -

    FBHEADER   -

    FOBCODE    -

    GLADDRESS  -

    GLAMOUNTS  -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCODES    -

    GLINTCO    -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY -

    ICCOUT     -

    ICFACILITY -

    ICMANFCODE -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMGROUP  -

    ITEMMAST   -

    KITITEM    -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    OEFRTCODE  -

    OEROUTE    -

    ORDERTYPE  -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POFRTTERM  -

    POITEMVEN  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCLEV    -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQLINE    -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


PO25.2 - Agreement Pricing

**Form Purpose
Use Agreement Pricing (PO25.2) to add specific detail pricing information
about the price agreement.

Agreement Pricing lets you set up multiple pricing structures (by date) under
a single vendor pricing agreement. For example, you can set up a 2 percent
price markup for the first year, and a 3 percent price markup for the second
year.




Updated Files

    POAGMTPRIC -


Referenced Files

    POVAGRMTHD -

    POVAGRMTLN -

    PROCUREGRP -


PO25.3 - Vendor Agreement Participants

**Form Purpose
Use Vendor Agreement Participants (PO25.3) to define participants for this
price agreement. The companies defined on this form are the only ones able to
use the selected price agreement.




Updated Files

    POAGMTPART -


Referenced Files

    ICLOCATION -

    POCOMPANY  -

    POVAGRMTHD -

    POVAGRMTLN -

    PROCUREGRP -

    RQLOC      -


PO25.5 - Vendor Agreement Item AOC

**Form Purpose
Use Vendor Agreement Item AOC (PO25.5) to define add-on cost information for
the vendor agreement.




Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    COCOMP     -

    COLINE     -

    COSGBLK    -

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    ICCOMPANY  -

    ICHISTORY  -

    ICLOCATION -

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    -

    ITSERIAL   -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APCOMPANY  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP -

    APVENMAST  -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCODES    -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    CUSTORDER  -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    GLADDRESS  -

    GLCHART    -

    GLCODES    -

    GLINTCO    -

    GLNAMES    -

    GLSYSTEM   -

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY -

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMGROUP  -

    ITEMMAST   -

    KITITEM    -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    OEFRTCODE  -

    OEROUTE    -

    ORDERTYPE  -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCLEV    -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQLINE    -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


PO25.6 - Vendor Agreement Line

**Form Purpose
Use Vendor Agreement Line (PO25.6) to maintain vendor price agreement line
information.

Distribution codes can be defined to blanket and standing agreement types
only.  Blanket agreements with distribution codes require a single company
participant to be defined.

**More Information
Only vendor agreement lines with a value of Y in the Lawson Item field on
Identify Lawson Items by Vendor Agreement Line (PO36.1) will display on this
form.

Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    COCOMP     -

    COLINE     -

    COSGBLK    -

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    ICAUDIT    -

    ICCOMPANY  -

    ICHISTORY  -

    ICLOCATION -

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    -

    ITEMMAST   -

    ITEMNDC    -

    ITEMSKU    -

    ITEMUPC    -

    ITEMUPN1   -

    ITEMUPN2   -

    ITSERIAL   -

    KWDDETAIL  -

    KWDMASTER  -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POITEMVEN  -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGLNERR -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APCOMPANY  -

    APCPYVND   -

    APDISTHDR  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENCLASS -

    APVENGROUP -

    APVENLOC   -

    APVENMAST  -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCODES    -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    CUSTORDER  -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    FBDETAIL   -

    FBFUNDDTL  -

    FBHEADER   -

    FOBCODE    -

    GLADDRESS  -

    GLAMOUNTS  -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCODES    -

    GLINTCO    -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY -

    ICCOUT     -

    ICFACILITY -

    ICGENERIC  -

    ICITEMCODE -

    ICMANFCODE -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMGROUP  -

    KITITEM    -

    KWDSETUP   -

    KWDSYNONYM -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAJORCL    -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    MINORCL    -

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    OEFRTCODE  -

    OEROUTE    -

    ORDERTYPE  -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POFRTTERM  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCLEV    -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQLINE    -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    TXUSAGECD  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


PO25.7 - Service Agreement Line

**Form Purpose
Use Service Agreement Line (PO25.7) to inquire on or make changes to the
service agreement lines on a vendor agreement.

A distribution code or an account number must be added to each service
agreement line.  The distribution code is defined using Distribution Code
(AP05.3) and must be  of the type Service.

Updated Files

    ACCOMMIT   -

    ACCOMMITX  -

    COCOMP     -

    COLINE     -

    COSGBLK    -

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    ICAUDIT    -

    ICCOMPANY  -

    ICHISTORY  -

    ICLOCATION -

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    -

    ITEMMAST   -

    ITEMNDC    -

    ITEMSKU    -

    ITEMUPC    -

    ITEMUPN1   -

    ITEMUPN2   -

    ITSERIAL   -

    KWDDETAIL  -

    KWDMASTER  -

    MAPOOLCNT  -

    MMDIST     -

    MMUAVAL    -

    POAGMTPART -

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  -

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POITEMVEN  -

    POLINE     -

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  -

    POPCRUF    -

    POPLIUF    -

    PORECEIVE  -

    PORECLINE  -

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGLNERR -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER -

    RECAOCDTL  -

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  -

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


Referenced Files

    ACACCTCAT  -

    ACACTGRP   -

    ACACTIVITY -

    AMASSET    -

    AMTEMPLATE -

    APACCRCODE -

    APAPIHIST  -

    APCOMPANY  -

    APCPYVND   -

    APDISTHDR  -

    APHLDINV   -

    APINVOICE  -

    APPAYMENT  -

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENCLASS -

    APVENGROUP -

    APVENLOC   -

    APVENMAST  -

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      -

    BUYVENPF   -

    COMPONENT  -

    CUCODES    -

    CUCONV     -

    CURELAT    -

    CUSTDESC   -

    CUSTORDER  -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    FBDETAIL   -

    FBFUNDDTL  -

    FBHEADER   -

    FOBCODE    -

    GLADDRESS  -

    GLAMOUNTS  -

    GLCHART    -

    GLCHARTDTL -

    GLCHARTSUM -

    GLCODES    -

    GLINTCO    -

    GLMASTER   -

    GLNAMES    -

    GLSYSTEM   -

    GLTRANS    -

    HCCHRGITEM -

    ICBIN      -

    ICCATEGORY -

    ICCOUT     -

    ICFACILITY -

    ICGENERIC  -

    ICITEMCODE -

    ICMANFCODE -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMGROUP  -

    KITITEM    -

    KWDSETUP   -

    KWDSYNONYM -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAJORCL    -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    MINORCL    -

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    OEFRTCODE  -

    OEROUTE    -

    ORDERTYPE  -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POFRTTERM  -

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCLEV    -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  -

    REQLINE    -

    REQUESTER  -

    RQLOC      -

    STATICCUST -

    STCOMMCODE -

    SYSTEMCODE -

    TXTAXRATE  -

    TXUSAGECD  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


PO25.9 - Agreement Line Error Messages

**Form Purpose
Use Agreement Line Error Messages (PO25.9) to view fatal or non-fatal errors
that were found for this vendor agreement line when item number processing was
performed.

Fatal errors will prevent the item number from being assigned to the line
because of problems with determining what item number to use. Non-fatal errors
occur when an item number is created and added to the item master but there
are problems with additional data. For example, a UNSPSC code may not be
defined in the system.

Non-fatal error messages will begin with the word WARNING.

Updated Files

    None.


Referenced Files

    POVAGLNERR -


INVOKED Programs

    ACAC
    ACCL
    API4
    IFAC
    IFCU
    IFSG
    SLSE
    SLSU
    API3
    ICCP
    ICI1
    IFOB
    IFRS
    POCP
    POIF
    POIH
    POI1
    POI6
    POI4
    POI7
    PHI6
    POI9
    POIA
    POIL
    POIX
    POIG
    POII
    IFAU
    POIJ
    POIM
    ICIB