Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQLOC


                               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     AP25.1    AP25.2    AP26.1
AP27.1    AP30.4    API1.1    BL120     BL122     BL130
BL20.1    BL20.3    BL21.2    BL21.5    BL29.1    BL29.2
BL520     BL820     BL92.1    CXCP.1    DR100     IC140
IC141     IC142     IC182     IC21.1    IC21.2    IC243
IC244     IC28.1    IC282     IC283     IC33.1    IC45.1
IC500     IC520     IC527     IC531     IC83.1    MA180
MA530     MA531     MA60.2    MA60.3    MA60.5    MA61.1
MA66.2    MA66.3    MA67.1    MA67.2    MA70.1    MA75.1
MA80.1    MAI1.1    OE10.1    OE10.2    OE10.3    OE10.4
OE10.5    OE10.6    OE10.7    OE10.8    OE11.1    OE11.4
OE11.8    OE11.9    OE110     OE111     OE113     OE114
OE116     OE129     OE13.2    OE13.3    OE13.5    OE13.6
OE14.4    OE30.1    OE30.2    OE30.3    OE30.4    OE30.5
OE30.6    OE30.7    OE30.9    OE510     OE530     OE81.1
OE810     OE830     OE90.1    OE90.2    PO04.3    PO100
PO101     PO115     PO122     PO131     PO134     PO15.1
PO15.2    PO20.1    PO204     PO21.1    PO21.2    PO21.3
PO21.4    PO21.5    PO22.1    PO223     PO23.1    PO25.3
PO25.7    PO254     PO258     PO27.2    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    PO58.1    PO58.2    POCP.1    POI3.1
POI7.1    POID.1    POIE.1    POII.1    POIJ.1    MM280
RQ04.1    RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ111
RQ12.1    RQ13.1    RQ13.2    RQ140     RQ201     RQ230
RQ235     RQ240     RQ300     RQ35.1    RQ39.1    RQ39.2
RQ39.3    RQ40.1    RQ41.1    RQ42.1    RQ44.1    RQ44.2
RQ500     RQIA.1    RQIB.1    RQIC.1    RQID.1    RQIF.1
RQIG.1    RQII.1    RQIJ.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     WO132     WO140

UPDATED BY

IC81.1    IC840     RQ01.1    RQ810

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RQL-COMPANY            Numeric 4                                 IC81.1  IC840
Element: Buyer         Identifies the AP company if the          RQ01.1  RQ810
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

RQL-REQ-LOCATION       Alpha 5                                   IC81.1  IC840
Element: 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
Element: Name          The requesting location name or           RQ01.1  RQ810
                       description.

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

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

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

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

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

RQL-STATE-PROV         Alpha 2                                   RQ01.1  RQ810
Element: State or ProviThe state or province.

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

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

RQL-COUNTRY-CODE       Alpha 2                                   RQ01.1  RQ810
Element: 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
Element: Country or OthThis 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
Element: Accounting UniThis is the default accounting unit for   RQ01.1  RQ810
                       issues.

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

RQL-ISS-SUB-ACCT       Numeric 4                                 IC81.1  IC840
Element: Subaccount    This is the default sub account number    RQ01.1  RQ810
                       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 that will be
                       created when the line is picked.
                       IS = Issues
                       DT = Direct Transfer
                       IT = Intransit Transfer

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

RQL-FROM-LOCATION      Alpha 5                                   IC81.1  IC840
Element: Location Code 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
Element: 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  RQ810
Element: 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  RQ810
Element: 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
Element: Fill Or Kill  F = Fill Backorders                       RQ810
                       K = Kill Backorders

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

RQL-STOCKLESS-FL       Alpha 1                                   RQ01.1  RQ810
Element: All Flag

RQL-ACTIVITY           Alpha 15                                  RQ01.1  RQ810
Element: 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  RQ810
Element: Account CategoAccount 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.

                       Valid account category types are:
                       cost
                       revenue
                       accrual
                       pass thru

RQL-BILL-CATEGORY      Alpha 32                                  RQ01.1
Element: Bill Category

RQL-APPROVAL-TYPE      Alpha 1                                   RQ01.1
Element: Approval Type The type of approval record.
                       " " = Use from IC Company
                       0 = Header approval-Approval codes
                       1 = Header approval-Process Flow
                       2 = Line approval
                       3 = No approval required

RQL-ACTIVE-STATUS      Alpha 1
Element: Status        The status of the account. If Inactive,
                       no posting can be done to the account.

                       A = Active
                       I = Inactive

                         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   AP25.1
                                                                 AP25.2  AP26.1
                                                                 AP27.1  AP30.4
                                                                 API1.1  BL120
                                                                 BL122   BL130
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  CXCP.1
                                                                 DR100   IC140
                                                                 IC141   IC142
                                                                 IC182   IC21.1
                                                                 IC21.2  IC243
                                                                 ...

                         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