Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                               RQLOC FILE

                          Requesting Locations

This file contains the valid requesting locations for the company. If the
transaction type is an Issue, the requesting location does not have to be a
valid inventory stock location. It can be a user defined entity, such as a
department, cost center, or machine. If the transaction type is a T (Direct
Transfer) or X (Intransit Transfer), the requesting location has to be a
defined as a location in Inventory Control.

REFERENCED BY

AP125     AP126     AP131     AP20.1    AP20.2    AP20.3
AP20.4    AP20.5    AP20.7    AP23.1    AP25.1    AP25.2
AP26.1    AP27.1    API1.1    CXCP.1    DR100     IC140
IC141     IC142     IC182     IC21.1    IC21.2    IC243
IC28.1    IC283     IC500     IC520     IC527     IC531
IC83.1    MA180     MA41.2    MA43.2    MA43.9    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA66.3
MA67.1    MA67.2    MA70.1    MAI1.1    PO04.3    PO100
PO101     PO122     PO131     PO134     PO15.1    PO15.2
PO20.1    PO204     PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO23.1    PO25.4    PO25.8    PO254     PO29.1
PO30.1    PO30.2    PO30.3    PO300     PO31.1    PO31.2
PO32.2    PO33.1    PO34.1    PO35.1    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     PO54.1
PO54.2    PO54.3    PO54.4    POCP.1    POI3.1    POI7.1
POIE.1    POII.1    POIJ.1    RQ04.1    RQ10.1    RQ10.2
RQ10.3    RQ11.1    RQ111     RQ12.1    RQ13.1    RQ140
RQ201     RQ230     RQ235     RQ300     RQ35.1    RQ39.1
RQ39.2    RQ39.3    RQ40.1    RQ41.1    RQ42.1    RQ44.1
RQ44.2    RQ500     RQIA.1    RQIB.1    RQID.1    RQIF.1
SEA2.1    WH130     WH132     WH190     WH20.2    WH20.7
WH222     WH25.1    WH25.2    WH30.1    WH30.2    WH30.3
WH30.4    WH31.1    WH31.2    WH31.3    WH31.4    WH32.1
WH32.2    WH32.3    WH32.4    WH33.1    WH33.2    WH33.3
WH33.4    WH33.5    WH33.6    WH33.8    WH33.9    WH34.1
WH34.2    WH34.3    WH34.4    WH40.1    WH40.2    WH520
WH830

UPDATED BY

IC81.1    IC840     RQ01.1    RQ810

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RQL-COMPANY          Numeric 4                                   IC81.1  IC840
Buyer                The company number represents an            RQ01.1  RQ810
                     established company and is entered on
                     all function codes.


RQL-REQ-LOCATION     Alpha 5                                     IC81.1  IC840
To Location          The location requisitioning items.          RQ01.1  RQ810
                     This location can be an inventory or
                     noninventory location.

RQL-NAME             Alpha 30  (Lower Case)                      IC81.1  IC840
Name                 The requesting location name or             RQ01.1  RQ810
                     description.

RQL-ADDR1            Alpha 30  (Lower Case)                      RQ01.1  RQ810
Address 1            This field contains the first line of
                     address information.

RQL-ADDR2            Alpha 30  (Lower Case)                      RQ01.1  RQ810
Address 2            This field contains the second line of
                     address information.

RQL-ADDR3            Alpha 30  (Lower Case)                      RQ01.1  RQ810
Address 3            This field contains the third line of
                     address information.

RQL-ADDR4            Alpha 30  (Lower Case)                      RQ01.1  RQ810
Address 4            This field contains the fourth line of
                     address information.

RQL-CITY-ADDR5       Alpha 18  (Lower Case)                      RQ01.1  RQ810
City or Address 5    The city or address line five.

RQL-STATE-PROV       Alpha 2                                     RQ01.1  RQ810
State or Province    The state or province.

RQL-COUNTY           Alpha 25  (Lower Case)                      RQ01.1
County               The county for the company address.

RQL-POSTAL-CODE      Alpha 10  (Lower Case)                      RQ01.1  RQ810
Postal Code          This field contains the postal code.

RQL-COUNTRY-CODE     Alpha 2                                     RQ01.1  RQ810
Country Code         The country code.  Required for VAT and
                     intrastat reporting.  Must be defined in
                      IN01.1 (Country Maintenance).


RQL-COUNTRY          Alpha 30  (Lower Case)                      RQ01.1  RQ810
Country or Other     This field contains the country of the
                     address, or it can be used for
                     additional information such as an
                     attention name.

RQL-ISS-ACCT-UNIT    Alpha 15                                    IC81.1  IC840
Issues Offset        This is the default accounting unit for     RQ01.1  RQ810
Accounting Unit      issues.

