|
|
POPCRUF FILE
UPDATED BY
POII.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
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
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 PO520 PO536
POI3.1 POID.1 POIJ.1 RQ10.1 RQ10.2 WH20.2
WH20.7
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UFP-COMPANY Numeric 4 POII.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.
UFP-PO-CODE Alpha 4 POII.1
Element: Po Code This is the purchase order code.
UFP-PO-NUMBER Alpha 14 (Right Justified) POII.1
Element: Po Number This field contains the number
representing the purchase order.
UFP-PO-RELEASE Numeric 4 POII.1
Element: Po Release Used to identify a purchase order
release (created from a Blanket or
Standing order).
UFP-PCR-USR-FLD-01 Alpha 20 POII.1
Element: Pcr Usr Fld 01
UFP-PCR-USR-FLD-02 Alpha 20 POII.1
Element: Pcr Usr Fld 02
UFP-PCR-USR-FLD-03 Alpha 20 POII.1
Element: Pcr Usr Fld 03
UFP-PCR-USR-FLD-04 Alpha 20 POII.1
Element: Pcr Usr Fld 04
UFP-PCR-USR-FLD-05 Alpha 20 POII.1
Element: Pcr Usr Fld 05
POPCRUF FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UFPSET1 COMPANY AP125 AP126
PO-CODE AP131 AP20.1
PO-NUMBER AP20.2 AP20.3
PO-RELEASE 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
...
POPCRUF FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Purchorder PURCHORDER Required
UFP-COMPANY -> PCR-COMPANY
UFP-PO-CODE -> PCR-PO-CODE
UFP-PO-NUMBER -> PCR-PO-NUMBER
UFP-PO-RELEASE -> PCR-PO-RELEASE
|
