Invoice Table - Sirius Case Management
Contains details of finance invoices associated with deputies in the database. Previously finance_invoice.
Stability: The invoice table is to be considered unstable .
Analytical Platform : Yes
Alternative formats : JSON
| Column Name | Column Type | Character Maximum | Is Nullable | Default | Constrained values |
|---|---|---|---|---|---|
| id | integer | NO | |||
| person_id | integer | YES | |||
| finance_client_id | integer | YES | |||
| feetype | text | NO | |||
| reference | character varying | 50 | NO | ||
| startdate | date | NO | |||
| enddate | date | NO | |||
| amount | integer | NO | |||
| supervisionlevel | character varying | 255 | YES | NULL::character varying | |
| confirmeddate | date | YES | |||
| batchnumber | integer | YES | |||
| raiseddate | date | YES | |||
| source | character varying | 20 | YES | NULL::character varying | |
| scheduledfn14date | date | YES | |||
| cacheddebtamount | integer | YES |