Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ACCUSTDTL


                             ACCUSTDTL FILE

REFERENCED BY

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

UPDATED BY

BR16.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CMB-COMPANY            Numeric 4                                 BR16.2
Element: Company       Identifies the AP company if the
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

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

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

                         ACCUSTDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CMBSET1   COMPANY                                                AC56.1  AC560
          CUSTOMER                                               BR155   BR16.2
                                                                 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

                            CMB-COMPANY     -> ACO-COMPANY

Arcustomer     ARCUSTOMER   Required

                            CMB-COMPANY     -> ACM-COMPANY
                            CMB-CUSTOMER    -> ACM-CUSTOMER