Diary Columns Tab

Use the Columns tab to select or clear columns, change column sequence, provide new column labels, set column widths, or select number and date formats.

The columns that display transaction detail information only contain data if you select Transaction Detail on the Sorting/Grouping tab of the Options dialog box. If you do not select Transaction Detail, the column headings display for the transaction detail columns but the columns are blank.

Contents

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.