| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GE7 | Faturamento (Pro/Hon) Paciente | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| GE7_FILIAL | C | 2 | 0 | Filial | N | ||||||
| GE7_CODLOC | C | 2 | 0 | Setor | @! | HS_VldP12() | GCS | R | N | ||
| GE7_NOMLOC | C | 30 | 0 | Descricao | @! | V | N | ||||
| GE7_DATDES | D | 8 | 0 | Data | @D | R | N | ||||
| GE7_HORDES | C | 5 | 0 | Hora | 99:99 | R | N | ||||
| GE7_QTDDES | N | 10 | 4 | Quantidade | @E 99,999.9999 | HS_VQtdPr(M->GE7_QTDDES) | R | N | |||
| GE7_CODDES | C | 10 | 0 | Procedimento | @! | HS_VldM24(, 38) .And. HSPBPATRIG("GE7","CODDES") | GA7 | R | N | ||
| GE7_DDESPE | C | 30 | 0 | Descricao | @! | V | N | ||||
| GE7_CODCRM | C | 7 | 0 | CRM | @! | HS_VldM24(, 17) .And. HSPBPATRIG("GE7","CODCRM") | GHCPRO | R | HS_M24WHEN("GE7_CODCRM") | N | |
| GE7_NOMMED | C | 30 | 0 | Nome | @! | V | N | ||||
| GE7_CODATO | C | 2 | 0 | Ato | 99 | HS_VldM24(, 18) | GMC | R | N | ||
| GE7_DESATO | C | 20 | 0 | Descricao | @! | V | N | ||||
| GE7_CODVIA | C | 6 | 0 | Via acesso | @! | HS_VldM24(, 10) | GE4 | R | N | ||
| GE7_DESVIA | C | 20 | 0 | Descricao | @! | V | N | ||||
| GE7_COEDES | N | 5 | 2 | Coef.Despesa | @E 99.99 | R | N | ||||
| GE7_COEFAM | N | 5 | 2 | Coef.Ato Med | @E 99.99 | R | N | ||||
| GE7_VALDES | N | 10 | 4 | Preco | @E 99,999.9999 | HS_CalcDsc() | R | N | |||
| GE7_DESPER | N | 5 | 2 | Desc. Percen | @E 99.99 | HS_VldM24(, 40) | R | N | |||
| GE7_DESVAL | N | 10 | 2 | Desc. Valor | @E 999,999.99 | HS_VldM24(, 40) | R | N | |||
| GE7_VALTOT | N | 10 | 2 | Valor Total | @E 999,999.99 | V | N | ||||
| GE7_TOTDSC | N | 10 | 2 | Total c/ Dsc | @E 999,999.99 | V | N | ||||
| GE7_DESOBS | C | 100 | 0 | Obs. Descont | @! | HS_VldM24(, 41) | R | N | |||
| GE7_VFILME | N | 10 | 4 | Preco Filme | @E 99,999.9999 | HS_CalcDsc() | R | N | |||
| GE7_VCUSOP | N | 10 | 4 | Preco C.Oper | @E 99,999.9999 | HS_CalcDsc() | R | N | |||
| GE7_PCUDES | N | 10 | 4 | Preco Custo | @E 99,999.9999 | HS_CalcDsc() | R | N | |||
| GE7_URGDES | C | 1 | 0 | Urgencia | @! | HS_VldM24(, 43) | R | 0=Nao;1=Sim;2=Regra | N | ||
| GE7_GLODES | C | 1 | 0 | Ind de Glosa | @! | Pertence("012") | R | 0=Normal;1=Indevida;2=Excecao | N | ||
| GE7_COECHP | N | 6 | 3 | Coef. CH Pr. | @E 99.999 | R | N | ||||
| GE7_QTDCHP | N | 10 | 2 | V.R$/Q.CH Pr | @E 99,999.99 | R | N | ||||
| GE7_CODESP | C | 2 | 0 | Especialidad | @! | HSPVLDBPA('GE7','M->GE7_CODESP') .And. HSPBPATRIG('GE7','CODESP',M->GE7_CODESP) | GHCBES | R | HSPWheEsp() | N | |
| GE7_NOMESP | C | 30 | 0 | Descricao | @! | V | N | ||||
| GE7_PGTMED | C | 1 | 0 | Tp Rec Med | @! | Pertence('0123') .And. HS_GDAtrib(oGDPR, {{nPRStaReg, 'BR_AMARELO', 'BR_VERDE'}}) .And. HS_CalcDsc() | R | 0=Direto;1=Repasse Faturamento;2=Repasse Acatamento;3=Repasse Quitacao | N | ||
| GE7_COECHM | N | 6 | 3 | Coef.CH Med. | @E 99.999 | R | N | ||||
| GE7_REPAMB | N | 6 | 2 | Repasse(%) | @E 999.99 | R | N | ||||
| GE7_VALREP | N | 15 | 4 | Repasse | @E 9,999,999,999.9999 | R | N | ||||
| GE7_VALREB | N | 10 | 4 | Rep. Bruto | @E 99,999.9999 | R | N | ||||
| GE7_CODPCT | C | 6 | 0 | Proc. Padrao | @! | HS_VldM24(, 44) | HSP008 | R | EMPTY(M->GE7_CODPCT) | N | |
| GE7_DESPCT | C | 30 | 0 | Descricao | @! | V | N | ||||
| GE7_CODKIT | C | 5 | 0 | Cod do Kit | @! | R | N | ||||
| GE7_DESKIT | C | 30 | 0 | Descricao | @! | V | N | ||||
| GE7_NREXTM | C | 8 | 0 | Cod. Extrato | R | N | |||||
| GE7_CODCON | C | 3 | 0 | Convenio | @! | R | N | ||||
| GE7_CODPRE | C | 6 | 0 | Cd Prestador | @! | ZA2 | R | N | |||
| GE7_VALPAG | N | 10 | 4 | Pago | @E 99,999.9999 | R | N | ||||
| GE7_VALGLO | N | 10 | 4 | Glosa | @E 99,999.9999 | R | N | ||||
| GE7_VALREC | N | 10 | 4 | Recuperado | @E 99,999.9999 | R | N | ||||
| GE7_VALPER | N | 10 | 4 | Perdido | @E 99,999.9999 | R | N | ||||
| GE7_NREXTC | C | 10 | 0 | Ext.Convenio | R | S | |||||
| GE7_SEQDES | C | 8 | 0 | Seq.Despesa | @! | R | N | ||||
| GE7_SPRINC | C | 8 | 0 | Seq.Desp.Pr. | @! | R | N | ||||
| GE7_NRSEQG | C | 6 | 0 | Nro.Seq.Guia | @! | R | N | ||||
| GE7_VLRGLO | N | 10 | 4 | Rep. Glosa | @E 99,999.9999 | R | S | ||||
| GE7_VLRREC | N | 10 | 4 | Rep. Recup. | @E 99,999.9999 | R | S | ||||
| GE7_REGATE | C | 6 | 0 | Reg. Atendim | @! | R | N | ||||
| GE7_MARLAN | C | 2 | 0 | Marcador | R | S | |||||
| GE7_IDMARC | C | 2 | 0 | Id. Marca | R | S | |||||
| GE7_STATUS | C | 1 | 0 | Status | @! | Pertence("123") | R | 1=Aberto;2=Associado;3=Encerrado | N | ||
| GE7_DATSTA | D | 8 | 0 | Dt Status | R | S | |||||
| GE7_HORSTA | C | 5 | 0 | Hr Status | 99:99 | R | S | ||||
| GE7_INCIDE | N | 2 | 0 | Incidencia | @E 99 | HS_VIncide(M->GE7_INCIDE) | R | lAltIncide | N | ||
| GE7_ORIDES | C | 1 | 0 | Origem | @! | Pertence("012") | R | 0=Normal;1=Cirurgia;2=Incidencia | N | ||
| GE7_CODPCO | C | 10 | 0 | Cod Pacote | @! | R | N | ||||
| GE7_DESCID | C | 70 | 0 | Patologia | @! | V | S | ||||
| GE7_CODPRT | C | 10 | 0 | Proced Tab | @! | R | N | ||||
| GE7_DESPRT | C | 50 | 0 | Descricao | @! | R | N | ||||
| GE7_TPAPAC | C | 1 | 0 | Tipo APAC | @! | R | 1=Inicial;2=Continuacao;3=Unica | S | |||
| GE7_CODCID | C | 8 | 0 | Codigo CID | @! | Vazio() .OR. HS_VLDM24(,29) | GHH001 | R | S | ||
| GE7_CMCPAC | C | 2 | 0 | Motivo Cobr. | @! | HS_SeekRet("GH7","M->GE7_CMCPAC",1,.F.,"GE7_DMCPAC","GH7_DMCPAC") | GH7001 | R | S | ||
| GE7_CDGATE | C | 2 | 0 | Grupo Atend. | @! | Vazio() .OR. HS_VLDM24(,29) | GHF001 | R | S | ||
| GE7_DSGATE | C | 50 | 0 | Descricao | @! | V | S | ||||
| GE7_DMCPAC | C | 50 | 0 | Descricao | @! | V | S | ||||
| GE7_CGCFOR | C | 14 | 0 | CNPJ Forn. | @R 99.999.999/9999-99 | Vazio() .Or. Cgc(M->GE7_CGCFOR) | R | S | |||
| GE7_CDTATE | C | 2 | 0 | Tipo Atend. | @! | Vazio() .OR. HS_VLDM24(,29) | GHG001 | R | S | ||
| GE7_DSTATE | C | 50 | 0 | Descricao | @! | V | S | ||||
| GE7_NNFFOR | C | 6 | 0 | Numero NF | @! | R | S | ||||
| GE7_DOPLER | C | 1 | 0 | Dopler | @! | Pertence("012") | R | 0=Nao usa;1=Convencional;2=Colorido | HS_M24When("GE7_DOPLER") | N | |
| GE7_LOGARQ | C | 40 | 0 | Log do Arq | @! | R | N | ||||
| GE7_VLRCOS | N | 10 | 3 | Vlr custo Op | @E 9,999,999.999 | R | N | ||||
| GE7_DOCCIR | C | 10 | 0 | Doc Cirurgia | @! | R | N | ||||
| GE7_DATFIM | D | 8 | 0 | Data Fim Pro | @D | R | N | ||||
| GE7_HORFIM | C | 5 | 0 | Hora Fim Pro | 99=99 | R | N | ||||
| GE7_TPANES | C | 6 | 0 | Tp Anestesia | @! | HS_SeekRet("SX5", "'CA' + M -> GE7_TPANES" ,1, .F., "GE7_DESANE","X5_DESCRI") | CA | R | N | ||
| GE7_DESANE | C | 55 | 0 | Anestesia | @! | V | N | ||||
| GE7_TABELA | C | 6 | 0 | Tabela Calc. | @! | R | N | ||||
| GE7_PAGFIL | N | 10 | 4 | Pago Filme | @E 99,999.9999 | R | N | ||||
| GE7_GLOFIL | N | 10 | 4 | Glosa Filme | @E 99,999.9999 | R | N | ||||
| GE7_RECFIL | N | 10 | 4 | Recup. Filme | @E 99,999.9999 | R | N | ||||
| GE7_PERFIL | N | 10 | 4 | Perd. Filme | @E 99,999.9999 | R | N | ||||
| GE7_VLREPF | N | 10 | 4 | Rep. Filme | @E 99,999.9999 | R | N | ||||
| GE7_TECUTI | C | 1 | 0 | Tec utilizad | @! | Vazio() .or. Pertence('CV') | R | C=Convencional;V=Videolaparoscopia;R=Robotica | N | ||
| GE7_CNPJFO | C | 14 | 0 | CNPJ Fornec. | @R 99.999.999/9999-99 | Vazio() .Or. Cgc(M->GE7_CNPJFO) | R | N | |||
| GE7_NFOPM | C | 11 | 0 | NF OPM | @! | R | N | ||||
| GE7_LOTOPM | C | 11 | 0 | Lote OPM | @! | R | N | ||||
| GE7_SEROPM | C | 3 | 0 | Serie OPM | @! | R | N | ||||
| GE7_CNPJFA | C | 14 | 0 | CNPJ Fabric. | @R 99.999.999/9999-99 | Vazio() .Or. Cgc(M->GE7_CNPJFA) | R | N | |||
| GE7_ANVOPM | C | 20 | 0 | Reg Anvisa | @! | R | N | ||||
| GE7_COMPD | C | 7 | 0 | Competencia | @! | R | N | ||||
| GE7_QTFILH | N | 2 | 0 | Qtd Filhos | 99 | R | N | ||||
| GE7_CIDIND | C | 6 | 0 | CID Indic. | @! | R | N | ||||
| GE7_GRINST | C | 1 | 0 | Grau Instr. | @! | R | N | ||||
| GE7_MCONT1 | C | 2 | 0 | Met Contra1 | @! | R | N | ||||
| GE7_MCONT2 | C | 2 | 0 | Met Contra2 | @! | R | N | ||||
| GE7_GESTR | C | 2 | 0 | Gest Risco | @! | R | N | ||||
| GE7_TDEAIH | C | 1 | 0 | Tip Doc AIH | R | 1=CPF Prof;2=CNS;3=CNPJ;5=CNES | N | ||||
| GE7_DDEAIH | C | 20 | 0 | Desc Doc AIH | @! | R | N | ||||
| GE7_REPPAR | C | 1 | 0 | Repl Parcial | @! | R | 0=Nao;1=Sim | N | |||
| GE7_DENREG | C | 4 | 0 | Dente/Reg. | Vazio() .OR. HS_SeekRet('B05','M->GE7_DENREG',2, .F., 'GE7_DESREG', 'B05_DESCRI') | B05HSP | R | N | |||
| GE7_DESREG | C | 50 | 0 | Descricao | V | N | |||||
| GE7_FADENT | C | 5 | 0 | Face | Vazio() .OR. HS_SeekRet('BYL','M->GE7_FADENT',3, .F., 'GE7_FACDES', 'BYL_DESFAC') | B06HSP | R | N | |||
| GE7_FACDES | C | 50 | 0 | Descricao | V | N | |||||
| GE7_STAPLS | C | 1 | 0 | Status PLS | R | 0=Negado;1=Autorizado | N | ||||