# PurchaseInvoices: Gripp CRM Purchase Invoices - Catalog: `GrippCrm` - Primary Keys: `id` - Label: Purchase Invoices - Retrieve: True ## Table Columns The columns of the table `PurchaseInvoices` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `bookingnumber` | `int32` | Booking Number | ☐ | | | `company_discr` | `varchar2` | | ☐ | | | `company_id` | `int32` | Company ID | ☐ | | | `company_searchname` | `varchar2` | Company Search Name | ☐ | | | `contact_discr` | `varchar2` | | ☐ | | | `contact_id` | `int32` | Contact ID | ☐ | | | `contact_searchname` | `varchar2` | Contact Search Name | ☐ | | | `createdon_date` | `datetime` | Created on Date | ☐ | | | `createdon_timezone_type` | `int32` | Created on Timezone Type | ☐ | | | `createdon_timezone` | `varchar2` | Created on Timezone | ☐ | | | `date_date` | `datetime` | Date Date | ☐ | | | `date_timezone_type` | `int32` | Date Timezone Type | ☐ | | | `date_timezone` | `varchar2` | Date Timezone | ☐ | | | `description` | `varchar2` | Description | ☐ | | | `expirydate_date` | `datetime` | Expiry Date (Date) | ☐ | | | `expirydate_timezone_type` | `int32` | Expiry Date (Timezone Type) | ☐ | | | `expirydate_timezone` | `varchar2` | Expiry Date (Timezone) | ☐ | | | `extendedproperties` | `varchar2` | Extended Properties | ☐ | | | `id` | `int32` | ID | ☐ | | | `identity_discr` | `varchar2` | | ☐ | | | `identity_id` | `int32` | Identity ID | ☑ | | | `identity_searchname` | `varchar2` | Identity Search Name | ☑ | | | `isopenstaand` | `char` | | ☐ | | | `number` | `varchar2` | Number | ☐ | | | `paymentmethod_discr` | `varchar2` | | ☐ | | | `paymentmethod_id` | `int32` | Payment Method ID | ☑ | | | `paymentmethod_searchname` | `varchar2` | Payment Method Search Name | ☑ | | | `phase_discr` | `varchar2` | | ☐ | | | `phase_id` | `int32` | Phase ID | ☑ | | | `phase_searchname` | `varchar2` | Phase Search Name | ☑ | | | `reportdate_date` | `datetime` | Report Date (Date) | ☐ | | | `reportdate_timezone_type` | `int32` | Report Date (Timezone Type) | ☐ | | | `reportdate_timezone` | `varchar2` | Report Date (Timezone) | ☐ | | | `searchname` | `varchar2` | Search Name | ☐ | | | `subject` | `varchar2` | Subject | ☐ | | | `totalbuyingincldiscountexclvat` | `double` | Total Buying incl. Discount excl. VAT | ☐ | | | `totalincldiscountinclvat` | `double` | Total incl. Discount incl. VAT | ☐ | | | `totalinclvat` | `double` | Total incl. VAT | ☐ | | | `totalopeninclvat` | `double` | Total Open incl. VAT | ☐ | | | `totalpayed` | `double` | Total Paid | ☐ | | | `updatedon_date` | `datetime` | Updated on Date | ☐ | | | `updatedon_timezone_type` | `int32` | Updated on Timezone Type | ☐ | | | `updatedon_timezone` | `varchar2` | Updated on Timezone | ☐ | |