| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| GG5 | Mat x Med Faturados Pacote | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| GG5_FILIAL | C | 2 | 0 | Filial | N | ||||||
| GG5_CODLOC | C | 2 | 0 | Setor | @! | HS_VldP12() | GCS | R | N | ||
| GG5_NOMLOC | C | 30 | 0 | Descricao | @! | V | N | ||||
| GG5_DATDES | D | 8 | 0 | Data | @D | R | N | ||||
| GG5_HORDES | C | 5 | 0 | Hora | 99:99 | R | N | ||||
| GG5_QTDDES | N | 10 | 4 | Quantidade | @E 99,999.9999 | HS_VQtdMM(M->GE5_QTDDES).And.IIf(!Empty(&__cRCodDes),HS_VMatMed(cGczCodPla,&__cRCodDes,cGcsArmSet,,,{.F.,M->GE5_QTDDES}),.T.) | R | N | |||
| GG5_CODBAR | C | 17 | 0 | Cod. Barras | @! | HS_VldM24(, 38) | V | N | |||
| GG5_CODDES | C | 15 | 0 | Mat/Med | @! | HS_VMatMed(cGczCodPla, M->GE5_CODDES, cGcsArmSet,,, {.F., __MMQtdDe}) | G1R | R | N | ||
| GG5_DDESPE | C | 30 | 0 | Descricao | @! | V | N | ||||
| GG5_CODCRM | C | 7 | 0 | CRM | @! | HS_VldM24(, 17) | MED | R | N | ||
| GG5_NOMMED | C | 30 | 0 | Nome | @! | V | N | ||||
| GG5_VALDES | N | 10 | 4 | Preco | @E 99,999.9999 | R | N | ||||
| GG5_DESPER | N | 5 | 2 | Desc. Percen | @E 99.99 | HS_VldM24(, 40) | R | N | |||
| GG5_DESVAL | N | 10 | 2 | Desc. Valor | @E 999,999.99 | HS_VldM24(, 40) | R | N | |||
| GG5_VALTOT | N | 10 | 2 | Valor Total | @E 999,999.99 | V | N | ||||
| GG5_TOTDSC | N | 10 | 2 | Total c/ Dsc | @E 999,999.99 | V | N | ||||
| GG5_DESOBS | C | 100 | 0 | Obs. Descont | @! | HS_VldM24(, 41) | R | N | |||
| GG5_PCUDES | N | 10 | 4 | Preco Custo | @E 99,999.9999 | R | N | ||||
| GG5_UNICON | C | 2 | 0 | Unidade | @! | V | N | ||||
| GG5_LOTEFO | C | 18 | 0 | Lote Fornec. | @! | R | N | ||||
| GG5_LOTECT | C | 10 | 0 | Lote | R | N | |||||
| GG5_NUMLOT | C | 6 | 0 | Sub-Lote | @! | R | N | ||||
| GG5_DTVALI | D | 8 | 0 | Dt Validade | @D | R | N | ||||
| GG5_PERTRO | C | 1 | 0 | Perm. Troca | @! | Pertence("01") | R | 0=Nao;1=Sim | N | ||
| GG5_PROALT | C | 15 | 0 | Prod. Alter. | @! | R | N | ||||
| GG5_DPRALT | C | 35 | 0 | Descricao | @! | V | N | ||||
| GG5_GLODES | C | 1 | 0 | Ind de Glosa | @! | R | 0=Normal;1=Indevida;2=Excecao | N | |||
| GG5_CODPCT | C | 6 | 0 | Proc. Padrao | @! | R | N | ||||
| GG5_DESPCT | C | 30 | 0 | Descricao | @! | V | N | ||||
| GG5_CODKIT | C | 5 | 0 | Cod do Kit | @! | R | N | ||||
| GG5_DESKIT | C | 30 | 0 | Descricao | @! | V | N | ||||
| GG5_VALPAG | N | 10 | 4 | Pago | @E 99,999.9999 | R | N | ||||
| GG5_VALGLO | N | 10 | 4 | Glosa | @E 99,999.9999 | R | N | ||||
| GG5_VALREC | N | 10 | 4 | Recuperado | @E 99,999.9999 | R | N | ||||
| GG5_VALPER | N | 10 | 4 | Perdido | @E 99,999.9999 | R | N | ||||
| GG5_NREXTC | C | 10 | 0 | Ext.Convenio | R | S | |||||
| GG5_SEQDES | C | 8 | 0 | Seq.Despesa | @! | R | N | ||||
| GG5_NRSEQG | C | 6 | 0 | Nro.Seq.Guia | @! | R | N | ||||
| GG5_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 | ||
| GG5_REPAMB | N | 6 | 2 | Repasse(%) | @E 999.99 | R | N | ||||
| GG5_REPINT | N | 7 | 2 | Rep.Int(%) | @E 9999.99 | R | N | ||||
| GG5_VALREP | N | 15 | 4 | Repasse | @E 9,999,999,999.9999 | R | N | ||||
| GG5_VALREB | N | 10 | 4 | Rep. Bruto | @E 99,999.9999 | R | N | ||||
| GG5_CODPRE | C | 6 | 0 | Cd Prestador | @! | ZA2 | R | N | |||
| GG5_NREXTM | C | 8 | 0 | Cod. Extrato | R | N | |||||
| GG5_NUMSEQ | C | 6 | 0 | Seq.Mov.Est | @! | R | N | ||||
| GG5_REGATE | C | 6 | 0 | Reg. Atendim | @! | R | N | ||||
| GG5_IDMARC | C | 2 | 0 | Id. Marca | R | S | |||||
| GG5_CODPCO | C | 10 | 0 | Codigo Proc. | R | N | |||||
| GG5_CODPRO | C | 20 | 0 | Cod.Proprio | @! | R | N | ||||
| GG5_DESPRO | C | 30 | 0 | Descricao | @! | R | N | ||||
| GG5_SEQGE7 | C | 8 | 0 | Seq. Pacote | @! | R | N | ||||
| GG5_LOGARQ | C | 40 | 0 | Log do Arq | @! | R | N | ||||
| GG5_TABELA | C | 6 | 0 | Tabela Calc. | @! | R | N | ||||
| GG5_CGCFOR | C | 14 | 0 | CNPJ Forn. | @R 99.999.999/9999-99 | Vazio().Or.Cgc(M->GG5_CGCFOR) | R | N | |||
| GG5_NNFFOR | C | 9 | 0 | Numero NF | @! | R | N | ||||
| GG5_SD3DOC | C | 6 | 0 | Num.Doc.Est. | @! | R | N | ||||
| GG5_VLRGLO | N | 10 | 4 | Rep. Glosa | @E 99,999.9999 | 0 | R | N | |||
| GG5_VLRREC | N | 10 | 4 | Rep. Recup. | @E 99,999.9999 | R | N | ||||
| GG5_STATUS | C | 1 | 0 | Status | @! | Pertence('123') | R | 1=Aberto;2=Associado;3=Encerrado | N | ||
| GG5_DATSTA | D | 8 | 0 | Data Status | R | S | |||||
| GG5_HORSTA | C | 5 | 0 | Hora Status | 99:99 | R | S | ||||