Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | CreatedBy (CreatedBy) | GUID | ExternalName: createdby ExternalType: Lookup ExternalAccess: Read
|
|
2 | CreatedByName (CreatedByName) | Text200 | ExternalName: createdbyname ExternalType: String ExternalAccess: Read
|
FlowField |
3 | CreatedOn (CreatedOn) | DateTime | ExternalName: createdon ExternalType: DateTime ExternalAccess: Read
|
|
4 | CreatedOnBehalfBy (CreatedOnBehalfBy) | GUID | ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
5 | CreatedOnBehalfByName (CreatedOnBehalfByName) | Text200 | ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
6 | OrganizationId (OrganizationId) | GUID | ExternalName: organizationid ExternalType: Lookup ExternalAccess: Read
|
|
7 | OrganizationIdName (OrganizationIdName) | Text160 | ExternalName: organizationidname ExternalType: String ExternalAccess: Read
|
FlowField |
8 | PostId (PostId) | GUID | ExternalName: postid ExternalType: Uniqueidentifier ExternalAccess: Insert
|
|
9 | RegardingObjectId (RegardingObjectId) | GUID | ExternalName: regardingobjectid ExternalType: Lookup ExternalAccess: Insert
|
|
10 | RegardingObjectTypeCode (RegardingObjectTypeCode) | Option | [ ,systemuser,account,contact,opportunity,post,transactioncurrency,pricelevel,productpricelevel,product,incident,incidentresolution,quote,quotedetail,salesorder,salesorderdetail,invoice,invoicedetail,contract,team,customeraddress,uom,uomschedule,organization,businessunit,discount,discounttype] ExternalName: regardingobjecttypecode ExternalType: EntityName ExternalAccess: Insert
|
|
11 | Source (Source) | Option | [AutoPost,ManualPost] OptionOrdinalValues: [1;2] InitValue: ManualPost ExternalName: source ExternalType: Picklist ExternalAccess: Insert
|
|
12 | Text (Text) | Text250 | ExternalName: text ExternalType: String ExternalAccess: Insert
|
|
13 | TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber) | Integer | MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer
|
|
14 | Type (Type) | Option | [Check-in,Idea,News,PrivateMessage,Question,Re-post,Status] OptionOrdinalValues: [1;2;3;4;5;6;7] InitValue: Check-in ExternalName: type ExternalType: Picklist ExternalAccess: Insert
|
|
15 | UTCConversionTimeZoneCode (UTCConversionTimeZoneCode) | Integer | MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer
|
|
16 | RegardingObjectOwnerId (RegardingObjectOwnerId) | GUID | ExternalName: regardingobjectownerid ExternalType: Owner ExternalAccess: Read
|
|
17 | RegardingObjectOwnerIdType (RegardingObjectOwnerIdType) | Option | [ ,systemuser,team] ExternalName: regardingobjectowneridtype ExternalType: EntityName ExternalAccess: Read
|
|
18 | RegardingObjectOwningBusinessU (RegardingObjectOwningBusinessU) | GUID | ExternalName: regardingobjectowningbusinessunit ExternalType: Lookup ExternalAccess: Read
|
|
19 | ModifiedBy (ModifiedBy) | GUID | ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read
|
|
20 | ModifiedByName (ModifiedByName) | Text200 | ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read
|
FlowField |
21 | ModifiedOnBehalfBy (ModifiedOnBehalfBy) | GUID | ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
22 | ModifiedOnBehalfByName (ModifiedOnBehalfByName) | Text200 | ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
23 | ModifiedOn (ModifiedOn) | DateTime | ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read
|
Keys
# | Fields | ||
---|---|---|---|
0 | PostId (PostId) | Clustered: Yes | |
1 | Text (Text) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
RegardingObjectId (RegardingObjectId) | CRM Account | AccountId (AccountId) |
|
1..n |
RegardingObjectOwningBusinessU (RegardingObjectOwningBusinessU) | CRM Businessunit | BusinessUnitId (BusinessUnitId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Contact | ContactId (ContactId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Contract | ContractId (ContractId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Customeraddress | CustomerAddressId (CustomerAddressId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Discount | DiscountId (DiscountId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Discounttype | DiscountTypeId (DiscountTypeId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Incident | IncidentId (IncidentId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Incidentresolution | ActivityId (ActivityId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Invoice | InvoiceId (InvoiceId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Invoicedetail | InvoiceDetailId (InvoiceDetailId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Opportunity | OpportunityId (OpportunityId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Organization | OrganizationId (OrganizationId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Post | PostId (PostId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Pricelevel | PriceLevelId (PriceLevelId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Product | ProductId (ProductId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Productpricelevel | ProductPriceLevelId (ProductPriceLevelId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Quote | QuoteId (QuoteId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Quotedetail | QuoteDetailId (QuoteDetailId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Salesorder | SalesOrderId (SalesOrderId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Salesorderdetail | SalesOrderDetailId (SalesOrderDetailId) |
|
1..n |
ModifiedOnBehalfBy (ModifiedOnBehalfBy) | CRM Systemuser | SystemUserId (SystemUserId) |
|
1..n |
RegardingObjectOwnerId (RegardingObjectOwnerId) | CRM Team | TeamId (TeamId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Transactioncurrency | TransactionCurrencyId (TransactionCurrencyId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Uom | UoMId (UoMId) |
|
1..n |
RegardingObjectId (RegardingObjectId) | CRM Uomschedule | UoMScheduleId (UoMScheduleId) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
CRM Post | RegardingObjectId (RegardingObjectId) |
|
1..n |