Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

RQ20

RQ20.1 - Speed PO Create

Use this form to create a purchase order from a single requisition. The
system converts all the lines on the requisition into a purchase order line.
You can not exclude requisition lines using this form. If you do not want to
convert all the lines into purchase order lines, use RQ20.2 (Buyer Requisition
Review) and RQ20.4 (Model PO Select).

The requisition must be previously approved before it can be converted into a
purchase order. The buyer can inquire on the requisition, change attributes,
add required fields, create a purchase order, and release the purchase order
into the Purchase Order system. Once a purchase order has been created and
released, it is maintained in the Purchase Order system.

Updated Files

    ACCOMMIT   - Contains commitments not yet posted to the general ledger.

    ACCOMMITX  - Contains commitment details not yet posted to the general
                 ledger.

    COCOMP     - The Demand Line Kit Components file contains the kit
                 components that make up a line on a document.

    COLINEDTL  - The Order Line Allocated Details file contains line allocation
                 information created when the item is tracked by bin, lot,
                 serial number, or multiple unit of measure.

    ICCOMPANY  - Used to edit the company number.

    ICLOCATION - Used to edit the location code.

    ICLOT      - The Lots with Expire Date/On Hold file stores the expiration
                 dates and/or the hold flag for lots.

    ICRECEIPTS - The cost history file is used for LIFO and FIFO costing.

    ITEMGROUP  - Enables companies to share Item Master records or to keep them
                 separate by company.

    ITEMLOC    - Used to validate a "from" location name.

    ITSERIAL   - Stores the valid serial numbers currently in stock and issued.

    MMDIST     - This record holds an account number and possibly an activity
                 code intended for a general ledger distribution of an inventory
                 item.

    MMUAVAL    - This file stores the user analysis values defined for
                 transactions.

    POAOCDTL   - Contains all add-on costs related to a purchase order.

    POCOMMENTS - Used in a Purchase Order common routine.

    POCOMOUT   -

    POCOMPANY  - Contains valid Purchase Order companies and corresponding
                 parameters.

    POHDROUT   -

    POINTERFAC - Primary file maintained by this program.

    POLINE     - Used in a Purchase Order common routine.

    POLINEOUT  -

    PURCHORDER - Used in a Purchase Order common routine.

    REQHEADER  - Used to get requisition status.

    REQLINE    - Detail file maintained by program.

    ROUTEDOC   - The Route Document file contains documents that are to be
                 delivered along a route.

    ROUTEHDR   - For all routes created, the system added a header record to
                 the Route Header file.

    ROUTESTOP  - The Route Stop file contains records set up to identify the
                 stops along a route.

    RQAPPROVE  - Contains open approval records that need approval because the
                 approval amount level is less than the requisition total value.


    RQCOMMENTS - Used to display a "comments exist" message on the screen.

    SOHDETAIL  - The Stock On Hand Detail File contains the detail quantities
                 for an item at a location for items controlled by bin or
                 lot/sublot or multiple units of measure.

    STPOLINE   - Used in a Purchase Order common routine.

    STPURCHORD - Used in a Purchase Order common routine.

    TERMS      - Contains Terms codes used to calculate due date and discount
                 information for an invoice.

    TXCODEMAST - The Tax Code Master file contains tax codes, descriptions, and
                 the tax types that define how the tax code is used.

    TXCOMPANY  - The Tax Company file contains company information, as well as
                 which tax system the company uses.

    TXTAXCODE  - The Tax Code file contains all tax code information used to
                 calculate tax transactions.

    TXTAXTABLE - Contains a tax table that defines a series of up to eight tax
                 codes to be applied to a single transaction and determines how
                 each tax code will affect the taxable amount of a transaction.

    WHDEMAND   - The Demand file contains all the records that the Warehouse
                 system needs for processing demands.

    WHDEMNDCMT - Referenced by warehouse API's that validate item type.

    WHDEMNDHDR - Used to create or update a Warehouse system demand header
                 record. The Demand Header file contains document header
                 records.


