Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

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