Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| paynetreference | varchar | 50 | √ | null |
|
|
||
| paynettype | varchar | 10 | √ | null |
|
|
||
| payreference | varchar | 30 | √ | null |
|
|
||
| cireference | varchar | 30 | √ | null |
|
|
||
| sireference | varchar | 30 | √ | null |
|
|
||
| paynetamount | float8 | 17,17 | √ | null |
|
|
||
| paynetdate | date | 13 | √ | null |
|
|
||
| paynetstatus | varchar | 10 | √ | null |
|
|
||
| tpidclient | int8 | 19 | √ | null |
|
|
||
| refclient | text | 2147483647 | √ | null |
|
|
||
| tpidsupplier | int8 | 19 | √ | null |
|
|
||
| refsupplier | text | 2147483647 | √ | null |
|
|
||
| tpid | int8 | 19 | √ | null |
|
|
||
| refpayer | text | 2147483647 | √ | null |
|
|