RQTEMP FILE
Requisition Template Header
This is the header file for the Requisition Templates. It contains the
template description.
REFERENCED BY
RQ780
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQM-COMPANY Numeric 4
Element: Company The company number represents an
established company and is entered on
all function codes.
RQM-REQ-LOCATION Alpha 5
Element: Location Code
RQM-REQUESTER Alpha 10 (Lower Case)
Element: Requester This is the person who requested this
requisition.
RQM-TEMPLATE-ID Alpha 10
Authorization
Identification
RQM-DESCRIPTION Alpha 30 (Lower Case)
Element: Description This is the description of the
template.
RQM-LAST-LINE-NBR Numeric 6
Element: Line Number This is the number of the last line
item added to the template. It is used
to determine the number when the next
line is added to the template.
RQTEMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQMSET1 COMPANY This index is used to access RQ780
REQ-LOCATION requisition template header data for a
REQUESTER specific template assigned to a specific
TEMPLATE-ID requester at a company requesting
location.
RQTEMP FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Ic Company ICCOMPANY Required
RQM-COMPANY -> ICC-COMPANY
Location RQLOC Required
RQM-COMPANY -> RQL-COMPANY
RQM-REQ-LOCATION -> RQL-REQ-LOCATION
Requester REQUESTER Not Required
RQM-COMPANY -> REQ-COMPANY
RQM-REQUESTER -> REQ-REQUESTER
RQTEMP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Lines RQTEMPLINE Delete Restricted
RQM-COMPANY -> RQX-COMPANY
RQM-REQ-LOCATION -> RQX-REQ-LOCATION
RQM-REQUESTER -> RQX-REQUESTER
RQM-TEMPLATE-ID -> RQX-TEMPLATE-ID
RQX-LINE-NBR
|
