Lawson Insight Technical Documentation

                            OECUSTCODE FILE

                       Order Entry Customer Codes

This file contains all the customer codes that are set up in the Lawson Order
Entry system.  A customer code is required for every customer's account.  The
code lets you classify customers for sales analysis purposes.

REFERENCED BY

AR08.1    AR10.1    AR501     AR550     BL214     OE290
SA03.1    SA252     SA80.2    SA90.2    SACU.1

UPDATED BY

BL120     BL122     BL130     BL14.1    BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    OE10.1    OE10.2    OE10.3    OE10.4    OE10.5
OE10.6    OE10.7    OE10.8    OE11.1    OE11.4    OE11.8
OE11.9    OE110     OE111     OE113     OE114     OE129
OE13.2    OE13.3    OE13.5    OE14.4    OE30.1    OE30.2
OE30.3    OE30.4    OE30.5    OE30.6    OE30.7    OE30.9
OE510     OE530     OE810     OE830     WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

OCD-COMPANY            Numeric 4                                 BL14.1
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.

OCD-CUSTOMER-CODE      Alpha 4                                   BL14.1
Element: Customer Code This field contains the code that
                       represents a customer. Codes can be used
                       to group customers together for sales
                       analysis.

OCD-DESCRIPTION        Alpha 30  (Lower Case)                    BL14.1  SA03.1
Element: Description   This field contains the description of
                       the customer code.

OCD-ACTIVE-FLAG        Alpha 1                                   BL14.1
Element: Status        This field indicates whether the
                       customer code is active.
                       A = Active
                       I = Inactive

OCD-USED-FLAG          Alpha 1                                   BL120   BL122
Element: Used          Indicates whether the customer code has   BL130   BL14.1
                       been used.                                BL20.1  BL20.3
                       N = No                                    BL21.2  BL21.5
                       Y = Yes                                   BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  OE10.1
                                                                 OE10.2  OE10.3
                                                                 OE10.4  OE10.5
                                                                 OE10.6  OE10.7
                                                                 OE10.8  OE11.1
                                                                 OE11.4  OE11.8
                                                                 OE11.9  OE110
                                                                 OE111   OE113
                                                                 OE114   OE129
                                                                 OE13.2  OE13.3
                                                                 OE13.5  OE14.4
                                                                 OE30.1  OE30.2
                                                                 OE30.3  OE30.4
                                                                 OE30.5  OE30.6
                                                                 OE30.7  OE30.9
                                                                 OE510   OE530
                                                                 OE810   OE830
                                                                 WH20.7

                         OECUSTCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OCDSET1   COMPANY                                                AR08.1  AR10.1
          CUSTOMER-CODE                                          AR501   AR550
                                                                 BL120   BL122
                                                                 BL130   BL14.1
                                                                 BL20.1  BL20.3
                                                                 BL21.2  BL21.5
                                                                 BL214   BL29.1
                                                                 BL29.2  BL520
                                                                 BL820   BL92.1
                                                                 OE10.1  OE10.2
                                                                 OE10.3  OE10.4
                                                                 OE10.5  OE10.6
                                                                 OE10.7  OE10.8
                                                                 OE11.1  OE11.4
                                                                 OE11.8  OE11.9
                                                                 ...

                         OECUSTCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OCD-COMPANY    -> OEC-COMPANY