Column Filter Show/Hide

Delete

Edit

Excel

Favorites

Group By Show/Hide

Help

New

• Accrual

• Brokerage

• Off Book

• On Invoice

• Rebate

Notes

Quick Column Filter

Refresh 

Saved Layouts

Fields

Description

Checkbox

Accrual Account

Database Field: ERPx_SPProgramHeader.CRAccountSK

Description

Identifies the Description (program name) associated with the Program ID. This is not required, and duplicate values are allowed. This is editable from the Sales Program Record View.

Database Field: ERPx_SPProgramHeader.Description

End

Identifies the Date the program ends. This is required and is editable from the Sales Program Record View. Programs with an End Date that occurs prior to a Sales Orders Invoice Date will not be evaluated, even if the Program is still Active. 

Database Field: ERPx_SPProgramHeader.EndDate

Expense Account

Database Field: ERPx_SPProgramHeader.DRAccountSK

Inactive

Database Field: ERPx_SPProgramHeader.Inactive

Payee

Identifies the Name and ID of the Customer or Vendor that will be paid for the Program, displayed as [Customer/Vendor Name] ([Customer/VendorID]). This is not editable after the initial save and is required for Brokerage, Off Book, and Rebate Programs. This value will be blank for Accrual and On Invoice programs as they do not create settlements.

Database Field: ERPx_SPProgramHeader.ProgramEntitySK

Program Class

Identifies the Class the program is assigned to. This is not editable after the initial save and is required.

Database Field: ERPx_SPProgram.ProgramClassSK

Program ID

Database Field: ERPx_SPProgramHeader.ProgramID

Program Rate Currency

Database Field: ERPx_SPProgramHeader.CurrencySK

Program Type

Identifies the Type of Program. This is required and not editable after the initial save. The Types of Programs include

Settle To

Identifies how the Program will be settled (paid). This is not editable after the initial save and is required for Brokerage, Off Book, and Rebate Programs. This value will be blank for Accrual and On Invoice programs as they do not create settlements. Accrual programs add journal lines to the Journal Entry that is created when the sales invoice, price adjustment, or return is posted and On Invoice programs add line item to sales orders, price adjustments, and returns that are included in the Journal Entry that is created when they post.

The available options include:

• AP Invoice - Paid In Full Orders: Sales Invoices that have been paid in full will be considered eligible for Settlement to the Payee assigned to the Program.

• AP Invoice - All Orders: Sales Invoices that have been posted, regardless of payment status will be considered eligible for Settlement to the Payee assigned to the Program.

• AR Credit Memo: Sales Invoices that have been posted, regardless of payment status will be considered eligible for Settlement as an AR Credit Memo for the Payee assigned to the Program.

Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

Settlement Frequency

Identifies how often the Program is settled. This is informational only (does not drive any functionality) and is always editable from the Sales Program Record View for Brokerage, Off Book, and Rebate Programs. This value will be blank for Accrual and On Invoice programs as they do not create settlements. Accrual programs add journal lines to the Journal Entry that is created when the sales invoice, price adjustment, or return is posted and On Invoice programs add line item to sales orders, price adjustments, and returns that are included in the Journal Entry that is created when they post.

Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

Start

Identifies the date the program starts. This is required and is editable from the Sales Program Record View. Programs with a Start Date that occur after a Sales Orders Invoice Date will not be evaluated.

Database Field: ERPx_SPProgramHeader.EndDate