Lawson Insight Technical Documentation |
|
CUCONTROL
CUCONTROL FILE
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 IFGT.1
GL300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CLC-COMPANY Numeric 4 GL110 GL146
Element: Company The company number represents an GL167 GL190
established company and is entered on GL191 GL196
all function codes. GL197 GL199
GL40.1 GL40.2
GL40.3 GL40.6
GL40.7 GL40.8
GL44.1 GL45.1
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 IFGT.1
CLC-ACCT-PERIOD Numeric 2 GL146 GL167
Element: Current Period GL190 GL191
GL196 GL197
GL199 GL40.1
GL40.2 GL40.3
GL40.6 GL40.7
GL40.8 GL44.1
GL45.1 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 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 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 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 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.7 GL40.8
GL44.1 GL45.1
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.7 GL40.8
GL44.1 GL45.1
IFGT.1
CLC-ENTRY-DB Signed 15.2 GL146 GL167
Element: Auto Debits GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CLC-ENTRY-CR Signed 15.2 GL146 GL167
Element: Auto Credits GL190 GL197
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
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 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
IFGT.1
|