POPCRUF

UPDATED BY
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 API2.1
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 CXCP.1 DR100 IC140
IC66.1 IC83.1 MA180 MA41.1 MA41.2 MA41.4
MA41.7 MA42.2 MA43.2 MA43.7 MA44.1 MA44.2
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 PO100 PO101
PO122 PO131 PO136 PO150 PO190 PO20.1
PO20.6 PO20.9 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO22.3 PO22.4 PO23.1 PO24.1
PO25.1 PO25.5 PO25.6 PO25.7 PO27.2 PO28.2
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 PO520 PO536 PO54.5
POCP.1 POI3.1 POID.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ10.4 RQ12.1 RQ13.1 RQ13.2 RQ35.1
RQ500 RQIF.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 ZW130

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
UFP-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.
POII.1
UFP-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code.
POII.1
UFP-PO-NUMBER
Element: Po Number
Alpha 14 (Right Justified)
This field contains the number representing the purchase order.
POII.1
UFP-PO-RELEASE
Element: Po Release
Numeric 4
Used to identify a purchase order release (created from a Blanket or Standing order).
POII.1
UFP-PCR-USR-FLD-01
Element: Pcr Usr Fld 01
Alpha 20
POII.1
UFP-PCR-USR-FLD-02
Element: Pcr Usr Fld 02
Alpha 20
POII.1
UFP-PCR-USR-FLD-03
Element: Pcr Usr Fld 03
Alpha 20
POII.1
UFP-PCR-USR-FLD-04
Element: Pcr Usr Fld 04
Alpha 20
POII.1
UFP-PCR-USR-FLD-05
Element: Pcr Usr Fld 05
Alpha 20
POII.1


POPCRUF FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
UFPSET1 COMPANY
PO-CODE
PO-NUMBER
PO-RELEASE
...
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 API2.1
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 CXCP.1
DR100 IC140


POPCRUF FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:24:37 2016

Home
Contact Us



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