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) |