PO23.1 – Purchase Order Worksheet
- System
- Purchase Order (PO)
- Type
- Online screen — form 23
- Updates
- 177 tables
- References
- 190 tables
PO23.1 (Purchase Order Worksheet) is a Lawson Purchase Order online screen (form 23, subform 1). It updates ACAMCODE, ACCOMMIT, ACCOMMITX, ACTRANS, ADDRDATA, AMACCOUNT, AMACCTAU, AMACCTGPAU and 169 more and references ACACCTCAT, ACACCTCATX, ACACTGRP, ACACTIVITY, ACBILL, ACBILLX, ACBUDHDR, ACCAL and 182 more.
About PO23.1
Use Purchase Order Worksheet (PO23.1) to manage requisition lines that require buyer intervention or that could not go automatically to a purchase order due to no cost, no vendor, or requester did not have the authority to enter a price that should be use on a purchase order. Note: The Tax Estimate function is used when a third-party tax source is used (excluding Vertex). **Processing Effect You can make changes using the Purchase Order Worksheet that will not create purchase orders, and then let PO100 pull these corrected lines the next time you run it.
More information: You can run Purchase Order Interface From Lawson Applications (PO100) first. Then you can use the Purchase Order Worksheet (PO23.1) to review the requisition lines that did not automatically go to a purchase order. You can 'add' lines that exist from another application, such as requisitions, case cart or order entry lines or lines from inventory replenishment. You can pull up inventory replenishment lines from Vendor Reorder Advice (IC140) by using an application code of IC. PO23 has a functionality that produces an audit record of requisition lines that were cancelled by the buyer before a purchase order is produced. The functionality also updates a cancelled quantity field on the requisition line. Cancelled lines on requisitions produced by Par Location Counts (IC83), Replenishment by Requisition PO (IC142), Distribution Requirements Report (DR100), Strategic Sourcing, and the Requisition, including Requisition Self Service, are audited by a database file in PO23. The requisition line cancel quantity is also updated when a requisition line is canceled. PO23 does not audit for Order Entry PO interface records because interface records from this program cannot be cancelled or changed. There is also no auditing for cancellations of line items in IC140. Cancellations are possible on these line items, but they are not audited by PO23.
Updated files (177)
| Table | Description | System |
|---|---|---|
| ACAMCODE | Activity Asset | AC |
| ACCOMMIT | Activity Commitments | AC |
| ACCOMMITX | Activity Commitments Detail | AC |
| ACTRANS | Activity Transaction | AC |
| ADDRDATA | Address Code | IF |
| AMACCOUNT | Asset Management Account | AM |
| AMACCTAU | Asset Account Audit | AM |
| AMACCTGPAU | Asset Account Group Audit | AM |
| AMACCTGRP | Asset Account Group | AM |
| AMASSET | Asset | AM |
| AMASSETADJ | Asset Adjustment | AM |
| AMASSETDSP | Asset Disposal | AM |
| AMASSETGRP | Asset Group | AM |
| AMASSETTRF | Asset Transfer | AM |
| AMASTBKADJ | Asset Book Adjustment | AM |
| AMASTBKDSP | Asset Book Disposal | AM |
| AMASTBKTRF | Asset Book Transfer | AM |
| AMASTBOOK | Asset Book | AM |
| AMASTITADJ | Asset Item Adjustment | AM |
| AMASTITDSP | Asset Item Disposal | AM |
| AMASTITEM | Asset Item | AM |
| AMASTITTRF | Asset Item Transfer | AM |
| AMASTMXVAL | Asset Attributes | AM |
| AMASTRECAP | Asset Depreciation Recapture | AM |
| AMASTRPAIR | Asset Repair | AM |
| AMASTTYPAU | Asset Type Audit | AM |
| AMASTTYPE | Asset Type | AM |
| AMAUGROUP | Asset Accounting Unit Group | AM |
| AMAUGRPAU | AM Accounting Unit Group Audit | AM |
| AMBKHIST | Asset Book History | AM |
| AMBKHISTX | Period Asset Book History | AM |
| AMBKTEMPLT | Book Template | AM |
| AMBKTRANS | Asset Book Transactions | AM |
| AMCALENDAR | Asset Calendar | AM |
| AMCLASSDEP | This file contains the depreciation information for account level depreciation to support Telecommunications Industry… | AM |
| AMCNTRLAU | Asset System Options Audit | AM |
| AMCONTROL | Asset Internal Control | AM |
| AMCTLTRANS | Asset Control Transaction | AM |
| AMDIVISION | Asset Division | AM |
| AMDIVISNAU | AM Division Audit | AM |
| AMINTER | Asset Interface | AM |
| AMINTERAU | Asset Interface Audit | AM |
| AMLOCATION | Asset Location | AM |
| AMLOCAUDIT | AM Location Audit | AM |
| AMMONITOR | No description in the Lawson data dictionary | AM |
| AMPOASTDTL | PO Asset Detail | AM |
| AMPOASTHDR | PO Asset Header | AM |
| AMPODFLTS | PO Defaults | AM |
| AMPUHIS | Personal Use History | AM |
| AMSEGBLOCK | No description in the Lawson data dictionary | AM |
| AMTAXAUTH | Tax Authority | AM |
| AMTEMPLATE | Asset Template | AM |
| AMTRANS | Asset Transaction | AM |
| AMTRANSUMM | Asset Transaction Summary | AM |
| APAPPROVAL | Invoice Approval | AP |
| APAUDIT | Vendor Invoice Audit | AP |
| APCOMMENTS | Comments | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APHLDINV | Hold | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APVENADDR | AP Vendor Address | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENGROUP | Vendor Group | AP |
| APVENLOC | Vendor Location | AP |
| APVENMAST | Vendor Master Record | AP |
| APVENPAY | No description in the Lawson data dictionary | AP |
| BUYER | PO Buyer Master | PO |
| CBBANKINST | Bank Transaction Code | CB |
| CBCASHCODE | Cash Code | CB |
| CBCHECK | Accounts Payable Cash Payment | CB |
| COCOMP | Demand Line Kit Components | WH |
| COLINE | Customer Order Line | OE |
| COSGBLK | No description in the Lawson data dictionary | OE |
| CUSTDESC | AR Group Customer | AR |
| CXCOMPANY | Case Cart Company | CX |
| CXCPIUAVAL | No description in the Lawson data dictionary | CX |
| CXITEMHIST | Case Cart Item History | CX |
| CXPREFITEM | Preference Items | CX |
| FBDETAIL | Budget Detail | GL |
| FBFUNDAMT | Budget Fund Balance | GL |
| FBTRANS | Budget Transactions | GL |
| FBYETR | No description in the Lawson data dictionary | GL |
| GLCOMMIT | GL Commitments | GL |
| GLCOMMITX | GL commitment Detail | GL |
| GLHISCOMBL | No description in the Lawson data dictionary | GL |
| GLHISCOMX | No description in the Lawson data dictionary | GL |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| HCHPPAUDIT | No description in the Lawson data dictionary | IC |
| HCPATCHRG | Patient Charge | IC |
| HCPATPROC | No description in the Lawson data dictionary | IC |
| HCPATVISIT | Patient Visit | IC |
| ICCOMPANY | Inventory Company Information | IC |
| ICFACILITY | Ship To Facility | IC |
| ICHISTORY | Transaction History | IC |
| ICICRAUDIT | No description in the Lawson data dictionary | IC |
| ICITEMCODE | Item Code | IC |
| ICLOCATION | Company Location | IC |
| ICLOT | Lots with Expire Date/On Hold | IC |
| ICRECEIPTS | Costing Record | IC |
| ICTRANS | Inventory Transaction | IC |
| ICTRANSDTL | Inventory Transaction Detail | IC |
| INSTDETAIL | Intrastat Detail Transactions | TX |
| INSTHEADER | Intrastat Transaction Header | TX |
| INSTNBR | Intrastat Company Numbers | TX |
| ITEMLOC | Item Location | IC |
| ITSERIAL | Serial Numbers | IC |
| KWDDETAIL | No description in the Lawson data dictionary | IC |
| KWDMASTER | No description in the Lawson data dictionary | IC |
| MAAOCDTL | Invoice Add On Cost Detail | MA |
| MAINVDTL | Invoice Line Detail | MA |
| MAMAAHIST | No description in the Lawson data dictionary | MA |
| MAMADHIST | No description in the Lawson data dictionary | MA |
| MMDIST | Account Distributions | PO |
| MMUAVAL | No description in the Lawson data dictionary | PO |
| MXLISTHDR | Attribute List Header | IF |
| MXLISTMBR | Attribute List | IF |
| POAGMAUDIT | Vendor Agreement Audit | PO |
| POAGMTPRIC | Agreement Pricing | PO |
| POAOCDTL | Add On Cost Detail | PO |
| POAOCMAST | Add On Cost Master | PO |
| POAOCSPRD | Add On Cost Spread | PO |
| POAPPROVE | No description in the Lawson data dictionary | PO |
| POAUDIT | Audit Records | PO |
| POCODE | Purchase Order Codes | PO |
| POCOMPANY | Company System Master | PO |
| POHDROUT | No description in the Lawson data dictionary | PO |
| POHDRPVT | No description in the Lawson data dictionary | PO |
| POINTAOC | Interface Add On Cost | PO |
| POINTAUDIT | No description in the Lawson data dictionary | PO |
| POINTERFAC | Interface File | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POIVACMNT | No description in the Lawson data dictionary | PO |
| POLINE | Line Items | PO |
| POLINEOUT | No description in the Lawson data dictionary | PO |
| POLINEPVT | No description in the Lawson data dictionary | PO |
| POLINESRC | PO Line Source | PO |
| POMATCHOBJ | Cost Change Information | PO |
| POMESSAGE | Buyer Messages | PO |
| POPCRUF | No description in the Lawson data dictionary | PO |
| POPLIUF | No description in the Lawson data dictionary | PO |
| POPOVUF | No description in the Lawson data dictionary | PO |
| PORECEIVE | PO Receivers | PO |
| PORECLINE | PO Line Item Receivings | PO |
| PORETURNHD | PO Return Header | PO |
| PORETURNLN | PO Return Line | PO |
| POREVISION | PO Revision | PO |
| POTRACK | Package Tracking Number | PO |
| POTRANSDTL | PO Transaction Detail | PO |
| POVACOMMIT | Commitments for Vendor Agrmt | PO |
| POVACOMMIX | No description in the Lawson data dictionary | PO |
| POVADIST | Vendor Agreement Distribution | PO |
| POVAGRMTHD | Vendor Agreement | PO |
| POVAGRMTLN | Vendor Agreement Line | PO |
| POVAPARTLN | Contract Participant Line | PO |
| POVENDLOC | Vendor Location Master | PO |
| POVENDOR | PO Vendor Master | PO |
| PURCHORDER | Purchase Order Master | PO |
| RECAOCDTL | Receiving AOC Detail | PO |
| REQHEADER | Requisition Header | RQ |
| REQLINE | Requisition Line | RQ |
| ROUTEDOC | Route Document | WH |
| ROUTEHDR | Route Header | WH |
| ROUTESTOP | Route Stop | WH |
| RQAUDIT | Requisition Audit | RQ |
| RQTRANS | Requisition Transactions | RQ |
| SOHDETAIL | Stock-on-Hand Detail | IC |
| SUBCKPOINT | Subledger Check Point | IF |
| SYSTEMCODE | System Code | IF |
| TERMS | Payment Terms Maintenance | TE |
| TXCODEMAST | Tax Code Master | TX |
| TXCOMPANY | Tax Company | TX |
| TXTAXCODE | Tax Code Maintenance | TX |
| TXTAXTABLE | Tax Table | TX |
| WHDEMAND | Demand | WH |
| WHDEMNDHDR | Demand Header | WH |
Referenced files (190)
| Table | Description | System |
|---|---|---|
| ACACCTCAT | Activity Account Categories | AC |
| ACACCTCATX | Account Category Detail | AC |
| ACACTGRP | Activity Group | AC |
| ACACTIVITY | Activity | AC |
| ACBILL | Activity Billing | BR |
| ACBILLX | Activity Billing Detail | BR |
| ACBUDHDR | Activity Budget Header | AC |
| ACCAL | Activity Calendar | AC |
| ACCALX | Activity Calendar Detail | AC |
| ACCATGRP | Account Category Group | AC |
| ACCATGRPX | Account Category Group Detail | AC |
| ACCATSUM | Account Category Summary | AC |
| ACCATSUMX | Account Category Summ Detail | AC |
| ACCNTRACT | Activity Contract | BR |
| ACCONSOL | Activity Consolidation | AC |
| ACIFACTV | This file contains activity import information from AC500 (Activity Import). | AC |
| ACPRDPERF | Activity Period Performance | AC |
| ACTRANS | Activity Transaction | AC |
| AMASSETBOD | No description in the Lawson data dictionary | AM |
| AMASSETDSP | Asset Disposal | AM |
| AMASSETTRF | Asset Transfer | AM |
| AMASTBKDSP | Asset Book Disposal | AM |
| AMASTBKTRF | Asset Book Transfer | AM |
| AMASTITDSP | Asset Item Disposal | AM |
| AMASTITTRF | Asset Item Transfer | AM |
| AMASTMXVAL | Asset Attributes | AM |
| AMASTRPAIR | Asset Repair | AM |
| AMBOOK | Asset Book Name | AM |
| AMCOMPUTE | Compute | AM |
| AMLOCDTL | Location Detail | AM |
| AMMETHOD | Asset Method | AM |
| AMPUCODE | Asset Personal Use Code | AM |
| AMTABLEPCT | Percent Table | AM |
| AMTABLETAX | Asset Management Tax Table | AM |
| AMTRANSBOD | No description in the Lawson data dictionary | AM |
| AMTYPALLOC | The The Asset Management Type Allocation file stores the allocation history for a type (type and subtype). | AM |
| AMTYPALLOX | The Asset Type Allocation Detail file stores the accounting units and percentages for each company, asset type (or… | AM |
| AMUOPPDS | Units of Production Periods | AM |
| APACCRCODE | Invoice Accrual Code | AP |
| APAPIHIST | Vendor Invoice History | AP |
| APAPPROVAL | Invoice Approval | AP |
| APAUTHOR | Authority Code | AP |
| APCOMMENTS | Comments | AP |
| APCOMPANY | Accounts Payable Company | AP |
| APCONTACT | No description in the Lawson data dictionary | AP |
| APCPYVND | Vendor Company Codes | AP |
| APDISCCODE | Discount Code | AP |
| APDISTHDR | Distribution Code Header | AP |
| APHLDINV | Hold | AP |
| APHOLDCODE | Hold Code | AP |
| APINCCODE | Income Code | AP |
| APINVOICE | Accounts Payable Invoice | AP |
| APPAYMENT | Invoice Payment | AP |
| APPROCGRP | Process Group | AP |
| APPROCLEV | Accounts Payable Process Level | AP |
| APUAVAL | No description in the Lawson data dictionary | AP |
| APUSRFLDEF | AP User Field Definition | AP |
| APVENBAL | Vendor Balance | AP |
| APVENCERT | No description in the Lawson data dictionary | AP |
| APVENCLASS | Vendor Class | AP |
| APVENLOC | Vendor Location | AP |
| APVNMXVAL | No description in the Lawson data dictionary | AP |
| ARCOMP | Accounts Receivable Company | AR |
| ARCUSTGRP | Accounts Receivable Cust Group | AR |
| ARCUSTOMER | AR Company Customer | AR |
| BILLTO | Bill To | AR |
| BUYBOD | No description in the Lawson data dictionary | PO |
| BUYCLASS | PO Buyer Purch Class Auth | PO |
| BUYCMPLOC | No description in the Lawson data dictionary | PO |
| BUYERGRP | PO Buyer Group Master | PO |
| BUYVENPF | Buyer/Vendor Purchase From | PO |
| CBCHECK | Accounts Payable Cash Payment | CB |
| CBUSER | Cash Ledger User | CB |
| CBUSRCLASS | Cash Ledger User Class | CB |
| COMPONENT | User Field | IC |
| CUCODES | Currency Codes | IF |
| CUCONV | Currency Exhange Rate | IF |
| CURELAT | Currency Relationships | IF |
| CUSTORDER | Customer Order File | OE |
| CXBURDEN | Case Cart Burden | CX |
| CXCASEHEAD | Case Cart Header | CX |
| CXCASEPREF | Case Cart Preferences | CX |
| CXPTMPITEM | Template Items | CX |
| EEADVANCE | Employee Advance | AP |
| EEAPPROVAL | Expense Advance Approval Code | AP |
| EEEXPENSE | Employee Expense | AP |
| FBFUNDDTL | Budget Fund Detail | GL |
| FBHEADER | Budget Header | GL |
| GLADDRESS | General Ledger Company Address | IF |
| GLAMOUNTS | General Ledger Amounts | GL |
| GLCGCPY | Company Group Company | IF |
| GLCHART | General Ledger Chart | IF |
| GLCHARTDTL | General Ledger Chart Detail | IF |
| GLCHARTSUM | General Ledger Chart Summary | IF |
| GLCODES | General Ledger Codes | IF |
| GLINTCO | General Ledger Intercompany | IF |
| GLMASTER | General Ledger Account Master | IF |
| GLNAMES | General Ledger Names | IF |
| GLNLOCDTL | No description in the Lawson data dictionary | IC |
| GLSYSTEM | General Ledger Company | IF |
| GLTRANS | General Ledger Transactions | GL |
| GMFNDACT | Grant Eligible Activities | GM |
| HCCHRGITEM | Charge Item | IC |
| ICBIN | Bin Numbers | IC |
| ICCATEGORY | GL Account Category | IC |
| ICCOUT | No description in the Lawson data dictionary | WH |
| ICFACILITY | Ship To Facility | IC |
| ICITEMGTIN | Inventory Item for GTIN | IC |
| ICMFGCODE | IC Manufacturing Code | IC |
| ICMFGDIST | IC Manufacturers Distribution | IC |
| ICRPTGRP | Report Group | IC |
| ICVALUOM | Valid Units Of Measure | IC |
| INDOCTPCD | No description in the Lawson data dictionary | TX |
| INLINETYPE | No description in the Lawson data dictionary | TX |
| INSTATPROC | Intrastat Stat Procedure | TX |
| INSTCMDTY | ICN and Unit of Measure Codes | TX |
| INSTCTRYCD | Intrastat Country Codes | TX |
| INSTNOTC | Intrastat Nature of Trans Code | TX |
| INSTPORTS | No description in the Lawson data dictionary | TX |
| INSTREGN | Intrastat Region Code | TX |
| ITEMGROUP | Item Group | IC |
| ITEMMAST | Item Master | IC |
| ITEMSPECL | No description in the Lawson data dictionary | IC |
| ITEMSRC | Item Source | IC |
| ITEMSUB | Item Substitute | IC |
| KITITEM | Kit Item | IC |
| KWDSETUP | No description in the Lawson data dictionary | IC |
| KWDSYNONYM | Keywords Synonym | IC |
| LMLEASE | Lease Information | LM |
| LMLEASESEG | This file stores the user analysis values for a lease. | LM |
| MACOMPANY | Matching Company | MA |
| MAELMGPREL | Match Element Group Relation | MA |
| MAELMVALUE | Matching Element Value | MA |
| MAINVHAND | Invoice Handling Code | MA |
| MAMATCHTBL | Match Table | MA |
| MAMSGTOL | No description in the Lawson data dictionary | MA |
| MAMTCHELEM | Matching Elements | MA |
| MAMTCHRULE | Matching Rules | MA |
| MAPOINV | Multiple PO Invoice | MA |
| MAREASONCD | Matching Reason Code | MA |
| MATCHCLASS | Match Class | MA |
| MFGSHPFAC | Manufacturer Relationship | IC |
| MXCATDEF | Attribute Definition | IF |
| MXELEMENT | Attribute Element | IF |
| MXLISTDTL | Attribute List Detail | IF |
| MXOBJCAT | Attribute Object | IF |
| NATACCT | Accounts Receivable Natl Acct | AR |
| NATBALANCE | AR National Account Balance | AR |
| OECOMPANY | Order Entry Company | BL |
| OECUST | Customer Order Processing | AR |
| OEFRTCODE | Order Entry Freight Code | BL |
| OEORDCMNT | Customer Order Comments | OE |
| OEROUTE | Order Entry Route | OE |
| ORDERTYPE | Order Type | OE |
| PDCARD | P-Card | PO |
| PDCCHRGERR | No description in the Lawson data dictionary | PO |
| PJLBOD | No description in the Lawson data dictionary | PO |
| POAGMTPART | Vendor Agreement Participants | PO |
| POAPPCODE | No description in the Lawson data dictionary | PO |
| POAUDRULES | Audit Rules | PO |
| POAUDTYPE | Audit Types | PO |
| POCONTGRP | This table contains detail information on a CM contract group. | PO |
| PODOCREF | Document Reference | PO |
| POITEMVEN | PO Vendor Item Information | PO |
| POMXVAL | Attribute | PO |
| POPCRUF | No description in the Lawson data dictionary | PO |
| POPLIUF | No description in the Lawson data dictionary | PO |
| PORECADJHD | Receiving Adjustments Header | PO |
| PORECADJLN | Receiving Adjustments Line | PO |
| POREVISION | PO Revision | PO |
| PORLNUF | No description in the Lawson data dictionary | RQ |
| PORQHUF | No description in the Lawson data dictionary | RQ |
| POVAGLNERR | No description in the Lawson data dictionary | PO |
| PROCLEV | Matching Process Level | MA |
| PROCTEMPLN | Procurement Template Line | PO |
| PROCUREGRP | Procurement Group | PO |
| PTHBOD | No description in the Lawson data dictionary | PO |
| PVHBOD | No description in the Lawson data dictionary | PO |
| REASON | Reason Code | IC |
| REQUESTER | Requester | RQ |
| RQAOCDTL | No description in the Lawson data dictionary | RQ |
| RQLOC | Requesting Locations | RQ |
| STATICCUST | AR Ovrd Credit Trans Review | AR |
| STCOMMCODE | PO Standard Comment Codes | PO |
| TXTAXRATE | Tax Rate | TX |
| WFSETUP | No description in the Lawson data dictionary | WF |
| WHPROCTYPE | Shipment Process Type | WH |
| WHSHIPLINE | Shipment Line | WH |
| WHSHIPMENT | Shipment | WH |
| WHSHLAUD | Shipment Line Audit | WH |
Program calls
Invoked programs (42)
ACAC, ACSB, ACTA, AMCO, API3, API4, GLCC, ICCP, ICI1, ICI9, IFAC, IFAU, IFCU, IFFC, IFGT, IFLU, IFOB, IFRS, IFSC, IFSG, IFUP, POBL, POCP, POI1, POI4, POI6, POI7, POI9, POIA, POIF, POIG, POIH, POII, POIJ, POIL, POIM, POIX, SLFD, SLSB, SLSE, SLSS, SLSU