|
PROCTMPPAR FILE
REFERENCED BY
PO215 RQIG.1 PO20.1 RQ10.1
UPDATED BY
PO115 PO15.1 PO15.2 RQ780
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POA-PROCURE-GROUP Alpha 4 PO115 PO15.1
Element: Procure Group This field contains the identifier for a PO15.2 RQ780
group of companies that share a common
procurement effort. They buy items and
services together.
POA-TEMPLATE-REF Alpha 30 PO115 PO15.1
Element: Template Ref PO15.2 RQ780
POA-COMPANY Numeric 4 PO115 PO15.1
Element: Company The company number represents an PO15.2 RQ780
established company and is entered on
all function codes.
POA-REQ-LOCATION Alpha 5 PO115 PO15.1
Element: Location Code PO15.2 RQ780
POA-REQUESTER Alpha 10 (Lower Case) PO115 PO15.1
Element: Requester This is the person who requested this PO15.2 RQ780
requisition.
POA-BUYER-GRP Alpha 5 PO115 PO15.1
Element: Buyer Group The user defined buyer group. PO15.2 RQ780
POA-BUYER Alpha 3 PO115 PO15.1
Element: Buyer PO15.2 RQ780
POA-ACCT-UNIT Alpha 15 RQ780
Element: Accounting UniThe accounting unit is a shorthand
notation representing the variable level
number. When used in the General Ledger
Account Master file, the accounting unit
must be defined in the General Ledger
Names file as a posting accounting unit.
PROCTMPPAR FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POASET1 PROCURE-GROUP PO115 PO15.1
TEMPLATE-REF PO15.2 PO215
COMPANY RQ780 RQIG.1
REQ-LOCATION
REQUESTER
BUYER-GRP
BUYER
POASET2 PROCURE-GROUP KeyChange, Subset PO115 PO20.1
BUYER-GRP Where (BUYER-GRP != Spaces )
TEMPLATE-REF
POASET3 PROCURE-GROUP KeyChange, Subset PO115 PO20.1
BUYER Where (BUYER != Spaces )
TEMPLATE-REF
POASET4 PROCURE-GROUP KeyChange, Subset PO115 PO20.1
COMPANY Where (COMPANY != Zeroes ) RQ10.1 RQIG.1
TEMPLATE-REF And (REQ-LOCATION = Spaces )
POASET5 PROCURE-GROUP KeyChange, Subset PO115 RQ10.1
COMPANY Where (REQ-LOCATION != Spaces ) RQIG.1
REQ-LOCATION And (COMPANY != Zeroes )
TEMPLATE-REF
POASET6 PROCURE-GROUP KeyChange, Subset PO115 RQ10.1
REQUESTER Where (REQUESTER != Spaces ) RQIG.1
TEMPLATE-REF
PROCTMPPAR FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Proctemp PROCTEMP Required
POA-PROCURE-GROUP -> POP-PROCURE-GROUP
POA-TEMPLATE-REF -> POP-TEMPLATE-REF
PROCTMPPAR FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Proctempln PROCTEMPLN
POA-PROCURE-GROUP -> POE-PROCURE-GROUP
POA-TEMPLATE-REF -> POE-TEMPLATE-REF
POE-LINE-NBR
|