Histórico da Página

01. GENERAL DATA

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

...

The Entry Point has a parameter with the following specification:

Parameter	Use
cFiltro	String containing the default query that can be edited.

Examples

User Function DEPRECQRY()

Local cFiltro := ParamIxb1

//Display Original Search Key
Alert(cFiltro)

//Edit Query
Image Removed

//Check balance type not to be used
cFiltro += " AND N3_TIPO NOT IN( '01', '02', '42', '04', '05', '06', '07', '08', '09' ) "

Image Removed

//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' ) "

Image Removed

Alert("Search Key record F120 edited!!")

Return cFiltro

Language	Portuguese(Brazil)
Versions	11
Operating Systems Supported	All
Compatible with the following Databases	All
Return	cFiltro(caracter) - String containing the handled query.

...