Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CATRANS


                              CATRANS FILE

                        Allocation Transactions

The Allocation Transaction file contains the allocations transactions to be
posted to the Lawson General Ledger system.


REFERENCED BY

CA15.1    CA15.2    CA210     CA215     CA290     GLRV.1
MLRV.1

UPDATED BY

CA10.2    CA10.4    CA110     CA190     CA195     GL110
GL500

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CAT-COMPANY            Numeric 4                                 CA110   GL500
Element: Company       The company number you are defining the
                       allocation for.


CAT-ALLOC-NAME         Alpha 12                                  CA110   GL500
Element: Allocation    The allocation name represents an
                       allocation as defined in CA10.1
                       (Allocation).


CAT-ALLOC-TYPE         Alpha 1                                   CA110   GL500
Element: Allocation TypThis field defines what the allocation
                       affects: actual amounts, current year
                       budget, or next year's budget.

                       A = Actual
                       C = Current Year Budget
                       N = Next Year Budget

CAT-LINE-NBR           Numeric 6                                 CA110   GL500
Element: Line Number   This field contains the allocation
                       detail line number.


CAT-ALLOCATION-GRP     Alpha 12                                  CA110
Element: Allocation GroThe allocation group where the
                       allocation is stored.


CAT-SEQ-NUMBER         Numeric 6                                 CA110   GL500
Element: Sequence NumbeThe sequence number is a unique number
                       assigned to each transaction.


CAT-FISCAL-YEAR        Numeric 4                                 CA110   GL500
Element: Fiscal Year   This is the fiscal year for the
                       transaction.


CAT-ACCT-PERIOD        Numeric 2                                 CA110   GL500
Element: Accounting PerThis is the accounting period for the
                       transaction.


CAT-TRANS-TYPE         Alpha 1                                   CA110   GL500
Element: Transaction TyThis field determines whether amounts
                       or units are processed for the
                       transaction.

                       A = Amounts
                       U = Units

CAT-STEP               Numeric 3                                 CA110   GL500
Element: Step          This field determines when in a series
                       of steps an allocation detail line gets
                       processed. Lower-numbered steps are
                       processed before higher steps.


CAT-ACCOUNT            Numeric 6                                 CA110   GL500
Element: Account       This field and the accounting unit and
                       subaccount define the location (account)
                       where amounts and other account
                       information are stored.


CAT-SUB-ACCOUNT        Numeric 4                                 CA110   GL500
Element: Subaccount    This field and the accounting unit and
                       account define the location (account)
                       where amounts and other account
                       information are stored.


CAT-GLT-COMPANY        Numeric 4                                 CA110   GL500
Element: Company       This is the company the transactions
                       are for.


CAT-ACCT-UNIT          Alpha 15                                  CA110   GL500
Element: Accounting UniThe accounting unit is a shorthand
                       notation representing a location
                       (variable level) in the company
                       structure. The accounting unit must be
                       defined in the General Ledger Names file
                       as a posting accounting unit.


CAT-TO-BUDGET          Numeric 3                                 CA110   GL500
Element: To Budget     This is the budget allocated to.

CAT-BKPST-FLAG         Alpha 1                                   CA110   GL500
Element: Backposting FlThis field determines whether the
                       transaction is to be back-posted.

                       Y = Yes
                       N = No

CAT-RECORD-TYPE        Alpha 1                                   CA110   GL500
Element: Record Type   This field indicates the type of record
                       defined: To or From.

                       F = From
                       T = To

CAT-AMOUNT-UNITS       Signed 15.2 Occurs 13 Times               CA110   GL500
Element: Amounts or UniThis field indicates the amounts or
                       units to be posted to an account for the
                       period.


CAT-RPT-AMOUNT-1       Signed 15.2 Occurs 13 Times               CA110
Element: Adj Amt       This field stores the amounts calculatd
                       by CA110 in Report Currency 1.

CAT-RPT-AMOUNT-2       Signed 15.2 Occurs 13 Times               CA110
Report Currency 2      This field stores the amounts calculated
Amount                 by CA110 in Report Currency 2.

CAT-TRAN-ND            Numeric 1                                 CA110   GL500
Element: Transaction NuThis is the number of decimal positions
                       used for the transaction.


CAT-JE-NBR             Numeric 8                                 CA110   GL500
Element: Journal Entry This is the journal entry number in the
                       Lawson General Ledger system.


CAT-JE-TYPE            Alpha 1                                   CA110   GL500
Element: Journal Entry The type of the journal entry: normal
                       or intercompany.

                       N = Normal
                       I = Intercompany

CAT-JE-DESC            Alpha 30                                  CA110   GL500
Journal Entry          This is the journal entry description.
Description

CAT-ACTIVITY           Alpha 15                                  CA110   GL500
Element: Activity      The activity associated with the
                       allocation.



