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