All categories

3 years ago

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

By the second decade of the 21st century, most organizations were devoting less and less time and attention to corporate ethics.

yKpoI14uk [10]

It is true that by the second decade of the 21st century, most organizations were devoting less and less time and attention to corporate ethics.

<h3> Corporate Ethics</h3>

Business ethics (also known as Corporate Ethics) is a state of applied ethics or experienced ethics, that explores ethical principles and moral or ethical concerns that can arise in a enterprise environment. It spreads to all aspects of business conduct and is applicable to the conduct of individuals and entire associations.

<h3>What are the type business ethics?</h3>

(i) Politics without Principles

(ii) Wealth without Work

(iii) Commerce without Morality

(iv) Knowledge without Character

(v) Pleasure without Conscience

(vi) Science without Humanity

(vii) Worship without Sacrifice.

To learn more about business ethics visit the link

brainly.com/question/27824491

#SPJ4

7 0

1 year ago

If your company's product is large home appliances such as washing machines, ranges, ovens, and refrigerators, would it seem to

ankoles [38]

No one customer likes the same thing, they all have dissimilar taste because of this A company that yields dry soup mixes and canned soups would be helped if it used the multi domestic strategy. By means of this strategy would let them to fit its soups to each country it chooses to do business with. The soups would be tailored to the local domestic territory, captivating into account the different fondness and local customs. Selecting to do this allows the customer to better obtain the company’s product in its place of seeing it as something manufactured by a foreign company.

5 0

3 years ago

Read 2 more answers

The issuer of a 5% common stock dividend to common stockholders should transfer from retained earnings to paid-in capital an amo

NISA [10]

Answer: A

Fair value of the shares issued.

5 0

3 years ago

Diaz Company issued $180,000 face value of bonds on January 1, 2018. The bonds had a 7 percent stated rate of interest and a fiv

Akimi4 [234]

Answer:

<u>Issuance:</u>

Balance sheet:

Assets and liabilities increase y 198,000

Net Income: no effect

Cash flow: financing activities: 198,000

<u>1st payment</u>

The interest expense will be the sum of both, the cash proceeds and the discount amortization.

13,860 + 792 = 14,652 interest expense

Balance sheet:

Assets decrease by 13,860 (cash)

Liabilities increase by 792 (as the carrying value of the bon increase)

Net Income: 14,652 interest expense

Cash flow: financing activities: (13,860)

<u>Carrying value </u>

194,040 + 792 = 194,832

<u>Interest expense 2019:</u>

same as before as we use striagh line method:

cash proceeds + amortization

13,860 + 792 = 14,652 interest expense

Explanation:

face value 198,000

proceeds 194,040

discount on bonds payable 3,960

amortization:

3,960 / 5 = 792

cash proceeds: 198,000 x 0.07 = 13,860

4 0

4 years ago

Gwen deposits $5,000 with Home Bank on July 1, 2018. Home Bank promises to repay Gwen the $5,000 plus 1 percent annual interest

Allisa [31]

Answer:

certificate of deposit

Explanation:

A certificate of deposit (CD) is a financial instrument sold by banks

The bank gives this CD to Gwen. She cannot withdraw the cash until July 1, 2023

The certificate of deposit are risk-free investment. The difference with savings account is that a certificate of deposit has a fixed term and fixed interest rate and it is create with the idea of holding the title until maturity. Not doing so, may inccur in penalties so a portion of the interest will be negate.

As this is a financial instrument, the bank issued a title to the investor to recognize his investment.

7 0

4 years ago

Read 2 more answers