Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| invoice_code | varchar | 20 | √ | null |
|
|
||||
| dated | date | 13 | √ | null |
|
|
||||
| exchequer_invoice | varchar | 50 | √ | null |
|
|
||||
| details | varchar | 50 | √ | null |
|
|
||||
| net_cost | numeric | 20,4 | √ | 0 |
|
|
||||
| account | varchar | 50 | √ | null |
|
|
||||
| tl_currency | int4 | 10 | √ | 1 |
|
|
||||
| total_amount | numeric | 20,4 | √ | null |
|
|
||||
| tax | numeric | 20,4 | √ | null |
|
|
||||
| gross | numeric | 20,4 | √ | null |
|
|
||||
| paid | varchar | 50 | √ | null |
|
|
||||
| cost_centre | varchar | 100 | √ | null |
|
|
||||
| folio | int8 | 19 | √ | null |
|
|
||||
| line_position | int8 | 19 | √ | null |
|
|
||||
| legacy_cambridge | bool | 1 | √ | false |
|
|
||||
| doc_type | int2 | 5 | √ | null |
|
|
Relationships
Close relationships within degrees of separation
