# Products: Gripp CRM Products - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Products - Retrieve: True ## Table Columns The columns of the table `Products` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `archived` | `char` | Archived | ☐ | | | `buyingprice` | `double` | Buying Price | ☐ | | | `buyingvat_discr` | `varchar2` | | ☐ | | | `buyingvat_id` | `int32` | Buying VAT ID | ☐ | | | `buyingvat_searchname` | `varchar2` | Buying VAT Search Name | ☐ | | | `convertto_discr` | `varchar2` | | ☐ | | | `convertto_id` | `int32` | Convert to ID | ☐ | | | `convertto_searchname` | `varchar2` | Convert to Search Name | ☐ | | | `costheading_discr` | `varchar2` | | ☐ | | | `costheading_id` | `int32` | Cost Heading ID | ☐ | | | `costheading_searchname` | `varchar2` | Cost Heading Search Name | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `description` | `varchar2` | Description | ☐ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `hideontimetrackingform` | `char` | Hide on Timetracking Form | ☐ | | | `id` | `int32` | ID | ☐ | | | `internalnote` | `varchar2` | Internal Note | ☐ | | | `invoicebasis_discr` | `varchar2` | | ☐ | | | `invoicebasis_id` | `int32` | Invoice Basis ID | ☑ | | | `invoicebasis_searchname` | `varchar2` | Invoice Basis Search Name | ☑ | | | `ledger_discr` | `varchar2` | | ☐ | | | `ledger_id` | `int32` | Ledger ID | ☐ | | | `ledger_searchname` | `varchar2` | Ledger Search Name | ☐ | | | `name` | `varchar2` | Name | ☑ | | | `number` | `int32` | Number | ☐ | | | `purchaseledger_discr` | `varchar2` | | ☐ | | | `purchaseledger_id` | `int32` | Purchase Ledger ID | ☐ | | | `purchaseledger_searchname` | `varchar2` | Purchase Ledger Search Name | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `sellingprice` | `double` | Selling Price | ☐ | | | `supplier_discr` | `varchar2` | | ☐ | | | `supplier_id` | `int32` | Supplier ID | ☐ | | | `supplier_searchname` | `varchar2` | Supplier Search Name | ☐ | | | `supplierordercode` | `varchar2` | Supplier Order Code | ☐ | | | `tasktype_discr` | `varchar2` | | ☐ | | | `tasktype_id` | `int32` | Tasktype ID | ☐ | | | `tasktype_searchname` | `varchar2` | Tasktype Search Name | ☐ | | | `unit_discr` | `varchar2` | | ☐ | | | `unit_id` | `int32` | Unit ID | ☐ | | | `unit_searchname` | `varchar2` | Unit Search Name | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | | | `vat_discr` | `varchar2` | | ☐ | | | `vat_id` | `int32` | VAT ID | ☐ | | | `vat_searchname` | `varchar2` | VAT Search Name | ☐ | |