Spend Savings Estimation table
The Spend Savings Estimation [sn_slm_opt_spend_savings_estimation] table stores the saving estimates generated by the saving estimator tool.
Spend Savings Estimation [sn_slm_opt_spend_savings_estimation] table
The Spend Savings Estimation [sn_slm_opt_spend_savings_estimation] table contains the following fields.
| Field | Data type | Description |
|---|---|---|
| Supplier | Reference | Name of the supplier. |
| System domain | Domain ID | Identifier for the system domain associated with the supplier. |
| System domain path | String | Path that indicates the hierarchy or structure of the system domain. |
| Annual target spend | Currency | Total amount expected to be spent in an year with the supplier. |
| Payment terms | Integer | Number of days taken to pay the supplier using current method. |
| New payment terms | Integer | Number of days it will take to pay the supplier using the new method (usually card). |
| Acceleration to supplier | Integer | Number of days reduced by paying the supplier using the new method. |
| Grace period | Integer | Number of days after the billing cycle closes before you must pay the card bill. |
| Billing terms | Integer | Internal setting or max deferral window — often used as a cap for payment timing (ex: billing cycle + grace period or a set maximum). |
| Working capital benefits | Currency | Estimated financial benefit gained by extending the time between paying the supplier and paying the card issuer. |
| Billing cycle | Integer | Number of days in the card billing cycle (from transaction date to statement date). |
| Cost of funds | Decimal | Organization’s internal cost (in percentage) for borrowing the funds needed to purchase goods or services from the supplier. |
| Total check transactions | Integer | Total number of transactions currently processed through checks. |
| Cost per check payment | Currency | Average processing cost per check payment (default value: 20). |
| Process savings benefits | Currency | Total process cost savings from switching from traditional check payments to virtual card payments. |
| Regular rebate | Decimal | Fixed rebate percentage offered by the card provider. |
| Iti rate | Decimal | Interchange Transfer Incentive rate: Additional rebate or incentive offered based on volume or card type. |
| Volume based rebates | Decimal | Total rebates earned based on the payments made through the virtual card. |
| Total savings | Currency | Total savings earned from process savings, working capital, and earned rebates. |
For more information, see Supplier Payment Optimization data model.