Tabela
TRX CADASTRO DE MULTAS
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
TRX_FILIAL C 2 0 Filial S
TRX_MULTA C 9 0 Multa @R! 999/99/99 MNT765MUL() S
TRX_TPMULT C 20 0 Tipo Multa @! R S
TRX_DTINFR D 8 0 Dta Infracao 99/99/9999 If(!Empty(M->TRX_DTINFR),NGCPDIAATU(M->TRX_DTINFR,'<=',.T.,.T.,.T.),.T.) .AND. MNT765DTIN() .AND. MNT765DTER() S
TRX_RHINFR C 5 0 Hra Infracao 99:99 NGVALHORA(M->TRX_RHINFR,.T.) S
TRX_DTREC D 8 0 Dta Recebime 99/99/9999 If(!Empty(M->TRX_DTREC),NGCPDIAATU(M->TRX_DTREC,'<=',.T.,.T.,.T.),.T.) .And. (M->TRX_DTREC >= M->TRX_DTINFR) S
TRX_NUMAIT C 14 0 Nro Infracao @! R MNT765WHNI() S
TRX_CODINF C 8 0 Infracao @! EXISTCPO('TSH',M->TRX_CODINF) .AND. MNTA765RES(1) .AND. MNT765INF() TSH R If(lIntFin,MNTPARCPAG(.f.),.t.) S
TRX_ARTIGO C 30 0 Artigo @! V S
TRX_DESART C 80 0 Descricao @! V S
TRX_PONTUA C 1 0 Pontuacao @! V N
TRX_RODOVI C 6 0 Rodovia @! If(!Empty(M->TRX_RODOVI),EXISTCPO('DTZ',M->TRX_RODOVI),.t.) DTZ R S
TRX_NOMROD C 20 0 Nome Rodov. @! V S
TRX_LOCAL C 240 0 Local Infrac @! S
TRX_GRPVEN C 6 0 Grupo Regiao @! ExistCpo('DUY',M->TRX_GRPVEN,1) DUY R lMntTms S
TRX_CIDINF C 40 0 Cidade @! R S
TRX_UFINF C 2 0 Uf Infracao @! EXISTCPO('SX5','12'+M->TRX_UFINF) 12 R S
TRX_CODOR C 6 0 Orgao Autuad @! If(!Empty(M->TRX_CODOR),EXISTCPO('TRZ',M->TRX_CODOR) .And. If(lIntFin,MNT765OAOK(),.t.),.t.) TRZ R If(lIntFin,Inclui,.t.) S
TRX_NOMOR C 40 0 Descricao @! V S
TRX_PLACA C 8 0 Placa Veicu. @! MNTA765PLA(M->TRX_PLACA) .AND. MNTA765BEM(1) NGZ R S
TRX_CODBEM C 16 0 Veiculo @! R M->TRX_INDFOB = '1' S
TRX_OPERAC C 1 0 Operacao @! R 1=Coleta;2=Transporte;3=Entrega;4=Terceiro;5=Outros S
TRX_RENAVA C 15 0 Renavam @! R M->TRX_INDFOB = '1' S
TRX_CODMO C 6 0 Motorista @! If(M->TRX_INDFOB='2',EXISTCPO('DA4',M->TRX_CODMO),.T.) DA4 R M->TRX_INDFOB = '2' S
TRX_NOME C 40 0 Nome Motoris @! R M->TRX_INDFOB = '1' S
TRX_FILMOT C 2 0 Filial Mot. EXISTCPO('SM0',SM0->M0_CODIGO+M->TRX_FILMOT) DLB R S
TRX_REPON C 1 0 Responsabili @! R 1=Motorista;2=Empresa;3=Pessoa Fisica;4=Pessoa Juridica e FIsica;5=Seguradora;6=Transportador;7=Expedidor S
TRX_PAGTO C 1 0 Pagamento? @! MNTA765PAG() .AND. MNT765RES() R 1=Sim;2=Nao If(lIntFin,lAntesAlt,.t.) .And. MNT765PGIN() S
TRX_DTVECI D 8 0 Dt. Vencto. (M->TRX_DTVECI >= M->TRX_DTINFR) .AND. M765NDESCO(1) R MNT765WHVC() S
TRX_VALOR N 12 2 Valor Multa @E 999,999,999.99 NGMAQUEZERO(M->TRX_VALOR,'TRX_VALOR',.t.) .And. MNTA765ATV(2) .And. MNT765VENC(2,2) If(lIntFin,MNTPARCPAG(.f.),.t.) S
TRX_DESCON N 12 2 Valor Desc. @E 999,999,999.99 MNTA765DES(1) .AND. POSITIVO() R If(lIntFin,MNTPARCPAG(.f.),MNTA765DEF() .AND. lDesco) S
TRX_PCTDSC N 6 2 % Desconto @E 999.99 MNT765VLD() R IIf(M->TRX_PAGTO = '1', .F., .T.) S
TRX_DTPGTO D 8 0 Dt. Pgto. MNTA765DPG() .AND. M765NDESCO(1) R MNT765WHDP() S
TRX_VALPAG N 12 2 Valor Pago @E 999,999,999.99 MNTA765DES(2) .And. Positivo() R MNT765WHVP() S
TRX_DTEMIS D 8 0 Dt. Emissao If(!Empty(M->TRX_DTEMIS),NGCPDIAATU(M->TRX_DTEMIS,'<=',.T.,.T.,.T.) .And. MNT765VENC(1),.t.) R MNT765WHEM() S
TRX_NUMSP C 15 0 Nro S. Paga. @! R M->TRX_PAGTO = '1' .AND. MNTA765DEF() S
TRX_CODAC C 6 0 Codigo Acao @! VAZIO() .OR. EXISTCPO('TSF',M->TRX_CODAC) TSF R M->TRX_PAGTO = '1' .AND. MNTA765DEF() S
TRX_DESACA C 40 0 Descri. Acao @! V S
TRX_INFRAC C 1 0 Ind Condutor @! PERTENCE('12') .AND. MNTA765LIM() 1=Sim;2=Nao S
TRX_DTIND D 8 0 Data Ind. 99/99/9999 IIF(!Empty(M->TRX_DTIND),VALDT(M->TRX_DTIND) .AND. MNT765DTIN(),.t.) R M->TRX_INFRAC = '1' S
TRX_DTNAR D 8 0 Dt. Aviso 99/99/9999 R M->TRX_INFRAC = '1' S
TRX_NUMAR C 20 0 Documento @! R M->TRX_INFRAC = '1' S
TRX_STATUS C 1 0 Status Multa @! PERTENCE('123') R 1=Registrado;2=Em Andamento;3=Concluido S
TRX_RECURS C 1 0 Tem Recurso? @! MNT765REC() .And. MNT765RES() R 1=Sim;2=Nao M->TRX_CABREC='1' .AND. MNT765WHRC() S
TRX_INDREC C 1 0 Recurso @! MNT765REC() R 1=Pela Empresa;2=Pelo Motorista M->TRX_CABREC='1' S
TRX_DTENRE D 8 0 Entr Recurso 99/99/9999 MNT765DTER() .AND. MNT765DTR1() M->TRX_RECURS='1' .And. (M->TRX_SITREC='1' .Or. Inclui) S
TRX_NUMCI C 10 0 Nro CI Recur @! M->TRX_RECURS='1' .And. (M->TRX_SITREC='1' .Or. Inclui) S
TRX_MOTREC C 6 0 Motivo Recur @! VAZIO() .OR. EXISTCPO('TSD',M->TRX_MOTREC) TSD M->TRX_RECURS='1' .And. (M->TRX_SITREC='1' .Or. Inclui) S
TRX_DESMOT C 30 0 Desc. Motivo @! V S
TRX_SITREC C 1 0 Sit. Recurso @! PERTENCE('123') .AND. MNT765RES() .AND. MNT765SEGI() R 1=Pendente;2=Recurso Deferido;3=Resurso Indeferido M->TRX_RECURS='1' .AND. lDef .AND. lSegSim .And. lSitRec S
TRX_DTFIRE D 8 0 Dt. Fim Rec. 99/99/9999 MNT765DTFR() .AND. MNT765DTR1() R M->TRX_RECURS = '1' .AND. lDef .AND. (lDtFim .OR. Inclui) S
TRX_SEGINS C 1 0 Segunda In.? @! MNT765SEGI() .And. MNT765RES() R 1=Sim;2=Nao M->TRX_SITREC = '3' .AND. lDef .AND. MNT765WHSI() S
TRX_DTENR2 D 8 0 Entr Rec. 2 99/99/9999 MNT765DTFR() .AND. MNT765DTR2() lSegIns .AND. lSeg1 S
TRX_NUMCI2 C 10 0 Nro CI Rec 2 @! lSegIns .AND. lSeg2 S
TRX_MOTRE2 C 6 0 Motivo Rec 2 @! EXISTCPO('TSD',M->TRX_MOTRE2) TSD lSegIns .AND. lSeg3 S
TRX_SITRE2 C 1 0 Sit. Rec. 2 @! PERTENCE('123') .AND. MNT765SEGI() .AND. MNT765RES() R 1=Pendente;2=Recurso Deferido;3=Resurso Indeferido lSegIns .AND. lDef .AND. lSeg4 S
TRX_DTFIR2 D 8 0 Dt. Fim Rec2 99/99/9999 MNT765DTR2() R lSegIns .AND. lSeg5 .AND. lDef S
TRX_ORIGEM C 1 0 Origem Multa @! PERTENCE('12') .AND. MNTA765ORI() .And. MNT765ORI() R 1=Auto Policial;2=Eletronica S
TRX_RECAUT C 1 0 Rec Auto Inf @! PERTENCE('12') .AND. MNTA765ORI() R 1=Sim;2=Nao S
TRX_RECNOT C 1 0 Rec Notifica @! PERTENCE('123') R 1=Sim;2=Nao;3=Pendente lRecNot S
TRX_NOTDT D 8 0 Dt Notifica. 99/99/9999 IIF(!Empty(M->TRX_NOTDT),(M->TRX_NOTDT >= M->TRX_DTINFR) .And. MNT765NOT(),.t.) R S
TRX_DTDIGI D 8 0 Dt Digitacao 99/99/9999 S
TRX_HRDIGI C 5 0 Hr Digitacao 99:99 NGVALHORA(M->TRX_HRDIGI,.T.) S
TRX_USUDIG C 15 0 Usuario Dig. @! S
TRX_NF C 9 0 Nota Fiscal @! R S
TRX_DATADV D 8 0 Dt. Advert. 99/99/9999 MNTA765ADV() R M->TRX_REPON = '2' S
TRX_CABREC C 1 0 Cabe Rec.? @! MNTA765CRE() R 1=Sim;2=Nao Inclui .Or. !(TRX->TRX_SITREC <> '1') S
TRX_RESTIT C 1 0 Restituicao @! Pertence('12') .And. MNT765RES() 1=Sim;2=Nao S
TRX_OBS M 80 0 Observacao @! V S
TRX_OBPAGA M 80 0 Observacao V S
TRX_OBCOND M 80 0 Observacao V S
TRX_OBRECU M 80 0 Observacao V M->TRX_RECURS = '1' .AND. lDef .AND. (lSeg4 .OR. Inclui) S
TRX_CCUSTO C 9 0 Centro Custo @! CTB105CC() CTT R S
TRX_NOMCUS C 30 0 Nome C.Custo @! V S
TRX_ADVERT C 1 0 Ger. Advert? @! R 1=Sim;2=Nao M->TRX_PAGTO='1' .AND. M->TRX_SITREC <> '2' S
TRX_NUMAPD C 10 0 N. da APD @! EXISTCPO('TSI',M->TRX_MULTA+M->TRX_NUMAPD) TSI R M->TRX_PAGTO = '1' .AND. M->TRX_SITREC <> '2' S
TRX_DTSOLI D 8 0 Dt Solicit. 99/99/9999 MNT765DTRE() .AND. MNT765DTSO() lRest1 S
TRX_VLRSOL N 9 2 Valor Restit @E 9,999,999.99 lRest2 S
TRX_STSOL C 1 0 Status @! Pertence('12') .AND. MNTA765STA() 1=Em Processo;2=Valor Restituido lRest3 .AND. (TRX->TRX_STSOL <> '2' .OR. Inclui) S
TRX_DTEFET D 8 0 Dt. Ef. Rest 99/99/9999 VALDT(M->TRX_DTEFET) .AND. MNT765DTRE() lRest4 .OR. (Inclui .AND. M->TRX_STSOL = '2') S
TRX_OBREST M 80 0 Observacao V lRest3 .AND. (TRX->TRX_STSOL <> '2' .OR. Inclui) S
TRX_INDFOB C 1 0 Viagem FOB? @! R 1=Sim;2=Nao S
TRX_MMSYP C 6 0 ChaveMM SYP @! R N
TRX_MMPAGA C 6 0 ChaveMM SYP @! R N
TRX_MMCOND C 6 0 ChaveMM SYP @! R N
TRX_MMRECU C 6 0 ChaveMM SYP @! R N
TRX_MMREST C 6 0 ChaveMM SYP @! R N
TRX_PREFIX C 3 0 Prefixo @! R lIntFin .And. Inclui N
TRX_TIPO C 3 0 Tipo ExistCpo("SX5","05"+M->TRX_TIPO) 05 R lIntFin .And. Inclui N
TRX_NUMSE2 C 9 0 No. Titulo @! R lIntFin .And. Inclui N
TRX_NATURE C 10 0 Natureza @! ExistCpo("SED",M->TRX_NATURE) SED lIntFin .And. Inclui N
TRX_CONPAG C 3 0 Cond. Pagto @! ExistCpo("SE4",M->TRX_CONPAG) .AND. MNT765VENC(2) SE4 R Inclui N
TRX_ITEMCT C 9 0 Item Conta @! Vazio() .Or. Ctb105Item() CTD R lTemIte N