Referenced Files

    ACACCTCAT  - Used to validate account categories maintained in the Activity
                 Management system.

    ACACTGRP   - Contains the highest reporting level in the Activity
                 Management system.

    ACACTIVITY - Used to validate the activities maintained in the Activity
                 Management system.

    ACCAL      - Contains calendar information from the Activity Management
                 system.

    ACCALX     - Contains detail calendar information from the Activity
                 Management system.

    AMASSET    - Used to validate the asset numbers maintained in the Asset
                 Management system.

    AMTEMPLATE - Used to validate the asset template numbers maintained in the
                 Asset Management system.

    APACCRCODE - Used in a Accounts Payable common routine.

    APCOMPANY  - Used in a Accounts Payable common routine.

    APCPYVND   - The Vendor Company Codes file contains default codes assigned
                 a vendor or alternate vendor location at the company level.

    APHLDINV   - Used to determine what invoices for a vendor are on hold.

    APPROCLEV  - Contains process levels used to default accounts used for
                 posting transactions, break and subtotal reports, and process
                 payments.

    APVENCLASS - Used in a Accounts Payable common routine.

    APVENGROUP - A vendor group represents a group of vendors that can be
                 shared by one or more accounts payable companies.

    APVENLOC   - Used in a Accounts Payable common routine.

    APVENMAST  - Used in a Accounts Payable common routine.

    BUYCLASS   - Defines valid item major and minor purchasing classes for a
                 buyer.

    BUYER      - Used in a Purchase Order  common routine to edit data during
                 release.

    COMPONENT  - Contains the component items that make up a kit item.

    CUACCT     - This file contains account numbers that variance amounts are
                 posted to when a timing difference occurs between the beginning
                 and the completion of a transaction.

    CUCONV     - Used in a Currency conversion common routine.

    CURELAT    - Used in a Lawson currency conversion common routine.

    CUTABLE    - This file defines currency tables.

    FOBCODE    - Describes valid ship term codes for a purchase order.

    GLADDRESS  - Used in a General Ledger common routine.

    GLCHART    - Contains chart and system account information in the General
                 Ledger system including retained earnings, undistributed
                 retained earnings, error suspense, and gain/loss account
                 records.

    GLCODES    - Used in a General Ledger common routine.

    GLINTCO    - Contains interzone and intercompany relationships.

    GLSYSTEM   - Used in a General Ledger common routine.

    ICBIN      - Used to validate a bin number.

    ICCATEGORY - Used to extract account information.

    ICCOUT     -

    INSTCTRYCD - This file maintains the Intrastat country codes.

    INSTHEADER - This file contains transaction information for Intrastat
                 records.

    ITEMMAST   - Used to get non-stock item description.

    ITEMSUB    - The Item Substitute file stores valid substitutes for an item.

    KITITEM    - Contains the valid kit or parent items for a kit or assembly.

    OEFRTCODE  - Contains freight codes that can be used in the Order Entry
                 system.

    OEROUTE    - Contains all user-defined routes that are set up in the Order
                 Entry system.

    ORDERTYPE  - The Order Type file stores order type parameters.

    POAOCSPRD  - Used internally to document the add-on cost spread method used
                 when entering or invoicing a purchase order.

    POAPPROVE  - Contains purchase order line item, miscellaneous add-on cost,
                 and line item add-on cost approval information by invoice and
                 purchase order.

    POAUDIT    - Contains a record of all changes to a purchase order that
                 affect the printed purchase order.

    POFRTTERM  - Contains a list of valid Purchase Order freight terms.

    POITEMVEN  - Used in a Purchase Order common routine.

    POLOCCON   - Contains a list of valid override contracts for a location.

    POQUOTES   - Used in a Purchase Order common routine.

    PORECEIVE  - Used to validate and default purchase order receiving
                 information.

    PORECLINE  - Used in a Purchase Order common routine.

    POVENDLOC  - Used in a Purchase Order common routine for vendor location
                 information.

    POVENDOR   - Used in a Purchase Order common routine to obtain vendor
                 information.

    REQUESTER  - This is the file of valid requesters.

    RQACCTU    - This is the list of valid accounting units that this requester
                 can enter on a requisition.

    RQAPPCODE  - Defines the codes that are assigned to requesters to identify
                 the approval hierarchy for all requisitions entered by that
                 requester.

    RQLOC      - Used to validate requesting location name.

    RQPURCHCLS - Contains the list of valid purchasing major classes that a
                 requester can enter items for on a requisition.

    RQTEMPLINE - Contains the items on a requisition template.

    STCOMMCODE - Used to default standard comment codes on a standard purchase
                 order.

    SYSTEMCODE - This file contains system code information used for remote
                 site processing.

    TXTAXRATE  - The Tax Rate file stores tax rates in effect for a specific
                 tax code.

    WFSETUP    -

    WHPROCTYPE - The Shipment Process Type file contains process type records
                 used for determining the steps an order is to take in the
                 Warehouse system.


