POPCRUF

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
API2.1 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1
PO136 PO190 PO300 PO520 POCP.1 POI3.1
POIJ.1

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
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
MAI1.1 PO136


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: Wed Jun 08 20:50:52 2016

Home
Contact Us



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