RQ500 - Requisition Interface

Run this program to load requisitions from a non-Lawson system into the
Requisition system. The loaded requisitions must pass through all the required
requisition edits. If an inventory item is not available in the requested
quantity,  the  system determines whether a replacement can be made. If the
item is not  available in the requested quantity and there is a replacement
item for the  original item, the system makes a replacement. In addition, if
needed, the system places any  remaining quantities on backorder for the
replacement item. No messages  display to indicate replacements,
substitutions, or backorders.

The program prints the requester and requisition number for requisitions that
processed successfully. Additional header or line detail is printed for
requisitions with exceptions. Drill around capabilities are provided for you
to view additional requisition detail from the report.

Run this program in report mode or in update mode.  Report mode lets you
review and correct exceptions before updating the database. When you run in
update mode, the input file is deleted when processing is complete.

Any  records with exceptions are written to an error file named
RQ500MTDYHRMNSC. In this file name, MT is the month, DY is the day, HR is the
hour, MN is the  minute, and SC is the second when the program started. You
may correct the exceptions, either in the database or in the input file, and
rerun the program for the input file.

You can run RQ500 (Requisition Interface) to process files uploaded by the
handheld terminal and routed to RQ500 by IC588 (Handheld Processing). To
process handheld terminal transactions, you must set up RQ500 jobs and
parameters according to the requirements for handheld processing. For details
on preparing RQ500 for handheld processing, see the Procurement Management
Technical Guide.

For instructions on error processing for requisition interface records, see
the Requisitions Procedures Manual.

For abnormal terminations (jobs needing recovery), such as might occur from a
hard drive head crash, the system creates an error print file. However, jobs
that need recovery are not available in Print Manager. The abnormally
terminated job resides in the normal Lawson print directory,
($LAWDIR/print/user/jobname/jobstep), and can be viewed with the lashow
command. To recover, you rerun the job. The interface program automatically
appends the output from the recovery run to the output  from the original run.
In the  print file, a  page break separates the recovery run from the original
output. Date and time stamps on the page headers also indicate whether the
page is from the  original or recovery run.

For instructions on handling abnormal terminations, see the Requisitions
Procedures Manual.

If you create released (not zip-released) requisitions, note the following
Enterprise Workflow services.

If the Enterprise Workflow Requisition Approval service is enabled, you can
send a requisition approval request when you release the requisition. The
Enterprise Workflow Requisition Approval service sends the request in the form
of an E-mail or work object. For more information, see the Requisitions
Procedures Manual.

If the Enterprise Workflow Rush Item service is enabled, you can send a rush
item request in the form of an E-mail or work object when you release the
requisition. For more  information, see the Requisitions Procedures Manual.

Note: If you are using the '@k' process type, this program does an
availability edit and creates a requisition line for what you have available.
The process of filling requisition lines and cancelling any remaining
quantities is not available for make-to-order kit items.

Updated Files

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

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

    CKPOINT    - Used in the event of a program or system failure to enable a
                 batch update program to continue from where it left off.

    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 identifier.

    ICLOCATION - Used to validate the inventory 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.

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

    ITEMLOC    - Updated with item location information.

    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    -

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

    PURCHORDER - Used in a Purchase Order common routine.

    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.

    RQCOMMENTS - Updated when comments are added to a requisition.

    SOHDETAIL  - Used to extract stock on hand detail information.

    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 - 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.

    APVENCLASS - Used in a Accounts Payable common routine.

    APVENGROUP - Used in a Accounts Payable common routine.

    APVENLOC   - Used to validate the vendor purchase from locations.

    APVENMAST  - Used in a Accounts Payable common routine.

    BUYER      - Used to validate the buyer codes.

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

    CUACCT     - Used to access General Ledger currency gain/loss accounts.

    CUCONV     - Maintains rate tables for each defined currency relationship.

    CURELAT    - Used in a Lawson Currency common routine.

    CUTABLE    - Used to validate the currency table.

    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 for defaults of general ledger account.

    ITEMMAST   - Used to edit the item number.

    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.

    POCOMMENTS - Contains all purchase order comments associated with both
                 actual and standard purchase orders.

    POCOMPANY  - Contains valid Purchase Order companies and corresponding
                 parameters.

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

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

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

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

    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 the approval code.

    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.

    RQTEMPLINE - Contains the items on a requisition template.

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

    STCOMMENTS - Used to extract standard comment lines.

    STPOLINE   - Used in a Purchase Order common routine.

    STPURCHORD - Used in a Purchase Order common routine.

    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.


INVOKED Programs

    ACAC
    IFCR
    IFSG
    IFCU
    IFAC
    IFAU
    SLSE
    SLSU
    IFCC
    IFOB
    IFRS