构建佣金报告表格的最佳方法
我想要一个表格来跟踪我们从无线销售中应得的所有佣金。每个计划支付不同的佣金，这不是问题。我们会进行核对，因为有时承运人不付款（他们可能会错过一两行）。
当运营商改变支付佣金的金额时，就会出现问题。我们希望能够返回并看到 1 月份有 4 条线路未按佣金率 x 支付。但 2 月份销售了同类型的计划，但佣金率却是 x-10。
如果我更改计划的佣金表中的费率，当我返回从一月份的报告中提取数据时，我将得到不正确的佣金率。
我有一张带有日期戳的销售表，所以我想我可以以某种方式交叉引用它。
希望有人关注这个。
我正在寻找构建此结构的最佳方法。
I want to have a table that will track all the commissions we are due from our wireless sales. Each plan pays a different Commission, not a problem. We do our reconciliation as sometimes the carriers don't pay (they may miss a line or 2).
The problem occurs when the carriers change how much they pay for the commissions. We want to be able to go back and see that there was 4 lines not paid for in January at commission rate x. but Feb the same types of plans were sold but their commission rates were x-10.
If I change the rate in the commission table for the plan, when i go back to pull the data from the January report I will get incorrect commission rates.
I have a table for sales set up with a date stamp so I was thinking i can cross reference that somehow.
Hope someone followed this.
I am looking for the best way to structure this.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您应该在记录上“盖章”佣金率。您可以将实际费率标记到每条记录中...或者您可以保留佣金 ID 并将其放入每条记录中。
You should "STAMP" the record with the commission rate. You could either stamp the actual rate into every record... or you could keep a commission ID and put that into each record.