invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseInvoiceCustomFieldValues: Gripp CRM Purchase Invoice Custom Field Values

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Primary Keys: parent_id
  • Label: Purchase Invoice Custom Field Values

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 PurchaseInvoiceCustomFieldValues 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
key varchar2 Key writable
parent_id int32 itgen_gripp_parent_id filters on the platform, writable, id
value varchar2 Value writable

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

View GrippCrm..PurchaseInvoiceCustomFieldValues is renamed to GrippCrm.GrippCrm.PurchaseInvoiceCustomFieldValues

A statement that names GrippCrm..PurchaseInvoiceCustomFieldValues fails after the upgrade; use GrippCrm.GrippCrm.PurchaseInvoiceCustomFieldValues. The view has 3 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