RQL-ISS-ACCOUNT      Numeric 6                                   IC81.1  IC840
Issues Offset        This is the default account number for      RQ01.1  RQ810
Account Number       issues.

RQL-ISS-SUB-ACCT     Numeric 4                                   IC81.1  IC840
Issues Offset        This is the default sub account number      RQ01.1  RQ810
Subaccount           for issues.

RQL-IC-TRANS-TYPE    Alpha 2                                     IC81.1  IC840
Inventory            This code indicates the type of             RQ01.1  RQ810
Transaction Type     inventory transaction created when the
                     line is picked in WH30 (Picking
                     Feedback).
                     IS = Issues
                     DT = Direct Transfer
                     IT = Intransit Transfer

RQL-BUYER-CODE       Alpha 3                                     RQ01.1  RQ810
Buyer Code           The user defined buyer identifier.

RQL-FROM-LOCATION    Alpha 5                                     IC81.1  IC840
From Location        This is the inventory location that         RQ01.1  RQ810
                     supplies the items or it is the purchase
                     order ship to location that receives the
                     items. When entered here, it is the
                     default from location on the
                     requisition.

RQL-FROM-COMPANY     Numeric 4                                   IC81.1  IC840
From Company         This is the company that is the source      RQ01.1  RQ810
                     of the items. When entered here, it is
                     the default company on the requisition.

RQL-PO-CODE          Alpha 4                                     RQ01.1
Po Code              This is the purchase order code that
                     will default from a requesting location
                     to a purchase order.

RQL-PROCESS-LEVEL    Alpha 5                                     RQ01.1
Process Level        This field contains the process level,
                     which is the reporting hierarchy below
                     company.


RQL-FILL-OR-KILL     Alpha 1                                     IC81.1  RQ01.1
Fill Or Kill         F = Fill Backorders
                     K = Kill Backorders

RQL-FIELD-ENTRY      Alpha 1
Field Entry          1 = Item Number
                     2 = NDC

RQL-STOCKLESS-FL     Alpha 1                                     RQ01.1
Stockless Fl

RQL-ACTIVITY         Alpha 15                                    RQ01.1
Activity             Activities are the processes or
                     procedures that produce work. Cost
                     objects (products, services, customers,
                     and so on) are the reasons for
                     performing the activity.



RQL-ACCT-CATEGORY    Alpha 5                                     RQ01.1
Account Category     Account categories are groupings of
                     costs, revenues, or a combination of
                     both used for reporting and inquiries
                     for activities in the Activity
                     Management system. All transactions are
                     posted to an account category within an
                     activity. You can assign a specific
                     General Ledger account or range of
                     accounts (company, accounting unit,
                     account, and subaccount) that make up
                     the transactions posted to an account
                     category using AC07.1 (Account
                     Assignment).

                     Period-to-date, year-to-date, and
                     life-to-date balances are maintained by
                     account category for activities. Account
                     categories must be assigned to
                     activities before you do any budgeting
                     or transaction processing.



                         RQLOC FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RQLSET1   COMPANY       This index is used to access a           AP125   AP126
          REQ-LOCATION  requesting location record.              AP131   AP20.1
                                                                 AP20.2  AP20.3
                                                                 AP20.4  AP20.5
                                                                 AP20.7  AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 API1.1  CXCP.1
                                                                 DR100   IC140
                                                                 IC141   IC142
                                                                 IC182   IC21.1
                                                                 IC21.2  IC243
                                                                 IC28.1  IC283
                                                                 IC500   IC520
                                                                 IC527   IC531
                                                                 ...

                         RQLOC FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Buyer          BUYER        Not Required

                            PCG-PROCURE-GROUP    -> BUY-PROCURE-GROUP
                            RQL-BUYER-CODE       -> BUY-BUYER-CODE

From Location  ICLOCATION   Not Required
                            Valid When RQL-FROM-LOCATION != "SPACE"

                            RQL-COMPANY          -> ICL-COMPANY
                            RQL-FROM-LOCATION    -> ICL-LOCATION

Ic Company     ICCOMPANY    Required

                            RQL-COMPANY          -> ICC-COMPANY

Ic Location    ICLOCATION   Required
                            When RQL-IC-TRANS-TYPE = "T"
                            Or   RQL-IC-TRANS-TYPE = "X"

                            RQL-COMPANY          -> ICL-COMPANY
                            RQL-REQ-LOCATION     -> ICL-LOCATION

Procuregrp     PROCUREGRP   Required

                            ICC-ITEM-GROUP       -> PCG-ITEM-GROUP

                         RQLOC FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Templates      RQTEMP

                            RQL-COMPANY          -> RQM-COMPANY
                            RQL-REQ-LOCATION     -> RQM-REQ-LOCATION
                            Spaces               -> RQM-REQUESTER
                                                    RQM-TEMPLATE-ID