new peoplesoft enterprise application fundamentals 9.1 reports · 2009. 11. 11. · chapter 1...
TRANSCRIPT
PeopleSoft Enterprise ApplicationFundamentals 9.1 Reports
November 2009
PeopleSoft Enterprise Application Fundamentals 9.1 ReportsSKU fscm91fspf-r1109
Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Trademark NoticeOracle is a registered trademark of Oracle Corporation and/or its affiliates. Other namesmay be trademarks of theirrespective owners.
License Restrictions Warranty/Consequential Damages DisclaimerThis software and related documentation are provided under a license agreement containing restrictions on use anddisclosure and are protected by intellectual property laws. Except as expressly permitted in your license agreementor allowed by law, youmay not use, copy, reproduce, translate, broadcast, modify, license, transmit, distribute,exhibit, perform, publish or display any part, in any form, or by anymeans. Reverse engineering, disassembly, ordecompilation of this software, unless required by law for interoperability, is prohibited.
Warranty DisclaimerThe information contained herein is subject to change without notice and is not warranted to be error-free. If you findany errors, please report them to us in writing.
Restricted Rights NoticeIf this software or related documentation is delivered to the U.S. Government or anyone licensing it on behalf of theU.S. Government, the following notice is applicable:
U.S. GOVERNMENT RIGHTS
Programs, software, databases, and related documentation and technical data delivered to U.S. Government customersare “commercial computer software” or “commercial technical data” pursuant to the applicable Federal AcquisitionRegulation and agency-specific supplemental regulations. As such, the use, duplication, disclosure, modification, andadaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract, and,to the extent applicable by the terms of the Government contract, the additional rights set forth in FAR 52.227-19,Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 Oracle Parkway, Redwood City,CA 94065.
Hazardous Applications NoticeThis software is developed for general use in a variety of informationmanagement applications. It is not developedor intended for use in any inherently dangerous applications, including applications whichmay create a riskof personal injury. If you use this software in dangerous applications, then you shall be responsible to take allappropriate fail-safe, backup, redundancy and other measures to ensure the safe use of this software. OracleCorporation and its affiliates disclaim any liability for any damages caused by use of this software in dangerousapplications.
Third Party Content, Products, and Services DisclaimerThis software and documentationmay provide access to or information on content, products and services from thirdparties. Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kindwith respect to third party content, products and services. Oracle Corporation and its affiliates will not be responsiblefor any loss, costs, or damages incurred due to your access to or use of third party content, products or services.
Contents
Chapter 1Application Fundamentals Reports ... . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1Application Fundamentals Reports: General Description .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1Managing ChartFields for Reports. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10
Report Samples . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .15
Copyright © 2009, Oracle and/or its affiliates. All rights reserved. iii
Contents
iv Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
CHAPTER 1
Application Fundamentals Reports
This chapter lists the reports provided with Oracle’s PeopleSoft Enterprise Application Fundamentals 9.1 PeopleBook,including general information and links to additional information about specific reports in various PeopleSoftEnterprise applications and discusses how to manage ChartFields for reports.
Note. For samples of these reports and reports associated with particular applications, see the Portable DocumentFormat (PDF) files that are published on CD-ROM with this and other product documentation.
See AlsoEnterprise PeopleTools PeopleBook: PeopleSoft Process Scheduler
Application Fundamentals Reports: General DescriptionUse this table to find general information about PeopleSoft Enterprise Application Fundamentals reports.
Report ID and ReportName
Description Navigation Run Control Page
APY0003AP Operator Profile
Displays Payables Userdefaults by SetID. For eachuser, the default values forBusiness Unit, SetID andOrigin as well as Vendorand Voucher ProcessingAuthority display. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,User Preferences, AP UserPreferences Report
RUN_APY0003
APY0012Accounting Entry Template
Displays availableaccounting entry templatesand shows template name,effective date, type,description, account,department, product, andproject. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Accounting Entry Templates,Template Report
RUN_APY0012
CFC001ChartField Project
Displays steps to configurea ChartField to individualneeds. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,Configuration Steps
RUN_CFC001
EO9030Cross/Reciprocal Rate Calc
Displays the cross ratescalculated for selectedcurrency exchange rates.(SQR)
Set Up Financials/SupplyChain, CommonDefinitions, Market Rates,Cross/Reciprocal Rate Calc
RUN_EO9030
Copyright © 2009, Oracle and/or its affiliates. All rights reserved. 1
Application Fundamentals Reports Chapter 1
Report ID and ReportName
Description Navigation Run Control Page
FIN0001Installation Options
Displays the contents of thePeopleSoft Installation Table,which contains system-wideparameters used by theapplications. (Crystal)
Set Up Financials/SupplyChain, Install, InstallationOptions Report
RUN_FIN0001
FIN0002Detail Calendars
Displays information aboutdetail calendars, includinga description as well as alisting of the periods youhave defined for the calendar.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Calendars/Schedules, DetailCalendar Report
RUN_FIN0002
FIN0003TimeSpans
Displays the TimeSpandefinitions for a SetID,including a descriptionand information about thestart year, start period, endyear, and end period. Thereport also shows whetherthe TimeSpan includesforward balances and closingadjustments. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Calendars/Schedules,TimeSpans Report
RUN_FIN0003
FIN0004Account Types
Displays all the accounttypes, including the longand short descriptive name,and indicates whether thesystem carries forward thebalance for that account type.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,Account Types
RUN_FIN0004
FIN0005Statistics Units of Measure
Displays a standard,portrait-style report of thecontents of the StatisticsUnits of Measure table. Thereport also contains the unitof measure and description.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Units of Measure, Units ofMeasure Report
RUN_FIN0005
FIN0006User Preferences
Displays the values you enterfor system users on the UserPreference page. The UserID, business unit, SetID,ledger, source, and as-of datealso display. These are thedefault settings that appearon the pages and reports usedby each user. (SQR)
Set Up Financials/SupplyChain, Common Definitions,User Preferences, UserPreferences Report
RUN_FIN0006
2 Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Chapter 1 Application Fundamentals Reports
Report ID and ReportName
Description Navigation Run Control Page
FIN0007List of Valid SpeedTypes(Crystal )
Displays a valid list ofSpeedTypes. A SpeedTypeenables you to entershorthand keys to trigger asystem expansion intopre-specified values for oneor more fields on a page. Foreach SpeedType, the reportprints a description, the UserID or class, and associatedvalues for account,department, product, project,and statistics code. (Crystal)
If you have configuredChartFields, you might wantto use the FSX0007 report toavoid manual changes to thisCrystal report.
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,SpeedTypes, Run, ProcessScheduler Request, andselect List of Valid SpeedTypes
RUN_FIN0007
FSX0007List of Valid SpeedTypes(XMLPublisher)
Crystal reports requiremanual changes whenthere are ChartFieldconfigurations. XMLPublisher reports do notrequire manual changesto support ChartFieldconfiguration and use thesame criteria from the requestpage as the Crystal reports.
Displays a valid list ofSpeedTypes. A SpeedTypeenables you to entershorthand keys to trigger asystem expansion intopre-specified values for oneor more fields on a page. Foreach SpeedType, the reportprints a description, the UserID or class, and associatedvalues for account,department, product, project,and statistics code.
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,SpeedTypes, Run, ProcessScheduler Request, andselect XMLP: List of ValidSpeed Types
RUN_FIN0007
FIN0008Journal Sources
Displays valid journal entrysources. Source codesdescribe the origination ofjournal entries or the partyresponsible for generatingthe journal, define specialprocessing, and makefinancial transactions easierto identify and report. (SQR)
Set Up Financials/SupplyChain, Common Definitions,Journals, Source Report
RUN_FIN0008
Copyright © 2009, Oracle and/or its affiliates. All rights reserved. 3
Application Fundamentals Reports Chapter 1
Report ID and ReportName
Description Navigation Run Control Page
FIN0010Valid General LedgerAccounts
Displays the valid generalledger accounts by SetID.For each account, the reportprints a description, shortname, and the account type.Shows if the account is astatistical account and if so,what unit of measure is used.If the account contains openitems, lists their descriptionsas well as the edit record andfield that apply. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, selectAccount
RUN_FIN0010
FIN0011Valid Department Codes
Displays valid departmentcodes by SetID. Printsthe department ID and itsdescription, along with eachdepartment manager’s name.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, selectDepartment
RUN_FIN0011
FIN0012Valid Product Codes
Displays valid product codesby SetID. Prints the productID and its description, inascending order by ID.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, selectProduct
RUN_FIN0012
FIN0013Valid Project IDs
Displays valid projects bySetID. For each project,prints the description,manager’s name, and theproject start and end dates.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, selectProject
RUN_FIN0013
FIN0015Valid Statistics Code
Produces a standard portraitstyle report that show thecontents of the StatisticsCodes table. Displaysthe code along with adescription, the standard unitof measure, and the ledgerupdate method. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, selectStatistics Code
RUN_FIN0015
FIN0016Record Groups
Displays tables by therecord group they belong to.Displays a description andtable name for each recordgroup ID. (Crystal)
Set Up Financials/SupplyChain, Business UnitRelated, Reports, RecordGroups
RUN_FIN0016
FIN0017Valid Set IDs
Displays a short and longdescription of each SetIDvalid on a specific date.(Crystal)
Set Up Financials/SupplyChain, Business UnitRelated, Reports, TableSetIDs
RUN_FIN0017
4 Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Chapter 1 Application Fundamentals Reports
Report ID and ReportName
Description Navigation Run Control Page
FIN0018Table Set Controls
Displays the record groupsassociated with the TableSetyou specify, including thefield names and values youenter at the system prompt.Displays the trees designatedfor that TableSet. For eachrecord group, shows the ID,description, SetID, and SetIDdescription. (SQR)
Set Up Financials/SupplyChain, Business UnitRelated, Reports, TableSetControls
RUN_FIN0018
FIN0020Valid General LedgerBusiness Units
Displays a list of businessunits that are valid as of aspecific date. For eachbusiness unit, prints adescription of the unit, andthe default as-of date. (SQR)
Set Up Financials/SupplyChain, Business UnitRelated, Reports, GeneralLedger Units
RUN_FIN0020
FIN0021Ledgers for a Business Unit
Displays information aboutthe ledgers that you havedefined for a business unit.Shows information abouteach ledger, including type,ledger, definition, SetID, dateof last update, and whetherthe ledger is balanced. Alsoshows open accountingperiods, the adjustments year,and journal error handlingoptions. (SQR)
Set Up Financials/SupplyChain, Business UnitRelated, Reports, LedgersFor A Unit
RUN_FIN0021
FIN0022Detail Ledger Definition
Displays general informationabout detail ledgers. Includesa description, error handlingoptions, accounting periods,record names, and a listing ofthe ChartFields associatedwith the ledger. (Crystal)
General Ledger, Ledgers,Detail Ledger Report
RUN_FIN0022
FIN0023Detail Ledger TemplateDefinition
Displays the records andfields included in detailledger templates. (Crystal)
General Ledger, Ledgers,Template Report
RUN_FIN0023
FIN0024Valid Budget Reference
Lists all valid BudgetReference ChartField valuesin a SetID. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Report, SelectBudget Reference
RUN_FIN0024
FIN0025Scenario
Lists by setID the currentactive budget scenario.
Set Up Financial/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, Scenario
RUN_FIN0025
Copyright © 2009, Oracle and/or its affiliates. All rights reserved. 5
Application Fundamentals Reports Chapter 1
Report ID and ReportName
Description Navigation Run Control Page
FIN0030nVision Reports
Displays the PS/nVisionreports for selected businessunits. For each report, showsthe ID, description, layout,scope ID, scope description,business unit, last run date,as-of date type, as-of date,tree date type, and tree date.(Crystal)
General Ledger, GeneralReports, nVision RequestSummary
RUN_FIN0030
FIN0031nVision Scopes
Displays the details of eachPS/nVision Scope definition.(Crystal)
General Ledger, GeneralReports, nVision Scope
RUN_FIN0031
FIN0032Valid Operating Units
Displays the valid operatingunits for a selected SetID.For each SetID it showsthe operating units, theirdescription, their status, andthe effective date of thestatus. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, selectOperating Unit
RUN_FIN0032
FIN0033Valid Alternate Account
Displays the valid AlternateAccounts for a SetID. Foreach alternate account, thereport prints a description,account type, if it has openitems, if it’s a statisticalaccount, any control flags,the current effective statusand, its effective date.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, selectAlternate Account
RUN_FIN0033
FIN0035Currency Codes
Displays information about acurrency, including code,effective date, description,symbol, country, and decimalpoint. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Currency, Currency CodeReport
RUN_FIN0035
FIN0036Alternate Account CrossReference
Displays accountswith correspondingcross-referenced alternateaccounts, by SetID andEffective Date. (SQR)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,Alt Acct Cross Reference
RUN_FIN0036
FIN0037Chartfield 1
Displays the valid values fora selected setID.
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports,Chartfield 1
RUN_FIN0037
FIN0038Chartfield 2
Displays the valid values fora selected setID.
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports,Chartfield 2
RUN_FIN0038
6 Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Chapter 1 Application Fundamentals Reports
Report ID and ReportName
Description Navigation Run Control Page
FIN0039Chartfield 3
Displays the valid values fora selected setID.
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports,Chartfield 3
RUN_FIN0039
FIN0050Valid Fund Codes
Displays a list of all validfund code ChartField values.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, FundCode
RUN_FIN0050
FIN0052Valid Program Codes
Displays a list of all validprogram code ChartFieldvalues. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, selectProgram Code
RUN_FIN0052
FIN0053Valid Class
Displays a list of all validclass ChartField values.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, selectClass Field
RUN_FIN0053
FIN0057Journal Types
Displays the various JournalTypes defined on the JournalTypes page for a particularSetID. Includes descriptionsfor each Journal Type andindicates whether they aresequenced by DocumentType or Journal Code.Related to DocumentSequencing. (Crystal)
Set Up Financials/SupplyChain, Common Definitions,Document Sequencing,Journal Type Report
RUN_FIN0057
FIN0058Journal Codes
Displays the various JournalCodes defined on theJournal Codes page for aparticular SetID-JournalType combination. Includesdescriptions for each JournalCode, as well as SequenceRange and SequencingType information. Relatedto Document Sequencing.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Document Sequencing,Journal Code Report
RUN_FIN0058
FIN0059Document Types
Displays the variousDocument Types definedon the Document Typepage for a particularSetID-Journal Type-JournalCode combination.Includes descriptions foreach Document Type, aswell as Sequence Rangeand Sequencing Typeinformation. Related toDocument Sequencing.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Document Sequencing,Document Type Report
RUN_FIN0059
Copyright © 2009, Oracle and/or its affiliates. All rights reserved. 7
Application Fundamentals Reports Chapter 1
Report ID and ReportName
Description Navigation Run Control Page
FIN0060Document Sequence Ranges
Displays the detail range(s)defined on the DocumentSequence Range page for aspecified Sequence Range.(Crystal)
Set Up Financials/SupplyChain, Common Definitions,Document Sequencing,Sequence Range Report
RUN_FIN0060
FIN0061ChartField Attribute Report
This report lists all or aselected list of ChartFieldsand their associatedattributes, attributedescriptions, and attributevalues. (SQR)
Setup Financials/SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Attributes
RUN_FIN0061
FIN1001Message Log Report
Prints message logs for aprocess instance ID and batchreport type, similar to theonline query available foreach background program.Displays job ID, programname, date, time, sequencenumber, logged message, andexplanation for each processinstance ID. (SQR)
Background Processes, PrintProcess Report
RUN_FIN1001
FIN2001Journal Entry
Displays all journal entriesentered in the system fora business unit and ledgerwithin the date rangespecified. Prints the journalentries in ascending IDorder within the ledger andshows the journal date, thesource, whether a reversalentry was created, journalstatus, posted date (if any),and a description. For eachline included in the journalentry, lists the line numberof the entry, the accountnumber, a description,the department, product,and project ChartFieldvalues, and debit and creditdetail. Also prints statisticalinformation where includedin a journal entry. (SQR)
General Ledger, GeneralReports, Journal Entry Detail
RUN_FIN2001
8 Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Chapter 1 Application Fundamentals Reports
Report ID and ReportName
Description Navigation Run Control Page
FIN5001Reconciliation by SystemSource
This report consists ofdetailed subsystem and GLjournal transactions that areaggregated to the businessunit, subsystem source,ledger, account or alternateaccount, fiscal year andaccounting period level. Forexample, it lists the data atthe system source level, suchas AP, and then lists all theactivity for AP, includingwhat was posted and notposted, for one or moreselected ChartFields thatappear in the data that youloaded. (SQR)
General Ledger, GeneralReports, GL ReconciliationSubsystem, Reconciliationby System Srce (source)
RUN_FIN5001
FIN5005Reconciliation by ChartField
This report lists the databased on one or moreselected ChartFields thatappear in the data thatyou loaded. Each of thesubsystem amounts thatfall within the ChartFieldcombination is listed on thereport along with the totalamounts for the ChartFieldsand the related ledgers.(SQR)
General Ledger,General Reports, GLSubsystem Reconciliation,Reconciliation byChartFields
RUN_FIN5005
GLC1001Ledger Codes
List Ledger Codes withassociated Book Codeand provides description.(Crystal)
General Ledger, Ledgers,Ledger Codes Report
RUN_GLC1001
GLC4004Adjustment Types
By setID, displays currentactive Adjustment TypeChartField values. (Crystal)
Setup Financials /SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports,Adjustment Type
RUN_GLC4004
GLC4005Book Codes
By setID, displays currentactive Book Codes. (Crystal)
Setup Financials / SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, BookCode
RUN_GLC4005
GLC4006Balancing Groups
Display all Balancing Groupsand describes whether theyare active or inactive andshows the default balancinggroup. (Crystal)
Setup Financials /SupplyChain, Common Definitions,Design ChartFields, Reports,ChartField Reports, AccountBalancing Group
RUN_GLC4006
Copyright © 2009, Oracle and/or its affiliates. All rights reserved. 9
Application Fundamentals Reports Chapter 1
Report ID and ReportName
Description Navigation Run Control Page
GLC4007Journal Entry TemplateReport (Crystal)
Displays Journal EntryTemplates by the securityapplied that is available to auser. (Crystal)
If you have configuredChartFields, you might wantto use the GLX4007 report toavoid manual changes to thisCrystal report.
Setup Financials/SupplyChain, Common Definitions,Journals, Entry TemplateReport, Journal EntryTemplate Report, Run,Process Scheduler Request,and select Journal EntryTemplate
RUN_GLC4007
GLX4007Journal Entry TemplateReport (XML Publisher)
Crystal reports requiremanual changes whenthere are ChartFieldconfigurations.XMLPublisher reports donot require manual changesto support ChartFieldconfiguration and use thesame criteria as the Crystalreports.
Displays Journal EntryTemplates by the securityapplied that is available to auser. (XML Publisher)
Setup Financials/SupplyChain, Common Definitions,Journals, Entry TemplateReport, Journal EntryTemplate Report, Run,Process Scheduler Request,and select XMLP: JournalEntry Template
RUN_GLC4007
APY0006Tax Authorities Report
Displays tax authorities bysetID. For each tax authority,the authority code, name,effective date, percentage andChartField values appear.
Setup Financials/SupplyChain, Common Definitions,Sales and Use Tax,Authorities Report
RUN_APY0006
APY0007Tax Codes Report
Displays tax codes bysetID. For each tax code, adescription, tax type, VATreference, tax calculationinformation, taxing authority,effective date, and taxpercentage appear.
Setup Financials/SupplyChain, Common Definitions,Sales and Use Tax, CodesReport
RUN_APY0007
Managing ChartFields for ReportsThe following discusses how to:
• Use XMLP reports to support configured ChartFields.
• Select ChartFields for SQR reports.
10 Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Chapter 1 Application Fundamentals Reports
Using XMLP Reports to Support Configured ChartFieldsOracle XML Publisher (XMLP) technology is accessible from PeopleTools 8.50 PS Query and all PeopleTools8.50 based applications. This technology enables PeopleSoft Enterprise to deliver XML publisher reports tosupplement some Crystal reports, which require manual changes if you implement ChartField configuration.These XML publisher reports do not require manual changes to support ChartField configuration and usethe same criteria as the Crystal reports.
The following is a list of the reports that can be generated in both Crystal and XML formats:
• Valid Speed Types: Available as a FIN0007 Crystal or FSX0007 XML Publisher report.• Journal Entry Template: Available as a GLC4007 Crystal or GLX4007 XML Publisher report.• Regulatory Ledger Translation Error: Available as a FIN5101 Crystal or FSX5101 XML Publisher report.• Journal Entry Detail: Available as a GLC7501 Crystal or GLX7501 XML Publisher report.• Journal Entry Detail (separate debit and credit): Available as a GLC7502 Crystal or GLX7502 XML
Publisher report.• Budget Attributes: Available as a GLC8100 Crystal or GLX8100 XML Publisher report.• Associated Budgets: Available as a GLC8110 Crystal or GLX8110 XML Publisher report.• Budget Checking Batch Process Statuses: Available as a GLC8530 Crystal or GLX 8530 XML Publisher
report.• Activity Log Detail: Available as a GLC8570 Crystal or GLX8570 XML Publisher report.• Activity Log Summary: Available as a GLC8571 or GLX8571 XML Publisher report.
Note. The navigation to the Crystal and XMLPublisher reports listed above is included in this report lists forPeopleSoft Enterprise Application Reports and in the report lists for each of the applications.
The XML Publisher report templates are designed in Microsoft Word’s rich text format and contain the reportlayout and XML publisher tags (placeholders) that are associated with the XML input file elements.
The following are general formatting features:
• All elements are placed in tables to optimize exact placement and alignment when the template istransformed to the actual report format.
• XML publisher can split columns to multiple pages if the columns exceed one page.
However, the GL report templates are designed to display all of the columns for a row on one page inmost instances. There will be exceptions if some of the columns will be split on multiple pages. Forexample, if you have additional ChartFields. Multiple ChartFields will be grouped in a single columnto optimize horizontal space.
• Some of the reports use intelligent formatting to display ChartFields only where a value exists in a row.
• Intelligent formatting is also used on other data such as statistical amount and statistical code to optimizehorizontal spacing.
Selecting ChartFields for SQR ReportsThe ChartField Selection grid is used by many report request pages and enables you to select the ChartFieldsyou want to view for SQR based reports that print ChartField values.
To enter report selection criteria in the ChartField Selection Grid:
Copyright © 2009, Oracle and/or its affiliates. All rights reserved. 11
Application Fundamentals Reports Chapter 1
1. Enter the header selection criteria and click Refresh to populate the grid with rows for each ChartField.2. Click Include CF for the ChartFields that you want to include values for in the report.
PeopleSoft delivers reports with a fixed number of lines on the report heading. This number is determinedbased on the most common business practice. There is just enough space for a few ChartFields onthe heading and still retain enough space for detail lines on each page. If you elect to include moreChartFields, the report will not have enough space to print all ChartField headings. This results in reportheading and detail lines that overlay each other. If your circumstances require you to print more than theoptimum number of ChartField values, change the report to increase the report heading lines. Increasingthe number of ChartFields is a customization and is not supported by PeopleSoft.
3. (Optional) Use the Value field to enter ChartField values for the budgets on which you want to report.Leave blank to select all values for the ChartField. Some Commitment Control report request pagesinclude Value From and Value To fields to enable you to select ranges of ChartField values.
4. (Optional) Change the Sequence in which the ChartFields appears on the report.For example, if you are reporting by Account and Department and you select Account to be first in thesequence, the report displays budget rows as follows:
Account Department
60000 100
110
120
62000 100
110
130
The default sequence is alphabetical.
5. (Optional) Select Descr to include a description of the ChartField value.
6. (Optional) Select Subtotal to include a subtotal of all amounts for the ChartField.
For example, if you are reporting by Account and Department as in the above example, and you selectSubtotal for Account, the report displays a subtotal amount for each Account:
Account Department Amount
60000 100 1000
110 2000
120 1000
Subtotal 4000
62000 100 2000
12 Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Chapter 1 Application Fundamentals Reports
Account Department Amount
110 1000
130 3000
Subtotal 6000
Copyright © 2009, Oracle and/or its affiliates. All rights reserved. 13
Application Fundamentals Reports Chapter 1
14 Copyright © 2009, Oracle and/or its affiliates. All rights reserved.
Report ID: APY0003 Page No. 1PeopleSoft Accounts Payable
Run DateAP OPERATOR PROFILERun Time 4:48:35PM
9/23/2009
TEST#TESTOperator:
Voucher Processing AuthorityVendor Processing AuthorityDefault Values
Set ID: Authority to Enter: No Enter Vouchers Only in Groups: No
Business Unit: Authority to Approve: No Voucher Entry Limit: 0.00
Origin: Authority to Inactivate: No Manually Schedule Payments: No
Post Vouchers: No
Aaron BrownABROWNOperator:
Voucher Processing AuthorityVendor Processing AuthorityDefault Values
Set ID: SHARE Authority to Enter: No Enter Vouchers Only in Groups: No
Business Unit: US005 Authority to Approve: No Voucher Entry Limit: 0.00
Origin: Authority to Inactivate: No Manually Schedule Payments: No
Post Vouchers: No
Arthur EricksonAERICKSONOperator:
Voucher Processing AuthorityVendor Processing AuthorityDefault Values
Set ID: Authority to Enter: No Enter Vouchers Only in Groups: No
Business Unit: Authority to Approve: No Voucher Entry Limit: 0.00
Origin: Authority to Inactivate: No Manually Schedule Payments: No
Post Vouchers: No
Anton JamesAJAMESOperator:
Voucher Processing AuthorityVendor Processing AuthorityDefault Values
Set ID: SHARE Authority to Enter: No Enter Vouchers Only in Groups: No
Business Unit: US001 Authority to Approve: No Voucher Entry Limit: 0.00
Origin: Authority to Inactivate: No Manually Schedule Payments: No
Post Vouchers: No
Report ID: APY0006 Page No. 1PeopleSoft Accounts Payable
Run DateTAX AUTHORITIES
Run Time
Set ID: SHARE
As Of Date: 23.Sep.2009
9/23/2009
4:53:24 PM
Effective DateName PercentAuthority
AL Alameda County (CA) Tax 01.Jan.1900 2.500
Alt Account Operating Unit Fund Code Program Code Class Field Budget Ref Affiliate Affiliate Intra 1
204005
Account Dept ID Product Project ID
Effective DateName PercentAuthority
AU1 Australian GST Standard Rate 01.Jan.1900 10.000
Alt Account Operating Unit Fund Code Program Code Class Field Budget Ref Affiliate Affiliate Intra 1Account Dept ID Product Project ID
Effective DateName PercentAuthority
AU2 Australian GST Nil Rate 01.Jan.1900 0.000
Alt Account Operating Unit Fund Code Program Code Class Field Budget Ref Affiliate Affiliate Intra 1Account Dept ID Product Project ID
Effective DateName PercentAuthority
BCT British Columbia Prov Sales Tx 01.Jan.1900 7.000
Alt Account Operating Unit Fund Code Program Code Class Field Budget Ref Affiliate Affiliate Intra 1
204000
Account Dept ID Product Project ID
Effective DateName PercentAuthority
BL1 Belgium - Tax at 21.00 % 01.Jan.1900 21.000
Alt Account Operating Unit Fund Code Program Code Class Field Budget Ref Affiliate Affiliate Intra 1Account Dept ID Product Project ID
Effective DateName PercentAuthority
BL2 Belgium - Tax at 12.00 % 01.Jan.1900 12.000
Alt Account Operating Unit Fund Code Program Code Class Field Budget Ref Affiliate Affiliate Intra 1Account Dept ID Product Project ID
Effective DateName PercentAuthority
BL3 Belgium - Tax at 6.00 % 01.Jan.1900 6.000
Alt Account Operating Unit Fund Code Program Code Class Field Budget Ref Affiliate Affiliate Intra 1Account Dept ID Product Project ID
�������� �� ���� �������� ����������������������������
����������� !"�
�����#$� �%&%�&��'
����� �(��"
���!����� ��)*��*+��&
�������������� �������
���������� ������������������� ����� ������
��*��*+��&
��� ������������������
��� ����� ������������� !� !�"�������� ��� ����������#��$���� %��&'(&()'' �*+,''!� !�
�+�,����������-���������.��� �/���0 �
�-( �-(���������."��"�������/�� !� !���� ���������."��"�������/�� %��&'(&()'' �('+'''!� !�
���������������-���������.��� �/���1��
�-* �-*���������."��0����/�� !� !���� ���������."��!��/�� %��&'(&()'' �'+'''!� !�
��������������-���������.��� �/���1+�
1�� 1��1�������� 2�������"������� !� !�"�������� 1�������� 2�������"������� %��&'(&()'' �3+'''!� !�
��������������-���������.��� �/��2 ��
1�( 1�(1���4��������!�� �� !� !���� 1���� �5�������*(+''�6 %��&'(&()'' �*(+'''!� !�
�+�������������-���������.��� �/��20��
1�* 1�*1���4������������� !� !���� 1���� �5�������(*+''�6 %��&'(&()'' �(*+'''!� !�
��+������������-���������.��� �/��20+�
1�7 1�71���4��������/��� !� !���� 1���� �5�������8+''�6 %��&'(&()'' �8+'''!� !�
�3������������-���������.��� �/��20&�
1�9 1�91���4���"������������&��� !� !���� 1���� �5���������� %��&'(&()'' �'+'''!� !�
��������������-���������.��� �/��20%�
1:" ��1����;����"�������� !� <��"�������� ������������"������ %��&'(&()'' �,+'''!� !�
�,������������-���������.��� �/��2!��
APY0012Report ID: Page No. 1PeopleSoft Accounts Payable
Run DateACCOUNTING ENTRY TEMPLATE
Run Time
SHARESet ID: CORPORATE SETID
As Of Date: 23.Sep.2009
9/23/2009
5:00:09 PM
ALTERNATE Alternate Template 01.Jan.1900
Type Description
Account Dept Product Project
Accounting Entry Template Effective Date
Alt Account Operating Unit Fund Code Program Code Class Field Budget Ref Affiliate Affiliate Intra 1
Accounts Payable
200000
APA
AR Rebate Control
120006
ARR
Cash Distribution
100001
CAS
Discount Earned
673100 10200
DSE
Discount Earned Memo
673110 10200
DSE
Discount Lost
673200 10200
DSL
Discount Lost Memo
673120
DSL
Escheatment Liability
205100
ESC
Expenses Accrual
207000
EXA
Expenses Period End Accruals
207000
EXB
Employee Advances
120500
EXV
Freight Expense
635000 ALL_DEPTS
FRG
Late Interest Charges
670100
LAT
Letter of credit payable
200000
LCP
Miscellaneous Charge Expense
655000 ALL_DEPTS
MIS
ProCard Accrual
208000
PCA
Prepaid Airfare
122001
PPA
Prepaid Expense
122000
PPD
Prepaid Hotel
122002
PPH
Receipt Accrual
212000
RAC
���������
��� ����
�������
������ ����� �������� �
�������� �
������� �����������
������ � ��������!�"���#���$���� ��������������%
����������� ��������� ������ �
������������ ������
��������
��� !����"#$�%���&�������������� �
��� !����"#$�%���&������� ���'�����
��� !�� �$������ �(�� ���))������������� �
� �����������������
�$�*�$���������
�$�*�$���������
�$�*�$������������� �
�$�*�$����� ������
�$�*�$������ ���'�����
�$�*�$���� �����
� �+������� ���'�����
�"�,-� �������� ������
�"�&������� ���'�����
����� ���������� ������ ������������ ������
� ��������� �
��)� �� �.����(����$��/�$�����0 �
��*$�"
���
�����'1�20��$���� �������'�
�����31�20��$���� �������3�
�(����� �.����(����$���(0+#��
/��."
�4�
������1�20��$��� ��������
�����/51�20��$���� ������/5�
����3�'��/51�
20��$��� ����3�'��/5
�
����3�'��1�20��$���� ����3�'���
����3�'�/51�20��$���� ����3�'�/5�
�����3�/51�20��$���� �����3�/5�
��������'1�20��$���� ��������'�
�������/51�20��$���� ���������/5�
��������'1�20��$���� ��������'�
�������/51�20��$���� �������/5�
��)� �� �.����(����$����)� ���0 �
��!��6��0+#0 � �
�7�
���1�20��$���� ���'������
�(���������*$���"�� !��-�(%�� ��
�(%"��$� �#0(�
�8�
���9�������1��
���������
��� ����
�������
������ ����� �������� �
�������� �
������� �����������
������ � ��������!�"���#���$���� ��������������%
����� ���������� ������ ������������ ������
20��$������:����� ���'������
$��(���*$�";�(������ ��<�"������
�(0=�������������� ��3��
�(�����/��."����4�
�(0=������������� ����/��5�
��� �.���*$����� ��0(��'(0-#����>�
�����/5�
����3�'��/5�
����3�'�/5�
�����3�/5�
�������/5�
�����3�
�#�����������*$���"�� !��(%"��$�
�#0(�
����7�
��������'���������
��������/���� ������������
�����:����� ���'�������
�����:���� �������
���������� �
�#�������!�"������
??������3��'� �(�$���!�(
�#������-�(��"�4����
2�3�����""���2� �!�+� �
2�3�������
2�3���������� �
2�����������2�'�
������������ ����3����
���������� �5��
�������� �������� �5��
���������3��?�/���
�����5��������� ��������
����� ���/��
��� � ���/��
� ��� �@��A�
��� ��� ������ ����
��/����� ����'������/���������%�*$�"
��/�����/����� ����'�� ��
�������'��0 �(���"
���������
��� ����
�������
������ ����� �������� �
�������� �
������� �����������
������ � ��������!�"���#���$���� ��������������%
����� ���������� ������ ������������ ������
�3���'� �'� �(�$���!�(
�3�����
������� �� ����
B�� ���/������
��'� �
�����'� ����
�����'� �������
�����'� �3��'����
��� �������'�
��'�??� �����
�2���'���/�� �� �0(%
���>>��� ���� ���� ����������(0=���"
���7�����A� ����� �B����
�#������(%"��$� �#0(�"�� ��
�-�(��"
�4����
�@���>��
�@���7��
������8��
2��4����""���2� �!�+� �
2'�����
�@��������%�*$�"
�@������
�@������
�@������
�@7�����
�@7��:��
�@8�:���
>������ ������*$�"
>������
3��� ���3�$$� !
�A��>�����<#� "�"
�A��>����
�A��>����
�A��>����
�A�47����
�A�47����
�A�>7����
�A�>7����
���>�����'� �(�$���!�(
'�4��8��
'�8>����
'�8>����
'�������
���������
��� ����
�������
������ ����� �������� �
�������� &
������� �����������
������ � ��������!�"���#���$���� ��������������%
����� ���������� ������ ������������ ������
'�������'� �(�$���!�(
'��>8���
'��>8���
��@��>����-(���"� !
��@>�����
��@>�>���
��@>�7���
�����>7���(��"-(%
�#�����##$�����0 �� !� ��
��0#$��0��
�>����
����� ����C��������'3��)�-$���
�9��������C���� �:C� �<��-��
��(0=���"
�#�����##�� !� ������*=���"�>����
����� ��������������2���������(0=���"
����� ���������������� ������
����� ������������������ �����
����� ������������������ �����
����� ������������������ �:���
����� ������������������ �:���
����� ������������������������
����� �����������������������
����� �����������������������
�0#%�2�� ��C",���0�%0-(�
�� �)0$��(
�8��:�
�
�#�����2�""���� !����+#$���"������
�23�����������(��(�2� �!�+� �
�23�����������
�23�����������
�23�����������
�23���������:�
�23����������
�23��������:�
�23��������4�
�23��������>�
�23��������7�
�23����������
�23����������
�23��������3�
�2��:�
�22 ?����
���������
��� ����
�������
������ ����� �������� �
�������� '
������� �����������
������ � ��������!�"���#���$���� ��������������%
����� ���������� ������ ������������ ������
�22 ?�����(��(�2� �!�+� �
�22 ?��4�
�2 3����������
�#�����2�""���� !���%#�"������
�������#���$�&��� �0��0+#0"����""���2� �!�+� �
�����B�����#���$�&���0+#0"����
�#�������$���(��� /�"�0 ��%0-�"����:�
�����'� �(�$���!�(
'�/������3��
'�/��������
� ������
� ��������3��
� ����������
�/�����
�#�����2�""�!����)� ���0 "����4�
��23���������� ��@�'� �(�$���!�(
���2��@���� �� �0(%
� ��������������
� �����������@���
� ���������@���
2����
�#�������$���%0-�"����>�
'�����2�� ��
B ����
��'� �
��'� ��3�
��'� ��3�2���
��������2�'�
��/����� ��������%�*$�"
���2��/�� ����
/�� ������A����
/���� �������A����
/���� ����
/�� ������/5�
3���'���/������������3�$$� !
'��A��B ��'� �(�$���!�(
'�B ���2�� ��
B �����3��3�
??�3��'���B ���2�� ��
��'� ��3�����
���������
��� ����
�������
������ ����� �������� �
�������� (
������� �����������
������ � ��������!�"���#���$���� ��������������%
����� ���������� ������ ������������ ������
��'� ��3�@���'� �(�$���!�(
��'� � ���/��
�2����'������ �� �0(%
�2�������B�
���� ��������
���� �������
2� ��� ���/�
�����������/�
� ����������/�
� �B�������2���(0=���"
� �B�����2������2��
���2�� �����������-(���"� !
�� ����� ��������������
�� ������2��� �
�� ������2�3��
�#������0+#0 � ��� ��()���"����8�
�����������@�����""���2� �!�+� �
�A����� ��@������%�*$�"
����������2���� ������*$�"
���� ���������(���!����0-(�� !
����/����� �������
������� �������0 �(���"
����������������
�A��@�����������<#� "�"
����� �������
����A������ ��� ��
����A������ ��� ������
����A�������@�������
����A���@���' �����
������ ������
���� ���� '�
�����2����� @�
�����2����� @�����
3�'���� ��5����@�'� �(�$���!�(
3�'���� ������@�
'2���� ���'(� �"�2� �!�+� �
���2�����2�A��� �� �0(%
���3��'����������(0=���"
��� ���������
� �B������'� ���� ����
���5��������'��������-(���"� !
���5��������'� ��������������
� ��A�� ��������������(��"-(%
���������
��� ����
�������
������ ����� �������� �
�������� )
������� �����������
������ � ��������!�"���#���$���� ��������������%
����� ���������� ������ ������������ ������
� �������'�������������(��"-(%
2�(D����0 "��0+#$����0 �
�0 )�!-(���0 �����-"�#�!�
�9�����
�
01/01/1999 USD ADP 165.70769092 1.00000000 01/01/1999 ADP USD 1.00000000 165.70769092 *
01/01/1999 USD AED 4.00134343 1.00000000 01/01/1999 AED USD 1.00000000 4.00134343 *
01/01/1999 USD AFA 5,174.62055000 1.00000000 01/01/1999 AFA USD 1.00000000 5,174.62055000 *
01/01/1999 USD ALL 171.85187195 1.00000000 01/01/1999 ALL USD 1.00000000 171.85187195 *
01/01/1999 USD ANG 1.93639748 1.00000000 01/01/1999 ANG USD 1.00000000 1.93639748 *
01/01/1999 USD ATS 13.76030000 1.15270000 01/01/1999 ATS USD 1.15270000 13.76030000 *
01/01/1999 USD AUD 1.00000000 0.75702549 01/01/1999 AUD USD 0.75702549 1.00000000 *
01/01/1999 USD BBD 2.19077093 1.00000000 01/01/1999 BBD USD 1.00000000 2.19077093 *
01/01/1999 USD BDT 49.95959967 1.00000000 01/01/1999 BDT USD 1.00000000 49.95959967 *
01/01/1999 USD BEF 40.33990000 1.15270000 01/01/1999 BEF USD 1.15270000 40.33990000 *
01/01/1999 USD BGL 1,953.41086820 1.00000000 01/01/1999 BGL USD 1.00000000 1,953.41086820 *
01/01/1999 USD BHD 0.41070146 1.00000000 01/01/1999 BHD USD 1.00000000 0.41070146 *
01/01/1999 USD BMD 1.08939380 1.00000000 01/01/1999 BMD USD 1.00000000 1.08939380 *
01/01/1999 USD BND 1.74303008 1.00000000 01/01/1999 BND USD 1.00000000 1.74303008 *
01/01/1999 USD BRR 1.56197283 1.00000000 01/01/1999 BRR USD 1.00000000 1.56197283 *
01/01/1999 USD BTN 43.23793098 1.00000000 01/01/1999 BTN USD 1.00000000 43.23793098 *
01/01/1999 USD BZD 2.17878760 1.00000000 01/01/1999 BZD USD 1.00000000 2.17878760 *
01/01/1999 USD CAD 1.27066886 1.00000000 01/01/1999 CAD USD 1.00000000 1.27066886 *
01/01/1999 USD CHF 1.65827524 1.00000000 01/01/1999 CHF USD 1.00000000 1.65827524 *
01/01/1999 USD CLP 491.97024008 1.00000000 01/01/1999 CLP USD 1.00000000 491.97024008 *
01/01/1999 USD CNY 9.02018066 1.00000000 01/01/1999 CNY USD 1.00000000 9.02018066 *
01/01/1999 USD COP 1,475.69284148 1.00000000 01/01/1999 COP USD 1.00000000 1,475.69284148 *
01/01/1999 USD CRC 273.56857106 1.00000000 01/01/1999 CRC USD 1.00000000 273.56857106 *
01/01/1999 USD CUP 25.05605740 1.00000000 01/01/1999 CUP USD 1.00000000 25.05605740 *
01/01/1999 USD CVE 106.70067574 1.00000000 01/01/1999 CVE USD 1.00000000 106.70067574 *
01/01/1999 USD CYP 0.57258538 1.00000000 01/01/1999 CYP USD 1.00000000 0.57258538 *
01/01/1999 USD DEM 1.95583000 1.15270000 01/01/1999 DEM USD 1.15270000 1.95583000 *
01/01/1999 USD DJF 176.48179560 1.00000000 01/01/1999 DJF USD 1.00000000 176.48179560 *
01/01/1999 USD DKK 7.48086722 1.00000000 01/01/1999 DKK USD 1.00000000 7.48086722 *
01/01/1999 USD DOP 16.12302824 1.00000000 01/01/1999 DOP USD 1.00000000 16.12302824 *
01/01/1999 USD DZD 63.75513805 1.00000000 01/01/1999 DZD USD 1.00000000 63.75513805 *
01/01/1999 USD ECS 5,474.20384500 1.00000000 01/01/1999 ECS USD 1.00000000 5,474.20384500 *
01/01/1999 USD EGP 3.70720710 1.00000000 01/01/1999 EGP USD 1.00000000 3.70720710 *
01/01/1999 USD ESP 166.38600000 1.15270000 01/01/1999 ESP USD 1.15270000 166.38600000 *
01/01/1999 USD ETB 7.45308768 1.00000000 01/01/1999 ETB USD 1.00000000 7.45308768 *
01/01/1999 USD EUR 1.00000000 1.15270000 01/01/1999 EUR USD 1.15270000 1.00000000 *
01/01/1999 USD FIM 5.94573000 1.15270000 01/01/1999 FIM USD 1.15270000 5.94573000 *
PeopleSoft
Report ID: EO9030 CROSS/RECIPROCAL RATE CALCULATION Page No. 1
Run Date 09/23/2009
Run Time 17:02:16
Common From Currency: USD Process Instance: 9969
Rate Type: AVG Update previous Rate: N
Rate Effective Date: 09/23/2009
Term: 0.00
Market Rate Index: MODEL * denotes rates not updated, update flag=N
Reciprocal Common: Y
<-------------------- Original Rate --------------------> <---------------------- Reciprocal --------------------->
EffDt From To Rate Mult Rate Div EffDt From To Rate Mult Rate Div
Report ID: Page No. 1PeopleSoft FinancialsFIN0001
Run Date 9/23/2009INSTALLATION OPTIONS
Run Time 5:06:04PM
PeopleSoft Products
Y
Y
Asset Management:
Order Management:
Y
Billing:
Payables:
Y
Y
General Ledger:
Purchasing:
Y YInventory: Receivables:
USADefault Address Country:
Overall Options
165Last Journal ID Assigned:
Manufacturing:
Product Configurator:
Y
Y
Tax Vendor: None
Item Approval Required:
Item Approval Method:
NSubCustomer Usage: Use Both SubCustomer Fields
Bank Reconciliation Level: All Business Units
YTreasury:
YQuality:
eBill Payment:
YExpenses:
Y
eSupplier Connection:
YEnable Document Sequencing:
Create Multibook Accounting
Entries in Subsystems:
YGrants Management:
Document Approval Required:
Enable Document Tolerance:
Enable Realtime D&B Access:
Project Costing: Y
Entry Event Options
General Ledger:
Payables:
Purchasing:
Receivables:
Billing:
No EE
Optional
Optional
Optional
Optional
Catalog Management:
Y
Y
Collaborative Supply Management:
Contracts:
Currency Conversion Utility:
Y
Y
Y
Deal Management: Y
Strategic Sourcing:
Engineering:
Y
Y
eProcurement: Y
Financials Portal Pack:
Y
Y
Human Capital Management:
Implementation Toolkit: N
Inventory Planning: Y
eSettlements: Y
Pay/Bill Management: Y
Promotions Management:
Proposal Management:
Y
Y
Resource Management:
Risk Management:
Y
Y
Services Procurement:
Supply Chain Portal Pack:
Y
Y
Supply Planning:
NTrading Partner Management:
Y
Expired Year Funding Adjustment:
Last VAT Authority Number:
Enable Alternate Account:
InterUnit Method:
Process Partition for GL:
ChartField:
Maximum Response Number:
Y
ESA Portal Pack Y
YFlow Production:
Program Management: Y
Transaction Billing Processor: Y
Lease Administration:
Work Order Management: Y
Y
N
N 0
0
Y
Y
N
FUND_CODE
Direct
Y
Use Legal Entity for InterUnit:
InterUnit Summarization Option: No Summarization
Y
Commitment Control
Billing:
Expenses:
General Ledger:
Grants Management:
Inventory:
Payables:
Project Costing:
Purchasing:
Receivables:
Procurement Card:
Y
Y
Y
Y
Y
Y
N
Y
Y
Y
Staffing Front Office: Y
N
Default Budget Date:
Reversal Date Option:
BP Liquidation Option:
Funding Source Activate Date:
Funding Source Activate Char1:
Funding Source Activate Char2:
Execute on Server:
Run Control Prefix:
On-Line Budget Checking Optio
Last Process Instance:
Maximum Waut Time (minutes)
Pop up Error/Warning Message:
Char1 Label:
Date Label:
Char2 Label:
Accounting Date Default
Current Date
Current Document Budget Period
N
N
N
BP
4263
6
Y
Supplier Contract Management:
Y
Demantra Y
End of Report
Report ID: Page No. 1PeopleSoft FinancialsFIN0002
Run Date 9/23/2009DETAIL CALENDARS
Run Time 5:07:15PM
Set ID: SHARE
Calendar: 01
Name: Monthly
Year Period Beginning Ending Period Name Abbrev
1957 1 01.Jan.1957 31.Jan.1957 January Jan
1957 2 01.Feb.1957 28.Feb.1957 February Feb
1957 3 01.Mar.1957 31.Mar.1957 March Mar
1957 4 01.Apr.1957 30.Apr.1957 April Apr
1957 5 01.May.1957 31.May.1957 May May
1957 6 01.Jun.1957 30.Jun.1957 June Jun
1957 7 01.Jul.1957 31.Jul.1957 July Jul
1957 8 01.Aug.1957 31.Aug.1957 August Aug
1957 9 01.Sep.1957 30.Sep.1957 September Sep
1957 10 01.Oct.1957 31.Oct.1957 October Oct
1957 11 01.Nov.1957 30.Nov.1957 November Nov
1957 12 01.Dec.1957 31.Dec.1957 December Dec
1958 1 01.Jan.1958 31.Jan.1958 January Jan
1958 2 01.Feb.1958 28.Feb.1958 February Feb
1958 3 01.Mar.1958 31.Mar.1958 March Mar
1958 4 01.Apr.1958 30.Apr.1958 April Apr
1958 5 01.May.1958 31.May.1958 May May
1958 6 01.Jun.1958 30.Jun.1958 June Jun
1958 7 01.Jul.1958 31.Jul.1958 July Jul
1958 8 01.Aug.1958 31.Aug.1958 August Aug
1958 9 01.Sep.1958 30.Sep.1958 September Sep
1958 10 01.Oct.1958 31.Oct.1958 October Oct
1958 11 01.Nov.1958 30.Nov.1958 November Nov
1958 12 01.Dec.1958 31.Dec.1958 December Dec
1959 1 01.Jan.1959 31.Jan.1959 January Jan
1959 2 01.Feb.1959 28.Feb.1959 February Feb
1959 3 01.Mar.1959 31.Mar.1959 March Mar
1959 4 01.Apr.1959 30.Apr.1959 April Apr
1959 5 01.May.1959 31.May.1959 May May
1959 6 01.Jun.1959 30.Jun.1959 June Jun
1959 7 01.Jul.1959 31.Jul.1959 July Jul
1959 8 01.Aug.1959 31.Aug.1959 August Aug
1959 9 01.Sep.1959 30.Sep.1959 September Sep
1959 10 01.Oct.1959 31.Oct.1959 October Oct
1959 11 01.Nov.1959 30.Nov.1959 November Nov
1959 12 01.Dec.1959 31.Dec.1959 December Dec
1960 1 01.Jan.1960 31.Jan.1960 January Jan
1960 2 01.Feb.1960 29.Feb.1960 February Feb
1960 3 01.Mar.1960 31.Mar.1960 March Mar
1960 4 01.Apr.1960 30.Apr.1960 April Apr
1960 5 01.May.1960 31.May.1960 May May
1960 6 01.Jun.1960 30.Jun.1960 June Jun
1960 7 01.Jul.1960 31.Jul.1960 July Jul
1960 8 01.Aug.1960 31.Aug.1960 August Aug
1960 9 01.Sep.1960 30.Sep.1960 September Sep
1960 10 01.Oct.1960 31.Oct.1960 October Oct
1960 11 01.Nov.1960 30.Nov.1960 November Nov
1960 12 01.Dec.1960 31.Dec.1960 December Dec
Report ID: Page No. 24PeopleSoft FinancialsFIN0002
Run Date 9/23/2009DETAIL CALENDARS
Run Time 5:07:15PM
Set ID: SHARE
Calendar: 01
Name: Monthly
Year Period Beginning Ending Period Name Abbrev
2049 1 01.Jan.2049 31.Jan.2049 Period 1 - 2049-01-01 1
2049 2 01.Feb.2049 28.Feb.2049 Period 2 - 2049-02-01 2
2049 3 01.Mar.2049 31.Mar.2049 Period 3 - 2049-03-01 3
2049 4 01.Apr.2049 30.Apr.2049 Period 4 - 2049-04-01 4
2049 5 01.May.2049 31.May.2049 Period 5 - 2049-05-01 5
2049 6 01.Jun.2049 30.Jun.2049 Period 6 - 2049-06-01 6
2049 7 01.Jul.2049 31.Jul.2049 Period 7 - 2049-07-01 7
2049 8 01.Aug.2049 31.Aug.2049 Period 8 - 2049-08-01 8
2049 9 01.Sep.2049 30.Sep.2049 Period 9 - 2049-09-01 9
2049 10 01.Oct.2049 31.Oct.2049 Period 10 - 2049-10-01 10
2049 11 01.Nov.2049 30.Nov.2049 Period 11 - 2049-11-01 11
2049 12 01.Dec.2049 31.Dec.2049 Period 12 - 2049-12-01 12
2050 1 01.Jan.2050 31.Jan.2050 Period 1 - 2050-01-01 1
2050 2 01.Feb.2050 28.Feb.2050 Period 2 - 2050-02-01 2
2050 3 01.Mar.2050 31.Mar.2050 Period 3 - 2050-03-01 3
2050 4 01.Apr.2050 30.Apr.2050 Period 4 - 2050-04-01 4
2050 5 01.May.2050 31.May.2050 Period 5 - 2050-05-01 5
2050 6 01.Jun.2050 30.Jun.2050 Period 6 - 2050-06-01 6
2050 7 01.Jul.2050 31.Jul.2050 Period 7 - 2050-07-01 7
2050 8 01.Aug.2050 31.Aug.2050 Period 8 - 2050-08-01 8
2050 9 01.Sep.2050 30.Sep.2050 Period 9 - 2050-09-01 9
2050 10 01.Oct.2050 31.Oct.2050 Period 10 - 2050-10-01 10
2050 11 01.Nov.2050 30.Nov.2050 Period 11 - 2050-11-01 11
2050 12 01.Dec.2050 31.Dec.2050 Period 12 - 2050-12-01 12
End of Report
Report ID: FIN0003 PeopleSoft Financials 1Page No.
9/23/2009Run DateTIMESPANS
5:07:20PMRun Time
Set ID: SHARE
Balance Closing------Start Year-------- ------Start Period------- -------End Year------- -------End Period--------
TimeSpan Description Type Year Type Period Type Year Type Period Calendar ID Forward Adjustments
ADJALLYR Adjusted Year-End P&L Totals 0 Absolute 1 Relative 01Absolute No Yes 0 12Relative
ADJALLYR-1 Adj. Last Year-End P&L Totals -1 Absolute 1 Relative 01Absolute No Yes-1 12Relative
ADJBAL Adjusted Year-End Balances 0 Absolute 1 Relative 01Absolute Yes No 0 12Relative
ADJBAL-1YR Adjusted Year End Bal Last Yr -1 Absolute 1 Relative 01Absolute Yes Yes-1 12Relative
ALLYEAR Entire Year Through Period 12 0 Absolute 1 Relative 01Absolute No No 0 12Relative
ALLYEAR+1 Periods 1 -12 Next Year 1 Absolute 1 Relative 01Absolute No No 1 12Relative
ALLYEAR+2 Periods 1 -12 + TWO YEARS 2 Absolute 1 Relative 01Absolute No No 2 12Relative
ALLYEAR+3 All Year + 3 Years 3 Absolute 1 Relative 01Absolute No No 3 12Relative
ALLYEAR-1 Entire Last Year Thru Per 12 -1 Absolute 1 Relative 01Absolute No No-1 12Relative
BAL Current Balance (BS Accounts) 0 Absolute 1 Relative 01Relative Yes No 0 0Relative
BAL-1YR Current Balance Last Year -1 Absolute 1 Relative 01Relative Yes No-1 0Relative
BAL-2YR Current Balance Two Years Ago -2 Absolute 1 Relative 01Relative Yes No-2 0Relative
BAL-3YR Current Balance 3 Years Ago -3 Absolute 1 Relative 01Relative Yes No-3 0Relative
BAL-4YR Current Balance Four Years Ago -4 Absolute 1 Relative 01Relative Yes No-4 0Relative
BAL-5YR Current Balance Five Years Ago -5 Absolute 1 Relative 01Relative Yes No-5 0Relative
BEGBAL Beginning Balance 0 Absolute 1 Relative 01Relative Yes No 0 -1Relative
DAY_BAL Current Daily Balance 0 Absolute 1 Relative D1Relative Yes No 0 0Relative
DAY_BAL-1 Previous Day's Balances 0 Absolute 1 Relative D1Relative Yes No 0 -1Relative
FY_FULL One fiscal year 0 Absolute 1 Relative G1Absolute No No 0 12Relative
FY_FULL0 One fiscal year w/ Bal Forward 0 Absolute 1 Relative G1Absolute Yes No 0 12Relative
FY_FULLC One fiscal year w/ Adj Per 0 Absolute 1 Relative 01Absolute No No 0 12Relative
ITD Inception-To-Date (P&L Accts) 0 Absolute 1 Relative 01Relative Yes No 0 0Relative
NEXTYEAR Next Year 1 Absolute 1 Relative 01Absolute No No 1 12Relative
NEXTYEAR+1 Two Years Hence 2 Absolute 1 Relative Q1Absolute No No 2 4Relative
NEXTYEAR+2 Three Years Hence 3 Absolute 1 Relative A1Absolute No No 3 1Relative
PER Current Period Activity 0 Relative 0 Relative 01Relative No No 0 0Relative
PER+1 Next Period 0 Relative 1 Relative 01Relative No No 0 1Relative
PER+2 Two Periods Hence 0 Relative 2 Relative 01Relative No No 0 2Relative
PER-1 Prior Period 0 Relative -1 Relative 01Relative No No 0 -1Relative
PER-1YR Current Period Last Year -1 Relative 0 Relative 01Relative No No-1 0Relative
PER-2 Two Periods Ago 0 Relative -2 Relative 01Relative No No 0 -2Relative
PER0195 Period 01 of 1995 1995 Absolute 1 Absolute 01Absolute No No 1995 1Absolute
PER0199 Period 01 of 1999 1999 Absolute 1 Absolute 01Absolute No No 1999 1Absolute
PER1 Period 01 This Year 0 Absolute 1 Relative 01Absolute No No 0 1Relative
PER1+1YR Period 01 Next Year 1 Absolute 1 Relative 01Absolute No No 1 1Relative
PER1-1YR Period 01 Last Year -1 Absolute 1 Relative 01Absolute No No-1 1Relative
PER10 Period 10 This Year 0 Absolute 10 Relative 01Absolute No No 0 10Relative
PER10+1YR Period 10 Next Year 1 Absolute 10 Relative 01Absolute No No 1 10Relative
PER10-1YR Period 10 Last Year -1 Absolute 10 Relative 01Absolute No No-1 10Relative
PER11 Period 11 This Year 0 Absolute 11 Relative 01Absolute No No 0 11Relative
PER11+1YR Period 11 Next Year 1 Absolute 11 Relative 01Absolute No No 1 11Relative
PER11-1YR Period 11 Last Year -1 Absolute 11 Relative 01Relative No No-1 11Relative
PER12 Period 12 This Year 0 Absolute 12 Relative 01Absolute No No 0 12Relative
PER12+1YR Period 12 Next Year 1 Absolute 12 Relative 01Absolute No No 1 12Relative
PER12-1YR Period 12 Last Year -1 Absolute 12 Relative 01Absolute No No-1 12Relative
PER1295 Period 12 of 1995 1995 Absolute 12 Absolute 01Absolute No No 1995 12Absolute
PER2 Period 02 This Year 0 Absolute 2 Relative 01Absolute No No 0 2Relative
Report ID: FIN0003 PeopleSoft Financials 2Page No.
9/23/2009Run DateTIMESPANS
5:07:20PMRun Time
Set ID: SHARE
Balance Closing------Start Year-------- ------Start Period------- -------End Year------- -------End Period--------
TimeSpan Description Type Year Type Period Type Year Type Period Calendar ID Forward Adjustments
PER2+1YR Period 02 Next Year 1 Absolute 2 Relative 01Absolute No No 1 2Relative
PER2-1YR Period 02 Last Year -1 Absolute 2 Relative 01Absolute No No-1 2Relative
PER3 Period 03 This Year 0 Absolute 3 Relative 01Absolute No No 0 3Relative
PER3+1YR Period 03 Next Year 1 Absolute 3 Relative 01Absolute No No 1 3Relative
PER3-1YR Period 03 Last Year -1 Absolute 3 Relative 01Absolute No No-1 3Relative
PER4 Period 04 This Year 0 Absolute 4 Relative 01Absolute No No 0 4Relative
PER4+1YR Period 04 Next Year 1 Absolute 4 Relative 01Absolute No No 1 4Relative
PER4-1YR Period 04 Last Year -1 Absolute 4 Relative 01Absolute No No-1 4Relative
PER5 Period 05 This Year 0 Absolute 5 Relative 01Absolute No No 0 5Relative
PER5+1YR Period 05 Next Year 1 Absolute 5 Relative 01Absolute No No 1 5Relative
PER5-1YR Period 05 Last Year -1 Absolute 5 Relative 01Absolute No No-1 5Relative
PER6 Period 06 This Year 0 Absolute 6 Relative 01Absolute No No 0 6Relative
PER6+1YR Period 06 Next Year 1 Absolute 6 Relative 01Absolute No No 1 6Relative
PER6-1YR Period 06 Last Year -1 Absolute 6 Relative 01Absolute No No-1 6Relative
PER7 Period 07 this year 0 Absolute 7 Relative 01Absolute No No 0 7Relative
PER7+1YR Period 07 Next Year 1 Absolute 7 Relative 01Absolute No No 1 7Relative
PER7-1YR Period 07 Last Year -1 Absolute 7 Relative 01Absolute No No-1 7Relative
PER8 Period 08 This Year 0 Absolute 8 Relative 01Absolute No No 0 8Relative
PER8+1YR Period 08 Next Year 1 Absolute 8 Relative 01Absolute No No 1 8Relative
PER8-1YR Period 08 Last Year -1 Absolute 8 Relative 01Absolute No No-1 8Relative
PER9 Period 09 This Year 0 Absolute 9 Relative 01Absolute No No 0 9Relative
PER9+1YR Period 09 Next Year 1 Absolute 9 Relative 01Absolute No No 1 9Relative
PER9-1YR Period 09 Last Year -1 Absolute 9 Relative 01Absolute No No-1 9Relative
PERLASTYR Same period last year -1 Relative 0 Relative 01Relative No No-1 0Relative
PERNEXTYR Same period next year 1 Relative 0 Relative 01Relative No No 1 0Relative
PRIOR_YEAR Prior Year -1 Absolute 1 Relative G1Absolute No No-1 12Relative
PRIOR_YR0 Prior Year w/ Bal Forward -1 Absolute 1 Relative G1Absolute Yes No-1 12Relative
PRIOR_YRC Prior Year w/ Adj Periods -1 Absolute 1 Relative 01Absolute No No-1 12Relative
QTR1 First Quarter 0 Absolute 1 Relative 01Absolute No No 0 3Relative
QTR1+1YR Quarter 1 Next Year 1 Absolute 1 Relative Q1Absolute No No 1 1Relative
QTR1-1 First Quarter - Last Year -1 Absolute 1 Relative 01Absolute No No-1 3Relative
QTR2 Second Quarter 0 Absolute 4 Relative 01Absolute No No 0 6Relative
QTR2+1YR Quarter 2 Next Year 1 Absolute 2 Relative Q1Relative No No 1 2Relative
QTR2-1 Second Quarter - Last Year -1 Absolute 4 Relative 01Absolute No No-1 6Relative
QTR3 Third Quarter 0 Absolute 7 Relative 01Absolute No No 0 9Relative
QTR3+1YR Quarter 3 Next Year 1 Absolute 3 Relative Q1Relative No No 1 3Relative
QTR3-1 Third Quarter - Last Year -1 Absolute 7 Relative 01Absolute No No-1 9Relative
QTR4 Fourth Quarter 0 Absolute 10 Relative 01Absolute No No 0 12Relative
QTR4+1YR Quarter 4 Next Year 1 Absolute 4 Relative Q1Relative No No 1 4Relative
QTR4-1 Fourth Quarter - Last Year -1 Absolute 10 Relative 01Absolute No No-1 12Relative
RESTOFYEAR Rest of Current Year 0 Relative 1 Relative 01Absolute No No 0 12Relative
YEAR1 Year 1 -1 Absolute 1 Relative G1Absolute No No-1 12Relative
YEAR2 Year 2 0 Absolute 1 Relative G1Absolute No No 0 12Relative
YEAR2_CUM Year 2 Cumulative -5 Absolute 1 Relative G1Absolute No No 1 12Relative
YTD Year-To-Date 0 Absolute 1 Relative 01Relative No No 0 0Relative
YTD-1YR Year-To-Date Last Year -1 Absolute 1 Relative 01Relative No No-1 0Relative
End of Report
Report ID: Page No. 1PeopleSoft FinancialsFIN0004
Run Date 9/23/2009ACCOUNT TYPES
Run Time 5:07:48PM
Set ID: SHARE
Short Description Balance ForwardLong DescriptionType
Asset YesAssetA
Expense NoExpenseE
Liability YesLiabilityL
Equity YesEquityQ
Revenue NoRevenueR
End of Report
Page No. 1PeopleSoft FinancialsFIN0005Report ID:
Run Date 9/23/2009STATISTICS UNITS OF MEASURE
Run Time 5:08:30PM
Convert ToDescriptionUnit of Measure Conversion Rate Inverse Rate
AVCAVC 1.00000000Average Cost Dollars 1.00000000
B15B15 1.00000000BAG 15 1.00000000
LBAB15 15.00000000BAG 15 0.06666667
LBSB15 14.99999925BAG 15 0.06666667
B25B25 1.00000000BAG 25 1.00000000
CSB25 0.25000000BAG 25 4.00000000
LBAB25 25.00000000BAG 25 0.04000000
LBSB25 25.00000000BAG 25 0.04000000
B50B50 1.00000000BAG 50 1.00000000
CSB50 0.50000000BAG 50 2.00000000
LBAB50 50.00000000BAG 50 0.02000000
LBSB50 50.00000000BAG 50 0.02000000
BBLBBL 1.00000000Barrel - Liquid Measure 1.00000000
GALBBL 31.50003150Barrel - Liquid Measure 0.03174600
BOXBOX 1.00000000Box 1.00000000
EABOX 4.00000000Box 0.25000000
BRLBRL 1.00000000BARREL 1.00000000
CANBRL 1.00000000BARREL 1.00000000
LBABRL 25.00000000BARREL 0.04000000
LBSBRL 25.00000000BARREL 0.04000000
BSDBSD 1.00000000Bushel - Dry Measure 1.00000000
CCMBSD 35248.50193867Bushel - Dry Measure 0.00002837
GALBSD 9.30925340Bushel - Dry Measure 0.10742000
CC 1.00000000Celsius 1.00000000
FC 1.00000000Celsius 1.00000000
BRLCAN 1.00000000CAN 1.00000000
CANCAN 1.00000000CAN 1.00000000
DRMCAN 0.25000000CAN 4.00000000
GALCAN 25.00000000CAN 0.04000000
LBSCAN 1.00000000CAN 1.00000000
BSDCCM 0.00002837Cubic Centimeters 35248.50193867
CCMCCM 1.00000000Cubic Centimeters 1.00000000
CMMCCM 1000.00000000Cubic Centimeters 0.00100000
CUFCCM 0.00003532Cubic Centimeters 28312.57078143
CUICCM 0.06102000Cubic Centimeters 16.38806949
CUMCCM 0.00000100Cubic Centimeters 1000000.00000000
CUYCCM 0.00000131Cubic Centimeters 763358.77862595
GALCCM 0.00026417Cubic Centimeters 3785.44119317
GLLCCM 0.00845000Cubic Centimeters 118.34319527
LCCM 0.00100000Cubic Centimeters 1000.00000000
PTDCCM 0.00182000Cubic Centimeters 549.45054945
PTLCCM 0.00211000Cubic Centimeters 473.93364929
QTDCCM 0.00091000Cubic Centimeters 1098.90109890
QTLCCM 0.00106000Cubic Centimeters 943.39622642
CDMCDM 1.00000000Cubic Decimeters 1.00000000
CGCG 1.00000000Centigrams 1.00000000
CHNCHN 1.00000000Chain 1.00000000
CLCL 1.00000000Centiliters 1.00000000
CMCM 1.00000000Centimeters 1.00000000
FTCM 0.03281000Centimeters 30.47851265
INCM 0.39370000Centimeters 2.54000508
KMCM 0.00001000Centimeters 100000.00000000
MCM 0.01000000Centimeters 100.00000000
MMCM 10.00000000Centimeters 0.10000000
YDCM 0.01094000Centimeters 91.40767824
CCMCMM 0.00100000Cubic Millimeters 1000.00000000
CMMCMM 1.00000000Cubic Millimeters 1.00000000
CUICMM 0.00006102Cubic Millimeters 16388.06948541
CUMCMM 0.76455000Cubic Millimeters 1.30795893
GALCMM 201.97400000Cubic Millimeters 0.00495113
LCMM 764.55490000Cubic Millimeters 0.00130795
QTDCMM 694.27900000Cubic Millimeters 0.00144034
QTLCMM 807.89600000Cubic Millimeters 0.00123778
CRTCRT 1.00000000CRATE 1.00000000
LBACRT 100.00000000CRATE 0.01000000
LBSCRT 100.00000000CRATE 0.01000000
SLVCRT 0.25000000CRATE 4.00000000
B25CS 4.00000000Case 0.25000000
Page No. 2PeopleSoft FinancialsFIN0005Report ID:
Run Date 9/23/2009STATISTICS UNITS OF MEASURE
Run Time 5:08:30PM
Convert ToDescriptionUnit of Measure Conversion Rate Inverse Rate
B50CS 2.00000000Case 0.50000000
CSCS 1.00000000Case 1.00000000
EACS 16.00000000Case 0.06250000
LBSCS 100.00000000Case 0.01000000
PLCS 0.00694444Case 144.00009216
CCMCUF 28312.57078143Cubic Feet 0.00003532
CUFCUF 1.00000000Cubic Feet 1.00000000
CUICUF 1727.11571675Cubic Feet 0.00057900
CUMCUF 0.02832000Cubic Feet 35.31073446
CUYCUF 0.03704000Cubic Feet 26.99784017
GALCUF 7.48055057Cubic Feet 0.13368000
LCUF 28.31687000Cubic Feet 0.03531464
PTDCUF 51.42810000Cubic Feet 0.01944462
PTLCUF 59.84420000Cubic Feet 0.01671006
CCMCUI 16.38806949Cubic Inches 0.06102000
CMMCUI 16388.06948541Cubic Inches 0.00006102
CUFCUI 0.00057900Cubic Inches 1727.11571675
CUICUI 1.00000000Cubic Inches 1.00000000
CUMCUI 0.00001639Cubic Inches 61012.81269067
CUYCUI 0.00002143Cubic Inches 46663.55576295
DRACUI 4.43290000Cubic Inches 0.22558596
GALCUI 0.00432900Cubic Inches 231.00023100
LCUI 0.01639000Cubic Inches 61.01281269
MLCUI 16.38710001Cubic Inches 0.06102361
PTDCUI 0.02976000Cubic Inches 33.60215054
PTLCUI 0.03463000Cubic Inches 28.87669651
QTDCUI 0.01488000Cubic Inches 67.20430108
QTLCUI 0.01732000Cubic Inches 57.73672055
CCMCUM 1000000.00000000Cubic Meters 0.00000100
CMMCUM 1.30795893Cubic Meters 0.76455000
CUFCUM 35.31073446Cubic Meters 0.02832000
CUICUM 61012.81269067Cubic Meters 0.00001639
CUMCUM 1.00000000Cubic Meters 1.00000000
CUYCUM 1.30795893Cubic Meters 0.76455000
GALCUM 264.20079260Cubic Meters 0.00378500
CCMCUY 763358.77862595Cubic Yards 0.00000131
CUFCUY 26.99784017Cubic Yards 0.03704000
CUICUY 46663.55576295Cubic Yards 0.00002143
CUMCUY 0.76455000Cubic Yards 1.30795893
CUYCUY 1.00000000Cubic Yards 1.00000000
GALCUY 202.02020202Cubic Yards 0.00495000
LCUY 764.55490000Cubic Yards 0.00130795
QTDCUY 694.27900000Cubic Yards 0.00144034
QTLCUY 807.89600000Cubic Yards 0.00123778
DAYDAY 1.00000000Days 1.00000000
MHRDAY 8.00000000Days 0.12500000
DGDG 1.00000000Decigrams 1.00000000
GDG 0.10000000Decigrams 10.00000000
DLDL 1.00000000Deciliters 1.00000000
DMDM 1.00000000Decimeters 1.00000000
DOZDOZ 1.00000000Dozen 1.00000000
GRSDOZ 0.08333333Dozen 12.00000048
UNTDOZ 12.00000000Dozen 0.08333333
CUIDRA 0.22558596Dram - Avoirdupois 4.43289999
DRADRA 1.00000000Dram - Avoirdupois 1.00000000
GDRA 1.77179305Dram - Avoirdupois 0.56440000
KGDRA 0.00177186Dram - Avoirdupois 564.37867552
LBSDRA 0.00390625Dram - Avoirdupois 256.00000000
MLDRA 3.69658436Dram - Avoirdupois 0.27052000
OZADRA 0.06250000Dram - Avoirdupois 16.00000000
CANDRM 4.00000000DRUM 0.25000000
DRMDRM 1.00000000DRUM 1.00000000
GALDRM 100.00000000DRUM 0.01000000
DRPDRP 1.00000000Dram - Apothecaries' 1.00000000
KGDRP 0.00388787Dram - Apothecaries' 257.21024623
LBSDRP 0.00857140Dram - Apothecaries' 116.66705556
OZADRP 0.13714223Dram - Apothecaries' 7.29170001
BOXEA 0.25000000Each 4.00000000
_______________________________________________________________________________________________________________________________________________________________________________
Operator ID: #TEST TEST Business Unit: SetID:
As of Date: 2009-08-14 Country: USA Alternate Character Enabled: N
_______________________________________________________________________________________________________________________________________________________________________________
Asset Management
General Ledger
Payables
Origin: Do Not Check Voucher Amount
Enter Groups: N Post Vouchers: N Schedule Payments: N Override Match: N
Receivables
Vendor Maintenance
Authority to Enter: N Authority to Approve: N Authority to Inactivate: N
OLE
_______________________________________________________________________________________________________________________________________________________________________________
Operator ID: ABROWN Aaron Brown Business Unit: US005 SetID: SHARE
As of Date: 2009-05-14 Country: USA Alternate Character Enabled: N
_______________________________________________________________________________________________________________________________________________________________________________
Asset Management
Field Drilldown Group Id:
Date Default Values Auto-Run Transaction Loader
Accounting Dt: Asset Management Integration: N
Transaction Dt: Impairment/Revaluation Process: Y
Edit Options for Interface Tables Property Pagelets
Edit Financial Information: None Business Unit:
Edit Phy A Information: None Space Unit of Measure:
Edit Phy B Information: None Property Class:
General Ledger
Ledger: Ledger Group: Source:
PeopleSoft Financials
Report ID: FIN0006 OPERATOR PREFERENCES Page No. 1
Run Date 09/23/2009
Run Time 17:08:50
Report ID: FIN0007 1Page No.PeopleSoft Financials
30.Oct.2001Run DateSPEEDTYPES5:00:21 PMRun Time
Set ID: SHARE
SpeedType Key Type Operator ID
Operator ClassDescription
Account Department Product
CurrencyAffiliate
Alternate Acc Operating Unit
Chartfield1 Chartfield2 Chartfield3 Affiliate Intra1 Affiliate Intra2 Stat Code
Fund Code Program Code Class Budget Ref
Project Id
DESKTOP Class
ALLPNLSCOGS Desktop Products
500000 21200 HARDWR
MTL-EXP-MG Class
ALLPNLSMisc Mtl Exp - Manufacturing
655000 42000
PERIPHERAL User VP1
COGS Peripheral Products
500000 21200 CONFIG
PREV Universal
Product Revenue
400000
QCASH Universal
Queens Bank Checking
100002
SCASH Universal
State Bank Checking
100001
SREV Universal
Service Revenue
401000
End of Report
_______________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________Source: ACC Accruals
Journal Options Balance: Recycle Edit Errors: Recycle Amount Error: Default
Control Total: Recycle Document Type: Default
Currency Options Base Adjust: Default to Higher Level Values Balancing: Default to Higher Level Values Curr. per Journal: Default
Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
_______________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________Source: ADJ Accounting Adjustments
Journal Options Balance: Recycle Edit Errors: Recycle Amount Error: Default
Control Total: Recycle Document Type: Default
Currency Options Base Adjust: Default to Higher Level Values Balancing: Default to Higher Level Values Curr. per Journal: Default
Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
_______________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________Source: ALO Allocation Process
Journal Options Balance: Recycle Edit Errors: Recycle Amount Error: Default
Control Total: Recycle Document Type: Default
Currency Options Base Adjust: Default to Higher Level Values Balancing: Default to Higher Level Values Curr. per Journal: Default
Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
_______________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________Source: AM Asset Management
Journal Options Balance: Recycle Edit Errors: Recycle Amount Error: Default
Control Total: Recycle Document Type: Default
Currency Options Base Adjust: Default to Higher Level Values Balancing: Default to Higher Level Values Curr. per Journal: Default
Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
_______________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________Source: AP Accounts Payable
Journal Options Balance: Recycle Edit Errors: Recycle Amount Error: Default
Control Total: Recycle Document Type: Default
Currency Options Base Adjust: Default to Higher Level Values Balancing: Default to Higher Level Values Curr. per Journal: Default
Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
_______________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________Source: AR Accounts Receivable
Journal Options Balance: Recycle Edit Errors: Recycle Amount Error: Default
Control Total: Recycle Document Type: Default
Currency Options Base Adjust: Default to Higher Level Values Balancing: Default to Higher Level Values Curr. per Journal: Default
Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
_______________________________________________________________________________________________________________________________________________________________________________
_______________________________________________________________________________________________________________________________________________________________________________Source: AV Student Adm/Student Adv
Journal Options Balance: Recycle Edit Errors: Recycle Amount Error: Default
Control Total: Recycle Document Type: Default
Currency Options Base Adjust: Disallow Base Currency Adjustment Balancing: Balance By All Currencies Curr. per Journal: Multiple
Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
_______________________________________________________________________________________________________________________________________________________________________________
PeopleSoft Financials
Report ID: FIN0008 JOURNAL SOURCES Page No. 1
Run Date 11/05/2001
Run Time 17:51:24
Report ID: FIN0010 Page No. 1PeopleSoft Financials
Run Date 09.Feb.2002VALID GENERAL LEDGER ACCOUNTSRun Time 2:29:33 PM
Set ID: SHARE
As Of Date: 09.Feb.2002
Monetary -------Statistical Account---------
Account TypeAccount Y/N UOM Edit FieldEdit RecordDescriptionY/NDescription Short Name Bal Forward
------------------------------------- Open Item Account -----------------------------
VAT
--A000000 No NoAll Accounts YAll Accts N
--A100000 No NoPetty Cash YPetty Cash N
--A100001 No NoUSBNK - Treasury Account YUSBNK-Trsr N
--A100002 No NoUSBNK - Disbursements Account YUBNK-Disb N
--A100003 No NoUSBNK - Collections Account YUSBNK -Col N
--A100004 No NoUSBNK - Payroll Account YUSBNK-PayR N
--A100006 No NoAUBNK - Treasury Account YAUBNK-Trsr N
--A100007 No NoAUBNK - Disbursements Account YAUBNK-Disb N
--A100008 No NoAUBNK - Collections Account YAUBNK- Col N
--A100009 No NoAUBNK - PayRoll Account YAUBNK-PayR N
--A100010 No NoUKBNK - Treasury Account YUKBNK-Trsr N
--A100011 No NoUKBNK - Disbursements Account YUKBNK-Disb N
--A100012 No NoUKBNK - Collections Account YUKBNK-Col N
--A100013 No NoUKBNK - Payroll Account YUKBNK-PayR N
--A100015 No NoBLBNK - Treasury Account YBLBNK-Trsr N
--A100016 No NoBLBNK - Disbursements Account YBLBNK-Disb N
--A100017 No NoBLBNK - Collections Account YBLBNK-Col N
--A100018 No NoBLBNK - Payroll Account YBLBNK-PayR N
--A100020 No NoSPBNK - Treasury Account YSPBNK-Trsr N
--A100021 No NoSPBNK - Disbursements Account YSPBNK-Disb N
--A100022 No NoSPBNK - Collections Account YSPBNK-Col N
--A100023 No NoSPBNK - Payroll Account YSPBNK-PayR N
--A100024 No NoCNBNK - Treasury Account YCNBNK-Trsr N
--A100025 No NoCNBNK - Disbursements Account YCNBNK-Disb N
--A100026 No NoCNBNK - Collections Account YCNBNK-Col N
--A100027 No NoCNBNK - Payroll Account YCNBNK-PayR N
--A100028 No NoGMBNK - Treasury Account YGMBNK-Trsr N
--A100029 No NoGMBNK - Disbursements Account YGMBNK-Disb N
--A100030 No NoGMBNK - Collections Account YGMBNK-Col N
--A100031 No NoGMBNK - Payroll Account YGMBNK-PayR N
--A100032 No NoFRBNK - Treasury Account YFRBNK-Trsr N
--A100033 No NoFRBNK - Disbursement Account YFRBNK-Disb N
--A100034 No NoFRBNK - Collections Account YFRBNK-Col N
--A100035 No NoFRBNK - Payroll Account YFRBNK-PayR N
Report ID: FIN0010 Page No. 2PeopleSoft Financials
Run Date 09.Feb.2002VALID GENERAL LEDGER ACCOUNTSRun Time 2:29:33 PM
Set ID: SHARE
As Of Date: 09.Feb.2002
Monetary -------Statistical Account---------
Account TypeAccount Y/N UOM Edit FieldEdit RecordDescriptionY/NDescription Short Name Bal Forward
------------------------------------- Open Item Account -----------------------------
VAT
--A100036 No NoJPBNK - Treasury Account YJPBNK-Trsr N
--A100037 No NoJPBNK - Disbursements Account YJPBNK-Disb N
--A100038 No NoJPBNK - Collections Account YJPBNK-Col N
--A100039 No NoJPBNK - Payroll Account YJPBNK-PayR N
--A100040 No NoNDBNK - Treasury Account YNDBNK-Trsr N
--A100041 No NoNDBNK - Disbursements Account YNDBNK-Disb N
--A100042 No NoNDBNK - Collections Account YNDBNK-Col N
--A100043 No NoNDBNK - Payroll Account YNDBNK-PayR N
--A100044 No NoTRBNK - Treasury Account YTRBNK-Trsr N
--A100045 No NoTRBNK - Disbursements Account YTRBNK-Disb N
--A100046 No NoTRBNK - Collections Account YTRBNK-Col N
--A100047 No NoTRBNK - Payroll Account YTRBNK-PayR N
--A100048 No NoNetting Bank Account YNettingBnk N
--A100050 No NoRemitted AR Draft YRmt AR N
--A100060 No NoDiscounted AR Draft YDisc AR N
--A100090 No NoTravelers Checks On-hand YTrav Check N
--A100100 No NoDue From - All YDue From - N
--A100103 No NoDue From - US001 YDue From - N
--A100105 No NoDue From - US003 YDue From - N
--A100106 No NoDue From - US004 YDue From - N
--A100107 No NoDue From - US005 YDue From - N
--A100108 No NoDue From - US006 YDue From - N
--A100110 No NoDue From - GBR01 YDue From - N
--A100111 No NoDue From - SPN01 YDue From - N
--A100112 No NoDue From - BLG01 YDue From - N
--A100113 No NoDue From - NLD01 YDue From - N
--A100114 No NoDue From - JPN01 YDue From - N
--A100115 No NoDue From - DEU01 YDue From - N
Report ID: Page No. 1PeopleSoft FinancialsFIN0011
Run Date 09.Feb.2002VALID DEPARTMENT CODESRun Time 2:38:44 PM
Set ID: SHARE
As Of Date: 09.Feb.2002
Manager NameDept Description Short Description
Ford,JaneHuman Resources HR10000
Headquarters Headquarte10200
Ford,JaneBenefits Benefits10500
Ford,JaneBenefits Benefits105000
Miller,SamuelInformation Services IS11000
Miller,SamuelPublic Affairs Public Aff12000
Bister,JamesFinance Finance13000
Zak,JillAdministration Admin14000
Ellis,HughBusiness Services Bus Svcs15000
Erwin,AliceSales Administration Sls Adm20000
Lyons,GregEastern Sales Region East Sls21000
Gerhart,RonCentral Sales Region Central Sl21100
Hoffman,TaniaWestern Sales Region West Sls21200
Ng,MaryNorthern Sales Region North Sls21300
Baker,MattSouthern Sales Region South Sls21400
Bartlett,MelanieAsia-Pacific Sales Region As-Pac Sls21500
Wessels,DerekEurope Sales Region Euro Sls21600
Erwin,AliceSales and Services Sales Svcs22000
Ryan,BethMarketing Mktg25000
Ryan,BethCustomer Service Cust Svc27000
Quality Assurance QA31000
Dempsey,GregoryEngineering Eng41000
Adams,TonyManufacturing Support Mfg Supp42000
Waters,WendyResearch and Development R & D43000
Wilson,LindaPurchasing Purchasing50000
Strigel,MikeStocking Stocking51000
Wilson,LindaPlanning Planning52000
Chin,DonaldProduction Scheduling Prod Sched53000
Hawkins,WendyAssembly Assembly54000
Hawkins,WendyFinal Assembly Fnl Assemb55000
Matthews,JamesFinal Inspection Fnl Insp56000
Matthews,JamesQuality Assurance QA60000
Dayton,DennisShipping Shipping61000
Dayton,DennisReceiving Receiving62000
Chapman,EarlRaw Material Stores Raw Matl63000
Diaz,FrankFinished Goods Stores Fin Goods64000
ISO elimination GEN_GOVT ISO eli70110
Mayor, Legislative, City Mg Mayor70111
Planning & Economic Dev Plannin70112
Legal Legal70113
Employee Relations Employe70114
Finance & Accounting Fin & A70115
City Clerk & Elections Clerk &70116
Administration Services Admin S70117
ISO elimination - COMM_DEV ISO eli70120
Ombudsman Office Ombudsm70121
Weatherization Program Weather70122
ISO elimination - CUL_REC ISO eli70130
Parks & Recreation Parks &70131
Community Communications Communi70132
Report ID: Page No. 2PeopleSoft FinancialsFIN0011
Run Date 09.Feb.2002VALID DEPARTMENT CODESRun Time 2:38:44 PM
Set ID: SHARE
As Of Date: 09.Feb.2002
Manager NameDept Description Short Description
Library Library70133
ISO elimination - ENG_SVCS ISO eli70140
Engineering Administration Eng Adm70141
Geographical Info System Geo Inf70142
Personal Services Persona70150
Purchases of Goods & Servic Purch G70151
Capital Projects Capital70160
Debt Services Debt Se70161
ISO elimination - HEALTH_SA ISO eli70170
Garbage Pickup Garbage70171
Casualty Insurance Casualt70180
Fleet Management Fleet M70181
Health/Life Insurance Health/70182
Telecommunications Telecom70183
Data Processing Data Pr70184
Non-Departmental Specific Non-Dep70185
ISO elimination - PUB_SAFET ISO eli70200
Inspections Inspect70201
Police Police70202
Emergency Medical Services Emergen70203
Fire Department Fire De70204
ISO elimination - PUB_WORKS ISO eli70210
Traffic Operations Traffic70211
Mechanical Maintenance Mechani70212
Public Works Administration Public70213
Street Maintenance Street70214
Water Water70220
Parking Facilities Parking70221
Sewer Sewer70222
Administration Services Admin Serv90100
Financial Aid Financ Aid90110
Office of the Registrar Off of Reg90120
School of Engineering Sch of Eng90300
Electrical Engineer Electr Eng90310
Civil Engineer Civil Engi90320
Chemical Engineering Chemic Eng90330
Mayor's Office Mayor's Of92100
Police & Fire Services Pol & Fire92200
Police Service Police Ser92210
Fire Protection Fire Prote92220
Public Works Public Wor92300
Executive Branch Executive95000
Report ID: Page No. 1FIN0012 PeopleSoft Financials
Run Date 09.Feb.2002VALID PRODUCT CODESRun Time 2:38:21 PM
Set ID: SHAREAs Of Date: 09.Feb.2002
Product Description Short Name
ACCSSR Accessories AccessorysALLPRD All Products All ProdsCONFIG Configuration Services Config SrvHARDWR Hardware HardwareINSTAL Installation Services InstallSrvMAINT Maintenance Services Maint SrvsMMEDIA Multimedia MultimediaNOPROD No Product NOPRODPRNTRS Printers PrintersSERVRS Servers Servers
End of Report
Report ID: Page No. 1PeopleSoft FinancialsFIN0013
Run Date 09.Feb.2002VALID PROJECT IDsRun Time 2:39:53 PM
Set ID: SHARE
Project ID Description Project Type
0000000106 Demo Project
0000000107 Demo Project
0000000108 Demo Project's
0000000109 Demo Project SERV
0000000110 Demo Project
0000000111 Demo Project
0000000112 Demo Project
0000000113 Demo Project
0000000114 Demo Project
0000000115 Demo Project with Funds Dist. GOVT
0000000116 ESA to Projects SERV
020208_MWTEST01 Consulting Services CONST
AEROSPACE Aerospace 00000
ALLPROJECTS All Projects 00000
ALL_US003 All US003 Projects 00000
ALL_US004 All US004 Projects 00000
BPA16PROJ1 BPA16 PROJECT 1
BPA17PROJ1 BPA17 PROJECT 1
BPA18PROJ1 BPA18 PROJECT 1
BUILDING Building 00000
COMPLEX Complex 00000
CONSTRUCTIONDIV Construction Division 00000
CONSULTINGDIV Consulting Division 00000
CU_GROMIT_02 ESA DESIGN
CU_GROMIT_03 ESA DESIGN
EPA Environmental Protection Agenc 00000
EXPC1 Basic expense report
EXPC2 Expense report - 5 expense typ
EXPC3 Dinner w/Attendees
EXPC4 Meals and Incidental Expenses
EXPC5 Project Chartfields
EXPC6 VP1, Accounting Splits
EXPC7A InterUnit
EXPC7B InterUnit
EXPC7C InterUnit
FACTORY Factory 00000
GOVTMISCDIV Government/Misc. Division 00000
HIGHTECH CANADIAN HIGH TECH PROJECT 00000
IMPLEMENT Implementation 00000
INTRANET Intranet 00000
IT EXTERNAL IT External 00000
IT INTERNAL IT Internal 00000
LANDSCAPE Landscape 00000
MAINTENANCE Maintenance 00000
MERGER Merger 00000
MIS Management Information Systems 00000
NETWORK Network 00000
NIH001 NIH sample proposal
NOPROJ No Project 00000
PCAM1 Basic Asset
PCAM2 Profile Asset
PCAM3 Book Processing
PCAM4 Profile/Asset Asset
PCAM5 Parent Asset
PCAM6 Child Asset
PCAM7 Group Asset
Report ID: Page No. 2PeopleSoft FinancialsFIN0013
Run Date 09.Feb.2002VALID PROJECT IDsRun Time 2:39:53 PM
Set ID: SHARE
Project ID Description Project Type
PCAM8 Chartfield Asset
PCAM9 COR/PFS Asset
PLANT Plant 00000
POST-IMPLEMENT Post-Implement 00000
PRE-IMPLEMENT Pre-Implementation 00000
PROJECTS01 PROJECTS01 SERV
PROJECTS02 PROJECTS02 CONST
RAD Rapid Application Development 00000
RENOVATION Renovation 00000
RESEARCH Research 00000
ROSY_PROJ1 Rosy Proj1 CAPTL
ROSY_PROJ2 Rosy Proj2 CAPTL
ROSY_PROJ3 Rosy Proj3 CAPTL
ROSY_PROJ4 Rosy Proj4 CAPTL
ROSY_PROJ5 Rosy Proj5 CAPTL
ROSY_PROJ6 Rosy Proj6 CAPTL
RTP_11413301 RTP_11413301 SERV
RTP_INCURRED RTP_INCURRED SERV
TECHNOLGYDIV Technology Division 00000
TRAINING Training 00000
YEAR END Year End 00000
Report ID: Page No. 1PeopleSoft FinancialsFIN0015
Run Date 09.Feb.2002VALID STATISTICS CODESRun Time 2:40:19 PM
Set ID: SHARE
As Of Date: 09.Feb.2002
Code Standard Unit of MeasureDescription Short Name
ALL AVCAll Statistics codes All stat
ASP STDAverage Selling Price AvgSelling
AVC AVCAverage Cost AvgCost
DAY DAYWork Days Work Days
EXT MHRExisting Positions Existing
FLS SQFFloor Space Fl Space
FT MHRFull Time Positions FT
FTE MHRFull Time Equivalent FTE
HC MHRHeadcount Headcount
NEW MHRNew Positions New
NO EANo Statistics Code No Stat
PT MHRPart Time Positions PT
REG MHRRegular Positions Reg
STC STDStandard Cost StndCst
TMP MHRTemporary Positions Temp
TRP UNTNumber of Business Trips Trips
WS UNTWorkstations Workstatns
End of Report
Report ID: Page No. 1PeopleSoft FinancialsFIN0016
Run Date 09.Feb.2002RECORD GROUPSRun Time 2:41:32 PM
Table NameDescriptionRecord Group ID
AGENCY_TBLAgenciesAM_01
BOOK_DEFN_LANGBook DefinitionAM_02BOOK_DEFN_TBLBOOK_DEFN_VWSP_BOOK_CLSVWSP_BOOK_NONVWSP_BOOK_OPRVW
CAP_TYPE_TBLC.A.P. TypesAM_04
AM_INDEX_DETAILAM IndexesAM_05AM_INDEX_TBL
UOP_DET_TBLUnits of Production TablesAM_06UOP_TBL
CONV_BOOK_VWDepreciation TablesAM_09CONV_BU_BOOK_VCONV_BU_VWCONV_DT_TBLCONV_DT_TBL_VWCONV_SETID_VWCONV_TBLDEPR_CAP_TBLDEPR_CAP_YR_TBLDEPR_LIM_TBLDEPR_LIM_YR_TBLDEPR_RT_DET_TBLDEPR_RT_DET_VWDEPR_RT_TBLDEPR_SCHED_PDDEPR_SCHED_TBLDEPR_TERMS_PDDEPR_TERMS_TBLMULTI_SHIFT_TBLUD_METHODUD_METHOD_SEQ
AMAE_TMPLID_TBLAccounting Entry TemplatesAM_10CATEGORY_LANGCATEGORY_LSE_VWCATEGORY_RTCATEGORY_TBLCATEGORY_VWCATEGORY_VW3COST_TYPE_LANGCOST_TYPE_TBLDIST_TMPLLN_TBLDIST_TMPLLN_TMPDIST_TMPLLN_VWDIST_TMPL_TBLDIST_TMPL_TMPTRANS_CODE_TBLTRANS_CODE_VWTRAN_EXCLUD_DETTRAN_EXCLUD_TBLTRAN_EXCLUD_VW
MAINT_CONTRACTRepair/ServiceAM_12MANUF_FS_VW
MAINT_TYPE_TBLMaintenance TypesAM_13
ASSET_LOC_RATEAsset ProfilesAM_15PROFILE_BK_TBLPROFILE_CR_TBLPROFILE_CR_VWPROFILE_DET_RT
Report ID: Page No. 2PeopleSoft FinancialsFIN0016
Run Date 09.Feb.2002RECORD GROUPSRun Time 2:41:32 PM
Table NameDescriptionRecord Group ID
PROFILE_DET_TBLAsset ProfilesAM_15PROFILE_DET_VWPROFILE_PCBK_VWPROFILE_PO_VWPROFILE_PO_VWLNPROFILE_TBLPROFILE_TBL_VWPROFILE_TBL_VW1SP_BK_PRF_CLSVWSP_BK_PRF_NONVWSP_BK_PRF_OPRVW
PROFILE_PCAM_VWProject Asset ProfilesAM_15_PC
LTAX_RT_DET_TBLTax ClassesAM_16LTAX_RT_TBLOWNER_INFO_TBLRETURN_INFO_TBLTAX_CLASS_AM
TAX_CR_RED_TBLTax CreditsAM_17TAX_CR_RED_VWTAX_CR_STATTAX_CR_TBLTAX_CR_VWTAX_CR_VW2TAX_QIV_DET_TBLTAX_QIV_TBL
VNDR_FSVendorsAM_19
FINANCE_CD_TBLFinancing TypesAM_20
ASSET_CLASS_TBLAsset ClassesAM_21FERC_CD_TBLTHRESHOLD_TBL
LEASE_SCH_DTLease Payment ScheduleAM_22LEASE_SCH_ID
ALLOC_BASISAllocationsAM_23ALLOC_DEFNTRANS_GROUP_HDR
AP_TSYMBOL_VWAP Business Unit OptionsAP_01BUS_UNIT_OPT_APBUS_UNIT_SCR_APBU_AMT_TOL_VWBU_FRG_LC_LANGBU_MSC_LC_LANGBU_NRV_LC_LANGBU_OPT_AP_VWBU_OPT_AP_VWLGBU_STX_LC_LANGBU_UTX_LC_LANGRFC_CODE_TBL
ORIGINAP_BI_VWVoucher Origin TablesAP_04
Report ID: Page No. 1PeopleSoft FinancialsFIN0017
Run Date 09.Feb.2002VALID SET IDSRun Time 2:41:44 PM
Set ID Description Short Description
ADB ADB ADBAROC1 AROC1 AROC1AROC2 AROC2 AROC2AROC3 AROC3 AROC3AROC4 AROC4 AROC4AUS01 AUSTRALIA OPERATIONS AUSTRALIAAUS02 Australia Operations 2 AUS02BELGM BELGIUM ALTACCT BELGM ALTBLG01 BELGIUM OPERATIONS BELGIUMBLGE1 BELGIUM - EURO BASE CURRENCY BLGE1BU-IU BU-IU BU-IUBUY01 Dean Jones & Bishop Dean JonesBUY02 DS Telecommunications DS TelecomBUY03 Choice Industries Choice IndBUY04 Jean Paul Inc Jean PaulBUY05 Le Groupe D'international Le GroupeBUY06 TR Services Financiers TR FinanceBUY07 Walton Bros WaltonBUY08 Selectronic Corporation SelectricCAN01 CANADA OPERATIONS CANADA OPSCAN02 Canadian Operations -CAN02 CAN02CBIU1 CBIU1 CBIU1CONSL For Consolidation Processing ConsolCRM01 CRM APPLIANCES CRM APPLCRM02 CRM HARDWARE/SOFTWARE CRM H/SCRM03 CRM EXERCISE EQUIPMENT CRM EXRCSEDEMO2 Demo Data 1 Demo 1DEU01 GERMANY OPERATIONS GERMANYDEU02 GERMANY SAUCE INTERNATIONAL DEU 02DEUE1 GERMANY - EURO BASE CURRENCY DEUE1DMM5 DMM5 DMM5DU002 Germany Unit #2 Germ #2EGV01 EDUC & GVT - BU 1 EGV01EGV02 EDUC & GVT - BU 2 EGV02EGV03 EDUC & GVT - BU 3 EGV03EGV04 EDUC & GVT - BU 4 EGV04EGV05 EDUC & GVT - BU 5 EGV05EGV06 EDUC & GVT - BU 6 EGV06EGVL1 EDUC & GVT - LEGAL ENTITY EGVL1EGVLE Educ & Gov't - Legal Entity BU EGVLEELIM1 Eliminations for Corp Elim CorpELIM2 Eliminations for Canada Elim CanELIM3 Eliminations for US Elim USELIM4 Eliminations for Asia/Pac Elim AsPacELIM5 Eliminations for Europe Eliom EurELIM6 Eliminations for FRA01/BLG01 Elim FR/BLELIM7 Eliminations for US001 Consol Elim US001ELIM8 Eliminations for US005 Consol Elim US005ELIM9 Eliminations for US007 ElimsELM10 Eliminations for USBC ElimELM11 Elimination E&G Elim E&GELM12 Elim - Public Division Elim - PubELM13 Elim - EGVL1 Legal Entity Elim EGVL1ELM14 Elim - Grants Division Elim GrantELM15 Elim - Federal Division Elim FedFED01 FEDERAL - BU 1 FED01FED02 FEDERAL - BU 2 FED02FEDRL Federal FEDERALFRA01 FRANCE OPERATIONS FRANCE OPSFRA02 FRANCE OPERATIONS FRANCE-02FRA03 FRANCE OPERATIONS - SOUTH FRANCE OPSFRA04 FRANCE OPERATIONS - WEST FRANCE OPSFRA05 FRANCE BIKE/OUTDOOR FRANCE-05FRAE1 FRANCE - EURO BASE CURRENCY FRAE1FRNCE FRANCE FRNCEGB003 Great Britain #3 GBR #3GBR01 BRITAIN OPERATIONS BRITAINGBR02 UK BIKE/OUTDOOR INTERNATIONAL UK 2GBR03 UK BIKE MFG/OUTDOOR UK 3
Report ID: Page No. 2PeopleSoft FinancialsFIN0017
Run Date 09.Feb.2002VALID SET IDSRun Time 2:41:44 PM
Set ID Description Short Description
GRMNY Germany Alternate Account GERMANYITALY Italian Setid ITALYITL01 ITALIAN OPERATIONS ITL01ITLE1 ITALY - EURO BASE CURRENCY ITLE1IU-MB IU-MB IU-MBJPN01 JAPAN OPERATIONS JAPAN OPSJPN02 Japan - Sapporo JPN02LCTES test testNLD01 NETHERLANDS OPERATIONS NETHRLANDSNLD02 NETHERLANDS OPERATIONS NETHRLANDSNLDB1 NLD - BALANCED BY DEPTID NLDB1NLDB2 NLD - BALANCED BY DEPTID NLDB2NLDB3 NLD - BALANCED BY DEPTID NLDB3NLDE1 NETHERLANDS - EURO BASE CURR. NLDE1PUBLC Public Setid PUBLCSHARE CORPORATE SETID SHARESHR01 Outdoor Equipment OutdoorSHR02 Consumer Products Cons ProdSHR03 Health Care Health CrSPN01 SPAIN OPERATIONS SPAIN OPSSPN02 SPAIN - EURO BASE CURRENCY SPAIN2-EURSSCA1 Credit Application 1 SSCA1SSCA2 Credit Application 2 SSCA2SSCA3 Credit Application 3 SSCA3SSDE1 SS Disc Eval 1 SSDE1SSDE2 SS Disc Eval 2 SSDE2SSDE3 SS Disc Eval 3 SSDE3US001 US001 NEW YORK OPERATIONS US001US002 US002 MASSACHUSETTS OPERATIONS US002US003 US003 CALIFORNIA OPERATIONS US003US004 US004 ILLINOIS OPERATIONS US004US005 US005 FLORIDA OPERATIONS US005US006 US006 OREGON OPERATIONS US006US007 US007 OPERATIONS US007US008 COLORADO BIKE MFG/OUTDOOR CO OpsUS009 LA BIKE MFG/OUTDOOR LA 9US010 PHOENIX BIKE/OUTDOOR PHOENIXUS011 SAN FRANCISCO BIKE/OUTDOOR SF 11US012 NEW HAMPSHIRE SAUCE/BOTTLING NH 12US013 VERMONT SAUCE AND DELIVERY VT 13US015 PLEASANTON HEALTH PL 15US021 US021 MASSACHUSETTS - DIV 1 US021US022 US022 -CALIFORNIA - DIV1 US022US023 US023 MASSACHUSETTS - DIV3 US023US024 US024 MASSACHUSETTS -DIV4 US024US025 US025 MASSACHUSETTS- DIV 5 US025US026 US026 MASSACHUSETTS - DIV 6 US026US103 US103 OPERATIONS US103US120 CRMCO APPLIANCES US120US130 CRM HARDWARE/SOFTWARE CRM H/SUS140 CRM EXERCISE EQUIP US140US200 CRMCO APPLIANCES CRM APPLUS201 CRMCO Appliance WHS 1 APPL WHS1US202 CRMCO APPLIANCE WHS2 APPL WHS2US300 CRMCO HARDWARE/SOFTWARE US300US301 CRMCO H/S WAREHOUSE 1 WHSE1US302 CRM H/S WAREHOUSE 2 WHSE2US400 CRMCO FITNESS TRUCK CENTER US400
Set Control Value: SHARE
Default Set ID: SHARE
Record Group ID Record Group Description Set ID Set ID Description
AM_01 Agencies SHARE SHARE AM_02 Book Definition SHARE SHARE AM_04 C.A.P. Types SHARE SHARE AM_05 AM Indexes SHARE SHARE AM_06 Units of Production Tables SHARE SHARE AM_09 Depreciation Tables SHARE SHARE AM_10 Accounting Entry Templates SHARE SHARE AM_12 Repair/Service SHARE SHARE AM_13 Maintenance Types SHARE SHARE AM_15 Asset Profiles SHARE SHARE AM_15_PC Project Asset Profiles SHARE SHARE AM_16 Tax Classes SHARE SHARE AM_17 Tax Credits SHARE SHARE AM_19 Vendors SHARE SHARE AM_20 Financing Types SHARE SHARE AM_21 Asset Classes SHARE SHARE AM_22 Lease Payment Schedule SHARE SHARE AM_23 Allocations SHARE SHARE AP_01 AP Business Unit Options SHARE SHARE AP_04 Voucher Origin Tables SHARE SHARE AP_05 Accounting Entry Templates SHARE SHARE AP_06 SpeedChart Tables SHARE SHARE AP_09 AP Conversation Keywords SHARE SHARE AP_10 Business Calendars SHARE SHARE AP_11 Match Rules SHARE SHARE AP_12 AP Archival Business Units SHARE SHARE AP_13 Payment Messages SHARE SHARE AR_02 Aging SHARE SHARE AR_03 Business Unit Options SHARE SHARE AR_04 Collection Status SHARE SHARE AR_05 Collectors SHARE SHARE AR_07 Credit Analysts SHARE SHARE AR_09 Dispute Status SHARE SHARE AR_11 Deposit Types SHARE SHARE AR_12 Dun & Bradstreet Information SHARE SHARE AR_13 Dunning SHARE SHARE AR_14 Distribution Codes SHARE SHARE AR_15 Entry Types and Reasons SHARE SHARE AR_16 Overdue Charges SHARE SHARE AR_17 Follow-up Actions SHARE SHARE AR_18 Group Types SHARE SHARE AR_19 History Definition SHARE SHARE AR_20 Origins SHARE SHARE AR_23 Statements SHARE SHARE AR_24 Keywords SHARE SHARE AR_26 Payment Predictor SHARE SHARE AR_27 Direct Debits SHARE SHARE AR_28 Unpost Reason SHARE SHARE BD_02 Scenarios SHARE SHARE BD_03 Budget Assets SHARE SHARE BD_05 Budget Job Codes SHARE SHARE BI_01 Billing Business Unit Options SHARE SHARE BI_02 Billing Types and Sources SHARE SHARE BI_03 Billing Inquiry Information SHARE SHARE BI_04 Billing Discounts/Surcharges SHARE SHARE BI_05 Charge Identifiers SHARE SHARE BI_06 Installment Billing SHARE SHARE CA_01 Contract Offerings SHARE SHARE CA_02 Contracts SHARE SHARE
Default Tree Set ID: SHARE
Tree Name Tree Description Set ID Set ID Description
BELGIUM_ALTACCTS Belgium Alternate Accounts BELGM BELGM ALT FRANCE_ALTACCTS France Alternate Accounts FRNCE FRNCE
PeopleSoft FinancialsReport ID: FIN0018 TABLE SET CONTROLS Page No. 1
Run Date 11/05/2001Run Time 17:58:54
As Of Date: 11/05/2001Set Control Value: SHARE%
_______________________________________________________________________________________________________________________________________________________________________________Business Unit: AUS01 AUSTRALIA OPERATIONS As Of Date: 1900-01-01 Base Currency: AUD
Interunit Journal Offsets Debit Credit
Chartfield Value Chartfield Value
ACCOUNT 100117 ACCOUNT 100117
AFFILIATE AUS01 AFFILIATE AUS01
Enable Document Sequencing: N
Journal Options Balance: Suspend Edit Errors: Recycle Control Total: Recycle
Chartfield Value
ACCOUNT 899998
Foreign Currency Options Base Adjust: Allow Base Currency Adjustments Balancing: Balance By All Currencies Curr. per Journal: Multiple
Journal Approval Options Standard: Pre-Approved Budget: Pre-Approved
VAT Options VAT Entity: AUS01V
VAT Transaction Type: ASAL VAT Code: AU1 Calculation Type: Inclusive
VAT Tolerance Pct: 0 VAT Tolerance Amt: 0
Currency: AUD Rate Type: CRRNT
_______________________________________________________________________________________________________________________________________________________________________________Business Unit: BLG01 BELGIUM OPERATIONS As Of Date: 1900-01-01 Base Currency: BEF
Interunit Journal Offsets Debit Credit
Chartfield Value Chartfield Value
ACCOUNT 100112 ACCOUNT 100112
AFFILIATE BLG01 AFFILIATE BLG01
Enable Document Sequencing: Y
Journal Options Balance: Suspend Edit Errors: Recycle Control Total: Recycle
Chartfield Value
ACCOUNT 899998
ALTACCT 499999
Foreign Currency Options Base Adjust: Allow Base Currency Adjustments Balancing: Balance By Base Currency Only Curr. per Journal: Multiple
Journal Approval Options Standard: Pre-Approved Budget: Pre-Approved
VAT Options VAT Entity: BLG01V
VAT Transaction Type: BVPS VAT Code: BL1 Calculation Type: Exclusive
VAT Tolerance Pct: 1 VAT Tolerance Amt: 1
Currency: BEF Rate Type: CRRNT
_______________________________________________________________________________________________________________________________________________________________________________Business Unit: BLGE1 BELGIUM - EURO BASE CURRENCY As Of Date: 1900-01-01 Base Currency: EUR
Interunit Journal Offsets Debit Credit
Enable Document Sequencing: Y
Journal Options Balance: Recycle Edit Errors: Recycle Control Total: Recycle
Foreign Currency Options Base Adjust: Allow Base Currency Adjustments Balancing: Balance By All Currencies Curr. per Journal: Multiple
Journal Approval Options Standard: Pre-Approved Budget: Pre-Approved
VAT Options VAT Entity: BLG01V
VAT Transaction Type: E1OP VAT Code: E1OP Calculation Type: Inclusive
VAT Tolerance Pct: 0 VAT Tolerance Amt: 0
PeopleSoft Financials
Report ID: FIN0020 VALID GENERAL LEDGER BUSINESS UNITS Page No. 1
Run Date 11/05/2001
Run Time 18:00:00
Business Unit: US001
_______________________________________________________________________________________________________________________________________________________________________________Ledger Group: ADJUSTMENT Adjustments Ledger Group Ledger Type: Detail
Accounting Periods Calendar: 01 Open From Y/P: 2001/1 Through Y/P: 2001/12 Adj Yr: 2001
Attributes Balanced Ledger: Y Enable Alt Acct: N Rpt Avg Balances: N
Allow WF Update: N Acct->Alt Susp: ADB Calendar:
Enable Sep D/C: N Alt->Acct Susp:
Default Ledger Grp: N Assoc. ledger group:
Commitment Control Enable CC: N Stop budget check at 1st error: Y Reversal Option: Amount
Allow increase remaining SA above budget: N Include pre-encumbrance in RSA: Default
Journal Options Balance: Default to Higher Level Edit Errors: Default to Higher Level Control Total: Default
Document Type:
Foreign Currency Options Base Adjust: Default to Higher Level Balancing: Default to Higher Level Curr. per Journal: Default
Rounding Adjust: Adjust Last Line
Journal Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
_______________________________________________________________________________________________________________________________________________________________________________Ledger Group: LOCALMTD Local ADB MTD Ledger Type: Detail
Accounting Periods Calendar: 01 Open From Y/P: 2001/1 Through Y/P: 2001/12 Adj Yr: 2001
Attributes Balanced Ledger: Y Enable Alt Acct: N Rpt Avg Balances: N
Allow WF Update: N Acct->Alt Susp: ADB Calendar:
Enable Sep D/C: N Alt->Acct Susp:
Default Ledger Grp: N Assoc. ledger group:
Commitment Control Enable CC: N Stop budget check at 1st error: Y Reversal Option: Amount
Allow increase remaining SA above budget: N Include pre-encumbrance in RSA: Default
Journal Options Balance: Default to Higher Level Edit Errors: Default to Higher Level Control Total: Default
Document Type:
Foreign Currency Options Base Adjust: Default to Higher Level Balancing: Default to Higher Level Curr. per Journal: Default
Rounding Adjust: Adjust Last Line
Journal Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
_______________________________________________________________________________________________________________________________________________________________________________Ledger Group: LOCALQTD Local ADB QTD Ledger Type: Detail
Accounting Periods Calendar: 01 Open From Y/P: 2001/1 Through Y/P: 2001/12 Adj Yr: 2001
Attributes Balanced Ledger: Y Enable Alt Acct: N Rpt Avg Balances: N
Allow WF Update: N Acct->Alt Susp: ADB Calendar:
Enable Sep D/C: N Alt->Acct Susp:
Default Ledger Grp: N Assoc. ledger group:
Commitment Control Enable CC: N Stop budget check at 1st error: Y Reversal Option: Amount
Allow increase remaining SA above budget: N Include pre-encumbrance in RSA: Default
Journal Options Balance: Default to Higher Level Edit Errors: Default to Higher Level Control Total: Default
Document Type:
Foreign Currency Options Base Adjust: Default to Higher Level Balancing: Default to Higher Level Curr. per Journal: Default
Rounding Adjust: Adjust Last Line
Journal Approval Options Standard: Default to Higher Level Budget: Default to Higher Level
PeopleSoft Financials
Report ID: FIN0021 LEDGERS FOR A BUSINESS UNIT Page No. 1
Run Date 11/13/2001
Run Time 16:16:05
Report ID: Page No. 1PeopleSoft FinancialsFIN0022
Run Date 09.Feb.2002DETAIL LEDGER DEFINITIONRun Time 2:42:48 PM
Set ID: SHARE
Ledger: LOCALDescription: Local Currency Ledger
Edit Tables Balance
Ledger Template:
ChartField
STANDARD
BUSINESS_UNIT SP_BU_GL_NONVW Y
ACCOUNT GL_ACCOUNT_TBL N
ALTACCT ALTACCT_TBL N
DEPTID DEPT_TBL N
OPERATING_UNIT OPER_UNIT_TBL N
PRODUCT PRODUCT_TBL N
FUND_CODE FUND_TBL N
CLASS_FLD CLASS_CF_TBL N
PROGRAM_CODE PROGRAM_TBL N
BUDGET_REF BUD_REF_TBL N
AFFILIATE AFFILIATE_VW N
AFFILIATE_INTRA1 AFFINTRA1_VW N
AFFILIATE_INTRA2 AFFINTRA2_VW N
CHARTFIELD1 CHARTFIELD1_TBL N
CHARTFIELD2 CHARTFIELD2_TBL N
CHARTFIELD3 CHARTFIELD3_TBL N
PROJECT_ID PROJECT_ID_VW N
BOOK_CODE BOOK_CODE_TBL Y
GL_ADJUST_TYPE ADJUST_TYPE_TBL Y
CURRENCY_CD CURRENCY_CD_TBL Y
STATISTICS_CODE STAT_TBL N
End of Report
Combo Data:
ADB Ledger:
Account ChartField:
Secured Reporting View:
Journal Line Tmp:
Journal Line:
Ledger Tmp 2:
Ledger Tmp:
Ledger:
Record Names
Ledger Type:
Description:
Ledger Template:
5:34:02 PMRun Time
DETAIL LEDGER TEMPLATE DEFINITION 30.Oct.2001Run Date
FIN0023 PeopleSoft Financials 1Page No.Report ID:
BD_PROJECT
BD Projects Detail LedgerDetail Ledger
Consolidations Log:
Multicurrency Log:
Multicurrency Tmp:
Closing Log:
Closing Tmp:
Closing RE Tmp:
Field Names
CLOSE_LDGLG_BDP
CLOSE_LDGTP_BDP
CONSOL_LOG_BDP
GL_ACCOUNT_TBL
LEDGER_TMP_BDP
LEDGER_TMP_BDP2
JRNL_LN_BDP
CURR_WRK_BDP
CURR_LOG_BDP
JRNL_LN_TMP_BDP
LEDGER_PROJ
CLOSE_EARN_BDP
Account:
Monetary Amount:
Statistical Amount:
Posted TotalAmount:
Posted Total Debits:
MONETARY_AMOUNT
STATISTIC_AMOUNT
ACCOUNT
POSTED_TOTAL_AMT
Journal Generator:
COMBO_DATA_BDP
Posted Total Credits:
Flex Budgets Results:
Flex Budgets Operands: BDP_OPERAND_TMP
BDP_RESULT_TMP
Templates
Combination Template: JOURNALS
Flex Budgets Results:
Flex Budgets Operands: BDP_OPERAND_TMP
BDP_RESULT_TMP
Budgets Record Names
Budget Notes:
Budgets Itemizations:
Budgets Asset Data
Budgets Depreciation Data:
Budgets Position Data:
End of Report
3:27:17 PMRun Time
Budget Reference 01.Feb.2002Run Date
FIN0024 PeopleSoft Financials 1Page No.Report ID:
Set ID:
As of Date:
Budget Reference Description Short Description
FEDRL
24.Jan.2002
B0000 All Budgets All Budg
B1999 1999 Budget 1999 BD
B2000 2000 Budget 2000 BD
B2001 2001 Budget 2001 BD
B2002 2002 Budget 2002 BD
B2003 2003 Budget 2003 BD
B2004 2004 Budget 2004 BD
B2005 2005 Budget 2005 BD
B2006 2006 Budget 2006 BD
B2007 2007 Budget 2007 BD
B2008 2008 Budget 2008 BD
B2009 2009 Budget 2009 BD
B2010 2010 Budget 2010 BD
End of Report
Report ID: Page No. 1PeopleSoft FinancialsFIN0025
Run Date 11/21/2003VALID SCENARIOSRun Time 12:30:59 PM
Set ID:
Scenario Description Short Description
As Of Date:
SHARENov/18/2003
4QFCAST 4QForecast4th Quarter Forecast
CLASS ClassExClass Excercise Scenario
CLASSFINAL ClassFinalClass Final Budgets Scenario
FINAL FinalFinal Budget
INITIAL InitialInitial Budget
Q1 1st Qtr1st Quarter
Q2 2nd Qtr2nd Quarter
Q3 3rd Qtr3rd Quarter
Q4 4th Qtr4th Quarter
REVISION1 Revision1Budget - Revision 1
REVISION2 Revision2Budget - Revision 2
End of Report
Report ID: Page No. 1FIN0030 PeopleSoft Financials
Run Date 09.Feb.2002nVISION REPORTSRun Time 2:49:52 PM
US001Unit:
Report ID: ADB Directory Template:
Description: Average Daily Balances File (Doc) Template: %LYN%.XLSLast Run:
As Of Date Tree DateTree Date OptionAs of Date OptionScope IDLayout ID Enable nPlosionReq. Unit Only Sum Led to Detail
FSADB U RYes NoYes 31.Dec.1995
Report ID: ADHOC Directory Template:
Description: Adhoc Journal Request File (Doc) Template: %RID%.xlsLast Run:
As Of Date Tree DateTree Date OptionAs of Date OptionScope IDLayout ID Enable nPlosionReq. Unit Only Sum Led to Detail
ADHOC U RYes NoYes 31.Dec.1995
Report ID: APGLRCN Directory Template:
Description: AP Account Analysis File (Doc) Template: %RID%.XLSLast Run:
As Of Date Tree DateTree Date OptionAs of Date OptionScope IDLayout ID Enable nPlosionReq. Unit Only Sum Led to Detail
APGLRCN U RYes NoYes 31.Dec.1995
Report ID: APPYMNT1 Directory Template:
Description: Payments by Vendor Type File (Doc) Template: %RID%.XLSLast Run:
As Of Date Tree DateTree Date OptionAs of Date OptionScope IDLayout ID Enable nPlosionReq. Unit Only Sum Led to Detail
PYMNTVN1 R RYes NoNo
Report ID: APPYMNT2 Directory Template:
Description: Payment Handling Analysis File (Doc) Template: %RID%.XLSLast Run:
As Of Date Tree DateTree Date OptionAs of Date OptionScope IDLayout ID Enable nPlosionReq. Unit Only Sum Led to Detail
HNDLG01 R RYes NoNo
Report ID: Page No. 2FIN0030 PeopleSoft Financials
Run Date 09.Feb.2002nVISION REPORTSRun Time 2:49:52 PM
US001Unit:
Report ID: BALANCE Directory Template:
Description: Balance Sheet File (Doc) Template: %RID%.XLSLast Run:
As Of Date Tree DateTree Date OptionAs of Date OptionScope IDLayout ID Enable nPlosionReq. Unit Only Sum Led to Detail
BALANCE U RNo NoYes 31.Dec.1995
Report ID: BUDGET Directory Template:
Description: Departmental Budget Worksheet File (Doc) Template: %SFV%.XLSLast Run:
As Of Date Tree DateTree Date OptionAs of Date OptionScope IDLayout ID Enable nPlosionReq. Unit Only Sum Led to Detail
BUDGET DEPTID U RYes NoYes 31.Dec.1995
Report ID: CONSBAL Directory Template:
Description: Consolidated Balance Sheet File (Doc) Template: %RID%.XLSLast Run:
As Of Date Tree DateTree Date OptionAs of Date OptionScope IDLayout ID Enable nPlosionReq. Unit Only Sum Led to Detail
CONSBAL U RYes NoNo 31.Dec.1995
Report ID: CONSBAL2 Directory Template:
Description: Consolidated Balance Sheet File (Doc) Template: %RID%.XLSLast Run:
As Of Date Tree DateTree Date OptionAs of Date OptionScope IDLayout ID Enable nPlosionReq. Unit Only Sum Led to Detail
CONSBAL2 U RYes NoNo 31.Dec.1995
Report ID: CONSIS Directory Template:
Description: Consolidated Income Statement File (Doc) Template: %RID%.XLSLast Run:
Report ID: Page No. 1FIN0031 PeopleSoft Financials
Run Date 09.Feb.2002nVISION SCOPESRun Time 2:50:51 PM
Set ID: SHARE
DEPARTMENTScope ID:
Selected DepartmentsDescription:
Field Combination Table:
ChartField Detail ValuesValue RecordLevelTreeHow Specified
DEPT_TBL 27000Selected Detail ValuesDEPTID
DEPT_TBL 42000Selected Detail Values
DEPARTMENTS DEPT_TBL ADMIN_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL ASSEM_GRPDetail-Selected Parents
DEPARTMENTS ENGR_DIVSelected Tree Nodes
DEPARTMENTS DEPT_TBL ENGR_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL FIN_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL HR_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL PLANNING_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL PURCH_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL QA_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL R & DDetail-Selected Parents
DEPARTMENTS SALES_GRPDetail-Selected Parents
DEPTIDScope ID:
Selected DepartmentsDescription:
Field Combination Table:
ChartField Detail ValuesValue RecordLevelTreeHow Specified
DEPT_TBL 27000Selected Detail ValuesDEPTID
DEPT_TBL 42000Selected Detail Values
DEPARTMENTS DEPT_TBL ADMIN_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL ASSEM_GRPDetail-Selected Parents
DEPARTMENTS ENGR_DIVSelected Tree Nodes
DEPARTMENTS DEPT_TBL ENGR_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL FIN_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL HR_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL PLANNING_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL PURCH_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL QA_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL R & DDetail-Selected Parents
DEPARTMENTS SALES_GRPDetail-Selected Parents
Report ID: Page No. 2FIN0031 PeopleSoft Financials
Run Date 09.Feb.2002nVISION SCOPESRun Time 2:50:51 PM
Set ID: SHARE
DIVISIONScope ID:
Instance for each divisionDescription:
Field Combination Table:
ChartField Detail ValuesValue RecordLevelTreeHow Specified
DEPT_TBL 27000Selected Detail ValuesDEPTID
DEPT_TBL 42000Selected Detail Values
DEPARTMENTS DEPT_TBL ADMIN_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL ASSEM_GRPDetail-Selected Parents
DEPARTMENTS ENGR_DIVSelected Tree Nodes
DEPARTMENTS DEPT_TBL ENGR_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL FIN_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL HR_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL PLANNING_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL PURCH_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL QA_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL R & DDetail-Selected Parents
DEPARTMENTS SALES_GRPDetail-Selected Parents
NODESScope ID:
Selected Tree NodesDescription:
Field Combination Table:
ChartField Detail ValuesValue RecordLevelTreeHow Specified
DEPT_TBL 27000Selected Detail ValuesDEPTID
DEPT_TBL 42000Selected Detail Values
DEPARTMENTS DEPT_TBL ADMIN_GRPDetail-Selected Parents
DEPARTMENTS DEPT_TBL ASSEM_GRPDetail-Selected Parents
DEPARTMENTS ENGR_DIVSelected Tree Nodes
DEPARTMENTS DEPT_TBL ENGR_GRPDetail-Selected Parents
Report ID: FIN0032 Page No. 1PeopleSoft Financials
Run Date 09.Feb.2002VALID OPERATING UNITSRun Time 2:52:12 PM
Set ID:
As Of Date: 09.Feb.2002
SHARE
SETID OPERATING_UNITS DESCRIPTION STATUS EFFECTIVE DATE
SHARE ALBERTA Alberta A 01.Jan.1900SHARE BELGIUM Belgium A 01.Jan.1900SHARE CALIF California A 01.Jan.1900SHARE ELIMEAST US East Elimination A 01.Jan.1900SHARE ELIMUS01 US001 Elimination A 01.Jan.1900SHARE ELIMWEST US West Elimination A 01.Jan.1900SHARE FLORIDA Florida A 01.Jan.1900SHARE FRANCE France A 01.Jan.1900SHARE GERMANY Germany A 01.Jan.1900SHARE HOKKAIDO Hokkaido A 01.Jan.1900SHARE ILLINOIS Illinois A 01.Jan.1900SHARE ITALY Italy A 01.Jan.1900SHARE KYUSHU Kyushu A 01.Jan.1900SHARE MASSACH Massachusetts A 01.Jan.1900SHARE NETHRLND Netherlands A 01.Jan.1900SHARE NEWBRUNS New Brunswick A 01.Jan.1900SHARE NEWYORK New York A 01.Jan.1900SHARE NOVASCOT Nova Scotia A 01.Jan.1900SHARE NSW New South Wales A 01.Jan.1900SHARE OREGON Oregon A 01.Jan.1900SHARE OSAKA Osaka A 01.Jan.1900SHARE QLD Queensland A 01.Jan.1900SHARE QUEBEC Quebec A 01.Jan.1900SHARE SHIKOKU Shikoku A 01.Jan.1900SHARE SPAIN Spain A 01.Jan.1900SHARE TOKYO Tokyo A 01.Jan.1900SHARE TORONTO Toronto A 01.Jan.1900SHARE UK Great Britain A 01.Jan.1900SHARE VICTORIA Victoria A 01.Jan.1900SHARE WA Western Australia A 01.Jan.1900SHARE YAMAGATA Yamagata A 01.Jan.1900SHARE YUKON Yukon A 01.Jan.1900
End of Report
Report Id: FIN0033 PeopleSoft Financials
Run Date
11:22:22 AMRun Time
21.Feb.2002
1Page No.
VALID ALTERNATE ACCOUNTS
SetId: FRNCEAs of Date: 21.Feb.2002
SetIdAlternate Account Description
ControlFlag
Account Type
EffectiveStatus Effective Date
OpenItem
StatisticsAccount
FRNCE 101000 Capital YQ A 01.Jan.1900N N
FRNCE 104200 Primes de Fusion YQ A 01.Jan.1900N N
FRNCE 105200 Ecarts de reevaluation libre NQ A 01.Jan.1900N N
FRNCE 105300 Reserve de Reevaluation NQ A 01.Jan.1900N N
FRNCE 106000 Reserve Legale NQ A 01.Jan.1900N N
FRNCE 106800 Reserves de Consolidation NQ A 01.Jan.1900N N
FRNCE 107000 Interets Minoritaires NQ A 01.Jan.1900N N
FRNCE 110000 Report a Nouveau du resultat NQ A 01.Jan.1900N N
FRNCE 120000 Resultat YQ A 01.Jan.1900N N
FRNCE 120100 Resultat Div A YQ A 01.Jan.1900N N
FRNCE 120200 Resultat Div B YQ A 01.Jan.1900N N
FRNCE 120300 Resultat Div C YQ A 01.Jan.1900N N
FRNCE 120400 Resultat Div D YQ A 01.Jan.1900N N
FRNCE 145000 Amortissements Derogatoires NQ A 01.Jan.1900N N
FRNCE 146000 Provision Reevaluation NQ A 01.Jan.1900N N
FRNCE 151000 Provisions pour Risques NQ A 01.Jan.1900N N
FRNCE 164000 Emprunts aupres Etablist Crd NL A 01.Jan.1900N N
FRNCE 186000 Inter-etablissements Toutes BU NL A 01.Jan.1900N N
FRNCE 186010 Inter-etablissements US001 CR NL A 01.Jan.1900N N
FRNCE 186030 Inter-etablissements US003 CR NL A 01.Jan.1900N N
FRNCE 186040 Inter-etablissements US004 CR NL A 01.Jan.1900N N
FRNCE 186050 Inter-etablissements US005 CR NL A 01.Jan.1900N N
FRNCE 186060 Inter-etablissements US006 CR NL A 01.Jan.1900N N
FRNCE 186070 Inter-etablissements FRA01 CR NL A 01.Jan.1900N N
FRNCE 186080 Inter-etablissements GBR01 CR NL A 01.Jan.1900N N
FRNCE 186090 Inter-etablissements SPN01 CR NL A 01.Jan.1900N N
FRNCE 186100 Inter-etablissements BLG01 CR NL A 01.Jan.1900N N
FRNCE 186110 Inter-etablissements NLD01 CR NL A 01.Jan.1900N N
FRNCE 186120 Inter-etablissements JPN01 CR NL A 01.Jan.1900N N
FRNCE 186130 Inter-etablissements DEU01 CR NL A 01.Jan.1900N N
FRNCE 186140 Inter-etablissements CAN01 CR NL A 01.Jan.1900N N
FRNCE 186150 Inter-etablissements AUS01 CR NL A 01.Jan.1900N N
FRNCE 186160 Inter-etablissements FRA03 CR NL A 01.Jan.1900N N
FRNCE 186165 Inter-etablissements FRA04 CR NL A 01.Jan.1900N N
FRNCE 186180 Inter-etablissements US008 CR NL A 01.Jan.1900N N
FRNCE 186190 Inter-etablissements US009 CR NL A 01.Jan.1900N N
FRNCE 186200 Inter-etablissements US010 CR NL A 01.Jan.1900N N
FRNCE 186210 Inter-etablissements US011 CR NL A 01.Jan.1900N N
FRNCE 186220 Inter-etablissements US012 CR NL A 01.Jan.1900N N
Report Id: FIN0033 PeopleSoft Financials
Run Date
11:22:22 AMRun Time
21.Feb.2002
2Page No.
VALID ALTERNATE ACCOUNTS
SetId: FRNCEAs of Date: 21.Feb.2002
SetIdAlternate Account Description
ControlFlag
Account Type
EffectiveStatus Effective Date
OpenItem
StatisticsAccount
FRNCE 186230 Inter-etablissements US013 CR NL A 01.Jan.1900N N
FRNCE 186250 Inter-etablissements US015 CR NL A 01.Jan.1900N N
FRNCE 186260 Inter-etablissements BLGE1 CR NL A 01.Jan.1900N N
FRNCE 186270 Inter-etablissements DEUE1 CR NL A 01.Jan.1900N N
FRNCE 186280 Inter-etablissements FRAE1 CR NL A 01.Jan.1900N N
FRNCE 186290 Inter-etablissements ITL01 CR NL A 01.Jan.1900N N
FRNCE 186300 Inter-etablissements ITLE1 CR NL A 01.Jan.1900N N
FRNCE 186310 Inter-etablissements NLDB1 CR NL A 01.Jan.1900N N
FRNCE 186320 Inter-etablissements NLDB2 CR NL A 01.Jan.1900N N
FRNCE 186330 Inter-etablissements NLDB3 CR NL A 01.Jan.1900N N
FRNCE 186340 Inter-etablissements NLDE1 CR NL A 01.Jan.1900N N
FRNCE 186350 Inter-etablissements US007 CR NL A 01.Jan.1900N N
FRNCE 186360 Inter-etablissements USBC1 CR NL A 01.Jan.1900N N
FRNCE 186370 Inter-etablissements USBC2 CR NL A 01.Jan.1900N N
FRNCE 186380 Inter-etablissements USBC3 CR NL A 01.Jan.1900N N
FRNCE 186390 Inter-etablissements USLE1 CR NL A 01.Jan.1900N N
FRNCE 186400 Inter-etablissements USLE2 CR NL A 01.Jan.1900N N
FRNCE 186500 InterEts-Bk Cd B /Bl Sht ON CR NA A 01.Jan.1900N N
FRNCE 186510 InterEts-Bk Cd C /Bl Sht ON CR NA A 01.Jan.1900N N
FRNCE 186520 InterEts-Bk Cd L /Bl Sht ON CR NA A 01.Jan.1900N N
FRNCE 186530 InterEts-Bk Cd B /Bl ShtOFF CR NA A 01.Jan.1900N N
FRNCE 186540 InterEts-Bk Cd C /Bl ShtOFF CR NA A 01.Jan.1900N N
FRNCE 186550 InterEts-Bk Cd L /Bl ShtOFF CR NA A 01.Jan.1900N N
FRNCE 187000 Inter-etablissements Toutes BU NL A 01.Jan.1900N N
FRNCE 187010 Inter-etablissements US001 DB NL A 01.Jan.1900N N
FRNCE 187030 Inter-etablissements US003 DB NL A 01.Jan.1900N N
FRNCE 187040 Inter-etablissements US004 DB NL A 01.Jan.1900N N
FRNCE 187050 Inter-etablissements US005 DB NL A 01.Jan.1900N N
FRNCE 187060 Inter-etablissements US006 DB NL A 01.Jan.1900N N
FRNCE 187070 Inter-etablissements FRA01 DB NL A 01.Jan.1900N N
FRNCE 187080 Inter-etablissements GBR01 DB NL A 01.Jan.1900N N
FRNCE 187090 Inter-etablissements SPN01 DB NL A 01.Jan.1900N N
FRNCE 187100 Inter-etablissements BLG01 DB NL A 01.Jan.1900N N
Report ID: Page No. 1PeopleSoft FinancialsFIN0035
Run Date 09.Feb.2002CURRENCY CODESRun Time 3:23:27 PM
As of Date: 09.Feb.2002
Currency Code Effective Date Description Short Description Country Currency Symbol Decimal Positions
ADP And Peseta AND 0Andorran Peseta01.Jan.1900AED Dirham ARE 2United Arab Emirates Dirham01.Jan.1900AFA Afghani AFG 2Afghani01.Jan.1900ALK I Old Lek ALB 2Old Lek01.Dec.1989ALL Lek ALB 2Lek01.Jan.1900AMD Dram ARM 2Armenian Dram01.Jan.1900ANG NA Guilder ANT 2Netherlands Antilles Guilder01.Jan.1900AOA Kwanza AGO 2Kwanza01.Jan.1900AOK I Kwanza AGO 2Kwanza01.Mar.1991AON I New Kwanza AGO 2New Kwanza01.Feb.2000AOR I Kwanza Rea AGO 2Kwanza Reajustado01.Feb.2000ARA I Austral ARG 2Austral01.Jan.1992ARP I Peso ARG 2Peso Argentino01.Jul.1985ARS Peso ARG 2Argentine Peso01.Jan.1900ARY I Peso ARG 2Peso01.Jan.1990ATS Schilling AUT 2Schilling01.Jan.1900AUD Dollar AUS 2Australian Dollar01.Jan.1900AWG Florin ABW 2Aruban Guilder01.Jan.1900AZM Manat AZE 2Azerbaijanian Manat01.Jan.1900BAD I Dinar BIH 2Dinar01.Sep.1997BAM Conv Mark BIH 2Convertible Marks01.Jan.1900BBD Dollar BRB 2Barbados Dollar01.Jan.1900BDT Taka BGD 2Taka01.Jan.1900BEC I Franc BEL 2Convertible Franc01.Mar.1990BEF Franc BEL 0Belgian Franc01.Jan.1900BEL I Franc BEL 2Financial Belgian Franc01.Mar.1990BGJ I Lev A/52 BGR 2Lev A/5201.Jan.1990BGK I Lev A/62 BGR 2Lev A/6201.Jan.1990BGL Leva BGR 2Lev01.Jan.1900BGN LEV BGR 2Bulgarian LEV01.Jan.1900BHD Dinar BHR 3Bahraini Dinar01.Jan.1900BIF Franc BDI 0Burundi Franc01.Jan.1900BMD Dollar BMU 2Bermudian Dollar01.Jan.1900BND Dollar BRN 2Brunei Dollar01.Jan.1900BOB Boliviano BOL 2Boliviano01.Jan.1900BOP I Peso BOL 2Peso01.Feb.1987BOV Mvdol BOL 2Mvdol01.Jan.1900BRB I Cruzeiro BRA 2Cruzeiro01.Mar.1986BRC I Cruzado BRA 2Cruzado01.Feb.1989BRE I Cruzeiro BRA 2Cruzeiro01.Aug.1993BRL Real BRA 2Brazilian Real01.Jan.1900BRN I Cruzado BRA 2New Cruzado01.Mar.1990BRR I Rl Dollar BRA 2Brazilian Real Dollar01.Jul.1994BSD Dollar BHS 2Bahamian Dollar01.Jan.1900BTN Ngultrum BTN 2Ngultrum01.Jan.1900BUK I N/A MMR 2N/A01.Feb.1990BWP Pula BWA 2Pula01.Jan.1900BYB Ruble BLR 0Belarussian Ruble01.Jan.1900BYR Ruble BLR 0Belarussian Ruble01.Jan.1900BZD Dollar BLZ 2Belize Dollar01.Jan.1900CAD Cad Dollar CAN 2Canadian Dollar01.Jan.1900CDF Franc COG 2Franc Congolais01.Jan.1900CHF Franc CHE 2Swiss Franc01.Jan.1900CLF Unid/fmnto CHL 0Unidades de fomento01.Jan.1900CLP Peso CHL 0Chilean Peso01.Jan.1900CNX I PB Dollar CHN 2Peoples Bank Dollar01.Dec.1989CNY Yuan CHN 2Yuan Renminbi01.Jan.1900COP Peso COL 2Colombian Peso01.Jan.1900CRC Colon CRI 2Costa Rican Colon01.Jan.1900CSJ I Krona A/53 CZE 2Krona A/5301.Jan.1990CSK I Koruna CZE 2Koruna01.Mar.1993CUP Peso CUB 2Cuban Peso01.Jan.1900CVE Escudo CPV 2Cape Verde Escudo01.Jan.1900CYP Pound CYP 2Cyprus Pound01.Jan.1900CZK Koruna CZE 2Czech Koruna01.Jan.1900DEM Mark DEU 2Deutsche Mark01.Jan.1900DJF Franc DJI 0Djibouti Franc01.Jan.1900DKK Krone DNK 2Danish Krone01.Jan.1900
Report ID: Page No. 2PeopleSoft FinancialsFIN0035
Run Date 09.Feb.2002CURRENCY CODESRun Time 3:23:27 PM
As of Date: 09.Feb.2002
Currency Code Effective Date Description Short Description Country Currency Symbol Decimal Positions
DOP Peso DOM 2Dominican Peso01.Jan.1900DZD Dinar DZA 2Algerian Dinar01.Jan.1900ECS Sucre ECU 2Sucre01.Jan.1900ECV Valor ECU 2Unidad de Valor01.Jan.1900EEK Kroon EST 2Kroon01.Jan.1900EGP Pound EGY 2Egyptian Pound01.Jan.1900EQE I Ekwele GNQ 2Ekwele01.Dec.1989ERN Nakfa ERI 2Nakfa01.Jan.1900ESA I Peseta ESP 2Spanish Peseta01.Jan.1983ESB I Peseta ESP 2Convertible Peseta01.Dec.1994ESP Peseta ESP 0Spanish Peseta01.Jan.1900ETB Birr ETH 2Ethiopian Birr01.Jan.1900EUR Euro 2Euro01.Jan.1900FIM Markka FIN 2Markka01.Jan.1900FJD Dollar FJI 2Fiji Dollar01.Jan.1900FKP Pound FLK 2Falklands Isl. Pound01.Jan.1900FRF Franc FRA 2French Franc01.Jan.1900GBP Pound GBR 2Pound Sterling01.Jan.1900GEK I Coupon GEO 2Georgian Coupon01.Jan.1995GEL Lari GEO 2Lari01.Jan.1900GHC New cedi GHA 2Cedi01.Jan.1900GIP Pound GIB 2Gibraltar Pound01.Jan.1900GMD Dalasi GMB 2Dalasi01.Jan.1900GNE I Syli GIN 2Syli01.Dec.1989GNF Gnea Franc GIN 0Guinea Franc01.Jan.1900GNS I Syli GIN 2Syli01.Feb.1986GQE I Ekwele GNQ 2Ekwele01.Jun.1986GRD Drachma GRC 0Drachma01.Jan.1900GTQ Quetzal GTM 2Quetzal01.Jan.1900GWP G-B Peso GNB 2Guinea-Bissau Peso01.Jan.1900GYD Dollar GUY 2Guyana Dollar01.Jan.1900HKD Dollar HKG 2Hong Kong Dollar01.Jan.1900HNL Lempira HND 2Lempira01.Jan.1900HRD I Dinar HRV 2Dinar01.Jan.1995HRK Kuna HRV 2Kuna01.Jan.1900HTG Gourde HTI 2Gourde01.Jan.1900HUF Forint HUN 2Forint01.Jan.1900IDR Rupiah IDN 2Rupiah01.Jan.1900IEP Punt IRL 2Irish Pound01.Jan.1900ILP I Pound ISR 2Pound01.Jan.1981ILR I Old Shekel ISR 2Old Shekel01.Jan.1990ILS Sheqel ISR 2New Israeli Sheqel01.Jan.1900INR Rupee IND 2Indian Rupee01.Jan.1900IQD Dinar IRQ 0Iraqi Dinar01.Jan.1900IRR Rial IRN 2Iranian Rial01.Jan.1900ISJ I Old Krona ISL 2Old Krona01.Jan.1990ISK Krona ISL 2Iceland Krona01.Jan.1900ITL Lira ITA 0Italian Lira01.Jan.1900JMD Dollar JAM 2Jamaican Dollar01.Jan.1900JOD Dinar JOR 3Jordanian Dinar01.Jan.1900JPY Yen JPN 0Yen01.Jan.1900KES Shilling KEN 2Kenyan Shilling01.Jan.1900KGS Som KGZ 2Som01.Jan.1900KHR New riel KHM 2Riel01.Jan.1900KMF Franc COM 0Comoro Franc01.Jan.1900KPW Won PRK 2North Korean Won01.Jan.1900KRW Won KOR 0Won01.Jan.1900
SHARE 000000 1900-01-01 0All Accounts All Accts A Y BELGM 499999 499999 000000 FRNCE 471999 471999 000000
100000 1900-01-01 0Petty Cash Petty Cash A Y BELGM 570000 570000 100000 FRNCE 530000 530000 100000
100001 1900-01-01 0USBNK - Treasury Account USBNK-Trsr A Y BELGM 550100 550100 100015 FRNCE 511010 511010 100001
100002 1900-01-01 0USBNK - Disbursements Account UBNK-Disb A Y BELGM 550000 550000 100002 FRNCE 512010 512010 100002
100003 1900-01-01 0USBNK - Collections Account USBNK -Col A Y BELGM 550000 550000 100002 FRNCE 512010 512010 100002
100004 1900-01-01 0USBNK - Payroll Account USBNK-PayR A Y BELGM 550000 550000 100002 FRNCE 512010 512010 100002
100006 1900-01-01 0AUBNK - Treasury Account AUBNK-Trsr A Y BELGM 550100 550100 100015 FRNCE 511020 511020 100006
100007 1900-01-01 0AUBNK - Disbursements Account AUBNK-Disb A Y BELGM 550000 550000 100002 FRNCE 512020 512020 100007
100008 1900-01-01 0AUBNK - Collections Account AUBNK- Col A Y BELGM 550000 550000 100002 FRNCE 512020 512020 100007
100009 1900-01-01 0AUBNK - PayRoll Account AUBNK-PayR A Y BELGM 550000 550000 100002 FRNCE 512020 512020 100007
100010 1900-01-01 0UKBNK - Treasury Account UKBNK-Trsr A Y BELGM 550100 550100 100015 FRNCE 511030 511030 100010
100011 1900-01-01 0UKBNK - Disbursements Account UKBNK-Disb A Y BELGM 550000 550000 100002 FRNCE 512030 512030 100011
100012 1900-01-01 0UKBNK - Collections Account UKBNK-Col A Y BELGM 550000 550000 100002 FRNCE 512030 512030 100011
100013 1900-01-01 0UKBNK - Payroll Account UKBNK-PayR A Y BELGM 550000 550000 100002 FRNCE 512030 512030 100011
100015 1900-01-01 0BLBNK - Treasury Account BLBNK-Trsr A Y BELGM 550100 550100 100015 FRNCE 511040 511040 100015
100016 1900-01-01 0BLBNK - Disbursements Account BLBNK-Disb A Y BELGM 550000 550000 100002 FRNCE 512040 512040 100016
100017 1900-01-01 0BLBNK - Collections Account BLBNK-Col A Y BELGM 550000 550000 100002 FRNCE 512040 512040 100016
100018 1900-01-01 0BLBNK - Payroll Account BLBNK-PayR A Y BELGM 550000 550000 100002 FRNCE 512040 512040 100016
100020 1900-01-01 0SPBNK - Treasury Account SPBNK-Trsr A Y BELGM 550100 550100 100015 FRNCE 511050 511050 100020
100021 1900-01-01 0SPBNK - Disbursements Account SPBNK-Disb A Y BELGM 550000 550000 100002 FRNCE 512050 512050 100021
100022 1900-01-01 0SPBNK - Collections Account SPBNK-Col A Y BELGM 550000 550000 100002 FRNCE 512050 512050 100021
100023 1900-01-01 0SPBNK - Payroll Account SPBNK-PayR A Y BELGM 550000 550000 100002 FRNCE 512050 512050 100021
100024 1900-01-01 0CNBNK - Treasury Account CNBNK-Trsr A Y BELGM 550100 550100 100015 FRNCE 511060 511060 100024
100025 1900-01-01 0CNBNK - Disbursements Account CNBNK-Disb A Y BELGM 550000 550000 100002 FRNCE 512060 512060 100025
100026 1900-01-01 0CNBNK - Collections Account CNBNK-Col A Y BELGM 550000 550000 100002 FRNCE 512060 512060 100025
100027 1900-01-01 0CNBNK - Payroll Account CNBNK-PayR A Y BELGM 550000 550000 100002 FRNCE 512060 512060 100025
100028 1900-01-01 0GMBNK - Treasury Account GMBNK-Trsr A Y BELGM 550100 550100 100015 FRNCE 511070 511070 100028
100029 1900-01-01 0GMBNK - Disbursements Account GMBNK-Disb A Y BELGM 550000 550000 100002 FRNCE 512070 512070 100029
100030 1900-01-01 0GMBNK - Collections Account GMBNK-Col A Y BELGM 550000 550000 100002 FRNCE 512070 512070 100029
100031 1900-01-01 0GMBNK - Payroll Account GMBNK-PayR A Y BELGM 550000 550000 100002 FRNCE 512070 512070 100029
100032 1900-01-01 0FRBNK - Treasury Account FRBNK-Trsr A Y BELGM 550100 550100 100015 FRNCE 511080 511080 100032
100033 1900-01-01 0FRBNK - Disbursement Account FRBNK-Disb A Y BELGM 550000 550000 100002 FRNCE 512080 512080 100033
100034 1900-01-01 0FRBNK - Collections Account FRBNK-Col A Y BELGM 550000 550000 100002 FRNCE 512080 512080 100033
100035 1900-01-01 0FRBNK - Payroll Account FRBNK-PayR A Y BELGM 550000 550000 100002 FRNCE 512080 512080 100033
100036 1900-01-01 0JPBNK - Treasury Account JPBNK-Trsr A Y BELGM 550100 550100 100015 FRNCE 511090 511090 100036
PeopleSoft FinancialsReport ID: FIN0036 ALTERNATE ACCOUNT CROSS REFERENCE Page No. 1
Run Date 11/05/2001Run Time 18:02:26
As Of Date: 10/30/2001SetID: SHARE
------Default------SetID Account Description Short Name Eff Date Type Active AltSetID AltAcct Acct->Alt Alt->Acct
End of Report
Report ID: Page No. 1PeopleSoft FinancialsFIN0050
Run Date 16.Feb.2002VALID FUND CODESRun Time 4:58:59 PM
Set ID:
As Of Date:
Fund Description Attributes
End of Report
Report ID: FIN0052 Page No. 1PeopleSoft Financials
Run Date 16.Feb.2002VALID PROGRAM CODES
Run Time 5:09:17 PM
Set ID:As Of Date:
Program Manager NameDescription
End of Report
1PeopleSoft Financials Page No.Report ID: FIN0053
01.Feb.2002Run DateVALID CLASSIFICATIONS5:33:05 PMRun Time
Set ID: FEDRLAs Of Date: 01.Feb.2002
DescriptionClass
C00 All ClassificationsC10 Administrative ServicesC11 Janitorial ServicesC12 Office SuppliesC13 Maintenance SuppliesC14 UtilitiesC15 Miscellaneous ExpensesC20 SalariesC21 Exempt WagesC22 Hourly WagesC23 OvertimeC24 VacationC25 Sick LeaveC30 BenefitsC31 HealthC32 DentalC33 VisionC34 Life InsuranceC35 PensionC40 OperationsC50 ServicesC60 EquipmentC70 Other
End of Report
Report ID: Page No. 1PeopleSoft FinancialsFIN0057
Run Date 09.Feb.2002JOURNAL TYPESRun Time 3:24:27 PM
SHARESet ID:
Journal Type Description Sequence By
BK Bank Journals Document Type
FS Financial Journals Document Type
JG Journal Generator Journals Document Type
PU Purchase Journals Document Type
SL Sales Journals Document Type
End of Report
Report ID: Page No. 1PeopleSoft FinancialsFIN0058
Run Date 09.Feb.2002JOURNAL CODESRun Time 3:25:08 PM
Set ID:
Journal Code Description Sequence Range Sequencing Type
Journal Type:
Sequence By:
End of Report
Report ID: Page No. 1PeopleSoft FinancialsFIN0059
Run Date 09.Feb.2002DOCUMENT TYPES Run Time 3:58:05 PM
Set ID:
Sequence By:
Journal Type:
Journal Code:
Sequence Range:
Sequencing Type:
Document Type Description Sequence Range Sequencing Type
End of Report
Report ID: Page No. 2PeopleSoft FinancialsFIN0059
Run Date 09.Feb.2002DOCUMENT TYPES Run Time 3:58:05 PM
Report ID: Page No. 1PeopleSoft FinancialsFIN0060
Run Date 09.Feb.2002Document Sequence RangesRun Time 3:25:38 PM
Range ID:
Start #Prefix
Description:
Begin Date End Date End #Start # Example End # Example
End of Report
ALBERTA Alberta
BELGIUM Belgium
CALIF California
CALIF California
CALIF California
ELIMEAST US East Elimination
ELIMUS01 US001 Elimination
ELIMWEST US West Elimination
FLORIDA Florida
FRANCE France
GERMANY Germany
HOKKAIDO Hokkaido
ILLINOIS Illinois
ITALY Italy
KYUSHU Kyushu
MASSACH Massachusetts
NETHRLND Netherlands
NEWBRUNS New Brunswick
NEWYORK New York
NOVASCOT Nova Scotia
NSW New South Wales
OREGON Oregon
OSAKA Osaka
QLD Queensland
QUEBEC Quebec
SHIKOKU Shikoku
SPAIN Spain
TOKYO Tokyo
TORONTO Toronto
UK Great Britain
VICTORIA Victoria
WA Western Australia
YAMAGATA Yamagata
YUKON Yukon
PeopleSoft GL
Report ID: FIN0061 CHARTFIELD ATTRIBUTE REPORT Page No. 1
Run Date 09/30/2003
Run Time 13:34:43
Setid: SHARE
Chartfield: AFFILIATE_INTRA2
Operating Unit Affil Description Attribute Attribute Description Attribute Value
End of Report
APP ENGINE psaemain 10/23/2001 23:45:10 1 Updating 1 of 46 - PSACTIVITYD EFN (0,0) %3 %4
%5 %6 %7 %8 %9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:10 2 Deleting PSACTIVITYDEL (0,0) %2 %3 %4 %5 %6 %7
%8 %9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:10 3 Updating 2 of 46 - PSAEAPPLDEF N (0,0) %3 %4 %5
%6 %7 %8 %9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:10 4 Deleting PSAEAPPLDEL (0,0) %2 %3 %4 %5 %6 %7 %8
%9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:10 5 Updating 3 of 46 - PSAESECTDEF N (0,0) %3 %4 %5
%6 %7 %8 %9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:13 6 Deleting PSAESECTDEL (0,0) %2 %3 %4 %5 %6 %7 %8
%9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:13 7 Updating 4 of 46 - PSBCDEFN (0 ,0) %3 %4 %5 %6
%7 %8 %9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:13 8 Deleting PSBCDEL (0,0) %2 %3 %4 %5 %6 %7 %8 %9 This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:14 9 Updating 5 of 46 - PSBUSPROCDE FN (0,0) %3 %4
%5 %6 %7 %8 %9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:14 10 Deleting PSBUSPROCDEL (0,0) %2 %3 %4 %5 %6 %7
%8 %9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:14 11 Updating 6 of 46 - PSCOLORDEFN (0,0) %3 %4 %5
%6 %7 %8 %9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:14 12 Deleting PSCOLORDEL (0,0) %2 %3 %4 %5 %6 %7 %8
%9
This is a dynamic message.
APP ENGINE psaemain 10/23/2001 23:45:14 13 Updating 7 of 46 - PSCHNLDEFN (0,0) %3 %4 %5 %6
%7 %8 %9
This is a dynamic message.
PeopleSoft Financials
Report ID: FIN1001 BATCH MESSAGE LOG Page No. 1
Run Date 11/06/2001
Run Time 14:51:16
FIN1001
Process Instances: 0000000001 to 0000000195
Process Instance: 0000000039
Job Id Program Date and Time Sequence Logged Message Explanation
Journal ID: GL84JE0104 Journal Date: 11/22/2001 Source: CFO--Chief Financial Officer Reversal: N--None Status: V--Valid
Description Benefit for allocation
1 Salaries & Wages USD 350,000.00 0.00
2 Sales Commissions & Bonuses USD 100,000.00 0.00
3 Expense Accrual USD 0.00 450,000.00
Total USD 450,000.00 450,000.00
_______________________________________________________________________________________________________________________________________________________________________________
PeopleSoft Financials
Report ID: FIN2001 JOURNAL ENTRY DETAIL REPORT Page No. 8
Run Date 12/03/2001
Run Time 10:04:30
Bus. Unit: US001--US001 NEW YORK OPERATIONS
Ledger Grp: RECORDING --Recording Ledger Group
Ledger: LOCAL --Local Currency Ledger
For the period 01/01/1900 through 12/03/2001
Source: CFO Journal ID: ALL Status: V
Line Description
Entry Event Cur Debit Credit
PS/GL Online Entry Panel
1010 Fund Balance with Treasury F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 21,630,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 21,630,000.00 0.00
1020 Miscellaneous Receivables F200 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 9,990,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 9,990,000.00
1110 Undeposited Collections F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
1310 Accounts Receivable F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
3100 Unexpended Appropriations F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 13,290,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 13,290,000.00
4115 Loan Subsidy Appropriation - D F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 9,365,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 9,365,000.00 0.00
4116 Entitlement Loan Subsidy Appro F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 6,065,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 6,065,000.00
4120 Appropriations Anticipated - I F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 3,300,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 3,300,000.00
5200 Revenue from Services Provided F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 15,000,000.00
Not Posted to GL 0.00 0.00
PeopleSoft GL
Report ID: FIN5001 GENERAL LEDGER RECONCILIATION BY SYSTEM SOURCE Page No. 1
Run Date 01/28/2003
Run Time 11:45:27
Bus. Unit: FED01--FEDERAL - BU 1
Ledger: LOCAL -- Actuals Ledger
For Fiscal Year 2002 Period 1 to 1
Account Fund Period Debit Credit
Posted to GL 0.00 15,000,000.00
5200 Revenue from Services Provided F200 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
5600 Donated Revenue - Financial Re F200 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
5700 Expended Appropriations F200 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 47,645,000.00 47,645,000.00
Not Posted to GL 0.00 0.00
Posted to GL 47,645,000.00 47,645,000.00
PS/GL Copy Journal
1010 Fund Balance with Treasury F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,300,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,300,000.00 0.00
4120 Appropriations Anticipated - I F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 6,065,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 6,065,000.00 0.00
4801 Undelivered Orders � Obligatio F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 3,300,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 3,300,000.00
4802 Undelivered Orders � Obligatio F100 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 6,065,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 6,065,000.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
PeopleSoft GL
Report ID: FIN5001 GENERAL LEDGER RECONCILIATION BY SYSTEM SOURCE Page No. 2
Run Date 01/28/2003
Run Time 11:45:27
Bus. Unit: FED01--FEDERAL - BU 1
Ledger: LOCAL -- Actuals Ledger
For Fiscal Year 2002 Period 1 to 1
Account Fund Period Debit Credit
Distributed to GL 9,365,000.00 9,365,000.00
Not Posted to GL 0.00 0.00
Posted to GL 9,365,000.00 9,365,000.00
PeopleSoft GL
Report ID: FIN5001 GENERAL LEDGER RECONCILIATION BY SYSTEM SOURCE Page No. 3
Run Date 01/28/2003
Run Time 11:45:28
Bus. Unit: FED01--FEDERAL - BU 1
Ledger: LOCAL -- Actuals Ledger
For Fiscal Year 2002 Period 1 to 1
Account Fund Period Debit Credit
End of Report
1010 Fund Balance with Treasury F100
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 21,630,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 21,630,000.00 0.00
PS/GL Copy Journal 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,300,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,300,000.00 0.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 24,930,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 24,930,000.00 0.00
Ledger Amount: 24,930,000.00
1020 Miscellaneous Receivables F200
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 9,990,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 9,990,000.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 9,990,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 9,990,000.00
Ledger Amount: < 9,990,000.00>
1110 Undeposited Collections F100
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
Ledger Amount: 3,330,000.00
1310 Accounts Receivable F100
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
PeopleSoft GL
Report ID: FIN5005 GENERAL LEDGER RECONCILIATION BY CHARTFIELD Page No. 1
Run Date 01/28/2003
Run Time 11:35:01
Bus. Unit: FED01--FEDERAL - BU 1
Ledger: LOCAL -- Actuals Ledger
For Fiscal Year 2002 Period 1 to 1
Account Fund Period Debit Credit
PeopleSoft Financials Page: 1 of 1Report Definition: FSX0007 SpeedTypes Run Date: 6-Jul-06
Run Time: 4:58:43 PM
Set ID: SHARE
Private and Confidential
Account Dept Product
PERIPHERAL COGS Peripheral Products
Type: User Operator ID: VP1 Operator Class: -----
500000 21200 CONFIG
PREV Product Revenue
Type: Universal Operator ID: ----- Operator Class: -----
400000 ----- -----
QCASH Queens Bank Checking
Type: Universal Operator ID: ----- Operator Class: -----
100002 ----- -----
SCASH State Bank Checking
Type: Universal Operator ID: ----- Operator Class: -----
100001 ----- -----
SREV Service Revenue
Type: Universal Operator ID: ----- Operator Class: -----
401000 ----- -----
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
Ledger Amount: 3,330,000.00
3100 Unexpended Appropriations F100
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 13,290,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 13,290,000.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 13,290,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 13,290,000.00
Ledger Amount: < 13,290,000.00>
4115 Loan Subsidy Appropriation - D F100
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 9,365,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 9,365,000.00 0.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 9,365,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 9,365,000.00 0.00
Ledger Amount: 9,365,000.00
4116 Entitlement Loan Subsidy Appro F100
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 6,065,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 6,065,000.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 6,065,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 6,065,000.00
Ledger Amount: < 6,065,000.00>
PeopleSoft GL
Report ID: FIN5005 GENERAL LEDGER RECONCILIATION BY CHARTFIELD Page No. 2
Run Date 01/28/2003
Run Time 11:35:01
Bus. Unit: FED01--FEDERAL - BU 1
Ledger: LOCAL -- Actuals Ledger
For Fiscal Year 2002 Period 1 to 1
Account Fund Period Debit Credit
4120 Appropriations Anticipated - I F100
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 3,300,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 3,300,000.00
PS/GL Copy Journal 1 Not Distributed to GL 0.00 0.00
Distributed to GL 6,065,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 6,065,000.00 0.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 6,065,000.00 3,300,000.00
Not Posted to GL 0.00 0.00
Posted to GL 6,065,000.00 3,300,000.00
Ledger Amount: 2,765,000.00
4801 Undelivered Orders � Obligatio F100
PS/GL Copy Journal 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 3,300,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 3,300,000.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 3,300,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 3,300,000.00
Ledger Amount: < 3,300,000.00>
4802 Undelivered Orders � Obligatio F100
PS/GL Copy Journal 1 Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 6,065,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 6,065,000.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 6,065,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 6,065,000.00
Ledger Amount: < 6,065,000.00>
5200 Revenue from Services Provided F100
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
PeopleSoft GL
Report ID: FIN5005 GENERAL LEDGER RECONCILIATION BY CHARTFIELD Page No. 3
Run Date 01/28/2003
Run Time 11:35:01
Bus. Unit: FED01--FEDERAL - BU 1
Ledger: LOCAL -- Actuals Ledger
For Fiscal Year 2002 Period 1 to 1
Account Fund Period Debit Credit
Distributed to GL 0.00 15,000,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 15,000,000.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 0.00 15,000,000.00
Not Posted to GL 0.00 0.00
Posted to GL 0.00 15,000,000.00
Ledger Amount: < 15,000,000.00>
5200 Revenue from Services Provided F200
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
Ledger Amount: 3,330,000.00
5600 Donated Revenue - Financial Re F200
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
Ledger Amount: 3,330,000.00
5700 Expended Appropriations F200
PS/GL Online Entry Panel 1 Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
------------------------------------------------------------------------
Total Activity: Not Distributed to GL 0.00 0.00
Distributed to GL 3,330,000.00 0.00
Not Posted to GL 0.00 0.00
Posted to GL 3,330,000.00 0.00
PeopleSoft GL
Report ID: FIN5005 GENERAL LEDGER RECONCILIATION BY CHARTFIELD Page No. 4
Run Date 01/28/2003
Run Time 11:35:01
Bus. Unit: FED01--FEDERAL - BU 1
Ledger: LOCAL -- Actuals Ledger
For Fiscal Year 2002 Period 1 to 1
Account Fund Period Debit Credit
Ledger Amount: 3,330,000.00
PeopleSoft GL
Report ID: FIN5005 GENERAL LEDGER RECONCILIATION BY CHARTFIELD Page No. 5
Run Date 01/28/2003
Run Time 11:35:02
Bus. Unit: FED01--FEDERAL - BU 1
Ledger: LOCAL -- Actuals Ledger
For Fiscal Year 2002 Period 1 to 1
Account Fund Period Debit Credit
End of Report
�������� �� ����� �����������������������������
������� ����������� !��"# �$��%!���"&%�
����$�'� �(��(���)
�����
��&�����
"*�������+�� ���������� �*�������������� ,�+ ����-�&��-
�%�+�����������
�������� �� ���������������������������������
������������� !�"#$�"�"%�$�����"�&�
�����
���'�����
�()���&����"*�� ���������� �+��������������
�����
,-.,/���#
,,0-,0-��.
,
������ �������������������� ��
������ �������������������� ���
�$�(�����������
�������� �� ���� �������� �
������������������������� ������� ���������
!"��#��$�%�&�%$'��#%$ ����%()� ������'
%�)������%*��
"+��
���)(+(����(+�
���������
���� �� ������� ������������������������������������ ��� ����� ������ ������� ������� !�� !�����
����������� �����
" ## " " " "##"" " # " #
� ����$��������$ ������ � �� � ������� ������� ���� �� �� ������ ����� � % ���� �� & � ��'�� �������� ������
# #
������ ��
" "
" # # # # " " " " # " " " "
�������
#
#
%�)�������
���� �� ������� ������������������������������������ ��� ����� ������ ������� ������� !�� !�����
����������� ���� %%���'��
" ## # " # "#"## " " # #
� ����$��������$ ������ � �� � ������� ������� ���� �� �� ������ ����� � % ���� �� & � ��'�� �������� ������
# #
������ ��
# "
" # # # # # # # # " # # # #
�������
#
"
%�)�������
���� �� ������� ������������������������������������ ��� ����� ������ ������� ������� !�� !�����
����������� ���!����
" ## " # " ###"" # # " "
� ����$��������$ ������ � �� � ������� ������� ���� �� �� ������ ����� � % ���� �� & � ��'�� �������� ������
# #
������ ��
" #
" " " " " " " " " " " " " "
�������
#
"
%�)�������
���� �� ������� ������������������������������������ ��� ����� ������ ������� ������� !�� !�����
����������� ����( ��� %
" ## " " " "#""" " " # #
� ����$��������$ ������ � �� � ������� ������� ���� �� �� ������ ����� � % ���� �� & � ��'�� �������� ������
# #
������ ��
# "
" " " " " " " " " " " " " "
�������
#
"
%�)�������
���� �� ������� ������������������������������������ ��� ����� ������ ������� ������� !�� !�����
����������� ������"����
# ## # # # ##### # # # #
� ����$��������$ ������ � �� � ������� ������� ���� �� �� ������ ����� � % ���� �� & � ��'�� �������� ������
# #
������ ��
# #
" # # # # # " " " " # " " "
�������
#
#
%�)�������
�������� �� ���������������������������������
���������� !�"�#����������� !��
����"�$�
��������#������� ���� ���������� ������ ������
%&'�()��*
%%+&%+&��'
%
������� ����������� �
����� ������������������������� � �
������ ����������� � �
������ ����������� � �
����� ����������������������� � �
���� ������������������������� � �
����! �����������������""���������� � �
����# �����������������""���������� � �
����$ �����������������""���������� � �
����% �����&������� � �
����' ����������� � �
����( �""������&������� � �
�,�-�����������
�������� �� ����� �����������������������������
������� ��������� !"����#�#���$#�����%�&� ���'����(
�����
)��*���+���+ �����+� ���������� �,��������������
�����
�� �� ����� �� ������ ����
�
�������� �� ����� �����������������������������
������� ��������� !"����#�#���$#�����%�&� ���'����(
�����
)��*���+���+ �����+� ���������� �,��������������
�����
��� ��� �������� ������ ����
�
�#�+�����������
�������� �� ����� �����������������������������
������� �� !� !��"#$���%&&'��&(�����)�*� �!"+!+��,
���������� �-��������������%��.���/�
����/
$�������� �����������
��
� ������������������������������ ����
� ������������������������ ���������
������������������� ����
�(�/�����������
PeopleSoft General Ledger Page: 1 of 3Report Definition: GLX4007 Journal Entry Template Run Date: 6-Jul-06
Run Time: 5:18:39 PM
Private and Confidential
Template Type: All Users Users: Permission List:
Template ID Default Unit Ledger Speed Type Event Book Code Budget Period Budget Date VAT Open Item Reference DescriptionCC N Y Y N N N Y Y N N N
Currency Amount Rate Type Rate Base Currency Base Amount Calculate Stat Code Stat Amount UOMY Y Y Y Y N N N N
Account /Affiliate
Fund Affil / Oper Unit Affil
Alt Acct /Bud Ref
Class /Dept
Fund /Oper Unit
Product /Program Project Scenario
Y
N
N
N
Y
Y
N
Y
Y
N
N
NY N
Template ID Default Unit Ledger Speed Type Event Book Code Budget Period Budget Date VAT Open Item Reference DescriptionCOMMERCIAL N Y Y Y N Y Y N Y Y Y
Currency Amount Rate Type Rate Base Currency Base Amount Calculate Stat Code Stat Amount UOMY Y Y Y Y Y N Y Y
Account /Affiliate
Fund Affil / Oper Unit Affil
Alt Acct /Bud Ref
Class /Dept
Fund /Oper Unit
Product /Program Project Scenario
Y
Y
N
Y
Y
N
N
Y
N
Y
Y
NY Y
Template ID Default Unit Ledger Speed Type Event Book Code Budget Period Budget Date VAT Open Item Reference DescriptionFEDRL N Y Y N Y Y Y N N N N
Currency Amount Rate Type Rate Base Currency Base Amount Calculate Stat Code Stat Amount UOMY Y N Y N N N N N
Account /Affiliate
Fund Affil / Oper Unit Affil
Alt Acct /Bud Ref
Class /Dept
Fund /Oper Unit
Product /Program Project Scenario
Y
N
Y
N
Y
Y
Y
Y
Y
N
N
YY Y
Template ID Default Unit Ledger Speed Type Event Book Code Budget Period Budget Date VAT Open Item Reference DescriptionSHORTCOM N Y Y N N Y Y N N N N
Currency Amount Rate Type Rate Base Currency Base Amount Calculate Stat Code Stat Amount UOMY Y N Y N N N N N
PeopleSoft General Ledger Page: 2 of 3Report Definition: GLX4007 Journal Entry Template Run Date: 6-Jul-06
Run Time: 5:18:39 PM
Private and Confidential
Account /Affiliate
Fund Affil / Oper Unit Affil
Alt Acct /Bud Ref
Class /Dept
Fund /Oper Unit
Product /Program Project Scenario
Y
Y
N
N
Y
N
N
Y
N
N
Y
NY Y
Template ID Default Unit Ledger Speed Type Event Book Code Budget Period Budget Date VAT Open Item Reference DescriptionSTANDARD Y Y Y Y Y Y Y N Y N N
Currency Amount Rate Type Rate Base Currency Base Amount Calculate Stat Code Stat Amount UOMY Y Y Y Y Y Y Y N
Account /Affiliate
Fund Affil / Oper Unit Affil
Alt Acct /Bud Ref
Class /Dept
Fund /Oper Unit
Product /Program Project Scenario
Y
Y
Y
N
Y
Y
Y
Y
Y
Y
Y
YY Y
Copy Down ID Default Unit Ledger Event Book Code Budget Period COMMERCIAL N Y Y N
Currency Amount Rate Type Stat Code Stat Amount Budget Date Reference DescriptionY Y Y Y Y N Y Y
Account /Affiliate
Fund Affil / Oper Unit Affil
Alt Acct /Bud Ref
Class /Dept
Fund /Oper Unit
Product /Program
Project /Scenario
Y
Y
N
Y
Y
N
N
Y
N
Y
Y
N
Y
N
Copy Down ID Default Unit Ledger Event Book Code Budget Period FEDRL N Y Y N
Currency Amount Rate Type Stat Code Stat Amount Budget Date Reference DescriptionY N N Y Y Y Y Y
Account / Fund Affil / Alt Acct / Class / Fund / Product / Project /
PeopleSoft General Ledger Page: 3 of 3Report Definition: GLX4007 Journal Entry Template Run Date: 6-Jul-06
Run Time: 5:18:39 PM
Private and Confidential
Affiliate Oper Unit Affil Bud Ref Dept Oper Unit Program Scenario Y
N
N
N
N
N
N
N
N
N
N
N
N
N
Copy Down ID Default Unit Ledger Event Book Code Budget Period SHORTCOM N Y Y N
Currency Amount Rate Type Stat Code Stat Amount Budget Date Reference DescriptionY N N Y Y N N N
Account /Affiliate
Fund Affil / Oper Unit Affil
Alt Acct /Bud Ref
Class /Dept
Fund /Oper Unit
Product /Program
Project /Scenario
Y
N
N
N
N
N
N
N
N
N
N
N
N
N
Copy Down ID Default Unit Ledger Event Book Code Budget Period STANDARD Y Y Y Y
Currency Amount Rate Type Stat Code Stat Amount Budget Date Reference DescriptionY N Y Y Y Y Y Y
Account /Affiliate
Fund Affil / Oper Unit Affil
Alt Acct /Bud Ref
Class /Dept
Fund /Oper Unit
Product /Program
Project /Scenario
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y
Y