Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| siid | int8 | 19 | √ | null |
|
|
|||||
| sireference | varchar | 30 | √ | null |
|
|
|||||
| mgid | int8 | 19 | √ | null |
|
|
|||||
| sitype | varchar | 10 | √ | null |
|
|
|||||
| sistatus | varchar | 10 | √ | null |
|
|
|||||
| sidocdate | date | 13 | √ | null |
|
|
|||||
| tprefsupplier | varchar | 30 | √ | null |
|
|
|||||
| suppliername | varchar | 100 | √ | null |
|
|
|||||
| tprefclient | varchar | 30 | √ | null |
|
|
|||||
| clientname | text | 2147483647 | √ | null |
|
|
|||||
| sidocreference | varchar | 30 | √ | null |
|
|
|||||
| ctreference | varchar | 2147483647 | √ | null |
|
|
|||||
| orderreference | varchar | 30 | √ | null |
|
|
|||||
| deliveryreference | varchar | 30 | √ | null |
|
|
|||||
| sinettotal | float8 | 17,17 | √ | null |
|
|
|||||
| sigrosstotal | float8 | 17,17 | √ | null |
|
|
|||||
| sidueamount | float8 | 17,17 | √ | null |
|
|
|||||
| siidcreditnote | int8 | 19 | √ | null |
|
|
|||||
| currcode | varchar | 10 | √ | null |
|
|