Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             ACDETAIL FILE

                     This file contains the allocat

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
Key field. This is   The allocation code name as defined in
the allocat          CA05.1 (Allocation Code).


ALD-COMPANY          Numeric 4                                   CA05.1
Key field. This is   The company number you are defining an
the company          allocation code for.


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


ALD-VALUE            Numeric 13                                  CA05.1
The value in this    The amount allocated to the company and
field determ         accounting unit.


ALD-VALUE-PERCENT    Derived
e total to           The percentage of the amount that is
determine the alloc  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