Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACADDASSGN


                            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     PW110
PW510

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

AAS-ADDRESS-CODE       Alpha 9                                   AC10.2  AC500
Element: Address Code  Required key. This is the address code    PW110   PW510
                       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.     PW110   PW510
Description

                         ACADDASSGN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

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

                         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