OfferProjectLineById: Gripp CRM Offer Project Line by ID
read only REST
- Catalog:
GrippCrm - Schema:
GrippCrm - Primary Keys:
id - Label: Offer Project 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 |
|---|---|---|---|---|
offerprojectline. |
`` |
Table Columns
The columns of the table OfferProjectLineById 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 |
|---|---|---|---|---|---|
_ |
int32 |
Ordering | filters on the platform, writable | ||
additionalsubject |
varchar2 |
Additional Subject | filters on the platform, writable | ||
amount |
double |
Amount | filters on the platform, writable | ||
buyingprice |
double |
Buying Price | filters on the platform, writable | ||
contractline_ |
varchar2 |
itgen_gripp_contractline_discr | writable, contractline. |
||
contractline_ |
int32 |
Contract Line ID | filters on the platform, writable, contractline. |
||
contractline_ |
varchar2 |
Contract Line Search Name | writable, contractline. |
||
convertto_ |
varchar2 |
itgen_gripp_convertto_discr | writable, convertto. |
||
convertto_ |
int32 |
Convert to ID | filters on the platform, writable, convertto. |
||
convertto_ |
varchar2 |
Convert to Search Name | writable, convertto. |
||
createdon_ |
datetime |
Created on Date | filters on the platform, writable, createdon. |
||
createdon_ |
varchar2 |
Created on Time Zone | writable, createdon. |
||
createdon_ |
int32 |
Created on Time Zone Type | writable, createdon. |
||
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 | ||
groupcategory_ |
varchar2 |
itgen_gripp_groupcategory_discr | writable, groupcategory. |
||
groupcategory_ |
int32 |
Group Category ID | filters on the platform, writable, groupcategory. |
||
groupcategory_ |
varchar2 |
Group Category Search Name | writable, groupcategory. |
||
hidedetails |
char |
Hide Details | filters on the platform, writable | ||
hidefortimewriting |
char |
Hide for Time Writing | filters on the platform, writable | ||
id |
int32 |
ID | filters on the platform, writable | ||
internalnote |
varchar2 |
Internal Note | filters on the platform, writable | ||
invoicebasis_ |
varchar2 |
itgen_gripp_invoicebasis_discr | writable, invoicebasis. |
||
invoicebasis_ |
int32 |
Invoice Basis ID | filters on the platform, writable, invoicebasis. |
||
invoicebasis_ |
varchar2 |
Invoice Basis Search Name | writable, invoicebasis. |
||
offerprojectbase_ |
varchar2 |
itgen_gripp_offerprojectbase_discr | writable, offerprojectbase. |
||
offerprojectbase_ |
int32 |
Offer Project Base ID | filters on the platform, writable, offerprojectbase. |
||
offerprojectbase_ |
varchar2 |
Offer Project Base Search Name | writable, offerprojectbase. |
||
product_ |
varchar2 |
itgen_gripp_product_discr | writable, product. |
||
product_ |
int32 |
Product ID | filters on the platform, writable, product. |
||
product_ |
varchar2 |
Product Search Name | writable, product. |
||
rowtype_ |
varchar2 |
itgen_gripp_rowtype_discr | writable, rowtype. |
||
rowtype_ |
int32 |
Rowtype ID | filters on the platform, writable, rowtype. |
||
rowtype_ |
varchar2 |
Rowtype Search Name | writable, rowtype. |
||
searchname |
varchar2 |
Search Name | filters on the platform, writable | ||
sellingprice |
double |
Selling Price | filters on the platform, writable | ||
unit_ |
varchar2 |
itgen_gripp_unit_discr | writable, unit. |
||
unit_ |
int32 |
Unit ID | filters on the platform, writable, unit. |
||
unit_ |
varchar2 |
Unit Search Name | writable, unit. |
||
updatedon_ |
datetime |
Updated on Date | filters on the platform, writable, updatedon. |
||
updatedon_ |
varchar2 |
Updated on Time Zone | writable, updatedon. |
||
updatedon_ |
int32 |
Updated on Time Zone Type | writable, updatedon. |
||
vat_ |
varchar2 |
itgen_gripp_vat_discr | writable, vat. |
||
vat_id |
int32 |
VAT ID | filters on the platform, writable, vat.id |
||
vat_ |
varchar2 |
VAT Search Name | writable, vat. |
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..OfferProjectLineById is renamed to GrippCrm.GrippCrm.OfferProjectLineById
A statement that names GrippCrm..OfferProjectLineById fails after the upgrade; use GrippCrm.GrippCrm.OfferProjectLineById. The table function has 46 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