RQAPPCODE – Requisition Approval Codes

System
Requisitions (RQ)
Prefix
RAC
Primary key
COMPANY, APPROVE-CD
Fields
8
Updated by
1 program
Referenced by
19 programs

RQAPPCODE is the Requisition Approval Codes table in Lawson Requisitions (prefix RAC). It is indexed by COMPANY, APPROVE-CD (RACSET1). It is related 1:1 to ICCOMPANY. It is updated by RQ02.1 and referenced by DR100, IC141, IC142, IC83.1, RQ04.1, RQ10.1, RQ10.3, RQ11.1 and 11 more. The table has 8 fields, 1 index and 1 documented relation.

About RQAPPCODE

This file defines an approval process. These codes are assigned to requesters to identify the approval hierarchy for all requisitions entered by that requester.

Fields (8)

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

Field / columnTypeDescription & valuesUpdated by
RAC-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.RQ02.1
RAC-APPROVE-CD PK
APPROVE_CD		Alpha 5This is a user-defined code to identify the approval process (levels) that a requisition has to pass before it can be picked or purchased.RQ02.1
RAC-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This is the description of the approval code.RQ02.1
RAC-SKIP-LVLS-FL
SKIP_LVLS_FL		Alpha 1This flag indicates whether a higher level approver can approve a requisition before a lower level approver has approved the requisition. Select No if all the levels must approve the requisition in order. Select Yes if upper approval levels can approve the requisition without passing through each prior approval level.
  • N No
  • Y Yes
RQ02.1
RAC-AUTH-PRT-FL
AUTH_PRT_FL		Alpha 1This flag indicates whether the requisition assigned to this approval code requisitions using this approval code are to be printed in RQ111 (Print Requisitions). When the requisition is entered, this flag defaults onto the requisition. The system determines this by the requester creating the requisition. Every requester is required to have an approval code assigned to it. Defaults to No.
  • N No
  • Y Yes
RQ02.1
RAC-AUTH-ID
AUTH_ID		Alpha 10 Occurs 6 Times ×6This is the authorization identifier for the approver to access the requisitions requiring approval at this level. The approver uses this ID to access the requisition information in RQ12.1 (Approval Review).RQ02.1
RAC-AUTH-NAME
AUTH_NAME		Alpha 30 Occurs 6 Times ×6This is the header field for the approver names defined for requisition approval levels.RQ02.1
RAC-AUTH-LIMIT
AUTH_LIMIT		Numeric 9 Occurs 6 Times ×6This is the header field for the authorization limit fields defined for requisition approval levels.RQ02.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
RACSET1COMPANY, APPROVE-CDPrimaryDR100, IC141, IC142, IC83.1, RQ02.1, RQ04.1, RQ10.1, RQ10.3 +12 more

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
Ic CompanyICCOMPANYRequiredRAC-COMPANY → ICC-COMPANY

Programs

Updated by (1)

Referenced by (19)