Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCUSTDTL


                             ACCUSTDTL FILE

                        Activity Customer Detail

REFERENCED BY

BR155     BR51.1    BR52.2    BR52.4    BR52.5

UPDATED BY

BR16.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CMA-COMPANY            Numeric 4                                 BR16.2
Element: Company       The company number represents an
                       established company and is entered on
                       all function codes.

CMA-CUSTOMER           Alpha 9  (Right Justified)                BR16.2
Element: Customer NumbeThis field contains the number that
                       represents a customer.

CMA-MAINT-RENEW-DT     Numeric 8  (yyyymmdd)                     BR16.2
Element: Maint Renew Dt

                         ACCUSTDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CMASET1   COMPANY                                                BR155   BR16.2
          CUSTOMER                                               BR51.1  BR52.2
                                                                 BR52.4  BR52.5

                         ACCUSTDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Arcomp         ARCOMP       Required

                            CMA-COMPANY     -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            CMA-COMPANY     -> ACM-COMPANY
                            CMA-CUSTOMER    -> ACM-CUSTOMER