Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CUACCT


                              CUACCT FILE

                     Currency Gain and Loss Account

This file contains account numbers that variance amounts are posted to when a
timing difference occurs between the beginning and the completion of a
transaction. CU03.1 (Currency Gain Loss Accounts) is the primary program that
updates this file.


REFERENCED BY

AP170     AP180     AP181     AP190     AP191     AP30.4
AR01.1    AR129     AR130     AR131     AR135     AR196
AR30.1    AR30.8    AR31.6    AR33.1    AR33.3    AR33.6
AR34.1    AR35.1    AR44.3    AR48.3    AR504     DT170
DT180     DT181     DT185     GL191     CU203     IFCU.1
MA180

UPDATED BY

GL110     CU03.1    GL10.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CUA-COMPANY            Numeric 4                                 CU03.1  GL110
Element: Company       The company number you are defining
                       currencies for.


CUA-FR-CURR-CODE       Alpha 5                                   CU03.1
Element: From currency This is the name of the currency code
                       you are converting from. It must be a
                       defined code in the Currency
                       Relationships file.


CUA-TO-CURR-CODE       Alpha 5                                   CU03.1
Element: To Currency CoThis is the name of the currency code
                       you are converting to. It must be a
                       defined code in the Currency
                       Relationships file.


CUA-SYSTEM             Alpha 2                                   CU03.1
Element: System        A system code is a unique two-character
                       code identifying a Lawson application
                       system. A blank system code must first
                       exist before a record can be added with
                       a valid system code. The system code
                       must be defined in the General Ledger
                       file and source code.

                       If you enter a system code in this
                       field, the currency gain and loss
                       accounts are used for that system only.



CUA-CURRENCY-TABLE     Alpha 12                                  CU03.1  GL10.1
Element: Currency TableThis is the currency table, a table of
                       currency relationships, currency
                       exchange rates, and translation rates
                       for one or more companies.


CUA-REAL-GAIN-ACU      Alpha 15                                  CU03.1
Realized Gain          A negative variance is posted to this
Accounting Unit        accounting unit if conversion rates
                       differ in the opening and closing of a
                       transaction. The accounting unit must be
                       defined in the General Ledger Account
                       Master file.


CUA-REAL-GAIN-ACT      Numeric 6                                 CU03.1
Realized Gain          A negative variance is posted to this
Account                account if conversion rates differ in
                       the opening and closing of a
                       transaction. The account must be defined
                       in the General Ledger Account Master
                       file.


CUA-REAL-GAIN-ACS      Numeric 4                                 CU03.1
Realized Gain          A negative variance is posted to this
Subaccount             subaccount if conversion rates differ in
                       the opening and closing of a
                       transaction. The subaccount must be
                       defined in the General Ledger Account
                       Master file.


CUA-UNRL-GAIN-ACU      Alpha 15                                  CU03.1
Unrealized Gain        A negative variance is posted to this
Accting Unit           accounting unit if one exists when the
                       conversion rate is revalued at the end
                       of a period. The accounting unit must be
                       defined in the General Ledger Account
                       Master file.


CUA-UNRL-GAIN-ACT      Numeric 6                                 CU03.1
Unrealized Gain        A negative variance is posted to this
Account                account if one exists when the
                       conversion rate is revalued at the end
                       of a period. The account must be defined
                       in the General Ledger Account Master
                       file.


CUA-UNRL-GAIN-ACS      Numeric 4                                 CU03.1
Unrelized Gain         A negative variance is posted to this
Subaccount             subaccount if one exists when the
                       conversion rate is revalued at the end
                       of a period. The subaccount must be
                       defined in the General Ledger Account
                       Master file.


CUA-REAL-LOSS-ACU      Alpha 15                                  CU03.1
Realized Loss          A positive variance is posted to this
Accounting Unit        accounting unit if conversion rates
                       differ in the opening and closing of a
                       transaction. The accounting unit must be
                       defined in the General Ledger Account
                       Master file.


CUA-REAL-LOSS-ACT      Numeric 6                                 CU03.1
Realized Loss          A positive variance is posted to this
Account                account if conversion rates differ in
                       the opening and closing of a
                       transaction. The account must be defined
                       in the General Ledger Account Master
                       file.


CUA-REAL-LOSS-ACS      Numeric 4                                 CU03.1
Realized Loss          A positive variance is posted to this
Subaccount             subaccount if conversion rates differ in
                       the opening and closing of a
                       transaction. The subaccount must be
                       defined in the General Ledger Account
                       Master file.


CUA-UNRL-LOSS-ACU      Alpha 15                                  CU03.1
Unrealized Loss        A positive variance is posted to this
Acct Unit              accounting unit if one exists when the
                       conversion rate is revalued at the end
                       of a period. The accounting unit must be
                       defined in the General Ledger Account
                       Master file.


