CUAMOUNTX

Currency Amount-Daily

The Daily Report Currency (CUAMOUNTX) file stores daily account balances for report currencies.

REFERENCED BY
GLOP.1 GL243 GL43.1


UPDATED BY
GL110 GL120 GL146 GL148 GL167 GL190
GL197 GL300 GL310 GL328 GL40.1 GL40.2
GL40.3 GL40.7 GL40.8 GL44.1 GL45.1 GL500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
CAX-COMPANY
Element: Company
Numeric 4
The company number assigned to the report currencies in GL10.1 (Company).
GL110 GL146
GL148 GL167
GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-DATE
Element: Date
Numeric 8 (yyyymmdd)
This field displays the system date when this reocrd was created.
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-AMT-TYPE
Element: Amt Type
Numeric 1
The amount type indicates whether the record is currency one or currency two.
3 = Currency One Balance
4 = Currency Two Balance
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-VAR-LEVELS
Element: Var Levels
Alpha 30
A level that represents the location of an accounting unit in an organization's level structure.
GL120 GL148
GL167 GL190
GL328
CAX-ACCOUNT
Element: Account
Numeric 6
This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored.
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-SUB-ACCOUNT
Element: Sub Acct
Numeric 4
This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record.
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-ACCT-UNIT
Element: Acct 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.
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-CURRENCY-CODE
Element: Currency Code
Alpha 5
This field contains the company base currency code established in Company (GL10.1 ).
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-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.
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-CURR-ND
Element: Acct Nd
Numeric 1
The number of decimals assigned to a particular account as determined by the account currency.
GL146 GL148
GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-BASE-ND
Element: Base Nd
Numeric 1
The number of decimal positions defined for the company base currency.
GL146 GL148
GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-DB-AMOUNT
Element: Intl Amt
Signed 18.2
GL110 GL146
GL148 GL167
GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-CR-AMOUNT
Element: Intl Amt
Signed 18.2
GL110 GL146
GL148 GL167
GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-BASE-DB-AMT
Element: Intl Amt
Signed 18.2
The base currency debit amount.
GL146 GL148
GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-BASE-CR-AMT
Element: Intl Amt
Signed 18.2
The base currency credit amount.
GL146 GL148
GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-ACCT-PERIOD
Element: Acct Period
Numeric 2
This is the current accounting period. This field is updated by GL199 (Period Closing).
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
CAX-FISCAL-YEAR
Element: Year
Numeric 4
Contains the fiscal year for the data stored on this record.
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
CAX-MAINT-DATE
Element: Maint Date
Numeric 8 (yyyymmdd)
The date last changed.
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
CAX-MAINT-TIME
Element: Sys Time
Numeric 6 (hhmmss)
GL146 GL148
GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
CAX-NET-AMOUNT
Element: Net Amount
Derived
The net daily report currency amount. This amount is the debit amount added to the credit amount.


CUAMOUNTX FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
CAXSET1 COMPANY
AMT-TYPE
DATE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
GL120 GL146
GL148 GL167
GL190 GL197
GL310 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
GLOP.1
CAXSET3 COMPANY
AMT-TYPE
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
KeyChange
GL110 GL300
CAXSET4 COMPANY
AMT-TYPE
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
GL120 GL243
GL43.1


CUAMOUNTX FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Gltrans GLTRANS
CAX-COMPANY->GLT-TO-COMPANY
CAX-FISCAL-YEAR->GLT-FISCAL-YEAR
CAX-ACCT-PERIOD->GLT-ACCT-PERIOD
CAX-ACCT-UNIT->GLT-ACCT-UNIT
CAX-ACCOUNT->GLT-ACCOUNT
CAX-SUB-ACCOUNT->GLT-SUB-ACCOUNT
CAX-DATE->GLT-POSTING-DATE
  GLT-SYSTEM
  GLT-CONTROL-GROUP
  GLT-JE-TYPE
  GLT-LINE-NBR
  GLT-COMPANY
  GLT-JE-SEQUENCE


File created: Thu Jun 09 11:13:00 2016

Home
Contact Us



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