Which two data types should you use?

You need to define the data types for the fields of the N on-conformity table.

Which two data types should you use? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.

A. Integer for the N on-conformity Number field

B. Date Time for the Non-Conformity Date field

C. Char for the Non-Conformity Number field

D. Date for the Non-Conformity Date field

E. Code for the Non-Conformity Number field

View Answer

Answer: DE

Explanation:

In Business Central, fields in tables are assigned specific data types that determine the kind of data they can store. For the Non-conformity table mentioned in the case study, the following data types should be used:

Date for the Non-Conformity Date field: This is because the Non-conformity Date field is required to store only the date when the non-conformity was recorded. The Date data type is appropriate for storing dates without times.

Code for the Non-Conformity Number field: The Non-conformity Number field is described to use alphanumeric values with a format that includes "NC" and the year, like "NC24-001". In Business Central, the Code data type is used for fields that store alphanumeric keys. It is a text field with a limited length, which makes it suitable for number series that contain letters and numbers.

Other options are not suitable:

A. Integer for the Non-conformity Number field: This would not be appropriate because the Non-conformity Number includes alphanumeric characters and not just integers.

B. Date Time for the Non-Conformity Date field: This is not correct because there is no requirement to store the time alongside the date.

C. Char for the Non-Conformity Number field: Char data type is not typically used in Business Central for number series or identifiers. The Code data type is preferred for this purpose.