# OpportunityLineItem: Opportunity Line Item - Name: `OpportunityLineItem` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Opportunity Line Item ## Table Columns The columns of the table `OpportunityLineItem` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `Description` | `string` | Description | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `ListPrice` | `decimal` | List Price | ☐ | | | `Name` | `string` | Name | ☐ | | | `OpportunityId` | `string` | Opportunity ID | ☐ | | | `PricebookEntryId` | `string` | Pricebook Entry ID | ☐ | | | `Product2Id` | `string` | Product ID | ☐ | | | `ProductCode` | `string` | Product Code | ☐ | | | `Quantity` | `double` | Quantity | ☐ | | | `ServiceDate` | `datetime` | Service Date | ☐ | | | `SortOrder` | `int32` | Sort Order | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `TotalPrice` | `decimal` | Total Price | ☐ | | | `UnitPrice` | `decimal` | Unit Price | ☐ | |