Tabela |
TS1 |
DCTOS OBRIGATORIOS POR VEICULO |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
TS1_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
S |
TS1_CODBEM |
C |
16 |
0 |
Codigo Bem |
@! |
|
|
R |
|
|
S |
TS1_PLACA |
C |
8 |
0 |
Placa |
@! |
|
|
R |
|
|
S |
TS1_DOCTO |
C |
6 |
0 |
Documento |
@! |
ExistCpo('TS0',M->TS1_DOCTO) .AND. ExistChav('TS1',M->TS1_CODBEM+M->TS1_DOCTO+DTOS(M->TS1_DTVENC)) .AND. MNTA805VAL() |
TS0 |
R |
|
|
S |
TS1_DESDOC |
C |
30 |
0 |
Desc. Doc. |
@! |
|
|
V |
|
|
S |
TS1_VALOR |
N |
9 |
2 |
Valor |
@E 999,999.99 |
NGMAQUEZERO(M->TS1_VALOR,'TS1_VALOR',.t.) .And. MNT805VENC(1,2) |
|
R |
|
lExiste |
S |
TS1_DTEMIS |
D |
8 |
0 |
Emissao |
|
VALDT(M->TS1_DTEMIS) .AND. MNTA805DT() |
|
R |
|
|
S |
TS1_UFEMIS |
C |
2 |
0 |
U.F. |
@! |
|
|
R |
|
|
S |
TS1_DTVENC |
D |
8 |
0 |
Vencimento |
|
MNTA805DT() |
|
R |
|
!lIntFin .And. !lConPag |
S |
TS1_QTDPAR |
N |
2 |
0 |
Parcelas |
99 |
Positivo() |
|
R |
|
|
S |
TS1_RENAVA |
C |
15 |
0 |
Renavam |
@! |
|
|
V |
|
|
S |
TS1_CHASSI |
C |
20 |
0 |
Chassi |
@! |
|
|
V |
|
|
S |
TS1_IDDOCT |
C |
12 |
0 |
Id. Docto. |
@! |
|
|
R |
|
|
S |
TS1_TIPO |
C |
3 |
0 |
Tipo |
@! |
ExistCpo("SX5","05"+M->TS1_TIPO) |
05 |
R |
|
|
N |
TS1_NATURE |
C |
10 |
0 |
Natureza |
@! |
ExistCpo("SED",M->TS1_NATURE) |
SED |
R |
|
|
N |
TS1_PREFIX |
C |
3 |
0 |
Prefixo |
@! |
|
|
R |
|
|
N |
TS1_NUMSE2 |
C |
9 |
0 |
No. Titulo |
@! |
|
|
R |
|
lIntFin |
S |
TS1_FORNEC |
C |
6 |
0 |
Fornecedor |
@! |
ExistCpo("SA2",M->TS1_FORNEC) |
FOR |
R |
|
|
N |
TS1_LOJA |
C |
2 |
0 |
Loja |
@! |
ExistCpo("SA2",M->TS1_FORNEC+M->TS1_LOJA) |
|
R |
|
|
N |
TS1_NOMFOR |
C |
40 |
0 |
Nome Fornece |
@! |
|
|
V |
|
|
N |
TS1_CONPAG |
C |
3 |
0 |
Cond. Pagto |
@! |
ExistCpo("SE4",M->TS1_CONPAG) .AND. MNT805VENC(1) |
SE4 |
R |
|
|
N |
TS1_VALPAG |
N |
9 |
2 |
Valor Pago |
@E 999,999.99 |
|
|
R |
|
|
N |