APCERTCODE – Accounts Payable Cert Code

System
Accounts Payable (AP)
Prefix
CER
Primary key
CERTIF-CODE
Fields
3
Updated by
1 program
Referenced by
4 programs

APCERTCODE is the Accounts Payable Cert Code table in Lawson Accounts Payable (prefix CER). It is indexed by CERTIF-CODE (CERSET1). It is updated by AP13.3 and referenced by AP14.3, AP210, AP51.8 and PO240. The table has 3 fields, 1 index and 0 documented relations.

About APCERTCODE

No description in the Lawson data dictionary.

Fields (3)

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

Field / columnTypeDescription & valuesUpdated by
CER-CERTIF-CODE PK
CERTIF_CODE
Alpha 10User defined code representing certifications.AP13.3
CER-CERTIF-DESC
CERTIF_DESC
Alpha 30Description of the Certification Code.AP13.3
CER-ACTIVE-STATUS
ACTIVE_STATUS
Alpha 1The status of the account. If Inactive, certification can not be used.
  • A Active
  • I Inactive
AP13.3

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CERSET1CERTIF-CODEPrimaryAP13.3, AP14.3, AP210, AP51.8, PO240

Programs

Updated by (1)

Referenced by (4)