|
|
CUAMOUNTX FILE
Daily Report Currency
The Daily Report Currency (CUAMOUNTX) file stores daily account balances for
report currencies.
REFERENCED BY
GLOP.1 GL243 GL43.1
UPDATED BY
GL110 GL146 GL167 GL190 GL300 GL328
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). GL328 GL45.1
CAX-DATE Numeric 8 (yyyymmdd) GL146 GL167
Date This field contains the system date GL190 GL328
when this was created. GL45.1
CAX-AMT-TYPE Numeric 1 GL146 GL167
Amount Type The amount type indicates whether the GL190 GL328
record is currency one or currency two. GL45.1
CAX-VAR-LEVELS Alpha 30 GL167 GL190
Levels A level that represents the location of GL328
an accounting unit in an organization's
level structure.
CAX-ACCOUNT Numeric 6 GL146 GL167
Account This field along with the accounting GL190 GL328
unit and subaccount make up the location GL45.1
(account) where amounts and other
account information is stored.
CAX-SUB-ACCOUNT Numeric 4 GL146 GL167
Subaccount This field along with the accounting GL190 GL328
unit and subaccount make up the location GL45.1
(account) where amounts and other
account information is stored.
CAX-ACCT-UNIT Alpha 15 GL146 GL167
Accounting Unit The accounting unit is a shorthand GL190 GL328
notation representing the variable level GL45.1
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.
CAX-CURRENCY-CODE Alpha 5 GL146 GL167
Currency Code This field contains the company base GL190 GL328
currency code established in GL10.1 GL45.1
(Company).
CAX-CHART-NAME Alpha 12 GL146 GL167
Chart This is the name you assigned to the GL190 GL328
chart of accounts when you defined your GL45.1
company structure in the General Ledger
system.
CAX-CURR-ND Numeric 1 GL146 GL190
Currency Represents the number of decimals GL328 GL45.1
defined for the currency of the object.
CAX-BASE-ND Numeric 1 GL146 GL190
Base Currency The number of decimal positions defined GL328 GL45.1
for the company base currency.
CAX-DB-AMOUNT Currency 15.2 GL110 GL146
Debit Amount The budget debit amount. GL167 GL190
GL328 GL45.1
CAX-CR-AMOUNT Currency 15.2 GL110 GL146
Credit Amount The budget credit amount. GL167 GL190
GL328 GL45.1
CAX-BASE-DB-AMT Currency 15.2 GL146 GL190
Base Debit Amount The base currency debit amount. GL328 GL45.1
CAX-BASE-CR-AMT Currency 15.2 GL146 GL190
Base Credit Amount The base currency credit amount. GL328 GL45.1
CAX-ACCT-PERIOD Numeric 2 GL146 GL167
Accounting Period This is the current accounting period. GL190 GL328
This field is updated by GL199 (Period GL45.1
Closing).
CAX-FISCAL-YEAR Numeric 4 GL146 GL167
Fiscal Year This is the current fiscal year. This GL190 GL328
field is updated by GL199 (Period GL45.1 GL500
Closing).
CAX-MAINT-TIME Numeric 6 (hhmmss) GL146 GL167
Maintenance Time The time last changed. GL190 GL328
GL45.1 GL500
CAX-MAINT-DATE Numeric 8 (yyyymmdd) GL146 GL167
Maintenance Date The date last changed. GL190 GL328
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 GL328
DATE GL45.1 GL500
ACCT-UNIT GLOP.1
ACCOUNT
SUB-ACCOUNT
CAXSET3 COMPANY GL110 GL300
AMT-TYPE
FISCAL-YEAR
ACCT-UNIT
ACCOUNT
SUB-ACCOUNT
DATE
CAXSET4 COMPANY GL243 GL43.1
AMT-TYPE
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
|