| 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 | |