POCONTACTS – Contacts

System: Purchase Order (PO)
Prefix: POC
Primary key: PROCURE-GROUP, AGRMT-ADMIN
Fields: 11
Updated by: 1 program
Referenced by: 5 programs

POCONTACTS is the Contacts table in Lawson Purchase Order (prefix POC). It is indexed by PROCURE-GROUP, AGRMT-ADMIN (POCSET1). It is related 1:M to POVAGRMTHD. It is updated by PO07.1 and referenced by PO150, PO25.1, PO25.6, PO25.7 and PO536. The table has 11 fields, 1 index and 1 documented relation.

About POCONTACTS

No description in the Lawson data dictionary.

Fields (11)

Column = COBOL field name without the POC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`POC-PROCURE-GROUP` PK 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.	PO07.1
`POC-AGRMT-ADMIN` PK AGRMT_ADMIN	Alpha 10 (Lower Case)	—	PO07.1
`POC-NAME` NAME	Alpha 30 (Lower Case)	Displays the company description.	PO07.1
`POC-INT-PREFIX` INT_PREFIX	Alpha 6	The telephone number country code.	PO07.1
`POC-PHONE-NMBR` PHONE_NMBR	Alpha 15	Phone number.	PO07.1
`POC-PHONE-EXT` PHONE_EXT	Alpha 5	This field contains the telephone extension number.	PO07.1
`POC-FAX-PREFIX` FAX_PREFIX	Alpha 6	The telephone number country code.	PO07.1
`POC-FAX-NMBR` FAX_NMBR	Alpha 15	Phone number.	PO07.1
`POC-FAX-EXT` FAX_EXT	Alpha 5	This field contains the telephone extension number.	PO07.1
`POC-LONG-DESC` LONG_DESC	Alpha 60 (Lower Case)	Long description.	PO07.1
`POC-E-MAIL-ADDRESS` E_MAIL_ADDRESS	Alpha 60 (Lower Case)	e-mail address.	PO07.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`POCSET1`	`PROCURE-GROUP`, `AGRMT-ADMIN`	Primary		PO07.1, PO150, PO25.1, PO25.6, PO25.7, PO536

Relations

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Povagrmthd	POVAGRMTHD			`POC-PROCURE-GROUP` → `PVH-PROCURE-GROUP`, `POC-AGRMT-ADMIN` → `PVH-AGRMT-ADMIN`, → `PVH-VEN-AGRMT-REF`

Programs

Updated by (1)

PO07.1 PO Contacts

Referenced by (5)

PO150 Bid Load to Contract or Catalog
PO25.1 Vendor Agreements
PO25.6 Vendor Agreement Line
PO25.7 Service Agreement Line
PO536 Vendor Price Agreement Load