Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

CADETAIL


                             CADETAIL FILE

                           Allocation Detail

The Allocation Detail file contains the allocation detail information defined
that is used to allocate amounts from a company accounting structure to
another company accounting structure.


REFERENCED BY

CA15.1    CA15.2    CA215     CA240     RW298     CA110

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CAD-COMPANY            Numeric 4                                 CA10.1  CA10.4
Element: Company       The company number related to the         CA10.7  CA210
                       allocation detail line.                   GL110   RW298

CAD-ALLOC-NAME         Alpha 12                                  CA10.1  CA10.4
Element: Allocation NamThe allocation name represents an         CA10.6  CA10.7
                       allocation as defined in CA10.1           CA210   RW298
                       (Allocation).


CAD-ALLOC-TYPE         Alpha 1                                   CA10.1  CA10.4
Element: Allocation TypThis field defines where the allocation   CA10.6  CA10.7
                       will take place.                          CA210   RW298
                       The values are:
                       A = Actuals
                       C = Currency Year Budget
                       N = Next Year Budget

CAD-ALLOC-TYPE-1       Derived
Element: Allocation TypThis field, used for drill around,
                       displays the Allocation Type field
                       values.


CAD-LINE-NBR           Numeric 6                                 CA10.1  CA10.4
Element: Line Number   This field contains the allocation        CA10.7  CA15.1
                       detail line number.                       CA15.2  CA210
                                                                 RW298

CAD-ALLOCATION-GRP     Alpha 12                                  CA10.1  CA10.2
Element: Allocation GroThe allocation group where an             CA10.4  CA10.6
                       allocation is stored.                     CA10.7  CA210


CAD-STEP               Numeric 3                                 CA10.1  CA10.2
Element: Step          This field determines when an             CA10.4  CA10.6
                       allocation detail line will get           CA10.7  CA210
                       processed.  All lower steps are
                       processed before processing higher
                       steps.

CAD-TRANS-TYPE         Alpha 1                                   CA10.1  CA10.6
Element: Transaction TyThe allocation type for each line. The    CA10.7  CA210
                       default is Amount.

                       To allocate units, the Post From and
                       Post To accounts must allow units. You
                       can verify this in GL20.1 (Chart of
                       Accounts).


                       A = Amounts
                       U = Units

CAD-TRANS-TYPE-1       Derived
Element: Transaction TyThis field, used for drill around,
                       displays the Transaction Type field
                       values.


CAD-ALLOC-PERCENT      Signed 7.4                                CA10.1  CA10.7
Element: Line Percent  The amount to be allocated.               CA190   CA195
                                                                 CA210
                       The percentage you define multiplied by
                       the From Company account balance = the
                       amount allocated.

                       If you leave this field blank, 100
                       percent defaults.



CAD-AUTO-REV           Alpha 1                                   CA10.1  CA10.6
Element: Auto Reversal If you select Yes in this field, GL 199   CA10.7  CA210
                       (Period Closing) creates an opposite
                       entry for this transaction in the next
                       period.

                       The default is No.

                       Y = Yes
                       N = No

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


CAD-ACTIVITY           Alpha 15                                  CA10.1  CA10.6
Element: Activity      The activity associated with the          CA10.7  CA210
                       allocation.  An activity is defined in
                       Activity Management (AC10.1)


CAD-ACCT-CATEGORY      Alpha 5                                   CA10.1  CA10.6
Element: Account CategoThe account category associated with the  CA10.7  CA210
                       allocation.
                       The Account category must exist in
                       Activity Management and must be valid
                       for the activity.



CAD-PT-COMPANY         Numeric 4                                 CA10.1  CA10.7
Element: Posting-To ComThe company number to which the amounts   CA210   GL110
                       are allocated.

                       If you select a post-to company and
                       accounting unit, leave the Allocation
                       Code field blank.