RQ20.2 - Buyer Requisition Review

Use this form to review the new requisitions and assign the items to vendors.
The form displays all unassigned requisitions for the same item. You can
select which requisitions are to be combined into one line on the purchase
order.

Note:  At this point, you have not created a purchase order. You are
combining multiple requisitions for the same requested item into one purchase
order line. The system tracks the distributions for each original requisition
line. You can combine only those requisition lines that have the same activity
and contract number. You can use normal system unit cost defaults. You can
change the quantity ordered and enter the purchase order unit cost. This can
be different from the requisition line unit costs. Or you can have the first
requisition line unit cost default.

Updated Files

    ICCOMPANY  - Used to edit the company number.

    ITEMLOC    - Used to validate an item number from a specific location.

    MMUAVAL    - This file stores the user analysis values defined for
                 transactions.

    POINTERFAC - Used to verify that an interface record exists for the vendor.

    POLINE     - Contains purchase order line item information.

    PURCHORDER - Primary file maintained by program.

    REQLINE    - Detail file maintained by the program.


Referenced Files

    APCOMPANY  - Used in a Accounts Payable common routine.

    APCPYVND   - The Vendor Company Codes file contains default codes assigned
                 a vendor or alternate vendor location at the company level.

    APHLDINV   - Used to determine what invoices for a vendor are on hold.

    APVENCLASS - Used in a Accounts Payable common routine.

    APVENGROUP - Used in a Accounts Payable common routine.

    APVENLOC   - Used in a Accounts Payable common routine.

    APVENMAST  - Used in a Accounts Payable common routine.

    CUCONV     - Maintains rate tables for each defined currency relationship.

    CURELAT    - Used to validate currency relationships.

    GLCODES    - Used in a General Ledger common routine.

    GLSYSTEM   - Contains company information used primarily by the General
                 Ledger, but the file is also referenced by LAWSON INSIGHT
                 subsystems.

    ICBIN      - Used to validate a bin number.

    ICLOCATION - Used to edit the ship to location code.

    ITEMMAST   - Used to validate an item number.

    MMDIST     -

    POCOMPANY  - Used to update next purchase order number.

    POITEMVEN  - Used in a Purchase Order common routine.

    POLOCCON   - Contains a list of valid override contracts for a location.

    POQUOTES   - Contains the vendor's item identifier.

    POVENDOR   - Used to edit vendor.

    REQHEADER  - Used to validate a requisition header number.

    RQCOMMENTS - Used to print a "comments exist" flag on screen.

    RQLOC      - Used to edit the requesting location and extract the default
                 accounts.

    STPOLINE   - Used to get standard purchase order line information.

    STPURCHORD - Updated on blanket order selection.


RQ20.3 - Purchase Order Create

Use this form to create a purchase order header. This is the second step in
creating a purchase order. You do not assign purchase order lines here. Use
RQ20.4 (Model PO Select) to assign lines to the purchase order. The purchase
order number is either manually or automatically assigned depending on the
company policy defined in MA00.1 (Company Setup).

