invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectPurchases2: Simplicate Project Purchases

read only REST

  • Catalog: Simplicate
  • Schema: Projects
  • Label: Project Purchases

Fetches all project purchase records

Can only retrieve data.

API Source

  • Endpoint: /projects/purchase
  • Operation: get /projects/purchase

Table Columns

The columns of the table ProjectPurchases2 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
has_register_mileage_enabled char itgen_spe_has_register_mileage_enabled
id varchar2 ID
id_2 varchar2 itgen_spe_id_2
invoice_number varchar2 Invoice Number
name varchar2 Name
organization_id varchar2 Organisation ID
organization_id_2 varchar2 itgen_spe_organization_id_2
organization_name varchar2 Organisation Name
organization_name_2 varchar2 itgen_spe_organization_name_2
organization_relation_number varchar2 itgen_spe_organization_relation_number
organization_relation_number_2 varchar2 itgen_spe_organization_relation_number_2
person_full_name varchar2 Person Full Name
person_full_name_2 varchar2 itgen_spe_person_full_name_2
person_id varchar2 Person ID
person_id_2 varchar2 itgen_spe_person_id_2
person_relation_number varchar2 itgen_spe_person_relation_number
person_relation_number_2 varchar2 itgen_spe_person_relation_number_2
project_manager_amount double itgen_spe_project_manager_amount
project_manager_declarable varchar2 itgen_spe_project_manager_declarable
project_manager_employee_id varchar2 itgen_spe_project_manager_employee_id
project_manager_id varchar2 itgen_spe_project_manager_id
project_manager_name varchar2 itgen_spe_project_manager_name
project_manager_person_id varchar2 itgen_spe_project_manager_person_id Added in order to comply with the original sales/sales responsible_employee response
project_manager_tariff double itgen_spe_project_manager_tariff
project_number varchar2 Project Number
supplier varchar2 Supplier
type varchar2 Type

Release Notes

What changed per release in the tables, columns, attributes and capabilities of the driver: