PROCTEMP FILE
REFERENCED BY
PO20.1 PO215 RQ10.1 RQIG.1
UPDATED BY
PO115 PO15.1 PO15.2
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
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 Number This field contains the number of the PO15.2 PO20.1
last line item added to the document. It RQ10.1
is used to determine what the next line
number is when you add another
item.
POP-FROM-COMPANY Numeric 4 PO115 PO15.1
Element: Company This is the company that is the source PO15.2 PO20.1
of the items. RQ10.1
POP-FROM-LOCATION Alpha 5 PO115 PO15.1
Element: Location Code This is the inventory location that PO15.2 PO20.1
supplies the items or it is the purchase RQ10.1
order ship to location that receives the
items.
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
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
|
