|
PROCTEMP FILE
REFERENCED BY
PO20.1 PO215 RQ10.1 RQIG.1
UPDATED BY
PO115 PO15.1 PO15.2 PO15.3
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POP-PROCURE-GROUP Alpha 4 PO115 PO15.1
Element: Procure Group This field contains the identifier for PO15.2 PO20.1
a group of companies that share a common RQ10.1
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
POP-DESCRIPTION Alpha 30 (Lower Case) PO115 PO15.1
Element: Description This field displays the description. PO15.2 PO20.1
RQ10.1
POP-LAST-LINE-NBR Numeric 6 PO115 PO15.1
Element: Line Nbr This field contains the line number. PO15.2 PO20.1
RQ10.1
POP-FROM-COMPANY Numeric 4 PO115 PO15.1
Element: Company Identifies the AP company if the PO15.2 PO20.1
resource type = V. Identifies the HR RQ10.1
company if the resource type = E. It is
blank for type A, P or Q resources.
POP-FROM-LOCATION Alpha 5 PO115 PO15.1
Element: Location This field contains a valid stocking PO15.2 PO20.1
location within the company inventory. RQ10.1
POP-LOCK-FLAG Numeric 1 PO115 PO15.1
Element: Lock Flag 0 = Not Locked PO15.2 PO15.3
1 = Locked 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 PO15.3
PO20.1 PO215
RQ10.1 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
|