Tabela |
AA3 |
Base de Atendimento |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
AA3_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
AA3_CODCLI |
C |
6 |
0 |
Cod. Cliente |
@! |
AT040SkCli().And.ExistChav("AA3",M->AA3_CODCLI+M->AA3_LOJA+M->AA3_CODPRO+M->AA3_NUMSER) |
SA1 |
|
|
INCLUI .And. M->AA3_EQALOC=="2" |
S |
AA3_LOJA |
C |
2 |
0 |
Loja |
@! |
AT040SkCli().And.ExistChav("AA3",M->AA3_CODCLI+M->AA3_LOJA+M->AA3_CODPRO+M->AA3_NUMSER) |
|
|
|
INCLUI .And. M->AA3_EQALOC=="2" |
S |
AA3_NOMCLI |
C |
30 |
0 |
Nome Cliente |
@! |
|
|
V |
|
|
S |
AA3_CODPRO |
C |
15 |
0 |
Produto/Eqto |
@! |
AT040SkPrd().And.ExistChav("AA3",M->AA3_CODCLI+M->AA3_LOJA+M->AA3_CODPRO+M->AA3_NUMSER) |
SB1 |
|
|
INCLUI |
S |
AA3_DESPRO |
C |
30 |
0 |
Desc.Produto |
@! |
|
|
V |
|
|
S |
AA3_NUMSER |
C |
20 |
0 |
Id.Unico |
@! |
At040SkSer().And.At040VSer() |
|
|
|
INCLUI |
S |
AA3_DTVEND |
D |
8 |
0 |
Dt.Venda |
|
At040Datas() |
|
|
|
|
S |
AA3_DTINST |
D |
8 |
0 |
Dt.Instalac. |
|
At040Datas() |
|
|
|
|
S |
AA3_DTGAR |
D |
8 |
0 |
Dt.Garantia |
|
At040Datas() |
|
|
|
|
S |
AA3_CBASE |
C |
10 |
0 |
Cod. Ativo |
@! |
ExistCpo("SN1") |
SN1 |
|
|
|
S |
AA3_ITEM |
C |
4 |
0 |
Item Ativo |
@! |
ExistCpo("SN1",M->AA3_CBASE+M->AA3_ITEM) |
|
|
|
|
S |
AA3_CHAPA |
C |
20 |
0 |
Plaqueta |
|
Vazio() .Or. ExistCpo("SN1",M->AA3_CHAPA,2) |
|
|
|
|
S |
AA3_CODTEC |
C |
14 |
0 |
Atend.Inst. |
|
AT040SkTec() |
AA1 |
|
|
|
S |
AA3_NOMTEC |
C |
30 |
0 |
Nome Atend. |
@! |
|
|
V |
|
|
S |
AA3_FORNEC |
C |
6 |
0 |
Fornecedor |
@! |
ExistCpo("SA2",M->AA3_FORNEC+RTRIM(M->AA3_LOJAFO),,,,!EMPTY(M->AA3_LOJAFO)) |
FOR |
|
|
|
S |
AA3_LOJAFO |
C |
2 |
0 |
Loja Fornec. |
@! |
ExistCpo("SA2",M->AA3_FORNEC+M->AA3_LOJAFO) |
|
|
|
|
S |
AA3_NFAQUI |
C |
9 |
0 |
NF.Aquisicao |
@! |
|
|
|
|
|
S |
AA3_CODFAB |
C |
6 |
0 |
Fabricante |
@! |
ExistCpo("SA1",M->AA3_CODFAB+RTRIM(M->AA3_LOJAFA),,,,!EMPTY(M->AA3_LOJAFA)) |
SA1 |
|
|
|
S |
AA3_LOJAFA |
C |
2 |
0 |
Loja Fabric. |
@! |
ExistCpo("SA1",M->AA3_CODFAB+M->AA3_LOJAFA) |
|
|
|
|
S |
AA3_NFVEND |
C |
9 |
0 |
Num.NF.Venda |
@! |
|
|
|
|
|
S |
AA3_CODMEM |
C |
6 |
0 |
Codigo Memo |
@! |
|
|
|
|
|
S |
AA3_OBS |
M |
80 |
0 |
Observacao |
@! |
|
|
V |
|
|
S |
AA3_CONTRT |
C |
15 |
0 |
No.Contrato |
@! |
|
|
R |
|
|
S |
AA3_DTCTAM |
D |
8 |
0 |
Dt.Inc.Cta. |
|
|
|
|
|
|
S |
AA3_CTAPRE |
C |
15 |
0 |
N.Preventiva |
@! |
|
|
|
|
|
S |
AA3_VLRCTR |
N |
12 |
2 |
Vlr.Ctr.Mnt. |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
AA3_LOCAL |
C |
100 |
0 |
Endereco |
@S10! |
|
|
|
|
|
S |
AA3_MODELO |
C |
15 |
0 |
Modelo |
@! |
|
|
|
|
|
S |
AA3_ACUMUL |
N |
12 |
2 |
Acumulador |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
AA3_MTBF |
N |
8 |
2 |
MTBF em Hr. |
99999.99 |
|
|
|
|
|
S |
AA3_MTTR |
N |
8 |
2 |
MTTR em Hr. |
99999.99 |
|
|
|
|
|
S |
AA3_PLANO |
C |
6 |
0 |
Plano Prev. |
@! |
ExistCpo( "ABF" ) |
|
|
|
|
S |
AA3_DTEXP |
D |
8 |
0 |
Dt.Expansao |
|
|
|
|
|
|
S |
AA3_HORRP |
N |
8 |
2 |
Q.Tot.Hs/Rep |
@E 99,999.99 |
|
|
|
|
|
S |
AA3_ULTNF |
C |
6 |
0 |
Ult.Nota.Ent |
@! |
|
|
|
|
|
S |
AA3_ULTSER |
C |
3 |
0 |
Ult.Serie |
!!! |
|
|
|
|
|
S |
AA3_QTREP |
N |
6 |
0 |
Qd.Total Rep |
|
|
|
|
|
|
S |
AA3_QTFAL |
N |
6 |
0 |
Qd.TT Falhas |
|
|
|
|
|
|
S |
AA3_ULTFOR |
C |
6 |
0 |
Ult.Fornec. |
@! |
|
|
|
|
|
S |
AA3_QTREPH |
N |
6 |
0 |
Tot.Rep.Hist |
@E 999,999 |
Positivo() |
|
|
|
DataRefHis() |
S |
AA3_ULTLOJ |
C |
2 |
0 |
Ult.Loja.For |
@! |
|
|
|
|
|
S |
AA3_ULTIT |
C |
2 |
0 |
Ult.Item NF |
@! |
|
|
|
|
|
S |
AA3_HORRPH |
N |
8 |
2 |
Hs .Rep/Hist |
@E 99,999.99 |
Positivo() |
|
|
|
DataRefHis() |
S |
AA3_ULTPRC |
N |
12 |
2 |
Ult.Preco |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
S |
AA3_QTFALH |
N |
6 |
0 |
Qtd. Fal/His |
@E 999,999 |
Positivo() |
|
|
|
DataRefHis() |
S |
AA3_OK |
C |
2 |
0 |
Ok |
@! |
.F. |
|
|
|
.F. |
S |
AA3_HOROPH |
N |
9 |
2 |
T.Hs.Op/Hist |
@E 999,999.99 |
Positivo() |
|
|
|
DataRefHis() |
S |
AA3_HORDIA |
N |
5 |
2 |
Hs. Oper/Dia |
99.99 |
(M->AA3_HORDIA > 0 .and. M->AA3_HORDIA <= 24) |
|
|
|
|
S |
AA3_STATUS |
C |
2 |
0 |
Status |
@! |
M->AA3_EQALOC=="2" .And. ExistCpo("SX5","A5"+M->AA3_STATUS) |
A5 |
|
|
M->AA3_EQALOC=="2" |
S |
AA3_STAANT |
C |
2 |
0 |
Status Ant. |
@! |
ExistCpo("SX5","A5"+M->AA3_STAANT) |
A5 |
|
|
.F. |
S |
AA3_DESSTA |
C |
30 |
0 |
Descr.Status |
@! |
|
|
V |
|
.F. |
S |
AA3_DTREFH |
D |
8 |
0 |
Dt.Ref/Histo |
|
|
|
|
|
|
S |
AA3_DTMTBF |
D |
8 |
0 |
Dt.MTBF(Off) |
|
|
|
|
|
|
S |
AA3_DIAOPE |
N |
1 |
0 |
Dias Ope/Sem |
9 |
( M->AA3_DIAOPE > 0 .AND. M->AA3_DIAOPE < 8 ) |
|
|
|
|
S |
AA3_DTMTTR |
D |
8 |
0 |
Dt.MTTR(Off) |
|
|
|
|
|
|
S |
AA3_SITE |
C |
15 |
0 |
Site |
@! |
|
|
|
|
|
S |
AA3_CODGRP |
C |
6 |
0 |
Cobertura |
@! |
Vazio() .Or. ExistCpo( "AAA" ) |
AAA |
|
|
|
S |
AA3_GRPDES |
C |
40 |
0 |
Desc.Cobert. |
@! |
|
|
V |
|
|
S |
AA3_CODLOC |
C |
8 |
0 |
Cod. Local |
@! |
M->AA3_EQALOC=="2" .And. ( Vazio() .OR. ExistCpo("ABS") ) |
ABS |
R |
|
M->AA3_EQALOC=="2" |
S |
AA3_EQALOC |
C |
1 |
0 |
Eq Locacao? |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
IIF(FindFunction("At040Loc"), At040Loc(), .T. ) |
S |
AA3_INALOC |
D |
8 |
0 |
Ini Locacao |
|
M->AA3_EQALOC=="2" |
|
R |
|
M->AA3_EQALOC=="2" |
S |
AA3_FIALOC |
D |
8 |
0 |
Fim Locacao |
|
M->AA3_EQALOC=="2" |
|
R |
|
M->AA3_EQALOC=="2" |
S |
AA3_MANPRE |
C |
1 |
0 |
Man Pre Loc? |
@! |
Pertence("12") .And. At040LocMan() |
|
R |
1=Sim;2=Nao |
|
S |
AA3_ORIGEM |
C |
3 |
0 |
Origem |
@! |
|
|
R |
|
|
S |
AA3_EXIGNF |
C |
1 |
0 |
Exige NF? |
@! |
Pertence("12") |
|
R |
1=Sim;2=Nao |
M->AA3_EQALOC == "1" |
S |
AA3_ENTEQP |
D |
8 |
0 |
Agenda. Ent. |
|
M->AA3_ENTEQP <= M->AA3_INALOC |
|
R |
|
M->AA3_EQALOC=="2" |
S |
AA3_COLEQP |
D |
8 |
0 |
Coleta Equip |
|
M->AA3_COLEQP >= M->AA3_FIALOC |
|
R |
|
M->AA3_EQALOC=="2" |
S |
AA3_FILORI |
C |
2 |
0 |
Fil Original |
|
ExistCpo("SM0", cEmpAnt+M->AA3_FILORI) .And. At040FilOk() |
SM0 |
R |
|
Inclui |
S |
AA3_EQ3 |
C |
1 |
0 |
Eq. Terceiro |
9 |
Pertence("12") |
|
R |
1=Sim;2=Nao |
M->AA3_EQALOC == "1" |
S |
AA3_MSBLQL |
C |
1 |
0 |
Status |
@! |
Pertence("12") |
|
R |
1=Inativo;2=Ativo |
|
S |
AA3_SDOC |
C |
3 |
0 |
Serie Doc |
!!! |
|
|
R |
|
|
S |
AA3_CODBEM |
C |
16 |
0 |
Cod. Bem MNT |
@! |
Vazio() .Or. ExistCpo("ST9") |
ST9GS1 |
R |
|
Inclui .Or. At040NoSTP() |
S |
AA3_OSMONT |
C |
1 |
0 |
Exige Mont? |
@9 |
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
AA3_CDBMFL |
C |
2 |
0 |
Fil. Bem MNT |
|
|
|
R |
|
Inclui .Or. At040NoSTP() |
S |
AA3_FILLOC |
C |
2 |
0 |
Fil. Locacao |
|
TC001FIPRD(M->AA3_FILLOC) |
|
R |
|
INCLUI |
S |
AA3_HMEATV |
C |
1 |
0 |
AtvHorimetro |
@! |
Pertence("12") .AND. At040VdHME() |
|
R |
1=Sim;2=Nao |
|
S |
AA3_HMESEP |
N |
8 |
0 |
Horim Separ. |
@E 99999999 |
|
|
R |
|
|
S |
AA3_CONSEP |
L |
1 |
0 |
HrSep Atual? |
|
|
|
R |
|
|
S |
AA3_HMERET |
N |
8 |
0 |
HorimRetorno |
@E 99999999 |
|
|
R |
|
|
S |
AA3_CONRET |
L |
1 |
0 |
HrRet Atual? |
|
|
|
R |
|
|
S |
AA3_HMELIM |
N |
2 |
0 |
Horim.Limite |
@E 99 |
Positivo() |
|
R |
|
M->AA3_HMEATV == "1" |
S |
AA3_QTDATF |
N |
11 |
2 |
Ativo Fixo |
@E 99,999,999.99 |
|
|
V |
|
|
S |
AA3_SLDLOC |
N |
11 |
2 |
Locado |
@E 99,999,999.99 |
|
|
V |
|
|
S |
AA3_SLDRES |
N |
11 |
2 |
Reservado |
@E 99,999,999.99 |
|
|
V |
|
|
S |
AA3_SLDMAN |
N |
11 |
2 |
Manutencao |
@E 99,999,999.99 |
|
|
V |
|
|
S |
AA3_SLDBLQ |
N |
11 |
2 |
Bloqueado |
@E 99,999,999.99 |
|
|
V |
|
|
S |
AA3_SLDDIS |
N |
11 |
2 |
Disponivel |
@E 99,999,999.99 |
|
|
V |
|
|
S |