Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

(Master File Name)'s are (explain what these are and what their purpose is). They are used in the (identify each functional area these are used in) Functional Area(s) (to support other master files, to support transactions, to support other master files and transactions.). The

Insert excerpt
Def - Program Type - GA Accrual
Def - Program Type - GA Accrual
nopaneltrue
 The purpose of this page is to add, edit, remove, and activate/inactive these records.

Software Version: 20192022.MM04.DD 22 and newer

Table of Contents
typeflat

Page Header

Toolbar IconsDescription
Column Filter Show/Hide
Insert excerpt
Column Filter Show/Hide - Global
Column Filter Show/Hide - Global
nopaneltrue
Delete
Insert excerpt
Delete -
Global
LV 3.0
Delete -
Global
LV 3.0
nopaneltrue
Edit
Insert excerpt
Edit -
List View (ML)
LV 3.0
Edit -
List View (ML)
LV 3.0
nopaneltrue
Excel
Insert excerpt
Excel -
Global
LV 3.0
Excel -
Global
LV 3.0
nopaneltrue
Favorites
Insert excerpt
Favorites Add/Remove - Global
Favorites Add/Remove - Global
nopaneltrue
Grid LayoutGroup By Show/HideGrid Layout
Insert excerpt
Grid Layout
Group By Show/Hide - Global
Group By Show/Hide - Global
nopaneltrue
Help
Insert excerpt
Help - Global
Icon
3.0
Help - Global
Icon
3.0
nopaneltrue
New
Insert excerpt
New -
In line addNew - In line add
Global 3.0
New - Global 3.0
nopaneltrue
Quick Column Filter
Insert excerpt
Quick Column Filter
Quick Column Filter
nopaneltrue
SaveSaved LayoutsSave - List View (ML)
Insert excerpt
Save - List View (ML)
Column Layouts for Framework 3.0 - Global
Column Layouts for Framework 3.0 - Global
nopaneltrue
FieldsDescriptionCheckbox
Insert excerpt
Checkbox
Used to select one or more records for delete or mass update.Accrual Item

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Accrual Account

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

AP Vendor

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

Calculated OnA single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####
Checkbox
nopaneltrue
Accrual Account

Insert excerpt
Def - GL Account - Accrual
Def - GL Account - Accrual
nopaneltrue
This is displayed as [GL Account ID] - [GL Account Description]. This is required and is always editable from the Accrual Record View.

Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.CRAccount

Accrual ID

Insert excerpt
Def - Program ID - Accruals
Def - Program ID - Accruals
nopaneltrue
 This is required and is always editable from the Accrual Record View.

Database Field: ERPx_CPAccrual.AccrualItem

Assign Rate By

Insert excerpt
Def - Assign Rate By GA Accrual
Def - Assign Rate By GA Accrual
nopaneltrue
This is required and is always editable from the Accrual Record View.

This lookup contains all the values in the CPAssignRateBy Enumeration Class.

Database Field: ERPx_CPAccrual.AssignRateByEN

Assign Rules By

Insert excerpt
Def - Assign Rules By GA Accrual
Def - Assign Rules By GA Accrual
nopaneltrue
This is required and is always editable from the Accrual Record View.

This lookup contains all the values in the CPAssignRulesByEnumeration Class.

Database Field: ERPx_CPAccrual.AssignRulesByCSVEN

Calculated On

Insert excerpt
Def - Calculated On - Ticket Accruals
Def - Calculated On - Ticket Accruals
nopaneltrue
This is required and is always editable from the Accrual Record View.

This lookup contains all the values in

the (EnumerationClassName)

the CPAccrualCalcMethod Enumeration Class.

Expense Account. Linked

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabled

Database Field: ERPx_

#####.#####

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

Rate

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Settle Method

A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####.

This lookup contains all the values in the (EnumerationClassName) Enumeration Class. 

UOM

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

(Field Name) ID

The unique identifier of the (what type of record is this). This default to blank but is required for all records, must be unique (what must it be unique by), and must be <= 25 characters.

Linked Database Field: ERPx_####.OOOO

(Field Name) Description

The name associated with the (ID Field Name) ID. This is required for all records but does not need to be unique (what must it be unique by) (and defaults from or is calculated by). 

Linked Database Field: ERPx_#####.#####.

