Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             CAHEADER FILE

                           Allocation Header

The Allocation Header file contains allocation control information used to
process allocation detail records.


REFERENCED BY

CA110     CA215     CA240     GLCC.1    IFGT.1    CA199
CA00.1    CA00.2    CA200

UPDATED BY

CA10.1    CA10.2    CA10.4    CA10.6    CA10.7    CA15.1
CA15.2    CA190     CA195     CA210     GL110     GL500

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

CAH-COMPANY          Numeric 4                                   CA10.2  CA10.6
Company              The company number allocations are          GL110   GLCC.1
                     defined for.


CAH-ALLOC-NAME       Alpha 12                                    CA10.2  CA10.6
Allocation           The allocation name represents an           GLCC.1
                     allocation as defined in CA10.1
                     (Allocation).


CAH-ALLOC-TYPE       Alpha 1                                     CA10.2  CA10.6
Allocation Type      The allocation type determines where        GLCC.1
                     funds are allocated to. The default is
                     Actual.

                     You can select Current Year budget or
                     Next Year budget.


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

CAH-ALLOC-TYPE-1     Derived
Allocation Type 1    This field, used for drill around,
                     displays the Allocation Type field
                     values.


CAH-ALLOCATION-GRP   Alpha 12                                    CA10.2  CA10.6
Allocation Group     The allocation group where an
                     allocation is stored.


CAH-STEP             Numeric 3                                   CA10.2  CA10.6
Step Value           This field determines when an
                     allocation detail line will get
                     processed.  All lower steps are
                     processed before processing higher
                     steps.
                     001
                     999
                     000 = Defined on Detail

CAH-DESCRIPTION      Alpha 30  (Lower Case)                      CA10.2  CA10.6
Allocation           The description of the allocation.
Description

CAH-OPERATOR         Alpha 10                                    CA10.2  CA10.6
Operator             This field is used to store the login
                     ID of the person who entered the record.



CAH-AUTO-ZERO        Alpha 1                                     CA10.2  CA10.6
Auto Zero Percent    This field is used to determine if
                     amounts are to be zeroed out after
                     processing.
                     N = No
                     Y = Yes

CAH-AUTO-ZERO-1      Derived
Auto Zero Percent 1  This field, used for drill around,
                     displays the Auto Zero field values.


CAH-BEG-PERIOD       Numeric 2                                   CA10.2  CA10.6
Beginning Period     The beginning period you want to post
                     transactions in.

                     01 = Period 1
                     02 = Period 2
                     03 = Period 3
                     04 = Period 4
                     05 = Period 5
                     06 = Period 6
                     07 = Period 7
                     08 = Period 8
                     09 = Period 9
                     10 = Period 10
                     11 = Period 11
                     12 = Period 12
                     13 = Period 13

CAH-BEG-YEAR         Numeric 4                                   CA10.2  CA10.6
Beginning Year       The beginning year you want to post
                     transactions in.


CAH-END-PERIOD       Numeric 2                                   CA10.2  CA10.6
Ending Period        The last period you want to post
                     transactions in.

                     01 = Period 1
                     02 = Period 2
                     03 = Period 3
                     04 = Period 4
                     05 = Period 5
                     06 = Period 6
                     07 = Period 7
                     08 = Period 8
                     09 = Period 9
                     10 = Period 10
                     11 = Period 11
                     12 = Period 12
                     13 = Period 13

CAH-END-YEAR         Numeric 4                                   CA10.2  CA10.6
Ending Year          The last year you want to post
                     transactions in.


CAH-STATUS           Numeric 1                                   CA10.1  CA10.2
Status               This field indicates the transaction        CA10.7  CA15.1
                     status: Released or Unreleased.             CA15.2  CA190

                     1 = Released
                     0 = Unreleased

CAH-POST-PERIOD      Alpha 1 Occurs 13 Times                     CA10.2  CA10.6
Posting Period       The periods you want the allocation to
                     be processed in.


CAH-DAY              Numeric 2                                   CA10.2  CA10.6
Posting Day          The day you want to post transactions.
                     If you leave this field blank, the
                     period end date defined for the company
                     in GL10.1 (Company) defaults.


CAH-LP-PERIOD        Numeric 2                                   CA190   CA195
Last Processed       This is the last-processed period for       GL500
Period               the allocation.


CAH-LP-YEAR          Numeric 4                                   CA190   CA195
Last Processed Year  This is the last-processed year for the     GL500
                     allocation.


CAH-MAINT-DATE       Numeric 8  (yyyymmdd)                       CA10.1  CA10.2
Last Changed         This is the date the allocation was         CA10.4  CA10.6
                     most recently changed.                      CA10.7  CA15.1
                                                                 CA15.2

