About 40% of the data types we talked about previously can be used to define the data that's stored either in tables or in working storage data definitions (that is, in a global or local data definition within an object). Two data types, BLOB and TableFilter, can only be used to define table stored data, not working storage data. About 60% of these data types can only be used for working storage data definitions.
The following list shows which data types can be used for table (persisted) data fields and which ones can be used for working storage (variable) data:
Table data types |
Working storage data types |
Action |
|
BigInteger |
|
BLOB |
|
Boolean |
|
Code |
|
Date |
Date |
DateFormula |
DateFormula |
DateTime |
DateTime |
Decimal |
|
Duration |
Duration |
Enum |
|
GUID |
|