RQLOC – Requesting Locations

System
Requisitions (RQ)
Prefix
RQL
Primary key
COMPANY, REQ-LOCATION
Fields
36
Updated by
16 programs
Referenced by
315 programs

RQLOC is the Requesting Locations table in Lawson Requisitions (prefix RQL). It is indexed by COMPANY, REQ-LOCATION (RQLSET1); alternate indexes: RQLSET2. It is related 1:1 to BUYER, ICCOMPANY, ICLOCATION, GLNLOC, GLNLOCDTL and PROCUREGRP and 1:M to RQRQLAUDIT. It is updated by AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 and 8 more and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 307 more. The table has 36 fields, 2 indexes and 9 documented relations.

About RQLOC

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.

Fields (36)

Column = COBOL field name without the RQL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RQL-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-REQ-LOCATION PK
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-NAME
NAME		Alpha 30 (Lower Case)The requesting location name or description.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ADDR1
ADDR1		Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ADDR2
ADDR2		Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ADDR3
ADDR3		Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ADDR4
ADDR4		Alpha 30 (Lower Case)This field contains the first line of address information.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-CITY-ADDR5
CITY_ADDR5		Alpha 18 (Lower Case)This field contains the city of the address.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-STATE-PROV
STATE_PROV		Alpha 2The state or province.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-COUNTY
COUNTY		Alpha 25 (Lower Case)The county for the company address.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-POSTAL-CODE
POSTAL_CODE		Alpha 10 (Lower Case)This field contains the postal code.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-COUNTRY-CODE
COUNTRY_CODE		Alpha 2The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-COUNTRY
COUNTRY		Alpha 30 (Lower Case)This field contains the country of the address, or it can be used for additional information such as an attention name.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ISS-ACCT-UNIT
ISS_ACCT_UNIT		Alpha 15The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ISS-ACCOUNT
ISS_ACCOUNT		Numeric 6This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ISS-SUB-ACCT
ISS_SUB_ACCT		Numeric 4This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-IC-TRANS-TYPE
IC_TRANS_TYPE		Alpha 2This code indicates the type of inventory transaction that will be created when the line is picked.
  • IS Issues
  • DT Direct Transfer
  • IT Intransit Transfer
AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-BUYER-CODE
BUYER_CODE		Alpha 3—AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-FROM-LOCATION
FROM_LOCATION		Alpha 5This is the inventory location that 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.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-FROM-COMPANY
FROM_COMPANY		Numeric 4This is the company that is the source of the items. When entered here, it is the default company on the requisition.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-PO-CODE
PO_CODE		Alpha 4This is the purchase order code that will default from a requesting location to a purchase order.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-FILL-OR-KILL
FILL_OR_KILL		Alpha 1—
  • F Fill Backorders
  • K Kill Backorders
AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-STOCKLESS-FL
STOCKLESS_FL		Alpha 1—AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ACTIVITY
ACTIVITY		Alpha 15Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ACCT-CATEGORY
ACCT_CATEGORY		Alpha 5Account 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 thruAP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-BILL-CATEGORY
BILL_CATEGORY		Alpha 32—AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-APPROVAL-TYPE
APPROVAL_TYPE		Alpha 1The 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
AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-ACTIVE-STATUS
ACTIVE_STATUS		Alpha 1The status of the account. If Inactive, no posting can be done to the account.
  • A Active
  • I Inactive
AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-RQL-OBJ-ID SET2
RQL_OBJ_ID		Numeric 12This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +8 more
#RQL-ONE-SRC-ONE-PO
ONE_SRC_ONE_PO		Numeric 1—
  • 0 No
  • 1 One Requisition to One PO
AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-PCARD-NBR
PCARD_NBR		Alpha 16——
#RQL-GLN-NBR
GLN_NBR		Alpha 13—AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-LOCATION-RULE
LOCATION_RULE		Alpha 12—AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-PURCH-TAX-CD
PURCH_TAX_CD		Alpha 10—AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more
#RQL-PURCH-TAX-FL
PURCH_TAX_FL		Alpha 1—AP510, IC64.1, IC64.2, IC64.3, IC64.4, IC64.5, IC64.6, IC64.7 +6 more

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RQLSET1
  1. COMPANY
  2. REQ-LOCATION
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RQLSET2
  1. RQL-OBJ-ID
KeyChange, SubsetWhere RQL-OBJ-ID != ZeroesIC243, MX223, MX500, PO100, PO23.1, RQ01.4, RQ01.5, RQ111 +7 more

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
BUYERICCOMPANYICLOCATIONGLNLOCGLNLOCDTLPROCUREGRPRQRQLAUDITRQLOC

One to one (8) — lookups and parents

RelationTableRulesConditionField map
BuyerBUYERNot Required
PCG-PROCURE-GROUP→BUY-PROCURE-GROUP
RQL-BUYER-CODE→BUY-BUYER-CODE
From CompanyICCOMPANYRequired
RQL-FROM-COMPANY→ICC-COMPANY
From LocationICLOCATIONNot RequiredValid When RQL-FROM-LOCATION != Spaces
RQL-COMPANY→ICL-COMPANY
RQL-FROM-LOCATION→ICL-LOCATION
GlnlocGLNLOCNot RequiredValid When RQL-GLN-NBR != Spaces
PCG-ITEM-GROUP→GLO-ITEM-GROUP
RQL-GLN-NBR→GLO-GLN-NBR
GlnlocdtlGLNLOCDTLNot RequiredValid When RQL-GLN-NBR != Spaces
ICC-ITEM-GROUP→GLX-ITEM-GROUP
4→GLX-GLN-TYPE
RQL-COMPANY→GLX-COMPANY
RQL-REQ-LOCATION→GLX-LOCATION
Spaces→GLX-BIN
RQL-GLN-NBR→GLX-GLN-NBR
Ic CompanyICCOMPANYRequired
RQL-COMPANY→ICC-COMPANY
Ic LocationICLOCATIONNot Required
RQL-COMPANY→ICL-COMPANY
RQL-REQ-LOCATION→ICL-LOCATION
ProcuregrpPROCUREGRPRequired
ICC-ITEM-GROUP→PCG-ITEM-GROUP

One to many (1) — child tables

RelationTableRulesConditionField map
RqrqlauditRQRQLAUDIT
RQL-COMPANY→RLA-COMPANY
RQL-REQ-LOCATION→RLA-REQ-LOCATION
—→RLA-DATE
—→RLA-TIME
—→RLA-FLD-NBR

Programs

Updated by (16)

Referenced by (315)