Tabela |
NT0 |
Contratos do Faturamento |
Campo |
Tipo |
Tamanho |
Decimal |
Titulo |
Formato |
Validacao |
F3 |
Contexto |
Lista |
Condicao |
PYME |
NT0_FILIAL |
C |
2 |
0 |
Filial |
|
|
|
R |
|
|
N |
NT0_COD |
C |
6 |
0 |
Codigo |
|
ExistChav('NT0',M->NT0_COD,1) |
|
R |
|
INCLUI |
N |
NT0_NOME |
C |
30 |
0 |
Descricao |
|
|
|
R |
|
|
N |
NT0_CGRPCL |
C |
6 |
0 |
Cod Grp Cli |
|
Vazio() .OR. J96SA1NT0V() |
ACY |
R |
|
|
N |
NT0_DGRPCL |
C |
30 |
0 |
Desc Grp Cli |
|
|
|
V |
|
|
N |
NT0_CCLIEN |
C |
6 |
0 |
Cl Principal |
@! |
Vazio() .OR. J96SA1NT0V() |
SA1NUH |
R |
|
|
N |
NT0_CLOJA |
C |
2 |
0 |
Cod Loja |
@! |
Vazio() .OR. J96SA1NT0V() |
|
R |
|
|
N |
NT0_DCLIEN |
C |
40 |
0 |
Nome cliente |
|
|
|
V |
|
|
N |
NT0_SIGLA1 |
C |
5 |
0 |
Socio Resp. |
|
Vazio().Or.(ExistCpo('RD0',FWFLDGET('NT0_SIGLA1'),9).And.JURRD0('NT0MASTER','NT0_SIGLA1','3',.T.)) |
RD0REV |
V |
|
|
S |
NT0_CPART1 |
C |
6 |
0 |
Cod Socio |
|
Vazio().Or.Iif(JurIsRest(),(ExistCpo('RD0',FWFLDGET('NT0_CPART1'),1).And.JURRD0('NT0MASTER','NT0_CPART1','3')),.T.) |
RD0REV |
R |
|
|
N |
NT0_DPART1 |
C |
30 |
0 |
Nome Socio |
|
|
|
V |
|
|
N |
NT0_CMOE |
C |
2 |
0 |
Moeda Prefat |
|
Vazio().or.ExistCpo('CTO',M->NT0_CMOE,1) |
JURCTO |
R |
|
|
N |
NT0_DMOE |
C |
10 |
0 |
Simb moeda |
|
|
|
V |
|
|
N |
NT0_CESCR |
C |
5 |
0 |
Cod Esc Fat |
|
Vazio().Or.(ExistCpo('NS7',M->NT0_CESCR,1).AND.JAVLDCAMPO('NT0MASTER','NT0_CESCR','NS7','NS7_EMITEF','1')) |
NS7 |
R |
|
|
N |
NT0_DESCR |
C |
100 |
0 |
Des Escr Fat |
@S15 |
|
|
V |
|
|
N |
NT0_CRELAT |
C |
4 |
0 |
Cod Relat |
|
Vazio() .or. (ExistCpo('NRJ',M->NT0_CRELAT,1).and.J096VldRel()) |
NRJCTR |
R |
|
|
N |
NT0_DRELAT |
C |
50 |
0 |
Desc Relat |
@S30 |
|
|
V |
|
|
N |
NT0_CIDIO |
C |
2 |
0 |
Cod Idi PreF |
|
ExistCpo('NR1',M->NT0_CIDIO,1).OR.Vazio() |
NR1 |
R |
|
|
N |
NT0_DIDIO |
C |
100 |
0 |
Des Idi PreF |
@S15 |
|
|
V |
|
|
N |
NT0_DTINC |
D |
8 |
0 |
Dt Criacao |
|
|
|
R |
|
|
N |
NT0_USRINC |
C |
15 |
0 |
Usuario inc |
|
|
|
R |
|
|
N |
NT0_CTPHON |
C |
3 |
0 |
Cod honor |
|
Vazio().OR.( ExistCpo('NRA',M->NT0_CTPHON,1) .and. J096VTpHon() ) |
NRA |
R |
|
|
N |
NT0_DTPHON |
C |
100 |
0 |
Desc honor |
@S30 |
|
|
V |
|
|
N |
NT0_DTVIGI |
D |
8 |
0 |
Vigencia Ini |
|
J096VldData() |
|
R |
|
|
S |
NT0_DTVIGF |
D |
8 |
0 |
Vigencia Fin |
|
J096VldData() |
|
R |
|
|
S |
NT0_DESPES |
C |
1 |
0 |
Cob despesas |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_SERTAB |
C |
1 |
0 |
Cobrar serv |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_ENCH |
C |
1 |
0 |
Enc cob hon |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NT0_ENCD |
C |
1 |
0 |
Enc cob desp |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NT0_ENCT |
C |
1 |
0 |
Enc cob serv |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NT0_CONTR |
C |
1 |
0 |
Contrato |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NT0_SIT |
C |
1 |
0 |
Situacao |
|
Pertence("12") |
|
R |
1=Provisorio;2=Definitivo |
|
N |
NT0_REV |
C |
1 |
0 |
Revisado? |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NT0_CMOELI |
C |
2 |
0 |
Cod Moeda |
|
ExistCpo('CTO',M->NT0_CMOELI,1).OR.Vazio() |
JURCTO |
R |
|
|
N |
NT0_DMOELI |
C |
10 |
0 |
Desc Moeda |
|
|
|
V |
|
|
N |
NT0_VLRLI |
N |
13 |
2 |
Valor Limite |
@E 9,999,999,999.99 |
JA096VLIM() |
|
R |
|
|
N |
NT0_SALDOI |
N |
13 |
2 |
Vlr Util Lim |
@E 9,999,999,999.99 |
JA096VLIM() |
|
R |
|
|
N |
NT0_DISPON |
N |
13 |
2 |
Disponivel |
@E 9,999,999,999.99 |
|
|
V |
|
|
N |
NT0_VLRLIF |
N |
13 |
2 |
Limite Fat |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
NT0_DTBASE |
D |
8 |
0 |
Data Base |
|
|
|
R |
|
|
N |
NT0_CMOEF |
C |
2 |
0 |
Cod Moeda |
|
Vazio().OR. ExistCpo('CTO',M->NT0_CMOEF,1) |
JURCTO |
R |
|
|
N |
NT0_DMOEF |
C |
10 |
0 |
Desc Moeda |
|
|
|
V |
|
|
N |
NT0_VLRBAS |
N |
13 |
2 |
Valor Base |
@E 9,999,999,999.99 |
|
|
R |
|
|
N |
NT0_VALORA |
N |
13 |
2 |
Vlr Base Atu |
@E 9,999,999,999.99 |
|
|
R |
|
|
S |
NT0_DATAAT |
D |
8 |
0 |
Dt Atu Base |
|
|
|
R |
|
|
S |
NT0_PERFIX |
N |
14 |
0 |
Per Cobranca |
@E 99,999,999,999,999 |
|
|
R |
|
|
N |
NT0_PEREX |
N |
14 |
0 |
Per Excedent |
@E 99,999,999,999,999 |
|
|
R |
|
|
N |
NT0_TPCEXC |
C |
1 |
0 |
Tp Cob Exc |
|
J096VLDCP("NT0_TPCEXC") |
|
R |
1=Hora;2=Valor |
|
N |
NT0_LIMEXH |
N |
14 |
2 |
Lim Horas |
@E 99,999,999,999.99 |
|
|
R |
|
M->NT0_TPCEXC=="1" |
N |
NT0_PERCD |
N |
13 |
2 |
% Desc Exc |
@E 9,999,999,999.99 |
Vazio() .Or. Positivo() |
|
R |
|
M->NT0_TPCEXC=="2" |
N |
NT0_PARFIX |
C |
1 |
0 |
Parc fixas? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_FINAJU |
C |
1 |
0 |
Cob no final |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_FIXEXC |
C |
1 |
0 |
Fixo e exc |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_TPFX |
C |
1 |
0 |
Tipo Faixa |
|
|
|
R |
1=Tabela Estatica;2=Tabela Progressiva |
|
N |
NT0_CALFX |
C |
1 |
0 |
Tipo Calculo |
|
Vazio().Or.(Pertence("12").And.JVldCalFx()) |
|
R |
1=Valor;2=Hora |
|
N |
NT0_CASPRO |
C |
1 |
0 |
Qtdade por? |
|
Vazio().Or.Pertence("12") |
|
R |
1=Casos;2=Processos |
|
S |
NT0_FXENCM |
C |
1 |
0 |
Enc periodo? |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NT0_FXABM |
C |
1 |
0 |
Aber period? |
|
|
|
R |
1=Sim;2=Nao |
|
N |
NT0_COPFAT |
C |
254 |
0 |
Copia Fatura |
@S25 |
|
|
R |
|
|
N |
NT0_DESPAD |
N |
12 |
8 |
% Desc Lin. |
@E 999.99999999 |
M->NT0_DESPAD <= 100.00 |
|
R |
|
J096When("NT0_DESPAD") |
N |
NT0_TPERCD |
C |
1 |
0 |
Tp Perc Desc |
|
Vazio().Or.Pertence("123") |
|
R |
1=Hora;2=Tabelado;3=Ambos |
|
S |
NT0_DTREFI |
D |
8 |
0 |
Ref Inicial |
|
|
|
R |
|
|
N |
NT0_DTREFF |
D |
8 |
0 |
Dt ref fim |
|
M->NT0_DTREFF > M->NT0_DTREFI |
|
R |
|
|
N |
NT0_QTPARC |
N |
11 |
0 |
Qtd Parcelas |
@E 99,999,999,999 |
|
|
R |
|
|
N |
NT0_DTVENC |
D |
8 |
0 |
Prim Vencto |
|
M->NT0_DTVENC >= M->NT0_DTREFI |
|
R |
|
|
N |
NT0_DIAEMI |
N |
2 |
0 |
Dia Max Emi |
@E 99 |
M->NT0_DIAEMI >= 0 .AND. M->NT0_DIAEMI <= 31 |
|
R |
|
|
N |
NT0_DISCAS |
C |
1 |
0 |
Discr caso |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_TITFAT |
C |
200 |
0 |
Titulo Fatu |
|
|
|
R |
|
M->NT0_DISCAS=="2" |
N |
NT0_DTENC |
D |
8 |
0 |
Data encerra |
|
JA096VLENC().or.Vazio() |
|
R |
|
|
N |
NT0_ATIVO |
C |
1 |
0 |
Ativo? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
J096When( "NT0_ATIVO") |
N |
NT0_TPVDIV |
C |
1 |
0 |
Tipo Divisao |
|
Vazio().Or.Pertence("12 ") |
|
R |
1=Percentual;2=Valor Fixo |
!Empty(M->NT0_CTPHON) |
N |
NT0_VALDIV |
N |
16 |
2 |
Vlr. Divisao |
@E 9,999,999,999,999.99 |
(Positivo().Or.Vazio() ) .and. J096ValDiv() |
|
R |
|
!Empty(M->NT0_CTPHON) |
N |
NT0_TPCORR |
C |
1 |
0 |
Tp Correcao |
|
Vazio().Or.Pertence("12") |
|
R |
1=Nao Corrigir;2=Indice |
|
N |
NT0_PERCOR |
N |
14 |
0 |
Per Correcao |
@E 99,999,999,999,999 |
|
|
R |
|
M->NT0_TPCORR == '2' |
N |
NT0_CINDIC |
C |
2 |
0 |
Cod Indice |
|
Vazio().Or.ExistCpo('NW5',M->NT0_CINDIC,1) |
NW5 |
R |
|
M->NT0_TPCORR == '2' |
N |
NT0_DINDIC |
C |
10 |
0 |
Desc Indice |
|
|
|
V |
|
|
N |
NT0_OBS |
M |
10 |
0 |
Observacao |
|
|
|
R |
|
|
N |
NT0_PARCE |
C |
1 |
0 |
Parcelar? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_DESPAR |
C |
4 |
0 |
Cod Des Parc |
|
ExistCpo('NXK',M->NT0_DESPAR,1) .AND. JA029VLATI("NXK","NXK_ATIVO",M->NT0_DESPAR) .OR. Vazio() |
NXK |
R |
|
|
N |
NT0_DECPAR |
C |
100 |
0 |
Desc Parcela |
@S30 |
|
|
V |
|
|
N |
NT0_CFXCVL |
C |
1 |
0 |
Fixo Lim? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_CTBCVL |
C |
1 |
0 |
Serv Tb Lim? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_CFACVL |
C |
1 |
0 |
Fat Adi Lim? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_CEXCVL |
C |
1 |
0 |
Exito Lim? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
N |
NT0_CTIPOF |
C |
3 |
0 |
Cod Tp Fat |
|
Vazio().OR.ExistCpo('NR9',M->NT0_CTIPOF,1) |
NR9 |
R |
|
|
N |
NT0_DTIPOF |
C |
100 |
0 |
Desc Tp Fat |
@S30 |
|
|
V |
|
|
N |
NT0_RELPRE |
C |
4 |
0 |
Cod Rel Pre |
|
Vazio() .or. (ExistCpo('NZO',FwFldGet("NT0_RELPRE"),1) .and. JNzoVldTrf(FwFldGet("NT0_RELPRE"))) |
NZO |
R |
|
|
N |
NT0_DRELPR |
C |
50 |
0 |
Desc Rel Pre |
|
|
|
V |
|
|
N |
NT0_PONUMB |
C |
100 |
0 |
PO Number |
|
|
|
R |
|
|
S |
NT0_SERVIC |
M |
10 |
0 |
Frase Servic |
|
|
|
R |
|
|
S |
NT0_CASMAE |
C |
1 |
0 |
Aloc unific? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |
NT0_CCLICM |
C |
6 |
0 |
Cod Cliente |
@! |
Vazio().OR.JurVldCli("", M->NT0_CCLICM, M->NT0_CLOJCM,,,"CLI") |
SA1NUH |
R |
|
M->NT0_CASMAE=='1' |
S |
NT0_CLOJCM |
C |
2 |
0 |
Cod Loja |
@! |
Vazio().OR.JurVldCli("", M->NT0_CCLICM, M->NT0_CLOJCM,,,"LOJ") |
|
R |
|
M->NT0_CASMAE=='1' |
S |
NT0_CCASCM |
C |
6 |
0 |
Cod Caso Mae |
|
Vazio().OR.JurVldCli("", M->NT0_CCLICM, M->NT0_CLOJCM,M->NT0_CCASCM,,"CAS") |
JURNVE |
R |
|
M->NT0_CASMAE=='1' |
S |
NT0_TPSERV |
C |
2 |
0 |
Tipo Servico |
@! |
|
DZ |
R |
|
|
S |
NT0_FIXREV |
C |
1 |
0 |
Revisa Fixo? |
|
Pertence("12") |
|
R |
1=Sim;2=Nao |
|
S |