invantive documentation
Invantive Support ForumsLog In / Sign Up

ProjectProjectLines: Gripp CRM Project Project Lines

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Label: Project Project Lines

Can only retrieve data.

API Source

  • Endpoint: api3.php

Performance Characteristics

Characteristic Value
Write rows per minute 8,930

The result can be cached on the client.

Table Columns

The columns of the table ProjectProjectLines 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
_ordering int32 Ordering writable
additionalsubject varchar2 Additional Subject writable
amount double Amount writable
buyingprice double Buying Price writable
contractline_discr varchar2 itgen_gripp_contractline_discr writable, contractline.discr
contractline_id int32 Contract Line ID writable, contractline.id
contractline_searchname varchar2 Contract Line Search Name writable, contractline.searchname
convertto_discr varchar2 itgen_gripp_convertto_discr writable, convertto.discr
convertto_id int32 Convert to ID writable, convertto.id
convertto_searchname varchar2 Convert to Search Name writable, convertto.searchname
createdon_date datetime Created on Date writable, createdon.date
createdon_timezone varchar2 Created on Time Zone writable, createdon.timezone
createdon_timezone_type int32 Created on Time Zone Type writable, createdon.timezone_type
description varchar2 Description writable
discount double Discount writable
extendedproperties varchar2 Extended Properties writable
groupcategory_discr varchar2 itgen_gripp_groupcategory_discr writable, groupcategory.discr
groupcategory_id int32 Group Category ID writable, groupcategory.id
groupcategory_searchname varchar2 Group Category Search Name writable, groupcategory.searchname
hidedetails char Hide Details writable
hidefortimewriting char Hide for Time Writing writable
id int32 ID writable
internalnote varchar2 Internal Note writable
invoicebasis_discr varchar2 itgen_gripp_invoicebasis_discr writable, invoicebasis.discr
invoicebasis_id int32 Invoice Basis ID writable, invoicebasis.id
invoicebasis_searchname varchar2 Invoice Basis Search Name writable, invoicebasis.searchname
offerprojectbase_discr varchar2 itgen_gripp_offerprojectbase_discr writable, offerprojectbase.discr
offerprojectbase_id int32 Offer Project Base ID writable, offerprojectbase.id
offerprojectbase_searchname varchar2 Offer Project Base Search Name writable, offerprojectbase.searchname
parent_id int32 itgen_gripp_parent_id filters on the platform, writable, ::ancestor.id
product_discr varchar2 itgen_gripp_product_discr writable, product.discr
product_id int32 Product ID writable, product.id
product_searchname varchar2 Product Search Name writable, product.searchname
rowtype_discr varchar2 itgen_gripp_rowtype_discr writable, rowtype.discr
rowtype_id int32 Rowtype ID writable, rowtype.id
rowtype_searchname varchar2 Rowtype Search Name writable, rowtype.searchname
searchname varchar2 Search Name writable
sellingprice double Selling Price writable
unit_discr varchar2 itgen_gripp_unit_discr writable, unit.discr
unit_id int32 Unit ID writable, unit.id
unit_searchname varchar2 Unit Search Name writable, unit.searchname
updatedon_date datetime Updated on Date writable, updatedon.date
updatedon_timezone varchar2 Updated on Time Zone writable, updatedon.timezone
updatedon_timezone_type int32 Updated on Time Zone Type writable, updatedon.timezone_type
vat_discr varchar2 itgen_gripp_vat_discr writable, vat.discr
vat_id int32 VAT ID writable, vat.id
vat_searchname varchar2 VAT Search Name writable, vat.searchname

Keys

Key Column Refers to Kind Description
ProjectProjectLines_parent_id_fk parent_id Projects.id Key

Release Notes

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

Changes of This Table, 26.0 to 27.0

Table GrippCrm..ProjectProjectLines is renamed to GrippCrm.GrippCrm.ProjectProjectLines

A statement that names GrippCrm..ProjectProjectLines fails after the upgrade; use GrippCrm.GrippCrm.ProjectProjectLines. The table has 47 columns. The driver registered its objects without a schema in release 26.0; from 27.0 the schema is GrippCrm.

What to Do

Check statements, views and scripts that use it before the upgrade.

  • can break a statement
  • importance 5

All changes of the driver, 26.0 to 27.0