Dicionário Protheus
Início
O Poder da Hiperautomação

Tabela GCZ no Protheus

Guias de Atendimentos

O que é a tabela GCZ no Protheus?

A tabela GCZ faz parte do sistema ERP Protheus da TOTVS e é utilizada para guias de atendimentos.

Ela pertence ao dicionário de dados do Protheus (SX2) e armazena informações essenciais utilizadas em processos como cadastros, movimentações e integrações do sistema.

A tabela GCZ possui diversos campos (SX3), cada um com regras específicas como tipo, tamanho e validações, além de índices (SIX) que otimizam a performance das consultas.

Nesta página você pode consultar a estrutura completa da tabela GCZ, incluindo todos os campos e índices relacionados.

Propriedades da Tabela

Propriedade Valor
X2_CHAVE GCZ
X2_PATH \DATA\
X2_ARQUIVO GCZ990
X2_NOME Guias de Atendimentos
X2_NOMESPA Formularios de Atenciones
X2_NOMEENG Attendance Forms
X2_ROTINA -
X2_MODO E
X2_MODOUN E
X2_MODOEMP E
X2_DELET 0
X2_TTS -
X2_UNICO GCZ_FILIAL+GCZ_NRSEQG
X2_PYME S
X2_MODULO 51
X2_DISPLAY -
X2_SYSOBJ -
X2_USROBJ -
X2_POSLGT 1
X2_CLOB 2
X2_AUTREC 2
X2_TAMFIL 2
X2_TAMUN 0
X2_TAMEMP 0
X2_STAMP 2
X2_INSDT 2
D_E_L_E_T_ -
R_E_C_N_O_ 4886
R_E_C_D_E_L_ 0

Campos da Tabela GCZ (149 campos)

