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)
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 and correct. The fewer mistakes that the company makes in processing orders, the happier the customers will be with their shopping experience.
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 organized which will obviously be good for you and also to your customer so that there will be no confusion that may take place.