Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| compid | text | 2147483647 | √ | null |
|
|
|||||
| assetid | int8 | 19 | √ | null |
|
|
|||||
| assetreference | varchar | 30 | √ | null |
|
|
|||||
| assettype | varchar | 10 | √ | null |
|
|
|||||
| assetcategory | varchar | 10 | √ | null |
|
|
|||||
| assetstatus | varchar | 10 | √ | null |
|
|
|||||
| assetnetamount | float8 | 17,17 | √ | null |
|
|
|||||
| assettaxamount | float8 | 17,17 | √ | null |
|
|
|||||
| assetgrossamount | float8 | 17,17 | √ | null |
|
|
|||||
| assetorderreference | varchar | 30 | √ | null |
|
|
|||||
| assetorderdate | date | 13 | √ | null |
|
|
|||||
| assetdeliveryreference | varchar | 30 | √ | null |
|
|
|||||
| assetdeliverydate | date | 13 | √ | null |
|
|
|||||
| assetmulticomponents | bool | 1 | √ | null |
|
|
|||||
| assetdescription | varchar | 500 | √ | null |
|
|
|||||
| assetlabel | varchar | 250 | √ | null |
|
|
|||||
| ctreference | varchar | 30 | √ | null |
|
|
|||||
| ctrid | int8 | 19 | √ | null |
|
|
|||||
| tpidsupplier | int8 | 19 | √ | null |
|
|
|||||
| clientname | text | 2147483647 | √ | null |
|
|
|||||
| clientreference | varchar | 30 | √ | null |
|
|
|||||
| tpidclient | int8 | 19 | √ | null |
|
|
|||||
| suppliername | varchar | 100 | √ | null |
|
|
|||||
| refsupplier | varchar | 30 | √ | null |
|
|
|||||
| taxcode | varchar | 10 | √ | null |
|
|
|||||
| flagholdback | bool | 1 | √ | null |
|
|
|||||
| holdbackpercentage | float8 | 17,17 | √ | null |
|
|
|||||
| holdbackamount | float8 | 17,17 | √ | null |
|
|
|||||
| holdbackbeleasenbdays | int4 | 10 | √ | null |
|
|
|||||
| holdbackbeleasedate | date | 13 | √ | null |
|
|
|||||
| currcode | varchar | 10 | √ | null |
|
|
|||||
| age | int4 | 10 | √ | null |
|
|
|||||
| assetconstructor | varchar | 100 | √ | null |
|
|
|||||
| balersize | varchar | 10 | √ | null |
|
|
|||||
| capacity | float8 | 17,17 | √ | null |
|
|
|||||
| chassisno | varchar | 100 | √ | null |
|
|
|||||
| country | varchar | 10 | √ | null |
|
|
|||||
| engineno | varchar | 100 | √ | null |
|
|
|||||
| firstregistrationdate | date | 13 | √ | null |
|
|
|||||
| fiscalpower | varchar | 10 | √ | null |
|
|
|||||
| flagused | bool | 1 | √ | null |
|
|
|||||
| kwhdegradation | float8 | 17,17 | √ | null |
|
|
|||||
| kwhpower | float8 | 17,17 | √ | null |
|
|
|||||
| kwhproduction | float8 | 17,17 | √ | null |
|
|
|||||
| lift | float8 | 17,17 | √ | null |
|
|
|||||
| manufacturername | varchar | 100 | √ | null |
|
|
|||||
| manufacturerreference | varchar | 10 | √ | null |
|
|
|||||
| nbcampaign | int4 | 10 | √ | null |
|
|
|||||
| plateno | varchar | 100 | √ | null |
|
|
|||||
| power | varchar | 10 | √ | null |
|
|
|||||
| registrationcity | varchar | 50 | √ | null |
|
|
|||||
| registrationdate | date | 13 | √ | null |
|
|
|||||
| registrationname | varchar | 100 | √ | null |
|
|
|||||
| registrationno | varchar | 100 | √ | null |
|
|
|||||
| rotorhours | int4 | 10 | √ | null |
|
|
|||||
| separatortype | varchar | 10 | √ | null |
|
|
|||||
| serialno | varchar | 100 | √ | null |
|
|
|||||
| tankcapacity | float8 | 17,17 | √ | null |
|
|
|||||
| threshinghours | int4 | 10 | √ | null |
|
|
|||||
| totalbalers | int4 | 10 | √ | null |
|
|
|||||
| totalhours | int4 | 10 | √ | null |
|
|
|||||
| tpidmanufacturer | int8 | 19 | √ | null |
|
|
|||||
| transmission | varchar | 10 | √ | null |
|
|
|||||
| weight | varchar | 10 | √ | null |
|
|
|||||
| wheeldrive | varchar | 10 | √ | null |
|
|
|||||
| assetclass | varchar | 10 | √ | null |
|
|
|||||
| wheeltrack | varchar | 10 | √ | null |
|
|