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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

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

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
PocontgrpPOCONTGRPRequiredCMH-CONTRACT-GROUP → CNG-CONTRACT-GROUP

Programs

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