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
Seller Dayne was made aware by the trustee that the lender was wanting to proceed with foreclosure on his property. What type of
elena55 [62]

Answer:

Promissory agreement and Deed of trust.

Explanation:

In this scenario, Seller Dayne was made aware by the trustee that the lender was wanting to proceed with foreclosure on his property. The type of financial agreement that Seller Dayne have with this lender is a Promissory agreement and Deed of trust.

A promissory agreement can be defined as an evidence of a debt and as such involves the use of a legal financial tool such as a promissory note as a written promise to declare that a party (borrower) would pay another (lender) at a specific period of time.

On the other hand, a deed of trust can be defined as a legal document used by a party (borrower) to pledge his or her property to another party (lender) as guarantee or collateral for the repayment of a loan. The deed of trust is typically made up of three (3) parties; the lender, borrower and a trustee.

Additionally, a foreclosure on a property refers to a legal procedure whereby the property being pledged by a borrower for a debt is sold to pay off the debt as a result of defaulting in payments or terms with respect to a loan.

6 0
3 years ago
Armando, a manager for Petros Pizza Pies (PPP), dies in an accident on July 12. PPP pays his wife, Penelope, $600 in salary that
stepan [7]

Answer:

Explanation:

Ms. P receives $6,000 from Company P due to her husband A's loyal service and She receives $600 that her husband earned prior to his death. Hence, Ms P earns a total of $6,600 ($6000 + $600) gross income.

The amount of $90,000 receive from the life insurance proceeds are excluded from the gross income.

Ms P's daughter receives $4,000 from company P. It should be included in her daughter income.

8 0
3 years ago
Due to ____, market forces should realign the cross exchange rate between two foreign currencies based on the spot exchange rate
aksik [14]

Answer:

Triangular Arbitrage

Explanation:

Arbitrage is the financial practice in which the prices of two or more different markets are taken advantage of to make profit as a result of tthe imbalance in the prices of the markets.

Also known as 3 point or cross currency arbitrage, Triangular arbitrage is the taking advantage/ exploiting of the pricing differences between 3 currencies on the foreign exchange market.

Simply put, triangular arbitrage is a situation in which the exchange rates between 3 currencies are not the same.

Triangular arbitrage is difficult to come by as it requires very advanced computer systems to detect and take advantage of.

I hope this helps.

6 0
3 years ago
The CFO of company ABC wants to give every employee a 3% raise, but would like a report to confirm if this is possible. Write an
katrin [286]

Answer:

For such a report , the sql query required would be:

SELECT emp_id, curr_salary, curr_salary*1.03 AS inc_salary FROM Employee;

Explanation:

For such a report , the sql query required would be:

SELECT emp_id, curr_salary, curr_salary*1.03 AS inc_salary FROM Employee;

In the above  sql query  employee id is emp_id , curr_salary is the current salary column.  "curr_salary*1.03" is been made because an increment of 3% means salary + salary*3% , that is , salary*1.03.

4 0
3 years ago
The four traits of constructive criticism are _______.
Dmitrij [34]

Answer:

The answer to this question is given below in the explanation section.

Explanation:

Constructive criticism is the process to offer valid and well-reasoned reponed or opinion about other works, it includes both positive and negative comments in a friendly way rather than an oppositional one.

There are four traits of constructive critisim.

So, the correct answer to this question is given below:

D: Positivity, Solution-Oriented, Specific, and private.

While other options are not correct because the four traits of constructive criticism are starting from positivity, solution-oriented, specific, and private.

8 0
2 years ago
Read 2 more answers
Other questions:
  • Mark agrees to buy dale's one-half-ton truck so that he can pull his trailer. both mark and dale believe that the truck is large
    5·2 answers
  • 1)If an interest rate is fixed that means the rate
    13·2 answers
  • When a business asks "What business are we in?" they are: a. conducting an environmental analysis. b. defining their business mi
    15·1 answer
  • Compared to attending a technical school, completing a four-year college degree allows you to enjoy lower educational costs ente
    10·1 answer
  • The independent variable in the hypothesis "the longer a U.S. line worker has been employed at a U.S.-based assembly plant, the
    9·1 answer
  • Based on the following data, what is the current ratio? Accounts payable………………………….. $ 64,000 Accounts receivable….………………….. 114
    5·1 answer
  • You work for an advertising agency. You have been assigned to come up with an advertising campaign for a new brand of designer w
    6·1 answer
  • What effect might the government have on​ oligopolies? In​ oligopolies, the government might A. promote competition with a paten
    6·1 answer
  • To force the value of the British pound to depreciate against the dollar, the Federal Reserve should: Group of answer choices se
    14·1 answer
  • What can disqualify you from unemployment benefits.
    6·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!