ProjectReverseInvoiceById: Simplicate Project Reverse Invoice by ID
read only REST
- Catalog:
Simplicate - Schema:
Projects - Label: Project Reverse Invoice by ID
Fetches a single project reverse invoice
Can only retrieve data.
API Source
- Endpoint:
/projects/reverseinvoice/{id} - Operation:
get /projects/reverseinvoice/{id}
Parameters
| Name | Data Type | Required | Default | Documentation |
|---|---|---|---|---|
id |
`` | The template's id |
Table Columns
The columns of the table ProjectReverseInvoiceById are shown below. Each column has an SQL data type. A new non-null value must be provided for every required column at all times during insert and update.
| Name | Data Type | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
date |
varchar2 |
Date | |||
id |
varchar2 |
ID | |||
invoice_ |
varchar2 |
Invoice ID | |||
invoice_ |
varchar2 |
itgen_spe_invoice_invoice_date | |||
invoice_ |
varchar2 |
Invoice Number | |||
invoice_ |
varchar2 |
Invoice Number | |||
invoice_ |
varchar2 |
itgen_spe_invoice_status_color | |||
invoice_ |
varchar2 |
itgen_spe_invoice_status_id | |||
invoice_ |
varchar2 |
itgen_spe_invoice_status_name | |||
price |
double |
Price | |||
project_ |
char |
itgen_spe_project_has_register_mileage_enabled | |||
project_ |
varchar2 |
Project ID | |||
project_ |
varchar2 |
Project Name | |||
project_ |
varchar2 |
Project Organisation ID | |||
project_ |
varchar2 |
Project Organisation Name | |||
project_ |
varchar2 |
itgen_spe_project_organization_relation_number | |||
project_ |
varchar2 |
Project Person Full Name | |||
project_ |
varchar2 |
Project Person ID | |||
project_ |
varchar2 |
itgen_spe_project_person_relation_number | |||
project_ |
double |
Project Manager Amount | |||
project_ |
varchar2 |
Project Manager Declarable | |||
project_ |
varchar2 |
Project Manager Employee ID | |||
project_ |
varchar2 |
Project Manager ID | |||
project_ |
varchar2 |
Project Manager Name | |||
project_ |
varchar2 |
Project Manager Person ID | Added in order to comply with the original sales/sales responsible_employee response | ||
project_ |
double |
Project Manager Tariff | |||
project_ |
varchar2 |
Project Number | |||
status |
varchar2 |
Status |
Release Notes
What changed per release in the tables, columns, attributes and capabilities of the driver: