Histórico da Página

Description

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

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

Return cFiltro

04. OTHER INFORMATION

FISXATF.PRX

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

Not Applicable.