ProjectReverseInvoices: Simplicate Project Reverse Invoices
read only REST
- Catalog:
Simplicate - Schema:
Projects - Label: Project Reverse Invoices
Fetches all reverse invoice records
Can only retrieve data.
API Source
- Endpoint:
/projects/reverseinvoice - Operation:
get /projects/reverseinvoice
Table Columns
The columns of the table ProjectReverseInvoices 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: