# Asset: Assets
- Name: `Asset`
- Catalog: `Salesforce`
- Schema: `Salesforce`
- Primary Keys: `id`
- Label: Assets
## Table Columns
The columns of the table `Asset` are shown below. Each column has an SQL data type.
| Name | Data Type | Label | Required | Documentation |
|---|:---:|---|:---:|---|
| `AccountId` | `string` | Account ID | ☐ | |
| `ContactId` | `string` | Contact ID | ☐ | |
| `CreatedById` | `string` | Created by ID | ☐ | |
| `CreatedDate` | `datetime` | Date Created | ☐ | |
| `Description` | `string` | Description | ☐ | |
| `Id` | `string` | ID | ☐ | |
| `InstallDate` | `datetime` | Install Date | ☐ | |
| `IsCompetitorProduct` | `boolean` | Is Competitor Product | ☐ | |
| `IsDeleted` | `boolean` | Is Deleted | ☐ | |
| `LastModifiedById` | `string` | Last Modified by ID | ☐ | |
| `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | |
| `LastReferencedDate` | `datetime` | Last Referenced Date | ☐ | |
| `LastViewedDate` | `datetime` | Last Viewed Date | ☐ | |
| `Name` | `string` | Name | ☐ | |
| `OwnerId` | `string` | Owner ID | ☐ | |
| `ParentId` | `string` | Parent ID | ☐ | |
| `Price` | `decimal` | Price | ☐ | |
| `Product2Id` | `string` | Product ID | ☐ | |
| `PurchaseDate` | `datetime` | Purchase Date | ☐ | |
| `Quantity` | `double` | Quantity | ☐ | |
| `RootAssetId` | `string` | Root Asset ID | ☐ | |
| `SerialNumber` | `string` | Serial Number | ☐ | |
| `Status` | `string` | Status | ☐ | |
| `SystemModstamp` | `datetime` | System Modstamp | ☐ | |
| `UsageEndDate` | `datetime` | Usage End Date | ☐ | |