PROCTEMP

UPDATED BY
PO15.1 PO15.2 PO15.3 PO15.4 PO215

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

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


PROCTEMP FILE INDEX

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


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: Wed Jun 08 20:50:58 2016

Home
Contact Us



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