Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            ACADDASSGN FILE

                      Activity Address Assignment

This file contains address assignment information from AC10.2 (Location
Assignment). It includes address codes, their descriptions, and the activities
they are assigned to. The addresses or locations that  address codes refer to
can be defined in AC10.4 (Location).

UPDATED BY

AC10.2    AC10.1    AC300     AC310     AC500

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

AAS-ACTIVITY         Alpha 15                                    AC10.2  AC500
Activity             Required key. This is the activity for
                     the address.

AAS-ADDRESS-CODE     Alpha 9                                     AC10.2  AC500
Address Code         Required key. This is the address code
                     used to assign a location to an
                     activity. Address codes are defined in
                     AC10.4 (Location).

AAS-DESCRIPTION      Alpha 30  (Lower Case)                      AC10.2  AC500
Address Code         This is the address code description.
Description

                         ACADDASSGN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

AASSET1   ACTIVITY                                               AC10.1  AC10.2
          ADDRESS-CODE                                           AC300   AC310
                                                                 AC500

                         ACADDASSGN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Acactivity     ACACTIVITY   Not Required

                            AAS-ACTIVITY        -> ACV-ACTIVITY

Acaddress      ACADDRESS    Required

                            AAS-ADDRESS-CODE    -> ADD-ADDRESS-CODE