CUAMOUNT

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
GLSV.1 GL196 GL290 GL90.1 GL90.4 GL90.6


UPDATED BY
CA110 CA190 GL110 GL120 GL146 GL148
GL167 GL190 GL197 GL199 GL300 GL310
GL327 GL330 GL40.1 GL40.2 GL40.3 GL40.7
GL40.8 GL44.1 GL45.1 GL500 GL141 GL147
GL191 GL291 GL296 GLOP.1 GLRV.1 GL320
RW80.1 CB222 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.
CA110 GL110
GL146 GL148
GL167 GL190
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 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 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
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 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 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 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 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 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 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
GL199 GL291
GL327 GL330
GL500 GLSV.1
CAM-CR-BEG-BAL
Credit Beginning
Balance
Signed 18.2
This is the credit beginning balance.
GL110 GL167
GL199 GL291
GL327 GL330
GL500 GLSV.1
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
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
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.
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.
CA110 GL120
GL146 GL148
GL167 GL190
GL197 GL199
GL327 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500


CUAMOUNT FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAMSET1 FISCAL-YEAR
COMPANY
AMT-TYPE
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
CURRENCY-CODE
CA110 CA190
GL110 GL120
GL141 GL146
GL147 GL148
GL167 GL190
GL191 GL197
GL199 GL291
GL296 GL300
GL327 GL330
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GLSV.1
GLOP.1 GLRV.1
CAMSET2 FISCAL-YEAR
COMPANY
AMT-TYPE
CURRENCY-CODE
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
GL196 GL199
GL296 GL320
GL327 GL330
GLOP.1
CAMSET3 AMT-TYPE
FISCAL-YEAR
COMPANY
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
ACCT-UNIT
CURRENCY-CODE
GL290 GL291
GLSV.1 RW80.1
GLRV.1
CAMSET4 AMT-TYPE
FISCAL-YEAR
COMPANY
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
ACCT-UNIT
CURRENCY-CODE
GL327 GL330
GLSV.1 GLRV.1
CAMSET5 COMPANY
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
AMT-TYPE
CURRENCY-CODE
FISCAL-YEAR
VAR-LEVELS
CB222 GL110
GL120 GL122
GL148 GL199
GL310 GL500
GL90.1 GL90.4
GL90.6 GL20.2
CAMSET6 AMT-TYPE
FISCAL-YEAR
VAR-LEVELS
ACCOUNT
SUB-ACCOUNT
COMPANY
ACCT-UNIT
CURRENCY-CODE
GLSV.1 GLRV.1
CAMSET7 AMT-TYPE
FISCAL-YEAR
ACCOUNT
SUB-ACCOUNT
VAR-LEVELS
COMPANY
ACCT-UNIT
CURRENCY-CODE
GLSV.1 GLRV.1
CAMSET9 PARENT-VAR-LEV
AMT-TYPE
COMPANY
ACCOUNT
SUB-ACCOUNT
FISCAL-YEAR
ACCT-UNIT
VAR-LEVELS
CURRENCY-CODE
KeyChange


CUAMOUNT FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Chart Detail GLCHARTDTL Required
GLS-CHART-NAME->GDT-CHART-NAME (GDTSET2)
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
Gam Sibling GLAMOUNTS Not Required
CAM-PARENT-VAR-LEV->GAM-PARENT-VAR-LEV
CAM-COMPANY->GAM-COMPANY
CAM-ACCOUNT->GAM-ACCOUNT
CAM-SUB-ACCOUNT->GAM-SUB-ACCOUNT
CAM-FISCAL-YEAR->GAM-FISCAL-YEAR
CAM-ACCT-UNIT->GAM-ACCT-UNIT
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
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Consol Parent1 GLCONSOL
CAM-PARENT-VAR-LEV->GCN-VAR-LEVELS
"Y"->GCN-TRANS-TYPE
CAM-COMPANY->GCN-COMPANY
CAM-ACCOUNT->GCN-ACCOUNT
CAM-SUB-ACCOUNT->GCN-SUB-ACCOUNT
CAM-FISCAL-YEAR->GCN-FISCAL-YEAR
  GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-CURRENCY-CODE
Consol Parent2 GLCONSOL
CAM-PARENT-VAR-LEV->GCN-VAR-LEVELS
"Z"->GCN-TRANS-TYPE
CAM-COMPANY->GCN-COMPANY
CAM-ACCOUNT->GCN-ACCOUNT
CAM-SUB-ACCOUNT->GCN-SUB-ACCOUNT
CAM-FISCAL-YEAR->GCN-FISCAL-YEAR
  GCN-BUDGET-NBR
  GCN-LEVEL-DEPTH
  GCN-CURRENCY-CODE
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
Curr 1 CUAMOUNT
CAM-PARENT-VAR-LEV->CAM-PARENT-VAR-LEV
3->CAM-AMT-TYPE
CAM-COMPANY->CAM-COMPANY
CAM-ACCOUNT->CAM-ACCOUNT
CAM-SUB-ACCOUNT->CAM-SUB-ACCOUNT
CAM-FISCAL-YEAR->CAM-FISCAL-YEAR
CAM-ACCT-UNIT->CAM-ACCT-UNIT
CAM-VAR-LEVELS->CAM-VAR-LEVELS
  CAM-CURRENCY-CODE
Curr 2 CUAMOUNT
CAM-PARENT-VAR-LEV->CAM-PARENT-VAR-LEV
4->CAM-AMT-TYPE
CAM-COMPANY->CAM-COMPANY
CAM-ACCOUNT->CAM-ACCOUNT
CAM-SUB-ACCOUNT->CAM-SUB-ACCOUNT
CAM-FISCAL-YEAR->CAM-FISCAL-YEAR
CAM-ACCT-UNIT->CAM-ACCT-UNIT
CAM-VAR-LEVELS->CAM-VAR-LEVELS
  CAM-CURRENCY-CODE
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


File created: Wed Jun 08 20:48:36 2016

Home
Contact Us



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