Lawson Insight Technical Documentation |
|
CUCONTROL
CUCONTROL FILE
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 Numeric 4 GL110 GL146
Element: Company Identifies the AP company if the GL167 GL190
resource type = V. Identifies the HR GL191 GL196
company if the resource type = E. It is GL197 GL199
blank for type A, P or Q resources. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500 IFGT.1
CLC-FISCAL-YEAR Numeric 4 GL146 GL167
Element: Last Closed YeThis is the current fiscal year. This GL190 GL191
field is updated by Period Closing GL196 GL197
(GL199). GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-ACCT-PERIOD Numeric 2 GL146 GL167
Element: Account PeriodThis is the current accounting period. GL190 GL191
This field is updated by GL199 (Period GL196 GL197
Closing). GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-SYSTEM Alpha 2 GL146 GL167
Element: System Code A two-character code representing an GL190 GL191
application used within the Lawson GL196 GL197
system. (i.e.: GL = General Ledger, AP = GL199 GL40.1
Accounts Payable, etc.) GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-JE-TYPE Alpha 1 GL146 GL167
Element: Journal Entry The type of journal entry. Valid values GL190 GL191
are Normal and Intercompany. 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 Numeric 8 GL146 GL167
Element: Control GroupsThis field displays the journal entry GL190 GL191
number used for process control of the GL196 GL197
journal entry detail. GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-JE-SEQUENCE Numeric 2 GL146 GL167
Journal Entry The journal entry sequence number. GL190 GL191
Sequence Number 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 Alpha 5 GL146 GL167
Element: Currency Code This field contains the company base GL190 GL191
currency code established in Company GL196 GL197
(GL10.1 ). GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-AMT-TYPE Numeric 1 GL146 GL167
Element: Amount Type The amount type can be either Report GL190 GL191
Currency One or Report Currency Two. GL196 GL197
GL199 GL40.1
1 = Report currency 1 GL40.2 GL40.3
2 = Report currency 2 GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 GL500
IFGT.1
CLC-ENTRY-DB Signed 18.2 GL146 GL167
Element: Intl Amt Displays the total debit amount for the GL190 GL197
journal entry. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500
CLC-ENTRY-CR Signed 18.2 GL146 GL167
Element: Intl Amt Displays the total credit amount for GL190 GL197
the journal entry. GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
GL500
CLC-AUTO-DB Signed 18.2 GL40.1 GL40.2
Element: Intl Amt This field will store the Auto Reverse GL40.3 GL40.6
Total Debits for a Journal Entry for GL40.7 GL40.8
Report Currency 1 and Report 2. GL45.1 GL500
CLC-AUTO-CR Signed 18.2 GL40.1 GL40.2
Element: Intl Amt This field will store the Auto Reverse GL40.3 GL40.6
Total Credits for a Journal Entry for GL40.7 GL40.8
Report Currency 1 and Report Currency 2. GL45.1 GL500
CUCONTROL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CLCSET1 COMPANY GL110 GL146
FISCAL-YEAR GL167 GL190
ACCT-PERIOD GL191 GL196
SYSTEM GL197 GL199
JE-TYPE GL300 GL310
CONTROL-GROUP GL40.1 GL40.2
JE-SEQUENCE GL40.3 GL40.6
AMT-TYPE GL40.7 GL40.8
CURRENCY-CODE GL44.1 GL45.1
GL500 IFGT.1
|