# InvoiceLines: Gripp CRM Invoice Lines - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Invoice Lines - Retrieve: True ## Table Columns The columns of the table `InvoiceLines` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `_ordering` | `int32` | Ordering | ☐ | | | `additionalsubject` | `varchar2` | Additional Subject | ☐ | | | `amount` | `double` | Amount | ☑ | | | `buyingprice` | `double` | Buying Price | ☑ | | | `contract_discr` | `varchar2` | | ☐ | | | `contract_id` | `int32` | Contract ID | ☐ | | | `contract_searchname` | `varchar2` | Contract Search Name | ☐ | | | `contractline_discr` | `varchar2` | | ☐ | | | `contractline_id` | `int32` | Contract Line ID | ☐ | | | `contractline_searchname` | `varchar2` | Contract Line 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 | ☐ | | | `discount` | `double` | Discount | ☑ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `groepscategorie_discr` | `varchar2` | | ☐ | | | `groepscategorie_id` | `int32` | | ☐ | | | `groepscategorie_searchname` | `varchar2` | | ☐ | | | `hidedetails` | `char` | Hide Details | ☐ | | | `id` | `int32` | ID | ☐ | | | `invoice_discr` | `varchar2` | | ☐ | | | `invoice_id` | `int32` | Invoice ID | ☑ | | | `invoice_searchname` | `varchar2` | Invoice Search Name | ☑ | | | `ledger_discr` | `varchar2` | | ☐ | | | `ledger_id` | `int32` | Ledger ID | ☐ | | | `ledger_searchname` | `varchar2` | Ledger Search Name | ☐ | | | `part_discr` | `varchar2` | | ☐ | | | `part_id` | `int32` | Part ID | ☐ | | | `part_searchname` | `varchar2` | Part Search Name | ☐ | | | `product_discr` | `varchar2` | | ☐ | | | `product_id` | `int32` | Product ID | ☑ | | | `product_searchname` | `varchar2` | Product Search Name | ☑ | | | `project_discr` | `varchar2` | | ☐ | | | `project_id` | `int32` | Project ID | ☐ | | | `project_searchname` | `varchar2` | Project Search Name | ☐ | | | `rowtype_discr` | `varchar2` | | ☐ | | | `rowtype_id` | `int32` | Rowtype ID | ☐ | | | `rowtype_searchname` | `varchar2` | Rowtype Search Name | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `sellingprice` | `double` | Selling Price | ☑ | | | `umbrellaproject_discr` | `varchar2` | | ☐ | | | `umbrellaproject_id` | `int32` | Umbrella Project ID | ☐ | | | `umbrellaproject_searchname` | `varchar2` | Umbrella Project 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 | ☐ | |