APDICT – No description in the Lawson data dictionary

System
Accounts Payable (AP)
Prefix
DCT
Primary key
FLD-NBR
Fields
8
Updated by
2 programs
Referenced by
3 programs

APDICT is a Lawson Accounts Payable table (prefix DCT); no description in the lawson data dictionary. It is indexed by FLD-NBR (DCTSET1); alternate indexes: DCTSET2. It is updated by AP788 and AP88.3 and referenced by AP98.1, AP98.2 and AP98.3. The table has 8 fields, 2 indexes and 0 documented relations.

About APDICT

No description in the Lawson data dictionary.

Fields (8)

Column = COBOL field name without the DCT- 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
#DCT-FLD-NBR PK
FLD_NBR		Numeric 4—AP788, AP88.3
#DCT-AUDIT-REC-TYPE
AUDIT_REC_TYPE		Alpha 1—
  • I Invoice
  • V Vendor
AP788, AP88.3
#DCT-DB-FILE-PFX SET2
DB_FILE_PFX		Alpha 3—AP788, AP88.3
#DCT-FLD-NAME
FLD_NAME		Alpha 15—AP788, AP88.3
#DCT-FLD-NAME-DESC
FLD_NAME_DESC		Alpha 50 (Lower Case)—AP788, AP88.3
#DCT-DATA-TYPE
DATA_TYPE		Alpha 1—
  • A Alpha
  • N Numeric
  • D Date
AP788, AP88.3
#DCT-MSG-CATG
MSG_CATG		Alpha 5—AP788, AP88.3
#DCT-MSG-NBR
MSG_NBR		Numeric 3—AP788, AP88.3

Indexes (2)

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
DCTSET1
  1. FLD-NBR
PrimaryAP788, AP88.2, AP88.3, AP98.1, AP98.2, AP98.3
DCTSET2
  1. DB-FILE-PFX
  2. FLD-NBR
KeyChange—

Programs

Updated by (2)

Referenced by (3)