/* =========================================================================
CAMINI SQL STUDIO - TOTVS RM
Consulta: Lançamentos Financeiros a Pagar/Receber com Cliente/Fornecedor
Módulo: RM Fluxus (Finanças)
========================================================================= */
SELECT
········FLAN.CODCOLIGADA························AS·[CODCOLIGADA]
······,·FLAN.IDLAN······························AS·[IDLAN]
······,·FLAN.NUMERODOCUMENTO····················AS·[NUMERODOCUMENTO]
······,·FLAN.PAGREC·····························AS·[PAGREC]
······,·FLAN.STATUSLAN··························AS·[STATUSLAN]
······,·FLAN.DATAEMISSAO························AS·[DATAEMISSAO]
······,·FLAN.DATAVENCIMENTO·····················AS·[DATAVENCIMENTO]
······,·FLAN.VALORORIGINAL······················AS·[VALORORIGINAL]
······,·FCFO.CODCFO·····························AS·[CODCFO]
······,·FCFO.NOMEFANTASIA·······················AS·[NOME_PARCEIRO]
······,·FCFO.CGCCFO·····························AS·[CNPJ_CPF]
······,·GFILIAL.NOMEFANTASIA····················AS·[NOME_FILIAL]
FROM
····CORPORE.DBO.FLAN·AS·FLAN·WITH·(NOLOCK)
····INNER·JOIN
········CORPORE.DBO.FCFO·AS·FCFO·WITH·(NOLOCK)
············ON··FLAN.CODCOLCFO··················=·FCFO.CODCOLIGADA
············AND·FLAN.CODCFO·····················=·FCFO.CODCFO
····INNER·JOIN
········CORPORE.DBO.GFILIAL·AS·GFILIAL·WITH·(NOLOCK)
············ON··FLAN.CODCOLIGADA················=·GFILIAL.CODCOLIGADA
············AND·FLAN.CODFILIAL··················=·GFILIAL.CODFILIAL
WHERE
····FLAN.CODCOLIGADA·=·1
····AND·FLAN.STATUSLAN·=·0
ORDER·BY
····FLAN.DATAVENCIMENTO·ASC;