PROCTEMP FILE
REFERENCED BY
PO20.1 PO215 RQ10.1 RQIG.1
UPDATED BY
PO115 PO15.1 PO15.2 RQ780
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POP-PROCURE-GROUP Alpha 4 PO115 PO15.1
Element: Procure Group This field contains the identifier for a PO15.2 PO20.1
group of companies that share a common RQ10.1 RQ780
procurement effort. They buy items and
services together.
POP-TEMPLATE-REF Alpha 30 PO115 PO15.1
Element: Template Ref PO15.2 PO20.1
RQ10.1 RQ780
POP-DESCRIPTION Alpha 30 (Lower Case) PO115 PO15.1
Element: Description This field displays the description. PO15.2 PO20.1
RQ10.1 RQ780
POP-LAST-LINE-NBR Numeric 6 PO115 PO15.1
Element: Line Number PO15.2 PO20.1
RQ10.1 RQ780
POP-FROM-COMPANY Numeric 4 PO115 PO15.1
Element: Company PO15.2 PO20.1
RQ10.1
POP-FROM-LOCATION Alpha 5 PO115 PO15.1
Element: Location Code PO15.2 PO20.1
RQ10.1
POP-PARTICIPANT Derived
Element: Participant
PROCTEMP FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POPSET1 PROCURE-GROUP PO115 PO15.1
TEMPLATE-REF PO15.2 PO20.1
PO215 RQ10.1
RQ780 RQIG.1
PROCTEMP FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Proctempl2 PROCTEMPLN Delete Cascades
POP-PROCURE-GROUP -> POE-PROCURE-GROUP
POP-TEMPLATE-REF -> POE-TEMPLATE-REF
POE-ITEM
POE-LINE-NBR
Proctempln PROCTEMPLN Delete Cascades
POP-PROCURE-GROUP -> POE-PROCURE-GROUP
POP-TEMPLATE-REF -> POE-TEMPLATE-REF
POE-LINE-NBR
Proctmppar PROCTMPPAR Delete Cascades
POP-PROCURE-GROUP -> POA-PROCURE-GROUP
POP-TEMPLATE-REF -> POA-TEMPLATE-REF
POA-COMPANY
POA-REQ-LOCATION
POA-REQUESTER
POA-BUYER-GRP
POA-BUYER
|