Tabela |
GAZ |
Prestadores |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
GAZ_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
GAZ_CODPRE |
C |
6 |
0 |
Codigo |
@! |
existchav("GAZ",M->GAZ_CODPRE) |
|
R |
|
|
N |
GAZ_FANPRE |
C |
30 |
0 |
Nom Fantasia |
@! |
NaoVazio() |
|
R |
|
|
N |
GAZ_RAZPRE |
C |
50 |
0 |
Razao Social |
@! |
NaoVazio() |
|
R |
|
|
N |
GAZ_ENDPRE |
C |
30 |
0 |
Endereco |
@! |
NaoVazio() |
|
R |
|
|
N |
GAZ_BAIPRE |
C |
20 |
0 |
Bairro |
@! |
NaoVazio() |
|
R |
|
|
N |
GAZ_CIDPRE |
C |
20 |
0 |
Municipio |
@! |
NaoVazio() |
|
R |
|
|
N |
GAZ_ESTPRE |
C |
2 |
0 |
Estado |
@! |
ExistCpo("SX5","12"+M->GAZ_ESTPRE) |
12 |
R |
|
|
N |
GAZ_CEPPRE |
C |
8 |
0 |
Cep |
@R 99999-999 |
NaoVazio() |
GAM001 |
R |
|
|
N |
GAZ_FONPRE |
C |
20 |
0 |
Telefone |
@! |
NaoVazio() |
|
R |
|
|
N |
GAZ_FAXPRE |
C |
20 |
0 |
Fax |
@! |
|
|
R |
|
|
N |
GAZ_PCOPRE |
C |
25 |
0 |
Contato |
@! |
NaoVazio() |
|
R |
|
|
N |
GAZ_TIPPRE |
C |
1 |
0 |
Tip. Prest. |
@! |
HS_VldA32(3) |
|
R |
F=Fisico;J=Juridico |
|
N |
GAZ_CGCPRE |
C |
14 |
0 |
CNPJ/CPF |
@R 99.999.999/9999-99 |
HS_VldA32(2) |
|
R |
|
|
N |
GAZ_INSPRE |
C |
18 |
0 |
Ins. Estad. |
@! |
|
|
R |
|
|
N |
GAZ_PERPRE |
N |
6 |
2 |
% Comis Hosp |
@E 999.99 |
|
|
R |
|
|
N |
GAZ_CCM |
C |
6 |
0 |
CCM |
@R 99999-9 |
|
|
R |
|
|
N |
GAZ_CODFOR |
C |
6 |
0 |
Cod. Fornec. |
@! |
HS_VLDA32(1) |
FOR |
R |
|
|
N |
GAZ_LOJA |
C |
2 |
0 |
Loja Fornec. |
@! |
|
|
R |
|
|
N |
GAZ_NREDUZ |
C |
20 |
0 |
Descricao |
@! |
|
|
V |
|
|
S |
GAZ_OBJCON |
C |
40 |
0 |
Obj. Contrat |
@! |
|
|
R |
|
|
S |
GAZ_DATVIG |
D |
8 |
0 |
Dt. Vigencia |
|
|
|
R |
|
|
S |
GAZ_DATVAL |
D |
8 |
0 |
Dt. Validade |
|
|
|
R |
|
|
S |
GAZ_OBSERV |
M |
10 |
0 |
Observacao |
@! |
|
|
R |
|
|
N |
GAZ_LOGARQ |
C |
40 |
0 |
Log do Arq |
@! |
|
|
R |
|
|
N |
GAZ_CTRLOC |
C |
1 |
0 |
Contr.setor |
@! |
Pertence('01') .And. HSHA32VLD('GAZ_CTRLOC') |
|
R |
0=Nao;1=Sim |
|
N |
GAZ_VLRDIU |
N |
10 |
2 |
Vlr. diurno |
@E 9,999,999.99 |
Positivo() |
|
R |
|
|
N |
GAZ_VLRNOT |
N |
10 |
2 |
Vlr. noturno |
@E 9,999,999.99 |
Positivo() |
|
R |
|
|
N |
GAZ_VLRFER |
N |
10 |
2 |
Vlr. feriado |
@E 9,999,999.99 |
Positivo() |
|
R |
|
|
N |
GAZ_FATORH |
N |
2 |
0 |
Fator hora |
99 |
|
|
R |
|
|
N |
GAZ_CTLOCM |
C |
1 |
0 |
Contr.setor |
@! |
Pertence('012') .And. HSHA32VLD('GAZ_CTLOCM') |
|
R |
0=Nao;1=Sim;2=Sem controle |
|
N |
GAZ_VALMIN |
N |
10 |
2 |
Valor minimo |
@E 9,999,999.99 |
Positivo() |
|
R |
|
|
N |
GAZ_VLMIND |
N |
10 |
2 |
Vl. min/dia |
@E 9,999,999.99 |
Positivo() |
|
R |
|
|
N |
GAZ_VALMAX |
N |
10 |
2 |
Valor maximo |
@E 9,999,999.99 |
Positivo() |
|
R |
|
|
N |
GAZ_VLMAXD |
N |
10 |
2 |
Vl. max/dia |
@E 9,999,999.99 |
Positivo() |
|
R |
|
|
N |
GAZ_TDEAIH |
C |
1 |
0 |
Tip Doc Exec |
@! |
|
|
R |
1=CPF Prof;2=CNS;3=CNPJ;5=CNES |
|
N |
GAZ_CNES |
C |
7 |
0 |
Num CNES |
@! |
|
|
R |
|
|
N |