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: Amt 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: Var Levels A 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: Sub Acct This field contains the subaccount from GL167 GL190
your general ledger chart of accounts GL197 GL328
that was charged with the amount carried GL40.1 GL40.2
on this record. GL40.3 GL40.7
GL40.8 GL44.1
GL45.1
CAX-ACCT-UNIT Alpha 15 GL146 GL148
Element: Acct Unit The 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
Element: Acct Nd The number of decimals assigned to a GL190 GL197
particular account as determined by the GL328 GL40.1
account currency. GL40.2 GL40.3
GL40.7 GL40.8
GL44.1 GL45.1
CAX-BASE-ND Numeric 1 GL146 GL148
Element: Base Nd The number of decimal positions defined GL190 GL197
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 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 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: Acct Period This 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: Year Contains the fiscal year for the data GL167 GL190
stored on this record. GL197 GL328
GL40.1 GL40.2
GL40.3 GL40.7
GL40.8 GL44.1
GL45.1 GL500
CAX-MAINT-DATE Numeric 8 (yyyymmdd) GL146 GL148
Element: Maint Date The 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 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 GL120 GL146
AMT-TYPE GL148 GL167
DATE GL190 GL197
ACCT-UNIT GL310 GL328
ACCOUNT GL40.1 GL40.2
SUB-ACCOUNT GL40.3 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
|