PORLNUF

REFERENCED BY
AM19.1 AM19.2 AP115 AP125 AP126 AP131
AP20.1 AP20.2 AP20.3 AP20.4 AP20.5 AP20.7
AP21.1 AP220 AP23.1 AP25.1 AP25.2 AP26.1
AP27.1 AP30.2 AP30.4 AP305 AP510 API1.1
API2.1 CX100 CX20.1 CX20.2 CX20.4 CX20.5
CX220 CX30.1 CX300 CX506 CXCP.1 DR100
IC12.1 IC130 IC140 IC141 IC142 IC145
IC243 IC330 IC64.1 IC64.2 IC64.3 IC64.4
IC64.5 IC64.6 IC64.7 IC64.8 IC64.9 IC66.1
MA126 MA180 MA26.1 MA278 MA41.1 MA41.2
MA41.4 MA41.7 MA42.1 MA42.2 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MA44.1 MA44.2
MA53.1 MA530 MA531 MA60.2 MA60.3 MA60.5
MA61.1 MA63.1 MA65.1 MA66.2 MA67.2 MA67.3
MA68.2 MA68.3 MA68.5 MA69.1 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PD570 PO04.1 PO04.2 PO10.1
PO10.2 PO100 PO101 PO115 PO120 PO122
PO131 PO132 PO135 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO20.1 PO20.6
PO20.9 PO204 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO220 PO222
PO224 PO225 PO229 PO23.1 PO230 PO234
PO24.1 PO25.1 PO25.5 PO25.6 PO25.7 PO251
PO26.1 PO26.3 PO26.7 PO26.9 PO27.2 PO27.3
PO27.4 PO275 PO276 PO277 PO28.2 PO280
PO29.1 PO30.1 PO30.2 PO30.3 PO30.4 PO300
PO31.1 PO31.2 PO32.1 PO32.2 PO32.4 PO33.1
PO34.1 PO35.1 PO36.1 PO36.2 PO38.1 PO39.1
PO39.2 PO44.1 PO50.1 PO52.1 PO520 PO536
PO54.5 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ01.1 RQ11.1 RQ11.3 RQ11.4 RQ11.5 RQ12.1
RQ13.1 RQ13.2 RQ35.1 RQ44.1 RQ810 RQIB.1
RQII.1 RQIJ.1 WH130 WH132 WH190 WH20.2
WH20.7 WH222 WH30.1 WH30.2 WH30.3 WH30.4
WH31.1 WH31.2 WH31.3 WH31.4 WH32.1 WH32.2
WH32.3 WH32.4 WH32.5 WH33.1 WH33.2 WH33.3
WH33.4 WH33.5 WH33.6 WH33.8 WH33.9 WH34.1
WH34.2 WH34.3 WH34.4 WH40.1 WH40.2 WH520
WH830


UPDATED BY
RQ10.1 RQ10.3 RQ10.4 RQ500 RQIF.1 IC83.1
RQ300

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UFQ-COMPANY
Element: Company		Numeric 4
Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.
RQ10.1 RQ10.4
RQ500 RQIF.1
UFQ-REQ-NUMBER
Element: Req Number		Numeric 7
This is the assigned number to identify this requisition.
RQ10.1 RQ10.3
RQ10.4 RQ500
RQIF.1
UFQ-LINE-NBR
Element: Line Nbr		Numeric 6
This field contains the line number.
RQ10.1 RQ10.3
RQ10.4 RQ500
RQIF.1
UFQ-RLN-USR-FLD-01
Element: Rln Usr Fld 01		Alpha 20
RQ10.1 RQ10.4
RQ500 RQIF.1
UFQ-RLN-USR-FLD-02
Element: Rln Usr Fld 02		Alpha 20
RQ10.1 RQ10.4
RQ500 RQIF.1
UFQ-RLN-USR-FLD-03
Element: Rln Usr Fld 03		Alpha 20
RQ10.1 RQ10.4
RQ500 RQIF.1
UFQ-RLN-USR-FLD-04
Element: Rln Usr Fld 04		Alpha 20
RQ10.1 RQ10.4
RQ500 RQIF.1
UFQ-RLN-USR-FLD-05
Element: Rln Usr Fld 05		Alpha 20
RQ10.1 RQ10.4
RQ500 RQIF.1


PORLNUF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UFQSET1 COMPANY
REQ-NUMBER
LINE-NBR
...
AM19.1 AM19.2
AP115 AP125
AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5


PORLNUF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Reqline REQLINE Required
UFQ-COMPANY->RLN-COMPANY
UFQ-REQ-NUMBER->RLN-REQ-NUMBER
UFQ-LINE-NBR->RLN-LINE-NBR

File created: Thu Jun 09 02:31:58 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.