Previous Topic: Description and Usage of Field TypesNext Topic: Eight-digit Date

Understanding Your Data Model › Using Fields › Description and Usage of Field Types › Code (CDE)

Code (CDE)

The following table describes the default characteristics of the CDE Field.

Field Type Attribute

Shipped Default Value

Default Override

Field Details Override

Device Field Override

Implementation name

System data type

External length

Internal length

Decimal places

xxCD

Alpha

6

as external

-

-

Y

N

-

-

Y

N

Y

-

-

N

N

N

-

-

LHS text (Column headings)

RHS text

Field name

Code

N

Y

Y

Y

Y

Y

Keyboard shift

Allow lowercase

Mandatory fill

Valid system name

Mod 10/11 check

XANWIDM

N

N

N

-

N

Y

Y

Y

-

Y

Y

Y

Y

-

N

N

N

N

-

Check condition

Translate values

*NONE

-

N

-

Y

-

Y

-

Field exit option

Edit codes: Input

Output

Report

Required

-

-

-

Y

-

-

-

N

-

-

-

Y

-

-

-

The CDE type is used for fields that represent codes. Fields of CDE type are alphanumeric and are typically keys to a file. The valid set of values for a CDE field is controlled by their existence as the primary key to a database file.

Examples of CDE fields include: