Page Comparison

Accrual AccountIdentifies either the GL Account that will be used for the Accrual side of the Journal Entry or the rule for how the GL Account will be assigned. This

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 AccountIdentifies either the GL Account that will be used for the Expense side of the Journal Entry or the rule for how the GL Account will be assigned. This

Database Field: ERPx_SPProgramHeader.DRAccountSK

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

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

Identifies the currency that the program is being calculated in.

Database Field: ERPx_SPProgramHeader.CurrencySK

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