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