Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQAPPROVE


                             RQAPPROVE FILE

                         Requisition Approvals

This is the file of open approval records needing to be approved. These
records are created when a new or changed requisition is released. Records are
created for each approval amount level that is less than the requisition total
value. These records are deleted when the approver approves the requisition at
a level.

REFERENCED BY

RQ02.1    RQ111     RQ44.2

UPDATED BY

RQ10.1    RQ12.1    RQ35.1    RQ500     RQIF.1    RQ13.1
RQ13.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RAP-COMPANY            Numeric 4                                 RQ10.1  RQ35.1
Element: Company       Identifies the AP company if the          RQ500   RQIF.1
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

RAP-AUTH-ID            Alpha 10                                  RQ10.1  RQ35.1
Element: Auth Id       This is the authorization identifier      RQ500   RQIF.1
                       for the approver to access the
                       requisitions that need approving at this
                       level.

RAP-APPROVE-CD         Alpha 5                                   RQ10.1  RQ35.1
Element: Approve Cd    This is a code to identify the approval   RQ500   RQIF.1
                       process (levels) that a requisition has
                       to pass before it can be picked or
                       purchased.

RAP-REQ-NUMBER         Numeric 7                                 RQ10.1  RQ35.1
Element: Req Number    This is the assigned number to identify   RQ500   RQIF.1
                       this requisition.

RAP-APRV-LEVEL         Numeric 1                                 RQ10.1  RQ35.1
Element: Aprv Level    This is the approval level number         RQ500   RQIF.1
                       within the approval code at which this
                       requisition has to be approved.

                         RQAPPROVE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RAPSET1   COMPANY                                                RQ02.1  RQ10.1
          AUTH-ID                                                RQ12.1  RQ35.1
          APPROVE-CD                                             RQ500   RQIF.1
          REQ-NUMBER

RAPSET2   COMPANY                                                RQ10.1  RQ111
          REQ-NUMBER                                             RQ12.1  RQ13.1
          APRV-LEVEL                                             RQ13.2  RQ44.2
                                                                 RQIF.1

                         RQAPPROVE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Approve Code   RQAPPCODE    Required

                            RAP-COMPANY       -> RAC-COMPANY
                            RAP-APPROVE-CD    -> RAC-APPROVE-CD

Ic Company     ICCOMPANY    Required

                            RAP-COMPANY       -> ICC-COMPANY

Requester      REQUESTER    Not Required

                            RAP-COMPANY       -> REQ-COMPANY
                            RQH-REQUESTER     -> REQ-REQUESTER

Requisition    REQHEADER    Required

                            RAP-COMPANY       -> RQH-COMPANY
                            RAP-REQ-NUMBER    -> RQH-REQ-NUMBER

                         RQAPPROVE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Req Lines      REQLINE

                            RAP-COMPANY       -> RLN-COMPANY
                            RAP-REQ-NUMBER    -> RLN-REQ-NUMBER
                                                 RLN-LINE-NBR