| Tabela | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| SDT | Itens importacao XML NF-e | ||||||||||
| Campo | Tipo | Tamanho | Decimal | Titulo | Formato | Validacao | F3 | Contexto | Lista | Condicao | PYME |
| DT_FILIAL | C | 2 | 0 | Filial | R | N | |||||
| DT_ITEM | C | 4 | 0 | Item | @! | R | N | ||||
| DT_COD | C | 15 | 0 | Produto | @! | SB1 | R | N | |||
| DT_DESC | C | 30 | 0 | Descricao | @! | V | .F. | N | |||
| DT_PRODFOR | C | 15 | 0 | Prd. For/Cli | @! | R | N | ||||
| DT_DESCFOR | C | 30 | 0 | Desc For/Cli | @! | R | N | ||||
| DT_FORNEC | C | 6 | 0 | Forn/Cliente | @! | R | N | ||||
| DT_LOJA | C | 2 | 0 | loja | @! | R | N | ||||
| DT_DOC | C | 9 | 0 | Documento | @! | N | |||||
| DT_SERIE | C | 3 | 0 | Serie | @! | R | N | ||||
| DT_CNPJ | C | 14 | 0 | CNPJ For/Cli | R | N | |||||
| DT_QUANT | N | 11 | 2 | Quantidade | @E 99999999.99 | R | N | ||||
| DT_VUNIT | N | 14 | 2 | Vlr.Unitario | @E 99,999,999,999.99 | R | N | ||||
| DT_TOTAL | N | 14 | 2 | Vlr.Total | @E 99,999,999,999.99 | Positivo() | R | N | |||
| DT_PEDIDO | C | 6 | 0 | Num. Pedido | @! | R | S | ||||
| DT_ITEMPC | C | 4 | 0 | Item PC | @! | R | S | ||||
| DT_NFORI | C | 9 | 0 | Docto. Orig | @! | NaoVazio().And. NFORIValid() | R | S | |||
| DT_SERIORI | C | 3 | 0 | Serie Orig. | !!! | IIF(FindFunction("NFORIValid"),NFORIValid(),A140IValNF()) | R | S | |||
| DT_ITEMORI | C | 4 | 0 | It.Doc Orig. | @! | NFORIValid() | R | S | |||
| DT_VALFRE | N | 14 | 2 | Vlr.Frete | @E 99,999,999,999.99 | R | S | ||||
| DT_SEGURO | N | 14 | 2 | Vlr.Seguro | @E 99,999,999,999.99 | R | S | ||||
| DT_DESPESA | N | 14 | 2 | Vlr.Despesas | @E 99,999,999,999.99 | R | S | ||||
| DT_VALDESC | N | 14 | 2 | Desconto | @E 99,999,999,999.99 | R | S | ||||
| DT_PICM | N | 5 | 2 | Aliq. ICMS | @E 99.99 | S | |||||
| DT_ORIGIN | C | 1 | 0 | Reg.Original | @! | S | |||||
| DT_LEGENDA | C | 13 | 0 | Legenda | @BMPS2 | V | S | ||||
| DT_XMLICST | N | 14 | 2 | ICMS ST XML | @E 99,999,999,999.99 | R | S | ||||
| DT_TESICST | N | 14 | 2 | ICMS ST TES | @E 99,999,999,999.99 | R | S | ||||
| DT_FCICOD | C | 36 | 0 | Cod. FCI | @! | S | |||||
| DT_TES | C | 3 | 0 | Tes | @! | Iif(!Empty(M->DT_TES),Existcpo("SF4").And.MaAvalTes("E",M->DT_TES).And.ColAtuImp(),.T.) | SF4 | R | S | ||
| DT_CODCFOP | C | 4 | 0 | Cod. CFOP | @! | R | S | ||||
| DT_TESIPI | N | 14 | 2 | Vlr. IPI TES | @E 99,999,999,999.99 | R | S | ||||
| DT_TESICM | N | 14 | 2 | Vlr. ICMS TE | @E 99,999,999,999.99 | R | S | ||||
| DT_TESISS | N | 14 | 2 | Vlr. ISS TES | @E 99,999,999,999.99 | R | S | ||||
| DT_TESPIS | N | 14 | 2 | Vlr. PIS TES | @E 99,999,999,999.99 | R | S | ||||
| DT_TESCOF | N | 14 | 2 | Vrl. COF TES | @E 99,999,999,999.99 | R | S | ||||
| DT_XMLIPI | N | 14 | 2 | Vlr. IPI XML | @E 99,999,999,999.99 | R | S | ||||
| DT_XMLICM | N | 14 | 2 | Vlr. ICMS XM | @E 99,999,999,999.99 | R | S | ||||
| DT_XMLISS | N | 14 | 2 | Vlr. ISS XML | @E 99,999,999,999.99 | S | |||||
| DT_XMLPIS | N | 14 | 2 | Vlr. PIS XML | @E 99,999,999,999.99 | R | S | ||||
| DT_XMLCOF | N | 14 | 2 | Vlr. COF XML | @E 99,999,999,999.99 | R | S | ||||
| DT_ALIQIPI | N | 6 | 2 | Aliq. IPI | @E 999.99 | R | S | ||||
| DT_ALIQICM | N | 6 | 2 | Aliq. ICMS | @E 999.99 | R | S | ||||
| DT_ALIQISS | N | 6 | 2 | Aliq. ISS | @E 999.99 | R | S | ||||
| DT_ALIQPIS | N | 6 | 2 | Aliq. PIS | @E 999.99 | R | S | ||||
| DT_ALIQCOF | N | 6 | 2 | Aliq. COF | @E 999.99 | R | S | ||||
| DT_XALQIPI | N | 6 | 2 | Alq. IPI XML | @E 999.99 | R | S | ||||
| DT_XALQICM | N | 6 | 2 | Alq. ICM XML | @E 999.99 | R | S | ||||
| DT_XALQISS | N | 6 | 2 | Alq. ISS XML | @E 999.99 | R | S | ||||
| DT_XALQPIS | N | 6 | 2 | Alq. PIS XML | @E 999.99 | R | S | ||||
| DT_XALQCOF | N | 6 | 2 | Alq. COF XML | @E 999.99 | R | S | ||||
| DT_DTVALID | D | 8 | 0 | Valid. Lote | R | S | |||||
| DT_CHVNFO | C | 44 | 0 | Chave Nf Ori | @! | S | |||||
| DT_LOCAL | C | 2 | 0 | Armazem | @! | S | |||||
| DT_LOTE | C | 10 | 0 | Lote | @! | R | S | ||||
| DT_CFOP | C | 1 | 0 | Valida CFOP | @! | S | |||||
| DT_SDOC | C | 3 | 0 | Serie Doc. | !!! | R | S | ||||
| DT_SDOCORI | C | 3 | 0 | Serie Orig. | !!! | R | S | ||||
| DT_ALIICST | N | 14 | 2 | Al. ICMS ST | @E 99,999,999,999.99 | R | S | ||||
| DT_XALICST | N | 14 | 2 | Al. IC ST XM | @E 99,999,999,999.99 | R | S | ||||
| DT_DFABRIC | D | 8 | 0 | Dt Fab Lote | R | S | |||||
| DT_XAFCPAN | N | 6 | 2 | Aliq FCP Ant | @E 999.99 | R | S | ||||
| DT_XBFCPAN | N | 14 | 2 | Base FCP Ant | @E 99,999,999,999.99 | R | S | ||||
| DT_XVFCPAN | N | 14 | 2 | Vlr. FCP Ant | @E 99,999,999,999.99 | R | S | ||||
| DT_XAFCPST | N | 6 | 2 | Aliq FCP ST | @E 999.99 | R | S | ||||
| DT_XBFCPST | N | 14 | 2 | Base FCP ST | @E 99,999,999,999.99 | R | S | ||||
| DT_XVFCPST | N | 14 | 2 | Valor FCP ST | @E 99,999,999,999.99 | R | S | ||||