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. PK = primary key (present in every index); SETn = leading/alternate key of that index.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
#POC-PROCURE-GROUP PKPROCURE_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 PKAGRMT_ADMIN | Alpha 10 (Lower Case) | — | PO07.1 |
#POC-NAMENAME | Alpha 30 (Lower Case) | Displays the company description. | PO07.1 |
#POC-INT-PREFIXINT_PREFIX | Alpha 6 | The telephone number country code. | PO07.1 |
#POC-PHONE-NMBRPHONE_NMBR | Alpha 15 | Phone number. | PO07.1 |
#POC-PHONE-EXTPHONE_EXT | Alpha 5 | This field contains the telephone extension number. | PO07.1 |
#POC-FAX-PREFIXFAX_PREFIX | Alpha 6 | The telephone number country code. | PO07.1 |
#POC-FAX-NMBRFAX_NMBR | Alpha 15 | Phone number. | PO07.1 |
#POC-FAX-EXTFAX_EXT | Alpha 5 | This field contains the telephone extension number. | PO07.1 |
#POC-LONG-DESCLONG_DESC | Alpha 60 (Lower Case) | Long description. | PO07.1 |
#POC-E-MAIL-ADDRESSE_MAIL_ADDRESS | Alpha 60 (Lower Case) | e-mail address. | PO07.1 |
Indexes (1)
Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
POCSET1 |
| 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 |
|
Programs
Updated by (1)
- PO07.1 PO Contacts