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
|