| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| NX1 | Pre-fatura Caso | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| NX1_FILIAL | C | 2 | 0 | Filial | R | N | |||||
| NX1_TKRET | L | 1 | 0 | Marcar ? | J202TKTDS('NX1') | V | N | ||||
| NX1_CPREFT | C | 8 | 0 | Codigo Pre | R | N | |||||
| NX1_CCLIEN | C | 6 | 0 | Cod Cliente | @! | R | N | ||||
| NX1_CLOJA | C | 2 | 0 | Cod Loja | @! | R | N | ||||
| NX1_DCLIEN | C | 30 | 0 | Nome Cliente | V | N | |||||
| NX1_CCONTR | C | 6 | 0 | Cod Contrato | R | N | |||||
| NX1_DCONTR | C | 30 | 0 | Des Contrato | V | N | |||||
| NX1_CCASO | C | 6 | 0 | Cod Caso | R | N | |||||
| NX1_DCASO | C | 200 | 0 | Titulo Caso | @S100 | V | N | ||||
| NX1_VLREMB | N | 16 | 2 | Vl Desp Remb | @E 9,999,999,999,999.99 | R | S | ||||
| NX1_VLTRIB | N | 16 | 2 | Vl Desp Trib | @E 9,999,999,999,999.99 | R | S | ||||
| NX1_CJCONT | C | 4 | 0 | Cod Juncao | R | N | |||||
| NX1_DJCONT | C | 100 | 0 | Desc Juncao | V | N | |||||
| NX1_VDESP | N | 16 | 2 | Valor Desp | @E 9,999,999,999,999.99 | JANX1_VDES() | R | J202WhDesp("NX1_VDESP") | N | ||
| NX1_VTAB | N | 16 | 2 | Valor Tab | @E 9,999,999,999,999.99 | R | N | ||||
| NX1_VLDESC | N | 16 | 2 | V Desc Espec | @E 9,999,999,999,999.99 | JA202VDESC("NX1_VLDESC") | R | N | |||
| NX1_PCDESC | N | 16 | 8 | % Desc Espec | @E 9,999,999.99999999 | JA202VDESC("NX1_PCDESC") | R | S | |||
| NX1_VDESCO | N | 16 | 2 | V Desc Lin. | @E 9,999,999,999,999.99 | R | N | ||||
| NX1_VDESCT | N | 16 | 2 | V Total Desc | @E 9,999,999,999,999.99 | R | S | ||||
| NX1_PDESCH | N | 16 | 8 | % Desc Lin. | @E 9,999,999.99999999 | JA202VDESC("NX1_PDESCH") | R | S | |||
| NX1_VFIXO | N | 16 | 2 | Valor Fixo | @E 9,999,999,999,999.99 | R | S | ||||
| NX1_VEXITO | N | 16 | 2 | Vl Exito | @E 9,999,999,999,999.99 | R | N | ||||
| NX1_VTS | N | 16 | 2 | Vl TS | @E 9,999,999,999,999.99 | JANX1_VTS () | R | N | |||
| NX1_VTSTAB | N | 16 | 2 | Vl TS Tab | @E 9,999,999,999,999.99 | R | N | ||||
| NX1_VTSVIN | N | 16 | 2 | Vlr TS Vinc | @E 9,999,999,999,999.99 | R | S | ||||
| NX1_VTSANT | N | 16 | 2 | Vlr TS Anter | @E 9,999,999,999,999.99 | R | S | ||||
| NX1_CMOETH | C | 2 | 0 | Cod Moe TabH | R | N | |||||
| NX1_DMOETH | C | 10 | 0 | Des Moe TabH | V | N | |||||
| NX1_REDAC | M | 10 | 0 | Redacao | R | N | |||||
| NX1_TSREV | C | 1 | 0 | TS Rev | Pertence("12") | R | 1=Sim;2=Nao | N | |||
| NX1_DSPREV | C | 1 | 0 | Desp Rev | Pertence("12") | R | 1=Sim;2=Nao | N | |||
| NX1_TABREV | C | 1 | 0 | Lanc Tab Rev | Pertence("12") | R | 1=Sim;2=Nao | N | |||
| NX1_CPAREX | C | 8 | 0 | Cod Parc Exi | R | N | |||||
| NX1_CODEXI | C | 1 | 0 | Cond Exito? | Pertence("12") | R | 1=Sim;2=Nao | N | |||
| NX1_TS | C | 1 | 0 | Time Sheet? | Pertence("12") | R | 1=Sim;2=Nao | N | |||
| NX1_DESP | C | 1 | 0 | Despesa? | Pertence("12") | R | 1=Sim;2=Nao | N | |||
| NX1_LANTAB | C | 1 | 0 | Lanc Tab? | Pertence("12") | R | 1=Sim;2=Nao | N | |||
| NX1_SIGLA | C | 5 | 0 | Sig Revisor | Vazio().Or.(ExistCpo('RD0',FWFLDGET('NX1_SIGLA'),9).And.JURRD0('NX1DETAIL','NX1_SIGLA','3',.T.)) | RD0REV | V | S | |||
| NX1_CPART | C | 6 | 0 | Cod Revisor | Vazio().Or.Iif(JurIsRest(),(ExistCpo('RD0',FWFLDGET('NX1_CPART'),1).And.JURRD0('NX1DETAIL','NX1_CPART','1')),.T.) | R | N | ||||
| NX1_DPART | C | 30 | 0 | Nome Revisor | V | N | |||||
| NX1_VEXLIM | N | 16 | 2 | Vl Exc Limit | @E 9,999,999,999,999.99 | R | N | ||||
| NX1_VFXFAT | N | 16 | 2 | Vl Faixa Fat | @E 9,999,999,999,999.99 | R | N | ||||
| NX1_VUTFAT | N | 16 | 2 | Vl Uti Fat | @E 9,999,999,999,999.99 | R | N | ||||
| NX1_VSLDPX | N | 16 | 2 | Vl Sldo Prox | @E 9,999,999,999,999.99 | R | N | ||||
| NX1_DTPREL | C | 50 | 0 | Desc Tp Rel | V | N | |||||
| NX1_CTPREL | C | 4 | 0 | Cod Tipo Rel | R | N | |||||
| NX1_VHON | N | 16 | 2 | Vlr Honor | @E 9,999,999,999,999.99 | R | S | ||||
| NX1_SITREV | C | 1 | 0 | Revisado? | Pertence("123") | R | 1=Sim;2=Nao;3=Parcialmente | S | |||
| NX1_RETREV | C | 4 | 0 | Retorno Revi | Vazio().Or.ExistCpo('NSC',FWFLDGET('NX1_RETREV'),1) | NSC | R | S | |||
| NX1_DRETRV | C | 50 | 0 | Desc Ret Rev | V | S | |||||
| NX1_INSREV | M | 10 | 0 | Inst Revisao | R | S | |||||
| NX1_INSFAT | M | 10 | 0 | Inst Faturam | R | S | |||||
| NX1_DESCEX | C | 1 | 0 | Desc Excede | Pertence("12") | R | 1=Sim;2=Nao | S | |||
| NX1_VTBVIN | N | 16 | 2 | Vlr Tab Vinc | @E 9,999,999,999,999.99 | R | S | ||||
| NX1_VFXVIN | N | 16 | 2 | Vlr Fix Vinc | @E 9,999,999,999,999.99 | R | S | ||||
| NX1_CONTTS | N | 10 | 0 | Time Sheets | @E 9,999,999,999 | V | S | ||||
| NX1_CONTDP | N | 10 | 0 | Despesas | @E 9,999,999,999 | V | S | ||||
| NX1_CONTLT | N | 10 | 0 | Lanc. tab. | @E 9,999,999,999 | V | S | ||||
| NX1_CIDIO | C | 2 | 0 | Cod. Idioma | V | S | |||||
| NX1_CMOELI | C | 2 | 0 | Moeda Limite | R | S | |||||
| NX1_VLRLI | N | 13 | 2 | Valor limite | @E 9,999,999,999.99 | R | S | ||||
| NX1_SALDOI | N | 13 | 2 | Vl. Ini. Lim | @E 9,999,999,999.99 | R | S | ||||
| NX1_CTBCVL | C | 1 | 0 | Serv Tb Lim? | Pertence("12") | R | 1=Sim;2=Nao | S | |||
| NX1_CFACVL | C | 1 | 0 | Fat Adi Lim? | Pertence("12") | R | 1=Sim;2=Nao | S | |||
| NX1_UTLIMT | N | 13 | 2 | Vl Utl Limit | @E 9,999,999,999.99 | R | S | ||||