Linha Microsiga Protheus - Inglês

Páginas filhas
  • EP CT105QRY

01. GENERAL DATA

Product:

TOTVS Backoffice

Product Line:

Protheus Line

Segment:

Services

Module:

TOTVS Backoffice (Protheus Line) - Managerial Accounting (SIGAFIS)

Function:

CTBA105

Country:

Brazil

Ticket:

Internal

Requisite/Story/Issue

DSERCTR1-46829

02. DESCRIPTION

The entry point CT105QRY allows for the manipulation of the query string used in the accounting of the CTBA105 routine. This point is especially useful for adding custom fields to the aggregation clause or modifying the query to meet specific user requirements. This provides greater flexibility in setting up the accounting data, allowing for customized adjustments in the accounting process.

03. OTHER INFORMATION


Entry Point (EP) manipulation in the system
cQuery 	:= 	ExecBlock("CT105QRY",.F.,.F.,{cQuery,lAglut})
EP Example
#INCLUDE "Protheus.ch"
 
User Function CT105QRY()
    cQuery := ParamIXB[1]  // RECEIVES THE SYSTEM QUERY
    lAglut := ParamIXB[2]  // RECEIVES THE SYSTEM PARAMETER: IF IT AGGREGATES = .T. IF IT DOES NOT AGGREGATE = .F.
    If  lAglut
        //ADDING THE CTK_INFOR FIELD ADDED VIA THE CONFIGURATOR TO THE CTK TABLE BY THE USER
        cQuery  :=   StrTran( cQuery, "FROM", ",CTK_INFOR FROM" )
        cQuery  :=   StrTran( cQuery, "ORDER BY", ",CTK_INFOR ORDER BY" ) 
    EndIf
 
Return cQuery  // RETURNS THE MODIFIED QUERY


Important!

  • It should be noted that the use of the Entry Point (PE) and its impacts on the system are the customer's responsibility.
  • The examples used in this documentation are for demonstration purposes only; each customer must determine the behavior they wish to implement according to the scope of the entry point.

04. RELATED ISSUES

  • It does not apply.