If a billing system fact table contains item quantity, amount paid, and amount due, its related dimension tables might include product information, customer information, and time or date information.
Once the claims manager receives a payment, he opens the damage claim, changes the payment status to PAID and enters the date of the payment as shown in Figure 9.
索赔经理收到赔款之后,他打开这个损害索赔,把付款状态改为PAID并输入付款日期,见图9。
3
The maturity of a mortgage is the date when it's paid off.