Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                            RQCOMMENTS FILE

                          Requisition Comments

This file contains both the header and line comments for a requisition. The
header comments have a line number of zeroes.

REFERENCED BY

RQ111     RQ120     RQ125     RQ240

UPDATED BY

DR100     IC141     IC142     IC83.1    RQ10.1    RQ10.3
RQ10.4    RQ10.5    RQ11.1    RQ20.1    RQ300     RQ35.1
RQ500     WH20.7

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RCM-COMPANY          Numeric 4                                   DR100   IC141
Company              The company number represents an            IC142   IC83.1
                     established company and is entered on       RQ10.1  RQ10.3
                     all function codes.                         RQ10.4  RQ10.5
                                                                 RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 WH20.7

RCM-REQ-NUMBER       Numeric 7                                   DR100   IC141
Requisition Number   This is the assigned number to identify     IC142   IC83.1
                     this requisition.                           RQ10.1  RQ10.3
                                                                 RQ10.4  RQ10.5
                                                                 RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 WH20.7

RCM-LINE-NBR         Numeric 6                                   DR100   IC141
Line Number          This is the requisition line number to      IC142   IC83.1
                     which the comment is attached.              RQ10.1  RQ10.3
                                                                 RQ10.4  RQ10.5
                                                                 RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 WH20.7

RCM-SEQ              Numeric 3                                   DR100   IC141
Sequence Number      The comment record sequence number.         IC142   IC83.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ10.4  RQ10.5
                                                                 RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 WH20.7

RCM-COMMENT          Alpha 40  (Lower Case)                      DR100   IC141
Comment Line         This field contains the comment             IC142   IC83.1
                     narrative.                                  RQ10.1  RQ10.3
                                                                 RQ10.4  RQ10.5
                                                                 RQ11.1  RQ20.1
                                                                 RQ35.1  RQ500
                                                                 WH20.7

RCM-PRINT-CODE       Alpha 1                                     DR100   IC141
Print Code           The Print Code defines where the            IC142   IC83.1
                     comment displays and/or prints.             RQ10.1  RQ10.3
                     B = Both Display and Print                  RQ10.4  RQ10.5
                     D = Display Only                            RQ11.1  RQ20.1
                     P = Print Only                              RQ35.1  RQ500
                     R = Receiving Only                          WH20.7

                         RQCOMMENTS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RCMSET1   COMPANY       This index is used to access comments    DR100   IC141
          REQ-NUMBER    for a specific requisition line.         IC142   IC83.1
          LINE-NBR                                               RQ10.1  RQ10.3
          SEQ                                                    RQ10.4  RQ10.5
                                                                 RQ11.1  RQ111
                                                                 RQ120   RQ125
                                                                 RQ20.1  RQ20.2
                                                                 RQ20.4  RQ240
                                                                 RQ300   RQ35.1
                                                                 RQ500   WH20.7

                         RQCOMMENTS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Req            REQHEADER    Required
                            When RCM-LINE-NBR = Zeroes

                            RCM-COMPANY       -> RQH-COMPANY
                            RCM-REQ-NUMBER    -> RQH-REQ-NUMBER

Req Line       REQLINE      Required
                            When RCM-LINE-NBR != Zeroes

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