General Ledger Implementation

PeopleSoft Setup Manager enables you to review a list of setup tasks for the products that you are implementing. The setup tasks include the components that you must set up, listed in the order in which you must enter data into the component tables, and the links to the corresponding documentation.

General Ledger also provides component interfaces to help you load and initialize setup data from you existing system into General Ledger tables. Use the Excel to Component Interface utility with the component interfaces to populate the tables.

This table lists all components that have a component interface delivered for use with the Excel to Component Interface import utility.

Note:

The Excel to Component Interface import utility is delivered for a technical user to provide data conversion during implementation.

Component Component Interface References

ALTACCT

Alternate Account ChartField

ALTACCT_CF

See Application Fundamentals: Alternate Account Page.

BD_SCENARIO

Budget Scenario ChartField

BUDGET_SCENARIO

See Application Fundamentals: Scenario Page.

BUDREF_PNL

Budget Reference ChartField

BUDGET_REF_CF

See Application Fundamentals: Budget Reference Page.

CHARTFIELD1

ChartField1

CHARTFIELD1

See Application Fundamentals: ChartField 1 Page.

CHARTFIELD2

ChartField2

CHARTFIELD2

See Application Fundamentals: ChartField 1 Page.

CHARTFIELD3

ChartField3

CHARTFIELD3

See Application Fundamentals: ChartField 1 Page.

CLASS_PNL

Class ChartField

CLASS_CF

See Application Fundamentals: Class Field Page.

DEPARTMENT

Department ChartField

DEPT_CF

See Application Fundamentals: Department Page.

FUND_DEFINITION

Fund ChartField

FUND_CF

See Application Fundamentals: Fund Code Page.

GL_ACCOUNT

Account ChartField

ACCOUNT_CF

See Application Fundamentals: Account Page.

GL_PE_CF_SEC_COMP

ChartField pagelet security

SECURITY_CF_PAGELET

See Application Fundamentals: Describing General ChartField Security Functionality

LEDGER_SECURITY

nVision Ledger Security

SECURITY_NVISION_LEDGER

See Application Fundamentals: Defining Row-Level Security.

OPERATING_UNIT

Operating Unit ChartField

OPER_UNIT_CF

See Application Fundamentals: Operating Unit Page.

OPR_DEFAULT_FIN

User Preferences

OPR_DEFAULT_FIN

See Application Fundamentals: Defining Cross-Application User Preferences.

PRODUCT

Product ChartField

PRODUCT_CF

See Application Fundamentals: Product Page.

PROGRAM_DEFINITION

Program ChartField

PROGRAM_CF

See Application Fundamentals: Program Code Page.

PROJECT

Project ChartField

PROJECT_CF

See Application Fundamentals: Project Page.

SEC_BU_CLS

Business Unit Security by Permission List

SECURITY_BU_CLS

See Application Fundamentals: Defining Row-Level Security.

SEC_BU_OPR

Business Unit Security by User ID

SECURITY_BU_OPR

See Application Fundamentals: Defining Row-Level Security.

SEC_LEDGER_CLS

Ledger Security by Permission List

SECURITY_LEDGER_CLS

See Application Fundamentals: Defining Row-Level Security.

SEC_LEDGER_OPR

Ledger Security by User ID

SECURITY_LEDGER_OPR

See Application Fundamentals: Defining Row-Level Security.

STATISTICS_TBL

Statistics Code

STATISTICS_CODE

See Application Fundamentals: Statistics Code Page.

TAX_AUTHORITY_VAT

Value Added Tax Authority

TAX_AUTHORITY_VAT

See PeopleSoft Global Options and Reports: Value Added Tax Authorities Page.

TAX_BU_CODE_VAT

VAT Accounts by Business Unit component

TAX_BU_CODE_VAT

See PeopleSoft Global Options and Reports: VAT Accounts by Business Unit Page.

TAX_CODE_VAT

Value Added Tax Code

TAX_CODE_VAT

See PeopleSoft Global Options and Reports: Value Added Tax Code Page.

VAT_ENTITY_ID

Value Added Tax Entity

VAT_ENTITY_ID

See PeopleSoft Global Options and Reports: Identification Page.

Other Sources of Information

In the planning phase of your implementation, take advantage of all PeopleSoft sources of information, including the installation guides, and data models.

PeopleTools Documentation: PeopleSoft Setup Manager

PeopleTools Documentation: PeopleSoft Component Interfaces