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 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 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
Element: 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
Element: 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
Element: New Levels GL190 GL328
CAX-ACCOUNT Numeric 6 GL146 GL167
Element: 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
Element: Subaccount GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-ACCT-UNIT Alpha 15 GL146 GL167
Element: Accounting UniThe 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
Element: 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
Element: Name User 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
Account Currency GL197 GL328
Code GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-BASE-ND Numeric 1 GL146 GL190
Account Currency GL197 GL328
Code GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-DB-AMOUNT Currency 15.2 GL110 GL146
Element: 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
Element: 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
Element: Amount 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
Element: Amount 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
Element: Current Period GL190 GL197
GL328 GL40.1
GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
GL500
CAX-FISCAL-YEAR Numeric 4 GL146 GL167
Element: Last Closed YeThis 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
Element: Date 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
Element: Sys Time 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 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 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
|