IFDICT – No description in the Lawson data dictionary

System
General Ledger Setup (IF)
Prefix
IFD
Primary key
DB-FILE, FLD-NBR
Fields
4
Updated by
1 program
Referenced by
65 programs

IFDICT is a Lawson General Ledger Setup table (prefix IFD); no description in the lawson data dictionary. It is indexed by DB-FILE, FLD-NBR (IFDSET1); alternate indexes: IFDSET2. It is updated by IF588 and referenced by CA91.1, CA91.2, CA91.3, CA91.4, CA91.5, CU91.1, CU91.2, CU91.3 and 57 more. The table has 4 fields, 2 indexes and 0 documented relations.

About IFDICT

No description in the Lawson data dictionary.

Fields (4)

Column = COBOL field name without the IFD- 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
#IFD-FLD-NBR PK
FLD_NBR		Numeric 4—IF588
#IFD-FLD-NAME SET2
FLD_NAME		Alpha 15—IF588
#IFD-DB-FILE PK
DB_FILE		Alpha 3—IF588
#IFD-FLD-NAME-DESC
FLD_NAME_DESC		Alpha 50 (Lower Case)—IF588

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
IFDSET1
  1. DB-FILE
  2. FLD-NBR
PrimaryCA91.1, CA91.2, CA91.3, CA91.4, CA91.5, FB91.1, FB91.2, FB91.3 +22 more (list truncated in source)
IFDSET2
  1. DB-FILE
  2. FLD-NAME
  3. FLD-NBR
CA91.2, MX91.1, MX91.2, MX91.3, MX91.4, MX91.5, MX91.6, MX91.7 +11 more

Programs

Updated by (1)

Referenced by (65)