X3_ARQUIVO X3_ORDEM X3_CAMPO X3_TIPO X3_TAMANHO X3_DECIMAL X3_TITULO X3_TITSPA X3_TITENG X3_DESCRIC X3_DESCSPA X3_DESCENG X3_PICTURE X3_VALID X3_USADO X3_RELACAO X3_F3 X3_NIVEL X3_RESERV X3_CHECK X3_TRIGGER X3_PROPRI X3_BROWSE X3_VISUAL X3_CONTEXT X3_OBRIGAT X3_VLDUSER X3_CBOX X3_CBOXSPA X3_CBOXENG X3_PICTVAR X3_WHEN X3_INIBRW X3_GRPSXG X3_FOLDER X3_PYME X3_CONDSQL X3_CHKSQL X3_IDXSRV X3_ORTOGRA X3_IDXFLD X3_TELA X3_PICBRV X3_AGRUP X3_POSLGT X3_MODAL X3_CHKSUM X3_ADDSUM D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
GCZ 01 GCZ_FILIAL C 2 0 Filial Sucursal Branch Filial do Sistema Sucursal de Sistema System Branch - - x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - 033 - N - - N N N - - - 1 2 - - - 79044 0
GCZ 02 GCZ_REGATE C 6 0 Reg. Atendim Reg. Atencio Attend. Rec. Registro de Atendimento Registro de Atencion Attendance Record - - x x x x x x x x x x x x x x x - - 1 - - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79045 0
GCZ 03 GCZ_DATATE D 8 0 Data Atendto Fecha Atenc Attend. Date Data do Atendimento Fecha de Atencion Attendance Date - - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79046 0
GCZ 04 GCZ_REGGER C 6 0 Prontuario Hist Clin pa Med. Record Prontuario do paciente historia clinica paciente Patient's Medical Record @! - x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79047 0
GCZ 05 GCZ_NOME C 45 0 Nome Pacient Nomb pacient Pat. Name Nome Nombre Name @! - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79048 0
GCZ 06 GCZ_MATRIC C 25 0 Matricula Matricula Registration Matr. do Plano do Pacient Matr. del Plan Paciente Patient's plan reg. nbr. @! - x x x x x x x x x x x x x x x IIF(!INCLUI,POSICIONE("GD4", 1, xFilial("GD4")+GCZ->GCZ_REGGER+GCZ->GCZ_CODPLA, "GD4_MATRIC"), "") - 1 xxxxxx x - - - N V V - - - - - - - POSICIONE("GD4", 1, xFilial("GD4")+GCZ->GCZ_REGGER+GCZ->GCZ_CODPLA) - - S - - N N N - - - 1 2 - - - 79049 0
GCZ 07 GCZ_CODTPG C 6 0 Tipo de guia Tipo de Form Guide Typ Co Codigo do tipo de guia Codigo de Tipo de Form. Guide Type Code @! HS_VldM24(,14) x x x x x x x x x x x x x x x x - GCU 1 xxxxxxxx - - - S A R - - - - - - - - - - N - - N N N - - - 1 1 - - - 79050 0
GCZ 08 GCZ_DESTPG C 50 0 Descricao Descripcion Description Descricao da clinica Descripcion de la clinica Clinic description @! - x x x x x x x x x x x x x x x x IIf(!Inclui,Posicione("GCU",1,xFilial("GCU")+GCZ->GCZ_CODTPG,"GCU_DESTPG"),"") - 1 xxxxxx x - - - S V V - - - - - - - Posicione("GCU", 1, xFilial("GCU") + GCZ->GCZ_CODTPG, "GCU_DESTPG") - - N - - N N N - - - 1 2 - - - 79051 0
GCZ 09 GCZ_CODCON C 3 0 Cod Convenio Cod.Convenio Code of Heal Codigo do Convenio Codigo del Convenio Codigo do Convenio @! - x x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79052 0
GCZ 10 GCZ_CODPLA C 6 0 Plano Plan Health plan Plano do convenio Plan del convenio Health Insurance Plan @! HS_VldM24(,13) x x x x x x x x x x x x x x x x - GCV 1 xxxxxxxx - - - S A R - - - - - - - - - - N - - N N N - - - 1 1 - - - 79053 0
GCZ 11 GCZ_DESPLA C 30 0 Descricao Descripcion Description Descricao do Plano Descripcion del Plan Health Plan Description @! - x x x x x x x x x x x x x x x x IIf(!Inclui,Posicione("GCM",2,xFilial("GCM")+GCZ->GCZ_CODPLA,"GCM_DESPLA"),"") - 1 xxxxxx x - - - S V V - - - - - - - Posicione("GCM",2,xFilial("GCM")+GCZ->GCZ_CODPLA,"GCM_DESPLA") - - N - - N N N - - - 1 2 - - - 79054 0
GCZ 12 GCZ_SQCATP C 3 0 Seq. Categ. Sec. Categ. Categ. seq. Sequenc. Categoria Plano Secuenc. Categoria Plan Plan category sequence @! HS_VldM24(,28) x x x x x x x x x x x x x x x x - - 1 x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79055 0
GCZ 13 GCZ_DSCATP C 30 0 Desc. Categ. Desc. Categ. Categ.Descr. Desc. Categoria Plano Desc. Categoria Plano Plan category descript. @! - x x x x x x x x x x x x x x x x HS_IniPadr("GFV", 1, GCZ->GCZ_CODPLA+GCZ->GCZ_SQCATP, "GFV_NOMCAT",,.F.) - 1 x - - - S V V - - - - - - - - - - S - - N N N - - - 1 2 - - - 79056 0
GCZ 14 GCZ_NRGUIA C 20 0 Nro. Guia Nro.Form. Guide Nbr. Numero da Guia Numero formulario Guide Number @! HS_VLDM24(,30) x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - !lNrGTissAt - - - N - - N N N - - - 1 2 - - - 79057 0
GCZ 15 GCZ_NRSEN1 C 20 0 Senha 1 Contrasena 1 Psswrd 1 Senha 1 Contrasena 1 Password 1 @! - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79058 0
GCZ 16 GCZ_NRSEN2 C 20 0 Senha 2 Contrasena Psswrd 2 Senha 2 Contrasena 2 Password 2 @! - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79059 0
GCZ 17 GCZ_NRSEN3 C 20 0 Senha 3 Contrasena 3 Psswrd 3 Senha 3 Contrasena 3 Password 3 @! - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79060 0
GCZ 18 GCZ_QTDIAS N 3 0 Qtde. Dias Ctd. Dias Days Qty. Qtde. de dias da guia Ctd. de dias de guia Qty. of Days in Form 999 M->GCZ_QTDIAS > 0 x x x x x x x x x x x x x x x x 1 - 1 x x - - - S A R - - - - - - - - - - N - - N N N - - - 1 1 - - - 79061 0
GCZ 19 GCZ_CODCRM C 7 0 CRM Solicit. CRM Solicit. Req. CRM CRM do medico solicitante CRM de medico solicitante requirer CRM Doctor @! HS_VldM24(,15) x x x x x x x x x x x x x x x x - MED 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79062 0
GCZ 20 GCZ_NOMMED C 30 0 Nome Medico Nomb. Medico Doctor Name Nome do Medico Nombre del Medico Doctor Name @! - x x x x x x x x x x x x x x x x HS_INIPADR("SRA",11,GCZ->GCZ_CODCRM,"RA_NOME") - 1 xxxxxx x - - - S V V - - - - - - - HS_INIPADR("SRA",11,GCZ->GCZ_CODCRM,"RA_NOME") - - N - - N N N - - - 1 2 - - - 79063 0
GCZ 21 GCZ_GUIAPR C 20 0 Guia Princip Form Princip Main form Guia Principal Form. Principal Main form @! - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79064 0
GCZ 22 GCZ_DATAUT D 8 0 Data Autoriz Fch.Autoriz. Author. Date Data da Autorizacao Fecha de Autorizacion Authorization Date - HS_VldM24(,25) x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79065 0
GCZ 23 GCZ_VALSEN D 8 0 Valid. Senha Valid. Contr Password Exp Data Validade Senha Autor Fch. Validez Contrasena A Exp. Dt of Auth. password - - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79066 0
GCZ 24 GCZ_DTGUIA D 8 0 Dt Emis Guia Fc Emis Form Form Issue D Data emissão Guia Fecha Emision Formulario Form Issue Date - - x x x x x x x x x x x x x x x x IIF(!Empty(M->GCY_DATATE),M->GCY_DATATE,'') - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79067 0
GCZ 25 GCZ_DATSOL D 8 0 Data Solicit Fch Solicit Req. date Data Solicitacao Fecha Solicitud Request date - - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79068 0
GCZ 26 GCZ_HORSOL C 5 0 Hora Solicit Hora Solicit Req. time Hora Solicitacao Hora Solicitud Request time 99:99 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79069 0
GCZ 27 GCZ_CIDSOL C 8 0 CID Solicita CID Solicitu Req. ICD CID Solicitacao CID Solicitud Request ICD @! HS_SeekRet('GAS','M->GCZ_CIDSOL',1) x x x x x x x x x x x x x x x x - GAS 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79070 0
GCZ 28 GCZ_INDCLI C 254 0 Ind. Clinica Ind. Clinica Clinical Ind Indicação Clinica Indicacion Clinica Clinical Indication @S100 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79071 0
GCZ 29 GCZ_TEDVLR N 2 0 Evol Doenca Evol Enferm. Disease Evol Tempo Evolucao da Doenca Tiempo Evolucion de Enfer Disease Evolution Time 99 HS_VLDTISS() x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79072 0
GCZ 30 GCZ_TEDUND C 1 0 Un Evol Doen Un Evol Enfe Disea.Evo.Un Unidade Evolucao Doenca Unidad Evolucion Enferm. Disease Evolution Unit 9 HS_VLDTISS() x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - A=Ano(s);M=Mes(es);D=Dia(s) A=Ano(s);M=Mes(es);D=Dia(s) Y=Year(s);M=Month(s);D=Day(s) - - - - - N - - N N N - - - 1 2 - - - 79073 0
GCZ 31 GCZ_IATISS C 1 0 Ind Acidente Ind Accident Accident Ind Indicacao de Acidente Indicacion de Accidente Accident Indication 9 Vazio() .or. Pertence('012') x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - 0=Acidente ou doenca relacionada ao transito;1=Transito;2=Outros;9=Não Acidente 0=Accidente o enfermedad relacionada al trafico;1=Trafico;2=Otros;9=No Accidente 0=Accident or disease related to transit;1=Transit;2=Other;9=Not Accident - - - - - N - - N N N - - - 1 2 - - - 79074 0
GCZ 32 GCZ_OBSTIS C 240 0 Observacao Observacion Note Observacao TISS Observacion TISS TISS Note @S100 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79075 0
GCZ 33 GCZ_IDMARC C 2 0 Id. Marca Id. Marca Brand ID Identif. Reg. Marcado Identif. Reg. Marcado Marked reg. ID - - x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 79076 0
GCZ 34 GCZ_NRFATU C 9 0 Nro Fatura Nº Factura Invoice No. Numero da Fatura Numero de la Factura Invoice Number @! - x x x x x x x x x x x x x x x - - 1 x x - - - N A R - - - - - - - - 018 - N - - N N N - - - 1 2 - - - 79077 0
GCZ 35 GCZ_DATFAT D 8 0 Data Fecha Date Data da Fatura Fecha de la Factura Invoice Date @D - x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79078 0
GCZ 36 GCZ_HORFAT C 5 0 Hora Hora Time Hora da fatura Hora de la factura Invoice Time 99:99 - x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79079 0
GCZ 37 GCZ_NRLOTE C 6 0 Numero Lote Numero Lote Lot No. Numero do Lote Numero del Lote Lot Number @! - x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79080 0
GCZ 38 GCZ_NREXTC C 10 0 Ext.Convenio Ext.Convenio H.Care Stat Codigo do Extr. convenio Codigo del Extr. convenio H.Care Statem.Code - - x x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 79081 0
GCZ 39 GCZ_FILFAT C 2 0 Fil. Faturam Suc Factur Inv. Branch Filial de Faturamento Sucursal de Facturacion Invoicing Branch - - x x x x x x x x x x x x x x x x - - 1 x - - - S V R - - - - - - - - 033 - N - - N N N - - - 1 2 - - - 79082 0
GCZ 40 GCZ_FILATE C 2 0 Fil. Atendim Suc. Atenc. Serv. branch Filial de Atendimento Sucursal de Atencion Service branch - - x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - 033 - N - - N N N - - - 1 2 - - - 79083 0
GCZ 41 GCZ_STATUS C 1 0 Status Estatus Status Status da Conta Estatus de la Cuenta Account Status @! - x x x x x x x x x x x x x x x x "0" - 1 xxxxxx x - - - S V R - - 0=Contr de Contas;1=Faturamento;2=Faturado;3=Lote Atrib;4=Gerado Faturas;5=Assoc Extr.Conv.;6=Liquidado;7=Quitado;8=Reapr. SUS 0=Contr de Cuentas;1=Facturacion;2=Facturado;3=Lote Atrib;4=Genera Facturas;5=Asoc Extr.Conv.;6=Liquidado;7=Pago;8=Reapr. S 0=Accounts Control;1=Invoicing;2=Invoiced;3=Lot granted;4=Inv. Generated;5=Extra HCP Related;6=Settled - - - - - N - - N N N - - - 1 2 - - - 79084 0
GCZ 42 GCZ_NMFFAT C 40 0 Desc. Fiial Desc Suc. Branch Desc. Descrição da Filial Fatur Descripcion de Suc Factur Invoicing Branch Descript @! - x x x x x x x x x x x x x x x x HS_DescFil("GCZ->GCZ_FILFAT", "M0_NOME") - 1 x - - - S A V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79085 0
GCZ 43 GCZ_NRPROT C 6 0 Nro. Protoco Nº Protoco Enroll.No. Numero Protocolo Numero Protocolo Enrollm.Number @! - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79086 0
GCZ 44 GCZ_DATSTA D 8 0 Data Fecha Date Dt do ultimo status conta Fcha ultimo est. cuenta Account status last date - - x x x x x x x x x x x x x x x dDataBase - 1 x x x - - - N A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79087 0
GCZ 45 GCZ_VALPAG N 10 2 Pago Total Pago Total Total paid Valor pago total Valor total pagado Total amount paid @E 9999,999.99 HS_VlM381() x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - lG_Guia - - - N - - N N N - - - 1 2 - - - 79088 0
GCZ 46 GCZ_VALGLO N 10 2 Glosa Total Glosa Total Total cut Valor glosa total Valor total glosa Total amount cut @E 9999,999.99 HS_VlM381() x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - lG_Guia - - - N - - N N N - - - 1 2 - - - 79089 0
GCZ 47 GCZ_VLPAGM N 10 2 Pago Mat/Med Pag. Mat/Med Mat/Med Paid Valor pago Mat/Med Valor pagado Mat/Med Valor pago Mat/Med @E 9999,999.99 HS_VlM381() x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - lG_Guia - - - N - - N N N - - - 1 2 - - - 79090 0
GCZ 48 GCZ_VLGLOM N 10 2 Glosa Mat/Me Glosa Mat/Me Disa.Mat/Med Valor glosa Mat/Med Valor glosa Mat/Med Mat/Med Disallow. Value @E 9999,999.99 HS_VlM381() x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - lG_Guia - - - N - - N N N - - - 1 2 - - - 79091 0
GCZ 49 GCZ_VLPAGT N 10 2 Pago Tax/Dia Pag Tas/Dia Rate/Day Pai Valor pago Tax/Dia Valor pagado Tas/Dia Valor pago Tax/Dia @E 9999,999.99 HS_VlM381() x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - lG_Guia - - - N - - N N N - - - 1 2 - - - 79092 0
GCZ 50 GCZ_VLGLOT N 10 2 Glosa Tax/Di Glosa Tas/Di Disallow Rat Valor glosa Tax/Dia Valor glosa Tas/Dia Valor glosa Tax/Dia @E 9999,999.99 HS_VlM381() x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - lG_Guia - - - N - - N N N - - - 1 2 - - - 79093 0
GCZ 51 GCZ_VLPAGP N 10 2 Pago Pro/Hon Pago Pro/Hon PymntPro/Fee Valor pago Pro/Hon Valor pagado Pro/Hon Value DisallowancePro/Fee @E 9999,999.99 HS_VlM381() x x x x x x x x x x x x x x x - - 1 x x x - - - N A R - - - - - - lG_Guia - - - N - - N N N - - - 1 2 - - - 79094 0
GCZ 52 GCZ_VLGLOP N 10 2 Glosa Pro/Ho Glosa Pro/Ho DisallPro/Fe Valor glosa Pro/Hon Valor glosa Pro/Hon Value DisallowancePro/Fee @E 9999,999.99 HS_VlM381() x x x x x x x x x x x x x x x - - 1 x x x - - - N V R - - - - - - lG_Guia - - - N - - N N N - - - 1 2 - - - 79095 0
GCZ 53 GCZ_VALREC N 10 2 Recup. Total Recup. Total Total recov. Valor recuperado total Valor recuperado total Total amount recovered @E 9999,999.99 - x x x x x x x x x x x x x x x - - 1 x x x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79096 0
GCZ 54 GCZ_VALPER N 10 2 Perda Total Perd. Total Total loss Valor perda total Valor perdida total Amount of total loss @E 9999,999.99 - x x x x x x x x x x x x x x x - - 1 x x x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79097 0
GCZ 55 GCZ_VLRECM N 10 2 Rec. Mat/Med Rec. Mat/Med Mat/Med.Reco Valor recuperado Mat/Med Valor recuperado Mat/Med Mat/Med.Recovered Value @E 9999,999.99 - x x x x x x x x x x x x x x x - - 1 x x x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79098 0
GCZ 56 GCZ_VLPERM N 10 2 Perda Mat/Me Perd. Mat/Me Mat/Med.Loss Valor perda Mat/Med Valor perd. Mat/Med Mat/Med loss @E 9999,999.99 - x x x x x x x x x x x x x x x - - 1 x x x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79099 0
GCZ 57 GCZ_VLRECT N 10 2 Rec. Tax/Dia Rec. Tas/Di Rec.Rate/Day Valor recuperado Tax/Dia Valor recuperado Tas/Dia Rcvrd.Amount Rate/Day @E 9999,999.99 - x x x x x x x x x x x x x x x - - 1 x x x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79100 0
GCZ 58 GCZ_VLPERT N 10 2 Perda Tax/Di Perd. Tas/Di LossRate/Day Valor perda Tax/Dia Valor perd. Tas/Dia Amnt. Loss Rate/Day @E 9999,999.99 - x x x x x x x x x x x x x x x - - 1 x x x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79101 0
GCZ 59 GCZ_VLRECP N 10 2 Rec. Pro/Hon Rec. Pro/Hon Rec.Prof/Fee Valor recuperado Pro/Hon Valor recuperado Pro/Hon Rcvrd.Amount Prof./Fee @E 9999,999.99 - x x x x x x x x x x x x x x x - - 1 x x x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79102 0
GCZ 60 GCZ_VLPERP N 10 2 Perda Pro/Ho Perd. Pro/Ho LossProf/Fee Valor perda Pro/Hon Valor perd. Pro/Hon Amnt. Loss Prof. Fee @E 9999,999.99 - x x x x x x x x x x x x x x x - - 1 x x x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79103 0
GCZ 61 GCZ_NUMORC C 6 0 Num. Orcam. Num. Presup. Budge. No. Numero do Orcamento Numero del Presupuesto Budget Number @! - x x x x x x x x x x x x x x x x - - 1 x x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79104 0
GCZ 62 GCZ_SERIE C 3 0 Serie Nota Serie Factur Invoice Seri Serie da Nota Serie de la Factura Invoice Series !!! - x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - N A R - - - - - - - - 094 - N - - N N N - - - 1 2 - - - 79105 0
GCZ 63 GCZ_NRNOTA C 9 0 Nota Fiscal Factura Invoice Numero da Nota Fiscal Numero de la Factura Invoice number @! - x x x x x x x x x x x x x x x - - 1 x x - - - N A R - - - - - - - - 018 - N - - N N N - - - 1 2 - - - 79106 0
GCZ 64 GCZ_VLGUIA N 10 2 Vlr da Guia Vlr de Form. Guide Val Valor Total da Guia Valor Total de Formulario Total Value of Guide @E 9,999,999.99 - x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79107 0
GCZ 65 GCZ_NRSEQG C 6 0 Nro.Seq.Guia Nro.Sec.Form Form.Seq.No. Numero sequencial da guia Numero Secuencial form. Form Sequential Number @! - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79108 0
GCZ 66 GCZ_NRRPT1 C 7 0 Rel.Sol.Det. Lis.Sol.Det. Rep.Req.Det. Rel.Sol.Det.Glosa Lis.Sol.Det.Glosa Rep.Req.Det.Disallow. - - x x x x x x x x x x x x x x x x - - 1 xx x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79109 0
GCZ 67 GCZ_DTRPT1 D 8 0 Dt.Em.Sol.Dt Fc.Em.Sol.Dt Dt.Em.Sol.Dt Dt.Em.Sol.Detalhe Fc.Em.Sol.Detalle Detail Req.Em.Dt. - - x x x x x x x x x x x x x x x x - - 1 xx x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79110 0
GCZ 68 GCZ_CANCEL C 1 0 Cancelado? ¿Anulado? Cancelled Cancelado? ¿Anulado? Cancelled @! - x x x x x x x x x x x x x x x "0" - 1 xxxxxx x - - - N V R - - 0=Näo;1=Cancelado 0=No;1=Anulado 0=No;1=Cancelled - - - - - N - - N N N - - - 1 2 - - - 79111 0
GCZ 69 GCZ_LOGARQ C 50 0 Log Log Log Log Log Log - - x x x x x x x x x x x x x x x HS_LOGARQ() - 1 xxxxxx x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79112 0
GCZ 70 GCZ_DTGERA D 8 0 Dt.Geracao Fc.Generac. Generat.Date Data da geracao Fecha de generacion Date of generation @D - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - N V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 79113 0
GCZ 71 GCZ_HRGERA C 5 0 Hr.Geracao Hr.Generac. Generat.Time Horario da geracao Horario generacion Time of generation 99:99 - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - N V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 79114 0
GCZ 72 GCZ_USGERA C 25 0 Usuario Gera Usuario Gen. Generat.User usuario da geracao usuario de generacion User of generation @! - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - N V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 79115 0
GCZ 73 GCZ_ATENDI C 1 0 Tipo Atendto Tp. Atencion Serv. type Tipo do Atendimento Tipo de Atencion Service type @! - x x x x x x x x x x x x x x x - - 1 - - - - N V R - - 0=Internacao;1=Ambulatorio;2=Pronto Atendimento 0=Internaciono;1=Ambulatorio;2=Consultorios Externos 0=Hospitalization;1=Policlinic;2=Emergency room - - - - - N - - N N N - - - 1 2 - - - 79116 0
GCZ 74 GCZ_LOCATE C 2 0 Setor Atend. Sector Atenc Serv. Sector Setor do atendimento Sector de atencion Servicing Sector @! - x x x x x x x x x x x x x x x - - 1 - - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79117 0
GCZ 75 GCZ_CTAPAR N 2 0 Cta Parcial Cta Parcial Partial Acct Conta Parcial Cuenta Parcial Partial account @E 99 - x x x x x x x x x x x x x x x x 1 - 1 xxxxxx x - - - S V R - - - - - - - - - - S - - N N N - - - 1 2 - - - 79118 0
GCZ 76 GCZ_DCPARI D 8 0 Dt.Parcial I FchParcial I Part Init Dt Dt inicial da cta parcial Fch inicial de cta parcil Initial Dt. of Part. Acc. @D - x x x x x x x x x x x x x x x x M->GCY_DATATE - 1 xxxxxx x - - - S A R - - - - - - !INCLUI .AND. M->GCZ_STATUS > "0" - - - S - - N N N - - - 1 2 - - - 79119 0
GCZ 77 GCZ_CMCAIH C 2 0 Motivo Cobr. Motivo Cobr. Reason Coll. Motivo Cobranca Motivo Cobranza Reason for collection - HS_VldM24(,21) x x x x x x x x x x x x x x x x - GH8001 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79120 0
GCZ 78 GCZ_DCPARF D 8 0 Dt.Parcial F FchParcial F Part Fin Dt. Dt. Parcial Final Fch Parcial Final Partial Final Date @D - x x x x x x x x x x x x x x x x IIF(M->GCY_ATENDI=="0", CTOD(" / / "), M->GCY_DATATE) - 1 xxxxxx x - - - S V R - - - - - - !INCLUI .AND. M->GCZ_STATUS > "0" - - - S - - N N N - - - 1 2 - - - 79121 0
GCZ 79 GCZ_DMCAIH C 50 0 Desc. Motivo Desc. Motivo Reason Dscr. Descricao Motivo Cobranca Descrip.Motivo Cobranza Collection reason descr. @! - x x x x x x x x x x x x x x x x HS_INIPADR("GH8", 1, GCZ->GCZ_CMCAIH, "GH8_DMCAIH") - 1 xxxxxx x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79122 0
GCZ 80 GCZ_IDGUIA C 1 0 ID. Guia ID. Formular Form ID Identificacao Guia Identificacion Formulario Form identification - - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S V R - - 1=Inicial;5=Continuidade 1=Inicial;5=Continuidad 1=Initial;5=Continuity - - - - - N - - N N N - - - 1 2 - - - 79123 0
GCZ 81 GCZ_AIHANT C 10 0 AIH Anterior AIH Anterior Previous AIH AIH Anterior AIH Anterior Previous AIH @! - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79124 0
GCZ 82 GCZ_AIHPOS C 10 0 AIH Post. AIH Post. Next AIH AIH Posterior AIH Posterior Next AIH - - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79125 0
GCZ 83 GCZ_CDCBOR C 3 0 Cod. Oficio Cod. Oficio Activ.Code Codigo do oficio Codigo del Oficio Activity Code - HS_VldM24(,22) x x x x x x x x x x x x x x x x - GH2001 1 xxxxxx x - - - S A R - - - - - - GCY->GCY_ACITRA == "1" - - - N - - N N N - - - 1 2 - - - 79126 0
GCZ 84 GCZ_DSCBOR C 50 0 Descricao Descripcion Description Descricao do Oficio Descripcion del Oficio Description of workshop - - x x x x x x x x x x x x x x x x HS_INIPADR("GH2", 1, GCZ->GCZ_CDCBOR, "GH2_DESCBO") - 1 xxxxxx x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79127 0
GCZ 85 GCZ_CDCCNA C 3 0 Cod. Nac Atv Cod.Nac.Act. Nat. Act. Cd Codigo nac. ativ. econ. Codigo Nac.Activ.Econom. Eco. Act. Nat. Code - HS_VldM24(,23) x x x x x x x x x x x x x x x x - GHB001 1 xxxxxx x - - - S A R - - - - - - GCY->GCY_ACITRA == "1" - - - N - - N N N - - - 1 2 - - - 79128 0
GCZ 86 GCZ_DESCNA C 50 0 Desc Nac Atv Cod.Nac.Act. Act.Nat.Desc Descricao Nac Atv Econ. Descripcion Nac.Act.Econ. Eco. Act. Nat. Descrip. @! - x x x x x x x x x x x x x x x x HS_INIPADR("GHB", 1, GCZ->GCZ_CDCCNA, "GHB_DESCNA") - 1 xxxxxx x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79129 0
GCZ 87 GCZ_TPVINC C 1 0 Tipo Vinculo Tipo Vinculo Bind type Tipo do Vinculo Tipo de Vinculo Bind type - - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - 1=Autonomo;2=Desempregado;3=Aposentado;4=Nao segurado;5=Empregado;6=Empregador 1=Autonomo;2=Desempleado;3=Jubilado;4=Sin seguro;5=Emplegado;6=Empleador 1=Autonomous;2=Unemployeed;3=Retired;4=Not insured;5=Employee;6=Employer - GCY->GCY_ACITRA == "1" - - - N - - N N N - - - 1 2 - - - 79130 0
GCZ 88 GCZ_RNNVIV N 2 0 Nasc. Vivo Nacido Vivo Born alive Nascido Vivo Nacido Vivo Born alive 99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - HS_VldM24(,24) - - - N - - N N N - - - 1 2 - - - 79131 0
GCZ 89 GCZ_RNNOBI N 2 0 Nasc. Mortos Nacido Muert Born dead Nascidos Mortos Nacidos Muertos Born dead 99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - HS_VldM24(,24) - - - N - - N N N - - - 1 2 - - - 79132 0
GCZ 90 GCZ_RNALTA N 2 0 Nasc. Alta Nacido Alta Newb. Disch Nascidos Alta Nacidos Alta Newborns Discharged 99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - HS_VldM24(,24) - - - N - - N N N - - - 1 2 - - - 79133 0
GCZ 91 GCZ_RNTRAN N 2 0 Nasc. Transf Nacido Trans Newborn Trfd Nascidos Transferidos Nacidos Transferidos Newborns Transferred 99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - HS_VldM24(,24) - - - N - - N N N - - - 1 2 - - - 79134 0
GCZ 92 GCZ_RNOBIT N 2 0 Obitos Obito Deaths Obitos Obitos Deaths 99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - HS_VldM24(,24) - - - N - - N N N - - - 1 2 - - - 79135 0
GCZ 93 GCZ_CPRAU1 C 10 0 Proced. Aut1 Proced. Aut1 Proced. Aut1 Proced. Autorizado 1 Proced. Autorizado 1 Proced. Authorized 1 - HS_VldM24(,26) x x x x x x x x x x x x x x x x - GA7 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79136 0
GCZ 94 GCZ_DPRAU1 C 50 0 Desc Pr Aut1 Desc Pr Aut1 Desc Pr Aut1 Desc. proced. Aut. 1 Desc. proced. Aut. 1 Desc. Proced. Aut. 1 @! - x x x x x x x x x x x x x x x x HS_INIPADR("GA7", 1, GCZ->GCZ_CPRAU1, "GA7_DESC") - 1 xxxxxx x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79137 0
GCZ 95 GCZ_CPRAU2 C 10 0 Proced. Aut2 Proced. Aut2 Proced. Aut2 Proced. Autorizado 2 Proced. Autorizado 2 Proced. Authorized 2 - HS_VldM24(,26) x x x x x x x x x x x x x x x x - GA7 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79138 0
GCZ 96 GCZ_DPRAU2 C 50 0 Desc Pr Aut2 Desc Pr Aut2 Desc Pr Aut2 Desc. Proced. Aut 2 Desc. Proced. Aut 2 Desc. Proced. Aut 2 @! - x x x x x x x x x x x x x x x x HS_INIPADR("GA7", 1, GCZ->GCZ_CPRAU2, "GA7_DESC") - 1 xxxxxx x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79139 0
GCZ 97 GCZ_CPRAU3 C 10 0 Proced. Aut3 Proced. Aut3 Proced. Aut3 Proced. Autorizado 3 Proced. Autorizado 3 Proced. Authorized 3 - HS_VldM24(,26) x x x x x x x x x x x x x x x x - GA7 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79140 0
GCZ 98 GCZ_DPRAU3 C 50 0 Desc Pr Aut3 Desc Pr Aut3 Desc Pr Aut3 Desc. Proced. Aut 3 Desc. Proced. Aut 3 Desc. Proced. Aut 3 @! - x x x x x x x x x x x x x x x x HS_INIPADR("GA7", 1, GCZ->GCZ_CPRAU3, "GA7_DESC") - 1 xxxxxx x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79141 0
GCZ 99 GCZ_CPRAU4 C 10 0 Proced. Aut4 Proced. Aut4 Proced. Aut4 Proced. Autorizado 4 Proced. Autorizado 4 Proced. Authorized 4 - HS_VldM24(,26) x x x x x x x x x x x x x x x x - GA7 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79142 0
GCZ A0 GCZ_DPRAU4 C 50 0 Desc Pr Aut4 Desc Pr Aut4 Desc Pr Aut4 Desc. Proced. Aut 4 Desc. Proced. Aut 4 Desc. Proced. Aut 4 @! - x x x x x x x x x x x x x x x x HS_INIPADR("GA7", 1, GCZ->GCZ_CPRAU4, "GA7_DESC") - 1 xxxxxx x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79143 0
GCZ A1 GCZ_CPRAU5 C 10 0 Proced. Aut5 Proced. Aut5 Proced. Aut5 Proced. Autorizado 5 Proced. Autorizado 5 Proced. Authorized 5 - HS_VldM24(,26) x x x x x x x x x x x x x x x x - GA7 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79144 0
GCZ A2 GCZ_DPRAU5 C 50 0 Desc Pr Aut5 Desc Pr Aut5 Desc Pr Aut5 Desc. Proced. Aut 5 Desc. Proced. Aut 5 Desc. Proced. Aut.5 @! - x x x x x x x x x x x x x x x x HS_INIPADR("GA7", 1, GCZ->GCZ_CPRAU5, "GA7_DESC") - 1 xxxxxx x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79145 0
GCZ A3 GCZ_DIASAC N 2 0 Acomp. Dias Acomp. Dias Comp. Days Acompanhante Dias Acompañante Dias Companion Days 99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79146 0
GCZ A4 GCZ_DTADIA D 8 0 Data Acomp. Fc.Acomp. Compan. Date Data Acompanhante Fecha Acompañante Companion Date - - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79147 0
GCZ A5 GCZ_CPFAUD C 11 0 CPF Auditor CPF Auditor CPF Auditor CPF do Auditor CPF del Auditor CPF of Auditor @R 999.999.999-99 Vazio() .or. CGC(M->GCZ_CPFAUD) x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79148 0
GCZ A6 GCZ_MESINI N 2 0 Mes Inicial Mes Inicial Initial mont Mes Inicial Mes Inicial Initial month 99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79149 0
GCZ A7 GCZ_MESANT N 2 0 Mes Anterior Mes Anterior Prev. month Mes Anterior Mes Anterior Previous month 99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79150 0
GCZ A8 GCZ_MESALT N 2 0 Mes Alta Mes Alta Disch Month Mes Alta Mes Alta DIscharge Month 99 Positivo() x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79151 0
GCZ A9 GCZ_IDAUTE C 1 0 Aut. Espec. Aut. Espec. Spec. Auth. Autorizacao Especial Autorizacion Especial Special Authorization - Pertence("01") x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - 0=Nao;1=Sim 0=No;1=Si 0=No;1=Yes - - - - - N - - N N N - - - 1 2 - - - 79152 0
GCZ B0 GCZ_CPFGES C 11 0 CPF Gestor CPF Gestor CPF Manager CPF do Gestor CPF del Gestor CPF of Manager @R 999.999.999-99 Vazio() .or. CGC(M->GCZ_CPFGES) x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79153 0
GCZ B1 GCZ_CODAUT C 1 0 Cod. Autoriz Cod. Autoriz Author. Code Codigo Autorizacao Codigo Autorizacion Authorization Code - - x x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - S A R - - 1=Tempo Permanencia a Menor;2=Idade Menor;3=Idade Menor;4=Tempo de Permanecia e Idade 1=Tiempo Permanencia a Menor;2=Edad Menor;3=Edad Menor;4=Tiempo de Permanencia y Edad 1=Permanence Time of Minor;2=Minor Age;3=Minor Age;4=Permanence Time and Age - - - - - N - - N N N - - - 1 2 - - - 79154 0
GCZ B2 GCZ_TPNOTA C 3 0 Tipo Tipo Type Tipo da Nota Tipo de Factura Invoice type - - x x x x x x x x x x x x x x x - - 1 xxxxxx x - - - N A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 79155 0
GCZ B3 GCZ_PRCTIT C 2 0 Parcela Tit. Cuota Tit. Bill Inst. Parcela do Título Cuota del Título Bill Installment @! - x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - 011 - N - - N N N - - - 1 2 - - - 79156 0
GCZ B4 GCZ_NDGUIA C 8 0 Nro Document Nro Document Document No Nro documento/guia ident Nro documento/guia ident Document No/Ident. Form 99999999 - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79157 0
GCZ B5 GCZ_CODDES C 10 0 Cod Serv/Pri Cod Serv/Pri Main srv. cd Código Serviço Principal Codigo Servicio Principal Main service code @! HS_VldM24(,34) x x x x x x x x x x x x x x x x - GA7 1 x x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79158 0
GCZ B6 GCZ_DDESPE C 30 0 Descrição Descripcion Description Descrição do Procedimento Descripcion de Procedim Procedure Description @! - x x x x x x x x x x x x x x x x HS_IniPadR('GA7', 1, GCZ->GCZ_CODDES, 'GA7_DESC') - 1 x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79159 0
GCZ B7 GCZ_CODPRT C 10 0 Cód. Proprio Cod. Propro Own Code Cód. Próprio do Convênio Cod. Propro de Convenio Own Insurance Code @! - x x x x x x x x x x x x x x x x - - 1 x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79160 0
GCZ B8 GCZ_TATISS C 2 0 Tp. Atend. Tp. Atenc. Attend. Tp. Código Tipo Atendimento Codigo Tipo Atencion Code of Attendance Type @! HS_VldM24(,35) x x x x x x x x x x x x x x x x - G08001 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79161 0
GCZ B9 GCZ_DTATIS C 30 0 Desc Tp Aten Desc Tp Aten Care Tp Desc Descrição do Tipo Atend. Descripcion do Tipo Atenc Care Type Description @! - x x x x x x x x x x x x x x x x HS_IniPadR('G08', 1, GCZ->GCZ_TATISS, 'G08_DESCRI') - 1 x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79162 0
GCZ C0 GCZ_TIPCON C 1 0 Tipo Consult Tipo Consult Appoint. Tp. Código do Tipo Consulta Codigo del Tipo Consulta Code of Appoint. Type @! HS_VldM24(,36) x x x x x x x x x x x x x x x x - G12001 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79163 0
GCZ C1 GCZ_DTIPCO C 30 0 Desc Tp Cons Desc Tp Cons App.Tp.Desc. Descrição Tipo Consulta Descripcion Tipo Consulta Appointment Type Desc. @! - x x x x x x x x x x x x x x x x HS_IniPadR('G12', 1, GCZ->GCZ_TIPCON, 'G12_DESCRI') - 1 x - - - S V V - - - - - - - - - - N - - N N N - - - 1 2 - - - 79164 0
GCZ C2 GCZ_TPAPAC C 1 0 Tipo APAC Tipo APAC APAC Type Tipo Atend. APAC Tipo Atencion APAC APAC Service Type @! HS_VLDM24(,39) x x x x x x x x x x x x x x x x '1' - 1 x - - - S A R - - 1=Inicial;2=ContinuaþÒo;3=?nica 1=Inicial;2=Continuacion;3=Unica 1=Initial;2=Continuation;3=Single - - - - - N - - N N N - - - 1 2 - - - 79165 0
GCZ C3 GCZ_CMCPAC C 2 0 Motiv. Cobr. Motiv. Cobr. Coll. Reason Código Motiv. Cobr. APAC Codigo Motiv. Cobr. APAC APAC Coll. Reason Code @! HS_SeekRet('GH7','M->GCZ_CMCPAC',1,.F.,'GD7_DMCPAC') x x x x x x x x x x x x x x x x - GH7001 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79166 0
GCZ C4 GCZ_VGUIAI D 8 0 Dt. Ini. Vld Fc Ini Vld Eff. Str Dt Data Inicial da Validade Fecha Inicial de Validez Effective Start Date - HS_VLDM24(, 39) x x x x x x x x x x x x x x x x IIF(!EMPTY(M->GCY_DATATE),M->GCY_DATATE,dDATABASE()) - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79167 0
GCZ C5 GCZ_VGUIAF D 8 0 Dt. Vld. Fim Fc. Vld. Fim Eff. End Dt Data de Validade Final Fecha de Validez Final Effective Final Date - HS_VLDM24(, 39) x x x x x x x x x x x x x x x x HS_InVGuF() - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79168 0
GCZ C6 GCZ_TDTISS C 1 0 Tp. Doença Tp. Enferm. Disease type Tipo de Doença Tipo de Enfermedad Disease type - Pertence('01') x x x x x x x x x x x x x x x x '0' - 1 x - - - S A R - - 0=Aguda;1=Cronica 0=Aguda;1=Cronica 0=Acute;1=Chronic - - - - - N - - N N N - - - 1 2 - - - 79169 0
GCZ C7 GCZ_ALTGUI C 1 0 Alt. Nr. Gui Mod.Nro.Form Edit Frm Nbr Altera Nr Guia Modifica numero formulari Edit Form Number @! Pertence('01') x x x x x x x x x x x x x x x "1" - 1 x - - - N V R - - 0=Nao;1=Sim 0=No;1=Si 0=No;1=Yes - - - - - N - - N N N - - - 1 2 - - - 79170 0
GCZ C8 GCZ_NRORES C 6 0 Nro Res. At. Nº Res. At. Att. Sum Nbr No Resumo Atendimento Nº Resumen Atencion Attendance Summary Number @! - x x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79171 0
GCZ C9 GCZ_RNVPRE N 2 0 RN Prematuro RN Prematuro NB Premature Qtd nasc vivos prematuros Cant nac vivos prematuro Nbr.of premature liveborn 99 Positivo() x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79172 0
GCZ D0 GCZ_OBNEOP N 2 0 Obt Neo Prec Obt Neo Prec Ear.neo.deat Obito neonatal precoce Obito neonatal precoz Early neonatal death 99 Positivo() x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79173 0
GCZ D1 GCZ_OBNEOT N 2 0 Obt Neo Tard Obt Neo Tard Lat.neo.deat Obito neonatal tardio Obito neonatal tardio Late neonatal death 99 Positivo() x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79174 0
GCZ D2 GCZ_TPALTA C 2 0 Tipo da Alta Tipo de Alta Disch. Type Codigo do Tipo da Alta Codigo del Tipo de Alta Discharge Type Code @! HS_SeekRet('GF4','M->GCZ_TPALTA',1,.f.,'GCZ_DESALT','GF4_DSTPAL') x x x x x x x x x x x x x x x x - GF4 1 x - - - S A R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79175 0
GCZ D3 GCZ_DESALT C 30 0 Desc Tp Alta Desc Tp Alta Disch.Tp.Des Descricao do Tipo da Alta Descrip del Tipo de Alta Discharge Type Descript. @! HS_IniPadr('GF4', 1, GCZ->GCZ_TPALTA, 'GF4_DSTPAL') x x x x x x x x x x x x x x x x HS_IniPadr('GF4', 1, GCZ->GCZ_TPALTA, 'GF4_DSTPAL') - 1 x - - - S V V - - - - - - - HS_IniPadr('GF4', 1, GCZ->GCZ_TPALTA, 'GF4_DSTPAL') - - N - - N N N - - - 1 2 - - - 79176 0
GCZ D4 GCZ_TIPAIH C 1 0 Tp Atend AIH Tp Atenc AIH AIH Serv.Tp. Tipo Atendimento AIH Tipo Atencion AIH AIH Service Type @! Pertence("123") x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - 1=AIH Principal;3=AIH de Continuacao;5=AIH Longa Permanencia 1=AIH Principal;3=AIH de Continuacion;5=AIH Larga Permanencia 1=Main AIH;3=AIH of Continuation;5=Long Staying AIH - - - - - S - - N N N - - - 1 2 - - - 79177 0
GCZ D5 GCZ_NUMAIH C 13 0 Numero AIH Numero AIH AIH Number Numero da AIH Numero de la AIH Number of AIH (Aut.Hosp.) @! HS_VldM24(,46) x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 79178 0
GCZ D6 GCZ_MDPROC C 1 0 Mud. Proc. Camb. Proc Proced.Chan. Mudanca Proced. Cambio Procedimiento Proced.Change - Pertence("01") x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - 0=Nao;1=Sim 0=No;1=Si 0=No;1=Yes - - - - - S - - N N N - - - 1 2 - - - 79179 0
GCZ D7 GCZ_SISAIH C 11 0 SISPRENAT SISPRENAT PRENATAL SISPRENATAL AIH SISPRENATAL AIH AIH PRENATAL @! - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N N N - - - 1 2 - - - 79180 0
GCZ D8 GCZ_CRMAUT C 7 0 Med Autoriz Med Autoriz Auth. Doctor Medico Autorizador Medico Autorizador Authorizing Doctor @! HS_VldM24(,17) x x x x x x x x x x x x x x x x - MED 1 x - - - S A R - - - - - - - - - - N - - S N N - - - 1 2 - - - 79181 0
GCZ D9 GCZ_MEDAUT C 30 0 Nome Autoriz Nombre Autor Name Auth. Nome Medico Autorizador Nombre Medico Autoriza Name of doctor who auth. @! - x x x x x x x x x x x x x x x x - - 1 x - - - S V V - - - - - - - HS_INIPADR('SRA', 11, GCZ->GCZ_CRMAUT,'RA_NOME',,.F.) - - N - - S N N - - - 1 2 - - - 79182 0
GCZ E0 GCZ_SEQSES C 5 0 Seq. Sessão Sec. Sesion Session Seq. Sequencia da Sessao Agen. Secuencia Sesion Program. Sched. Session Sequence @! - x x x x x x x x x x x x x x x x - - 1 x - - - S V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79183 0
GCZ E1 GCZ_NRGGLO C 6 0 Nr.Guia.Glo. Nr.Guia.Glo. Disal.Form N Nro Seq da Guia Glosada Nro Sec de Guia Glosada Seq.No. of Form Disallowe @! - x x x x x x x x x x x x x x x x - - 1 x - - - N V R - - - - - - - - - - N - - N N N - - - 1 2 - - - 79184 0
GCZ E2 GCZ_GUIAOP C 20 0 Nro Guia Ope Num Form Ope Ope Form Nr Nro da Guia Atribuido pel Num de Formul. Atribuido Pel Attrib Form Nr. @! - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 79185 0
GCZ E3 GCZ_DTSUGE D 8 0 Dt. Sug. Int Fc. Sug. Int Int Sug Dt Data Sugerida de Internaç Fecha Sugerida Internac. Hosp Adm. Suggested Date - - x x x x x x x x x x x x x x x x - - 1 x - - - S A R - - - - - - - - - - S - - N - N - - - 1 2 - - - 79186 0
GCZ E4 GCZ_USOOPM C 1 0 Prev uso OPM Prev uso OPM OPM use Frcs Previsão de uso de OPME Prevision uso de OPME OPME use forecast @! - x x x x x x x x x x x x x x x x 'N' - 1 x - - - S A R - - N=Não;S=Sim N=No;S=Si N=No;S=Yes - - - - - S - - N - N - - - 1 2 - - - 79187 0
GCZ E5 GCZ_USOQUI C 1 0 Prev. Quim. Prev. Quim. Quim Frcst Previsão de uso de Quimio Prevision uso de Quimiot. Chemotherapy use forecast @! - x x x x x x x x x x x x x x x x 'N' - 1 x - - - S A R - - N=Não;S=Sim N=No;S=Si N=No;S=Yes - - - - - S - - N - N - - - 1 2 - - - 79188 0
GCZ E6 GCZ_DECOBT C 11 0 Dec Obito Dec óbito Death St. Declaração de óbito RN Declaración de óbito RN RN death statement - - x x x x x x x x x x x x x x x - - 1 - - - - - - - - - - - - - - - - - S - - N - N - - - 1 2 - - - 79189 0
GCZ E7 GCZ_IOBTRN C 1 0 Ind Obito RN Ind Obito RN RN Death Ind Indicação òbito do RN Indicación óbito del RN RN death indication - - x x x x x x x x x x x x x x x - - 1 - - - - - - - - - N=Não;S=Sim N=No;S=Sí N=No;S=Yes - - - - - S - - N - N - - - 1 2 - - - 79190 0
GCZ E8 GCZ_CIDOBT C 4 0 Motivo óbito Motivo óbito Death Reason Cid òbito Cid óbito Death ICD - - x x x x x x x x x x x x x x x - - 1 - - - - - - - - - - - - - - - - - S - - N - N - - - 1 2 - - - 79191 0
GCZ E9 GCZ_DECVIV C 11 0 Dec Nas vivo Dec Nac vivo Born alive Declaração nascido vivo Declaración nacido vivo Born Alive Statement - - x x x x x x x x x x x x x x x - - 1 - - - - - - - - - - - - - - - - - S - - N - N - - - 1 2 - - - 79192 0

