invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectPurchases: 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 ProjectPurchases 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
id varchar2 ID
invoice_number varchar2 Invoice Number
organization_id varchar2 Organisation ID
organization_name varchar2 Organisation Name
organization_relation_number varchar2 itgen_spe_organization_relation_number
person_full_name varchar2 Person Full Name
person_id varchar2 Person ID
person_relation_number varchar2 itgen_spe_person_relation_number
supplier varchar2 Supplier
type varchar2 Type

Release Notes

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