Columns for Diary Report
The following columns are available for this report.
Field | Description |
---|---|
Account | If you select Transaction Detail as a sorting/grouping option, this column displays the number of the general ledger account. |
Company | This column displays the active company that was used when the transaction was posted. |
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. |
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. |
Description | If you select Transaction Detail as a sorting/grouping option, this column displays the description of the transaction entered during transaction entry. |
Description 1, Description 2 | If you select
Transaction Detail as a sorting/grouping option, these columns display the descriptions for each transaction detail line.
Vantagepoint stores the following types of descriptions for each transaction:
|
Diary Code | If you select Transaction Detail as a sorting/grouping option, this column displays the diary code for each transaction. |
Diary Number | If you select Transaction Detail as a sorting/grouping option, this column displays the diary number for each transaction. |
Diary Type | If you select Transaction Detail as a sorting/grouping option, this column displays the diary type for each transaction. |
Discipline | This column displays the discipline that is associated with the transaction. Discipline is the 2nd level of your organization's structure that represents the business disciplines within each of your offices.
The actual column name varies and is based on the name of the business discipline in your organization structure. |
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. |
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. |
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. |
Phase | If you select Transaction Detail as a sorting/grouping option, this column displays the phase number associated with the transaction. |
Posting Date | This column displays the date that 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. Vantagepoint 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. |
Project | If you select Transaction Detail as a sorting/grouping option, this column displays the project number associated with the transaction. |
Reference Number | If you select
Transaction Detail as a sorting/grouping option, this column displays the reference number for the transaction.
|
Row Count | This column displays the row number of a line item. |
Task | If you select Transaction Detail as a sorting/grouping option, this column displays the task number associated with the 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. |
Tax Code | If you select Transaction Detail as a sorting/grouping option, this column displays the tax code for each transaction. |
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. |
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 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. |
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). |
Parent Topic: Diary Report