Índices da Tabela GCZ (27 índices)

INDICE ORDEM CHAVE DESCRICAO DESCSPA DESCENG PROPRI F3 NICKNAME SHOWPESQ IX_VIRTUAL IX_VIRCUST D_E_L_E_T_ R_E_C_N_O_ R_E_C_D_E_L_
GCZ 1 GCZ_FILIAL+GCZ_NRSEQG+GCZ_STATUS Nro.Seq.Guia + Status Nro.Sec.Form + Estatus Form.Seq.No. + Status S - - S 2 3 - 11596 0
GCZ 2 GCZ_FILIAL+GCZ_REGATE+GCZ_STATUS+GCZ_NRSEQG Reg. Atendim + Status + Nro.Seq.Guia Reg. Atencio + Estatus + Nro.Sec.Form Attend. Rec. + Status + Form.Seq.No. S - - N 2 3 - 11597 0
GCZ 3 GCZ_FILIAL+GCZ_STATUS+GCZ_NRLOTE+GCZ_REGGER Status + Numero Lote + Prontuario Estatus + Numero Lote + Hist Clin pa Status + Lot No. + Med. Record S - - N 2 3 - 11598 0
GCZ 4 GCZ_FILIAL+GCZ_STATUS+GCZ_REGGER Status + Prontuario Estatus + Hist Clin pa Status + Med. Record S - - S 2 3 - 11599 0
GCZ 5 GCZ_FILIAL+GCZ_NREXTC+GCZ_NRSEQG Ext.Convenio + Nro.Seq.Guia Ext.Convenio + Nro.Sec.Form H.Care Stat + Form.Seq.No. S - - S 2 3 - 11600 0
GCZ 6 GCZ_FILIAL+GCZ_STATUS+GCZ_NRSEQG Status + Nro.Seq.Guia Estatus + Nro.Sec.Form Status + Form.Seq.No. S - - S 2 3 - 11601 0
GCZ 7 GCZ_FILIAL+GCZ_NRPROT Nro. Protoco Nº Protoco Enroll.No. S - - S 2 3 - 11602 0
GCZ 8 GCZ_FILIAL+GCZ_NRLOTE+GCZ_NRGUIA Numero Lote + Nro. Guia Numero Lote + Nro.Form. Lot No. + Guide Nbr. S - - S 2 3 - 11603 0
GCZ 9 GCZ_FILIAL+GCZ_STATUS+GCZ_REGATE+GCZ_CODCON+GCZ_CODPLA Status + Reg. Atendim + Cod Convenio + Plano Estatus + Reg. Atencio + Cod.Convenio + Plan Status + Attend. Rec. + Code of Heal + Health plan S - - S 2 3 - 11604 0
GCZ A GCZ_FILIAL+GCZ_STATUS+GCZ_CODCON+DTOS(GCZ_DATFAT) Status + Cod Convenio + Data Estatus + Cod.Convenio + Fecha Status + Code of Heal + Date S - - S 2 3 - 11605 0
GCZ B GCZ_FILIAL+GCZ_REGGER Prontuario Hist Clin pa Med. Record S - - S 2 3 - 11606 0
GCZ C GCZ_FILIAL+GCZ_STATUS+GCZ_NREXTC Status + Ext.Convenio Estatus + Ext.Convenio Status + H.Care Stat S - - S 2 3 - 11607 0
GCZ D GCZ_FILIAL+GCZ_CODPLA+GCZ_REGGER Plano + Prontuario Plan + Hist Clin pa Health plan + Med. Record S - - S 2 3 - 11608 0
GCZ E GCZ_FILIAL+GCZ_NUMORC+GCZ_NRGUIA Num. Orcam. + Nro. Guia Num. Presup. + Nro.Form. Budge. No. + Guide Nbr. S - - S 2 3 - 11609 0
GCZ F GCZ_FILIAL+GCZ_REGATE+GCZ_CODTPG Reg. Atendim + Tipo de guia Reg. Atencio + Tipo de Form Attend. Rec. + Guide Typ Co S - - S 2 3 - 11610 0
GCZ G GCZ_FILIAL+GCZ_IDMARC+GCZ_NRSEQG Id. Marca + Nro.Seq.Guia Id. Marca + Nro.Sec.Form Brand ID + Form.Seq.No. S - - S 2 3 - 11611 0
GCZ H GCZ_FILIAL+GCZ_NOME Nome Pacient Nomb pacient Pat. Name S - - S 2 3 - 11612 0
GCZ I GCZ_FILIAL+GCZ_NRNOTA+GCZ_SERIE Nota Fiscal + Serie Nota Factura + Serie Factur Invoice + Invoice Seri S - - S 2 3 - 11613 0
GCZ J GCZ_FILIAL+GCZ_CDCCNA Cod. Nac Atv Cod.Nac.Act. Nat. Act. Cd S - - S 2 3 - 11614 0
GCZ K GCZ_FILIAL+GCZ_CDCBOR Cod. Oficio Cod. Oficio Activ.Code S - - S 2 3 - 11615 0
GCZ L GCZ_FILFAT+GCZ_NRLOTE+GCZ_NRGUIA Fil. Faturam + Numero Lote + Nro. Guia Suc Factur + Numero Lote + Nro.Form. Inv. Branch + Lot No. + Guide Nbr. S - - S 2 3 - 11616 0
GCZ M GCZ_FILFAT+GCZ_NRNOTA+GCZ_SERIE Fil. Faturam + Nota Fiscal + Serie Nota Suc Factur + Factura + Serie Factur Inv. Branch + Invoice + Invoice Seri S - - S 2 3 - 11617 0
GCZ N GCZ_FILFAT+GCZ_STATUS+GCZ_NRLOTE Fil. Faturam + Status + Numero Lote Suc Factur + Estatus + Numero Lote Inv. Branch + Status + Lot No. S - - S 2 3 - 11618 0
GCZ O GCZ_FILIAL+GCZ_CODCON+DTOS(GCZ_DATATE)+GCZ_LOCATE+GCZ_ATENDI+GCZ_CANCEL Cod Convenio + Data Atendto + Setor Atend. + Tipo Atendto + Cancelado? Cod.Convenio + Fecha Atenc + Sector Atenc + Tp. Atencion + ¿Anulado? Code of Heal + Attend. Date + Serv. Sector + Serv. type + Cancelled S - - S 2 3 - 11619 0
GCZ P GCZ_FILFAT+GCZ_NREXTC+GCZ_NRSEQG Fil. Faturam + Ext.Convenio + Nro.Seq.Guia Suc Factur + Ext.Convenio + Nro.Sec.Form Inv. Branch + H.Care Stat + Form.Seq.No. S - - S 2 3 - 11620 0
GCZ Q GCZ_FILIAL+GCZ_NUMAIH Numero AIH Numero AIH AIH Number S - - S 2 3 - 11621 0
GCZ R GCZ_FILIAL+GCZ_LOCATE Setor Atend. Sector Atenc Serv. Sector S - - S 2 3 - 11622 0