CAD-PT-ACCT-UNIT       Alpha 15                                  CA10.1  CA10.7
Posting-To             The accounting unit to which the          CA210
Accounting Unit        amounts are allocated

                       If you select a post-to company and
                       accounting  unit, leave the Allocation
                       Code field  blank.

CAD-PT-ALLOC-CODE      Alpha 12                                  CA10.1  CA10.7
Posting-To             The allocation code used to allocate to   CA110   CA210
Allocation Code        multiple accounting units.

                       You cannot use an allocation code with a
                       compute statement.



CAD-PT-ACCOUNT         Numeric 6                                 CA10.1  CA10.7
Element: Posting-To AccThe account number to which amounts are   CA210
                       allocated.

                       If you select an override account range
                       and an error occurs when you run CA110
                       (Allocation Calculation), this account
                       defaults. If this account is invalid,
                       the system uses the company error
                       suspense account.

CAD-PT-SUB-ACCT        Numeric 4                                 CA10.1  CA10.7
Posting-To             The subaccount number to which amounts    CA210
Subaccount             are allocated.

                       If you select an override subaccount
                       range and an error occurs when you run
                       CA110 (Allocation Calculation), this
                       subaccount defaults. If this subaccount
                       is invalid, the system uses the company
                       error suspense account.

CAD-PT-DETAIL-OPT      Alpha 1                                   CA10.1  CA10.7
Posting-To Detail      Determines the Accounting Unit and        CA210
Option                 Account allocation detail on the Post to
                       side. The default is Consolidate.

                       Select one of the following Post To
                       options:

                       Consolidate creates one transaction line
                       for each variable in the From Accounting
                       Unit and Account fields.

                       Level Detail creates as many transaction
                       lines as there are unique variable
                       levels in the override information. The
                       transaction contains the From Account
                       and From Subaccount fields.

                       Account Detail creates as many
                       transaction lines as there are unique
                       accounts and subaccounts in the override
                       information.  The transaction contains
                       the To side accounting unit.

                       Full Detail creates as many transaction
                       lines as there are unique accounting
                       unit, account, and subaccount
                       combinations in the override
                       information.
                       C = Consolidate
                       L = Level Detail
                       A = Acct Detail
                       D = Full Detail

CAD-PT-DET-OPT-1       Derived
Posting-To Detail      This field, used for drill around,
Option 1               displays the Posting-To Detail Option
                       field values.


CAD-PF-ACCT-UNIT       Alpha 15                                  CA10.1  CA10.7
Posting-From           The accounting unit from which the        CA210
Accounting Unit        amounts are allocated.

                       If you select override accounting unit
                       information, the program overrides this
                       field when determining the allocated
                       amount.

CAD-PF-ACCOUNT         Numeric 6                                 CA10.1  CA10.7
Element: Posting-From AThe account number from which the         CA210
                       amounts are allocated.

                       If you select override account
                       information, the program overrides this
                       field when determining the allocated
                       amount.

CAD-PF-SUB-ACCT        Numeric 4                                 CA10.1  CA10.7
Posting-From           The subaccount number from which the      CA210
Subaccount             amounts are allocated.

                       If you select override subaccounts or a
                       subaccount group, the program overrides
                       this subaccount when determining the
                       allocated amount.

CAD-PF-DETAIL-OPT      Alpha 1                                   CA10.1  CA10.7
Posting-From Detail    The allocation amount that is created     CA210
Option                 when you post. The default is
                       Consolidate.

                       Select one of the following Post From
                       options:

                       Consolidate creates one transaction line
                       for each variable level in the From
                       Accounting Unit and Account fields.

                       Level Detail creates as many transaction
                       lines as there are unique variable
                       levels for the From Accounting Unit
                       override fields. The transaction uses
                       the account and subaccount in the From
                       detail line.

                       Account Detail creates as many
                       transaction lines as there are unique
                       accounts and subaccounts in the override
                       information.  The transaction uses the
                       accounting unit on the From detail line.


                       Full Detail creates as many transaction
                       lines as there are unique accounting
                       unit, account, and subaccount
                       combinations in the override
                       information.
                       C = Consolidate
                       L = Level Detail
                       A = Acct Detail
                       D = Full Detail

