LINETOTAL data type CustID Cust Type City 697 S Tooele PostalCode SalesOrderNum ProductID 84074 SO50270 863 Order Qty LineTotal ProductName ProductLine ProductListPrice 44 639.3717 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 869 41 1097.6182 Women's Mountain Shorts, L A 69.99 697 S Tooele 84074 SO51783 867 40 1259.82 Women's Mountain Shorts, S A 69.99 546 L Loveland 80537 SO57186 869 40 1259.82 Women's Mountain Shorts, L A 69.99 546 L Loveland 80537 SO48089 863 39 666.7245 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 867 38 1196.829 Women's Mountain Shorts, S A 69.99 697 302 125 315 SSSS Tooele 84074 SO51783 869 36 1133.838 Women's Mountain Shorts, L A 69.99 Offenbach 63009 SO51109 864 36 1028.7 Classic Vest, S S 63.5 Stamford 06901 SO46610 863 35 598.3425 S Merritt Island 32952 SO46673 863 35 598.3425 Full-Finger Gloves, L Full-Finger Gloves, L M 37.99 M 37.99 LineTotal is always present and is not stored as a currency. Data in column is representative of how many decimal places are stored. Highest allowed value is nine thousand i.e. 9000 Which ONE of the following is the most appropriate data type to use for LineTotal? O smallmoney O decimal(9) O decimal(8,4) O decimal(12,4) O decimal(4,4)

Understanding Business
12th Edition
ISBN:9781259929434
Author:William Nickels
Publisher:William Nickels
Chapter1: Taking Risks And Making Profits Within The Dynamic Business Environment
Section: Chapter Questions
Problem 1CE
icon
Related questions
Question
LINETOTAL data type
CustID
Cust Type
City
697
S
Tooele
PostalCode SalesOrderNum ProductID
84074
SO50270
863
Order Qty
LineTotal
ProductName
ProductLine ProductListPrice
44
639.3717
Full-Finger Gloves, L
M
37.99
146
L
Seattle
98104
SO67266
869
41
1097.6182
Women's Mountain Shorts, L
A
69.99
697
S
Tooele
84074
SO51783
867
40
1259.82
Women's Mountain Shorts, S
A
69.99
546
L
Loveland
80537
SO57186
869
40
1259.82
Women's Mountain Shorts, L
A
69.99
546
L
Loveland
80537
SO48089
863
39
666.7245
Full-Finger Gloves, L
M
37.99
146
L
Seattle
98104
SO67266
867
38
1196.829
Women's Mountain Shorts, S
A
69.99
697
302
125
315
SSSS
Tooele
84074
SO51783
869
36
1133.838
Women's Mountain Shorts, L
A
69.99
Offenbach
63009
SO51109
864
36
1028.7
Classic Vest, S
S
63.5
Stamford
06901
SO46610
863
35
598.3425
S
Merritt Island
32952
SO46673
863
35
598.3425
Full-Finger Gloves, L
Full-Finger Gloves, L
M
37.99
M
37.99
LineTotal is always present and is not stored as a currency.
Data in column is representative of how many decimal places are stored. Highest allowed value is nine thousand i.e. 9000
Which ONE of the following is the most appropriate data type to use for LineTotal?
O smallmoney
O decimal(9)
O decimal(8,4)
O decimal(12,4)
O decimal(4,4)
Transcribed Image Text:LINETOTAL data type CustID Cust Type City 697 S Tooele PostalCode SalesOrderNum ProductID 84074 SO50270 863 Order Qty LineTotal ProductName ProductLine ProductListPrice 44 639.3717 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 869 41 1097.6182 Women's Mountain Shorts, L A 69.99 697 S Tooele 84074 SO51783 867 40 1259.82 Women's Mountain Shorts, S A 69.99 546 L Loveland 80537 SO57186 869 40 1259.82 Women's Mountain Shorts, L A 69.99 546 L Loveland 80537 SO48089 863 39 666.7245 Full-Finger Gloves, L M 37.99 146 L Seattle 98104 SO67266 867 38 1196.829 Women's Mountain Shorts, S A 69.99 697 302 125 315 SSSS Tooele 84074 SO51783 869 36 1133.838 Women's Mountain Shorts, L A 69.99 Offenbach 63009 SO51109 864 36 1028.7 Classic Vest, S S 63.5 Stamford 06901 SO46610 863 35 598.3425 S Merritt Island 32952 SO46673 863 35 598.3425 Full-Finger Gloves, L Full-Finger Gloves, L M 37.99 M 37.99 LineTotal is always present and is not stored as a currency. Data in column is representative of how many decimal places are stored. Highest allowed value is nine thousand i.e. 9000 Which ONE of the following is the most appropriate data type to use for LineTotal? O smallmoney O decimal(9) O decimal(8,4) O decimal(12,4) O decimal(4,4)
AI-Generated Solution
AI-generated content may present inaccurate or offensive content that does not represent bartleby’s views.
steps

Unlock instant AI solutions

Tap the button
to generate a solution

Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Understanding Business
Understanding Business
Management
ISBN:
9781259929434
Author:
William Nickels
Publisher:
McGraw-Hill Education
Management (14th Edition)
Management (14th Edition)
Management
ISBN:
9780134527604
Author:
Stephen P. Robbins, Mary A. Coulter
Publisher:
PEARSON
Spreadsheet Modeling & Decision Analysis: A Pract…
Spreadsheet Modeling & Decision Analysis: A Pract…
Management
ISBN:
9781305947412
Author:
Cliff Ragsdale
Publisher:
Cengage Learning
Management Information Systems: Managing The Digi…
Management Information Systems: Managing The Digi…
Management
ISBN:
9780135191798
Author:
Kenneth C. Laudon, Jane P. Laudon
Publisher:
PEARSON
Business Essentials (12th Edition) (What's New in…
Business Essentials (12th Edition) (What's New in…
Management
ISBN:
9780134728391
Author:
Ronald J. Ebert, Ricky W. Griffin
Publisher:
PEARSON
Fundamentals of Management (10th Edition)
Fundamentals of Management (10th Edition)
Management
ISBN:
9780134237473
Author:
Stephen P. Robbins, Mary A. Coulter, David A. De Cenzo
Publisher:
PEARSON