Field | Description |
Transaction Type
|
If you select
Transaction Detail as a sorting/grouping option, this column displays a two-letter abbreviation for the type of transaction (for example,
CD for cash disbursements).
|
Fiscal Year and Period
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the fiscal period in which the transaction was posted.
|
Posting Sequence
|
If you select
Transaction Detail as a sorting/grouping option, 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.
If you preview the report, you can click the link in this column for a transaction to drill down to the Posting Log report.
|
Transaction Date
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the date entered for the transaction for all transactions except automatic postings. For automatic postings, this column displays the period-ending date for the file of transactions that generated the posting.
|
Description
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the description of the transaction entered during transaction entry.
|
Project
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the project number associated with the transaction.
|
Phase
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the phase number associated with the transaction.
|
Task
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the task number associated with the transaction.
|
Debit Amount
|
This column displays the total debit amount for each sorting/grouping level. If you select
Transaction Detail as a sorting/grouping option, it also displays debit amounts for each transaction.
|
Credit Amount
|
This column displays the total credit amount for each sorting/grouping level. If you select
Transaction Detail as a sorting/grouping option, it also displays credit amounts for each transaction.
|
Reference Number
|
If you select
Transaction Detail as a sorting/grouping option, 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.
|
Diary Code
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the diary code for each transaction.
|
Diary Type
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the diary type for each transaction.
|
Diary Number
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the diary number for each transaction.
|
Tax Code
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the tax code for each transaction.
|
Tax Amount
|
This column displays the total tax amount for each sorting/grouping level. If you select
Transaction Detail as a sorting/grouping option, it also displays the tax amounts for each transaction.
|
Transaction Currency Code
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the code for the transaction currency. This code applies to the amount in the
Tax Amount and
Transaction Amount columns.
|
Transaction Amount
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the total amount of the transaction, expressed in the transaction currency.
|
Account
|
If you select
Transaction Detail as a sorting/grouping option, 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
|
If you select
Transaction Detail as a sorting/grouping option, these columns display the descriptions for each transaction detail line.
DPS stores the following types of descriptions 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
|
If you select
Transaction Detail as a sorting/grouping option and the transaction is an intercompany transaction, this column displays the name of the other company involved.
|
Organization
|
If you select
Transaction Detail as a sorting/grouping option, this column displays the organization associated with the transaction. If your enterprise does not use organizations, this column is not available.
|
Organization levels
|
If you select
Transaction Detail as a sorting/grouping option, these columns display the full names of the subcodes for the organization in the
Organization column. If your enterprise does not use organizations, this column is not available.
|