Consulta Padrao(SXB): B66PLS - Locais Atendimento | |||||
XB_ALIAS | XB_TIPO | XB_SEQ | XB_COLUNA | XB_DESCRI | XB_CONTEM |
B66PLS | 1 | 01 | DB | Locais Atendimento | BB8 |
B66PLS | 2 | 01 | 01 | Sequencia do Local | |
B66PLS | 4 | 01 | 01 | Sequencia do Local | BB8->BB8_CODLOC |
B66PLS | 4 | 01 | 02 | Codigo do Local | BB8->BB8_LOCAL |
B66PLS | 4 | 01 | 03 | Local | EVAL({|| x := POSICIONE("BD1",1,xFilial("BD1")+mv_par02+BB8->BB8_LOCAL,"BD1_DESLOC"), IF(EMPTY(X),"NAO ENCONTRADO",X) }) |
B66PLS | 4 | 01 | 04 | Endereco | BB8->BB8_END |
B66PLS | 4 | 01 | 05 | Numero | BB8->BB8_NR_END |
B66PLS | 4 | 01 | 06 | Complemento | BB8->BB8_COMEND |
B66PLS | 4 | 01 | 07 | Municipio | BB8->BB8_MUN |
B66PLS | 4 | 01 | 08 | Bairro | BB8->BB8_BAIRRO |
B66PLS | 4 | 01 | 09 | Estado | BB8->BB8_EST |
B66PLS | 4 | 01 | 10 | Telefone | BB8->BB8_TEL |
B66PLS | 5 | 01 | BB8->BB8_CODLOC | ||
B66PLS | 5 | 02 | BB8->BB8_LOCAL | ||
B66PLS | 6 | 01 | BB8->BB8_CODIGO == mv_par03 |