Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | BusinessUnitId (BusinessUnitId) | GUID | ExternalName: businessunitid ExternalType: Uniqueidentifier ExternalAccess: Insert
|
|
2 | OrganizationId (OrganizationId) | GUID | ExternalName: organizationid ExternalType: Lookup ExternalAccess: Read
|
|
3 | Name (Name) | Text160 | ExternalName: name ExternalType: String
|
|
4 | Description (Description) | BLOB [Memo] | ExternalName: description ExternalType: Memo
|
|
5 | DivisionName (DivisionName) | Text100 | ExternalName: divisionname ExternalType: String
|
|
6 | FileAsName (FileAsName) | Text100 | ExternalName: fileasname ExternalType: String
|
|
7 | TickerSymbol (TickerSymbol) | Text10 | ExternalName: tickersymbol ExternalType: String
|
|
8 | StockExchange (StockExchange) | Text20 | ExternalName: stockexchange ExternalType: String
|
|
9 | UTCOffset (UTCOffset) | Integer | MinValue: -1500 MaxValue: 1500 ExternalName: utcoffset ExternalType: Integer
|
|
10 | CreatedOn (CreatedOn) | DateTime | ExternalName: createdon ExternalType: DateTime ExternalAccess: Read
|
|
11 | ModifiedOn (ModifiedOn) | DateTime | ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read
|
|
12 | CreditLimit (CreditLimit) | Decimal | ExternalName: creditlimit ExternalType: Double
|
|
13 | CostCenter (CostCenter) | Text100 | ExternalName: costcenter ExternalType: String
|
|
14 | WebSiteUrl (WebSiteUrl) | Text200 [URL] | ExternalName: websiteurl ExternalType: String
|
|
15 | FtpSiteUrl (FtpSiteUrl) | Text200 [URL] | ExternalName: ftpsiteurl ExternalType: String
|
|
16 | EMailAddress (EMailAddress) | Text100 [E-Mail] | ExternalName: emailaddress ExternalType: String
|
|
17 | InheritanceMask (InheritanceMask) | Integer | MaxValue: 1000000000 ExternalName: inheritancemask ExternalType: Integer ExternalAccess: Insert
|
|
18 | CreatedBy (CreatedBy) | GUID | ExternalName: createdby ExternalType: Lookup ExternalAccess: Read
|
|
19 | ModifiedBy (ModifiedBy) | GUID | ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read
|
|
20 | WorkflowSuspended (WorkflowSuspended) | Boolean | ExternalName: workflowsuspended ExternalType: Boolean
|
|
21 | ParentBusinessUnitId (ParentBusinessUnitId) | GUID | ExternalName: parentbusinessunitid ExternalType: Lookup
|
|
22 | IsDisabled (IsDisabled) | Boolean | ExternalName: isdisabled ExternalType: Boolean ExternalAccess: Read
|
|
23 | DisabledReason (DisabledReason) | Text250 | ExternalName: disabledreason ExternalType: String ExternalAccess: Read
|
|
24 | VersionNumber (VersionNumber) | BigInteger | ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read
|
|
25 | ParentBusinessUnitIdName (ParentBusinessUnitIdName) | Text160 | ExternalName: parentbusinessunitidname ExternalType: String ExternalAccess: Read
|
FlowField |
26 | Address1_AddressId (Address1_AddressId) | GUID | ExternalName: address1_addressid ExternalType: Uniqueidentifier
|
|
27 | Address1_AddressTypeCode (Address1_AddressTypeCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address1_addresstypecode ExternalType: Picklist
|
|
28 | Address1_Name (Address1_Name) | Text100 | ExternalName: address1_name ExternalType: String
|
|
29 | Address1_Line1 (Address1_Line1) | Text250 | ExternalName: address1_line1 ExternalType: String
|
|
30 | Address1_Line2 (Address1_Line2) | Text250 | ExternalName: address1_line2 ExternalType: String
|
|
31 | Address1_Line3 (Address1_Line3) | Text250 | ExternalName: address1_line3 ExternalType: String
|
|
32 | Address1_City (Address1_City) | Text80 | ExternalName: address1_city ExternalType: String
|
|
33 | Address1_StateOrProvince (Address1_StateOrProvince) | Text50 | ExternalName: address1_stateorprovince ExternalType: String
|
|
34 | Address1_County (Address1_County) | Text50 | ExternalName: address1_county ExternalType: String
|
|
35 | Address1_Country (Address1_Country) | Text80 | ExternalName: address1_country ExternalType: String
|
|
36 | Address1_PostOfficeBox (Address1_PostOfficeBox) | Text20 | ExternalName: address1_postofficebox ExternalType: String
|
|
37 | Address1_PostalCode (Address1_PostalCode) | Text20 | ExternalName: address1_postalcode ExternalType: String
|
|
38 | Address1_UTCOffset (Address1_UTCOffset) | Integer | MinValue: -1500 MaxValue: 1500 ExternalName: address1_utcoffset ExternalType: Integer
|
|
39 | Address1_UPSZone (Address1_UPSZone) | Text4 | ExternalName: address1_upszone ExternalType: String
|
|
40 | Address1_Latitude (Address1_Latitude) | Decimal | ExternalName: address1_latitude ExternalType: Double
|
|
41 | Address1_Telephone1 (Address1_Telephone1) | Text50 | ExternalName: address1_telephone1 ExternalType: String
|
|
42 | Address1_Longitude (Address1_Longitude) | Decimal | ExternalName: address1_longitude ExternalType: Double
|
|
43 | Address1_ShippingMethodCode (Address1_ShippingMethodCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address1_shippingmethodcode ExternalType: Picklist
|
|
44 | Address1_Telephone2 (Address1_Telephone2) | Text50 | ExternalName: address1_telephone2 ExternalType: String
|
|
45 | Address1_Telephone3 (Address1_Telephone3) | Text50 | ExternalName: address1_telephone3 ExternalType: String
|
|
46 | Address1_Fax (Address1_Fax) | Text50 | ExternalName: address1_fax ExternalType: String
|
|
47 | Address2_AddressId (Address2_AddressId) | GUID | ExternalName: address2_addressid ExternalType: Uniqueidentifier
|
|
48 | Address2_AddressTypeCode (Address2_AddressTypeCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_addresstypecode ExternalType: Picklist
|
|
49 | Address2_Name (Address2_Name) | Text100 | ExternalName: address2_name ExternalType: String
|
|
50 | Address2_Line1 (Address2_Line1) | Text250 | ExternalName: address2_line1 ExternalType: String
|
|
51 | Address2_Line2 (Address2_Line2) | Text250 | ExternalName: address2_line2 ExternalType: String
|
|
52 | Address2_Line3 (Address2_Line3) | Text250 | ExternalName: address2_line3 ExternalType: String
|
|
53 | Address2_City (Address2_City) | Text80 | ExternalName: address2_city ExternalType: String
|
|
54 | Address2_StateOrProvince (Address2_StateOrProvince) | Text50 | ExternalName: address2_stateorprovince ExternalType: String
|
|
55 | Address2_County (Address2_County) | Text50 | ExternalName: address2_county ExternalType: String
|
|
56 | Address2_Country (Address2_Country) | Text80 | ExternalName: address2_country ExternalType: String
|
|
57 | Address2_PostOfficeBox (Address2_PostOfficeBox) | Text20 | ExternalName: address2_postofficebox ExternalType: String
|
|
58 | Address2_PostalCode (Address2_PostalCode) | Text20 | ExternalName: address2_postalcode ExternalType: String
|
|
59 | Address2_UTCOffset (Address2_UTCOffset) | Integer | MinValue: -1500 MaxValue: 1500 ExternalName: address2_utcoffset ExternalType: Integer
|
|
60 | Address2_UPSZone (Address2_UPSZone) | Text4 | ExternalName: address2_upszone ExternalType: String
|
|
61 | Address2_Latitude (Address2_Latitude) | Decimal | ExternalName: address2_latitude ExternalType: Double
|
|
62 | Address2_Telephone1 (Address2_Telephone1) | Text50 | ExternalName: address2_telephone1 ExternalType: String
|
|
63 | Address2_Longitude (Address2_Longitude) | Decimal | ExternalName: address2_longitude ExternalType: Double
|
|
64 | Address2_ShippingMethodCode (Address2_ShippingMethodCode) | Option | DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: address2_shippingmethodcode ExternalType: Picklist
|
|
65 | Address2_Telephone2 (Address2_Telephone2) | Text50 | ExternalName: address2_telephone2 ExternalType: String
|
|
66 | Address2_Telephone3 (Address2_Telephone3) | Text50 | ExternalName: address2_telephone3 ExternalType: String
|
|
67 | Address2_Fax (Address2_Fax) | Text50 | ExternalName: address2_fax ExternalType: String
|
|
68 | CreatedByName (CreatedByName) | Text200 | ExternalName: createdbyname ExternalType: String ExternalAccess: Read
|
FlowField |
69 | ModifiedByName (ModifiedByName) | Text200 | ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read
|
FlowField |
70 | OrganizationIdName (OrganizationIdName) | Text160 | ExternalName: organizationidname ExternalType: String ExternalAccess: Read
|
FlowField |
71 | OverriddenCreatedOn (OverriddenCreatedOn) | Date | ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert
|
|
72 | ImportSequenceNumber (ImportSequenceNumber) | Integer | ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert
|
|
73 | CreatedOnBehalfBy (CreatedOnBehalfBy) | GUID | ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
74 | CreatedOnBehalfByName (CreatedOnBehalfByName) | Text200 | ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
75 | ModifiedOnBehalfBy (ModifiedOnBehalfBy) | GUID | ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
76 | ModifiedOnBehalfByName (ModifiedOnBehalfByName) | Text200 | ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
77 | TransactionCurrencyId (TransactionCurrencyId) | GUID | ExternalName: transactioncurrencyid ExternalType: Lookup
|
|
78 | TransactionCurrencyIdName (TransactionCurrencyIdName) | Text100 | ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read
|
FlowField |
79 | ExchangeRate (ExchangeRate) | Decimal | ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read
|
Keys
# | Fields | ||
---|---|---|---|
0 | BusinessUnitId (BusinessUnitId) | Clustered: Yes | |
1 | Name (Name) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
ParentBusinessUnitId (ParentBusinessUnitId) | CRM Businessunit | BusinessUnitId (BusinessUnitId) |
|
1..n |
OrganizationId (OrganizationId) | CRM Organization | OrganizationId (OrganizationId) |
|
1..n |
ModifiedOnBehalfBy (ModifiedOnBehalfBy) | CRM Systemuser | SystemUserId (SystemUserId) |
|
1..n |
TransactionCurrencyId (TransactionCurrencyId) | CRM Transactioncurrency | TransactionCurrencyId (TransactionCurrencyId) |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
CRM Account | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Businessunit | ParentBusinessUnitId (ParentBusinessUnitId) |
|
1..n |
CRM Contact | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Contract | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Customeraddress | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Incident | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Incidentresolution | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Invoice | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Opportunity | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Post | RegardingObjectOwningBusinessU (RegardingObjectOwningBusinessU) |
|
1..n |
CRM Quote | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Salesorder | OwningBusinessUnit (OwningBusinessUnit) |
|
1..n |
CRM Systemuser | BusinessUnitId (BusinessUnitId) |
|
1..n |
CRM Team | BusinessUnitId (BusinessUnitId) |
|
1..n |