ProjectReverseInvoices: Simplicate Retourfacturen Project |
Fetches all reverse invoice records
Catalogus: Simplicate
Schema: Projects
Label: Retourfacturen Project
Dit is een alleen-lezen tabel. De Simplicate API biedt mogelijk geen ondersteuning voor het wijzigen van de data of het Invantive UniversalSQL-stuurprogramma voor Simplicate ondersteunt dit niet. In het laatste geval gebruikt u de tabel NativePlatformScalarRequests om gegevens te uploaden naar de Simplicate-API.
Tabelkolommen
De kolommen van de tabel ProjectReverseInvoices worden hieronder weergegeven. Elke kolom heeft een SQL-gegevenstype.
Naam |
Datatype |
Label |
Verplicht |
Documentatie |
---|---|---|---|---|
date |
string |
Datum |
☐ |
|
id |
string |
ID |
☐ |
|
invoice_id |
string |
Factuur ID |
☐ |
|
invoice_invoice_date |
string |
|
☐ |
|
invoice_invoice_number |
string |
Factuurnummer |
☐ |
|
invoice_number |
string |
Factuurnummer |
☐ |
|
invoice_status_color |
string |
|
☐ |
|
invoice_status_id |
string |
|
☐ |
|
invoice_status_name |
string |
|
☐ |
|
price |
float |
Prijs |
☐ |
|
project_has_register_mileage_enabled |
boolean |
|
☐ |
|
project_id |
string |
Project ID |
☐ |
|
project_name |
string |
Projectnaam |
☐ |
|
project_organization_id |
string |
Projectorganisatie-ID |
☐ |
|
project_organization_name |
string |
Naam Projectorganisatie |
☐ |
|
project_organization_relation_number |
string |
|
☐ |
|
project_person_full_name |
string |
Project Persoon Volledige naam |
☐ |
|
project_person_id |
string |
Projectpersoon-ID |
☐ |
|
project_person_relation_number |
string |
|
☐ |
|
project_project_manager_amount |
float |
Projectmanager Bedrag |
☐ |
|
project_project_manager_declarable |
string |
Projectmanager Declarable |
☐ |
|
project_project_manager_employee_id |
string |
Projectmanager Werknemer ID |
☐ |
|
project_project_manager_id |
string |
Projectmanager ID |
☐ |
|
project_project_manager_name |
string |
Projectmanager Naam |
☐ |
|
project_project_manager_person_id |
string |
Projectmanager Persoon ID |
☐ |
Added in order to comply with the original sales/sales responsible_employee response |
project_project_manager_tariff |
float |
Projectmanager Tarief |
☐ |
|
project_project_number |
string |
Projectnummer |
☐ |
|
status |
string |
Status |
☐ |
|
18-10-2024 06:48 Versie 24.0.345-PROD+4945