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

DR100     IC141     IC142     IC83.1    RQ10.1    RQ10.2
RQ10.3    RQ11.1    RQ13.2    RQ204     RQ35.1    RQ500
RQIA.1    RQIB.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: Accounting UniThe 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       Use this index to access a record for a  DR100   IC141
          REQUESTER     specific requester and accounting unit.  IC142   IC83.1
          ACCT-UNIT                                              RQ04.1  RQ10.1
                                                                 RQ10.2  RQ10.3
                                                                 RQ11.1  RQ13.2
                                                                 RQ204   RQ35.1
                                                                 RQ500   RQIA.1
                                                                 RQIB.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