Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

OECUSTCODE


                            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

UPDATED BY

WH20.7

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

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

OCD-USED-FLAG          Alpha 1                                   WH20.7
Element: 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  AR10.1
          CUSTOMER-CODE                                          AR501   AR550
                                                                 WH20.7

                         OECUSTCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OCD-COMPANY    -> OEC-COMPANY