• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 311
  • Last Modified:

right word usage in math/finance

could you suggest what is the right words to use in terms of grammar and also proper current usage in government/bank etc
0
25112
Asked:
25112
  • 2
  • 2
2 Solutions
 
25112Author Commented:
this will be used as field names in databases.

short and right word to describe what was the debt at the end of last quarter  and also start of this quarter ?

QuarterDebtEnd or EndingQuarterDebt or ClosingQuarterDebt
StartingQuarterDebt, QuarterDebtBegin or beginningQuarterDebt
QuarterInterestPaid, QuarterInterestRatePaid, Quarter%Paid
or anything else
0
 
David L. HansenProgrammer AnalystCommented:
See "Accounts Payable" here
http://en.wikipedia.org/wiki/Accounts_payable

see also "Accounts Receivable"
http://en.wikipedia.org/wiki/Accounts_receivable
0
 
TommySzalapskiCommented:
If the 'debt' is unpaid invoices or something similar then I agree with sl8rz and would use AccountsPayable.
If it's remaining debt on a loan (which I'm guessing it is because of the interest fields), then I would just use LoanBalance. Closing and Opening are better words than Ending and Starting if you really want to include that. But it doesn't really matter that you are at the end of a quarter. Whether you are at the end of a week, a quarter, or a year, the number is the same so I don't see the need to include the expected timeframe in the name.
0
 
David L. HansenProgrammer AnalystCommented:
The fact that you want to include the time frame concerns me.  Good database structure is independent of time (until you query it, then you impose a time frame).  You should have a general ledger that keeps track of your expenses and incomes.  The entries have date stamps, but the table itself should not denote any kind of time frame.  Just think of it as a long list of receipts.  I can point you to some ERDs (Entity Relationship Diagrams) that show you more detailed descriptions of complex accounting systems, but for now the general ledger concept is important to grasp.
0
 
25112Author Commented:
we have started discussing that.. thanks for the valuable input
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now