CAD-PF-DET-OPT-1       Derived
Posting-From Detail    This field, used for drill around,
Option 1               displays the Posting-From Detail Option
                       field values.


CAD-COMPUTE-NAME       Alpha 12                                  CA10.1  CA10.7
Element: Compute Name  The compute statement used to determine   CA210
                       the percent allocated.

                       You cannot select a compute statement if
                       you selected an allocation code.



CAD-ACCT-UNIT          Alpha 15 Occurs 3 Times                   CA10.1  CA10.7
Element: Accounting UniThe override accounting unit.             CA210

CAD-FR-ACCOUNT         Numeric 6                                 CA10.1  CA10.7
Element: From Account  The override From account range           CA210
                       If you select an account range, leave
                       the Account Group field blank.

CAD-TH-ACCOUNT         Numeric 6                                 CA10.1  CA10.7
Element: Through AccounThe override Through account range.       CA210
                       If you leave this field blank, the from
                       value defaults.

CAD-FR-SUB-ACCT        Numeric 4                                 CA10.1  CA10.7
Element: From SubaccounThe override From subaccount range.       CA210

                       You cannot select a subaccount range and
                       a subaccount group.

CAD-TH-SUB-ACCT        Numeric 4                                 CA10.1  CA10.7
Element: Through SubaccThe override through subaccount range.    CA210

                       You cannot select a subaccount range and
                       a subaccount group.

CAD-LEVEL-GROUP        Alpha 12                                  CA10.1  CA10.7
Element: Level Group   The override level group.                 CA210

CAD-ACCOUNT-GROUP      Alpha 12                                  CA10.1  CA10.7
Element: Account Group The override account group.               CA210

CAD-SUB-ACCT-GRP       Alpha 12                                  CA10.1  CA10.7
Element: Subaccount GroThe override subaccount group.            CA210
                       You cannot select a subaccount group and
                       an override subaccount range.

CAD-JE-DESC            Alpha 30                                  CA10.1  CA10.6
Journal Entry          You can type a journal entry              CA10.7  CA210
Description            description that identifies what journal
                       entry number the allocation will post
                       to.


CAD-MATRIX-LIST        Alpha 12                                  CA10.1  CA10.7
Element: Accounting UniThe override accounting unit list.        CA210

CAD-CHART-NAME         Alpha 12                                  CA10.1  CA10.7
Element: Chart Name    The chart of accounts name.               CA210

                       If you select a chart of accounts,
                       select a summary account.

CAD-SUMRY-ACCT-ID      Numeric 6                                 CA10.1  CA10.7
Element: Summary AccounThe identifier for the summary account.   CA210

CAD-SEGMENT-BLOCK      Alpha 103                                 CA10.1  CA10.7
Element: Segment Block This field identifies the user analysis   CA210
                       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.

CAD-ACCOUNT-LIST       Alpha 12                                  CA10.1  CA10.7
Element: Account List  The override account List.                CA210

CAD-POOL-ACCT-UNIT     Alpha 15 Occurs 4 Times                   CA10.1  CA10.7
Element: Pool AccountinThe pool accounting unit can be used
                       with a compute data name, such as CPAMT,
                        when the source accounting unit amount
                       is different than the post from
                       accounting unit.

CAD-POOL-AU-LIST       Alpha 12                                  CA10.1  CA10.7
Pool Accounting        The pool accounting unit list can be
Unit List              used with a compute data name, such as
                       CPAMT, when the source amount account
                       units are different than the post from
                       accounting units..

