The following table lists the series in Oracle Demantra Settlement Management, including series that are not shown in the Oracle Demantra Settlement Management worksheets by default:
| Approved Non Trade
| Sum of amounts for approved non-trade settlements.
| Non-trade settlements
|
|
| Approved Trade
| Sum of amounts for approved trade settlements.
| Trade settlements
| Settlement Details By Account, Settlement Account Summaries
|
| Customer CHECK #
| Number of the check from the customer. Uses the customer's check numbering system.
| Deductions and off-invoice settlements
| Settlement Details By Account
|
| Customer CHECK DATE
| Date of the check from the customer.
| Deductions and off-invoice settlements
| Settlement Details By Account
|
| Customer Invoice #
| Number of the invoice from the customer. Uses the customer's invoice numbering system.
| Claims
| Settlement Details By Account
|
| Customer Invoice DATE
| Date of the invoice from the customer.
| Claims
| Settlement Details By Account
|
| G/L Code
| General ledger code that best explains why this settlement was denied or split.
| All settlements
| Settlement Details By Account
|
| Linked Promo ID
| ID of the promotion with which this settlement is linked.
| All settlements
|
|
| Linked Promotion
| Name of the promotion with which this settlement is linked.
| All settlements
|
|
| Matched Event
| Name of the promotion with which this settlement is linked.
| All settlements
| Settlement Details By Account
|
| Owner
| Oracle Demantra Settlement Management user who has claimed responsibility for this settlement.
| All settlements
| Settlement Details By Account
|
| Posted DATE
| Date on which this settlement entered the system.
| All settlements
| Settlement Details By Account
|
| Promotion Budget
| Total projected spend for the selected promotions.
|
|
|
| Settlement #
| Unique identifier of this settlement.
| All settlements
|
|
| Settlement Account ID
| Customer with which this settlement is associated.
| All settlements
| Settlement Details By Account
|
| SETTLEMENT STATUS
| Current status of this settlement, within Oracle Demantra Settlement Management. One of the following:
-
New
-
In Progress
-
Unapproved
-
Approved
-
Duplicate
-
Denied
-
Write Off
These are not customizable. You can also display the settlement status as a level.
| All settlements
| Settlement Details By Account
|
| SETTLEMENT TYPE
| Settlement type, for use by Oracle Demantra Settlement Management. One of the following:
These are not customizable. You can also display the settlement type as a level.
| All settlements
| Settlement Details By Account
|
| Supplier CHECK #
| Number of the check that reimburses the customer for this claim.
| Claims
| Settlement Details By Account
|
| Supplier CHECK DATE
| Date of the check to the customer.
| Claims
| Settlement Details By Account
|
| Supplier Invoice #
| Number of the invoice to the customer.
| Deductions and off-invoice settlements
| Settlement Details By Account
|
| Supplier Invoice DATE
| Date of the invoice to the customer.
| Deductions and off-invoice settlements
| Settlement Details By Account
|
| Total Outstanding Non Trade
| Sum of amounts for unapproved and unresolved non-trade settlements.
| Non-trade settlements
|
|
| Total Outstanding Trade
| Sum of amounts for unapproved and unresolved trade settlements.
| Trade settlements
| Settlement Details By Account, Settlement Account Summaries
|
| Unapproved Event Product
| Doesn't work
|
|
|
| Unapproved Non Trade
| Sum of amounts for unapproved non-trade settlements.
| Non-trade settlements
|
|
| Unapproved Trade
| Sum of amounts for unapproved trade settlements.
| Trade settlements
| Settlement Details By Account, Settlement Account Summaries
|
| Unresolved Non Trade
| Sum of amounts for unresolved non-trade settlements.
| Non-trade settlements
|
|
| Unresolved Trade
| Sum of amounts for unresolved trade settlements.
| Trade settlements
| Settlement Details By Account, Settlement Account Summaries |
