SO payment summary star schema grouping
The SO Payment Summary aggregate fact table is derived from the SO Payment fact and consists of the following dimensions:
Dimensions
- Enterprise
- Document type
- Calendar (Execution Date)
Measures
The following table provides a list of the SO Payment Summary measures:
- Measure
- Description
- Authorized Amount
Indicates the amount that has been authorized for a payment.
- Credit Amount
Indicates the amount that has been allowed for credit in a payment.
- Settled Amount
Indicates the amount that has been settled for a payment.
- Request Amount
Indicates the amount that has requested for a payment.
- Authorization Count
Indicates the number of payments that have been authorized.
- Settlement Count
Indicates the number of settlements.
- Authorization Failure Count
Indicates the number of authorizations that have failed.
- Settlement Failure Count
Indicates the number of settlements that have failed.
Grouped measures
The following table provides a list of the SO Payment Summary grouped measures:
- Measure
- Description
- Percentage Authorization Failures
Indicates the percentage of the failed authorizations.
- Percentage Settlement Failures
Indicates the percentage of the failed settlements.