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


UPDATED BY

BL120     BL122     BL130     BL14.1    BL20.1    BL20.3
BL21.2    BL21.5    BL29.1    BL29.2    BL520     BL820
BL92.1    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
Element: Description   This field contains the description of
                       the customer code.

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

OCD-USED-FLAG          Alpha 1                                   BL120   BL122
Element: Used Flag     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  WH20.7

                         OECUSTCODE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

OCDSET1   COMPANY                                                AR08.1  AR10.1
          CUSTOMER-CODE                                          AR120   AR501
                                                                 AR550   BL120
                                                                 BL122   BL130
                                                                 BL14.1  BL20.1
                                                                 BL20.3  BL21.2
                                                                 BL21.5  BL214
                                                                 BL29.1  BL29.2
                                                                 BL520   BL820
                                                                 BL92.1  WH20.7

                         OECUSTCODE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Oecompany      OECOMPANY    Required

                            OCD-COMPANY    -> OEC-COMPANY