Tabela
NXA Fatura
Campo Tipo Tamanho Decimal Titulo Formato Validacao F3 Contexto Lista Condicao PYME
NXA_FILIAL C 2 0 Filial R S
NXA_CESCR C 5 0 Cod. Escrit. R .F. N
NXA_COD C 9 0 Cod. Fatura R .F. N
NXA_TIPO C 2 0 Tipo R N
NXA_DTEMI D 8 0 Data Emissao R .F. N
NXA_DTVENC D 8 0 Data Vencto J204Venc() R !(NXA->NXA_SITUAC=='2') N
NXA_SITUAC C 1 0 Situacao Pertence("12") R 1=Valida;2=Cancelada .F. N
NXA_STATUS C 1 0 Situacao Fat Pertence("123") V 1=Pendente;2=Paga;3=Parcialmente Paga .F. S
NXA_DTPAGT D 8 0 Data Pgto V S
NXA_VLRPAG N 16 2 Valor Pgto @E 9,999,999,999,999.99 V S
NXA_DTCANC D 8 0 Data Cancto R .F. N
NXA_CMOEDA C 2 0 Cod. Moeda R .F. N
NXA_DMOEDA C 10 0 Sigla Moeda V .F. N
NXA_VLREMB N 16 2 Vl Desp Remb @E 9,999,999,999,999.99 R S
NXA_VLTRIB N 16 2 Vl Desp Trib @E 9,999,999,999,999.99 R S
NXA_VLGROS N 16 2 Vl Gross Up @E 9,999,999,999,999.99 R S
NXA_VLTXAD N 16 2 Vl Taxa Adm @E 9,999,999,999,999.99 R S
NXA_VLTOTD N 16 2 Total Trib. @E 9,999,999,999,999.99 R S
NXA_VALLIQ N 16 2 Valor Liquid @E 9,999,999,999,999.99 V N
NXA_VLFATH N 16 2 Vl Honor @E 9,999,999,999,999.99 R .F. N
NXA_VLFATD N 16 2 Vl Desp @E 9,999,999,999,999.99 R .F. N
NXA_VLDESC N 16 2 Des Total @E 9,999,999,999,999.99 R .F. N
NXA_VLACRE N 16 2 Vl Acrescimo @E 9,999,999,999,999.99 R .F. N
NXA_PIRRF N 5 2 Porc IRRF @E 99.99 R S
NXA_IRRF N 12 2 IRRF @E 999,999,999.99 R .F. N
NXA_PPIS N 5 2 Porc PIS @E 99.99 R S
NXA_PIS N 12 2 PIS @E 999,999,999.99 R .F. N
NXA_PCOFIN N 5 2 Porc COFINS @E 99.99 R S
NXA_COFINS N 12 2 COFINS @E 999,999,999.99 R .F. N
NXA_PCSLL N 5 2 Porc CSLL @E 99.99 R S
NXA_CSLL N 12 2 CSLL @E 999,999,999.99 R .F. N
NXA_PINSS N 5 2 Porc INSS @E 99.99 R S
NXA_INSS N 12 2 INSS @E 999,999,999.99 R N
NXA_ISS N 12 2 ISS @E 999,999,999.99 R N
NXA_CGRPCL C 6 0 Cod grp cli Vazio() R N
NXA_DGRPCL C 30 0 Desc grp cli V N
NXA_CCLIEN C 6 0 Cod. Cliente @! R .F. N
NXA_CLOJA C 2 0 Cod Loja @! R .F. N
NXA_CJCONT C 4 0 Cod. Juncao R .F. N
NXA_DJCONT C 100 0 Desc. Juncao V .F. N
NXA_CCONTR C 6 0 Cod Contrato R .F. N
NXA_DCONTR C 30 0 Des Contrato V .F. N
NXA_WO C 1 0 WO? R 1=Sim;2=Nao .F. N
NXA_DREFIH D 8 0 Dt Ref Ini H R .F. N
NXA_DREFFH D 8 0 Dt Ref Fim H R .F. N
NXA_DREFID D 8 0 Dt Ref Ini D R .F. N
NXA_DREFFD D 8 0 Dt Ref Fim D R .F. N
NXA_DREFIT D 8 0 Dt Ref Ini T R .F. S
NXA_DREFFT D 8 0 Dt Ref Fim T R .F. S
NXA_TS C 1 0 Tem TS Pertence("12") R 1=Sim;2=Nao .F. N
NXA_DES C 1 0 Tem DS Pertence("12") R 1=Sim;2=Nao .F. N
NXA_TAB C 1 0 Tem TAB Pertence("12") R 1=Sim;2=Nao .F. N
NXA_FIXO C 1 0 Tem Fixo Pertence("12") R 1=Sim;2=Nao .F. N
NXA_EXITO C 1 0 Tem Exito Pertence("12") R 1=Sim;2=Nao .F. N
NXA_FATADC C 1 0 Tem Fat Adic Pertence("12") R 1=Sim;2=Nao .F. N
NXA_SIGLA C 5 0 Sigla Resp V .F. S
NXA_CPART C 6 0 Resp Fatura R .F. N
NXA_DPART C 30 0 Nome Resp V .F. N
NXA_OBS C 254 0 Observacao @S50 R NXA->NXA_SITUAC=='2' N
NXA_RAZSOC C 40 0 Razao Social @! R JA204WRaSo() N
NXA_ENDENT C 254 0 End Internac @S50 R .F. N
NXA_TPPAG C 1 0 Tp Pagador Pertence("12") R 1=Juridica;2=Fisica .F. N
NXA_CGCCPF C 20 0 CNPJ/CPF R .F. N
NXA_PAIS C 60 0 Pais R .F. N
NXA_ESTADO C 2 0 Estado @! R .F. N
NXA_CIDADE C 60 0 Cidade R .F. N
NXA_BAIRRO C 60 0 Bairro R .F. N
NXA_CEP C 10 0 CEP @R 99999-999 R .F. N
NXA_LOGRAD C 100 0 Logradouro R .F. N
NXA_INSEST C 15 0 Ins Estadual R .F. N
NXA_INSMUN C 50 0 Inscr Munic R .F. N
NXA_VLFIXH C 1 0 Valor Fixo H R 1=Sim;2=Nao .F. N
NXA_VLORIH N 16 2 Vl Orig Hon @E 9,999,999,999,999.99 R .F. N
NXA_VLFIXO C 1 0 Valor Fixo D R 1=Sim;2=Nao .F. N
NXA_VLORID N 16 2 Vl Orig Desp @E 9,999,999,999,999.99 R .F. N
NXA_CMOTCA C 4 0 Mot Cancto JA204VLDCPO("NXA_CMOTCA") NSA R NXA->NXA_SITUAC=='2' N
NXA_DMOTCA C 50 0 Desc Mot Can V N
NXA_TXTFAT M 10 0 Texto Fatura R N
NXA_CALDIS C 1 0 Calc Vl Disp Pertence("12") R 1=Sim;2=Nao N
NXA_VUADIA N 16 2 Vl Uti Adian @E 9,999,999,999,999.99 R .F. N
NXA_VSADIA N 16 2 Vl Sol Adian @E 9,999,999,999,999.99 R .F. N
NXA_EMAIL C 50 0 E-Mail Envio R NXA->NXA_SITUAC=='1' N
NXA_CRTENV C 1 0 Carta Env Pertence("12") R 1=Sim;2=Nao .F. N
NXA_RELENV C 1 0 Relat Env Pertence("12") R 1=Sim;2=Nao .F. N
NXA_RECENV C 1 0 Recibo Env Pertence("12") R 1=Sim;2=Nao .F. N
NXA_MAILEN C 1 0 E-mail Env Pertence("12") R 1=Sim;2=Nao .F. N
NXA_SIGLA4 C 5 0 Sigla Cancel V .F. S
NXA_USRCAN C 6 0 Usuario Canc R N
NXA_DUSRCA C 30 0 Nome Cancela V S
NXA_CPREFT C 8 0 Cod Pre-fat R .F. N
NXA_FPAGTO C 1 0 Forma Pgto Pertence("12") R 1=Deposito;2=Boleto J204FPagto() N
NXA_CFTADC C 8 0 Cod Fat Adic R .F. N
NXA_CBANCO C 3 0 Banco @! J033ValCpo() SA6 R .F. N
NXA_CAGENC C 5 0 Agencia @! J033ValCpo() R .F. N
NXA_CCONTA C 10 0 Conta @! J033ValCpo() R .F. N
NXA_CESCSU C 5 0 Cod Esc Subs Vazio().OR.ExistCpo('NS7',M->NXA_CESCSU,1) NS7 R NXA->NXA_SITUAC=='2' N
NXA_CFTSUB C 9 0 Fatura Subst Vazio().OR.ExistCpo("NXA",M->NXA_CESCSU+M->NXA_CFTSUB,1) R NXA->NXA_SITUAC=='2' N
NXA_VLIQMN N 16 2 Liq Moe Nac @E 9,999,999,999,999.99 V N
NXA_FATHMN N 16 2 Hon Moe Nac @E 9,999,999,999,999.99 R N
NXA_FATDMN N 16 2 Desp Moe Nac @E 9,999,999,999,999.99 R N
NXA_DESCMN N 16 2 Desc Moe Nac @E 9,999,999,999,999.99 R N
NXA_ACREMN N 16 2 Acre Moe Nac @E 9,999,999,999,999.99 R N
NXA_TXADMN N 16 2 Tx Adm M Nac @E 9,999,999,999,999.99 R S
NXA_GROSMN N 16 2 Gross Up Nac @E 9,999,999,999,999.99 R S
NXA_REMBMN N 16 2 Vl Reemb Nac @E 9,999,999,999,999.99 R S
NXA_TRIBMN N 16 2 Vl Trib Nac @E 9,999,999,999,999.99 R S
NXA_OK C 4 0 Marca OK R N
NXA_CFILA C 6 0 Cod Fila R N
NXA_CLIPG C 6 0 Clie Pagador @! R N
NXA_LOJPG C 2 0 Loja Pagador @! R N
NXA_DCLIPG C 50 0 Nome pag V S
NXA_CCONT C 6 0 Cod Contato JURCONTOK('SA1',M->NXA_CCONT, xFilial("SA1")+M->NXA_CLIPG+M->NXA_LOJPG ,"SU5->U5_ATIVO=='1'" ).OR.VAZIO() SU5NXA R N
NXA_DCONT C 30 0 Nome Contato V .F. N
NXA_NFGER C 1 0 NF Gerada? Pertence("123") R 1=Sim;2=Nao;3=Nao Gerar N
NXA_CCDPGT C 3 0 Cond Pagto SE4 R .F. N
NXA_DCDPGT C 15 0 Des Cnd Pgto V N
NXA_DOC C 9 0 Doc Fiscal @! R N
NXA_SERIE C 3 0 Serie D.Fisc R N
NXA_TITGER C 1 0 Titulo Gerad R 1=Sim;2=Nao N
NXA_PERFAT N 16 8 Percentual @E 9,999,999.99999999 R N
NXA_FATATU C 9 0 Fatura Atual R N
NXA_CCARTA C 4 0 Cod carta ExistCpo("NRG", M->NXA_CCARTA,1) NRG R S
NXA_ESCATU C 5 0 Escr. Atual R N
NXA_CIDIO C 2 0 Cod Idi Rel ExistCpo("NR1", M->NXA_CIDIO,1) NR1 R N
NXA_CIDIO2 C 2 0 Cod Idi Cart ExistCpo("NR1", M->NXA_CIDIO2,1) NR1 R N
NXA_CTPFAT C 1 0 Tipo de Fatu R 1=Litisconsorcio;2=Multipayer N
NXA_TPREL C 4 0 Tipo Rel Fat Vazio() .or. (ExistCpo('NRJ',M->NXA_TPREL,1).and.J096VldRel("NXA")) NRJCTR R N
NXA_CTIPOF C 3 0 Tipo Fatura NR9 R JA204BxSe1() N
NXA_SIGLA2 C 5 0 Sigla Emi V S
NXA_USUEMI C 6 0 Usuario Emi R N
NXA_DUSUEM C 30 0 Nome Usu Emi V N
NXA_SIGLA3 C 5 0 Sigla Altera V S
NXA_USRALT C 6 0 Usr Alt Venc R N
NXA_DUSRAL C 30 0 Nome Alt Ven V N
NXA_DTALVE D 8 0 Dt Alt Venct R N
NXA_VLDSCL N 16 2 Des Linear @E 9,999,999,999,999.99 R S
NXA_VLDSCE N 16 2 Des Especial @E 9,999,999,999,999.99 R S
NXA_VLDSCP N 16 2 Des Pagador @E 9,999,999,999,999.99 R S
NXA_DIDIO C 50 0 Desc idioma V S
NXA_DIDIO2 C 50 0 Desc Idioma V S
NXA_DCARTA C 50 0 Desc carta V S
NXA_DTPREL C 50 0 Desc tip rel V S
NXA_DTIPOF C 50 0 Desc tp fatu V S
NXA_CFIXO C 8 0 Cod Fixo R .F. S
NXA_SISCOE D 8 0 Dt Emi SISCO R S
NXA_SISCOC D 8 0 Dt Can SISCO R S
NXA_SISLOG M 10 0 Log SISCO R S
NXA_SDOC C 3 0 Serie Doc. !!! R S
NXA_PONUMB C 100 0 PO Number R S
NXA_SERVIC M 10 0 Frase Servic R S
NXA_TPSERV C 2 0 Tipo Servico @! DZ R S
NXA_DTCEMI D 8 0 Dt Cont. Emi R S
NXA_DTCCAN D 8 0 Dt Cont. Can R S