Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                            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    AR501     AR550     BL214

UPDATED BY

BL14.1

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

OCD-COMPANY          Numeric 4                                   BL14.1
Company              The company number represents an
                     established company and is entered on
                     all function codes.

OCD-CUSTOMER-CODE    Alpha 4                                     BL14.1
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
Description          This field contains the description of
                     the customer code.

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

OCD-USED-FLAG        Alpha 1                                     BL14.1
Used                 Indicates whether the customer code has
                     been used.
                     N = No
                     Y = Yes

                         OECUSTCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OCDSET1   COMPANY                                                AR08.1  AR501
          CUSTOMER-CODE                                          AR550   BL14.1
                                                                 BL214

                         OECUSTCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OCD-COMPANY    -> OEC-COMPANY