You can create a release from a blanket purchase order by entering the
blanket order name. When creating a blanket release, leave the purchase number
field blank. The number defaults to the blanket order number. A release number
is assigned with the purchase order number. The two fields are the complete
purchase order number.

You can assign a currency to the purchase order. Use CU01.1 (Currency Code)
to define currency. Also, the company must allow for multiple currency. The
currency policy is defined in MA00.1 (Company Setup). If company allows for
multiple currency, you can enter a valid currency code. If the vendor has a
currency code defined in AP10.1 (Vendor), that currency code defaults if the
field is left blank. If the vendor has a balance currency defined, you must
use that currency. If a default currency is not defined for the vendor, the
company base currency defined in GL10.1 (Company) defaults.

Updated Files

    ACCOMMIT   - Contains commitments not yet posted to the general ledger.

    ACCOMMITX  - Contains commitment details not yet posted to the general
                 ledger.

    MMDIST     - This record holds an account number and possibly an activity
                 code intended for a general ledger distribution of an inventory
                 item.

    MMUAVAL    - This file stores the user analysis values defined for
                 transactions.

    POAOCDTL   - Contains all Add-on costs related to a purchase order.

    POCOMOUT   -

    POCOMPANY  - Used to edit the company number.

    POHDROUT   -

    POINTERFAC - Updated with the purchase order information.

    POLINE     - Detail line updated by program.

    POLINEOUT  -

    PURCHORDER - Primary file maintained by program.

    STPURCHORD - Updated with purchase order release.

    TERMS      - Contains Terms codes used to calculate due date and discount
                 information for an invoice.

    TXCODEMAST - The Tax Code Master file contains tax codes, descriptions, and
                 the tax types that define how the tax code is used.

    TXCOMPANY  - The Tax Company file contains company information, as well as
                 which tax system the company uses.

    TXTAXCODE  - The Tax Code file contains all tax code information used to
                 calculate tax transactions.

    TXTAXTABLE - Contains a tax table that defines a series of up to eight tax
                 codes to be applied to a single transaction and determines how
                 each tax code will affect the taxable amount of a transaction.


Referenced Files

    ACACCTCAT  - Used to validate account categories maintained in the Activity
                 Management system.

    ACACTGRP   - Contains the highest reporting level in the Activity
                 Management system.

    ACACTIVITY - Used to validate the activities maintained in the Activity
                 Management system.

    ACCAL      - Contains calendar information from the Activity Management
                 system.

    ACCALX     - Contains detail calendar information from the Activity
                 Management system.

    AMASSET    - Used to validate the asset numbers maintained in the Asset
                 Management system.

    AMTEMPLATE - Used to validate the asset template numbers maintained in the
                 Asset Management system.

    APACCRCODE - An invoice accrual code is used to link a general ledger
                 invoice accrual account to an invoice.

    APCOMPANY  - Used in a Accounts Payable common routine.

    APCPYVND   - The Vendor Company Codes file contains default codes assigned
                 a vendor or alternate vendor location at the company level.

    APHLDINV   - Used to determine what invoices for a vendor are on hold.

    APPROCLEV  - Contains process levels used to default accounts used for
                 posting transactions, break and subtotal reports, and process
                 payments.

    APVENCLASS - Used in a Accounts Payable common routine.

    APVENGROUP - Used in a Accounts Payable common routine.

    APVENLOC   - Used in a Accounts Payable common routine.

    APVENMAST  - Used in a Accounts Payable common routine.

    BUYCLASS   - Defines valid item major and minor purchasing classes for a
                 buyer.

    BUYER      - Used to edit the buyer code.

    CUCONV     - Used in a Currency conversion common routine.

    CURELAT    - Used in a Lawson currency conversion common routine.

    FOBCODE    - Describes valid ship term codes for a purchase order.

    GLADDRESS  - Contains the name, address, and communication numbers for the
                 company and needed accounting units.

    GLCHART    - Contains chart and system account information in the General
                 Ledger system including retained earnings, undistributed
                 retained earnings, error suspense, and gain/loss account
                 records.

    GLINTCO    - Contains interzone and intercompany relationships.

    GLSYSTEM   - Used in a General Ledger common routine.

    ICCATEGORY - The GL Account Category file is a master file which defines
                 the inventory and offset general ledger accounts used to post
                 inventory transactions.

    ICCOMPANY  - Used to edit the company number.

    ICCOUT     -

    ICLOCATION - Used to edit the ship to location code.

    INSTCTRYCD - This file maintains the Intrastat country codes.

    INSTHEADER - This file contains transaction information for Intrastat
                 records.

    ITEMLOC    - The Item Location file contains the dynamic information for an
                 inventoried item at a stock location.

    ITEMMAST   - Used to get non-stock item description.

    POAOCSPRD  - Used internally to document the add-on cost spread method used
                 when entering or invoicing a purchase order.

    POAPPROVE  - Contains purchase order line item, miscellaneous add-on cost,
                 and line item add-on cost approval information by invoice and
                 purchase order.

    POAUDIT    - Contains a record of all changes to a purchase order that
                 affect the printed purchase order.

    POCOMMENTS - Updated from requisition comments.

    POFRTTERM  - Contains a list of valid purchase order freight terms.

    PORECEIVE  - Used to validate and default purchase order receiving
                 information.

    PORECLINE  - Contains purchase order receiving line item detail and status
                 information.

    POVENDLOC  - Used by the Purchase Order system to validate the vendor
                 location name.

    POVENDOR   - Updated with open purchase order amount.

    REQLINE    - Updated with the purchase order information.

    RQLOC      - Contains the valid requesting locations for the company.

    STCOMMCODE - This is a file of valid standard comment codes used to add
                 comments to purchase orders.

    STPOLINE   - Updated for blanket purchase order.

    SYSTEMCODE - This file contains system code information used for remote
                 site processing.

    TXTAXRATE  - The Tax Rate file stores tax rates in effect for a specific
                 tax code.


