Detalhes da Tabela
vendas_parcela | Database: devprojetos_emissor | Conexão: Teste migração
Estrutura da Tabela
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| idParcela | int(11) | NO | PRI | auto_increment | |
| idVenda | int(11) | NO | MUL | ||
| idUsuario | int(11) | NO | MUL | ||
| userIdMaster | int(11) | YES | |||
| parcelaNumero | varchar(5) | NO | |||
| idFormaPagamento | int(11) | YES | MUL | ||
| valor | decimal(10,2) | NO | |||
| vencimento | date | NO | |||
| pago | tinyint(1) | NO | 0 | ||
| dataPagamento | date | YES | |||
| valorPago | decimal(10,2) | YES | |||
| desconto | decimal(10,2) | YES | |||
| juros | decimal(10,2) | YES | |||
| observacao | varchar(255) | YES | |||
| lastUser | int(11) | YES | |||
| created_at | timestamp | NO | CURRENT_TIMESTAMP |
Dados da Tabela (máx. 100 linhas)
| idParcela | idVenda | idUsuario | userIdMaster | parcelaNumero | idFormaPagamento | valor | vencimento | pago | dataPagamento | valorPago | desconto | juros | observacao | lastUser | created_at |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3 | 17 | 20 | 20 | 1 | 20.00 | 2026-08-01 | 0 | 20 | 2026-08-01 03:00:48 | ||||||
| 4 | 17 | 20 | 20 | 2 | 20.00 | 2026-08-31 | 0 | 20 | 2026-08-01 03:00:48 | ||||||
| 5 | 24 | 20 | 20 | 1 | 253 | 20.00 | 2026-08-01 | 0 | 20 | 2026-08-01 03:04:32 | |||||
| 6 | 25 | 20 | 20 | 1 | 253 | 15.00 | 2026-08-01 | 0 | 20 | 2026-08-01 03:04:36 | |||||
| 7 | 25 | 20 | 20 | 2 | 253 | 15.00 | 2026-08-31 | 0 | 20 | 2026-08-01 03:04:36 | |||||
| 8 | 26 | 20 | 20 | 1 | 253 | 30.00 | 2026-08-01 | 0 | 20 | 2026-08-01 03:04:39 | |||||
| 9 | 26 | 20 | 20 | 2 | 253 | 30.00 | 2026-08-31 | 0 | 20 | 2026-08-01 03:04:39 | |||||
| 10 | 26 | 20 | 20 | 3 | 253 | 30.00 | 2026-09-30 | 0 | 20 | 2026-08-01 03:04:39 | |||||
| 11 | 27 | 20 | 20 | 1 | 253 | 60.00 | 2026-08-01 | 0 | 20 | 2026-08-01 03:04:43 | |||||
| 12 | 28 | 20 | 20 | 1 | 253 | 75.00 | 2026-08-01 | 0 | 20 | 2026-08-01 03:04:48 | |||||
| 13 | 28 | 20 | 20 | 2 | 253 | 75.00 | 2026-08-31 | 0 | 20 | 2026-08-01 03:04:48 | |||||
| 14 | 30 | 20 | 20 | 1 | 253 | 120.00 | 2026-08-01 | 0 | 20 | 2026-08-01 03:04:58 | |||||
| 15 | 31 | 20 | 20 | 1 | 253 | 45.00 | 2026-08-01 | 0 | 20 | 2026-08-01 03:05:02 | |||||
| 16 | 31 | 20 | 20 | 2 | 253 | 45.00 | 2026-08-31 | 0 | 20 | 2026-08-01 03:05:02 | |||||
| 17 | 32 | 20 | 20 | 1 | 253 | 33.33 | 2026-08-01 | 0 | 20 | 2026-08-01 03:05:06 | |||||
| 18 | 32 | 20 | 20 | 2 | 253 | 33.33 | 2026-08-31 | 0 | 20 | 2026-08-01 03:05:06 | |||||
| 19 | 32 | 20 | 20 | 3 | 253 | 33.34 | 2026-09-30 | 0 | 20 | 2026-08-01 03:05:06 | |||||
| 20 | 33 | 20 | 20 | 1 | 253 | 130.00 | 2026-08-01 | 0 | 20 | 2026-08-01 03:05:11 | |||||
| 21 | 29 | 20 | 20 | 1 | 253 | 90.00 | 2026-08-31 | 0 | 20 | 2026-08-01 03:05:23 | |||||
| 22 | 29 | 20 | 20 | 2 | 253 | 90.00 | 2026-09-30 | 0 | 20 | 2026-08-01 03:05:23 | |||||
| 23 | 29 | 20 | 20 | 3 | 253 | 90.00 | 2026-10-30 | 0 | 20 | 2026-08-01 03:05:23 | |||||
| 26 | 34 | 20 | 20 | 1 | 253 | 80.00 | 2026-08-31 | 0 | 20 | 2026-08-01 03:08:25 | |||||
| 27 | 35 | 3 | 3 | 1 | 25.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:45 | ||||||
| 28 | 36 | 3 | 3 | 1 | 50.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:45 | ||||||
| 29 | 37 | 3 | 3 | 1 | 75.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:45 | ||||||
| 30 | 38 | 3 | 3 | 1 | 100.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:45 | ||||||
| 31 | 39 | 3 | 3 | 1 | 125.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:46 | ||||||
| 32 | 40 | 3 | 3 | 1 | 150.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:46 | ||||||
| 33 | 41 | 3 | 3 | 1 | 175.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:46 | ||||||
| 34 | 42 | 3 | 3 | 1 | 200.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:47 | ||||||
| 35 | 43 | 3 | 3 | 1 | 225.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:47 | ||||||
| 36 | 44 | 3 | 3 | 1 | 250.00 | 2026-08-31 | 0 | 3 | 2026-08-01 16:33:47 | ||||||
| 37 | 57 | 3 | 3 | 1 | 110.00 | 2026-08-02 | 0 | 3 | 2026-08-01 23:06:12 |