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