RQ20.4 - Model PO Select

Use this form to select requisition lines that have been combined and
assigned to the entered vendor. Use RQ20.2 (Buyer Requisition Review) to
combine and assign requisition lines to a vendor. Use this form to take the
created purchase order (done in RQ20.3 Purchase Order Create) and assign
created PO lines to the order.

After you have completed the purchase order on this form, you must release it
for processing in the Purchase Order system. You can release it on this form
or release it in the Purchase Order system.

Updated Files

    ACCOMMIT   - Contains commitments not yet posted to the general ledger.

    ACCOMMITX  - Contains commitment details not yet posted to the general
                 ledger.

    INSTDETAIL - This file maintains Intrastat distribution line information.

    INSTHEADER - This file contains transaction information for Intrastat
                 records.

    ITEMLOC    - Used to obtain items at a location.

    MMDIST     - This record holds an account number and possibly an activity
                 code intended for a general ledger distribution of an inventory
                 item.

    MMUAVAL    - This file stores the user analysis values defined for
                 transactions.

    POAOCDTL   - Contains all Add-on costs related to a purchase order.

    POAOCSPRD  - Used internally to document the add-on cost spread method used
                 when entering or invoicing a purchase order.

    POCOMMENTS - Used in a Purchase Order common routine.

    POCOMOUT   -

    POHDROUT   -

    POINTERFAC - Primary file maintained by the program.

    POLINE     - Used in a Purchase Order common routine.

    POLINEOUT  -

    POVENDOR   - Used in a Purchase Order common routine.

    PURCHORDER - Used in a Purchase Order common routine.

    REQLINE    - Detail file maintained by the program.

    STPOLINE   - Used in a Purchase Order common routine.

    STPURCHORD - Used in a Purchase Order common routine.

    TERMS      - Contains Terms codes used to calculate due date and discount
                 information for an invoice.

    TXCODEMAST - The Tax Code Master file contains tax codes, descriptions, and
                 the tax types that define how the tax code is used.

    TXCOMPANY  - The Tax Company file contains company information, as well as
                 which tax system the company uses.

    TXTAXCODE  - The Tax Code file contains all tax code information used to
                 calculate tax transactions.

    TXTAXTABLE - Contains a tax table that defines a series of up to eight tax
                 codes to be applied to a single transaction and determines how
                 each tax code will affect the taxable amount of a transaction.

    WHDEMAND   - The Demand file contains all the records that the Warehouse
                 system needs for processing demands.


