Consulta Padrao: GU3TRP - Transportadores



Consulta Padrao(SXB): GU3TRP - Transportadores
XB_ALIASXB_TIPOXB_SEQXB_COLUNAXB_DESCRIXB_CONTEM
GU3TRP101DBTransportadoresGU3
GU3TRP20101Cod Emitente
GU3TRP20202Nome do Emitente
GU3TRP20303Nome Abrev
GU3TRP20411CNPJ/CPF
GU3TRP20512Código Erp + Cod Com
GU3TRP20613Cod Tran Erp
GU3TRP40101Cod EmitenteGU3_CDEMIT
GU3TRP40102Nome AbrevGU3_NMABRV
GU3TRP40103Nome do EmitenteGU3_NMEMIT
GU3TRP40104CidadePosicione("GU7",1,xFilial("GU7")+GU3->GU3_NRCID,"GU7_NMCID")
GU3TRP40105CNPJ/CPFGU3_IDFED
GU3TRP40106Código ERPGU3_CDERP
GU3TRP40107Cod Comp ERPGU3_CDCERP
GU3TRP40108Cod Tran ERPGU3_CDTERP
GU3TRP40209Nome do EmitenteGU3_NMEMIT
GU3TRP40210Cod EmitenteGU3_CDEMIT
GU3TRP40211Nome AbrevGU3_NMABRV
GU3TRP40212CidadePosicione("GU7",1,xFilial("GU7")+GU3->GU3_NRCID,"GU7_NMCID")
GU3TRP40213CNPJ/CPFGU3_IDFED
GU3TRP40214Código ERPGU3_CDERP
GU3TRP40215Cod Comp ERPGU3_CDCERP
GU3TRP40216Cod Tran ERPGU3_CDTERP
GU3TRP40317Nome AbrevGU3_NMABRV
GU3TRP40318Cod EmitenteGU3_CDEMIT
GU3TRP40319Nome do EmitenteGU3_NMEMIT
GU3TRP40320CidadePOSICIONE("GU7",1,xFilial("GU7")+GU3->GU3_NRCID,"GU7_NMCID")
GU3TRP40321CNPJ/CPFGU3_IDFED
GU3TRP40322Código ERPGU3_CDERP
GU3TRP40323Cod Comp ERPGU3_CDCERP
GU3TRP40324Cod Tran ERPGU3_CDTERP
GU3TRP40325CódigoGU3_CDEMIT
GU3TRP40326Código ERPGU3_CDERP
GU3TRP40327Cod Comp ERPGU3_CDCERP
GU3TRP40328Cod Tran ERPGU3_CDTERP
GU3TRP40425CNPJ/CPFGU3_IDFED
GU3TRP40426Cod EmitenteGU3_CDEMIT
GU3TRP40427Nome AbrevGU3_NMABRV
GU3TRP40428Nome do EmitenteGU3_NMEMIT
GU3TRP40429CidadePosicione("GU7",1,xFilial("GU7")+GU3->GU3_NRCID,"GU7_NMCID")
GU3TRP40430Código ERPGU3_CDERP
GU3TRP40431Cod Comp ERPGU3_CDCERP
GU3TRP40432Cod Tran ERPGU3_CDTERP
GU3TRP40533Código ERPGU3_CDERP
GU3TRP40534Cod Comp ERPGU3_CDCERP
GU3TRP40535Cod EmitenteGU3_CDEMIT
GU3TRP40536Nome AbrevGU3_NMABRV
GU3TRP40537Nome do EmitenteGU3_NMEMIT
GU3TRP40538CidadePosicione("GU7",1,xFilial("GU7")+GU3->GU3_NRCID,"GU7_NMCID")
GU3TRP40539CNPJ/CPFGU3_IDFED
GU3TRP40540Cod Tran ERPGU3_CDTERP
GU3TRP40641Cod Tran ERPGU3_CDTERP
GU3TRP40642Cod EmitenteGU3_CDEMIT
GU3TRP40643Nome AbrevGU3_NMABRV
GU3TRP40644Nome do EmitenteGU3_NMEMIT
GU3TRP40645CidadePOSICIONE("GU7",1,xFilial("GU7")+GU3->GU3_NRCID,"GU7_NMCID")
GU3TRP40646CNPJ/CPFGU3_IDFED
GU3TRP40647Código ERPGU3_CDERP
GU3TRP40648Cod Comp ERPGU3_CDCERP
GU3TRP501GU3->GU3_CDEMIT
GU3TRP601GU3->GU3_SIT=="1".AND.(GU3->GU3_TRANSP=="1".OR. GU3->GU3_AUTON=="1")