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 |