Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| idfinanceirocheque | int8 | 19 | null |
|
|
||||||
| idparceiro | int8 | 19 | √ | null |
|
|
|||||
| idlocal | int8 | 19 | √ | null |
|
|
|||||
| idusuario | int8 | 19 | √ | null |
|
|
|||||
| nomebanco | varchar | 80 | √ | null |
|
|
|||||
| numerocheque | varchar | 20 | √ | null |
|
|
|||||
| numeroagencia | varchar | 20 | √ | null |
|
|
|||||
| numeroconta | varchar | 20 | √ | null |
|
|
|||||
| datavencimento | date | 13 | √ | null |
|
|
|||||
| valor | numeric | 18,6 | √ | null |
|
|
|||||
| varchar | 80 | √ | null |
|
|
||||||
| cpfcnpjcheque | varchar | 80 | √ | null |
|
|
|||||
| observacao | varchar | 4000 | √ | null |
|
|
|||||
| codigoerp | varchar | 80 | √ | null |
|
|
|||||
| wsversao | int8 | 19 | √ | null |
|
|
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| pkb3fc3bad | Primary key | Asc | idfinanceirocheque |
| idx114c7a63 | Performance | Asc | idparceiro |
| idxb1ae6118 | Performance | Asc | idlocal |
| idxdaf806bd | Performance | Asc | idusuario |
| idxwsversao_b3fc3bad | Performance | Desc | wsversao |
| uce3ef1f6d | Must be unique | Asc | codigoerp |



