서비스 프로바이더 메뉴얼
- 상품 정보 수정에서, Vendor 와 Vendor 의 수익 분배율을 지정한다.
- 플랜 정보 수정에서, 상품에 등록된 Vendor 수익 분배율을 덮어써서 플랜별로 각기 다른 분배율을 적용할 수 있음을 확인한다.
- 플랜 정보 수정의 Usage 정의 항목에서, Usage 별로 각기 다른 분배율을 적용할 수 있음을 확인한다.
-
플랜의 분배율 적용을 마친 후, 구매자 계정으로 하여금 플랜을 구독 하도록 한후, 발급된 인보이스를 확인한다. (10 달러)
-
발급된 인보이스의 항목을 5달러로 가격 조정하여 환불처리한다.
- 플랜에 기록된 Vendor 들에게 수익분배가 적용되었는지 살펴본다.
mysql> SELECT * FROM killbill.product_distribution_history;
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 1663
Current database: killbill
+-----------+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+----------------+---------+--------------------------+------------+--------------+--------------+-----------------+----------+--------------------------------------+--------------------------------------+-------------------+------------------+-------------+---------------------+
| record_id | subscription_id | tenant_id | organization_id | buyer_id | vendor_id | product_id | version | plan_name | usage_name | ratio | amount | original_amount | currency | invoice_id | invoice_item_id | invoice_item_type | transaction_type | format_date | created_date |
+-----------+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+----------------+---------+--------------------------+------------+--------------+--------------+-----------------+----------+--------------------------------------+--------------------------------------+-------------------+------------------+-------------+---------------------+
| 1 | 07bcbd58-3960-42e3-a7ba-19e7a269320e | a31a66e0-ed86-494c-983a-75df5894069d | 6925a6d1-a6b7-4298-944b-b29945bd4872 | 6811d4c2-7736-486d-889c-791205d602c0 | 5664d0ca-c86c-49ed-9b8c-2cb00b3f10a2 | PRD_0000000001 | 2 | PRD_0000000001_PL_000001 | NULL | 3.010000000 | 0.301000000 | 10.000000000 | USD | 69420fe7-39e2-430b-b375-e4b255a5acc6 | 7dd92e8e-4af5-4715-9f35-a7ee56434017 | RECURRING | CREATION | 2017-06-19 | 2017-06-19 00:00:18 |
| 2 | 07bcbd58-3960-42e3-a7ba-19e7a269320e | a31a66e0-ed86-494c-983a-75df5894069d | 6925a6d1-a6b7-4298-944b-b29945bd4872 | 6811d4c2-7736-486d-889c-791205d602c0 | 64daf4bd-447c-4f10-963d-055c8ce2cc96 | PRD_0000000001 | 2 | PRD_0000000001_PL_000001 | NULL | 15.050000000 | 1.505000000 | 10.000000000 | USD | 69420fe7-39e2-430b-b375-e4b255a5acc6 | 7dd92e8e-4af5-4715-9f35-a7ee56434017 | RECURRING | CREATION | 2017-06-19 | 2017-06-19 00:00:18 |
| 3 | 07bcbd58-3960-42e3-a7ba-19e7a269320e | a31a66e0-ed86-494c-983a-75df5894069d | 6925a6d1-a6b7-4298-944b-b29945bd4872 | 6811d4c2-7736-486d-889c-791205d602c0 | organization | PRD_0000000001 | 2 | PRD_0000000001_PL_000001 | NULL | 81.940000000 | 8.194000000 | 10.000000000 | USD | 69420fe7-39e2-430b-b375-e4b255a5acc6 | 7dd92e8e-4af5-4715-9f35-a7ee56434017 | RECURRING | CREATION | 2017-06-19 | 2017-06-19 00:00:18 |
| 4 | 07bcbd58-3960-42e3-a7ba-19e7a269320e | a31a66e0-ed86-494c-983a-75df5894069d | 6925a6d1-a6b7-4298-944b-b29945bd4872 | 6811d4c2-7736-486d-889c-791205d602c0 | 5664d0ca-c86c-49ed-9b8c-2cb00b3f10a2 | PRD_0000000001 | 2 | PRD_0000000001_PL_000001 | NULL | 3.010000000 | -0.150500000 | -5.000000000 | USD | 69420fe7-39e2-430b-b375-e4b255a5acc6 | cf26f5bc-bf54-4776-a89a-2bdc0ecfafc3 | ITEM_ADJ | ADJUSTMENT | 2017-05-18 | 2017-05-18 13:57:43 |
| 5 | 07bcbd58-3960-42e3-a7ba-19e7a269320e | a31a66e0-ed86-494c-983a-75df5894069d | 6925a6d1-a6b7-4298-944b-b29945bd4872 | 6811d4c2-7736-486d-889c-791205d602c0 | 64daf4bd-447c-4f10-963d-055c8ce2cc96 | PRD_0000000001 | 2 | PRD_0000000001_PL_000001 | NULL | 15.050000000 | -0.752500000 | -5.000000000 | USD | 69420fe7-39e2-430b-b375-e4b255a5acc6 | cf26f5bc-bf54-4776-a89a-2bdc0ecfafc3 | ITEM_ADJ | ADJUSTMENT | 2017-05-18 | 2017-05-18 13:57:43 |
| 6 | 07bcbd58-3960-42e3-a7ba-19e7a269320e | a31a66e0-ed86-494c-983a-75df5894069d | 6925a6d1-a6b7-4298-944b-b29945bd4872 | 6811d4c2-7736-486d-889c-791205d602c0 | organization | PRD_0000000001 | 2 | PRD_0000000001_PL_000001 | NULL | 81.940000000 | -4.097000000 | -5.000000000 | USD | 69420fe7-39e2-430b-b375-e4b255a5acc6 | cf26f5bc-bf54-4776-a89a-2bdc0ecfafc3 | ITEM_ADJ | ADJUSTMENT | 2017-05-18 | 2017-05-18 13:57:43 |
+-----------+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+--------------------------------------+----------------+---------+--------------------------+------------+--------------+--------------+-----------------+----------+--------------------------------------+--------------------------------------+-------------------+------------------+-------------+---------------------+
6 rows in set (0.30 sec)
인보이스 발급에 따라 Vendor 에게 수익배분이 일어나고, 인보이스 항목 조정이 일어남에 따라 분배되었던 기록을 도로 차감시킴을 알 수 있다.