Columns
Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
---|---|---|---|---|---|---|---|---|
NUMBANCO | varchar | 3 | null |
|
|
|||
NUMAGENCIA | varchar | 6 | null |
|
|
|||
NROCONTA | varchar | 15 | null |
|
|
|||
TIPOCOB | smallint | 2 | null |
|
|
|||
POSININUMERO | smallint | 2 | √ | null |
|
|
||
POSFIMNUMERO | smallint | 2 | √ | null |
|
|
||
POSINIDTRECEB | smallint | 2 | √ | null |
|
|
||
POSFIMDTRECEB | smallint | 2 | √ | null |
|
|
||
POSINIVRRECEB | smallint | 2 | √ | null |
|
|
||
POSFIMVRRECEB | smallint | 2 | √ | null |
|
|
||
POSINIDESCONTO | smallint | 2 | √ | null |
|
|
||
POSFIMDESCONTO | smallint | 2 | √ | null |
|
|
||
POSINIJUROS | smallint | 2 | √ | null |
|
|
||
POSFIMJUROS | smallint | 2 | √ | null |
|
|
||
POSINIVRMULTA | smallint | 2 | √ | null |
|
|
||
POSFIMVRMULTA | smallint | 2 | √ | null |
|
|
||
POSINIVRDEPOS | smallint | 2 | √ | null |
|
|
||
POSFIMVRDEPOS | smallint | 2 | √ | null |
|
|
||
RECCREATEDBY | varchar | 50 | √ | null |
|
|
||
RECCREATEDON | datetime | 16,3 | √ | null |
|
|
||
RECMODIFIEDBY | varchar | 50 | √ | null |
|
|
||
RECMODIFIEDON | datetime | 16,3 | √ | null |
|
|
Indexes
Constraint Name | Type | Sort | Column(s) |
---|---|---|---|
PKFRETBANCO | Primary key | Asc/Asc/Asc/Asc | NUMBANCO + NUMAGENCIA + NROCONTA + TIPOCOB |
Diagram producer might be missing
No diagrams were produced please see application output for any errors