invantive documentation
Invantive Support ForumsLog In / Sign Up

PurchaseInvoiceLineById: Gripp CRM Purchase Invoice Line by ID

read only REST

  • Catalog: GrippCrm
  • Schema: GrippCrm
  • Primary Keys: id
  • Label: Purchase Invoice Line by 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
purchaseinvoiceline.id ``

Table Columns

The columns of the table PurchaseInvoiceLineById 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 filters on the platform, writable
additionalsubject varchar2 Additional Subject filters on the platform, writable
amount double Amount filters on the platform, writable
costheading_discr varchar2 itgen_gripp_costheading_discr writable, costheading.discr
costheading_id int32 Cost Heading ID filters on the platform, writable, costheading.id
costheading_searchname varchar2 Cost Heading Search Name writable, costheading.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
description varchar2 Description filters on the platform, writable
discount double Discount filters on the platform, writable
extendedproperties varchar2 Extended Properties filters on the platform, writable
id int32 ID filters on the platform, writable
ledger_discr varchar2 itgen_gripp_ledger_discr writable, ledger.discr
ledger_id int32 Ledger ID filters on the platform, writable, ledger.id
ledger_searchname varchar2 Ledger Search Name writable, ledger.searchname
part_discr varchar2 itgen_gripp_part_discr writable, part.discr
part_id int32 Part ID filters on the platform, writable, part.id
part_searchname varchar2 Part Search Name writable, part.searchname
project_discr varchar2 itgen_gripp_project_discr writable, project.discr
project_id int32 Project ID filters on the platform, writable, project.id
project_searchname varchar2 Project Search Name writable, project.searchname
purchaseinvoice_discr varchar2 itgen_gripp_purchaseinvoice_discr writable, purchaseinvoice.discr
purchaseinvoice_id int32 Purchase Invoice ID filters on the platform, writable, purchaseinvoice.id
purchaseinvoice_searchname varchar2 Purchase Invoice Search Name writable, purchaseinvoice.searchname
purchaseorderline_discr varchar2 itgen_gripp_purchaseorderline_discr writable, purchaseorderline.discr
purchaseorderline_id int32 Purchase Order Line ID filters on the platform, writable, purchaseorderline.id
purchaseorderline_searchname varchar2 Purchase Order Line Search Name writable, purchaseorderline.searchname
searchname varchar2 Search Name filters on the platform, writable
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
vat_discr varchar2 itgen_gripp_vat_discr writable, vat.discr
vat_id int32 VAT ID filters on the platform, 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..PurchaseInvoiceLineById is renamed to GrippCrm.GrippCrm.PurchaseInvoiceLineById

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