PJMRPTFRE: Financial overview with specific parameters in SQL queries

Use this entry point to take control on the SQL queries used for extracting the financial overview and assign specific parameters to them.


Context and operating mode

Transaction

There is one transaction in progress.

Log file

There is no open log file.

Call context

Refer to the help on the PJMFINFRE entry point.
The same behavior applies.
The only difference is the available screen, PJMRPTEXT (abbreviation [M:DIA]).


Available variables and masks

The [M:DIA] screen is available.

Open tables


PJMRPTEXT-FILTER: Additional filters

Use this entry point to define additional filters. These filters can be for specific fields that have been added to the screen, for example.


Contexte et mode de fonctionnement

Transaction

There is one transaction in progress.

Log file

There is an open log file.

Call context

This entry point is called just after adding the standard X3 filters.
You just need to add new lines to the table of criteria.

Example:
If [M:DIA]SPECIFIC <> "" Then
ICRITERE += 1: CRITERE(ICRITERE) -= "and [F:PIM]FIELD = [M:DIA]SPECIFIC"
Endif

You can apply the filters to the following tables:

  • OPPOR [OPP]
  • OPPORPJM [OPPPJM]
  • PIMPL [PIM]


Available variables and masks

The [M:DIA] screen is available.

Open tables