Detalhes da Tabela
nfe | Database: devprojetos_emissor | Conexão: Teste migração
Estrutura da Tabela
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| idNFe | int(9) | NO | |||
| numero | int(9) | NO | 0 | ||
| cUf | varchar(2) | NO | |||
| natOp | varchar(60) | NO | |||
| naturezaId | smallint(6) | YES | |||
| indPag | varchar(1) | NO | |||
| modelo | varchar(2) | NO | 55 | ||
| serie | varchar(3) | NO | |||
| dEmi | date | NO | |||
| hEmi | time | YES | |||
| dSaiEnt | date | NO | |||
| hSaiEnt | varchar(10) | NO | 00:00:00 | ||
| tpNF | int(1) | NO | 0 | ||
| idDest | varchar(1) | NO | 1 | ||
| indIEDest | varchar(2) | NO | 1 | ||
| indFinal | varchar(1) | NO | 0 | ||
| indPres | varchar(1) | NO | 0 | ||
| indIntermed | tinyint(1) | YES | |||
| refNFe | varchar(44) | YES | |||
| modFrete | varchar(1) | YES | |||
| transportador | varchar(1) | NO | 1 | ||
| tpImp | int(1) | NO | 1 | ||
| tpEmis | int(1) | NO | 1 | ||
| chave | varchar(50) | NO | |||
| nRec | varchar(20) | YES | |||
| nProt | varchar(20) | YES | |||
| cDV | varchar(1) | NO | |||
| cNF | varchar(8) | YES | |||
| tpAmb | int(1) | NO | 2 | ||
| finNFe | int(1) | NO | 1 | ||
| procEmi | int(1) | NO | 0 | ||
| clienteId | int(11) | NO | |||
| contribuinteComplementar | longtext | NO | |||
| contribuinteComplementarObrig | text | YES | |||
| contribuinteComplementarObrigChk | enum('0','1') | NO | 0 | ||
| fiscoComplementar | longtext | NO | |||
| veiculo | int(11) | NO | 0 | ||
| vFrete | decimal(13,2) | NO | 0.00 | ||
| vSeg | decimal(13,2) | NO | 0.00 | ||
| vDesc | decimal(13,2) | NO | 0.00 | ||
| vProd | decimal(13,2) | NO | 0.00 | ||
| vOutro | decimal(13,2) | NO | 0.00 | ||
| vNF | decimal(13,2) | NO | 0.00 | ||
| vFCP | decimal(13,2) | NO | 0.00 | ||
| vFCPST | decimal(13,2) | NO | 0.00 | ||
| vFCPSTRet | decimal(13,2) | NO | 0.00 | ||
| vTotTrib | decimal(13,2) | NO | 0.00 | ||
| vBC | decimal(13,2) | NO | 0.00 | ||
| vICMS | decimal(13,2) | NO | 0.00 | ||
| vBCST | decimal(13,2) | NO | 0.00 | ||
| vST | decimal(13,2) | NO | 0.00 | ||
| vII | decimal(13,2) | NO | 0.00 | ||
| vIPI | decimal(13,2) | NO | 0.00 | ||
| vIPIDevol | decimal(13,2) | YES | |||
| vPIS | decimal(13,2) | YES | 0.00 | ||
| vCOFINS | decimal(13,2) | NO | 0.00 | ||
| transNome | varchar(222) | NO | |||
| transAntt | varchar(222) | NO | |||
| transPlaca | varchar(8) | NO | |||
| transPlacaUf | varchar(4) | NO | |||
| transCnpj | varchar(22) | NO | |||
| transEndereco | varchar(300) | NO | |||
| transMun | varchar(222) | NO | |||
| transUf | varchar(4) | NO | |||
| transIE | varchar(15) | NO | |||
| UFSaidaPais | varchar(2) | YES | |||
| xLocExporta | varchar(60) | YES | |||
| xLocDespacho | varchar(60) | YES | |||
| vendaId | varchar(200) | YES | |||
| validada | tinyint(1) | NO | 0 | ||
| assinada | tinyint(1) | NO | 0 | ||
| transmitida | tinyint(1) | NO | 0 | ||
| statusId | tinyint(4) | NO | 1 | ||
| vFCPUFDest | decimal(13,2) | NO | 0.00 | ||
| vICMSUFDest | decimal(13,2) | NO | 0.00 | ||
| vICMSUFRemet | decimal(13,2) | NO | 0.00 | ||
| tPag | varchar(2) | YES | |||
| xPag | varchar(60) | YES | |||
| pgObservacao | text | YES | |||
| vPag | decimal(13,2) | YES | |||
| tpIntegra | int(1) | YES | |||
| pagCNPJ | varchar(20) | YES | |||
| idCadIntTran | varchar(60) | YES | |||
| intermedCNPJ | varchar(14) | YES | |||
| tBand | varchar(2) | YES | |||
| cAut | varchar(20) | YES | |||
| vTroco | decimal(13,2) | YES | |||
| dupnDup | varchar(60) | YES | |||
| dupdVenc | date | YES | |||
| dupvDup | decimal(13,2) | YES | |||
| lastUser | int(11) | NO | |||
| xPed | varchar(15) | YES | |||
| vCBS | decimal(15,2) | YES | |||
| vIBS | decimal(15,2) | YES | |||
| vIS | decimal(15,2) | YES |
Dados da Tabela (máx. 100 linhas)
| idNFe | numero | cUf | natOp | naturezaId | indPag | modelo | serie | dEmi | hEmi | dSaiEnt | hSaiEnt | tpNF | idDest | indIEDest | indFinal | indPres | indIntermed | refNFe | modFrete | transportador | tpImp | tpEmis | chave | nRec | nProt | cDV | cNF | tpAmb | finNFe | procEmi | clienteId | contribuinteComplementar | contribuinteComplementarObrig | contribuinteComplementarObrigChk | fiscoComplementar | veiculo | vFrete | vSeg | vDesc | vProd | vOutro | vNF | vFCP | vFCPST | vFCPSTRet | vTotTrib | vBC | vICMS | vBCST | vST | vII | vIPI | vIPIDevol | vPIS | vCOFINS | transNome | transAntt | transPlaca | transPlacaUf | transCnpj | transEndereco | transMun | transUf | transIE | UFSaidaPais | xLocExporta | xLocDespacho | vendaId | validada | assinada | transmitida | statusId | vFCPUFDest | vICMSUFDest | vICMSUFRemet | tPag | xPag | pgObservacao | vPag | tpIntegra | pagCNPJ | idCadIntTran | intermedCNPJ | tBand | cAut | vTroco | dupnDup | dupdVenc | dupvDup | lastUser | xPed | vCBS | vIBS | vIS |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2 | 2 | 0 | 1 | 0 | 55 | 1 | 2025-06-30 | 15:03:30 | 2025-06-30 | 15:03:30 | 1 | 1 | 9 | 0 | 1 | 0 | 4 | 1 | 1 | 1 | 31250636371817000113550010000000021043536371 | 1 | 04353637 | 2 | 1 | 0 | 1 | 1 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0.00 | 0.00 | 0.00 | 01 | 1000.00 | 2 | 01 | 0.00 | 120 | ||||||||||||||||||||||
| 3 | 3 | 8 | 8 | 55 | 1 | 2025-10-21 | 11:42:53 | 2025-10-21 | 11:42:53 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 3125103637181700011355001000000003136376 | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 1 | 0.00 | 0.00 | 0.00 | 120 | |||||||||||||||||||||||||||||||||||||||||||
| 5 | 5 | 0 | 4 | 0 | 55 | 1 | 2026-05-19 | 18:40:54 | 2026-05-19 | 18:40:54 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 31260536371817000113550010000000051123136370 | 0 | 12313637 | 1 | 1 | 0 | 5 | a | 0 | a | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0.00 | 0.00 | 17 | asdad | 2000.00 | 1 | 1313 | 313 | 01 | 0.00 | 120 | adad | ||||||||||||||||
| 6 | 6 | 0 | 7 | 0 | 55 | 1 | 2026-05-19 | 20:33:43 | 2026-05-19 | 20:33:43 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 31260536371817000113550010000000062123136375 | 5 | 12313637 | 1 | 1 | 0 | 5 | 0 | 0 | 0.00 | 0.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0.00 | 0.00 | 17 | 250.00 | 1 | 01 | 0.00 | 120 | ||||||||||||||||||||||
| 2 | 2 | 0 | 1 | 0 | 55 | 1 | 2025-06-30 | 15:03:30 | 2025-06-30 | 15:03:30 | 1 | 1 | 9 | 0 | 1 | 0 | 4 | 1 | 1 | 1 | 31250636371817000113550010000000021043536371 | 1 | 04353637 | 2 | 1 | 0 | 1 | 1 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0.00 | 0.00 | 0.00 | 01 | 1000.00 | 2 | 01 | 0.00 | 120 | ||||||||||||||||||||||
| 3 | 3 | 8 | 8 | 55 | 1 | 2025-10-21 | 11:42:53 | 2025-10-21 | 11:42:53 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 3125103637181700011355001000000003136376 | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 1 | 0.00 | 0.00 | 0.00 | 120 | |||||||||||||||||||||||||||||||||||||||||||
| 5 | 5 | 0 | 4 | 0 | 55 | 1 | 2026-05-19 | 18:40:54 | 2026-05-19 | 18:40:54 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 31260536371817000113550010000000051123136370 | 0 | 12313637 | 1 | 1 | 0 | 5 | a | 0 | a | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0.00 | 0.00 | 17 | asdad | 2000.00 | 1 | 1313 | 313 | 01 | 0.00 | 120 | adad | ||||||||||||||||
| 6 | 6 | 0 | 7 | 0 | 55 | 1 | 2026-05-19 | 20:33:43 | 2026-05-19 | 20:33:43 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 31260536371817000113550010000000062123136375 | 5 | 12313637 | 1 | 1 | 0 | 5 | 0 | 0 | 0.00 | 0.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0.00 | 0.00 | 17 | 250.00 | 1 | 01 | 0.00 | 120 | ||||||||||||||||||||||
| 2 | 2 | 0 | 1 | 0 | 55 | 1 | 2025-06-30 | 15:03:30 | 2025-06-30 | 15:03:30 | 1 | 1 | 9 | 0 | 1 | 0 | 4 | 1 | 1 | 1 | 31250636371817000113550010000000021043536371 | 1 | 04353637 | 2 | 1 | 0 | 1 | 1 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 2 | 0.00 | 0.00 | 0.00 | 01 | 1000.00 | 2 | 01 | 0.00 | 120 | ||||||||||||||||||||||
| 3 | 3 | 8 | 8 | 55 | 1 | 2025-10-21 | 11:42:53 | 2025-10-21 | 11:42:53 | 1 | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 3125103637181700011355001000000003136376 | 6 | 1 | 1 | 0 | 0 | 0 | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 1 | 0.00 | 0.00 | 0.00 | 120 | |||||||||||||||||||||||||||||||||||||||||||
| 5 | 5 | 0 | 4 | 0 | 55 | 1 | 2026-05-19 | 18:40:54 | 2026-05-19 | 18:40:54 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 1 | 1 | 1 | 31260536371817000113550010000000051123136370 | 0 | 12313637 | 1 | 1 | 0 | 5 | a | 0 | a | 0 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0.00 | 0.00 | 17 | asdad | 2000.00 | 1 | 1313 | 313 | 01 | 0.00 | 120 | adad | ||||||||||||||||
| 6 | 6 | 0 | 7 | 0 | 55 | 1 | 2026-05-19 | 20:33:43 | 2026-05-19 | 20:33:43 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 31260536371817000113550010000000062123136375 | 5 | 12313637 | 1 | 1 | 0 | 5 | 0 | 0 | 0.00 | 0.00 | 0.00 | 14.00 | 0.00 | 14.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0.00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.00 | 0.00 | 0.00 | 17 | 250.00 | 1 | 01 | 0.00 | 120 |