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
Company The company number represents an
established company and is entered on
all function codes.
RQM-REQ-LOCATION Alpha 5
To Location The location requisitioning items.
This location can be an inventory or
noninventory location.
RQM-REQUESTER Alpha 10 (Lower Case)
Requester This is the person who requested this
requisition.
RQM-TEMPLATE-ID Alpha 10
Template Id This is an identifier for the template
to differentiate it from other templates
within the requesting location or for
the requester.
RQM-DESCRIPTION Alpha 30 (Lower Case)
Description This is the description of the
template.
RQM-LAST-LINE-NBR Numeric 6
Last 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
|
