SO payment star schema grouping
The SO Payment star schema grouping consists of the SO Payment measures and the following dimensions.
Dimensions
- Enterprise
- Calendar(Charge Date)
- Buyer
- Seller
- Channel
- Payment type
- Document type
Measures
The following table provides a list of the SO Payment measures:
- Measure
- Description
- Authorization Count
This measure indicates whether the transaction has been authorized.
- Authorization Failure Count
This measure indicates whether the authorization of transaction has failed.
- Credit Amount
This is the amount that is actually charged or refunded to the buyer.
- Authorized Amount
This is the amount that is authorized for an order.
- Settlement Count
This measure indicates whether the transaction settlement has been completed or not.
- Settlement Failure Count
This measure indicates whether the settlement of transaction has failed.
- Request Amount
This is the amount that has been requested for settlement or authorization.
- Settled Amount
This measure is the amount for which a settlement has been requested.
Grouped measures
The following table provides a list of the SO Payment grouped measures:
- Measure
- Description
- Percentage Authorization Failures
This is the percentage of payment instruments that failed during the authorization of payment.
- Percentage Settlement Failures
This is the percentage of settlements that failed during the settlement cycle.