| Field | Description |
|---|
| Transaction Type
|
This column displays a two-letter abbreviation for the type of transaction (for example, CD for cash disbursements).
|
| Reference Number
|
This column displays the reference number for the transaction.
- If the transaction is an implicit posting or an automatic posting, this column displays
Auto.
- If the transaction is historical, this column displays
History.
- If the transaction is related to revenue generation, this column displays
REVGEN.
If you preview the report, you can drill down on the reference to see a listing of all transactions associated with that reference number. You can drill down on
Auto to see all transactions for the posting run.
|
| Fiscal Year and Period
|
This column displays the fiscal year and period in which the transaction was posted (for example,
201906 for the sixth accounting period in the year 2019).
|
| Posting Sequence
|
This column displays the posting sequence number of the transaction.
DPS assigns sequence number 1 to the first group of transactions posted during an accounting period, sequence number 2 to the second group, and so on.
To generate a numbered list of all of the postings for the current accounting period, click
.
|
| Transaction Date
|
For all transactions except automatic postings, this column displays the date entered for the transaction. For automatic postings, this column displays the period-ending date for the file of transactions that generated the posting.
|
| Description
|
This column displays the description of the transaction entered during transaction entry.
If you use multiple companies and the report includes journal entries to intercompany accounts receivable or intercompany accounts payable accounts, you can drill down from the
Description column in those rows to see supporting detail in the Intercompany Billing Detail report. (This drill-down option is only available if your role security gives you access to the Intercompany Billing Detail report, and it is not available for tax-related journal entries.)
|
| Project
|
This column displays the project number associated with the transaction.
If a transaction is not related to a project, this column is blank. This column is blank for all Balance Sheet account transactions except for those that affect accounts receivable.
|
| Phase
|
This column displays the phase number associated with the transaction.
|
| Task
|
This column displays the task number associated with the transaction.
|
| Opening Balance
|
This column displays the balance of the account at the beginning of the reporting period. For example, if you generate a year-to-date Account Analysis, this column displays the balance as of the first day of the fiscal year.
|
| Amount
|
This column displays the total amount of the transaction.
|
| Closing Balance
|
This column displays the balance of the account at the end of the reporting period. If you generate a report for the current period or year to date, this column displays the balance on the day that you generate the report. If you generate a report for a range of past periods, this column displays the balance at the end of the last accounting period in the range.
|
| Transaction Currency Code
|
This column displays the code for the transaction currency. This code applies to the amount in the
Transaction Amount column.
|
| Transaction Opening Balance
|
This column displays the balance of the account at the beginning of the reporting period, expressed in the transaction currency. This amount will be different from the amount in the
Opening Balance column if the transaction currency and functional currency are not the same.
|
| Transaction Amount
|
This column displays the total amount of the transaction, expressed in the transaction currency. This amount will be different from the amount in the
Amount column if the transaction currency and functional currency are not the same.
|
| Transaction Closing Balance
|
This column displays the balance of the account at the end of the reporting period, expressed in the transaction currency. This amount will be different from the amount in the
Closing Balance column if the transaction currency and functional currency are not the same.
|
| Total Credits
|
This column displays the total credits posted to the account during the reporting period.
|
| Total Debits
|
This column displays the total debits posted to the account during the reporting period.
|
| Account Number
|
This column displays the number of the general ledger account.
|
| Posting Date
|
This column displays the date that the transaction was posted.
|
| Description 1, Description 2
|
These columns display the descriptions for each transaction detail line. The following types of descriptions are stored for each transaction:
- Description 1 is a general description of the transaction (for example, the name of the vendor for an accounts payable voucher).
- Description 2 is a more specific description of the transaction (for example, the description entered during transaction entry for a single item on a voucher).
|
| Due To/ From Company
|
For an intercompany transaction, this column displays the name of the other company involved.
|
| Sort/Select 1-3
|
These columns display the sort and select fields that are assigned to this account.
|
| Organization
|
This column displays the organization associated with the transaction. If your enterprise does not use organizations, this column is not available.
|
| Organization levels
|
These columns display the full names of the subcodes for the organization in the
Organization column.
|
