Detalhes da Tabela
recibos | Database: devprojetos_emissor | Conexão: Teste migração
Estrutura da Tabela
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| idRecibo | int(11) | NO | PRI | auto_increment | |
| idUsuario | int(11) | NO | MUL | ||
| userIdMaster | int(11) | YES | |||
| numero | varchar(20) | YES | |||
| idCliente | int(11) | YES | MUL | ||
| idVenda | int(11) | YES | |||
| dataEmissao | datetime | YES | CURRENT_TIMESTAMP | ||
| valor | decimal(10,2) | NO | 0.00 | ||
| valorExtenso | varchar(500) | YES | |||
| referente | text | YES | |||
| formaPagamento | varchar(50) | YES | |||
| observacao | text | YES | |||
| emitente_nome | varchar(150) | YES | |||
| emitente_documento | varchar(20) | YES | |||
| cliente_nome | varchar(255) | YES | |||
| cliente_documento | varchar(20) | YES | |||
| lastUser | int(11) | YES | 0 |
Dados da Tabela (máx. 100 linhas)
| idRecibo | idUsuario | userIdMaster | numero | idCliente | idVenda | dataEmissao | valor | valorExtenso | referente | formaPagamento | observacao | emitente_nome | emitente_documento | cliente_nome | cliente_documento | lastUser |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 6 | 1 | 4 | 2 | 2026-05-31 10:36:54 | 1687.37 | 0 | |||||||||
| 2 | 6 | 1 | 2 | 4 | 2 | 2026-05-31 10:36:54 | 1187.36 | 0 | ||||||||
| 3 | 6 | 1 | 4 | 2 | 2026-05-31 10:36:54 | 1687.37 | 0 | |||||||||
| 4 | 6 | 1 | 1 | 6 | 3 | 2026-05-31 10:36:54 | 34.00 | 0 | ||||||||
| 5 | 6 | 1 | 4 | 2 | 2026-05-31 10:36:54 | 1687.37 | 0 | |||||||||
| 6 | 6 | 1 | 4 | 18 | 2026-05-31 10:36:54 | 325.01 | 0 | |||||||||
| 7 | 6 | 1 | 33 | 0 | 2026-05-31 10:36:54 | 840.00 | 0 | |||||||||
| 8 | 6 | 1 | 33 | 0 | 2026-05-31 10:36:54 | 840.00 | 0 | |||||||||
| 9 | 6 | 1 | 33 | 0 | 2026-05-31 10:36:54 | 840.00 | 0 | |||||||||
| 10 | 6 | 1 | 33 | 0 | 2026-05-31 10:36:54 | 840.00 | 0 | |||||||||
| 11 | 6 | 1 | 33 | 0 | 2026-05-31 10:36:54 | 485.00 | 0 | |||||||||
| 12 | 13 | 1 | 1134 | 0 | 2026-05-31 10:36:55 | 215.00 | 0 | |||||||||
| 13 | 6 | 1 | 1 | 60 | 155 | 2026-05-31 10:36:54 | 1700.00 | 0 | ||||||||
| 14 | 13 | 1 | 752 | 0 | 2026-05-31 10:36:55 | 320.00 | 0 | |||||||||
| 15 | 6 | 1 | 1 | 60 | 159 | 2026-05-31 10:36:54 | 3940.00 | 0 | ||||||||
| 16 | 13 | 1 | 126 | 0 | 2026-05-31 10:36:55 | 130.00 | 0 | |||||||||
| 17 | 6 | 1 | 1 | 11 | 185 | 2026-05-31 10:36:54 | 1260.00 | 0 | ||||||||
| 18 | 30 | 1 | 1 | 71 | 81 | 2026-05-31 10:36:58 | 1400.00 | 0 | ||||||||
| 19 | 6 | 1 | 1 | 11 | 189 | 2026-05-31 10:36:54 | 400.00 | 0 | ||||||||
| 20 | 13 | 1 | 683 | 0 | 2026-05-31 10:36:55 | 31.00 | 0 | |||||||||
| 21 | 13 | 1 | 683 | 0 | 2026-05-31 10:36:55 | 310.00 | 0 | |||||||||
| 22 | 13 | 1 | 909 | 0 | 2026-05-31 10:36:55 | 350.00 | 0 | |||||||||
| 23 | 13 | 1 | 1623 | 0 | 2026-05-31 10:36:55 | 790.00 | 0 | |||||||||
| 24 | 30 | 1 | 1 | 93 | 84 | 2026-05-31 10:36:58 | 1700.00 | 0 | ||||||||
| 25 | 13 | 1 | 1287 | 0 | 2026-05-31 10:36:55 | 80.00 | 0 | |||||||||
| 26 | 13 | 1 | 683 | 0 | 2026-05-31 10:36:55 | 90.00 | 0 | |||||||||
| 27 | 6 | 1 | 1 | 163 | 516 | 2026-05-31 10:36:54 | 31000.00 | 0 | ||||||||
| 28 | 13 | 1 | 62 | 0 | 2026-05-31 10:36:55 | 100.00 | 0 | |||||||||
| 29 | 13 | 1 | 1727 | 0 | 2026-05-31 10:36:55 | 110.00 | 0 | |||||||||
| 30 | 6 | 1 | 1 | 163 | 573 | 2026-05-31 10:36:54 | 33500.00 | 0 | ||||||||
| 31 | 6 | 1 | 1 | 197 | 659 | 2026-05-31 10:36:54 | 1560.00 | 0 | ||||||||
| 32 | 13 | 1 | 1586 | 0 | 2026-05-31 10:36:55 | 90.00 | 0 | |||||||||
| 33 | 6 | 1 | 1 | 227 | 784 | 2026-05-31 10:36:54 | 4200.00 | 0 | ||||||||
| 34 | 13 | 1 | 667 | 0 | 2026-05-31 10:36:55 | 220.00 | 0 | |||||||||
| 35 | 13 | 1 | 379 | 0 | 2026-05-31 10:36:55 | 60.00 | 0 | |||||||||
| 36 | 6 | 1 | 1 | 248 | 881 | 2026-05-31 10:36:54 | 810.00 | 0 | ||||||||
| 37 | 6 | 1 | 1 | 246 | 1088 | 2026-05-31 10:36:54 | 2047.00 | 0 | ||||||||
| 38 | 6 | 1 | 1 | 246 | 1090 | 2026-05-31 10:36:54 | 1330.00 | 0 | ||||||||
| 39 | 6 | 1 | 1 | 283 | 1091 | 2026-05-31 10:36:54 | 2105.00 | 0 | ||||||||
| 40 | 13 | 1 | 0 | 0 | 2026-05-31 10:36:55 | 130.00 | 0 | |||||||||
| 41 | 6 | 1 | 1 | 246 | 1106 | 2026-05-31 10:36:54 | 1108.00 | 0 | ||||||||
| 42 | 6 | 1 | 1 | 246 | 1107 | 2026-05-31 10:36:54 | 1330.00 | 0 | ||||||||
| 43 | 6 | 1 | 1 | 246 | 1130 | 2026-05-31 10:36:54 | 1249.00 | 0 | ||||||||
| 45 | 6 | 1 | 1 | 99 | 1152 | 2026-05-31 10:36:54 | 47652.00 | 0 | ||||||||
| 47 | 6 | 1 | 1 | 246 | 1155 | 2026-05-31 10:36:54 | 562.00 | 0 | ||||||||
| 48 | 13 | 1 | 0 | 2026-05-31 10:36:55 | 80.00 | 0 | ||||||||||
| 49 | 6 | 1 | 1 | 283 | 1178 | 2026-05-31 10:36:54 | 480.00 | 0 | ||||||||
| 50 | 13 | 1 | 788 | 0 | 2026-05-31 10:36:55 | 50.00 | 0 | |||||||||
| 51 | 6 | 1 | 1 | 283 | 1203 | 2026-05-31 10:36:54 | 378.00 | 0 | ||||||||
| 52 | 13 | 1 | 683 | 0 | 2026-05-31 10:36:55 | 290.00 | 0 | |||||||||
| 53 | 6 | 1 | 1 | 311 | 1228 | 2026-05-31 10:36:54 | 8000.00 | 0 | ||||||||
| 54 | 6 | 1 | 1 | 314 | 1240 | 2026-05-31 10:36:54 | 3960.00 | 0 | ||||||||
| 55 | 6 | 1 | 1 | 413 | 1599 | 2026-05-31 10:36:54 | 1640.00 | 0 | ||||||||
| 56 | 6 | 1 | 1 | 413 | 1602 | 2026-05-31 10:36:54 | 900.00 | 0 | ||||||||
| 57 | 13 | 1 | 1177 | 0 | 2026-05-31 10:36:55 | 650.00 | 0 | |||||||||
| 60 | 13 | 1 | 1854 | 0 | 2026-05-31 10:36:55 | 487.32 | 0 | |||||||||
| 61 | 13 | 1 | 550 | 0 | 2026-05-31 10:36:55 | 520.00 | 0 | |||||||||
| 62 | 13 | 1 | 0 | 0 | 2026-05-31 10:36:55 | 50.00 | 0 | |||||||||
| 63 | 13 | 1 | 1869 | 0 | 2026-05-31 10:36:55 | 5000.00 | 0 | |||||||||
| 64 | 13 | 1 | 1869 | 0 | 2026-05-31 10:36:55 | 50.00 | 0 | |||||||||
| 65 | 13 | 1 | 550 | 0 | 2026-05-31 10:36:55 | 350.00 | 0 | |||||||||
| 66 | 13 | 1 | 1870 | 0 | 2026-05-31 10:36:55 | 200.00 | 0 | |||||||||
| 68 | 13 | 1 | 667 | 2026-05-31 10:36:55 | 1800.00 | 0 | ||||||||||
| 69 | 13 | 1 | 2026-05-31 10:36:55 | 0.00 | 0 | |||||||||||
| 70 | 13 | 1 | 2026-05-31 10:36:55 | 0.00 | 0 | |||||||||||
| 71 | 13 | 1 | 1576 | 0 | 2026-05-31 10:36:55 | 310.00 | 0 | |||||||||
| 74 | 13 | 1 | 1888 | 0 | 2026-05-31 10:36:55 | 150.00 | 0 | |||||||||
| 75 | 13 | 1 | 1888 | 0 | 2026-05-31 10:36:55 | 80.00 | 0 | |||||||||
| 77 | 13 | 1 | 1905 | 0 | 2026-05-31 10:36:55 | 40.00 | 0 | |||||||||
| 78 | 13 | 1 | 531 | 0 | 2026-05-31 10:36:55 | 402.00 | 0 | |||||||||
| 80 | 13 | 1 | 1906 | 0 | 2026-05-31 10:36:55 | 80.00 | 0 | |||||||||
| 81 | 13 | 1 | 0 | 0 | 2026-05-31 10:36:55 | 60.00 | 0 | |||||||||
| 82 | 13 | 1 | 1799 | 0 | 2026-05-31 10:36:55 | 60.00 | 0 | |||||||||
| 83 | 13 | 1 | 143 | 0 | 2026-05-31 10:36:55 | 488.00 | 0 | |||||||||
| 84 | 13 | 1 | 1215 | 0 | 2026-05-31 10:36:55 | 610.00 | 0 | |||||||||
| 85 | 13 | 1 | 183 | 0 | 2026-05-31 10:36:55 | 500.00 | 0 | |||||||||
| 86 | 13 | 1 | 1380 | 0 | 2026-05-31 10:36:55 | 50.00 | 0 | |||||||||
| 87 | 13 | 1 | 143 | 0 | 2026-05-31 10:36:55 | 540.00 | 0 | |||||||||
| 88 | 13 | 1 | 531 | 0 | 2026-05-31 10:36:55 | 90.00 | 0 | |||||||||
| 89 | 13 | 1 | 1778 | 0 | 2026-05-31 10:36:55 | 330.00 | 0 | |||||||||
| 91 | 13 | 1 | 1682 | 0 | 2026-05-31 10:36:55 | 80.00 | 0 | |||||||||
| 92 | 13 | 1 | 1778 | 0 | 2026-05-31 10:36:55 | 290.00 | 0 | |||||||||
| 93 | 13 | 1 | 1682 | 0 | 2026-05-31 10:36:55 | 80.00 | 0 | |||||||||
| 94 | 13 | 1 | 2092 | 2026-05-31 10:36:55 | 1620.00 | 0 | ||||||||||
| 95 | 13 | 1 | 683 | 0 | 2026-05-31 10:36:55 | 430.00 | 0 | |||||||||
| 96 | 13 | 1 | 2026-05-31 10:36:55 | 0.00 | 0 | |||||||||||
| 97 | 13 | 1 | 2026-05-31 10:36:55 | 0.00 | 0 | |||||||||||
| 99 | 13 | 1 | 550 | 0 | 2026-05-31 10:36:55 | 140.00 | 0 | |||||||||
| 102 | 13 | 1 | 2172 | 0 | 2026-05-31 10:36:55 | 320.00 | 0 | |||||||||
| 103 | 13 | 1 | 2155 | 0 | 2026-05-31 10:36:55 | 200.00 | 0 | |||||||||
| 104 | 13 | 1 | 2155 | 0 | 2026-05-31 10:36:55 | 200.00 | 0 | |||||||||
| 105 | 13 | 1 | 1739 | 0 | 2026-05-31 10:36:55 | 200.00 | 0 | |||||||||
| 106 | 13 | 1 | 1417 | 0 | 2026-05-31 10:36:55 | 50.00 | 0 | |||||||||
| 107 | 13 | 1 | 2191 | 0 | 2026-05-31 10:36:55 | 120.00 | 0 | |||||||||
| 108 | 13 | 1 | 683 | 0 | 2026-05-31 10:36:55 | 260.00 | 0 | |||||||||
| 109 | 13 | 1 | 1907 | 0 | 2026-05-31 10:36:55 | 320.00 | 0 | |||||||||
| 110 | 13 | 1 | 160 | 0 | 2026-05-31 10:36:55 | 90.00 | 0 | |||||||||
| 111 | 13 | 1 | 683 | 0 | 2026-05-31 10:36:55 | 200.00 | 0 | |||||||||
| 112 | 13 | 1 | 1682 | 0 | 2026-05-31 10:36:55 | 80.00 | 0 | |||||||||
| 114 | 13 | 1 | 1487 | 0 | 2026-05-31 10:36:55 | 100.00 | 0 |