invantive documentation
Invantive Support ForumsLog In / Sign Up

PriceExceptions: Gripp CRM Price Exceptions

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Primary Keys: id
  • Label: Price Exceptions

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 PriceExceptions 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
company_discr varchar2 itgen_gripp_company_discr writable, company.discr
company_id int32 Company ID filters on the platform, writable, company.id
company_searchname varchar2 Company Search Name writable, company.searchname
createdon_date datetime Created on Date filters on the platform, 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
extendedproperties varchar2 Extended Properties filters on the platform, writable
id int32 ID filters on the platform, writable
product_discr varchar2 itgen_gripp_product_discr writable, product.discr
product_id int32 Product ID filters on the platform, writable, product.id
product_searchname varchar2 Product Search Name writable, product.searchname
sellingprice double Selling Price filters on the platform, writable
updatedon_date datetime Updated on Date filters on the platform, 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

Keys

Key Column Refers to Kind Description
PriceExceptions_company_id_fk company_id Companies.id Key
PriceExceptions_product_id_fk product_id Products.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..PriceExceptions is renamed to GrippCrm.GrippCrm.PriceExceptions

A statement that names GrippCrm..PriceExceptions fails after the upgrade; use GrippCrm.GrippCrm.PriceExceptions. The table has 15 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