Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | AccountId (AccountId) | GUID | ExternalName: accountid ExternalType: Uniqueidentifier ExternalAccess: Insert
|
|
2 | AccountCategoryCode (AccountCategoryCode) | Option | [ ,PreferredCustomer,Standard] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: accountcategorycode ExternalType: Picklist
|
|
3 | DefaultPriceLevelId (DefaultPriceLevelId) | GUID | ExternalName: defaultpricelevelid ExternalType: Lookup
|
|
4 | CustomerSizeCode (CustomerSizeCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: customersizecode ExternalType: Picklist
|
|
5 | PreferredContactMethodCode (PreferredContactMethodCode) | Option | [Any,Email,Phone,Fax,Mail] OptionOrdinalValues: [1;2;3;4;5] InitValue: Any ExternalName: preferredcontactmethodcode ExternalType: Picklist
|
|
6 | CustomerTypeCode (CustomerTypeCode) | Option | [ ,Competitor,Consultant,Customer,Investor,Partner,Influencer,Press,Prospect,Reseller,Supplier,Vendor,Other] OptionOrdinalValues: [-1;1;2;3;4;5;6;7;8;9;10;11;12] InitValue: [ ] ExternalName: customertypecode ExternalType: Picklist
|
|
7 | AccountRatingCode (AccountRatingCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: accountratingcode ExternalType: Picklist
|
|
8 | IndustryCode (IndustryCode) | Option | [ ,Accounting,AgricultureandNon-petrolNaturalResourceExtraction,BroadcastingPrintingandPublishing,Brokers,BuildingSupplyRetail,BusinessServices,Consulting,ConsumerServices,DesignDirectionandCreativeManagement,DistributorsDispatchersandProcessors,DoctorsOfficesandClinics,DurableManufacturing,EatingandDrinkingPlaces,EntertainmentRetail,EquipmentRentalandLeasing,Financial,FoodandTobaccoProcessing,InboundCapitalIntensiveProcessing,InboundRepairandServices,Insurance,LegalServices,Non-DurableMerchandiseRetail,OutboundConsumerService,PetrochemicalExtractionandDistribution,ServiceRetail,SIGAffiliations,SocialServices,SpecialOutboundTradeContractors,SpecialtyRealty,Transportation,UtilityCreationandDistribution,VehicleRetail,Wholesale] OptionOrdinalValues: [-1;1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31;32;33] InitValue: [ ] ExternalName: industrycode ExternalType: Picklist
|
|
9 | TerritoryCode (TerritoryCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: territorycode ExternalType: Picklist
|
|
10 | AccountClassificationCode (AccountClassificationCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: accountclassificationcode ExternalType: Picklist
|
|
11 | BusinessTypeCode (BusinessTypeCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: businesstypecode ExternalType: Picklist
|
|
12 | OwningBusinessUnit (OwningBusinessUnit) | GUID | ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read
|
|
13 | TraversedPath (TraversedPath) | Text250 | ExternalName: traversedpath ExternalType: String
|
|
14 | OwningUser (OwningUser) | GUID | ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read
|
|
15 | PaymentTermsCode (PaymentTermsCode) | Option | [ ,Net30,2%10Net30,Net45,Net60] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: paymenttermscode ExternalType: Picklist
|
|
16 | ShippingMethodCode (ShippingMethodCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: shippingmethodcode ExternalType: Picklist
|
|
17 | PrimaryContactId (PrimaryContactId) | GUID | ExternalName: primarycontactid ExternalType: Lookup
|
|
18 | ParticipatesInWorkflow (ParticipatesInWorkflow) | Boolean | ExternalName: participatesinworkflow ExternalType: Boolean
|
|
19 | Name (Name) | Text160 | ExternalName: name ExternalType: String
|
|
20 | AccountNumber (AccountNumber) | Text20 | ExternalName: accountnumber ExternalType: String
|
|
21 | Revenue (Revenue) | Decimal | ExternalName: revenue ExternalType: Money
|
|
22 | NumberOfEmployees (NumberOfEmployees) | Integer | MaxValue: 1000000000 ExternalName: numberofemployees ExternalType: Integer
|
|
23 | Description (Description) | BLOB [Memo] | ExternalName: description ExternalType: Memo
|
|
24 | SIC (SIC) | Text20 | ExternalName: sic ExternalType: String
|
|
25 | OwnershipCode (OwnershipCode) | Option | [ ,Public,Private,Subsidiary,Other] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: ownershipcode ExternalType: Picklist
|
|
26 | MarketCap (MarketCap) | Decimal | ExternalName: marketcap ExternalType: Money
|
|
27 | SharesOutstanding (SharesOutstanding) | Integer | MaxValue: 1000000000 ExternalName: sharesoutstanding ExternalType: Integer
|
|
28 | TickerSymbol (TickerSymbol) | Text10 | ExternalName: tickersymbol ExternalType: String
|
|
29 | StockExchange (StockExchange) | Text20 | ExternalName: stockexchange ExternalType: String
|
|
30 | WebSiteURL (WebSiteURL) | Text200 [URL] | ExternalName: websiteurl ExternalType: String
|
|
31 | FtpSiteURL (FtpSiteURL) | Text200 [URL] | ExternalName: ftpsiteurl ExternalType: String
|
|
32 | EMailAddress1 (EMailAddress1) | Text100 [E-Mail] | ExternalName: emailaddress1 ExternalType: String
|
|
33 | EMailAddress2 (EMailAddress2) | Text100 [E-Mail] | ExternalName: emailaddress2 ExternalType: String
|
|
34 | EMailAddress3 (EMailAddress3) | Text100 [E-Mail] | ExternalName: emailaddress3 ExternalType: String
|
|
35 | DoNotPhone (DoNotPhone) | Boolean | ExternalName: donotphone ExternalType: Boolean
|
|
36 | DoNotFax (DoNotFax) | Boolean | ExternalName: donotfax ExternalType: Boolean
|
|
37 | Telephone1 (Telephone1) | Text50 | ExternalName: telephone1 ExternalType: String
|
|
38 | DoNotEMail (DoNotEMail) | Boolean | ExternalName: donotemail ExternalType: Boolean
|
|
39 | Telephone2 (Telephone2) | Text50 | ExternalName: telephone2 ExternalType: String
|
|
40 | Fax (Fax) | Text50 | ExternalName: fax ExternalType: String
|
|
41 | Telephone3 (Telephone3) | Text50 | ExternalName: telephone3 ExternalType: String
|
|
42 | DoNotPostalMail (DoNotPostalMail) | Boolean | ExternalName: donotpostalmail ExternalType: Boolean
|
|
43 | DoNotBulkEMail (DoNotBulkEMail) | Boolean | ExternalName: donotbulkemail ExternalType: Boolean
|
|
44 | DoNotBulkPostalMail (DoNotBulkPostalMail) | Boolean | ExternalName: donotbulkpostalmail ExternalType: Boolean
|
|
45 | CreditLimit (CreditLimit) | Decimal | ExternalName: creditlimit ExternalType: Money
|
|
46 | CreditOnHold (CreditOnHold) | Boolean | ExternalName: creditonhold ExternalType: Boolean
|
|
47 | CreatedOn (CreatedOn) | DateTime | ExternalName: createdon ExternalType: DateTime ExternalAccess: Read
|
|
48 | CreatedBy (CreatedBy) | GUID | ExternalName: createdby ExternalType: Lookup ExternalAccess: Read
|
|
49 | ModifiedOn (ModifiedOn) | DateTime | ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read
|
|
50 | ModifiedBy (ModifiedBy) | GUID | ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read
|
|
51 | VersionNumber (VersionNumber) | BigInteger | ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read
|
|
52 | ParentAccountId (ParentAccountId) | GUID | ExternalName: parentaccountid ExternalType: Lookup
|
|
53 | Aging30 (Aging30) | Decimal | ExternalName: aging30 ExternalType: Money ExternalAccess: Read
|
|
54 | StateCode (StateCode) | Option | [Active,Inactive] OptionOrdinalValues: [0;1] InitValue: Active ExternalName: statecode ExternalType: State ExternalAccess: Modify
|
|
55 | Aging60 (Aging60) | Decimal | ExternalName: aging60 ExternalType: Money ExternalAccess: Read
|
|
56 | StatusCode (StatusCode) | Option | [ ,Active,Inactive] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: statuscode ExternalType: Status
|
|
57 | Aging90 (Aging90) | Decimal | ExternalName: aging90 ExternalType: Money ExternalAccess: Read
|
|
58 | PrimaryContactIdName (PrimaryContactIdName) | Text160 | ExternalName: primarycontactidname ExternalType: String ExternalAccess: Read
|
FlowField |
59 | ParentAccountIdName (ParentAccountIdName) | Text160 | ExternalName: parentaccountidname ExternalType: String ExternalAccess: Read
|
FlowField |
60 | DefaultPriceLevelIdName (DefaultPriceLevelIdName) | Text100 | ExternalName: defaultpricelevelidname ExternalType: String ExternalAccess: Read
|
FlowField |
61 | Address1_AddressId (Address1_AddressId) | GUID | ExternalName: address1_addressid ExternalType: Uniqueidentifier
|
|
62 | Address1_AddressTypeCode (Address1_AddressTypeCode) | Option | [ ,BillTo,ShipTo,Primary,Other] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: address1_addresstypecode ExternalType: Picklist
|
|
63 | Address1_Name (Address1_Name) | Text200 | ExternalName: address1_name ExternalType: String
|
|
64 | Address1_PrimaryContactName (Address1_PrimaryContactName) | Text100 | ExternalName: address1_primarycontactname ExternalType: String
|
|
65 | Address1_Line1 (Address1_Line1) | Text250 | ExternalName: address1_line1 ExternalType: String
|
|
66 | Address1_Line2 (Address1_Line2) | Text250 | ExternalName: address1_line2 ExternalType: String
|
|
67 | Address1_Line3 (Address1_Line3) | Text250 | ExternalName: address1_line3 ExternalType: String
|
|
68 | Address1_City (Address1_City) | Text80 | ExternalName: address1_city ExternalType: String
|
|
69 | Address1_StateOrProvince (Address1_StateOrProvince) | Text50 | ExternalName: address1_stateorprovince ExternalType: String
|
|
70 | Address1_County (Address1_County) | Text50 | ExternalName: address1_county ExternalType: String
|
|
71 | Address1_Country (Address1_Country) | Text80 | ExternalName: address1_country ExternalType: String
|
|
72 | Address1_PostOfficeBox (Address1_PostOfficeBox) | Text20 | ExternalName: address1_postofficebox ExternalType: String
|
|
73 | Address1_PostalCode (Address1_PostalCode) | Text20 | ExternalName: address1_postalcode ExternalType: String
|
|
74 | Address1_UTCOffset (Address1_UTCOffset) | Integer | MinValue: -1500 MaxValue: 1500 ExternalName: address1_utcoffset ExternalType: Integer
|
|
75 | Address1_FreightTermsCode (Address1_FreightTermsCode) | Option | [ ,FOB,NoCharge] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: address1_freighttermscode ExternalType: Picklist
|
|
76 | Address1_UPSZone (Address1_UPSZone) | Text4 | ExternalName: address1_upszone ExternalType: String
|
|
77 | Address1_Latitude (Address1_Latitude) | Decimal | ExternalName: address1_latitude ExternalType: Double
|
|
78 | Address1_Telephone1 (Address1_Telephone1) | Text50 | ExternalName: address1_telephone1 ExternalType: String
|
|
79 | Address1_Longitude (Address1_Longitude) | Decimal | ExternalName: address1_longitude ExternalType: Double
|
|
80 | Address1_ShippingMethodCode (Address1_ShippingMethodCode) | Option | [ ,Airborne,DHL,FedEx,UPS,PostalMail,FullLoad,WillCall] OptionOrdinalValues: [-1;1;2;3;4;5;6;7] InitValue: [ ] ExternalName: address1_shippingmethodcode ExternalType: Picklist
|
|
81 | Address1_Telephone2 (Address1_Telephone2) | Text50 | ExternalName: address1_telephone2 ExternalType: String
|
|
82 | Address1_Telephone3 (Address1_Telephone3) | Text50 | ExternalName: address1_telephone3 ExternalType: String
|
|
83 | Address1_Fax (Address1_Fax) | Text50 | ExternalName: address1_fax ExternalType: String
|
|
84 | Address2_AddressId (Address2_AddressId) | GUID | ExternalName: address2_addressid ExternalType: Uniqueidentifier
|
|
85 | Address2_AddressTypeCode (Address2_AddressTypeCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_addresstypecode ExternalType: Picklist
|
|
86 | Address2_Name (Address2_Name) | Text200 | ExternalName: address2_name ExternalType: String
|
|
87 | Address2_PrimaryContactName (Address2_PrimaryContactName) | Text100 | ExternalName: address2_primarycontactname ExternalType: String
|
|
88 | Address2_Line1 (Address2_Line1) | Text250 | ExternalName: address2_line1 ExternalType: String
|
|
89 | Address2_Line2 (Address2_Line2) | Text250 | ExternalName: address2_line2 ExternalType: String
|
|
90 | Address2_Line3 (Address2_Line3) | Text250 | ExternalName: address2_line3 ExternalType: String
|
|
91 | Address2_City (Address2_City) | Text80 | ExternalName: address2_city ExternalType: String
|
|
92 | Address2_StateOrProvince (Address2_StateOrProvince) | Text50 | ExternalName: address2_stateorprovince ExternalType: String
|
|
93 | Address2_County (Address2_County) | Text50 | ExternalName: address2_county ExternalType: String
|
|
94 | Address2_Country (Address2_Country) | Text80 | ExternalName: address2_country ExternalType: String
|
|
95 | Address2_PostOfficeBox (Address2_PostOfficeBox) | Text20 | ExternalName: address2_postofficebox ExternalType: String
|
|
96 | Address2_PostalCode (Address2_PostalCode) | Text20 | ExternalName: address2_postalcode ExternalType: String
|
|
97 | Address2_UTCOffset (Address2_UTCOffset) | Integer | MinValue: -1500 MaxValue: 1500 ExternalName: address2_utcoffset ExternalType: Integer
|
|
98 | Address2_FreightTermsCode (Address2_FreightTermsCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_freighttermscode ExternalType: Picklist
|
|
99 | Address2_UPSZone (Address2_UPSZone) | Text4 | ExternalName: address2_upszone ExternalType: String
|
|
100 | Address2_Latitude (Address2_Latitude) | Decimal | ExternalName: address2_latitude ExternalType: Double
|
|
101 | Address2_Telephone1 (Address2_Telephone1) | Text50 | ExternalName: address2_telephone1 ExternalType: String
|
|
102 | Address2_Longitude (Address2_Longitude) | Decimal | ExternalName: address2_longitude ExternalType: Double
|
|
103 | Address2_ShippingMethodCode (Address2_ShippingMethodCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_shippingmethodcode ExternalType: Picklist
|
|
104 | Address2_Telephone2 (Address2_Telephone2) | Text50 | ExternalName: address2_telephone2 ExternalType: String
|
|
105 | Address2_Telephone3 (Address2_Telephone3) | Text50 | ExternalName: address2_telephone3 ExternalType: String
|
|
106 | Address2_Fax (Address2_Fax) | Text50 | ExternalName: address2_fax ExternalType: String
|
|
107 | CreatedByName (CreatedByName) | Text200 | ExternalName: createdbyname ExternalType: String ExternalAccess: Read
|
FlowField |
108 | ModifiedByName (ModifiedByName) | Text200 | ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read
|
FlowField |
109 | OwnerId (OwnerId) | GUID | ExternalName: ownerid ExternalType: Owner
|
|
110 | OwnerIdType (OwnerIdType) | Option | [ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName |
|
111 | PreferredAppointmentDayCode (PreferredAppointmentDayCode) | Option | [ ,Sunday,Monday,Tuesday,Wednesday,Thursday,Friday,Saturday] OptionOrdinalValues: [-1;0;1;2;3;4;5;6] InitValue: [ ] ExternalName: preferredappointmentdaycode ExternalType: Picklist
|
|
112 | PreferredSystemUserId (PreferredSystemUserId) | GUID | ExternalName: preferredsystemuserid ExternalType: Lookup
|
|
113 | PreferredAppointmentTimeCode (PreferredAppointmentTimeCode) | Option | [ ,Morning,Afternoon,Evening] OptionOrdinalValues: [-1;1;2;3] InitValue: [ ] ExternalName: preferredappointmenttimecode ExternalType: Picklist
|
|
114 | Merged (Merged) | Boolean | ExternalName: merged ExternalType: Boolean ExternalAccess: Read
|
|
115 | DoNotSendMM (DoNotSendMM) | Boolean | ExternalName: donotsendmm ExternalType: Boolean
|
|
116 | MasterId (MasterId) | GUID | ExternalName: masterid ExternalType: Lookup ExternalAccess: Read
|
|
117 | LastUsedInCampaign (LastUsedInCampaign) | Date | ExternalName: lastusedincampaign ExternalType: DateTime ExternalAccess: Modify
|
|
118 | PreferredSystemUserIdName (PreferredSystemUserIdName) | Text200 | ExternalName: preferredsystemuseridname ExternalType: String ExternalAccess: Read
|
FlowField |
119 | MasterAccountIdName (MasterAccountIdName) | Text160 | ExternalName: masteraccountidname ExternalType: String ExternalAccess: Read
|
FlowField |
120 | ExchangeRate (ExchangeRate) | Decimal | ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read
|
|
121 | UTCConversionTimeZoneCode (UTCConversionTimeZoneCode) | Integer | MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer
|
|
122 | OverriddenCreatedOn (OverriddenCreatedOn) | Date | ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert
|
|
123 | TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber) | Integer | MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer
|
|
124 | ImportSequenceNumber (ImportSequenceNumber) | Integer | ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert
|
|
125 | TransactionCurrencyId (TransactionCurrencyId) | GUID | ExternalName: transactioncurrencyid ExternalType: Lookup
|
|
126 | CreditLimit_Base (CreditLimit_Base) | Decimal | ExternalName: creditlimit_base ExternalType: Money ExternalAccess: Read
|
|
127 | TransactionCurrencyIdName (TransactionCurrencyIdName) | Text100 | ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read
|
FlowField |
128 | Aging30_Base (Aging30_Base) | Decimal | ExternalName: aging30_base ExternalType: Money ExternalAccess: Read
|
|
129 | Revenue_Base (Revenue_Base) | Decimal | ExternalName: revenue_base ExternalType: Money ExternalAccess: Read
|
|
130 | Aging90_Base (Aging90_Base) | Decimal | ExternalName: aging90_base ExternalType: Money ExternalAccess: Read
|
|
131 | MarketCap_Base (MarketCap_Base) | Decimal | ExternalName: marketcap_base ExternalType: Money ExternalAccess: Read
|
|
132 | Aging60_Base (Aging60_Base) | Decimal | ExternalName: aging60_base ExternalType: Money ExternalAccess: Read
|
|
133 | YomiName (YomiName) | Text160 | ExternalName: yominame ExternalType: String
|
|
134 | CreatedOnBehalfBy (CreatedOnBehalfBy) | GUID | ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
135 | CreatedOnBehalfByName (CreatedOnBehalfByName) | Text200 | ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
136 | ModifiedOnBehalfBy (ModifiedOnBehalfBy) | GUID | ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
137 | ModifiedOnBehalfByName (ModifiedOnBehalfByName) | Text200 | ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
138 | OwningTeam (OwningTeam) | GUID | ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read
|
|
139 | StageId (StageId) | GUID | ExternalName: stageid ExternalType: Uniqueidentifier
|
|
140 | ProcessId (ProcessId) | GUID | ExternalName: processid ExternalType: Uniqueidentifier
|
|
141 | Address2_Composite (Address2_Composite) | BLOB [Memo] | ExternalName: address2_composite ExternalType: Memo ExternalAccess: Read
|
|
142 | Address1_Composite (Address1_Composite) | BLOB [Memo] | ExternalName: address1_composite ExternalType: Memo ExternalAccess: Read
|
|
143 | EntityImageId (EntityImageId) | GUID | ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read
|
|
144 | OpenDeals (OpenDeals) | Integer | ExternalName: opendeals ExternalType: Integer ExternalAccess: Read
|
|
145 | OpenDeals_Date (OpenDeals_Date) | DateTime | ExternalName: opendeals_date ExternalType: DateTime ExternalAccess: Read
|
|
146 | OpenDeals_State (OpenDeals_State) | Integer | ExternalName: opendeals_state ExternalType: Integer ExternalAccess: Read
|
|
147 | OpenRevenue (OpenRevenue) | Decimal | ExternalName: openrevenue ExternalType: Money ExternalAccess: Read
|
|
148 | OpenRevenue_Base (OpenRevenue_Base) | Decimal | ExternalName: openrevenue_base ExternalType: Money ExternalAccess: Read
|
|
149 | OpenRevenue_Date (OpenRevenue_Date) | DateTime | ExternalName: openrevenue_date ExternalType: DateTime ExternalAccess: Read
|
|
150 | OpenRevenue_State (OpenRevenue_State) | Integer | ExternalName: openrevenue_state ExternalType: Integer ExternalAccess: Read
|
|
200 | AccountStatiticsId (AccountStatiticsId) | GUID | ExternalName: nav_accountstatisticsid ExternalType: Lookup
|
|
201 | AccountStatiticsName (AccountStatiticsName) | Text100 | ExternalName: nav_accountstatiticsidname ExternalType: String ExternalAccess: Read
|
FlowField |
Keys
# | Fields | ||
---|---|---|---|
0 | AccountId (AccountId) | Clustered: Yes | |
1 | Name (Name) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
MasterId (MasterId) | CRM Account | AccountId (AccountId) |
|
1..n |
AccountStatiticsId (AccountStatiticsId) | CRM Account Statistics | AccountStatisticsId (AccountStatisticsId) |
|
1..n |
OwningBusinessUnit (OwningBusinessUnit) | CRM Businessunit | BusinessUnitId (BusinessUnitId) |
|
1..n |
PrimaryContactId (PrimaryContactId) | CRM Contact | ContactId (ContactId) |
|
1..n |
DefaultPriceLevelId (DefaultPriceLevelId) | CRM Pricelevel | PriceLevelId (PriceLevelId) |
|
1..n |
ModifiedOnBehalfBy (ModifiedOnBehalfBy) | CRM Systemuser | SystemUserId (SystemUserId) |
|
1..n |
OwningTeam (OwningTeam) | CRM Team | TeamId (TeamId) |
|
1..n |
TransactionCurrencyId (TransactionCurrencyId) | CRM Transactioncurrency | TransactionCurrencyId (TransactionCurrencyId) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
CRM Account | MasterId (MasterId) |
|
1..n |
CRM Contact | ParentCustomerId (ParentCustomerId) |
|
1..n |
CRM Contract | BillingCustomerId (BillingCustomerId) |
|
1..n |
CRM Customeraddress | ParentId (ParentId) |
|
1..n |
CRM Incident | CustomerId (CustomerId) |
|
1..n |
CRM Invoice | CustomerId (CustomerId) |
|
1..n |
CRM Opportunity | ParentAccountId (ParentAccountId) |
|
1..n |
CRM Post | RegardingObjectId (RegardingObjectId) |
|
1..n |
CRM Quote | CustomerId (CustomerId) |
|
1..n |
CRM Salesorder | CustomerId (CustomerId) |
|
1..n |