OECUSTCODE – Order Entry Customer Codes

System
Billing (BL)
Prefix
OCD
Primary key
COMPANY, CUSTOMER-CODE
Fields
5
Updated by
1 program
Referenced by
4 programs

OECUSTCODE is the Order Entry Customer Codes table in Lawson Billing (prefix OCD). It is indexed by COMPANY, CUSTOMER-CODE (OCDSET1). It is related 1:1 to OECOMPANY. It is updated by WH20.7 and referenced by AR08.1, AR10.1, AR501 and AR550. The table has 5 fields, 1 index and 1 documented relation.

About OECUSTCODE

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.

Fields (5)

Column = COBOL field name without the OCD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
OCD-COMPANY PK
COMPANY		Numeric 4Identifies 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 PK
CUSTOMER_CODE		Alpha 4This field contains the code that represents a customer. Codes can be used to group customers together for sales analysis.—
OCD-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field contains the description of the customer code.—
OCD-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1This field indicates whether the customer code is active.
  • A Active
  • I Inactive
—
OCD-USED-FLAG
USED_FLAG		Alpha 1Indicates whether the customer code has been used.
  • N No
  • Y Yes
WH20.7

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
OCDSET1COMPANY, CUSTOMER-CODEPrimaryAR08.1, AR10.1, AR501, AR550, WH20.7

Relations

One to one (1) — lookups and parents

RelationTableRulesConditionField map
OecompanyOECOMPANYRequiredOCD-COMPANY → OEC-COMPANY

Programs

Updated by (1)

Referenced by (4)