|
|
POPLIUF FILE
UPDATED BY
PO20.1 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 API1.1 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA43.1 MA43.2 MA43.3 MA43.7 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 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 PO100 PO101
PO122 PO131 PO22.1 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 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 POI3.1 POID.1 POII.1 RQ10.1 RQ10.2
WH20.2 WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UFN-COMPANY Numeric 4 POIJ.1
Element: Company 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.
UFN-PO-NUMBER Alpha 14 (Right Justified) POIJ.1
Element: Po Number This field contains the number
representing the purchase order.
UFN-PO-RELEASE Numeric 4 POIJ.1
Element: Po Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
UFN-PO-CODE Alpha 4 POIJ.1
Element: Po Code This is the purchase order code.
UFN-LINE-NBR Numeric 6 PO20.1 PO21.2
Element: Line Nbr This field contains the line number. PO21.4 PO21.5
PO520 POIJ.1
UFN-PLI-USR-FLD-01 Alpha 20 POIJ.1
Element: Pli Usr Fld 01
UFN-PLI-USR-FLD-02 Alpha 20 POIJ.1
Element: Pli Usr Fld 02
UFN-PLI-USR-FLD-03 Alpha 20 POIJ.1
Element: Pli Usr Fld 03
UFN-PLI-USR-FLD-04 Alpha 20 POIJ.1
Element: Pli Usr Fld 04
UFN-PLI-USR-FLD-05 Alpha 20 POIJ.1
Element: Pli Usr Fld 05
POPLIUF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UFNSET1 COMPANY AP125 AP126
PO-NUMBER AP131 AP20.1
PO-RELEASE AP20.2 AP20.3
PO-CODE AP20.4 AP20.5
LINE-NBR AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 MA180
...
POPLIUF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
|