CAT-ACCT-CATEGORY      Alpha 5                                   CA110   GL500
Element: Account CategoThe account category associated with
                       the allocation.

                       Account categories are the Activity
                       Management accounts by which activity
                       transactions are grouped for budgeting
                       and reporting. Set up account categories
                       for an activity before you do any
                       budgeting or transaction processing.
                       Using account categories, you can sort
                       and combine incoming amounts into groups
                       for reporting and inquiry on activities.


                       You can tie account categories to
                       general ledger accounts using AC07.1
                       (Account Assignment). You can  also
                       streamline your maintenance of changes
                       to general ledger accounts; use AC04.1
                       (GL Code) to define GL codes to
                       represent general ledger accounts.




CAT-AUTO-REV           Alpha 1                                   CA110   GL500
Element: Auto Reversal When the Auto Reversal field is Yes,
                       GL199 (Period Closing) creates an
                       opposite entry for this transaction in
                       the next period.

                       Y = Yes
                       N = No

CAT-TRANS-DATE         Numeric 8  (yyyymmdd)                     CA110   GL500
Element: Transaction Date

CAT-SEGMENT-BLOCK      Alpha 103                                 CA110   GL500
Element: User Analysis This field identifies the user analysis
                       values included in the transaction.

                       You can either type up to four values
                       or use Define (F6) to open the User
                       Analysis Entry subform. Use this subform
                       to select the user analysis values you
                       want to include in the transaction. If
                       you choose to type values, use commas to
                       separate them. For example:
                       value1,value2,value3,value4

                       There are three conditions that affect
                       how you can select user analysis values.
                       See the User Analysis Entry form help or
                       the Strategic Ledger procedures manual
                       for additional information.

                         CATRANS FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CATSET1   COMPANY                                                CA10.1  CA10.2
          ALLOC-NAME                                             CA10.4  CA10.5
          ALLOC-TYPE                                             CA10.7  CA15.1
          LINE-NBR                                               CA15.2  CA210
          SEQ-NUMBER                                             CA215   GL500

CATSET2   COMPANY       KeyChange                                CA110
          ALLOC-TYPE
          STEP
          ALLOC-NAME
          SEQ-NUMBER

CATSET3   COMPANY       KeyChange                                CA190   CA195
          FISCAL-YEAR                                            GL110
          ACCT-PERIOD
          ALLOC-TYPE
          ALLOC-NAME
          STEP
          GLT-COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          SEQ-NUMBER

CATSET4   FISCAL-YEAR   KeyChange                                CA290   GLRV.1
          ACCT-PERIOD                                            MLRV.1
          ALLOC-TYPE
          TRANS-TYPE
          GLT-COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          STEP
          SEQ-NUMBER
          COMPANY
          ALLOC-NAME

CATSET5   ALLOCATION-GRPKeyChange                                CA190
          COMPANY
          FISCAL-YEAR
          ACCT-PERIOD
          ALLOC-TYPE
          ALLOC-NAME
          STEP
          GLT-COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          SEQ-NUMBER

CATSET6   ALLOCATION-GRPKeyChange                                GLRV.1  MLRV.1
          FISCAL-YEAR
          ACCT-PERIOD
          ALLOC-TYPE
          TRANS-TYPE
          GLT-COMPANY
          ACCT-UNIT
          ACCOUNT
          SUB-ACCOUNT
          STEP
          SEQ-NUMBER
          COMPANY
          ALLOC-NAME

                         CATRANS FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Account        GLMASTER     Required

                            CAT-GLT-COMPANY    -> GLM-COMPANY
                            CAT-ACCT-UNIT      -> GLM-ACCT-UNIT
                            CAT-ACCOUNT        -> GLM-ACCOUNT
                            CAT-SUB-ACCOUNT    -> GLM-SUB-ACCOUNT

Acct Unit      GLNAMES      Required

                            CAT-GLT-COMPANY    -> GLN-COMPANY
                            CAT-ACCT-UNIT      -> GLN-ACCT-UNIT

Alloc Name     CAHEADER     Not Required

                            CAT-COMPANY        -> CAH-COMPANY
                            CAT-ALLOC-NAME     -> CAH-ALLOC-NAME
                            CAT-ALLOC-TYPE     -> CAH-ALLOC-TYPE

Chart Detail   GLCHARTDTL   Not Required

                            GLS-CHART-NAME     -> GDT-CHART-NAME
                            CAT-ACCOUNT        -> GDT-ACCOUNT
                            CAT-SUB-ACCOUNT    -> GDT-SUB-ACCOUNT

Company        GLSYSTEM     Required

                            CAT-COMPANY        -> GLS-COMPANY

To Company     GLSYSTEM     Not Required

                            CAT-GLT-COMPANY    -> GLS-COMPANY