Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACDETAIL


                             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