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
GL141 | GL147 | GL191 | GL291 | GL296 | GLSV.1 |
GLOP.1 | GLRV.1 | ML291 | GL196 | GL320 | GL290 |
RW80.1 | ML290 | CB222 | GL90.1 | GL90.4 | GL90.6 |
CA110 | CA190 | GL110 | GL120 | GL146 | GL148 |
GL167 | GL190 | GL194 | GL197 | GL199 | GL300 |
GL310 | GL327 | GL330 | GL40.1 | GL40.2 | GL40.3 |
GL40.7 | GL40.8 | GL44.1 | GL45.1 | GL500 | GL122 |
GL20.2 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CAM-COMPANY Element: Company | Numeric 4 This is the company number for which currency amounts are defined. |
|
||||||||||||||||||||
CAM-FISCAL-YEAR Element: Fiscal Year | Numeric 4 Key field. This is the fiscal year. |
|
||||||||||||||||||||
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 |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
CAM-CURRENCY-CODE Element: Currency Code | Alpha 5 Key field. This field contains the company's base currency code established in GL10.1 (Company). |
|
||||||||||||||||||||
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. |
|
||||||||||||||||||||
CAM-CURR-ND Element: currency Code | Numeric 1 This field determines the number of decimal positions for amount fields. |
|
||||||||||||||||||||
CAM-BASE-ND Base Number of Decimals | Numeric 1 This is the defined number of decimal positions for base amount fields. |
|
||||||||||||||||||||
CAM-DB-BEG-BAL Debit Beginning Balance | Signed 18.2 This is the debit beginning balance. |
|
||||||||||||||||||||
CAM-CR-BEG-BAL Credit Beginning Balance | Signed 18.2 This is the credit beginning balance. |
|
||||||||||||||||||||
CAM-BASE-DB-BBAL Base Currency Debit Balance | Signed 18.2 This is the base currency debit balance. |
|
||||||||||||||||||||
CAM-BASE-CR-BBAL Base Currency Credit Balance | Signed 18.2 This is the base currency credit balance. |
|
||||||||||||||||||||
CAM-RPT1-DB-BBAL Report One Debit Beg Balance | Signed 18.2 The Report One currency debit beginning balance. |
|
||||||||||||||||||||
CAM-RPT1-CR-BBAL Report One Credit Beg Balance | Signed 18.2 The Report One currency credit beginning balance. |
|
||||||||||||||||||||
CAM-RPT2-DB-BBAL Report Two Debit Beg Balance | Signed 18.2 The Report Two currency debit beginning balance. |
|
||||||||||||||||||||
CAM-RPT2-CR-BBAL Report Two Credit Beg Balance | Signed 18.2 The Report Two currency credit beginning balance. |
|
||||||||||||||||||||
CAM-DB-AMOUNT Element: Budget Debit Amount | Signed 18.2 Occurs 13 Times This is the currency debit amount. |
|
||||||||||||||||||||
CAM-CR-AMOUNT Element: Budget Credit Amount | Signed 18.2 Occurs 13 Times This is the currency credit amount. |
|
||||||||||||||||||||
CAM-BASE-DB-AMT Period Base Debit Amount | Signed 18.2 Occurs 13 Times This is the base debit amount for the period. |
|
||||||||||||||||||||
CAM-BASE-CR-AMT Period Base Credit Amount | Signed 18.2 Occurs 13 Times This is the base credit amount for the period. |
|
||||||||||||||||||||
CAM-RPT1-DB-AMT Report One Debit Amount | Signed 18.2 Occurs 13 Times The Report One currency debit amount for the period. |
|
||||||||||||||||||||
CAM-RPT1-CR-AMT Report One Credit Amount | Signed 18.2 Occurs 13 Times The Report One currency credit amount for the period. |
|
||||||||||||||||||||
CAM-RPT2-DB-AMT Report Two Debit Amount | Signed 18.2 Occurs 13 Times The Report Two currency debit amount for the period. |
|
||||||||||||||||||||
CAM-RPT2-CR-AMT Report Two Credit Amount | Signed 18.2 Occurs 13 Times The Report Two currency credit amount for the period. |
|
||||||||||||||||||||
CAM-MAINT-DATE Element: Maintenance Date | Numeric 8 (yyyymmdd) The date last changed. |
|
||||||||||||||||||||
CAM-MAINT-TIME Element: Maintenance Time | Numeric 6 (hhmmss) |
|
||||||||||||||||||||
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. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
CAMSET1 |
FISCAL-YEAR COMPANY AMT-TYPE VAR-LEVELS ACCOUNT SUB-ACCOUNT ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||||||||||||||
CAMSET2 |
FISCAL-YEAR COMPANY AMT-TYPE CURRENCY-CODE ACCOUNT SUB-ACCOUNT VAR-LEVELS ACCT-UNIT |
|
| ||||||||||||||||||||||||||||||||||||
CAMSET3 |
AMT-TYPE FISCAL-YEAR COMPANY VAR-LEVELS ACCOUNT SUB-ACCOUNT ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||||||||||||||
CAMSET4 |
AMT-TYPE FISCAL-YEAR COMPANY ACCOUNT SUB-ACCOUNT VAR-LEVELS ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||||||||||||||
CAMSET5 |
COMPANY ACCT-UNIT ACCOUNT SUB-ACCOUNT AMT-TYPE CURRENCY-CODE FISCAL-YEAR VAR-LEVELS |
|
| ||||||||||||||||||||||||||||||||||||
CAMSET6 |
AMT-TYPE FISCAL-YEAR VAR-LEVELS ACCOUNT SUB-ACCOUNT COMPANY ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||||||||||||||
CAMSET7 |
AMT-TYPE FISCAL-YEAR ACCOUNT SUB-ACCOUNT VAR-LEVELS COMPANY ACCT-UNIT CURRENCY-CODE |
|
| ||||||||||||||||||||||||||||||||||||
CAMSET9 |
PARENT-VAR-LEV AMT-TYPE COMPANY ACCOUNT SUB-ACCOUNT FISCAL-YEAR ACCT-UNIT VAR-LEVELS CURRENCY-CODE |
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Chart Detail | GLCHARTDTL |
Required
| ||||||||||||||||||
Company | GLSYSTEM |
Required
| ||||||||||||||||||
Cucodes | CUCODES |
Required
| ||||||||||||||||||
Gam Sibling | GLAMOUNTS |
Not Required
| ||||||||||||||||||
Glmaster | GLMASTER |
Required
| ||||||||||||||||||
Glnames | GLNAMES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Consol Parent1 | GLCONSOL |
| |||||||||||||||||||||||||||||||||||||||
Consol Parent2 | GLCONSOL |
| |||||||||||||||||||||||||||||||||||||||
Cuconv | CUCONV |
| |||||||||||||||||||||||||||||||||||||||
Curr 1 | CUAMOUNT |
| |||||||||||||||||||||||||||||||||||||||
Curr 2 | CUAMOUNT |
| |||||||||||||||||||||||||||||||||||||||
Gltrans 1 Prd | GLTRANS |
| |||||||||||||||||||||||||||||||||||||||
Gltrans 1 Year | GLTRANS |
|
All trademarks and registered trademarks are the property of their
respective owners.