CUA-UNRL-LOSS-ACT      Numeric 6                                 CU03.1
Unrealized Loss        A positive variance is posted to this
Account                account if one exists when the
                       conversion rate is revalued at the end
                       of a period. The account must be defined
                       in the General Ledger Account Master
                       file.


CUA-UNRL-LOSS-ACS      Numeric 4                                 CU03.1
Unrealized Loss        A positive variance is posted to this
Subaccount             subaccount if one exists when the
                       conversion rate is revalued at the end
                       of a period. The subaccount must be
                       defined in the General Ledger Account
                       Master file.


                         CUACCT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CUASET1   COMPANY       This path is used to retrieve the        AP170   AP180
          FR-CURR-CODE  gain/loss accounts for a company by      AP181   AP190
          TO-CURR-CODE  "From/To" currency and system.           AP191   AP30.4
          SYSTEM                                                 AR01.1  AR129
                                                                 AR130   AR131
                                                                 AR135   AR196
                                                                 AR30.1  AR30.8
                                                                 AR31.6  AR33.1
                                                                 AR33.3  AR33.6
                                                                 AR34.1  AR35.1
                                                                 AR44.3  AR48.3
                                                                 AR504   DT170
                                                                 DT180   DT181
                                                                 DT185   GL110
                                                                 GL191   CU03.1
                                                                 ...

CUASET2   CURRENCY-TABLEKeyChange
          FR-CURR-CODE
          TO-CURR-CODE
          COMPANY
          SYSTEM

                         CUACCT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Curelat        CURELAT      Required

                            CUA-CURRENCY-TABLE    -> CRL-CURRENCY-TABLE  (CRLSET1)
                            CUA-FR-CURR-CODE      -> CRL-FR-CURR-CODE
                            CUA-TO-CURR-CODE      -> CRL-TO-CURR-CODE

Gdt Real Gain  GLCHARTDTL   Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            CUA-REAL-GAIN-ACT     -> GDT-ACCOUNT
                            CUA-REAL-GAIN-ACS     -> GDT-SUB-ACCOUNT

Gdt Real Loss  GLCHARTDTL   Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            CUA-REAL-LOSS-ACT     -> GDT-ACCOUNT
                            CUA-REAL-LOSS-ACS     -> GDT-SUB-ACCOUNT

Gdt Unrl Gain  GLCHARTDTL   Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            CUA-UNRL-GAIN-ACT     -> GDT-ACCOUNT
                            CUA-UNRL-GAIN-ACS     -> GDT-SUB-ACCOUNT

Gdt Unrl Loss  GLCHARTDTL   Required

                            GLS-CHART-NAME        -> GDT-CHART-NAME
                            CUA-UNRL-LOSS-ACT     -> GDT-ACCOUNT
                            CUA-UNRL-LOSS-ACS     -> GDT-SUB-ACCOUNT

Glcodes        GLCODES      Required
                            When CUA-SYSTEM != Spaces

                            CUA-COMPANY           -> GCD-COMPANY
                            CUA-SYSTEM            -> GCD-SYSTEM

Glm Real Gain  GLMASTER     Required

                            CUA-COMPANY           -> GLM-COMPANY
                            CUA-REAL-GAIN-ACU     -> GLM-ACCT-UNIT
                            CUA-REAL-GAIN-ACT     -> GLM-ACCOUNT
                            CUA-REAL-GAIN-ACS     -> GLM-SUB-ACCOUNT

Glm Real Loss  GLMASTER     Required

                            CUA-COMPANY           -> GLM-COMPANY
                            CUA-REAL-LOSS-ACU     -> GLM-ACCT-UNIT
                            CUA-REAL-LOSS-ACT     -> GLM-ACCOUNT
                            CUA-REAL-LOSS-ACS     -> GLM-SUB-ACCOUNT

Glm Unrl Gain  GLMASTER     Required

                            CUA-COMPANY           -> GLM-COMPANY
                            CUA-UNRL-GAIN-ACU     -> GLM-ACCT-UNIT
                            CUA-UNRL-GAIN-ACT     -> GLM-ACCOUNT
                            CUA-UNRL-GAIN-ACS     -> GLM-SUB-ACCOUNT

Glm Unrl Loss  GLMASTER     Required

                            CUA-COMPANY           -> GLM-COMPANY
                            CUA-UNRL-LOSS-ACU     -> GLM-ACCT-UNIT
                            CUA-UNRL-LOSS-ACT     -> GLM-ACCOUNT
                            CUA-UNRL-LOSS-ACS     -> GLM-SUB-ACCOUNT

Glsystem       GLSYSTEM     Required

                            CUA-COMPANY           -> GLS-COMPANY