CUCONTROL – Currency Control

System
General Ledger (GL)
Prefix
CLC
Primary key
COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, AMT-TYPE, CURRENCY-CODE
Fields
13
Updated by
20 programs
Referenced by
0 programs

CUCONTROL is the Currency Control table in Lawson General Ledger (prefix CLC). It is indexed by COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, AMT-TYPE, CURRENCY-CODE (CLCSET1). It is updated by GL110, GL146, GL167, GL190, GL191, GL196, GL197, GL199 and 12 more. The table has 13 fields, 1 index and 0 documented relations.

About CUCONTROL

No description in the Lawson data dictionary.

Fields (13)

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

Field / columnTypeDescription & valuesUpdated by
CLC-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.GL110, GL146, GL167, GL190, GL191, GL196, GL197, GL199 +10 more
CLC-FISCAL-YEAR PK
FISCAL_YEAR		Numeric 4Contains the fiscal year for the data stored on this record.GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
CLC-ACCT-PERIOD PK
ACCT_PERIOD		Numeric 2This is the current accounting period. This field is updated by GL199 (Period Closing).GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
CLC-SYSTEM PK
SYSTEM		Alpha 2A two-character code representing an application used within the Lawson system. (i.e.: GL = General Ledger, AP = Accounts Payable, etc.)GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
CLC-JE-TYPE PK
JE_TYPE		Alpha 1The type of journal entry. Valid values are Normal and Intercompany.GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
CLC-CONTROL-GROUP PK
CONTROL_GROUP		Numeric 8This field displays the journal entry number used for process control of the journal entry detail.GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
CLC-JE-SEQUENCE PK
JE_SEQUENCE		Numeric 2The journal entry sequence number.GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
CLC-CURRENCY-CODE PK
CURRENCY_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
CLC-AMT-TYPE PK
AMT_TYPE		Numeric 1The amount type can be either Report Currency One or Report Currency Two.
  • 1 Report currency 1
  • 2 Report currency 2
GL146, GL167, GL190, GL191, GL196, GL197, GL199, GL40.1 +9 more
CLC-ENTRY-DB
ENTRY_DB		Signed 18.2—GL146, GL167, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.6 +5 more
CLC-ENTRY-CR
ENTRY_CR		Signed 18.2—GL146, GL167, GL190, GL197, GL40.1, GL40.2, GL40.3, GL40.6 +5 more
CLC-AUTO-DB
AUTO_DB		Signed 18.2This field will store the Auto Reverse Total Debits for a Journal Entry for Report Currency 1 and Report 2.GL40.1, GL40.2, GL40.3, GL40.6, GL40.7, GL40.8, GL45.1, GL500
CLC-AUTO-CR
AUTO_CR		Signed 18.2This field will store the Auto Reverse Total Credits for a Journal Entry for Report Currency 1 and Report Currency 2.GL40.1, GL40.2, GL40.3, GL40.6, GL40.7, GL40.8, GL45.1, GL500

Indexes (1)

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

IndexKeysFlagsConditionUsed in
CLCSET1COMPANY, FISCAL-YEAR, ACCT-PERIOD, SYSTEM, JE-TYPE, CONTROL-GROUP, JE-SEQUENCE, AMT-TYPE, CURRENCY-CODEPrimaryGL110, GL146, GL167, GL190, GL191, GL196, GL197, GL199 +12 more

Programs

Updated by (20)