|
|
CUAMOUNT FILE
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
GL191 GL291 GL296 GLSV.1 GLOP.1 GLRV.1
GL196 GL320 GL290 RW80.1 GL122 GL90.1
GL90.4 GL00.7
UPDATED BY
GL110 GL120 GL146 GL167 GL190 GL199
GL300 GL327 GL330 GL45.1 GL500 GL20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAM-COMPANY Numeric 4 GL110 GL146
Company This is the company number you are GL167 GL190
defining currency amounts for. GL199 GL327
GL330 GL45.1
GL500 GLSV.1
CAM-FISCAL-YEAR Numeric 4 GL146 GL167
Fiscal Year Key field. This is the fiscal year. GL190 GL199
GL327 GL330
GL45.1 GL500
GLSV.1
CAM-AMT-TYPE Numeric 1 GL146 GL167
Amount Type Key field. Two amount types are GL190 GL199
allowed. Use 1 for amounts for non-base GL327 GL330
account currencies. Use 2 for non-base GL45.1 GL500
transaction currency amounts for balance GLSV.1
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 Alpha 30 GL120 GL146
Variable Level Key field. The variable level GL167 GL190
represents the location of an accounting GL199 GL327
unit in an organization's level GL330 GL45.1
structure. GL500 GLSV.1
CAM-ACCOUNT Numeric 6 GL146 GL167
Account Key field. This field and the GL190 GL199
accounting unit and subaccount define GL327 GL330
the location (account) where amounts and GL45.1 GL500
other account information are stored. GLSV.1
CAM-SUB-ACCOUNT Numeric 4 GL146 GL167
Subaccount Key field. This field and the GL190 GL199
accounting unit and account define the GL327 GL330
location (account) where amounts and GL45.1 GL500
other account information are stored. GLSV.1
CAM-ACCT-UNIT Alpha 15 GL146 GL167
Accounting Unit The accounting unit is a shorthand GL190 GL199
notation representing the variable level GL327 GL330
number. When used in the General Ledger GL45.1 GL500
Account Master file, the accounting unit GLSV.1
must be defined in the General Ledger
Names file as a posting accounting unit.
CAM-CURRENCY-CODE Alpha 5 GL146 GL167
Currency Code Key field. This field contains the GL190 GL199
company's base currency code established GL327 GL330
in GL10.1 (Company). GL45.1 GL500
GLSV.1
CAM-CHART-NAME Alpha 12 GL146 GL167
Chart This is the name you assigned to the GL190 GL199
chart of accounts when you defined your GL327 GL330
company structure in the General Ledger GL45.1 GL500
system. GLSV.1
CAM-CURR-ND Numeric 1 GL146 GL167
Currency This field determines the number of GL190 GL199
decimal positions for amount fields. GL327 GL330
GL45.1 GL500
CAM-BASE-ND Numeric 1 GL146 GL167
Base Currency This is the defined number of decimal GL190 GL199
positions for base amount fields. GL327 GL330
GL45.1 GL500
CAM-DB-BEG-BAL Currency 15.2 GL110 GL167
Debit Beginning This is the debit beginning balance. GL199 GL291
Balance GL327 GL500
GLSV.1
CAM-CR-BEG-BAL Currency 15.2 GL110 GL167
Credit Beginning This is the credit beginning balance. GL199 GL291
Balance GL327 GL500
GLSV.1
CAM-BASE-DB-BBAL Currency 15.2 GL110 GL167
Base Currency Debit This is the base currency debit balance. GL199 GL327
Balance GL500
CAM-BASE-CR-BBAL Currency 15.2 GL110 GL167
Base Currency This is the base currency credit GL199 GL327
Credit Balance balance. GL500
CAM-DB-AMOUNT Currency 15.2 Occurs 13 Times GL110 GL146
Budget Debit Amount This is the budget debit amount. GL167 GL190
GL291 GL327
GL330 GL45.1
GL500 GLSV.1
CAM-CR-AMOUNT Currency 15.2 Occurs 13 Times GL110 GL146
Budget Credit Amount This is the budget credit amount. GL167 GL190
GL291 GL327
GL330 GL45.1
GL500 GLSV.1
CAM-BASE-DB-AMT Currency 15.2 Occurs 13 Times GL110 GL146
Period Base Debit This is the base debit amount for the GL167 GL190
Amount period. GL327 GL330
GL45.1 GL500
CAM-BASE-CR-AMT Currency 15.2 Occurs 13 Times GL110 GL146
Period Base Credit This is the base credit amount for the GL167 GL190
Amount period. GL327 GL330
GL45.1 GL500
CAM-MAINT-DATE Numeric 8 (yyyymmdd)
Maintenance Date The date last changed.
CAM-MAINT-TIME Numeric 6 (hhmmss)
Maintenance Time The time last changed.
CAM-CPAMT-DR Derived
Current Per This is the currency debit amount for
Currency Dr Amount the current period.
CAM-CPAMT-CR Derived
Current Per This is the currency credit amount for
Currency Cr Amount the current period.
CAM-CPAMT Derived
Current Period This is the currency amount for the
Currency Amount current period.
CAM-CUR-PD-SUM-A-D Derived
Current Per Base Dr This is the base debit amount for the
Amount current period.
CAM-CUR-PD-SUM-A-C Derived
Current Per Base Cr This is the base credit amount for the
Amount current period.
CAM-CYBAMT Derived
Current Year Beg This is the beginning base amount for
Base Amount the current year.
CAM-CYDAMT Derived
Current Per Base This is the base amount to date for the
Amnt to Date current period.
CAM-CYPAMT1-DR Derived
Period 1 Base Debit This is the period 1 base debit amount.
Amount
CAM-CYPAMT1-CR Derived
Period 1 Base This is the period 1 base credit amount.
Credit Amount
CAM-CYPAMT1 Derived
Period 1 Base Amount This is the period 1 base amount.
CAM-CYPAMT2-DR Derived
Period 2 Base Debit This is the period 2 base debit amount.
Amount
CAM-CYPAMT2-CR Derived
Period 2 Base This is the period 2 base credit amount.
Credit Amount
CAM-CYPAMT2 Derived
Period 2 Base Amount This is the period 2 base amount.
CAM-CYPAMT3-DR Derived
Period 3 Base Debit This is the period 3 base debit amount.
Amount
CAM-CYPAMT3-CR Derived
Period 3 Base This is the period 3 base credit amount.
Credit Amount
CAM-CYPAMT3 Derived
Period 3 Base Amount This is the period 3 base amount.
CAM-CYPAMT4-DR Derived
Period 4 Base Debit This is the period 4 base debit amount.
Amount
CAM-CYPAMT4-CR Derived
Period 4 Base This is the period 4 base credit amount.
Credit Amount
CAM-CYPAMT4 Derived
Period 4 Base Amount This is the period 4 base amount.
CAM-CYPAMT5-DR Derived
Period 5 Base Debit This is the period 5 base debit amount.
Amount
CAM-CYPAMT5-CR Derived
Period 5 Base This is the period 5 base credit amount.
Credit Amount
CAM-CYPAMT5 Derived
Period 5 Base Amount This is the period 5 base amount.
CAM-CYPAMT6-DR Derived
Period 6 Base Debit This is the period 6 base debit amount.
Amount
CAM-CYPAMT6-CR Derived
Period 6 Base This is the period 6 base credit amount.
Credit Amount
CAM-CYPAMT6 Derived
Period 6 Base Amount This is the period 6 base amount.
CAM-CYPAMT7-DR Derived
Period 7 Base Debit This is the period 7 base debit amount.
Amount
CAM-CYPAMT7-CR Derived
Period 7 Base This is the period 7 base credit amount.
Credit Amount
CAM-CYPAMT7 Derived
Period 7 Base Amount This is the period 7 base amount.
CAM-CYPAMT8-DR Derived
Period 8 Base Debit This is the period 8 base debit amount.
Amount
CAM-CYPAMT8-CR Derived
Period 8 Base This is the period 8 base credit amount.
Credit Amount
CAM-CYPAMT8 Derived
Period 8 Base Amount This is the period 8 base amount.
CAM-CYPAMT9-DR Derived
Period 9 Base Debit This is the period 9 base debit amount.
Amount
CAM-CYPAMT9-CR Derived
Period 9 Base This is the period 9 base credit amount.
Credit Amount
CAM-CYPAMT9 Derived
Period 9 Base Amount This is the period 9 base amount.
CAM-CYPAMT10-DR Derived
Period 10 Base This is the period 10 base debit amount.
Debit Amount
CAM-CYPAMT10-CR Derived
Period 10 Base This is the period 10 base credit
Credit Amount amount.
CAM-CYPAMT10 Derived
Period 10 Base This is the period 10 base amount.
Amount
CAM-CYPAMT11-DR Derived
Period 11 Base This is the period 11 base debit amount.
Debit Amount
CAM-CYPAMT11-CR Derived
Period 11 Base This is the period 11 base credit
Credit Amount amount.
CAM-CYPAMT11 Derived
Period 11 Base This is the period 11 base amount.
Amount
CAM-CYPAMT12-DR Derived
Period 12 Base This is the period 12 base debit amount.
Debit Amount
CAM-CYPAMT12-CR Derived
Period 12 Base This is the period 12 base credit
Credit Amount amount.
CAM-CYPAMT12 Derived
Period 12 Base This is the period 12 base amount.
Amount
CAM-CYPAMT13-DR Derived
Period 13 Base This is the period 13 base debit amount.
Debit Amount
CAM-CYPAMT13-CR Derived
Period 13 Base This is the period 13 base credit
Credit Amount amount.
CAM-CYPAMT13 Derived
Period 13 Base This is the period 13 base amount.
Amount
CAM-CPCUR-DR Derived
Current Period This is the current period debit amount.
Debit Amount
CAM-CPCUR-CR Derived
Current Period This is the current period credit
Credit Amount amount.
CAM-CPCUR Derived
Current Period This is the current period amount.
Amount
CAM-CUR-PD-SUM-C-D Derived
Year-to-Date Debit This is the year-to-date debit amount.
Amount
CAM-CUR-PD-SUM-C-C Derived
Year-to-Date Credit This is the year-to-date credit amount.
Amount
CAM-CYBCUR Derived
Beginning Balance This is the beginning balance.
CAM-CYDCUR Derived
Balance to Date This is the balance to date.
CAM-CYPCUR1-DR Derived
Per 1 Currency This is the period 1 currency debit
Debit Amount amount.
CAM-CYPCUR1-CR Derived
Per 1 Currency This is the period 1 currency credit
Credit Amount amount.
CAM-CYPCUR1 Derived
Per 1 Currency This is the period 1 currency amount.
Amount
CAM-CYPCUR2-DR Derived
Per 2 Currency This is the period 2 currency debit
Debit Amount amount.
CAM-CYPCUR2-CR Derived
Per 2 Currency This is the period 2 currency credit
Credit Amount amount.
CAM-CYPCUR2 Derived
Per 2 Currency This is the period 2 currency amount.
Amount
CAM-CYPCUR3-DR Derived
Per 3 Currency This is the period 3 currency debit
Debit Amount amount.
CAM-CYPCUR3-CR Derived
Per 3 Currency This is the period 3 currency credit
Credit Amount amount.
CAM-CYPCUR3 Derived
Per 3 Currency This is the period 3 currency amount.
Amount
CAM-CYPCUR4-DR Derived
Per 4 Currency This is the period 4 currency debit
Debit Amount amount.
CAM-CYPCUR4-CR Derived
Per 4 Currency This is the period 4 currency credit
Credit Amount amount.
CAM-CYPCUR4 Derived
Per 4 Currency This is the period 4 currency amount.
Amount
CAM-CYPCUR5-DR Derived
Per 5 Currency This is the period 5 currency debit
Debit Amount amount.
CAM-CYPCUR5-CR Derived
Per 5 Currency This is the period 5 currency credit
Credit Amount amount.
CAM-CYPCUR5 Derived
Per 5 Currency This is the period 5 currency amount.
Amount
CAM-CYPCUR6-DR Derived
Per 6 Currency This is the period 6 currency debit
Debit Amount amount.
CAM-CYPCUR6-CR Derived
Per 6 Currency This is the period 6 currency credit
Credit Amount amount.
CAM-CYPCUR6 Derived
Per 6 Currency This is the period 6 currency amount.
Amount
CAM-CYPCUR7-DR Derived
Per 7 Currency This is the period 7 currency debit
Debit Amount amount.
CAM-CYPCUR7-CR Derived
Per 7 Currency This is the period 7 currency credit
Credit Amount amount.
CAM-CYPCUR7 Derived
Per 7 Currency This is the period 7 currency amount.
Amount
CAM-CYPCUR8-DR Derived
Per 8 Currency This is the period 8 currency debit
Debit Amount amount.
CAM-CYPCUR8-CR Derived
Per 8 Currency This is the period 8 currency credit
Credit Amount amount.
CAM-CYPCUR8 Derived
Per 8 Currency This is the period 8 currency amount.
Amount
CAM-CYPCUR9-DR Derived
Per 9 Currency This is the period 9 currency debit
Debit Amount amount.
CAM-CYPCUR9-CR Derived
Per 9 Currency This is the period 9 currency credit
Credit Amount amount.
CAM-CYPCUR9 Derived
Per 9 Currency This is the period 9 currency amount.
Amount
CAM-CYPCUR10-DR Derived
Per 10 Currency This is the period 10 currency debit
Debit Amount amount.
CAM-CYPCUR10-CR Derived
Per 10 Currency This is the period 10 currency credit
Credit Amount amount.
CAM-CYPCUR10 Derived
Per 10 Currency This is the period 10 currency amount.
Amount
CAM-CYPCUR11-DR Derived
Per 11 Currency This is the period 11 currency debit
Debit Amount amount.
CAM-CYPCUR11-CR Derived
Per 11 Currency This is the period 11 currency credit
Credit Amount amount.
CAM-CYPCUR11 Derived
Per 11 Currency This is the period 11 currency amount.
Amount
CAM-CYPCUR12-DR Derived
Per 12 Currency This is the period 12 currency debit
Debit Amount amount.
CAM-CYPCUR12-CR Derived
Per 12 Currency This is the period 12 currency credit
Credit Amount amount.
CAM-CYPCUR12 Derived
Per 12 Currency This is the period 12 currency amount.
Amount
CAM-CYPCUR13-DR Derived
Per 13 Currency This is the period 13 currency debit
Debit Amount amount.
CAM-CYPCUR13-CR Derived
Per 13 Currency This is the period 13 currency credit
Credit Amount amount.
CAM-CYPCUR13 Derived
Per 13 Currency This is the period 13 currency amount.
Amount
CAM-BLANK Derived
Blank This derived field is always blank. It
is used in drill around to allow for
column headings.
CAM-CPAMT-THOU Derived
Cpamt Thou The current period base amount divided
by 1,000.
CAM-CYDAMT-THOU Derived
Cydamt Thou The current year-to-date base amount
divided by 1,000.
CAM-CPCUR-THOU Derived
Cpcur Thou The current year-to-date currency
amount divided by 1,000.
CAM-CYDCUR-THOU Derived
Cydcur Thou The current year-to-date currency
amount divided by 1,000.
CUAMOUNT FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAMSET1 FISCAL-YEAR This path is used to retrieve a GL110 GL146
COMPANY currency amount for a specific company, GL167 GL190
AMT-TYPE variable level, etc. GL191 GL199
VAR-LEVELS GL291 GL296
ACCOUNT GL300 GL327
SUB-ACCOUNT GL330 GL45.1
ACCT-UNIT GLSV.1 GLOP.1
CURRENCY-CODE GLRV.1
CAMSET2 FISCAL-YEAR This path accesses the accounting unit GL191 GL196
COMPANY via amount type, currency code, account GL199 GL320
AMT-TYPE and subaccount, and variable levels, GL327 GL330
CURRENCY-CODE within company. GLOP.1
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
CAMSET3 AMT-TYPE GL290 GL291
FISCAL-YEAR GLSV.1 RW80.1
COMPANY GLRV.1
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
CURRENCY-CODE
CAMSET4 AMT-TYPE GL327 GL330
FISCAL-YEAR GLSV.1 GLRV.1
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
CURRENCY-CODE
CAMSET5 COMPANY GL110 GL120
ACCT-UNIT GL122 GL199
ACCOUNT GL500 GL90.1
SUB-ACCOUNT GL90.4 GL00.7
AMT-TYPE GL20.2
CURRENCY-CODE
FISCAL-YEAR
VAR-LEVELS
CAMSET6 AMT-TYPE GLSV.1 GLRV.1
FISCAL-YEAR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
CURRENCY-CODE
CAMSET7 AMT-TYPE GLSV.1 GLRV.1
FISCAL-YEAR
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
CURRENCY-CODE
CAMSET9 AMT-TYPE KeyChange GLOP.1
MAINT-DATE
MAINT-TIME
CURRENCY-CODE
COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
VAR-LEVELS
CUAMOUNT FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Chart Detail GLCHARTDTL Required
GLS-CHART-NAME -> GDT-CHART-NAME
CAM-ACCOUNT -> GDT-ACCOUNT
CAM-SUB-ACCOUNT -> GDT-SUB-ACCOUNT
Company GLSYSTEM Required
CAM-COMPANY -> GLS-COMPANY
Cucodes CUCODES Required
CAM-CURRENCY-CODE -> CUC-CURRENCY-CODE
Glmaster GLMASTER Required
CAM-COMPANY -> GLM-COMPANY
CAM-ACCT-UNIT -> GLM-ACCT-UNIT
CAM-ACCOUNT -> GLM-ACCOUNT
CAM-SUB-ACCOUNT -> GLM-SUB-ACCOUNT
Glnames GLNAMES Required
CAM-COMPANY -> GLN-COMPANY
CAM-ACCT-UNIT -> GLN-ACCT-UNIT
CUAMOUNT FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Cuconv CUCONV
GLS-CURRENCY-TABLE -> CCN-CURRENCY-TABLE
CAM-CURRENCY-CODE -> CCN-FR-CURR-CODE
GLS-CURRENCY-CODE -> CCN-TO-CURR-CODE
CCN-SYSTEM
CCN-EFFECT-DATE
Gltrans 1 Prd GLTRANS
CAM-COMPANY -> GLT-TO-COMPANY
CAM-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLS-ACCT-PERIOD -> GLT-ACCT-PERIOD
CAM-ACCT-UNIT -> GLT-ACCT-UNIT
CAM-ACCOUNT -> GLT-ACCOUNT
CAM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
GLT-POSTING-DATE
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-LINE-NBR
GLT-COMPANY
GLT-JE-SEQUENCE
Gltrans 1 Year GLTRANS
CAM-COMPANY -> GLT-TO-COMPANY
CAM-ACCOUNT -> GLT-ACCOUNT
CAM-SUB-ACCOUNT -> GLT-SUB-ACCOUNT
CAM-ACCT-UNIT -> GLT-ACCT-UNIT
CAM-FISCAL-YEAR -> GLT-FISCAL-YEAR
GLT-ACCT-PERIOD
GLT-SYSTEM
GLT-CONTROL-GROUP
GLT-JE-TYPE
GLT-JE-SEQUENCE
GLT-LINE-NBR
GLT-COMPANY
|