Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Id | id | 18 | null |
|
|
Label: Organization ID |
||||||||
| Name | string | 80 | null |
|
|
Label: Name |
||||||||
| Division | string | 80 | null |
|
|
Label: Division |
||||||||
| Street | textarea | 255 | null |
|
|
Label: Street |
||||||||
| City | string | 40 | null |
|
|
Label: City |
||||||||
| State | string | 80 | null |
|
|
Label: State/Province |
||||||||
| PostalCode | string | 20 | null |
|
|
Label: Zip/Postal Code |
||||||||
| Country | string | 80 | null |
|
|
Label: Country |
||||||||
| Phone | phone | 40 | null |
|
|
Label: Phone |
||||||||
| Fax | phone | 40 | null |
|
|
Label: Fax |
||||||||
| PrimaryContact | string | 80 | null |
|
|
Label: Primary Contact |
||||||||
| DefaultLocaleSidKey | picklist | 40 | null |
|
|
Label: Locale |
||||||||
| LanguageLocaleKey | picklist | 40 | null |
|
|
Label: Language |
||||||||
| ReceivesInfoEmails | boolean | 0 | null |
|
|
Label: Info Emails |
||||||||
| ReceivesAdminInfoEmails | boolean | 0 | null |
|
|
Label: Info Emails Admin |
||||||||
| PreferencesRequireOpportunityProducts | boolean | 0 | null |
|
|
Label: RequireOpportunityProducts |
||||||||
| FiscalYearStartMonth | int | 9 | null |
|
|
Label: Fiscal Year Starts In |
||||||||
| UsesStartDateAsFiscalYearName | boolean | 0 | null |
|
|
Label: Fiscal Year Name by Start |
||||||||
| DefaultAccountAccess | picklist | 40 | null |
|
|
Label: Default Account Access |
||||||||
| DefaultContactAccess | picklist | 40 | null |
|
|
Label: Default Contact Access |
||||||||
| DefaultOpportunityAccess | picklist | 40 | null |
|
|
Label: Default Opportunity Access |
||||||||
| DefaultLeadAccess | picklist | 40 | null |
|
|
Label: Default Lead Access |
||||||||
| DefaultCaseAccess | picklist | 40 | null |
|
|
Label: Default Case Access |
||||||||
| DefaultCalendarAccess | picklist | 40 | null |
|
|
Label: Default Calendar Access |
||||||||
| DefaultPricebookAccess | picklist | 40 | null |
|
|
Label: Default Price Book Access |
||||||||
| DefaultCampaignAccess | picklist | 40 | null |
|
|
Label: Default Campaign Access |
||||||||
| DelegatedAuthenticationServiceUrl | url | 255 | null |
|
|
Label: Single Sign-On Gateway URL |
||||||||
| SystemModstamp | datetime | 0 | null |
|
|
Label: System Modstamp |
||||||||
| ComplianceBccEmail | 80 | null |
|
|
Label: Compliance BCC Email |
|||||||||
| UiSkin | picklist | 40 | null |
|
|
Label: UI Skin |
||||||||
| SignupCountryIsoCode | string | 2 | null |
|
|
Label: Signup Country |
||||||||
| TrialExpirationDate | datetime | 0 | null |
|
|
Label: Trial Expiration Date |
||||||||
| OrganizationType | picklist | 40 | null |
|
|
Label: Edition |
||||||||
| WebToCaseDefaultOrigin | string | 40 | null |
|
|
Label: Web to Cases Default Origin |
||||||||
| MonthlyPageViewsUsed | int | 9 | null |
|
|
Label: Monthly Page Views Used |
||||||||
| MonthlyPageViewsEntitlement | int | 9 | null |
|
|
Label: Monthly Page Views Allowed |
||||||||
| CreatedDate | datetime | 0 | null |
|
|
Label: Created Date |
||||||||
| CreatedById | reference | 18 | null |
|
|
Label: Created By ID |
||||||||
| LastModifiedDate | datetime | 0 | null |
|
|
Label: Last Modified Date |
||||||||
| LastModifiedById | reference | 18 | null |
|
|
Label: Last Modified By ID |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| FakeIndex125 | Must be unique | Asc | Id |