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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#RQU-COMPANY PKCOMPANY | 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 PKREQUESTER | Alpha 10 (Lower Case) | This is the person who requested this requisition. | RQ04.1 |
#RQU-ACCT-UNIT PKACCT_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 PKDIST_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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
RQUSET1 |
| 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 |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Rqreqaudit | RQREQAUDIT |
|
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