Clear all

Which data type should they use for the Order ID field?

1 Posts
1 Users
Noble Member
Joined: 6 months ago
Posts: 336
Topic starter  

Northern Trail Outfitters assigns a 15-digit integer as their Order ID which will be used as the primary key of a data extension. The import file contains leading zeros, but they will NOT be included in the final values.

Which data type should they use for the Order ID field?

  • A . Number
  • B . Text (15)
  • C . Decimal (15,0)
  • D . Decimal (15,2)

Show Answer Hide Answer

Suggested Answer: C


The order ID field is conducive because it places all of the items that the customers want under one order. You can imagine how problematic it would be if the rules would be set in different areas. It will be harder for the company to track the orders of each customer.

This may lead to people receiving items that they did not order or not getting any of the things that they have ordered at all. The order ID field will make everything more organized and correct. The fewer mistakes that the company makes in processing orders, the happier the customers will be with their shopping experience.