Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CAHEADER


                             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
Element: Company       The company number defined the            GL110   GLCC.1
                       allocations.

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


CAH-ALLOC-TYPE         Alpha 1                                   CA10.2  CA10.6
Element: Allocation TypThe 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
Element: Allocation TypThis field, used for drill around,
                       displays the Allocation Type field
                       values.


CAH-ALLOCATION-GRP     Alpha 12                                  CA10.2  CA10.6
Element: Allocation GroThe allocation group where an
                       allocation is stored.


CAH-STEP               Numeric 3                                 CA10.2  CA10.6
Element: 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
Element: 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
Element: Auto Zero PercThis field is used to determine if
                       amounts are to be zeroed out after
                       processing.
                       N = No
                       Y = Yes

CAH-AUTO-ZERO-1        Derived
Element: Auto Zero PercThis field, used for drill around,
                       displays the Auto Zero field values.


CAH-BEG-PERIOD         Numeric 2                                 CA10.2  CA10.6
Element: Beginning PeriThe 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
Element: Beginning YearThe beginning year you want to post
                       transactions in.


CAH-END-PERIOD         Numeric 2                                 CA10.2  CA10.6
Element: 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
Element: Ending Year   The last year you want to post
                       transactions in.


CAH-STATUS             Numeric 1                                 CA10.1  CA10.2
Element: 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
Element: Posting PeriodThe periods you want the allocation to
                       be processed in.


CAH-DAY                Numeric 2                                 CA10.2  CA10.6
Element: 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
Element: Last ProcessedThis is the last-processed year for the   GL500
                       allocation.


CAH-MAINT-DATE         Numeric 8  (yyyymmdd)                     CA10.1  CA10.2
Element: 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
Element: Journal Entry The journal entry number assigned in
                       GL40.1 (Journal Entry) assigned to the
                       allocation.


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


CAH-JE-TYPE-1          Derived
Element: Journal Entry 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
Element: Backposted PerThe 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
Element: Backposted YeaThe year you want to back-post the        CA190
                       allocation to.


CAH-SOURCE-CODE        Alpha 2                                   CA10.2  CA10.6
Element: 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
Element: 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
Element: Base Zone     The zone within the Lawson General
                       Ledger System where the transaction
                       originating.

CAH-BUDGET-NBR         Numeric 3                                 CA10.2  CA10.6
Element: 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
Element: Contra AccountYou 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
Element: Contra SubaccoYou 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 11.4                               CA10.1  CA10.4
Element: Total PercentaThis 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
Element: Last Line UsedThis 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
Element: 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
Element: 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
Element: Auto Reversal This field, used for drill around,
                       displays the auto reversal sign.


CAH-JRNL-BOOK-NBR      Alpha 12                                  CA10.2  CA10.6
Element: Journal Book NThe journal book assigned to the
                       transaction.

CAH-MX-VALUE-APPLY     Alpha 1                                   CA10.2
Element: 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
Element: 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
Element: Apply ActivityThis 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
Element: Apply Segment 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
Element: Apply Segment 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       KeyChange, 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   GL110

CAHSET5   COMPANY       KeyChange                                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