Referenced Files

    ACACCTCAT  - Used to validate account categories maintained in the Activity
                 Management system.

    ACACTGRP   - Contains the highest reporting level in the Activity
                 Management system.

    ACACTIVITY - Used to validate the activities maintained in the Activity
                 Management system.

    ACCAL      - Contains calendar information from the Activity Management
                 system.

    ACCALX     - Contains detail calendar information from the Activity
                 Management system.

    AMASSET    - Used to validate the asset numbers maintained in the Asset
                 Management system.

    AMTEMPLATE - Used to validate the asset template numbers maintained in the
                 Asset Management system.

    APACCRCODE - Used in a Accounts Payable common routine.

    APCOMPANY  - Used in a Accounts Payable routine.

    APCPYVND   - The Vendor Company Codes file contains default codes assigned
                 a vendor or alternate vendor location at the company level.

    APHLDINV   - Used to determine what invoices for a vendor are on hold.

    APPROCLEV  - Contains process levels used to default accounts used for
                 posting transactions, break and subtotal reports, and process
                 payments.

    APVENCLASS - Used in a Accounts Payable common routine.

    APVENGROUP - Used in a Accounts Payable common routine.

    APVENLOC   - Used in a Accounts Payable common routine.

    APVENMAST  - Used in a Accounts Payable common routine.

    BUYCLASS   - Defines valid item major and minor purchasing classes for a
                 buyer.

    BUYER      - Used in a Purchase Order common routine.

    CUCONV     - Used in a Currency conversion common routine.

    CURELAT    - Used in a Lawson currency conversion common routine.

    FOBCODE    - Describes valid ship term codes for a purchase order.

    GLADDRESS  - Used in a General Ledger common routine.

    GLCHART    - Contains chart and system account information in the General
                 Ledger system including retained earnings, undistributed
                 retained earnings, error suspense, and gain/loss account
                 records.

    GLCODES    - Used in a General Ledger common routine.

    GLINTCO    - Contains interzone and intercompany relationships.

    GLSYSTEM   - Used in a General Ledger common routine.

    ICBIN      - Used to validate a bin number.

    ICCATEGORY - Used to extract account information.

    ICCOMPANY  - Used to validate the company number.

    ICCOUT     -

    ICLOCATION - Used to validate the location name.

    INSTCTRYCD - This file maintains the Intrastat country codes.

    ITEMMAST   - Used to validate the item number.

    POAOCSPRD  - Used internally to document the add-on cost spread method used
                 when entering or invoicing a purchase order.

    POAPPROVE  - Contains purchase order line item, miscellaneous add-on cost,
                 and line item add-on cost approval information by invoice and
                 purchase order.

    POAUDIT    - Contains a record of all changes to a purchase order that
                 affect the printed purchase order.

    POCOMPANY  - Contains valid Purchase Order companies and corresponding
                 parameters.

    POFRTTERM  - Contains a list of valid purchase order freight terms.

    POITEMVEN  - Used in a Purchase Order common routine.

    POLOCCON   - Contains a list of valid override contracts for a location.

    POQUOTES   - Used in a Purchase Order common routine.

    PORECEIVE  - Used to validate and default purchase order receiving
                 information.

    PORECLINE  - Used in a Purchase Order common routine.

    POVENDLOC  - Used in a Purchase Order common routine.

    REQHEADER  - Used to validate the requisition number.

    RQCOMMENTS - Used to display a "comments exist" message on the screen.

    RQLOC      - Contains the valid requesting locations for the company.

    STCOMMCODE - Used in a Purchase Order common routine.

    SYSTEMCODE - This file contains system code information used for remote
                 site processing.

    TXTAXRATE  - The Tax Rate file stores tax rates in effect for a specific
                 tax code.


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS