Previous Topic: Reference Field

Next Topic: Specifying Field Types

Field Types for Referenced Objects

The field type specifies all of the default characteristics for a field.

CA 2E uses field types to make default assumptions about properties of a field. It also uses field types to validate entries.

To describe fields, select one of the field types from the following table.

The following table contains CA 2E field types.

Field Type Name

Description

Type

Length

Example

CDE

DT#

DTE

IGC

NAR

NBR

PCT

PRC

QTY

REF

SGT

STS

TM#

TME

TS#

TXT

VAL

VNM

Code

ISO 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

A

A

P

P

P

P

-

P

A

A

P

A

A

P

A

6

10

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

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