Understanding Your Data Model › Using Fields › Displaying Existing Field Types

Previous Topic: Shipped CA 2E Field Types

Next Topic: Field Type Default Characteristics

Displaying Existing Field Types

To display the field types:

  1. Zoom into the *Field Attribute Types file by placing a Z against one of the file's relations on the Edit Database Relations panel. The Display Field Types panel lists the field types.
  2. Zoom into a specific field type by placing Z against the field type to view the default values
  3. Press F9 from the Display Field Types panel to add your own user-defined field types.

See the chapter "Maintaining Your Data Model" for more information on defining and adding your own field types.

The following table details the field types shipped with CA 2E.

Field Type Name

Description

Type

Internal
Length

Example

CDE

DT#

D8

DTE

IGC

NAR

NBR

PCT

PRC

QTY

REF

SGT

STS

TM#

TME

TS#

TXT

VAL

VNM

Code

ISO Date

8-digit Date

Date

Ideographic text

Narrative text

Number

Percentage

Price or tariff

Quantity

Reference

Surrogate

Status

ISO Time

Time

ISO Timestamp

Descriptive name

Monetary value

Valid system name

A

A

P

P

A

A

P

P

P

P

–

P

A

A

P

A

A

P

A

6

10

8.0

7.0

20

30

5.0

5.2

7.2

5.0

–

7.0

1

10

6.0

26

25

11.2

10

Stock code

Order date

Order date

Date of birth

Kanji name

Comments

Number of employees

Profit margin

Unit price

Stock quantity

Field based on another

System key

Discontinued/Current

Time process starts

Transaction time

Transaction date/time

Product name

Stock value

File name

The following sections describe how to use the field types listed in this table.