Tabela |
DTY |
Contrato de Carreteiro |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
DTY_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
|
|
|
N |
DTY_FILORI |
C |
2 |
0 |
Fil.Origem |
|
|
|
|
|
|
N |
DTY_NUMCTC |
C |
9 |
0 |
No.Contrato |
@! |
|
|
|
|
|
N |
DTY_DATCTC |
D |
8 |
0 |
Data |
|
|
|
|
|
|
N |
DTY_HORCTC |
C |
4 |
0 |
Hora |
@R 99:99 |
|
|
|
|
|
N |
DTY_VIAGEM |
C |
6 |
0 |
Viagem |
|
|
|
|
|
|
N |
DTY_CODFOR |
C |
6 |
0 |
Cod. Propri. |
@! |
|
|
|
|
|
N |
DTY_LOJFOR |
C |
2 |
0 |
Loja Propri. |
@! |
|
|
|
|
|
N |
DTY_NOMFOR |
C |
40 |
0 |
Proprietario |
@! |
|
|
V |
|
|
N |
DTY_CODMOT |
C |
6 |
0 |
Cd.Motorista |
@! |
|
|
|
|
|
N |
DTY_NOMMOT |
C |
40 |
0 |
Motorista |
@! |
|
|
V |
|
|
N |
DTY_VALFRE |
N |
14 |
2 |
Frete |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_VALPDG |
N |
14 |
2 |
Pedagio |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_ADIFRE |
N |
14 |
2 |
Adiantamento |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_QTDDOC |
N |
5 |
0 |
Qtde.Doctos. |
@E 99,999 |
|
|
|
|
|
N |
DTY_QTDVOL |
N |
5 |
0 |
Qtde.Volumes |
@E 99,999 |
|
|
|
|
|
N |
DTY_PESO |
N |
11 |
4 |
Peso |
@E 999,999.9999 |
|
|
|
|
|
N |
DTY_IRRF |
N |
14 |
2 |
IRRF |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_SEST |
N |
14 |
2 |
SEST/SENAT |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_INSS |
N |
14 |
2 |
INSS |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_ISS |
N |
14 |
2 |
ISS |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_QTDDIA |
N |
5 |
0 |
Diaria Sem. |
@E 99999 |
Positivo() |
|
|
|
|
N |
DTY_DIAFIM |
N |
5 |
0 |
Diaria Fim S |
@E 99999 |
Positivo() |
|
|
|
|
N |
DTY_DOCSDG |
C |
9 |
0 |
No.Doc.Desp. |
@! |
|
|
|
|
|
N |
DTY_TIPCTC |
C |
1 |
0 |
Tip.Contrato |
@! |
Pertence("1234567") |
|
|
1=Por Viagem;2=Por Periodo;3=Por Premio;4=Adiantamento;5=Complemento;6=Carga;7=Redespacho |
|
N |
DTY_VALPRE |
N |
14 |
2 |
Valor Premio |
@E 999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_QTDPER |
N |
3 |
0 |
Qtd.Pernoite |
@E 999 |
Positivo() |
|
|
|
|
N |
DTY_QTDKM |
N |
7 |
1 |
KM Rodado |
@E 9999.9 |
Positivo() |
|
|
|
|
N |
DTY_CODVEI |
C |
8 |
0 |
Cod. Veiculo |
@! |
ExistCpo('DA3') |
|
|
|
|
N |
DTY_TABFRE |
C |
4 |
0 |
Tab.Frete |
@! |
|
|
R |
|
|
N |
DTY_TIPTAB |
C |
2 |
0 |
Tipo Tabela |
@! |
|
|
R |
|
|
N |
DTY_TABCAR |
C |
4 |
0 |
Tab.Carret. |
@! |
|
|
R |
|
|
N |
DTY_CODFAV |
C |
6 |
0 |
Cod. Fav. |
@! |
|
|
|
|
|
N |
DTY_LOJFAV |
C |
2 |
0 |
Loja Fav |
@! |
|
|
|
|
|
N |
DTY_NOMFAV |
C |
40 |
0 |
Nome Fav. |
@! |
|
|
V |
|
|
N |
DTY_FILDEB |
C |
2 |
0 |
Fil.Debito |
|
Vazio().Or.TmsValidEmp(cEmpAnt+M->DTY_FILDEB) |
DLB |
|
|
|
N |
DTY_NUMPC |
C |
6 |
0 |
Ped. Compra |
@! |
|
|
|
|
|
N |
DTY_PIS |
N |
12 |
2 |
Vl.Ret.PIS |
@E 9,999,999.99 |
|
|
|
|
|
N |
DTY_COFINS |
N |
12 |
2 |
Vl.Ret.COF. |
@E 9,999,999.99 |
|
|
|
|
|
N |
DTY_CSLL |
N |
12 |
2 |
Vl.Ret.CSLL |
@E 9,999,999.99 |
|
|
|
|
|
N |
DTY_STATUS |
C |
1 |
0 |
STATUS |
@! |
|
|
R |
1=Em Aberto;2=Aguard. Lib. p/ Pagto;3=Lib. p/ Pagto;4=Contr. Quit. com Ped. Compras;5=Contr. Quitado/Pagto. Realiz;6=Tit. Fatura |
|
N |
DTY_DATLIB |
D |
8 |
0 |
Dt. Liber. |
@D |
|
|
R |
|
|
S |
DTY_OK |
C |
4 |
0 |
OK |
|
|
|
R |
|
|
N |
DTY_BASIMP |
N |
14 |
2 |
Base Imp. |
@E 999,999,999.99 |
|
|
R |
|
|
N |
DTY_CODOPE |
C |
2 |
0 |
Cod. Operad. |
@! |
TMSVALFIELD("M->DTY_CODOPE",.T.,"DTY_NOMOPE") |
|
R |
|
|
N |
DTY_NOMOPE |
C |
30 |
0 |
Nome Operad. |
@! |
|
|
V |
|
|
N |
DTY_DTLIB |
D |
8 |
0 |
Dt. Liber. |
|
|
|
R |
|
|
N |
DTY_CODMOV |
C |
3 |
0 |
Cod. Movto. |
@! |
TMA250Vld() |
DEM |
R |
|
|
N |
DTY_IDENT |
C |
9 |
0 |
Id.Vge/Carga |
@! |
|
|
R |
|
|
N |
DTY_TIPUSO |
C |
1 |
0 |
Utiliza em |
@! |
|
|
R |
1=Viagem;2=Carga |
|
N |
DTY_CARGA |
C |
6 |
0 |
Cod.Carga |
@! |
|
|
V |
|
|
N |
DTY_SEQCAR |
C |
2 |
0 |
Seq.Carga |
@! |
|
|
V |
|
|
N |
DTY_LOCQUI |
C |
1 |
0 |
Local Quitac |
@! |
Pertence('01') |
|
R |
0=Filial,1=Posto |
|
S |
DTY_FILLIB |
C |
2 |
0 |
Fil.Libera. |
|
ExistCpo('SM0', cEmpAnt + M->DTY_FILLIB) |
SM0 |
R |
|
|
S |
DTY_PARCTC |
C |
2 |
0 |
Parcela Ope. |
@! |
|
|
|
|
|
N |
DTY_SOLFLG |
N |
8 |
0 |
Soli. Fluig |
99999999 |
|
|
R |
|
|
N |
DTY_TAXBAN |
N |
6 |
2 |
Tarifa Banco |
@E 999.99 |
|
|
R |
|
|
S |
DTY_VLACRE |
N |
14 |
2 |
Vlr Acresc |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
DTY_TIPFRO |
C |
1 |
0 |
Tipo Frota |
@! |
Pertence("123") |
|
R |
1=Propria;2=Terceiro;3=Agregado |
|
S |
DTY_VLDECR |
N |
14 |
2 |
Vlr Decresc |
@E 99,999,999,999.99 |
|
|
R |
|
|
S |
DTY_PERCUS |
N |
6 |
2 |
% Cust x Rec |
@E 999.99 |
|
|
R |
|
|
S |
DTY_TITFRE |
C |
1 |
0 |
Ger.Tit.Frt. |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
DTY_TITNDF |
C |
1 |
0 |
Ger.Tit.NDF. |
@! |
Pertence('12') |
|
R |
1=Sim;2=Nao |
|
S |
DTY_IDOPE |
C |
20 |
0 |
Id.Ope.Vge. |
@! |
|
|
R |
|
|
S |
DTY_VLSEST |
N |
14 |
2 |
Valor SEST |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_VLSENA |
N |
14 |
2 |
Valor SENAT |
@E 99,999,999,999.99 |
Positivo() |
|
|
|
|
N |
DTY_VLREEM |
N |
14 |
2 |
Valor Reemb. |
@E 99,999,999,999.99 |
Positivo() |
|
R |
|
|
S |
DTY_CODOBS |
C |
6 |
0 |
Codigo Obs. |
999999 |
|
|
R |
|
|
S |
DTY_OBS |
M |
80 |
0 |
Observacao |
|
|
|
V |
|
|
S |