CUCONTROL FILE
Currency Control
The General Ledger Currency Control (CUCONTROL) file stores transaction
currency amounts.
UPDATED BY
GL110 GL146 GL190 GL191 GL196 GL40.1
GL40.2 GL40.3 GL40.7 GL40.8 GL40.9 GL44.1
GL45.1 IFGT.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CLC-COMPANY Numeric 4 GL110 GL146
Company The company number represents an GL190 GL191
established company and is entered on GL196 GL40.1
all function codes. GL40.2 GL40.3
GL40.7 GL40.8
GL40.9 GL44.1
GL45.1 IFGT.1
CLC-FISCAL-YEAR Numeric 4 GL146 GL190
Fiscal Year This is the current fiscal year. This GL191 GL196
field is updated by GL199 (Period GL40.1 GL40.2
Closing). GL40.3 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
IFGT.1
CLC-ACCT-PERIOD Numeric 2 GL146 GL190
Accounting Period This is the current accounting period. GL191 GL196
This field is updated by GL199 (Period GL40.1 GL40.2
Closing). GL40.3 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
IFGT.1
CLC-SYSTEM Alpha 2 GL146 GL190
System A two-character code representing an GL191 GL196
application used within the Lawson GL40.1 GL40.2
system. (i.e.: GL = General Ledger, AP = GL40.3 GL40.7
Accounts Payable, etc.) GL40.8 GL40.9
GL44.1 GL45.1
IFGT.1
CLC-JE-TYPE Alpha 1 GL146 GL190
Journal Entry Type The type of journal entry. Valid values GL191 GL196
are Normal and Intercompany. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
IFGT.1
CLC-CONTROL-GROUP Numeric 8 GL146 GL190
Control Group This field contains the journal entry GL191 GL196
number used for process control of the GL40.1 GL40.2
journal entry detail. GL40.3 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
IFGT.1
CLC-JE-SEQUENCE Numeric 2 GL146 GL190
Sequence Number The journal entry sequence number. GL191 GL196
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
IFGT.1
CLC-CURRENCY-CODE Alpha 5 GL146 GL190
Currency Code This field contains the company base GL191 GL196
currency code established in GL10.1 GL40.1 GL40.2
(Company). GL40.3 GL40.7
GL40.8 GL40.9
GL44.1 GL45.1
IFGT.1
CLC-AMT-TYPE Numeric 1 GL146 GL190
Amount Type The amount type can be either Report GL191 GL196
Currency One or Report Currency Two. GL40.1 GL40.2
GL40.3 GL40.7
1 = Report currency 1 GL40.8 GL40.9
2 = Report currency 2 GL44.1 GL45.1
IFGT.1
CLC-ENTRY-DB Signed 15.2 GL146 GL190
Debit Displays the total debit amount for the GL40.1 GL40.2
journal entry. GL40.3 GL40.7
GL40.8 GL40.9
GL45.1
CLC-ENTRY-CR Signed 15.2 GL146 GL190
Credit Displays the total credit amount for GL40.1 GL40.2
the journal entry. GL40.3 GL40.7
GL40.8 GL40.9
GL45.1
CUCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CLCSET1 COMPANY GL110 GL146
FISCAL-YEAR GL190 GL191
ACCT-PERIOD GL196 GL40.1
SYSTEM GL40.2 GL40.3
JE-TYPE GL40.7 GL40.8
CONTROL-GROUP GL40.9 GL44.1
JE-SEQUENCE GL45.1 IFGT.1
AMT-TYPE
CURRENCY-CODE
|