Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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

DR100     IC141     IC142     IC83.1    RQ04.1    RQ111
RQ12.1    RQ202     RQ44.2

UPDATED BY

RQ02.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RAC-COMPANY          Numeric 4                                   RQ02.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

RAC-APPROVE-CD       Alpha 5                                     RQ02.1
Approval Code        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
Description          This is the description of the approval
                     code.

RAC-SKIP-LVLS-FL     Alpha 1                                     RQ02.1
Skip Approval        This flag indicates whether a higher
Levels Flag          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
Authorization Print  This flag indicates whether the
Flag                 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
Authorization        This is the authorization identifier
Identification       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
Authorization Name   This is the header field for the
                     approver names defined for requisition
                     approval levels.

RAC-AUTH-LIMIT       Numeric 9 Occurs 6 Times                    RQ02.1
Authorization 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       Use this index to access a specific      DR100   IC141
          APPROVE-CD    requester approval code record.          IC142   IC83.1
                                                                 RQ02.1  RQ04.1
                                                                 RQ111   RQ12.1
                                                                 RQ202   RQ44.2

                         RQAPPCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ic Company     ICCOMPANY    Required

                            RAC-COMPANY    -> ICC-COMPANY