POCODE – Purchase Order Codes

System
Purchase Order (PO)
Prefix
POO
Primary key
PROCURE-GROUP, PO-CODE
Fields
6
Updated by
229 programs
Referenced by
8 programs

POCODE is the Purchase Order Codes table in Lawson Purchase Order (prefix POO). It is indexed by PROCURE-GROUP, PO-CODE (POOSET1). It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 221 more and referenced by MA205, MAPC.1, PO223, PO254, PO525, PO529, RQ260 and RQ504. The table has 6 fields, 1 index and 0 documented relations.

About POCODE

No description in the Lawson data dictionary.

Fields (6)

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

Field / columnTypeDescription & valuesUpdated by
POO-PROCURE-GROUP PK
PROCURE_GROUP
Alpha 4This field contains the identifier for a group of companies that share a common procurement effort. They buy items and services together.PO00.1, PO03.1, PO05.1
POO-PO-CODE PK
PO_CODE
Alpha 4This is the purchase order code.PO00.1, PO03.1, PO05.1
POO-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.PO00.1, PO03.1, PO05.1
POO-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The status of the PO code. If Inactive, no more purchase orders can be created using this code.
  • A Active
  • I Inactive
PO00.1, PO03.1, PO05.1
POO-USED-FLAG
USED_FLAG
Alpha 1Indicates if the record has been accessed by some source after creation. If the record has been accessed, it cannot be deleted, it must be inactivated.
  • Y Used
  • N Unused
  • P Used For Price Agreements
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
POO-CONSIGN-CODE
CONSIGN_CODE
Alpha 2PO05.1

Indexes (1)

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

IndexKeysFlagsConditionUsed in
POOSET1PROCURE-GROUP, PO-CODEPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)

Programs

Updated by (229)

Referenced by (8)