Detalhes da Tabela
formas_pagamento | Database: devprojetos_emissor | Conexão: Teste migração
Estrutura da Tabela
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| idForma | int(11) | NO | PRI | auto_increment | |
| idUsuario | int(11) | NO | MUL | ||
| nome | varchar(50) | NO | |||
| icone | varchar(10) | YES | |||
| tipo | varchar(20) | YES | ambos | ||
| prazo | int(11) | YES | 0 | ||
| taxa | decimal(5,2) | YES | 0.00 | ||
| ativo | tinyint(1) | YES | 1 | ||
| padrao | tinyint(1) | YES | 0 | ||
| ordem | int(11) | YES | 0 | ||
| lastUser | int(11) | YES | 0 |
Dados da Tabela (máx. 100 linhas)
| idForma | idUsuario | nome | icone | tipo | prazo | taxa | ativo | padrao | ordem | lastUser |
|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1 | Dinheiro | ? | ambos | 0 | 0.00 | 1 | 1 | 1 | 0 |
| 2 | 1 | PIX | ⚡ | ambos | 0 | 0.00 | 1 | 0 | 2 | 0 |
| 3 | 1 | Cartão de Crédito | ? | ambos | 30 | 3.99 | 1 | 0 | 3 | 0 |
| 4 | 1 | Cartão de Débito | ? | ambos | 1 | 1.99 | 1 | 0 | 4 | 0 |
| 5 | 1 | Boleto Bancário | ? | ambos | 3 | 0.00 | 1 | 0 | 5 | 0 |
| 6 | 1 | Transferência | ? | ambos | 1 | 0.00 | 1 | 0 | 6 | 0 |
| 7 | 1 | A Prazo | ? | saida | 30 | 0.00 | 1 | 0 | 7 | 0 |
| 8 | 1 | Teste | ambos | 0 | 0.00 | 1 | 0 | 99 | 1 | |
| 9 | 21 | Dinheiro | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 10 | 21 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 11 | 21 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 12 | 21 | Cheque | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 13 | 21 | Boleto | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 14 | 21 | Conv | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 15 | 21 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 16 | 21 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 17 | 21 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 18 | 21 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 19 | 21 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 20 | 21 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 21 | 21 | Credi | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 22 | 21 | Boleto Mercado Pago | 0 | 0.00 | 0 | 0 | 0 | 0 | ||
| 23 | 21 | Cart | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 24 | 21 | Cart | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 25 | 6 | Dinheiro | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 26 | 6 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 27 | 6 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 28 | 6 | Cheque | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 29 | 6 | Boleto | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 30 | 6 | Conv | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 31 | 6 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 32 | 6 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 33 | 6 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 34 | 6 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 35 | 6 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 36 | 6 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 37 | 6 | Credi | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 38 | 6 | Boleto Mercado Pago | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 39 | 6 | Cart | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 40 | 6 | Cart | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 41 | 7 | Dinheiro | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 42 | 7 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 43 | 7 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 44 | 7 | Cheque | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 45 | 7 | Boleto | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 46 | 7 | Conv | 0 | 0.00 | 0 | 0 | 0 | 0 | ||
| 47 | 7 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 48 | 7 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 49 | 7 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 50 | 7 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 51 | 7 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 52 | 7 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 53 | 7 | Credi | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 54 | 7 | Boleto Mercado Pago | 0 | 0.00 | 0 | 0 | 0 | 0 | ||
| 55 | 7 | Cart | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 56 | 7 | Cart | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 57 | 8 | Dinheiro | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 58 | 8 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 59 | 8 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 60 | 8 | Cheque | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 61 | 8 | Boleto | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 62 | 8 | Conv | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 63 | 8 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 64 | 8 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 65 | 8 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 66 | 8 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 67 | 8 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 68 | 8 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 69 | 8 | Credi | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 70 | 8 | Boleto Mercado Pago | 0 | 0.00 | 0 | 0 | 0 | 0 | ||
| 71 | 8 | Cart | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 72 | 8 | Cart | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 73 | 9 | Dinheiro | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 74 | 9 | C. Cr | credito | 0 | 0.00 | 0 | 0 | 0 | 0 | |
| 75 | 9 | C. D | debito | 0 | 0.00 | 0 | 0 | 0 | 0 | |
| 76 | 9 | Cheque | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 77 | 9 | Boleto | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 78 | 9 | Conv | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 79 | 9 | C. Cr | credito | 0 | 0.00 | 0 | 0 | 0 | 0 | |
| 80 | 9 | C. D | debito | 0 | 0.00 | 0 | 0 | 0 | 0 | |
| 81 | 9 | C. Cr | credito | 0 | 0.00 | 0 | 0 | 0 | 0 | |
| 82 | 9 | C. D | debito | 0 | 0.00 | 0 | 0 | 0 | 0 | |
| 83 | 9 | C. Cr | credito | 0 | 0.00 | 0 | 0 | 0 | 0 | |
| 84 | 9 | C. D | debito | 0 | 0.00 | 0 | 0 | 0 | 0 | |
| 85 | 9 | Boleto Mercado Pago | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 86 | 9 | Transfer | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 87 | 9 | Cart | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 88 | 9 | Cart | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 89 | 9 | Permuta | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 90 | 9 | A Faturar - Futura | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 91 | 9 | ASAAS Boleto | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 92 | 9 | ASAAS Pix | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 93 | 9 | PIX | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 94 | 10 | Dinheiro | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 95 | 10 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 96 | 10 | C. D | debito | 0 | 0.00 | 1 | 0 | 0 | 0 | |
| 97 | 10 | Cheque | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 98 | 10 | Boleto | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 99 | 10 | Conv | 0 | 0.00 | 1 | 0 | 0 | 0 | ||
| 100 | 10 | C. Cr | credito | 0 | 0.00 | 1 | 0 | 0 | 0 |