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 |