问题描述
我正在设计一个数据库以维持与拨款相关的预算和费用。
tblGrants 和 tblGrantBudget 包括授权标题，拨款收入等数据金额等
每笔赠款都有美联储的授权金额。每次我们提交费用报告时，我们都会获得报销 - 这称为Echo draw。我们需要跟踪这些抽奖。所以基本上如果拨款总额为100美元，我们提交20美元的费用，剩余的余额将为80美元。
为了记录这些抽奖我有3个单独的表（ tblAP ， tblPayroll 和 tblAllocation ）。这些给了我关于每个类别等的每个Echo Draw的报告。
这是相当简单的方式。发生的事情是，在我接手这个数据库之前会产生费用。现在我的问题是：
1.要跟踪这些抽奖，我是否需要一个单独的表，如tblEchoDraw或tblGrantExpense（我们称之为无关紧要）？
2.如何绑定 tblEcho ， tblAP ， tblPayroll ， tblAllocation （这些是费用） tblGrantBudget ？使用一个名为tblEchoDraw的新表并显示余额？
3.由于上一年有开支，我会在某处硬编码这些金额并增加开支费用。如果是，我在哪里硬编码这些数据？
有人可以帮我一些指示吗？非常感谢。
I am designing a db to maintain grant related budget and expenses.
tblGrants and tblGrantBudget include data such as grant title, grant revenue amount etc.
Each grant has an authorized amount from the Fed. Each time we submit an expense report, we get reimbursed - this is called Echo draw. We need to keep track of these draws. So basically if a grant has a total of $100 and we submit $20 expense the remaining balance will be $80.
To record these draws I have 3 separate tables (tblAP, tblPayroll and tblAllocation). These give me reports on each Echo Draw for each category etc.
This is rather simplistic way of putting it. What happened is that there are expenses incurred prior to my taking up on this DB. Now my questions are:
1. To keep track of these draws, do I need a separate table like tblEchoDraw or tblGrantExpense (it does not matter what we call it)?
2. How do I tie tblEcho, tblAP, tblPayroll, tblAllocation (these are expenses) with tblGrantBudget? With a new table called tblEchoDraw and show a balance?
3. Since there are expenses from prior year do I hard code these amounts somewhere and add to on going expenses. If yes, where do I hard code this data?
Can someone please help me with some directions? Many thanks.
这篇关于如何纳入上年度费用并维持当前余额的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！