POPLIUF

UPDATED BY
PO20.1 PO20.6 PO20.9 PO21.2 PO21.4 PO21.5
PO21.1 PO21.3 PO520 POD0.1 POIJ.1 AP125
AP126 AP131 AP20.1 AP20.2 AP20.3 AP20.4
AP20.5 AP20.7 AP21.1 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 AP510 API1.1 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC12.1
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 IC83.1 MA180
MA278 MA41.1 MA41.2 MA41.4 MA41.7 MA42.2
MA43.2 MA43.7 MA44.1 MA44.2 MA53.1 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 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 PO136 PO15.1 PO15.2
PO15.4 PO150 PO17.1 PO190 PO204 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.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.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
PO536 PO54.5 POCP.1 POI3.1 POID.1 POII.1
RQ01.1 RQ10.1 RQ10.2 RQ10.3 RQ10.4 RQ10.5
RQ11.1 RQ12.1 RQ13.1 RQ13.2 RQ35.1 RQ44.1
RQ500 RQ810 RQIB.1 RQIF.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

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UFN-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.
POIJ.1
UFN-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
POIJ.1
UFN-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
POIJ.1
UFN-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
POIJ.1
UFN-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
PO20.1 PO21.2
PO21.4 PO21.5
PO520 POIJ.1
UFN-PLI-USR-FLD-01
Element: Pli Usr Fld 01
Alpha 20
POIJ.1
UFN-PLI-USR-FLD-02
Element: Pli Usr Fld 02
Alpha 20
POIJ.1
UFN-PLI-USR-FLD-03
Element: Pli Usr Fld 03
Alpha 20
POIJ.1
UFN-PLI-USR-FLD-04
Element: Pli Usr Fld 04
Alpha 20
POIJ.1
UFN-PLI-USR-FLD-05
Element: Pli Usr Fld 05
Alpha 20
POIJ.1


POPLIUF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UFNSET1 COMPANY
PO-NUMBER
PO-RELEASE
PO-CODE
LINE-NBR
...
AP125 AP126
AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
AP510 API1.1
API2.1 CX100
CX20.1 CX20.2
CX20.4 CX20.5
CX220 CX30.1
CX300 CX506
CXCP.1 DR100


POPLIUF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Poline POLINE Required
UFN-COMPANY->PLI-COMPANY
UFN-PO-NUMBER->PLI-PO-NUMBER
UFN-PO-RELEASE->PLI-PO-RELEASE
UFN-PO-CODE->PLI-PO-CODE
UFN-LINE-NBR->PLI-LINE-NBR


File created: Thu Jun 09 02:27:26 2016

Home
Contact Us



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