Which data type should they use for the Order ID field? Northern - ProProfs Discuss
Topics
Products
Follow Us:

Which data type should they use for the Order ID field?
Northern Trail Outfitters (NTO) 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 zeroes, but NTO does not want to include them in the final values.  



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

This question is part of PUB - Set 2
Asked by Cmall, Last updated: Jan 23, 2020

+ Answer
Request

3 Answers

J. Harty

Have keen interest in writing, traveller by heart.

J. Harty, Writer, M.A, Chula Vista

Answered May 30, 2019

A is the answer to this question. 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 an...Read More
 

W. Pratt

Want to learn new things and share my knowledge

W. Pratt, Marketing Analyst, MBA, Lincoln

Answered Apr 19, 2019

The answer to this is A. Are you familiar with what an order ID field is? This is a field wherein you can put multiple sales in one single order. This can be effective when you have a customer who is purchasing different items from your store. Instead of making all of the items separate, you can just place all of the items that are being purchased under one field. This will make it easier to do the computation and to complete the order. All of the orders will also be clear and organi...Read More
 

cmall

Cmall

Answered Jul 18, 2018

Decimal (15,0)

####
 

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.