Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PORLNUF


                              PORLNUF FILE

REFERENCED BY

RQIJ.1

UPDATED BY

RQ10.1    RQ10.3    RQ500     RQIF.1    RQ300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

UFQ-LINE-NBR           Numeric 6                                 RQ10.1  RQ10.3
Element: Line Nbr      This field contains the line number.      RQ500   RQIF.1

UFQ-RLN-USR-FLD-01     Alpha 20                                  RQ10.1  RQ500
Element: Rln Usr Fld 01                                          RQIF.1

UFQ-RLN-USR-FLD-02     Alpha 20                                  RQ10.1  RQ500
Element: Rln Usr Fld 02                                          RQIF.1

UFQ-RLN-USR-FLD-03     Alpha 20                                  RQ10.1  RQ500
Element: Rln Usr Fld 03                                          RQIF.1

UFQ-RLN-USR-FLD-04     Alpha 20                                  RQ10.1  RQ500
Element: Rln Usr Fld 04                                          RQIF.1

UFQ-RLN-USR-FLD-05     Alpha 20                                  RQ10.1  RQ500
Element: Rln Usr Fld 05                                          RQIF.1

                         PORLNUF FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UFQSET1   COMPANY                                                RQ10.1  RQ10.3
          REQ-NUMBER                                             RQ300   RQ500
          LINE-NBR                                               RQIF.1  RQIJ.1

                         PORLNUF FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Reqline        REQLINE      Required

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