Accrual Account

Identifies 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 is required and editable from the Sales Program Record View for Accrual, Brokerage, Off Book, and Rebate Programs.

Database Field: ERPx_SPProgramHeader.CRAccountSK

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

Identifies 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 is required and editable from the Sales Program Record View for Accrual, Brokerage, and Rebate Programs. 

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. This is required and not editable after the initial save. Programs can only be applied to sale transactions where the Customer Currency and the Program Currency match.

Database Field: ERPx_

SPProgramHeader.

CurrencySK

A single select standard lookup to identify the Currency the Program is stated in. This defaults to blank for new records but is required. If not assigned, the message "Program Rate Currency is required." will be displayed on Save. This field is not editable after the initial Save. Programs can only be applied to sale transactions where the Customer Currency and the Program Currency match.

This lookup contains a blank value and all the System Currencies that are open to the current Company.

Database Field: ERPx_SPProgramHeader.CurrencySK

A system assigned value, from the Program Class, that identifies the Type of Sales Program. The options include: Brokerage, Accrual, On Invoice, Off Book and Rebate. This is never editable.

A lookup to identify how often the Program is settled. This defaults to "Invoice" for all Freight Accrual, On Invoice, and Promotion programs and is not editable. This defaults to blank and is required for Brokerage programs. If missing, the message "Frequency is required." will be displayed on Save.

A Settle Frequency of "Invoice" means that the program is fully accrued for and charged when the Sales Invoice is Posted. All other options are only used for internally information and do not impact any functionality.

For Brokerage Programs, this field is always editable from the record view.

This lookup contains all the values in the SPSettlementFrequency Enumeration Class except "Invoice".

Database Field: ERPx_SPProgramHeader.SettlementFrequencySK

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