Defining a Ledger Template

PeopleSoft provides several ledger templates that include default records and fields that support the ChartFields and other field and record definitions delivered with the system. Do not change the system-generated set of default values unless you modify your system or if you have multiple sets of ChartFields.

To define ledger templates, use the Ledger Template component (LEDGER_TEMPLATE).

This section discusses how to:

Create or modify ledger template record definitions.
Create or modify ledger template field definitions.
Modify tables to store separate debit and credit balances.

Note: Deselect all check boxes on the Installation Options - Products page for products that you have not licensed and are not using. As delivered, all check boxes for all products whether licensed or unlicensed are selected on the Products page and this can result in unnecessary setup for the unlicensed products. For example, if General Ledger is selected on the Products page and you have not licensed the product, there are fields that are only applicable to General Ledger that are then available for input of values on the ledger template.

Pages Used to Define a Ledger Template

Page Name	Definition Name	Navigation	Usage
Templates - Record Definitions	LEDGER_TEMPLATE1	General Ledger, Ledgers, Templates, Record Definitions	Specify the record names for a ledger template. Do this only if you are adding a new template or modifying the default records of the templates delivered with the system.
Templates - Field Definitions	LEDGER_TEMPLATE2	General Ledger, Ledgers, Templates, Field Definitions.	Specify the field names for a ledger template. Do this only if you are modifying the default fields or if you are adding the fields to store debit amounts separate from credit amounts.

Templates - Record Definitions Page

Use the Templates - Record Definitions page (LEDGER_TEMPLATE1) to specify the record names for a ledger template.

Do this only if you are adding a new template or modifying the default records of the templates delivered with the system.

Navigation

select General Ledger, then select Ledgers, then select Templates, then select Record Definitions

Image: Templates - Record Definitions page

This example illustrates the fields and controls on the Templates - Record Definitions page. You can find definitions for the fields and controls later on this page.

Note: Create or modify ledger template record definitions only if you are adding a new template or modifying the default records of the templates delivered with the system.

Description

Enter a description of this ledger template to appear on pages, inquiries, prompt lists, and reports.

Detail

Select if this ledger template represents a detail ledger.

Summary

Select if this ledger template represents a summary ledger.

Default Ledger Type

Select a default ledger type closest to the type of ledger template that you are creating. This selection determines the default record definitions that the system generates.

Default

Click the Get Template Default button to apply a set of default records to every template in the system. You can modify these values.

If you select Commitment Control as the default ledger type, the system automatically populates the record and field names. These are required fields and cannot be modified.

Note: TheGet Template Default button is not available to a Commitment Control ledger type.

Record (Table) Name

Represents the ledger record that you use to store the balances for each ChartField combination that has posted activity.

Ledger Tmp (ledger temporary)

Indicates a worktable used in ledger processing. Detail and Summary templates both require this worktable.

Ledger Tmp2 (ledger temporary 2)

Indicates a worktable used in ledger processing.

Journal Line

Stores detail lines containing the monetary and statistical amounts for each journal entry.

Journal Line Tmp (journal line temporary)

Indicates a worktable used in journal processing.

Secured Rptg Vw (secured reporting view)

(Optional) Specifies a ledger reporting view (LED_RPTG_VW for General Ledger and LED_RPTG_KK_VW for Commitment Control) to secure access to the ledger by authorized user IDs during PS/nVision reporting. Because this is an optional security field, if you do not specify a ledger reporting view, PS/nVision provides reporting directly against the ledger.

Note: Use the Ledger Security page to specify which user IDs have access to this ledger data. If you specify a reporting view and an unauthorized user tries to access the ledger, PS/nVision displays all zeros for ledger amounts on the report.

See PeopleTools: PS/nVision, Setting Up PS/nVision Security, Implementing PS/nVision Ledger-Based Data security

Account ChartField

Identifies the record that stores the account ChartField values. In the standard PeopleSoft General Ledger system, this is the GL_ACCOUNT_TBL.

Combo Data (combination data)

Stores the data used for ChartField combination editing.

Jrnl Gen Tmp (journal generator temporary)

Indicates a worktable used by Journal Generator process.

Summary Ledger Stage Tbl (summary ledger staging table)

Acts as a holding table for ledger rows. After the system creates the summary ledger, the posting process stores additional rows here. When you run the Summary Ledger Incremental Posting process, the system incrementally updates the Summary Ledger Staging table with this stored data. This field is required only on Detail templates and not on Summary templates.

