CUAMOUNTX FILE
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 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 Numeric 4 GL110 GL146
Company The company number report currencies GL167 GL190
are assigned to in GL10.1 (Company). GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-DATE Numeric 8 (yyyymmdd) GL146 GL167
Date This field displays the system date GL190 GL197
when this was created. GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-AMT-TYPE Numeric 1 GL146 GL167
Amount Type The amount type indicates whether the GL190 GL197
record is currency one or currency two. GL328 GL40.1
GL40.2 GL40.3
3 = Currency One Balance GL40.7 GL40.8
4 = Currency Two Balance GL44.1 GL45.1
CAX-VAR-LEVELS Alpha 30 GL120 GL167
Variable Levels A level that represents the location of GL190 GL328
an accounting unit in an organization's
level structure.
CAX-ACCOUNT Numeric 6 GL146 GL167
Account This field along with the accounting GL190 GL197
unit and subaccount make up the location GL328 GL40.1
(account) where amounts and other GL40.2 GL40.3
account information is stored. GL40.7 GL40.8
GL44.1 GL45.1
CAX-SUB-ACCOUNT Numeric 4 GL146 GL167
Subaccount This field along with the accounting GL190 GL197
unit and subaccount make up the location GL328 GL40.1
(account) where amounts and other GL40.2 GL40.3
account information is stored. GL40.7 GL40.8
GL44.1 GL45.1
CAX-ACCT-UNIT Alpha 15 GL146 GL167
Accounting Unit The accounting unit is a shorthand GL190 GL197
notation representing the variable level GL328 GL40.1
number. When used in the General Ledger GL40.2 GL40.3
Account Master file, the accounting unit GL40.7 GL40.8
must be defined in the General Ledger GL44.1 GL45.1
Names file as a posting accounting unit.
CAX-CURRENCY-CODE Alpha 5 GL146 GL167
Currency Code This field contains the company base GL190 GL197
currency code established in Company GL328 GL40.1
(GL10.1 ). GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-CHART-NAME Alpha 12 GL146 GL167
Chart Name This is the name you assigned to the GL190 GL197
chart of accounts when you defined your GL328 GL40.1
company structure in the General Ledger GL40.2 GL40.3
system. GL40.7 GL40.8
GL44.1 GL45.1
CAX-CURR-ND Numeric 1 GL146 GL190
Currency Number of Represents the number of decimals GL197 GL328
Decimals defined for the currency of the object. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-BASE-ND Numeric 1 GL146 GL190
Base Number Of The number of decimal positions defined GL197 GL328
Decimals for the company base currency. GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-DB-AMOUNT Currency 15.2 GL110 GL146
Debit Amount The budget debit amount. GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-CR-AMOUNT Currency 15.2 GL110 GL146
Credit Amount The budget credit amount. GL167 GL190
GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-BASE-DB-AMT Currency 15.2 GL146 GL190
Base Db Amt The base currency debit amount. GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-BASE-CR-AMT Currency 15.2 GL146 GL190
Base Cr Amt The base currency credit amount. GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-ACCT-PERIOD Numeric 2 GL146 GL167
Account Period This is the current accounting period. GL190 GL197
This field is updated by GL199 (Period GL328 GL40.1
Closing). GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
CAX-FISCAL-YEAR Numeric 4 GL146 GL167
Fiscal Year This is the current fiscal year. This GL190 GL197
field is updated by Period Closing GL328 GL40.1
(GL199). GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
CAX-MAINT-DATE Numeric 8 (yyyymmdd) GL146 GL167
Maintenance Date The date last changed. GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
CAX-MAINT-TIME Numeric 6 (hhmmss) GL146 GL167
Maintenance Time The time last changed. GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
CAX-NET-AMOUNT Derived
Net Amount 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 GL146 GL167
AMT-TYPE GL190 GL197
DATE GL310 GL328
ACCT-UNIT GL40.1 GL40.2
ACCOUNT GL40.3 GL40.7
SUB-ACCOUNT GL40.8 GL44.1
GL45.1 GL500
GLOP.1
CAXSET3 COMPANY GL110 GL300
AMT-TYPE
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
CAXSET4 COMPANY GL120 GL243
AMT-TYPE GL43.1
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
CUAMOUNTX FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME 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
|