PROCTEMP

Procurement Template

REFERENCED BY
PO165 PO20.1 PO215 PO65.3 PO65.4 RQ10.1
RQIG.1


UPDATED BY
PO115 PO15.1 PO15.2 PO15.3 PO15.4 PO27.4

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 PO27.3
RQ10.1
POP-TEMPLATE-REF
Element: Template Ref		Alpha 30
PO115 PO15.1
PO15.2 PO15.4
PO20.1 PO27.3
RQ10.1
POP-DESCRIPTION
Element: Description		Alpha 30 (Lower Case)
This field displays the description.
PO115 PO15.1
PO15.2 PO15.4
PO20.1 PO27.3
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 PO27.3
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 PO27.3
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 PO27.3
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
PO27.3 RQ10.1
POP-PARTICIPANT
Element: Participant		Derived
POP-VEN-AGRMT-REF
Element: Agreement Ref		Alpha 30
PO115 PO15.1
PO15.2 PO15.4
PO20.1 PO27.3
RQ10.1
POP-TEMPLT-DOC-NBR
Element: Source Doc N		Numeric 8
PO115 PO15.1
PO15.2 PO15.4
PO20.1 PO27.3
PO27.4 RQ10.1
POP-TEMPLATE-CODE
Element: Template Code		Alpha 4


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 PO165
PO20.1 PO215
PO27.3 PO27.4
PO65.3 PO65.4
RQ10.1 RQIG.1


PROCTEMP FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Povagrmthd POVAGRMTHD Not Required
Valid When POP-VEN-AGRMT-REF !=Spaces
POP-PROCURE-GROUP->PVH-PROCURE-GROUP
POP-VEN-AGRMT-REF->PVH-VEN-AGRMT-REF


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 02:28:09 2016

Home
Contact Us



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