Tabela |
GG7 |
Proced Faturados Pacote |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
GG7_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
GG7_CODLOC |
C |
2 |
0 |
Setor |
@! |
HS_VldP12() |
GCS |
R |
|
|
N |
GG7_NOMLOC |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
N |
GG7_DATDES |
D |
8 |
0 |
Data |
@D |
|
|
R |
|
|
N |
GG7_HORDES |
C |
5 |
0 |
Hora |
99:99 |
|
|
R |
|
|
N |
GG7_QTDDES |
N |
10 |
4 |
Quantidade |
@E 99,999.9999 |
HS_VQtdPr(M->GE7_QTDDES) |
|
R |
|
|
N |
GG7_CODDES |
C |
10 |
0 |
Procedimento |
@! |
HS_VldM24(, 38) |
GA7 |
R |
|
|
N |
GG7_DDESPE |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
N |
GG7_CODCRM |
C |
7 |
0 |
CRM |
@! |
HS_VldM24(, 17) |
MED |
R |
|
HS_M24WHEN("GE7_CODCRM") |
N |
GG7_NOMMED |
C |
30 |
0 |
Nome |
@! |
|
|
V |
|
|
N |
GG7_CODATO |
C |
2 |
0 |
Ato |
99 |
HS_VldM24(, 18) |
GMC |
R |
|
|
N |
GG7_DESATO |
C |
20 |
0 |
Descricao |
@! |
|
|
V |
|
|
N |
GG7_CODVIA |
C |
6 |
0 |
Via acesso |
@! |
HS_VldM24(, 10) |
GE4 |
R |
|
|
N |
GG7_DESVIA |
C |
20 |
0 |
Descricao |
@! |
|
|
V |
|
|
N |
GG7_COEDES |
N |
5 |
2 |
Coef.Despesa |
@E 99.99 |
HS_VldM24(, 38) |
|
R |
|
|
N |
GG7_COEFAM |
N |
5 |
2 |
Coef.Ato Med |
@E 99.99 |
|
|
R |
|
|
N |
GG7_VALDES |
N |
10 |
4 |
Preco |
@E 99,999.9999 |
HS_CalcDsc() |
|
R |
|
|
N |
GG7_VFILME |
N |
10 |
4 |
Preco Filme |
@E 99,999.9999 |
HS_CalcDsc() |
|
R |
|
|
N |
GG7_DESPER |
N |
5 |
2 |
Desc. Percen |
@E 99.99 |
HS_VldM24(, 40) |
|
R |
|
|
N |
GG7_VCUSOP |
N |
10 |
4 |
Preco C.Oper |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_DESVAL |
N |
10 |
2 |
Desc. Valor |
@E 999,999.99 |
HS_VldM24(, 40) |
|
R |
|
|
N |
GG7_PCUDES |
N |
10 |
4 |
Preco Custo |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_VALTOT |
N |
10 |
2 |
Valor Total |
@E 999,999.99 |
|
|
V |
|
|
N |
GG7_URGDES |
C |
1 |
0 |
Urgencia |
@! |
Pertence("012") |
|
R |
0=Nao;1=Sim;2=Regra |
|
N |
GG7_TOTDSC |
N |
10 |
2 |
Total c/ Dsc |
@E 999,999.99 |
|
|
V |
|
|
N |
GG7_GLODES |
C |
1 |
0 |
Ind de Glosa |
@! |
Pertence("012") |
|
R |
0=Normal;1=Indevida;2=Excecao |
|
N |
GG7_DESOBS |
C |
100 |
0 |
Obs. Descont |
@! |
HS_VldM24(, 41) |
|
R |
|
|
N |
GG7_COECHP |
N |
6 |
3 |
Coef. CH Pr. |
@E 99.999 |
|
|
R |
|
|
N |
GG7_QTDCHP |
N |
10 |
2 |
V.R$/Q.CH Pr |
@E 99,999.99 |
|
|
R |
|
|
N |
GG7_CODESP |
C |
2 |
0 |
Especialidad |
@! |
HS_VldM24(, 16) |
GFR001 |
R |
|
|
N |
GG7_NOMESP |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
N |
GG7_PGTMED |
C |
1 |
0 |
Tp Rec Med |
@! |
Pertence('01234') |
|
R |
0=Direto;1=Repasse Faturamento;2=Repasse Acatamento;3=Repasse Quitacao |
|
N |
GG7_COECHM |
N |
6 |
3 |
Coef.CH Med. |
@E 99.999 |
|
|
R |
|
|
N |
GG7_REPAMB |
N |
6 |
2 |
Repasse(%) |
@E 999.99 |
|
|
R |
|
|
N |
GG7_VALREP |
N |
15 |
4 |
Repasse |
@E 9,999,999,999.9999 |
|
|
R |
|
|
N |
GG7_CODPCT |
C |
6 |
0 |
Proc. Padrao |
@! |
|
|
R |
|
|
N |
GG7_DESPCT |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
N |
GG7_CODKIT |
C |
5 |
0 |
Cod do Kit |
@! |
|
|
R |
|
|
N |
GG7_DESKIT |
C |
30 |
0 |
Descricao |
@! |
|
|
V |
|
|
N |
GG7_NREXTM |
C |
8 |
0 |
Cod. Extrato |
|
|
|
R |
|
|
N |
GG7_CODCON |
C |
3 |
0 |
Convenio |
@! |
|
|
R |
|
|
N |
GG7_CODPRE |
C |
6 |
0 |
Cd Prestador |
@! |
|
ZA2 |
R |
|
|
N |
GG7_VALPAG |
N |
10 |
4 |
Pago |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_VALGLO |
N |
10 |
4 |
Glosa |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_VALREC |
N |
10 |
4 |
Recuperado |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_VALPER |
N |
10 |
4 |
Perdido |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_NREXTC |
C |
10 |
0 |
Ext.Convenio |
|
|
|
R |
|
|
S |
GG7_SEQDES |
C |
8 |
0 |
Seq.Despesa |
@! |
|
|
R |
|
|
N |
GG7_SPRINC |
C |
8 |
0 |
Seq.Desp.Pr. |
@! |
|
|
R |
|
|
N |
GG7_NRSEQG |
C |
6 |
0 |
Nro.Seq.Guia |
@! |
|
|
R |
|
|
N |
GG7_VLRGLO |
N |
10 |
4 |
Rep. Glosa |
@E 99,999.9999 |
|
|
R |
|
|
S |
GG7_VLRREC |
N |
10 |
4 |
Rep. Recup. |
@E 99,999.9999 |
|
|
R |
|
|
S |
GG7_REGATE |
C |
6 |
0 |
Reg. Atendim |
@! |
|
|
R |
|
|
N |
GG7_MARLAN |
C |
2 |
0 |
Marcador |
|
|
|
R |
|
|
S |
GG7_IDMARC |
C |
2 |
0 |
Id. Marca |
|
|
|
R |
|
|
S |
GG7_STATUS |
C |
1 |
0 |
Status |
@! |
Pertence("123") |
|
R |
1=Aberto;2=Associado;3=Encerrado |
|
N |
GG7_DATSTA |
D |
8 |
0 |
Dt Status |
|
|
|
R |
|
|
S |
GG7_HORSTA |
C |
5 |
0 |
Hr Status |
99:99 |
|
|
R |
|
|
S |
GG7_INCIDE |
N |
2 |
0 |
Incidencia |
@E 99 |
HS_VIncide(M->GE7_INCIDE) |
|
R |
|
|
N |
GG7_ORIDES |
C |
1 |
0 |
Origem |
@! |
Pertence("012") |
|
R |
0=Normal;1=Cirurgia;2=Incidencia |
|
N |
GG7_CODPCO |
C |
10 |
0 |
Codigo Proc. |
|
|
|
R |
|
|
N |
GG7_CODPRT |
C |
10 |
0 |
Proced Tab |
@! |
|
|
R |
|
|
N |
GG7_DESPRT |
C |
50 |
0 |
Descricao |
@! |
|
|
R |
|
|
N |
GG7_CDFETA |
C |
2 |
0 |
Faixa Etaria |
@! |
HS_SeekRet("GHA","M->GG7_CDFETA",1,.F.,"GG7_DSFETA","GHA_DSFETA") |
|
R |
|
|
S |
GG7_DSFETA |
C |
50 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
GG7_CDGATE |
C |
2 |
0 |
Grupo Atend. |
@! |
HS_SeekRet("GH3","M->GG7_CDGATE",1,.F.,"GG7_DSGATE","GH3_DSGATE") |
GHF001 |
R |
|
|
S |
GG7_DSGATE |
C |
50 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
GG7_CDTATE |
C |
2 |
0 |
Tipo Atend. |
@! |
HS_SeekRet("GH4","M->GG7_CDTATE",1,.F.,"GG7_DSTATE","GH4_DSTATE") |
GHG001 |
R |
|
|
S |
GG7_DSTATE |
C |
50 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
GG7_TPAPAC |
C |
1 |
0 |
Tipo APAC |
@! |
|
|
R |
1=Inicial;2=Continuacao;3=Unica |
|
S |
GG7_DESCID |
C |
70 |
0 |
Patologia |
@! |
|
|
V |
|
|
S |
GG7_CMCPAC |
C |
2 |
0 |
Motivo Cobr. |
@! |
HS_SeekRet("GH7","M->GG7_CMCPAC",1,.F.,"GG7_DMCPAC","GH7_DMCPAC") |
|
R |
|
|
S |
GG7_DMCPAC |
C |
50 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
GG7_CGCFOR |
C |
14 |
0 |
CNPJ Forn. |
@R 99.999.999/9999-99 |
Cgc(M->GG7_CGCFOR) |
|
R |
|
|
S |
GG7_NNFFOR |
C |
6 |
0 |
Numero NF |
@! |
|
|
R |
|
|
S |
GG7_DOPLER |
C |
1 |
0 |
Dopler |
@! |
Pertence("012") |
|
R |
0=Nao usa;1=Convencional;2=Colorido |
|
N |
GG7_VLRCOS |
N |
10 |
3 |
Vlr Custo Op |
@E 9,999,999.999 |
|
|
R |
|
|
N |
GG7_SEQGE7 |
C |
8 |
0 |
Seq. Pacote |
@! |
|
|
R |
|
|
N |
GG7_LOGARQ |
C |
40 |
0 |
Log do Arq |
@! |
|
|
R |
|
|
N |
GG7_DOCCIR |
C |
10 |
0 |
Doc Cirurgia |
@! |
|
|
R |
|
|
N |
GG7_DATFIM |
D |
8 |
0 |
Data Fim Pro |
|
|
|
R |
|
|
N |
GG7_HORFIM |
C |
5 |
0 |
Hora Fim Pro |
99=99 |
|
|
R |
|
|
N |
GG7_TPANES |
C |
6 |
0 |
Tp Anestesia |
@! |
HS_SeekRet("SX5","'CA' + M->GG7_TPANES",1,.F.,"GG7_DESANE","X5_DESCRI") |
|
R |
|
|
N |
GG7_DESANE |
C |
55 |
0 |
Anestesia |
@! |
|
|
V |
|
|
N |
GG7_TABELA |
C |
6 |
0 |
Tabela Calc. |
@! |
|
|
R |
|
|
N |
GG7_CIDSEC |
C |
8 |
0 |
Cid Sec. |
@! |
Vazio.OR.HS_VLDM24(,29) |
GAS |
R |
|
|
N |
GG7_PAGFIL |
N |
10 |
4 |
Pago Filme |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_GLOFIL |
N |
10 |
4 |
Glosa Filme |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_RECFIL |
N |
10 |
4 |
Recup. Filme |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_PERFIL |
N |
10 |
4 |
Perd. Filme |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_VLREPF |
N |
10 |
4 |
Rep. Filme |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_TECUTI |
C |
1 |
0 |
Tec utilizad |
@! |
|
|
R |
C=Convencional;V=Videolaparoscopia |
|
N |
GG7_CNPJFO |
C |
14 |
0 |
CNPJ Fornec. |
@R 99.999.999/9999-99 |
Vazio() .Or. Cgc(M->GG7_CNPJFO) |
|
R |
|
|
N |
GG7_NFOPM |
C |
11 |
0 |
NF OPM |
@! |
|
|
R |
|
|
N |
GG7_LOTOPM |
C |
11 |
0 |
Lote OPM |
@! |
|
|
R |
|
|
N |
GG7_SEROPM |
C |
3 |
0 |
Serie OPM |
@! |
|
|
R |
|
|
N |
GG7_CNPJFA |
C |
14 |
0 |
CNPJ Fabric. |
@R 99.999.999/9999-99 |
Vazio() .Or. Cgc(M->GG7_CNPJFA) |
|
R |
|
|
N |
GG7_ANVOPM |
C |
20 |
0 |
Reg Anvisa |
@! |
|
|
R |
|
|
N |
GG7_COMPD |
C |
7 |
0 |
Competencia |
@! |
|
|
R |
|
|
N |
GG7_QTFILH |
N |
2 |
0 |
Qtd Filhos |
99 |
|
|
R |
|
|
N |
GG7_CIDIND |
C |
6 |
0 |
CID Indic. |
@! |
|
|
R |
|
|
N |
GG7_GRINST |
C |
1 |
0 |
Grau Instr. |
@! |
|
|
R |
|
|
N |
GG7_MCONT1 |
C |
2 |
0 |
Met Contra1 |
@! |
|
|
R |
|
|
N |
GG7_MCONT2 |
C |
2 |
0 |
Met Contra2 |
@! |
|
|
R |
|
|
N |
GG7_GESTR |
C |
2 |
0 |
Gest Risco |
@! |
|
|
R |
|
|
N |
GG7_TDEAIH |
C |
1 |
0 |
Tip Doc AIH |
@! |
|
|
R |
1=CPF Prof;2=CNS;3=CNPJ;5=CNES |
|
N |
GG7_DDEAIH |
C |
20 |
0 |
Desc Doc AIH |
|
|
|
R |
|
|
N |
GG7_VALREB |
N |
10 |
4 |
Rep. Bruto |
@E 99,999.9999 |
|
|
R |
|
|
N |
GG7_REPPAR |
C |
1 |
0 |
Repl Parcial |
@! |
|
|
R |
0=Nao;1=Sim |
|
N |
GG7_DENREG |
C |
4 |
0 |
Dente/Reg. |
|
|
|
R |
|
|
N |
GG7_DESREG |
C |
50 |
0 |
Descricao |
|
|
|
V |
|
|
N |
GG7_FADENT |
C |
5 |
0 |
Face |
|
|
|
R |
|
|
N |
GG7_FACDES |
C |
50 |
0 |
Descricao |
|
|
|
V |
|
|
N |
GG7_STAPLS |
C |
1 |
0 |
Status PLS |
|
|
|
R |
|
|
N |