Report Naming Conventions
The reports delivered with PeopleSoft applications are identified by a seven- or eight-character code, for example, AMV2060.XNV or APC1030.RPT. Each report name is broken down into the following parts:
·
The first two letters of the code identify the PeopleSoft product:|
Abbreviation |
PeopleSoft Product |
|
AM |
Asset Management |
|
AP |
Accounts Payable |
|
AR |
Accounts Receivable |
|
BD |
Budgets |
|
BI |
Billing |
|
GL |
General Ledger |
|
GM |
Grants |
|
IN |
Inventory |
|
PC |
Projects |
|
PO |
Purchasing |
·
The third letter in the report name denotes the reporting application in which the report was created:|
V |
PS/nVision |
|
C |
Crystal Reports |
|
S |
SQR |
|
Q |
PeopleSoft Query |
·
Following the first three letters in the report name are four numbers, the first two of which reflect the functional area:|
00 |
Basic reports |
|
10 |
Business unit and ledger reports |
|
20 |
Consolidation reports |
|
30 |
Inquiry reports |
|
40 |
Table reports |
|
50 |
Multicurrency reports |
|
60 |
Allocations reports |
|
70 |
Journal entry processing reports for Crystal Reports and Query Reports only, a hyphen follows the four numbers. |
·
The three-character file extension at the end of a report name can help you identify the application that created the report and, in several cases, the format of the report:|
.XNV |
PS/nVision-Layout |
|
.XLS |
PS/nVision-Instance |
|
.RPT |
Crystal Reports-Layout |
|
.EXE |
Crystal Reports-Compiled |
|
.CRF |
Crystal Reports-To File |
|
.SQR |
SQR (Structured Query Reports) |