invantive documentation
Invantive Support ForumsLog In / Sign Up

PacketPacketLinesByPacketId: Gripp CRM Packet Packet Lines by Packet ID

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Label: Packet Packet Lines by Packet ID

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.

Parameters

Name Data Type Required Default Documentation
packet.id ``

Table Columns

The columns of the table PacketPacketLinesByPacketId 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
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
discount double Discount writable
extendedproperties varchar2 Extended Properties writable
id int32 ID 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
packet_discr varchar2 itgen_gripp_packet_discr writable, packet.discr
packet_id int32 Packet ID writable, packet.id
packet_searchname varchar2 Packet Search Name writable, packet.zoeknaam
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
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

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 function GrippCrm..PacketPacketLinesByPacketId is renamed to GrippCrm.GrippCrm.PacketPacketLinesByPacketId

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