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 SAA2.1
UPDATED BY
BL120 BL130 BL14.1 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
BL940 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 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE810 OE830 OE920
OE950 WH20.7
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 SA03.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 BL120 BL130
Used Indicates whether the customer code has BL14.1 BL20.1
been used. BL20.3 BL21.2
N = No BL21.5 BL29.1
Y = Yes BL29.2 BL520
BL820 BL92.1
BL940 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
OE113 OE114
OE129 OE14.4
OE15.1 OE15.2
OE15.3 OE15.4
OE15.5 OE15.7
OE30.1 OE30.2
OE30.3 OE30.4
OE30.5 OE30.6
OE30.7 OE30.9
OE510 OE810
OE830 OE920
OE950 WH20.7
OECUSTCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OCDSET1 COMPANY AR08.1 AR10.1
CUSTOMER-CODE AR501 AR550
BL120 BL130
BL14.1 BL20.1
BL20.3 BL21.2
BL21.5 BL214
BL29.1 BL29.2
BL520 BL820
BL92.1 BL940
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
|