CAH-JE-NBR           Numeric 8                                   CA10.2  CA10.6
Journal Entry Number The journal entry number assigned in
                     GL40.1 (Journal Entry) assigned to the
                     allocation.


CAH-JE-TYPE          Alpha 1                                     CA10.2  CA10.6
Journal Entry Type   The type of journal entry associated
                     with the allocation: Normal or
                     Intercompany.


CAH-JE-TYPE-1        Derived
Journal Entry Type 1 This field, used for drill around,
                     displays the Journal Entry Type field
                     values.


CAH-BKPST-JE-NBR     Numeric 8                                   CA15.1  CA15.2
Backposted Journal   This is the journal entry number to be      CA190
Entry Nbr            used for back-posting this allocation.


CAH-BKPST-PERIOD     Numeric 2                                   CA15.1  CA15.2
Backposted Period    The period you want to back-post the        CA190
                     allocation to. The period must be open
                     for back-posting in the General Ledger
                     system.


CAH-BKPST-YEAR       Numeric 4                                   CA15.1  CA15.2
Backposted Year      The year you want to back-post the          CA190
                     allocation to.


CAH-SOURCE-CODE      Alpha 2                                     CA10.2  CA10.6
Source Code          A two character code assigned to a
                     transaction to identify where the
                     transaction was created.

CAH-REFERENCE        Alpha 10  (Lower Case)                      CA10.2  CA10.6
Reference            Reference is a user-defined field used
                     to track transactions. For example, type
                     a purchase order number for audit
                     purposes.


CAH-BASE-ZONE        Alpha 15                                    CA10.2  CA10.6
Base Zone            The zone within the Lawson General
                     Ledger System where the transaction
                     originating.

CAH-BUDGET-NBR       Numeric 3                                   CA10.2  CA10.6
Budget               If you select Current Year or Next Year
                     Budget in the Type field, type or select
                     the budget number you want to allocate
                     from.

                     The budget must exist in FB20.1 (Period
                     Budget, Rate).



CAH-CTRA-AU          Alpha 15                                    CA10.2  CA10.6
Contra Accounting    You can use a contra account to retain
Unit                 the integrity of your original data. The
                     accounting unit you type here will
                     replace the data in the From Accounting
                     Unit field when you run CA110
                     (Allocation Calculation).

                     If you use a contra account, the amount
                     will appear on the Journal Entry for
                     audit purposes.

                     For example: If you want to allocate 50
                     percent from account 41000's balance of
                     $5000, you can use contra account 42000
                     to allocate $2500 while keeping the
                     integrity of account 41000's original
                     balance.




CAH-CTRA-ACCOUNT     Numeric 6                                   CA10.2  CA10.6
Contra Account       You can use a contra account to retain
                     the integrity of your original data. The
                     account you type here will replace the
                     data in the From Account field when you
                     run CA110 (Allocation Calculation).

                     If you use a contra account, the amount
                     will appear on the Journal Entry for
                     audit purposes.

                     For example: If you want to allocate 50
                     percent from account 41000's balance of
                     $5000, you can use contra account 42000
                     to allocate $25000 while keeping the
                     integrity of account 41000's original
                     balance.




CAH-CTRA-SUB-ACCT    Numeric 4                                   CA10.2  CA10.6
Contra Subaccount    You can use a contra subaccount to
                     retain the integrity of you original
                     data. The subaccount you type here will
                     replace the data in the From Subaccount
                     field when you run CA110 (Allocation
                     Calculation).

                     If you use a contra account, the amount
                     will appear on the Journal Entry for
                     audit purposes.

                     For example: If you want to allocate 50
                     percent from account 41000's balance of
                     $5000, you can use contra account 42000
                     to allocate $2500 while keeping the
                     integrity of account 41000's original
                     balance.




CAH-TOTAL-PCT        Signed 7.4                                  CA10.1  CA10.4
Total Percentage     This field displays the total               CA10.6  CA10.7
                     percentage for all allocation detail        CA190   CA195
                     lines.


CAH-LAST-CMT-SEQ     Numeric 4
Last Comment         This is the sequence number of the last
Sequence             comment for the transaction.


CAH-LAST-LINE-NBR    Numeric 6                                   CA10.1  CA10.4
Last Line Used       This is the number of the last line         CA10.6  CA10.7
                     item added to the transaction. It is        CA210
                     used to determine the number for the
                     next line added to the transaction.


CAH-NBR-LINES        Numeric 6                                   CA10.1  CA10.4
Line Number          This is the number of detail lines.         CA10.6  CA10.7

CAH-NBR-CMT-LINES    Numeric 6
Number of Comment    This is the number of comment lines for
Lines                the transaction.


CAH-AUTO-REV         Alpha 1                                     CA10.2  CA10.6
Auto Reversal        If you select Yes in this field, the
                     Lawson General  Ledger Closing program
                     GL199 creates an opposite entry for this
                     transaction in the next period.

                     The default is No.


