OECUSTCODE

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
Element: Company
Numeric 4
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
Element: Customer Code
Alpha 4
This field contains the code that represents a customer. Codes can be used to group customers together for sales analysis.
OCD-DESCRIPTION
Element: Description
Alpha 30 (Lower Case)
This field contains the description of the customer code.
OCD-ACTIVE-FLAG
Element: Active Flag
Alpha 1
This field indicates whether the customer code is active.
A = Active
I = Inactive
OCD-USED-FLAG
Element: Used Flag
Alpha 1
Indicates whether the customer code has been used.
N = No
Y = Yes
WH20.7


OECUSTCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
OCDSET1 COMPANY
CUSTOMER-CODE
AR08.1 AR10.1
AR501 AR550
WH20.7


OECUSTCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Oecompany OECOMPANY Required
OCD-COMPANY->OEC-COMPANY


File created: Thu Jun 09 02:09:32 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.