Using Column D to Consolidate by Transaction Details

Column D constants for use in the spec area are the indicators for listing by transaction details, by transaction consolidated total, and by transaction total. Values must begin with “P”.

Transactions can also be listed by consolidated account segments and account groups as listings by accounts. When consolidating by a specific account order in listing by transactions, the column D value must start with P instead of with D.

For example, P(ACSEGVAL02) is the consolidation of transactions with account segment 2 retrieving records from a transaction, while D(ACSEGVAL02) is the consolidation of account history with account segment 2 retrieving records from an account.

To list the details by transaction, FR requires the spec to provide a correct sorting order, as illustrated in the following table:

• If the account reference is specified with exclusive sorting order at column A from a spec line and the order is an account order (for example, 1000:9000|ACCT), FR does not generate the transaction details of the spec line.

• The sorting order must be POSTTRAN if consolidation value in column D is P(POSTTRAN).

• The sorting order must be POSTDATE if consolidation value in column D is P(POSTDATE).

• The sorting order must be POSTSEQ if consolidation value in column D is P(POSTSEQ).

• If the consolidating total is retrieved by any defined account switches, like P(ACSEGVAL02), it can be sorted by any defined account order, similar to listing by accounts.

• Listing by transaction is only limited to the inquiry of transaction records from the inquired period.