RQACCTU – Requesters Accounting Units

System: Requisitions (RQ)
Prefix: RQU
Primary key: COMPANY, REQUESTER, ACCT-UNIT, DIST-COMPANY
Fields: 4
Updated by: 1 program
Referenced by: 21 programs

RQACCTU is the Requesters Accounting Units table in Lawson Requisitions (prefix RQU). It is indexed by COMPANY, REQUESTER, ACCT-UNIT, DIST-COMPANY (RQUSET1). It is related 1:1 to GLNAMES and 1:M to RQREQAUDIT. It is updated by RQ04.1 and referenced by DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.2, RQ10.3, RQ10.4 and 13 more. The table has 4 fields, 1 index and 2 documented relations.

About RQACCTU

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

Fields (4)

Column = COBOL field name without the RQU- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`RQU-COMPANY` PK COMPANY	Numeric 4	Identifies 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.	RQ04.1
`RQU-REQUESTER` PK REQUESTER	Alpha 10 (Lower Case)	This is the person who requested this requisition.	RQ04.1
`RQU-ACCT-UNIT` PK ACCT_UNIT	Alpha 15	The 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.	RQ04.1
`RQU-DIST-COMPANY` PK DIST_COMPANY	Numeric 4	When a Dist Company number is entered, it supercedes the Company number from the Main tab. A valid intercompany relationship must be defined in General Ledger (GL25.1).	RQ04.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`RQUSET1`	`COMPANY`, `REQUESTER`, `ACCT-UNIT`, `DIST-COMPANY`	Primary		DR100, IC141, IC142, IC83.1, RQ04.1, RQ10.1, RQ10.2, RQ10.3 +14 more

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Glnames	GLNAMES	Required		`RQU-COMPANY` → `GLN-COMPANY`, `RQU-ACCT-UNIT` → `GLN-ACCT-UNIT`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Rqreqaudit	RQREQAUDIT			`RQU-COMPANY` → `RQA-COMPANY`, `RQU-REQUESTER` → `RQA-REQUESTER`, `Spaces` → `RQA-PURCH-MAJOR`, `Spaces` → `RQA-PURCH-MINOR`, `RQU-ACCT-UNIT` → `RQA-ACCT-UNIT`, `RQU-DIST-COMPANY` → `RQA-DIST-COMPANY`, → `RQA-DATE`, → `RQA-TIME`, → `RQA-FLD-NBR`

Programs

Updated by (1)

RQ04.1 Requesters

Referenced by (21)

DR100 Distribution Requirements Report
IC141 Location Replenishment Report
IC142 Replenishment by Requisition PO's
IC83.1 Par Location Counts
RQ10.1 Requisition
RQ10.2 Account Distribution
RQ10.3 Select and Copy
RQ10.4 Requisition Line Entry Detail
RQ10.5 Substitutes
RQ11.1 Kit Accessories
RQ13.2 Direct Line Approval
RQ204 Requester Listing
RQ35.1 Requisition Returns
RQ500 Requisition Interface
RQ504 Requester Setup Extract
RQIA.1 RQREQPD Invoke Object
RQIB.1 RQRQHUPD Invoke Object
RQID.1 RQRQHUPD Invoke Object
RQIF.1 RQRLNUPD Invoke Object
RQII.1 Invoke for Reqheader Inquiry
RQIJ.1 Requisition Copy