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”.

 

List By	Cell Value of Column D
Transaction details in posted transaction order	PD
Transaction consolidated total	PT
Transaction consolidated by account	P(POSTRAN)
Transaction consolidated by journal date	P(POSTDATE)
Transaction consolidated by posting sequence	P(POSTSEQ)

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:

 

Exclusive Sorting Order	Meaning
POSTTRAN	By Posted Transaction, in account order
POSTDATE	By Date Order
POSTSEQ	By Posting Sequence Order
POSTACCT	By Account Posting Sequence

 

• 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.