CUCONTROL

Currency Control

The General Ledger Currency Control (CUCONTROL) file stores transaction currency amounts.
UPDATED BY
GL110 GL146 GL167 GL190 GL191 GL196
GL197 GL199 GL310 GL40.1 GL40.2 GL40.3
GL40.6 GL40.7 GL40.8 GL44.1 GL45.1 GL500
IFGT.1 GL300

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CLC-COMPANY
Element: Company		Numeric 4
Identifies 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
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
CLC-FISCAL-YEAR
Element: Year		Numeric 4
Contains the fiscal year for the data stored on this record.
GL146 GL167
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-ACCT-PERIOD
Element: Acct Period		Numeric 2
This is the current accounting period. This field is updated by GL199 (Period Closing).
GL146 GL167
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-SYSTEM
Element: System		Alpha 2
A 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
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-JE-TYPE
Element: Je Type		Alpha 1
The type of journal entry. Valid values are Normal and Intercompany.
GL146 GL167
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-CONTROL-GROUP
Element: Control Group		Numeric 8
This field displays the journal entry number used for process control of the journal entry detail.
GL146 GL167
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-JE-SEQUENCE
Element: Je Sequence		Numeric 2
The journal entry sequence number.
GL146 GL167
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-CURRENCY-CODE
Element: Currency Code		Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
GL146 GL167
GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-AMT-TYPE
Element: Amt Type		Numeric 1
The 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
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-ENTRY-DB
Element: Intl Amt		Signed 18.2
GL146 GL167
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500
CLC-ENTRY-CR
Element: Intl Amt		Signed 18.2
GL146 GL167
GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500
CLC-AUTO-DB
Element: Intl Amt		Signed 18.2
This 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
Element: Intl Amt		Signed 18.2
This 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


CUCONTROL FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CLCSET1 COMPANY
FISCAL-YEAR
ACCT-PERIOD
SYSTEM
JE-TYPE
CONTROL-GROUP
JE-SEQUENCE
AMT-TYPE
CURRENCY-CODE
GL110 GL146
GL167 GL190
GL191 GL196
GL197 GL199
GL300 GL310
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1

File created: Wed Jun 08 20:48:37 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.