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