Perguntas frequentes

Para que serve a tabela GCZ no Protheus?

Ela é utilizada para guias de atendimentos dentro do sistema ERP Protheus.

Como consultar os campos da tabela GCZ?

Nesta página você pode visualizar todos os campos, incluindo tipo, tamanho e validações.

O que são os índices da tabela GCZ?

Os índices são estruturas que melhoram a performance de busca e acesso aos dados dentro do Protheus.

Exemplo de consulta SQL da tabela GCZ

Modelo de query gerado automaticamente com base na estrutura da tabela. 

SELECT
    GCZ_FILIAL,
    GCZ_REGATE,
    GCZ_DATATE,
    GCZ_REGGER,
    GCZ_NOME,
    GCZ_MATRIC,
    GCZ_CODTPG,
    GCZ_DESTPG,
    GCZ_CODCON,
    GCZ_CODPLA,
    GCZ_DESPLA,
    GCZ_SQCATP,
    GCZ_DSCATP,
    GCZ_NRGUIA,
    GCZ_NRSEN1,
    GCZ_NRSEN2,
    GCZ_NRSEN3,
    GCZ_QTDIAS,
    GCZ_CODCRM,
    GCZ_NOMMED,
    GCZ_GUIAPR,
    GCZ_DATAUT,
    GCZ_VALSEN,
    GCZ_DTGUIA,
    GCZ_DATSOL,
    GCZ_HORSOL,
    GCZ_CIDSOL,
    GCZ_INDCLI,
    GCZ_TEDVLR,
    GCZ_TEDUND,
    GCZ_IATISS,
    GCZ_OBSTIS,
    GCZ_IDMARC,
    GCZ_NRFATU,
    GCZ_DATFAT,
    GCZ_HORFAT,
    GCZ_NRLOTE,
    GCZ_NREXTC,
    GCZ_FILFAT,
    GCZ_FILATE,
    GCZ_STATUS,
    GCZ_NMFFAT,
    GCZ_NRPROT,
    GCZ_DATSTA,
    GCZ_VALPAG,
    GCZ_VALGLO,
    GCZ_VLPAGM,
    GCZ_VLGLOM,
    GCZ_VLPAGT,
    GCZ_VLGLOT,
    GCZ_VLPAGP,
    GCZ_VLGLOP,
    GCZ_VALREC,
    GCZ_VALPER,
    GCZ_VLRECM,
    GCZ_VLPERM,
    GCZ_VLRECT,
    GCZ_VLPERT,
    GCZ_VLRECP,
    GCZ_VLPERP,
    GCZ_NUMORC,
    GCZ_SERIE,
    GCZ_NRNOTA,
    GCZ_VLGUIA,
    GCZ_NRSEQG,
    GCZ_NRRPT1,
    GCZ_DTRPT1,
    GCZ_CANCEL,
    GCZ_LOGARQ,
    GCZ_DTGERA,
    GCZ_HRGERA,
    GCZ_USGERA,
    GCZ_ATENDI,
    GCZ_LOCATE,
    GCZ_CTAPAR,
    GCZ_DCPARI,
    GCZ_CMCAIH,
    GCZ_DCPARF,
    GCZ_DMCAIH,
    GCZ_IDGUIA,
    GCZ_AIHANT,
    GCZ_AIHPOS,
    GCZ_CDCBOR,
    GCZ_DSCBOR,
    GCZ_CDCCNA,
    GCZ_DESCNA,
    GCZ_TPVINC,
    GCZ_RNNVIV,
    GCZ_RNNOBI,
    GCZ_RNALTA,
    GCZ_RNTRAN,
    GCZ_RNOBIT,
    GCZ_CPRAU1,
    GCZ_DPRAU1,
    GCZ_CPRAU2,
    GCZ_DPRAU2,
    GCZ_CPRAU3,
    GCZ_DPRAU3,
    GCZ_CPRAU4,
    GCZ_DPRAU4,
    GCZ_CPRAU5,
    GCZ_DPRAU5,
    GCZ_DIASAC,
    GCZ_DTADIA,
    GCZ_CPFAUD,
    GCZ_MESINI,
    GCZ_MESANT,
    GCZ_MESALT,
    GCZ_IDAUTE,
    GCZ_CPFGES,
    GCZ_CODAUT,
    GCZ_TPNOTA,
    GCZ_PRCTIT,
    GCZ_NDGUIA,
    GCZ_CODDES,
    GCZ_DDESPE,
    GCZ_CODPRT,
    GCZ_TATISS,
    GCZ_DTATIS,
    GCZ_TIPCON,
    GCZ_DTIPCO,
    GCZ_TPAPAC,
    GCZ_CMCPAC,
    GCZ_VGUIAI,
    GCZ_VGUIAF,
    GCZ_TDTISS,
    GCZ_ALTGUI,
    GCZ_NRORES,
    GCZ_RNVPRE,
    GCZ_OBNEOP,
    GCZ_OBNEOT,
    GCZ_TPALTA,
    GCZ_DESALT,
    GCZ_TIPAIH,
    GCZ_NUMAIH,
    GCZ_MDPROC,
    GCZ_SISAIH,
    GCZ_CRMAUT,
    GCZ_MEDAUT,
    GCZ_SEQSES,
    GCZ_NRGGLO,
    GCZ_GUIAOP,
    GCZ_DTSUGE,
    GCZ_USOOPM,
    GCZ_USOQUI,
    GCZ_DECOBT,
    GCZ_IOBTRN,
    GCZ_CIDOBT,
    GCZ_DECVIV