CAD-POOL-LVL-GRP       Alpha 12                                  CA10.1  CA10.7
Element: Pool Level GroThe pool level group can be used with a
                       compute data name, such as CPAMT, when
                       the source accounting units are
                       different that the post from accounting
                       units.

                         CADETAIL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CADSET1   COMPANY                                                CA10.1  CA10.2
          ALLOC-NAME                                             CA10.4  CA10.5
          ALLOC-TYPE                                             CA10.6  CA10.7
          LINE-NBR                                               CA15.1  CA15.2
                                                                 CA190   CA195
                                                                 CA210   CA215
                                                                 CA240   GL110
                                                                 RW298

CADSET2   COMPANY       KeyChange                                CA110
          ALLOC-TYPE
          STEP
          ALLOC-NAME
          LINE-NBR

CADSET3   COMPANY       KeyChange                                CA110
          ALLOC-TYPE
          ALLOC-NAME
          STEP
          LINE-NBR

CADSET4   ALLOCATION-GRPKeyChange                                CA110   CA190
          COMPANY
          ALLOC-TYPE
          STEP
          ALLOC-NAME
          LINE-NBR

                         CADETAIL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

All Cod Hdr    ACHEADER     Not Required

                            CAD-PT-ALLOC-CODE    -> ALH-ALLOC-CODE

Allocation     CAHEADER     Required

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

Company        GLSYSTEM     Required

                            CAD-COMPANY          -> GLS-COMPANY

Compute        CMPUTE       Not Required

                            CAD-COMPUTE-NAME     -> CMP-COMPUTE-NAME

From Chart Dtl GLCHARTDTL   Not Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            CAD-PF-ACCOUNT       -> GDT-ACCOUNT
                            CAD-PF-SUB-ACCT      -> GDT-SUB-ACCOUNT

Glchart        GLCHART      Not Required

                            CAD-CHART-NAME       -> GCH-CHART-NAME

Glchartsum     GLCHARTSUM   Not Required

                            CAD-CHART-NAME       -> GCS-CHART-NAME
                            CAD-SUMRY-ACCT-ID    -> GCS-SUMRY-ACCT-ID

Mxlisthdr      MXLISTHDR    Not Required

                            "ACCTU"              -> MLH-OBJ-TYPE
                            CAD-MATRIX-LIST      -> MLH-MATRIX-LIST

Post Fr Au     GLNAMES      Required

                            CAD-COMPANY          -> GLN-COMPANY
                            CAD-PF-ACCT-UNIT     -> GLN-ACCT-UNIT

Post To Au     GLNAMES      Not Required

                            CAD-PT-COMPANY       -> GLN-COMPANY
                            CAD-PT-ACCT-UNIT     -> GLN-ACCT-UNIT

Post To Comp   GLSYSTEM     Not Required

                            CAD-PT-COMPANY       -> GLS-COMPANY

Pst To Company GLSYSTEM     Not Required

                            CAD-PT-COMPANY       -> GLS-COMPANY

To Chart Dtl   GLCHARTDTL   Not Required

                            GLS-CHART-NAME       -> GDT-CHART-NAME
                            CAD-PT-ACCOUNT       -> GDT-ACCOUNT
                            CAD-PT-SUB-ACCT      -> GDT-SUB-ACCOUNT

                         CADETAIL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acct Grp Det   RWGRPDET

                            "A"                  -> RGD-RECORD-TYPE
                            CAD-ACCOUNT-GROUP    -> RGD-HEAD-NAME
                                                    RGD-RANGE-NUMBER

All Cod Det    ACDETAIL

                            CAD-PT-ALLOC-CODE    -> ALD-ALLOC-CODE
                                                    ALD-COMPANY
                                                    ALD-ACCT-UNIT

Lvl Grp Det    RWGRPDET

                            "L"                  -> RGD-RECORD-TYPE
                            CAD-LEVEL-GROUP      -> RGD-HEAD-NAME
                                                    RGD-RANGE-NUMBER

Sub Grp Det    RWGRPDET

                            "S"                  -> RGD-RECORD-TYPE
                            CAD-SUB-ACCT-GRP     -> RGD-HEAD-NAME
                                                    RGD-RANGE-NUMBER