Series Reference

Series

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:

Series name Purpose Applies to... Used in worksheets...
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:

  • Claim

  • Off-invoice

  • Deduction

  • Non-Trade

  • Claim resulting from an original claim split

  • Deduction resulting from an original deduction split


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