FROM GCZ
WHERE
    D_E_L_E_T_ = ' '
    AND GCZ_FILIAL = 'VALOR'
    AND GCZ_REGATE = 'VALOR'
    AND GCZ_DATATE BETWEEN '20261001' AND '20261031'
    AND GCZ_REGGER = 'VALOR'
    AND GCZ_NOME = 'VALOR'
    AND GCZ_MATRIC = 'VALOR'
    AND GCZ_CODTPG = 'VALOR'
    AND GCZ_DESTPG = 'VALOR'
    AND GCZ_CODCON = 'VALOR'
    AND GCZ_CODPLA = 'VALOR'
    AND GCZ_DESPLA = 'VALOR'
    AND GCZ_SQCATP = 'VALOR'
    AND GCZ_DSCATP = 'VALOR'
    AND GCZ_NRGUIA = 'VALOR'
    AND GCZ_NRSEN1 = 'VALOR'
    AND GCZ_NRSEN2 = 'VALOR'
    AND GCZ_NRSEN3 = 'VALOR'
    AND GCZ_QTDIAS = 0
    AND GCZ_CODCRM = 'VALOR'
    AND GCZ_NOMMED = 'VALOR'
    AND GCZ_GUIAPR = 'VALOR'
    AND GCZ_DATAUT BETWEEN '20261001' AND '20261031'
    AND GCZ_VALSEN BETWEEN '20261001' AND '20261031'
    AND GCZ_DTGUIA BETWEEN '20261001' AND '20261031'
    AND GCZ_DATSOL BETWEEN '20261001' AND '20261031'
    AND GCZ_HORSOL = 'VALOR'
    AND GCZ_CIDSOL = 'VALOR'
    AND GCZ_INDCLI = 'VALOR'
    AND GCZ_TEDVLR = 0
    AND GCZ_TEDUND = 'VALOR'
    AND GCZ_IATISS = 'VALOR'
    AND GCZ_OBSTIS = 'VALOR'
    AND GCZ_IDMARC = 'VALOR'
    AND GCZ_NRFATU = 'VALOR'
    AND GCZ_DATFAT BETWEEN '20261001' AND '20261031'
    AND GCZ_HORFAT = 'VALOR'
    AND GCZ_NRLOTE = 'VALOR'
    AND GCZ_NREXTC = 'VALOR'
    AND GCZ_FILFAT = 'VALOR'
    AND GCZ_FILATE = 'VALOR'
    AND GCZ_STATUS = 'VALOR'
    AND GCZ_NMFFAT = 'VALOR'
    AND GCZ_NRPROT = 'VALOR'
    AND GCZ_DATSTA BETWEEN '20261001' AND '20261031'
    AND GCZ_VALPAG = 0
    AND GCZ_VALGLO = 0
    AND GCZ_VLPAGM = 0
    AND GCZ_VLGLOM = 0
    AND GCZ_VLPAGT = 0
    AND GCZ_VLGLOT = 0
    AND GCZ_VLPAGP = 0
    AND GCZ_VLGLOP = 0
    AND GCZ_VALREC = 0
    AND GCZ_VALPER = 0
    AND GCZ_VLRECM = 0
    AND GCZ_VLPERM = 0
    AND GCZ_VLRECT = 0
    AND GCZ_VLPERT = 0
    AND GCZ_VLRECP = 0
    AND GCZ_VLPERP = 0
    AND GCZ_NUMORC = 'VALOR'
    AND GCZ_SERIE = 'VALOR'
    AND GCZ_NRNOTA = 'VALOR'
    AND GCZ_VLGUIA = 0
    AND GCZ_NRSEQG = 'VALOR'
    AND GCZ_NRRPT1 = 'VALOR'
    AND GCZ_DTRPT1 BETWEEN '20261001' AND '20261031'
    AND GCZ_CANCEL = 'VALOR'
    AND GCZ_LOGARQ = 'VALOR'
    AND GCZ_DTGERA BETWEEN '20261001' AND '20261031'
    AND GCZ_HRGERA = 'VALOR'
    AND GCZ_USGERA = 'VALOR'
    AND GCZ_ATENDI = 'VALOR'
    AND GCZ_LOCATE = 'VALOR'
    AND GCZ_CTAPAR = 0
    AND GCZ_DCPARI BETWEEN '20261001' AND '20261031'
    AND GCZ_CMCAIH = 'VALOR'
    AND GCZ_DCPARF BETWEEN '20261001' AND '20261031'
    AND GCZ_DMCAIH = 'VALOR'
    AND GCZ_IDGUIA = 'VALOR'
    AND GCZ_AIHANT = 'VALOR'
    AND GCZ_AIHPOS = 'VALOR'
    AND GCZ_CDCBOR = 'VALOR'
    AND GCZ_DSCBOR = 'VALOR'
    AND GCZ_CDCCNA = 'VALOR'
    AND GCZ_DESCNA = 'VALOR'
    AND GCZ_TPVINC = 'VALOR'
    AND GCZ_RNNVIV = 0
    AND GCZ_RNNOBI = 0
    AND GCZ_RNALTA = 0
    AND GCZ_RNTRAN = 0
    AND GCZ_RNOBIT = 0
    AND GCZ_CPRAU1 = 'VALOR'
    AND GCZ_DPRAU1 = 'VALOR'
    AND GCZ_CPRAU2 = 'VALOR'
    AND GCZ_DPRAU2 = 'VALOR'
    AND GCZ_CPRAU3 = 'VALOR'
    AND GCZ_DPRAU3 = 'VALOR'
    AND GCZ_CPRAU4 = 'VALOR'
    AND GCZ_DPRAU4 = 'VALOR'
    AND GCZ_CPRAU5 = 'VALOR'
    AND GCZ_DPRAU5 = 'VALOR'
    AND GCZ_DIASAC = 0
    AND GCZ_DTADIA BETWEEN '20261001' AND '20261031'
    AND GCZ_CPFAUD = 'VALOR'
    AND GCZ_MESINI = 0
    AND GCZ_MESANT = 0
    AND GCZ_MESALT = 0
    AND GCZ_IDAUTE = 'VALOR'
    AND GCZ_CPFGES = 'VALOR'
    AND GCZ_CODAUT = 'VALOR'
    AND GCZ_TPNOTA = 'VALOR'
    AND GCZ_PRCTIT = 'VALOR'
    AND GCZ_NDGUIA = 'VALOR'
    AND GCZ_CODDES = 'VALOR'
    AND GCZ_DDESPE = 'VALOR'
    AND GCZ_CODPRT = 'VALOR'
    AND GCZ_TATISS = 'VALOR'
    AND GCZ_DTATIS = 'VALOR'
    AND GCZ_TIPCON = 'VALOR'
    AND GCZ_DTIPCO = 'VALOR'
    AND GCZ_TPAPAC = 'VALOR'
    AND GCZ_CMCPAC = 'VALOR'
    AND GCZ_VGUIAI BETWEEN '20261001' AND '20261031'
    AND GCZ_VGUIAF BETWEEN '20261001' AND '20261031'
    AND GCZ_TDTISS = 'VALOR'
    AND GCZ_ALTGUI = 'VALOR'
    AND GCZ_NRORES = 'VALOR'
    AND GCZ_RNVPRE = 0
    AND GCZ_OBNEOP = 0
    AND GCZ_OBNEOT = 0
    AND GCZ_TPALTA = 'VALOR'
    AND GCZ_DESALT = 'VALOR'
    AND GCZ_TIPAIH = 'VALOR'
    AND GCZ_NUMAIH = 'VALOR'
    AND GCZ_MDPROC = 'VALOR'
    AND GCZ_SISAIH = 'VALOR'
    AND GCZ_CRMAUT = 'VALOR'
    AND GCZ_MEDAUT = 'VALOR'
    AND GCZ_SEQSES = 'VALOR'
    AND GCZ_NRGGLO = 'VALOR'
    AND GCZ_GUIAOP = 'VALOR'
    AND GCZ_DTSUGE BETWEEN '20261001' AND '20261031'
    AND GCZ_USOOPM = 'VALOR'
    AND GCZ_USOQUI = 'VALOR'
    AND GCZ_DECOBT = 'VALOR'
    AND GCZ_IOBTRN = 'VALOR'
    AND GCZ_CIDOBT = 'VALOR'
    AND GCZ_DECVIV = 'VALOR'