1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
andrew11 [14]
3 years ago
13

Assuming that all the table and column names are spelled correctly, what's wrong with the INSERT statement that follows?

Business
1 answer:
Nezavi [6.7K]3 years ago
3 0

Answer:

(VendorID = 97

InvoiceNumber = 456789

InvoiceTotal = <u>8344.50</u>

PaymentTotal = <u>0</u>

CreditTotal = <u>0</u>

TermsID = 1

InvoiceDate = 2006-08-01

InvoiceDueDate = ?

You cannot have PaymentTotal = 0. The sales value was $8,344.50, and since the sales was paid with cash (no invoice due date), the payment should record the same amount as the invoice.

InvoiceTotal = PaymentTotal + CreditTotal, since you were paid with cash or you gave credit to the client.

You might be interested in
What is the most important component of excellence in customer service?
dmitriy555 [2]
Osmsmskspsps,s,lapses
5 0
3 years ago
EASY!! Please help!! 25 points
aniked [119]

Answer:

Corporation

Explanation:

3 0
3 years ago
Other things the same, when the government spends more, the initial effect is that a. aggregate demand shifts right. b. aggregat
tatyana61 [14]

Answer: Option (a) is correct.

Explanation:

Correct option: Aggregate demand shifts right.

Aggregate demand = consumption + government spending + Investment + Net Exports

Other things remains constant, if there is an increase in the government spending, as a result aggregate demand curve shifts rightwards. This will lead to increase the price level and level of output.

4 0
3 years ago
A company determined that the budgeted cost of producing a product is $30 per unit. On June 1, there were 72000 units on hand, t
Lyrx [107]

Answer:

"The budgeted cost of goods sold" for June would be $5,640,000

Explanation:

Sales department budget for June = 220,000  units

Less-Opening balance as on 1st June = 72,000  units

Add-Closing balance as on 30th June = 40,000  units

No of unit manufactured = Sales department budget for June  - Opening balance as on 1st June + Closing balance as on 30th June

= 220,000 - 72,000 + 40,000

= 188,000  units

Cost per unit = $30

Budgeted cost of manufactured = 188,000 × $30 = $5,640,000

4 0
3 years ago
Financial statement data for years ending December 31, 2019 and 2018, for Edison Company follow: 2019 2018 Sales $513,500 $480,0
madam [21]

Answer:

The answer is

For 2018 - 1.5

For 2019 - 1.3

Explanation:

Asset turnover ratio=Net sales/average total assets

For 2018:

Sales - $480,000

Beginning asset - 360,000

Ending asset -360,000

Average total asset:

($280,000 + $360,000)/2

=$320,000

Therefore, asset turnover for 2018 is:

$480,000/$320,000

=1.5

For 2019:

Sales - $513,500

Beginning asset - $360,000

Ending asset - $430,000

Average total asset:

($360,000 + $430,000)/2

=$395,000

Therefore, asset turnover for 2019 is:

$513,500/$395,000

=1.3

5 0
3 years ago
Other questions:
  • Workers are responsible for the production of goods in a business,
    9·1 answer
  • A farmer who has fixed amounts of land and capital finds that total product is 24 for the first worker hired; 32 when two worker
    9·1 answer
  • A for-profit institution that works with large companies and corporations to manage deposits, loans, and investments is known as
    12·2 answers
  • Please give a unique example of what you could realistically make a database for. Give examples of at least 5 lists that would b
    6·1 answer
  • A person driving a car has the duty to exercise what standard of care?
    13·1 answer
  • You submit an offer to the seller. They agree with price, inclusions, everything except the closing date. The proper way to hand
    6·1 answer
  • Sam and Richard work at the local glue factory. Recently, Sam, who is a more experienced worker, has begun to establish a protég
    13·1 answer
  • State two ways by which hotels may promote sales during the off season​
    11·1 answer
  • At the end of its first month of operations, a company reported Revenue of $37,000. It also reported Wages Expense, $6,000; Rent
    8·1 answer
  • A(n) ________ is an organizational change that involves rethinking the nature of the business and the nature of the organization
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!