Currency Amount

The Currency Amount file contains a partial chart of accounts for non-base currency transactions. All Lawson subsystems verify the existence of non-base currency accounts against this file. This file also maintains monthly activity and beginning balances for all non-base currency, posting level accounting units. GL190 (Journal Posting) updates this file, and GL191 (Currency Revaluation) revalues the balance sheet accounts. Non-base currency, balance sheet accounts used in revaluation are designated as type 2 amounts. Type 1 amounts are non-base currency account amounts and are not revalued.

REFERENCED BY

GL196	GL290	GL90.1	GL90.4	GL90.6	GL141
GL147	GL191	GL296	GLSV.1	GLOP.1	ML291
GL320	RW80.1	ML290

UPDATED BY

CB222	CA110	CA190	GL110	GL120	GL122
GL146	GL148	GL167	GL190	GL194	GL197
GL199	GL291	GL300	GL310	GL327	GL330
GL40.1	GL40.2	GL40.3	GL40.7	GL40.8	GL44.1
GL45.1	GL500	GL20.2	GLRV.1

FIELD NAME	DESCRIPTION/VALID VALUES	UPDATED BY
CAM-COMPANY Element: Company	Numeric 4 This is the company number for which currency amounts are defined.	CA110 GL110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
CAM-FISCAL-YEAR Element: Fiscal Year	Numeric 4 Key field. This is the fiscal year.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
CAM-AMT-TYPE Element: Amount Type	Numeric 1 Key field. Two amount types are allowed. Use 1 for amounts for non-base account currencies. Use 2 for non-base transaction currency amounts for balance sheet accounts carried in both the base and transaction amounts. Use 3 for Report Currency One. Use 4 for Report Currency Two. 1 = Account Currency Balance 2 = Transaction Balances 3 = Currency One Balance 4 = Currency Two Balance	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
CAM-VAR-LEVELS Element: Variable Level	Alpha 30 Key field. The variable level represents the location of an accounting unit in an organization's level structure.	CA110 GL120 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
CAM-ACCOUNT Element: Account	Numeric 6 Key field. This field and the accounting unit and subaccount define the location (account) where amounts and other account information are stored.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
CAM-SUB-ACCOUNT Element: Subaccount	Numeric 4 Key field. This field and the accounting unit and account define the location (account) where amounts and other account information are stored.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
CAM-ACCT-UNIT Element: Accounting Unit	Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
CAM-CURRENCY-CODE Element: Currency Code	Alpha 5 Key field. This field contains the company's base currency code established in GL10.1 (Company).	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
CAM-CHART-NAME Element: Chart Name	Alpha 12 This is the name you assigned to the chart of accounts when you defined your company structure in the General Ledger system.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1
CAM-CURR-ND Element: currency Code	Numeric 1 This field determines the number of decimal positions for amount fields.	CA110 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
CAM-BASE-ND Base Number of Decimals	Numeric 1 This is the defined number of decimal positions for base amount fields.	CA110 GL146 GL148 GL167 GL190 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
CAM-DB-BEG-BAL Debit Beginning Balance	Signed 18.2 This is the debit beginning balance.	GL110 GL167 GL194 GL199 GL291 GL327 GL330 GL500 GLSV.1 ML291
CAM-CR-BEG-BAL Credit Beginning Balance	Signed 18.2 This is the credit beginning balance.	GL110 GL167 GL194 GL199 GL291 GL327 GL330 GL500 GLSV.1 ML291
CAM-BASE-DB-BBAL Base Currency Debit Balance	Signed 18.2 This is the base currency debit balance.	GL110 GL167 GL199 GL327 GL330 GL500
CAM-BASE-CR-BBAL Base Currency Credit Balance	Signed 18.2 This is the base currency credit balance.	GL110 GL167 GL199 GL327 GL330 GL500
CAM-RPT1-DB-BBAL Report One Debit Beg Balance	Signed 18.2 The Report One currency debit beginning balance.	GL110 GL167 GL199 GL310 GL327 GL330
CAM-RPT1-CR-BBAL Report One Credit Beg Balance	Signed 18.2 The Report One currency credit beginning balance.	GL110 GL167 GL199 GL310 GL327 GL330
CAM-RPT2-DB-BBAL Report Two Debit Beg Balance	Signed 18.2 The Report Two currency debit beginning balance.	GL110 GL167 GL199 GL310 GL327 GL330
CAM-RPT2-CR-BBAL Report Two Credit Beg Balance	Signed 18.2 The Report Two currency credit beginning balance.	GL110 GL167 GL199 GL310 GL327 GL330
CAM-DB-AMOUNT Element: Budget Debit Amount	Signed 18.2 Occurs 13 Times This is the currency debit amount.	GL110 GL146 GL148 GL167 GL190 GL197 GL291 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1 ML291
CAM-CR-AMOUNT Element: Budget Credit Amount	Signed 18.2 Occurs 13 Times This is the currency credit amount.	GL110 GL146 GL148 GL167 GL190 GL197 GL291 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500 GLSV.1 ML291
CAM-BASE-DB-AMT Period Base Debit Amount	Signed 18.2 Occurs 13 Times This is the base debit amount for the period.	GL110 GL146 GL148 GL167 GL190 GL197 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
CAM-BASE-CR-AMT Period Base Credit Amount	Signed 18.2 Occurs 13 Times This is the base credit amount for the period.	GL110 GL146 GL148 GL167 GL190 GL197 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500
CAM-RPT1-DB-AMT Report One Debit Amount	Signed 18.2 Occurs 13 Times The Report One currency debit amount for the period.	GL110 GL146 GL148 GL167 GL190 GL197 GL310 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
CAM-RPT1-CR-AMT Report One Credit Amount	Signed 18.2 Occurs 13 Times The Report One currency credit amount for the period.	GL110 GL146 GL148 GL167 GL190 GL197 GL310 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
CAM-RPT2-DB-AMT Report Two Debit Amount	Signed 18.2 Occurs 13 Times The Report Two currency debit amount for the period.	GL110 GL146 GL148 GL167 GL190 GL197 GL310 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
CAM-RPT2-CR-AMT Report Two Credit Amount	Signed 18.2 Occurs 13 Times The Report Two currency credit amount for the period.	GL110 GL146 GL148 GL167 GL190 GL197 GL310 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1
CAM-MAINT-DATE Element: Maintenance Date	Numeric 8 (yyyymmdd) The date last changed.	GL194
CAM-MAINT-TIME Element: Maintenance Time	Numeric 6 (hhmmss)	GL194
CAM-CPAMT-DR Current Per Currency Dr Amount	Derived This is the currency debit amount for the current period.
CAM-CPAMT-CR Current Per Currency Cr Amount	Derived This is the currency credit amount for the current period.
CAM-CPAMT Current Period Currency Amount	Derived This is the currency amount for the current period.
CAM-CUR-PD-SUM-A-D Current Per Base Dr Amount	Derived This is the base debit amount for the current period.
CAM-CUR-PD-SUM-A-C Current Per Base Cr Amount	Derived This is the base credit amount for the current period.
CAM-CYBAMT Current Year Beg Base Amount	Derived This is the beginning base amount for the current year.
CAM-CYDAMT Current Per Base Amt to Date	Derived This is the base amount to date for the current period.
CAM-CYPAMT1-DR Period 1 Base Debit Amount	Derived This is the period 1 base debit amount.
CAM-CYPAMT1-CR Period 1 Base Credit Amount	Derived This is the period 1 base credit amount.
CAM-CYPYTD1 Period 1 Year to Date Amount	Derived Current year period year to date period 1.
CAM-CYPAMT2-DR Period 2 Base Debit Amount	Derived This is the period 2 base debit amount.
CAM-CYPAMT2-CR Period 2 Base Credit Amount	Derived This is the period 2 base credit amount.
CAM-CYPYTD2 Period 2 Year to Date Amount	Derived Current year period year to date period 2.
CAM-CYPAMT3-DR Period 3 Base Debit Amount	Derived This is the period 3 base debit amount.
CAM-CYPAMT3-CR Period 3 Base Credit Amount	Derived This is the period 3 base credit amount.
CAM-CYPYTD3 Period 3 Year to Date Amount	Derived Current year period year to date period 3.
CAM-CYPAMT4-DR Period 4 Base Debit Amount	Derived This is the period 4 base debit amount.
CAM-CYPAMT4-CR Period 4 Base Credit Amount	Derived This is the period 4 base credit amount.
CAM-CYPYTD4 Period 4 Year to Date Amount	Derived Current year period year to date period 4.
CAM-CYPAMT5-DR Period 5 Base Debit Amount	Derived This is the period 5 base debit amount.
CAM-CYPAMT5-CR Period 5 Base Credit Amount	Derived This is the period 5 base credit amount.
CAM-CYPYTD5 Period 5 Year to Date Amount	Derived Current year period year to date period 5.
CAM-CYPAMT6-DR Period 6 Base Debit Amount	Derived This is the period 6 base debit amount.
CAM-CYPAMT6-CR Period 6 Base Credit Amount	Derived This is the period 6 base credit amount.
CAM-CYPYTD6 Period 6 Year to Date Amount	Derived Current year period year year to date period 6.
CAM-CYPAMT7-DR Period 7 Base Debit Amount	Derived This is the period 7 base debit amount.
CAM-CYPAMT7-CR Period 7 Base Credit Amount	Derived This is the period 7 base credit amount.
CAM-CYPYTD7 Period 7 Year to Date Amount	Derived Current year period year to date period 7.
CAM-CYPAMT8-DR Period 8 Base Debit Amount	Derived This is the period 8 base debit amount.
CAM-CYPAMT8-CR Period 8 Base Credit Amount	Derived This is the period 8 base credit amount.
CAM-CYPYTD8 Period 8 Year to Date Amount	Derived Current year period year to date period 8.
CAM-CYPAMT9-DR Period 9 Base Debit Amount	Derived This is the period 9 base debit amount.
CAM-CYPAMT9-CR Period 9 Base Credit Amount	Derived This is the period 9 base credit amount.
CAM-CYPYTD9 Period 9 Year to Date Amount	Derived Current year period year to date period 9.
CAM-CYPAMT10-DR Period 10 Base Debit Amount	Derived This is the period 10 base debit amount.
CAM-CYPAMT10-CR Period 10 Base Credit Amount	Derived This is the period 10 base credit amount.
CAM-CYPYTD10 Period 10 Year to Date Amount	Derived Current year period year to date period 10.
CAM-CYPAMT11-DR Period 11 Base Debit Amount	Derived This is the period 11 base debit amount.
CAM-CYPAMT11-CR Period 11 Base Credit Amount	Derived This is the period 11 base credit amount.
CAM-CYPYTD11 Period 11 Year to Date Amount	Derived Current year period year to date period 11.
CAM-CYPAMT12-DR Period 12 Base Debit Amount	Derived This is the period 12 base debit amount.
CAM-CYPAMT12-CR Period 12 Base Credit Amount	Derived This is the period 12 base credit amount.
CAM-CYPYTD12 Period 12 Year to Date Amount	Derived Current year period year to date period 12.
CAM-CYPAMT13-DR Period 13 Base Debit Amount	Derived This is the period 13 base debit amount.
CAM-CYPAMT13-CR Period 13 Base Credit Amount	Derived This is the period 13 base credit amount.
CAM-CYPYTD13 Period 13 Year to Date Amount	Derived Current year period year to date period 13.
CAM-CPCUR-DR Current Period Debit Amount	Derived This is the current period debit amount.
CAM-CPCUR-CR Current Period Credit Amount	Derived This is the current period credit amount.
CAM-CPCUR Current Period Amount	Derived This is the current period amount.
CAM-CUR-PD-SUM-C-D Year-to-Date Debit Amount	Derived This is the year-to-date debit amount.
CAM-CUR-PD-SUM-C-C Year-to-Date Credit Amount	Derived This is the year-to-date credit amount.
CAM-CYBCUR Element: Beginning Balance	Derived This is the beginning balance.
CAM-CYDCUR Element: Balance to Date	Derived This is the balance to date.
CAM-CYPCUR1-DR Per 1 Currency Debit Amount	Derived This is the period 1 currency debit amount.
CAM-CYPCUR1-CR Per 1 Currency Credit Amount	Derived This is the period 1 currency credit amount.
CAM-CURYTD1 Per 1 Curr Year to Date Amt	Derived Currency current year period year to date period 1.
CAM-CYPCUR2-DR Per 2 Currency Debit Amount	Derived This is the period 2 currency debit amount.
CAM-CYPCUR2-CR Per 2 Currency Credit Amount	Derived This is the period 2 currency credit amount.
CAM-CURYTD2 Per 2 Curr Year to Date Amt	Derived Currency current year period year to date period 2.
CAM-CYPCUR3-DR Per 3 Currency Debit Amount	Derived This is the period 3 currency debit amount.
CAM-CYPCUR3-CR Per 3 Currency Credit Amount	Derived This is the period 3 currency credit amount.
CAM-CURYTD3 Per 3 Curr Year to Date Amt	Derived Currency current year period year to date period 3.
CAM-CYPCUR4-DR Per 4 Currency Debit Amount	Derived This is the period 4 currency debit amount.
CAM-CYPCUR4-CR Per 4 Currency Credit Amount	Derived This is the period 4 currency credit amount.
CAM-CURYTD4 Per 4 Curr Year to Date Amt	Derived Currency current year period year to date period 4.
CAM-CYPCUR5-DR Per 5 Currency Debit Amount	Derived This is the period 5 currency debit amount.
CAM-CYPCUR5-CR Per 5 Currency Credit Amount	Derived This is the period 5 currency credit amount.
CAM-CURYTD5 Per 5 Curr Year to Date Amt	Derived Currency current year period year to date period 5.
CAM-CYPCUR6-DR Per 6 Currency Debit Amount	Derived This is the period 6 currency debit amount.
CAM-CYPCUR6-CR Per 6 Currency Credit Amount	Derived This is the period 6 currency credit amount.
CAM-CURYTD6 Per 6 Curr Year to Date Amt	Derived Currency current year period year to date period 6.
CAM-CYPCUR7-DR Per 7 Currency Debit Amount	Derived This is the period 7 currency debit amount.
CAM-CYPCUR7-CR Per 7 Currency Credit Amount	Derived This is the period 7 currency credit amount.
CAM-CURYTD7 Per 8 Curr Year to Date Amt	Derived Currency current year period year to date period 7.
CAM-CYPCUR8-DR Per 8 Currency Debit Amount	Derived This is the period 8 currency debit amount.
CAM-CYPCUR8-CR Per 8 Currency Credit Amount	Derived This is the period 8 currency credit amount.
CAM-CURYTD8 Per 8 Curr Year to Date Amt	Derived Currency current year period year to date period 8.
CAM-CYPCUR9-DR Per 9 Currency Debit Amount	Derived This is the period 9 currency debit amount.
CAM-CYPCUR9-CR Per 9 Currency Credit Amount	Derived This is the period 9 currency credit amount.
CAM-CURYTD9 Per 9 Curr Year to Date Amt	Derived Currency current year period year to date period 9.
CAM-CYPCUR10-DR Per 10 Currency Debit Amount	Derived This is the period 10 currency debit amount.
CAM-CYPCUR10-CR Per 10 Currency Credit Amount	Derived This is the period 10 currency credit amount.
CAM-CURYTD10 Per 10 Curr Year to Date Amt	Derived Currency current year period year to date period 10.
CAM-CYPCUR11-DR Per 11 Currency Debit Amount	Derived This is the period 11 currency debit amount.
CAM-CYPCUR11-CR Per 11 Currency Credit Amount	Derived This is the period 11 currency credit amount.
CAM-CURYTD11 Per 11 Curr Year to Date Amt	Derived Currency current year period year to date period 11.
CAM-CYPCUR12-DR Per 12 Currency Debit Amount	Derived This is the period 12 currency debit amount.
CAM-CYPCUR12-CR Per 12 Currency Credit Amount	Derived This is the period 12 currency credit amount.
CAM-CURYTD12 Per 12 Curr year to Date Amt	Derived Currency current year period year to date period 12.
CAM-CYPCUR13-DR Per 13 Currency Debit Amount	Derived This is the period 13 currency debit amount.
CAM-CYPCUR13-CR Per 13 Currency Credit Amount	Derived This is the period 13 currency credit amount.
CAM-CURYTD13 Per 13 Curr Year to Date Amt	Derived Currency current year period year to date period 13.
CAM-BLANK Element: Blank	Derived This derived field is always blank. It is used in drill around to allow for column headings.
CAM-CPAMT-THOU Current Period Amount Thousand	Derived The current period base amount divided by 1,000.
CAM-CYDAMT-THOU Current YTD Amount Thousands	Derived The current year-to-date base amount divided by 1,000.
CAM-CPCUR-THOU Current Per Curr Amt Thousand	Derived The current year-to-date currency amount divided by 1,000.
CAM-CYDCUR-THOU Current YTD Curreny Amt Thou	Derived The current year-to-date currency amount divided by 1,000.
CAM-PARENT-VAR-LEV Parent Variable Level	Alpha 30 The variable level address of the parent accounting unit.	CA110 GL120 GL146 GL148 GL167 GL190 GL194 GL197 GL199 GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500

CUAMOUNT FILE INDEX

CUAMOUNT FILE RELATIONS

ONE TO ONE RELATIONS

CUAMOUNT FILE RELATIONS

ONE TO MANY RELATIONS

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