POCONTRACT – Contract Description

System
Purchase Order (PO)
Prefix
CMH
Primary key
CONTRACT-GROUP, CM-CONTRACT
Fields
6
Updated by
0 programs
Referenced by
0 programs

POCONTRACT is the Contract Description table in Lawson Purchase Order (prefix CMH). It is indexed by CONTRACT-GROUP, CM-CONTRACT (CMHSET1). It is related 1:1 to POCONTGRP. The table has 6 fields, 1 index and 1 documented relation.

About POCONTRACT

This table contains the contract detail information.

Fields (6)

Column = COBOL field name without the CMH- 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 / columnTypeDescription & valuesUpdated by
#CMH-CONTRACT-GROUP PK
CONTRACT_GROUP		Alpha 4This field contains the identifier for a group of contracts that can be shared by one or more companies.—
#CMH-CM-CONTRACT PK
CM_CONTRACT		Numeric 15——
#CMH-NAME-LONG
NAME_LONG		Alpha 50 (Lower Case)The contract name.—
#CMH-CURRENCY-CODE
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).—
#CMH-CM-CONT-STATUS
CM_CONT_STATUS		Numeric 2—
  • 01 Draft
  • 02 Released
  • 03 Negotiation
  • 04 Approved
  • 05 Ready To Activate
  • 06 Active
  • 07 Inactive
  • 08 Addendum
  • 09 Amendment
—
#CMH-WORKING-CNTRCT
WORKING_CNTRCT		Alpha 30Working contract. The user-defined, non-Lawson contract number. It gives the user the ability to keep their own contract number as an identifier in the Lawson CM system. It defaults from the CM contract number if none is supplied.—

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.

IndexKeysFlagsConditionUsed in
CMHSET1
  1. CONTRACT-GROUP
  2. CM-CONTRACT
PrimaryAP125, AP126, AP133, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
POCONTGRPPOCONTRACT

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PocontgrpPOCONTGRPRequired
CMH-CONTRACT-GROUP→CNG-CONTRACT-GROUP

Programs

No Lawson programs are documented as updating or referencing this table.