PROCTEMP

REFERENCED BY
RQIG.1


UPDATED BY
PO115 PO15.1 PO15.2 PO15.3 PO15.4 PO20.1
PO215 RQ10.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
POP-PROCURE-GROUP
Element: Procure Group
Alpha 4
Type or select a procurement group. A procurement group is a group of companies that share a common procurement effort. They buy items and services together.
PO115 PO15.1
PO15.2 PO15.4
PO20.1 RQ10.1
POP-TEMPLATE-REF
Element: Template Ref
Alpha 30
PO115 PO15.1
PO15.2 PO15.4
PO20.1 RQ10.1
POP-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field displays the description.
PO115 PO15.1
PO15.2 PO15.4
PO20.1 RQ10.1
POP-LAST-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the line number.
PO115 PO15.1
PO15.2 PO15.4
PO20.1 RQ10.1
POP-FROM-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.
PO115 PO15.1
PO15.2 PO15.4
PO20.1 RQ10.1
POP-FROM-LOCATION
Element: Location
Alpha 5
This field contains a valid stocking location within the company inventory.
PO115 PO15.1
PO15.2 PO15.4
PO20.1 RQ10.1
POP-LOCK-FLAG
Element: Lock Flag
Numeric 1

0 = Not Locked
1 = Locked
PO115 PO15.1
PO15.2 PO15.3
PO15.4 PO20.1
RQ10.1
POP-PARTICIPANT
Element: Participant
Derived


PROCTEMP FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
POPSET1 PROCURE-GROUP
TEMPLATE-REF
PO115 PO15.1
PO15.2 PO15.3
PO15.4 PO20.1
PO215 RQ10.1
RQIG.1


PROCTEMP FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED 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


File created: Thu Jun 09 11:25:18 2016

Home
Contact Us



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