You plan to create two tables named Table l and Table2. Both tables will have a field named Customer Number of the string type that has a length of 15.
The tables will have a relationship on the Customer Number field.
You need to ensure that the string length of Customer Number is identical for both tables. The solution must ensure that if any relationships on the Customer Number field are added to other tables, the other tables will have the same string length for Customer Number.
What should you use?
A. A view
B. An extended data type (EOT)
C. A perspective
D. A map
Correct Answer: B
Explanation/Reference:
Extended data types (EDTs) are user-defined types, based on the primitive data types boolean, integer, real, string, and date, and the composite type container. You can also base EDTs on other EDTs.
The benefits of EDTs are as follows:
• Code is easier to read because variables have a meaningful data type. For example, Name instead of string.
• The properties you set for an EDT are used by all instances of that type, which reduces work and promotes consistency. For example, account numbers (AccountNum data type) have the same properties throughout the system.
• You can create hierarchies of EDTs, inheriting the properties that are appropriate from the parent and changing the other properties.
Reference: Extended Data Types (EDTs) [AX 2012]
Incorrect:
Not C: A perspective is a collection of tables and views that contain the measures and dimensions for a cube.
Not D: Maps define X++ elements that wrap table objects at run time. With a map, you associate a map field with a field in one or more tables. This enables you to use the same field name to access fields with different names in different tables. Map methods enable you to create or modify methods that act on the map fields.