Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQAPPCODE


                             RQAPPCODE FILE

                       Requisition Approval Codes

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

REFERENCED BY

RQ04.1    RQ10.1    RQ10.3    RQ11.1    RQ111     RQ12.1
RQ13.2    RQ202     RQ35.1    RQ44.2    RQ500     RQIB.1
RQIF.1    RQIJ.1

UPDATED BY

RQ02.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RAC-COMPANY            Numeric 4                                 RQ02.1
Element: Company       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.

RAC-APPROVE-CD         Alpha 5                                   RQ02.1
Element: Approve Cd    This is a user-defined code to identify
                       the approval process (levels) that a
                       requisition has to pass before it can be
                       picked or purchased.

RAC-DESCRIPTION        Alpha 30  (Lower Case)                    RQ02.1
Element: Description   This is the description of the approval
                       code.

RAC-SKIP-LVLS-FL       Alpha 1                                   RQ02.1
Element: All Flag      This 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

RAC-AUTH-PRT-FL        Alpha 1                                   RQ02.1
Element: All Flag      This 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

RAC-AUTH-ID            Alpha 10 Occurs 6 Times                   RQ02.1
Element: Auth Id       This 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).

RAC-AUTH-NAME          Alpha 30 Occurs 6 Times                   RQ02.1
Element: Authority     This is the header field for the
                       approver names defined for requisition
                       approval levels.

RAC-AUTH-LIMIT         Numeric 9 Occurs 6 Times                  RQ02.1
Element: Auth Limit    This is the header field for the
                       authorization limit fields defined for
                       requisition approval levels.

                         RQAPPCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RACSET1   COMPANY                                                RQ02.1  RQ04.1
          APPROVE-CD                                             RQ10.1  RQ10.3
                                                                 RQ11.1  RQ111
                                                                 RQ12.1  RQ13.2
                                                                 RQ202   RQ35.1
                                                                 RQ44.2  RQ500
                                                                 RQIB.1  RQIF.1
                                                                 RQIJ.1

                         RQAPPCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ic Company     ICCOMPANY    Required

                            RAC-COMPANY    -> ICC-COMPANY