InactiveA Yes/No field used to identify if the record is Inactive. If set to 'Yes' then it's "Inactive" and will not be included in look-ups for transactions or other master files. If set to 'No' then it's "Active" and can be used without restrictions. ('No' values display as blank in the grid). This value is always editable. Linked Database Field: ERPx_#####.#####.Date FieldThe date of the (what is the date for) that was created by the transaction. Linked Database Field: ERPx_#####.#####.HyperlinkA hyperlink show the (Field Name) of the transaction. Clicking on the link opens the record view of the transaction. This field is not editable. Linked Database Field: ERPx_#####.#####.Lookup (from an Enumeration)

A single-select standard lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####.

This lookup contains all the values in the (EnumerationClassName) Enumeration Class. 

Lookup (non Enumeration)

A (single-select standard, single select load on demand, or multi-select) lookup to select (describe what is being selected). This defaults to (Default Value) and is (always, never, or conditionally) required. If not assigned, the message "(what message is displayed)" will be displayed. This field is (always, never, or conditionally) enabledLinked Database Field: ERPx_#####.#####

This lookup contains a blank value, the current assigned value, and a list of all the 'Active' (what does it include).

Text Field

The [Describe what the field shows] (formatted as …(if applicable)). This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This column has a grand total at the bottom. The values comes from the (Enumeration Class) Enumeration. Linked Database Field: ERPx_#####.#####.

(text box or non-editable text box) (formatted as …(if applicable)) to... . This is only populated for (what is it populated for...) and (defaults from or is calculated by…). This is (always, never, or conditionally) required and must be <= (how many) characters. (This column has a grand total at the bottom). Linked Database Field: ERPx_#####.#####.

Yes/No Lookup

A Yes/No lookup to identify whether or not the feature is turned on. The value defaults to "Yes" but can be changed at anytime. 

A value of "Yes" means that...

A value of "No" means that...

CPAccrual.AccrualCalcMethodSK

Default Rate

Identifies the "Default" rate/percentage of the Accrual. This defaults to 0.0000 for new records but is not required to be changed. This field is always editable from the Accrual Record View.

(lightbulb) This only identifies the default rate. However, the actual Rates may be different if the "Assign Rate By" property is not set to "Default Rate".

Database Field: ERPx_CPAccrual.Rate

End Date

Identifies the Date the Accrual Program ends. A blank value assumes the Accrual program does not end. This is not required and is always editable from the Accrual Record View.

Database Field: ERPx_CPAccrual.EndDate

Expense Account

Insert excerpt
Def - GL Account - Expense
Def - GL Account - Expense
nopaneltrue
This is displayed as [GL Account ID] - [GL Account Description]. This is required and is always editable from the Accrual Record View.

Database Fields: ERPx_GLAccount.AccountNumber - Description, ERPx_CPAccrual.DRAccount

Inactive

Insert excerpt
Def - Inactive
Def - Inactive
nopaneltrue

Database Field: ERPx_CPAccrual.IsInactive

Rate UOM

Identifies the UOM associated with the Accrual Rate. This value is informational only and can only be edited by changing the 'Calculated On' property on the Accrual Record View.  If the 'Calculated On' property is set to '% Gross $' then the Rate UOM value will display '%'.  

Insert excerpt
Def - UOM
Def - UOM
nopaneltrue

Database Field: ERPx_CPAccrual.UOMSK

Settlement Method

Identifies how the Accrual Program is Settled. This is required and is always editable from the Accrual Record View.

  • AP Invoice: The Accrual is created via a separate AP Invoice that posts directly to AP when the Ticket is posted.
  • GL AccrualThe Accrual is included with the journal entry created by the Ticket.

This lookup contains all the values in the CPSettleMethod Enumeration Class.

Database Field: ERPx_CPAccrual.AccrualSettleMethodSK

Start Date

Identifies the Date the Accrual Program starts. This is required and is always editable from the Accrual Record View.

Database Field: ERPx_CPAccrual.StartDate

Vendor Name

Insert excerpt
Vendor Name
Vendor Name
nopaneltrue
This identifies the AP Vendor that will be paid when this accrual is used. For Accrual programs with a 'Settlement Method' of "AP Invoice", this is required and always editable from the Accrual Record View.  For Accrual programs with a 'Settlement Method' of "GL Accrual", this is blank and not editable.

Database Field: ERPx_CPAccrual.VendorSK

Related Topics



Expand
titlePage Definitions

Page Definitions


...