Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACDETAIL


                             ACDETAIL FILE

                         Cost Allocation Detail

This file contains the allocation code detail information.

REFERENCED BY

CA110     CA205

UPDATED BY

CA05.1    CA05.2    CA160

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ALD-ALLOC-CODE         Alpha 12                                  CA05.1  CA160
Element: Allocation CodThe allocation code name as defined in
                       CA05.1 (Allocation Code).


ALD-COMPANY            Numeric 4                                 CA05.1  CA160
Element: Company       The General Ledger company number for
                       which the allocation code is defined.

ALD-ACCT-UNIT          Alpha 15                                  CA05.1  CA160
Posting Accounting     The Post To accounting unit.
Unit

ALD-VALUE              Numeric 13                                CA05.1  CA160
Element: Value         The value determines the percentage
                       allocated to the company and accounting
                       unit.  The percentage is calculated by
                       dividing the line value by the total
                       value.

ALD-VALUE-PERCENT      Derived
Element: Value Percent The percentage of the allocated 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   CA160
          ACCT-UNIT                                              CA205

                         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