Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQ10


RQ10.1 - Requisition

**Form Purpose
Use Requisition (RQ10.1) to manually create requests for any item type:
Inventory, nonstock, special order (X), or service.




Updated Files

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

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

    ADDRDATA   -

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

    COLINE     -

    COSGBLK    -

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    ICCOMPANY  - Used to edit the company number.

    ICHISTORY  -

    ICLOCATION - Used to edit the delivering location.

    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.

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    - Updated with item location information.

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

    MAPOOLCNT  -

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

    MMUAVAL    -

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  - Contains valid Purchase Order companies and corresponding
                 parameters.

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     - Used by the Purchase Order system to extract the unit cost of
                 an item.

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  - Used to validate and default buyer message information.

    POPCRUF    -

    POPLIUF    -

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

    PORECLINE  - Used to obtain receiving line information.

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    PORLNUF    -

    PORQHUF    -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

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

    PURCHORDER - Used in a Purchase Order common routine.

    RECAOCDTL  -

    REQHEADER  - Primary file maintained by program.

    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.

    RQTRANS    -

    SOHDETAIL  - Used to extract stock on hand detail information.

    TERMS      -

    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.

    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.

    ACCATSUMX  -

    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.

    APAPIHIST  -

    APCOMPANY  - Used in a Accounts Payable common routine.

    APDISTCODE -

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

    APINVOICE  - Used to obtain invoice information.

    APPAYMENT  - Used to create and maintain an invoice payment record.

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP - Used in a Accounts Payable common routine.

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      - Used to validate the buyer codes.

    BUYVENPF   -

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

    CUCONV     - Maintains rate tables for each defined currency relationship.

    CURELAT    - Used in a Lawson Currency common routine.

    CUSTDESC   -

    CUSTORDER  -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    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.

    GLNAMES    - Used to verify the existence of the accounting unit. Used in a
                 General Ledger common routine.

    GLSYSTEM   - Used in a General Ledger common routine.

    HCCHRGITEM -

    ICBIN      - Used to validate a bin number.

    ICCATEGORY - Used for defaults of general ledger account.

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICUSRFLDEF -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

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

    ITEMMAST   - Used to edit the item number.

    ITEMSRC    -

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

    KWDSETUP   -

    MAAOCDTL   -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAJORCL    - Contains the major class codes which are entered on Item
                 Master records.

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    MINORCL    - A detail file for the Major Class file.

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    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.

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  - Used in a Purchase Order common routine when defaulting unit
                 cost.

    PORECADJHD -

    PORECADJLN -

    POUSRFLDEF -

    POVENDLOC  -

    PROCTEMP   -

    PROCTEMPLN -

    PROCTMPPAR -

    PROCUREGRP -

    REASON     -

    REQUESTER  - Used to edit the requester and extract the defaults.

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

    RQAPPCODE  - Used to determine the approval levels.

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

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

    SLSEGMENT  -

    SLSEGVALUE -

    STATICCUST -

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

    SYSTEMCODE -

    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.

    WHSHIPLINE -

    WHSHLAUD   -


RQ10.2 - Account Distribution

**Form Purpose
Use Account Distribution (RQ10.2) to enter account distribution information
for nonstock, special order, and service items. You can

- Distribute the cost of a nonstock, special order, or service item to
multiple expense accounts. You can distribute by percentage or quantity.
However, the total distributions must equal either 10012r the total item
quantity.

- Assign an asset code, asset template, or activity to the line.




