Product: | TOTVS Backoffice |
Product Line: | Microsiga Protheus Line |
Industry: | Services |
Module: | TOTVS Backoffice (Protheus Line) - Fixed Asset (SIGAFIS) |
Function: | FISXATF.PRW |
Country: | Brazil |
Ticket: | 19714440 |
Requisite/Story/Issue: | DSERCTR1-45022 |
...
Use entry point DEPRECQRY to edit the search query when generating the record F120 of SPED PIS/COFINS
...
Examples
User Function DEPRECQRY()
Local cFiltro := ParamIxb1
//Display Original Search Key
Alert(cFiltro)
//Edit Query
.
The Entry Point has a parameter with the following specification:
Parameter | Use |
cFiltro | String containing the default query that can be edited. |
Handling of EP in the system:
Bloco de código | ||||||
---|---|---|---|---|---|---|
| ||||||
If ExistBlock( 'DEPRECQRY' )
cFiltro := Execblock( 'DEPRECQRY' , .F. , .F. , {cFiltro} )
Endif |
No anexo abaixo temos exemplo de utilização do Ponto de Entrada DEPRECQRY:
View file | ||||||||
---|---|---|---|---|---|---|---|---|
|
Informações | ||
---|---|---|
| ||
The example above refers only to a model for using the Entry Point. The customer is responsible for customizing it depending on their needs and its impacts. |
//Check balance type not to be used
cFiltro += " AND N3_TIPO NOT IN( '01', '02', '42', '04', '05', '06', '07', '08', '09' ) "
//Check transaction types to be used.
//http://tdn.totvs.com/display/public/mp/Tipos+de+movimentos+N4_OCORR+--+11410
cFiltro += " AND N4_OCORR IN ( '06', '10', '20' ) "
Alert("Search Key record F120 edited!!")
...
Language | Portuguese(Brazil) |
Versions | 11 |
Operating Systems Supported | All |
Compatible with the following Databases | All |
Return | cFiltro(caracter) - String containing the handled query. |
...