CAH-AUTO-REV-1       Derived
Auto Reversal 1      This field, used for drill around,
                     displays the auto reversal sign.


CAH-JRNL-BOOK-NBR    Alpha 12                                    CA10.2  CA10.6
Journal Book Number  The journal book assigned to the
                     transaction.

CAH-MX-VALUE-APPLY   Alpha 1                                     CA10.2
Apply Value          You can select the type of account the
                     activity (from the Activity Management
                     system) applies to.

                     When you post, the program creates
                     transactions in the Activity Management
                     and General Ledger systems.


                     B = Both
                     F = From Accounts
                     T = To Accounts

CAH-MX-VALUE         Alpha 32 Occurs 3 Times                     CA10.2  CA10.6
Value                This is a transaction matrix value
                     associated  with the allocation
                     transaction. You can assign a matrix
                     value for each matrix category assigned
                     to the source code. You can define up to
                     three categories for each source code
                     using GL05.1.


CAH-ACTIVITY-APPLY   Alpha 1                                     CA10.2  CA10.6
Apply Activity       This field determines the transaction
                     type applied to the activity. You can
                     select Both Sides of the Allocation,
                     Post To Accounts, and Post From
                     Accounts.

                     When you post, the system creates
                     transaction in the Activity Management
                     and General Ledger systems.


                     T = Post To Accounts
                     F = Post From Accounts
                     B = Both Post To And From Accounts

CAH-SEGMENT-APPLY    Alpha 1                                     CA10.2
Apply User Analysis  This field determines where the user
                     analysis values are applied for an
                     allocation.

                     T = Post To Accounts
                     F = Post From Accounts
                     B = Both Accounts

CAH-SEGMENT-BLOCK    Alpha 103
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.

                         CAHEADER FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CAHSET1   COMPANY                                                CA10.1  CA10.2
          ALLOC-NAME                                             CA10.4  CA10.5
          ALLOC-TYPE                                             CA10.6  CA10.7
                                                                 CA110   CA15.1
                                                                 CA190   CA195
                                                                 CA210   CA215
                                                                 CA240   GL110
                                                                 GL500   GLCC.1
                                                                 IFGT.1

CAHSET2   COMPANY       KeyChange                                CA10.2  CA10.6
          JE-NBR
          JE-TYPE
          ALLOC-NAME
          ALLOC-TYPE

CAHSET3   COMPANY       Subset                                   CA10.2  CA10.6
          BKPST-JE-NBR  Where BKPST-JE-NBR != Zeroes             CA15.1  CA15.2
          JE-TYPE
          ALLOC-NAME
          ALLOC-TYPE

CAHSET4   COMPANY                                                CA10.1  CA10.2
          ALLOC-TYPE                                             CA10.4  CA10.6
          ALLOC-NAME                                             CA10.7  CA110
                                                                 CA15.1  CA15.2
                                                                 CA199

CAHSET5   COMPANY                                                CA15.1  CA215
          STEP
          ALLOC-NAME
          ALLOC-TYPE

CAHSET6   ALLOCATION-GRPKeyChange                                CA00.1  CA00.2
          ALLOC-TYPE                                             CA110   CA15.2
          COMPANY                                                CA200
          ALLOC-NAME

CAHSET7   ALLOCATION-GRPKeyChange                                CA15.2  CA215
          STEP
          COMPANY
          ALLOC-NAME
          ALLOC-TYPE

                         CAHEADER FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Allocation Grp CAALLOCGRP   Not Required

                            CAH-ALLOCATION-GRP    -> CAG-ALLOCATION-GRP

Company        GLSYSTEM     Required

                            CAH-COMPANY           -> GLS-COMPANY

Glmaster       GLMASTER     Not Required

                            CAH-COMPANY           -> GLM-COMPANY
                            CAH-CTRA-AU           -> GLM-ACCT-UNIT
                            CAH-CTRA-ACCOUNT      -> GLM-ACCOUNT
                            CAH-CTRA-SUB-ACCT     -> GLM-SUB-ACCOUNT

Source Code    GLCODES      Not Required

                            CAH-SOURCE-CODE       -> GCD-SOURCE-CODE

                         CAHEADER FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Alloc Detail   CADETAIL     Delete Restricted

                            CAH-COMPANY           -> CAD-COMPANY
                            CAH-ALLOC-NAME        -> CAD-ALLOC-NAME
                            CAH-ALLOC-TYPE        -> CAD-ALLOC-TYPE
                                                     CAD-LINE-NBR

Fbheader       FBHEADER

                            CAH-COMPANY           -> FBH-COMPANY
                            CAH-BUDGET-NBR        -> FBH-BUDGET-NBR
                                                     FBH-FISCAL-YEAR