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