ACJOURNLCD – Activity Journal Code

System
AC Billing Revenue (BR)
Prefix
JCD
Primary key
JOURNAL-CODE
Fields
6
Updated by
1 program
Referenced by
8 programs

ACJOURNLCD is the Activity Journal Code table in Lawson AC Billing Revenue (prefix JCD). It is indexed by JOURNAL-CODE (JCDSET1). It is updated by BR12.1 and referenced by AC04.1, AC56.1, AC560, BR10.1, BR130, BR140, BR47.1 and BR530. The table has 6 fields, 1 index and 0 documented relations.

About ACJOURNLCD

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the JCD- 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
#JCD-JOURNAL-CODE PK
JOURNAL_CODE
Alpha 4—BR12.1
#JCD-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field displays the description.BR12.1
#JCD-GL-CODE-DB
GL_CODE_DB
Alpha 4—BR12.1
#JCD-ACCOUNT-CAT-DB
ACCOUNT_CAT_DB
Alpha 5—BR12.1
#JCD-GL-CODE-CR
GL_CODE_CR
Alpha 4—BR12.1
#JCD-ACCOUNT-CAT-CR
ACCOUNT_CAT_CR
Alpha 5—BR12.1

Indexes (1)

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
JCDSET1
  1. JOURNAL-CODE
PrimaryAC04.1, AC56.1, AC560, BR10.1, BR12.1, BR130, BR140, BR47.1 +1 more

Programs

Updated by (1)

Referenced by (8)