Updated Files

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

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

    ADDRDATA   -

    COCOMP     -

    COLINE     -

    COSGBLK    -

    CXCOMPANY  -

    CXCPIUAVAL -

    CXITEMHIST -

    CXPREFITEM -

    GLCOMMIT   -

    GLCOMMITX  -

    HCPATCHRG  -

    HCPATVISIT -

    ICCOMPANY  - Used to edit the company number.

    ICHISTORY  -

    ICLOCATION - Used to edit the delivering location.

    ICLOT      -

    ICRECEIPTS -

    ICTRANS    -

    ICTRANSDTL -

    INSTDETAIL -

    INSTHEADER -

    INSTNBR    -

    ITEMLOC    - Updated with item location information.

    ITSERIAL   -

    MAPOOLCNT  -

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

    MMUAVAL    -

    POAGMTPRIC -

    POAOCDTL   -

    POAOCMAST  -

    POAOCSPRD  -

    POAUDIT    -

    POCODE     -

    POCOMPANY  - Used to validate a Purchase Order company.

    POHDROUT   -

    POHDRPVT   -

    POINTAOC   -

    POINTERFAC -

    POLINE     - Used by the Purchase Order system to extract the unit cost of
                 an item.

    POLINEOUT  -

    POLINEPVT  -

    POLINESRC  -

    POMESSAGE  - Used to validate and default buyer message information.

    POPCRUF    -

    POPLIUF    -

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

    PORECLINE  - Used to obtain receiving line information.

    PORETURNHD -

    PORETURNLN -

    POREVISION -

    POTRACK    -

    POTRANSDTL -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDOR   -

    PURCHORDER - Used in a Purchase Order common routine.

    RECAOCDTL  -

    REQLINE    - Detail file maintained by program.

    ROUTEDOC   -

    ROUTEHDR   -

    ROUTESTOP  -

    RQTRANS    -

    SOHDETAIL  - Used to extract SOH detail information.

    TERMS      -

    TXCODEMAST -

    TXCOMPANY  -

    TXTAXCODE  -

    TXTAXTABLE -

    WHDEMAND   -

    WHDEMNDHDR -


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.

    ACCATSUMX  -

    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 -

    APAPIHIST  -

    APCOMPANY  - Used in a Accounts Payable common routine.

    APDISTCODE - Contains distribution codes used to automatically create
                 expense distributions or expense distribution "shells" for
                 invoices or to split invoice distributions into multiple
                 distribution lines.

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

    APINVOICE  - Used to obtain invoice information.

    APPAYMENT  - Used to create and maintain an invoice payment record.

    APPROCLEV  -

    APUAVAL    -

    APVENADDR  -

    APVENGROUP - Used in a Lawson Accounts Payable common routine.

    ARCOMP     -

    ARCUSTOMER -

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      - Used to edit the buyer code.

    BUYVENPF   -

    COMPONENT  -

    CUCONV     - Maintains rate tables for each defined currency relationship.

    CURELAT    - Used in a Lawson Currency common routine.

    CUSTDESC   -

    CUSTORDER  -

    CXBURDEN   -

    CXCASEPREF -

    CXPTMPITEM -

    EEADVANCE  -

    EEEXPENSE  -

    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.

    GLNAMES    - Used in a Lawson general ledger common routine.

    GLSYSTEM   - Used in a General Ledger common routine.

    HCCHRGITEM -

    ICBIN      - Used to validate a bin number.

    ICCATEGORY - Used to default general ledger account information.

    ICCOUT     -

    ICFACILITY -

    ICMFGCODE  -

    ICMFGDIST  -

    ICVALUOM   -

    INSTATPROC -

    INSTCMDTY  -

    INSTCTRYCD -

    INSTNOTC   -

    INSTPORTS  -

    INSTREGN   -

    ITEMGROUP  -

    ITEMMAST   - Used to edit the item number.

    KITITEM    -

    MAAOCDTL   -

    MACOMPANY  -

    MAELMGPREL -

    MAELMVALUE -

    MAINVDTL   -

    MAMATCHTBL -

    MAMTCHELEM -

    MAMTCHRULE -

    MAPOINV    -

    MAREASONCD -

    MATCHCLASS -

    MFGSHPFAC  -

    NATACCT    -

    NATBALANCE -

    OECOMPANY  -

    OECUST     -

    OEFRTCODE  -

    OEROUTE    -

    ORDERTYPE  -

    POAGMTPART -

    POAUDRULES -

    POAUDTYPE  -

    PODOCREF   -

    POITEMVEN  - Used in a Lawson PO common routine for unit cost information.

    PORECADJHD -

    PORECADJLN -

    POVENDLOC  -

    PROCTEMPLN -

    PROCUREGRP -

    REASON     -

    REQHEADER  - Primary file maintained by program.

    REQUESTER  - Used to edit the requester and extract defaults.

    RQACCTU    -

    RQLOC      - Used to edit the requesting location and extract the defaults.

    STATICCUST -

    STCOMMCODE - Used to edit the comment codes.

    SYSTEMCODE -

    TXTAXRATE  -

    WFSETUP    -

    WHPROCTYPE -

    WHSHLAUD   -


RQ10.3 - Select and Copy

**Form Purpose
Use Select and Copy (RQ10.3) to select and copy lines from an existing
requisition, template, or standard order.




Updated Files

    ADDRDATA   -

    ICCOMPANY  - Used to edit the company number.

    ICLOCATION - Used to edit the location codes.

    ITEMLOC    - Allocated, backordered, and on order quantities are updated.

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

    MMUAVAL    -

    POCODE     -

    PORLNUF    -

    PORQHUF    -

    REQHEADER  - Primary file maintained by program.

    REQLINE    - Detail file maintained by program.

    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  - Used to validate Tax Code.

    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

    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.

    APDISTCODE -

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

    BUYCLASS   -

    BUYCMPLOC  -

    BUYER      - Used to validate the buyer codes.

    BUYVENPF   -

    CUCONV     - Maintains rate tables for each defined currency relationship.

    CURELAT    - Used in a Lawson Currency common routine.

    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    - Used in a General Ledger common routine.

    GLSYSTEM   - Used in a General Ledger common routine.

    ICBIN      - Used to validate a bin number.

    ICCATEGORY - Used for default of general ledger account information.

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

    ICUSRFLDEF -

    ICVALUOM   -

    INSTCTRYCD -

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

    ITEMMAST   - Used to edit the item number.

    ITEMSRC    -

    KWDSETUP   -

    MACOMPANY  -

    MAJORCL    -

    MAMTCHELEM -

    MATCHCLASS -

    MINORCL    -

    POAGMTPART -

    POCOMPANY  - Contains valid Purchase Order companies and corresponding
                 parameters.

    POITEMVEN  - Used in a Purchase Order common routine in defaulting unit
                 cost information.

    POUSRFLDEF -

    POVAGRMTHD -

    POVAGRMTLN -

    POVENDLOC  -

    POVENDOR   - Used in a Purchase Order common routine.

    PROCTEMPLN -

    PROCUREGRP -

    REQUESTER  - Used to edit the requester and extract the defaults.

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

    RQAPPCODE  - Used to edit approval code.

    RQLOC      - Used to edit the requesting location and extract the defaults.

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

    SLSEGMENT  -

    SLSEGVALUE -

    STCOMMCODE - Used to validate standard comment codes.

    TXTAXRATE  - Used to obtain tax rate information.


INVOKED Programs

    ACAC
    ACCL
    ACTA
    API4
    IFAC
    IFAU
    IFCU
    IFOB
    IFSG
    SLSE
    SLSU
    IFLU
    ACSB
    API3
    ICCP
    ICI1
    ICI8
    IFRS
    IFSC
    POCP
    POIF
    POIH
    POI6
    POI4
    POI7
    POI9
    POIA
    POIL
    POIX
    POIG
    POII
    POIJ
    POI1
    POIM
    RQCP
    SLSS
    SLUA
    SLSR