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 |