Column Filter Show/Hide

Excel

Favorites

Group By Show/Hide

Help

More Actions

• IQ: Broker Activity: Opens the Broker Activity Inquiry for the selected record

Process Settlements For 

Displays a drop-down menu of options including:

• Brokerage: Opens the Process Settlements page to create Brokerage Settlements

• Off Book: Opens the Process Settlements page to create Off Book Settlements

• Rebates: Opens the Process Settlements page to create Rebate Settlements 

Quick Column Filter

Saved Layouts

Fields

Description

Company Balance

Displays the current open Program balance, in the Company currency. This is required and is not editable. This is a calculated field that is not stored in the database. It is calculated from the 'Program Balance' amount using the associated currency exchange rate. It is not stored in the database.

Currency ID

Displays the ID of the currency assigned as the 'Program Rate Currency'. This is required and is not editable after the Program has been saved.

Database Fields: ERPx_SPProgramHeader.CurrencySK, ERPx_MFCurrency.CurrencyID

Payee ID

Displays the ID of the Customer or Vendor that is assigned as the 'Payee' on the Sales Program. This is required and is not editable after the Program has been saved.

Database Fields: ERPx_SPProgramHeader.ProgramEntitySK, ERPx_APVendor.VendorID, ERPx_APCustomer.CustomerID

Payee Name

Displays the name of the Customer or Vendor that is assigned as the 'Payee' on the Sales Program. This is required and is not editable after the Program has been saved.

Database Fields: ERPx_SPProgramHeader.ProgramEntitySK, ERPx_APVendor.VendorName, ERPx_APCustomer.CustomerName

Program

Database Fields: ERPx_SPProgramHeader.ProgramID, ERPx_SPProgramHeader.Description

Program Balance

Displays the current open Program balance, in the Program currency. This is required and is not editable. 

Database Field: ERPx_SPProgramSettlementHeader.ComputedAmount, ERPx_SPProgramSettlementHeader.SettledAmount, ERPx_SPProgramSettlementHeader.WriteoffAmount

Program Class

Displays the Program Class assigned to the Program. This is required and is not editable after the Program has been saved.

Database Fields: ERPx_SPProgramHeader.ProgramClassSK, ERPx_SPProgramClass.ClassName

Program Type

Displays the Type of Sales Program. The potential 'Program Types' include:

• Brokerage: A Program that pays an AP Vendor.

• Off Book: A Program that can either pay an AP Vendor or credit an AR Customer but does not post to the General Ledger until the program is settled.

• Rebates: A Program that calculates amounts that will either pay an AP Vendor or credit an AR Customer. 

Database Fields: ERPx_SPProgramHeader.ProgramClassSK, ERPx_SPProgramClass.ProgramTypeSK

Settle To 

Displays how the Program is settled. This is required and is not editable after the Program has been saved.

The Settle To options include:

1. AP Invoice - Paid in Full Orders

2. AP Invoice - All Orders

3. AR Credit Memo

Database Fields: ERPx_SPProgramHeader.SettlementMethodSK