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 |
| Copyright © 2011 CA. All rights reserved. | Tell Technical Publications how we can improve this information |