# Case: Cases - Name: `Case` - Catalog: `Salesforce` - Schema: `Salesforce` - Primary Keys: `id` - Label: Cases ## Table Columns The columns of the table `Case` are shown below. Each column has an SQL data type. | Name | Data Type | Label | Required | Documentation | |---|:---:|---|:---:|---| | `AccountId` | `string` | Account ID | ☐ | | | `AssetId` | `string` | Asset ID | ☐ | | | `CaseNumber` | `string` | Case Number | ☐ | | | `ClosedDate` | `datetime` | Closed Date | ☐ | | | `ContactEmail` | `string` | Contact Email | ☐ | | | `ContactFax` | `string` | Contact Fax | ☐ | | | `ContactId` | `string` | Contact ID | ☐ | | | `ContactMobile` | `string` | Contact Mobile | ☐ | | | `ContactPhone` | `string` | Contact Phone | ☐ | | | `CreatedById` | `string` | Created by ID | ☐ | | | `CreatedDate` | `datetime` | Date Created | ☐ | | | `Description` | `string` | Description | ☐ | | | `EngineeringReqNumber__c` | `string` | Engineering Req Number | ☐ | | | `Id` | `string` | ID | ☐ | | | `IsClosed` | `boolean` | Is Closed | ☐ | | | `IsDeleted` | `boolean` | Is Deleted | ☐ | | | `IsEscalated` | `boolean` | Is Escalated | ☐ | | | `LastModifiedById` | `string` | Last Modified by ID | ☐ | | | `LastModifiedDate` | `datetime` | Date Last Modified | ☐ | | | `LastReferencedDate` | `datetime` | Last Referenced Date | ☐ | | | `LastViewedDate` | `datetime` | Last Viewed Date | ☐ | | | `Origin` | `string` | Origin | ☐ | | | `OwnerId` | `string` | Owner ID | ☐ | | | `ParentId` | `string` | Parent ID | ☐ | | | `PotentialLiability__c` | `string` | Potential Liability | ☐ | | | `Priority` | `string` | Priority | ☐ | | | `Product__c` | `string` | Product | ☐ | | | `Reason` | `string` | Reason | ☐ | | | `SLAViolation__c` | `string` | SLA Violation | ☐ | | | `Status` | `string` | Status | ☐ | | | `Subject` | `string` | Subject | ☐ | | | `SuppliedCompany` | `string` | Supplied Company | ☐ | | | `SuppliedEmail` | `string` | Supplied Email | ☐ | | | `SuppliedName` | `string` | Supplied Name | ☐ | | | `SuppliedPhone` | `string` | Supplied Phone | ☐ | | | `SystemModstamp` | `datetime` | System Modstamp | ☐ | | | `Type` | `string` | Type | ☐ | |