Lawson Insight Technical Documentation


ERDs Tables Elements Libraries App Forms

                             ACDETAIL FILE

                         Allocation Code Detail

This file contains the allocation code detail information.

REFERENCED BY

CA110     CA205

UPDATED BY

CA05.1    CA05.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

ALD-ALLOC-CODE       Alpha 12                                    CA05.1
Allocation Code      The allocation code name as defined in
                     CA05.1 (Allocation Code).


ALD-COMPANY          Numeric 4                                   CA05.1
Company              The company number you are defining an
                     allocation code for.


ALD-ACCT-UNIT        Alpha 15                                    CA05.1
Accounting Unit      The accounting unit you are allocating
                     to.


ALD-VALUE            Numeric 13                                  CA05.1
Value                The amount allocated to the company and
                     accounting unit.


ALD-VALUE-PERCENT    Derived
Percent              The percentage of the amount that is
                     allocated to the company and accounting
                     unit.


                         ACDETAIL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ALDSET1   ALLOC-CODE                                             CA05.1  CA05.2
          COMPANY                                                CA110   CA205
          ACCT-UNIT

                         ACDETAIL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accountunit    GLNAMES      Required

                            ALD-COMPANY       -> GLN-COMPANY
                            ALD-ACCT-UNIT     -> GLN-ACCT-UNIT

Acct Unit      GLNAMES      Required

                            ALD-COMPANY       -> GLN-COMPANY
                            ALD-ACCT-UNIT     -> GLN-ACCT-UNIT

Acheader       ACHEADER     Required

                            ALD-ALLOC-CODE    -> ALH-ALLOC-CODE

Company        GLSYSTEM     Required

                            ALD-COMPANY       -> GLS-COMPANY

Header         ACHEADER     Required

                            ALD-ALLOC-CODE    -> ALH-ALLOC-CODE