Consolidations Log

Identifies the record to update for the consolidations log during the consolidation process.

Consolidation Equity Temp (consolidation equity temporary)

Identifies the worktable used to calculate equity elimination in the consolidation process.

Closing Record Names

The following fields apply to the closing process.

Closing Log

Identifies the record to update for the close log during the closing process.

Closing Tmp (closing temporary)

Identifies a worktable that is used in the closing process. This table and the Closing RE Tmp table have the same structure, and both are required for the closing process.

Closing RE Tmp (closing retained earnings temporary)

Identifies a retained earnings worktable that is used in the closing process. This table and the Closing Tmp table have the same structure; both are required for the close process.

Closing ChartField Table

Identifies the table that stores the closing ChartFields values.

Closing Account Tmp (closing account temporary)

Identifies a worktable that stores account information for the business unit being closed.

Closing Journal Header Tmp (closing journal header temporary)

Identifies a worktable that stores the header of the source journal that results from the interim closing process or the yearn end closing process.

Closing Journal Line Tmp (closing journal line temporary) and Closing Journal Line Tmp2 (closing journal line temporary 2)

Identifies worktables that store the lines of the source journal that results from the interim closing process or the year end closing process.

Multicurrency Record Names

The following fields apply to multicurrency processing.

MultiCurrency Log

Identifies the record to update for the currency log during the multicurrency process.

MultiCurrency Tmp (multicurrency temporary) and MultiCurrency Tmp1 (multicurrency temporary 1)

Identifies worktables that are used in multicurrency processing.

ADB (Average Daily Balancing) Record Names

The following fields apply to ADB ledger processing.

ADB Ledger

Stores the balances in a daily ledger when ADB is activated.

Ledger ADB Tmp (ledger average daily balance temporary), Ledger ADB Tmp2 (ledger ADB temporary 2), and Ledger ADB Tmp3 (ledger ADB temporary 3)

Identifies a worktable that Ledger ADB Posting uses during ADB processing to post daily balances to the ADB Ledger Holding table.

ADB Ledger Holding Table

Stores daily balances from the Journal Post process. During ADB processing, the system posts the balances from this table to the ADB ledger table and deletes these balances from the holding table to prevent double posting.

ADB Ledger Adj. Holding Tbl (ADB ledger adjustments holding table) and ADB Ledger Adj. Holding Tbl 2 (ADB ledger adjustments holding table 2)

Stores adjustments to daily balances from the Journal Post process. During ADB processing, the system posts the balances from these tables to the ADB ledger table.

Ledger Loader Record Names

The following fields apply to ledgers loaded from another PeopleSoft or third-party system.

Ledger Load Staging Table

Stores values used in ledger load processing (ChartField value mapping) and Ledger Publish Enterprise Integration Point, which Consolidations uses.

Led Load Temp Record (ledger load temporary record) and Led Load Temp Record 2 (ledger load temporary record 2)

Identifies work records used in ledger load processing

Templates - Field Definitions Page

Use the Templates - Field Definitions page (LEDGER_TEMPLATE2) to specify the field names for a ledger template.

Do this only if you are modifying the default fields or if you are adding the fields to store debit amounts separate from credit amounts.

Navigation

General Ledger, Ledgers, Templates, Field Definitions.

The system populates fields on the Field Definitions page with default values based on the default ledger type that you select on the Templates - Record Definitions page. You can modify these values and add fields to store debit amounts separate from credit amounts.

Account

Contains the field name of the account ChartField. The system uses this field name only for background processing. The online PeopleCode still refers to the Account field name.

Monetary Amount

A required field that contains the monetary (base currency) amount of the journal line.

Statistical Amount

(Optional) Contains the statistical amount of the journal line.

Posted Total Amount

Contains the net balance of the debit and credit amounts for each ChartField combination that has been posted to the ledger.

Posted Total Debits

If populated, and if you selected the Separate Debit/Credit option for the ledger on the Ledgers For A Unit - Definition page, the system populates these fields and tracks separate debit and credit balances. To use this option, add this amount field to the record.

Posted Total Credits

If populated this means that you selected the Separate Debit/Credit option for the ledger on the Ledgers For A Unit page, resulting in the tracking of separate debits and credits. To use this option, add this amount field to the record.

Combination Edit Template

Required for journal edit processing. Select JOURNALS.

Warning! Even if you are not using ChartField combination editing, select the JOURNALS combination template. You must populate this field to run the journal edit process.