Consulta Padrao: S61 - PPE



Consulta Padrao(SXB): S61 - PPE
XB_ALIASXB_TIPOXB_SEQXB_COLUNAXB_DESCRIXB_CONTEM
S61101DBPPERCC
S6120101Codigo
S6140101CodigoSUBSTR(RCC->RCC_CONTEU,1,2)
S6140102FilialRCC->RCC_FIL
S6140103SindicatoSUBSTR(RCC->RCC_CONTEU,3,2)
S6140104Início VigênciaCTOD(SUBSTR(RCC->RCC_CONTEU,11,2) + '/'+SUBSTR(RCC->RCC_CONTEU,9,2)+'/'+SUBSTR(RCC->RCC_CONTEU,5,4))
S6140105Fim VigênciaCTOD(SUBS(RCC->RCC_CONTEU,19,2) + '/'+SUBS(RCC->RCC_CONTEU,17,2)+'/'+SUBS(RCC->RCC_CONTEU,13,4))
S6140106%ReduçãoSUBSTR(RCC->RCC_CONTEU,21,7)
S6140107Teto AbonoSUBSTR(RCC->RCC_CONTEU,28,12)
S61501SUBSTR(RCC->RCC_CONTEU,1,2)
S61601RCC->RCC_CODIGO == "S061"
S61701If(.T.,' ',' ')
S61702If(.T.,'ZZ','ZZ')