Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQACCTU


                              RQACCTU FILE

                      Requester's Accounting Units

This is the list of valid accounting units that this requester can enter on a
requisition.

REFERENCED BY

RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ13.2    RQ204
RQ35.1    RQ500     RQIA.1    RQIB.1    RQID.1    RQIF.1
RQII.1    RQIJ.1

UPDATED BY

RQ04.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RQU-COMPANY            Numeric 4                                 RQ04.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.

RQU-REQUESTER          Alpha 10  (Lower Case)                    RQ04.1
Element: Requester     This is the person who requested this
                       requisition.

RQU-ACCT-UNIT          Alpha 15                                  RQ04.1
Element: Acct Unit     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.


                         RQACCTU FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RQUSET1   COMPANY                                                RQ04.1  RQ10.1
          REQUESTER                                              RQ10.2  RQ10.3
          ACCT-UNIT                                              RQ11.1  RQ13.2
                                                                 RQ204   RQ35.1
                                                                 RQ500   RQIA.1
                                                                 RQIB.1  RQID.1
                                                                 RQIF.1  RQII.1
                                                                 RQIJ.1

                         RQACCTU FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Glnames        GLNAMES      Required

                            RQU-COMPANY      -> GLN-COMPANY
                            RQU-ACCT-UNIT    -> GLN-ACCT-UNIT