|
|
PORLNUF FILE
REFERENCED BY
RQIJ.1
UPDATED BY
RQ10.1 RQ10.3 RQ500 RQIF.1 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UFQ-COMPANY Numeric 4 RQ10.1 RQ500
Element: Company Identifies the AP company if the RQIF.1
resource type = V. Identifies the HR
company if the resource type = E. It is
blank for type A, P or Q resources.
UFQ-REQ-NUMBER Numeric 7 RQ10.1 RQ10.3
Element: Req Number This is the assigned number to identify RQ500 RQIF.1
this requisition.
UFQ-LINE-NBR Numeric 6 RQ10.1 RQ10.3
Element: Line Nbr This field contains the line number. RQ500 RQIF.1
UFQ-RLN-USR-FLD-01 Alpha 20 RQ10.1 RQ500
Element: Rln Usr Fld 01 RQIF.1
UFQ-RLN-USR-FLD-02 Alpha 20 RQ10.1 RQ500
Element: Rln Usr Fld 02 RQIF.1
UFQ-RLN-USR-FLD-03 Alpha 20 RQ10.1 RQ500
Element: Rln Usr Fld 03 RQIF.1
UFQ-RLN-USR-FLD-04 Alpha 20 RQ10.1 RQ500
Element: Rln Usr Fld 04 RQIF.1
UFQ-RLN-USR-FLD-05 Alpha 20 RQ10.1 RQ500
Element: Rln Usr Fld 05 RQIF.1
PORLNUF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UFQSET1 COMPANY RQ10.1 RQ10.3
REQ-NUMBER RQ300 RQ500
LINE-NBR RQIF.1 RQIJ.1
PORLNUF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Reqline REQLINE Required
UFQ-COMPANY -> RLN-COMPANY
UFQ-REQ-NUMBER -> RLN-REQ-NUMBER
UFQ-LINE-NBR -> RLN-LINE-NBR
|
