Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | ParentId | GUID | ExternalName: parentid ExternalType: Lookup
|
|
2 | CustomerAddressId | GUID | ExternalName: customeraddressid ExternalType: Uniqueidentifier ExternalAccess: Insert
|
|
3 | AddressNumber | Integer | MaxValue: 1000000000 ExternalName: addressnumber ExternalType: Integer
|
|
4 | AddressTypeCode | Option | [ ,BillTo,ShipTo,Primary,Other] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: addresstypecode ExternalType: Picklist
|
|
5 | Name | Text200 | ExternalName: name ExternalType: String
|
|
6 | PrimaryContactName | Text150 | ExternalName: primarycontactname ExternalType: String
|
|
7 | Line1 | Text250 | ExternalName: line1 ExternalType: String
|
|
8 | Line2 | Text250 | ExternalName: line2 ExternalType: String
|
|
9 | Line3 | Text250 | ExternalName: line3 ExternalType: String
|
|
10 | City | Text80 | ExternalName: city ExternalType: String
|
|
11 | StateOrProvince | Text50 | ExternalName: stateorprovince ExternalType: String
|
|
12 | County | Text50 | ExternalName: county ExternalType: String
|
|
13 | Country | Text80 | ExternalName: country ExternalType: String
|
|
14 | PostOfficeBox | Text20 | ExternalName: postofficebox ExternalType: String
|
|
15 | PostalCode | Text20 | ExternalName: postalcode ExternalType: String
|
|
16 | UTCOffset | Integer | MinValue: -1500 MaxValue: 1500 ExternalName: utcoffset ExternalType: Integer
|
|
17 | FreightTermsCode | Option | [ ,FOB,NoCharge] OptionOrdinalValues: [-1;1;2] InitValue: [ ] ExternalName: freighttermscode ExternalType: Picklist
|
|
18 | UPSZone | Text4 | ExternalName: upszone ExternalType: String
|
|
19 | Latitude | Decimal | ExternalName: latitude ExternalType: Double
|
|
20 | Telephone1 | Text50 | ExternalName: telephone1 ExternalType: String
|
|
21 | Longitude | Decimal | ExternalName: longitude ExternalType: Double
|
|
22 | ShippingMethodCode | Option | [ ,Airborne,DHL,FedEx,UPS,PostalMail,FullLoad,WillCall] OptionOrdinalValues: [-1;1;2;3;4;5;6;7] InitValue: [ ] ExternalName: shippingmethodcode ExternalType: Picklist
|
|
23 | Telephone2 | Text50 | ExternalName: telephone2 ExternalType: String
|
|
24 | Telephone3 | Text50 | ExternalName: telephone3 ExternalType: String
|
|
25 | Fax | Text50 | ExternalName: fax ExternalType: String
|
|
26 | VersionNumber | BigInteger | ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read
|
|
27 | CreatedBy | GUID | ExternalName: createdby ExternalType: Lookup ExternalAccess: Read
|
|
28 | CreatedOn | DateTime | ExternalName: createdon ExternalType: DateTime ExternalAccess: Read
|
|
29 | ModifiedBy | GUID | ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read
|
|
30 | ModifiedOn | DateTime | ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read
|
|
31 | CreatedByName | Text200 | ExternalName: createdbyname ExternalType: String ExternalAccess: Read
|
FlowField |
32 | ModifiedByName | Text200 | ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read
|
FlowField |
33 | OwningBusinessUnit | GUID | ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read
|
|
34 | OwningUser | GUID | ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read
|
|
35 | TimeZoneRuleVersionNumber | Integer | MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer
|
|
36 | OverriddenCreatedOn | Date | ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert
|
|
37 | UTCConversionTimeZoneCode | Integer | MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer
|
|
38 | ImportSequenceNumber | Integer | ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert
|
|
39 | OwnerIdType | Option | [ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName ExternalAccess: Read |
|
40 | OwnerId | GUID | ExternalName: ownerid ExternalType: Owner ExternalAccess: Read
|
|
41 | ParentIdTypeCode | Option | [ ,account,contact] ExternalName: parentidtypecode ExternalType: EntityName |
|
42 | CreatedOnBehalfBy | GUID | ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
43 | CreatedOnBehalfByName | Text200 | ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
44 | ModifiedOnBehalfBy | GUID | ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
45 | ModifiedOnBehalfByName | Text200 | ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
46 | TransactionCurrencyId | GUID | ExternalName: transactioncurrencyid ExternalType: Lookup
|
|
47 | TransactionCurrencyIdName | Text100 | ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read
|
FlowField |
48 | ExchangeRate | Decimal | ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read
|
|
49 | Composite | BLOB [Memo] | ExternalName: composite ExternalType: Memo ExternalAccess: Read
|
Keys
# | Fields | ||
---|---|---|---|
0 | CustomerAddressId | Clustered: Yes | |
1 | Name |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
ParentId | CRM Account | AccountId |
|
1..n |
OwningBusinessUnit | CRM Businessunit | BusinessUnitId |
|
1..n |
ParentId | CRM Contact | ContactId |
|
1..n |
ModifiedOnBehalfBy | CRM Systemuser | SystemUserId |
|
1..n |
OwnerId | CRM Team | TeamId |
|
1..n |
TransactionCurrencyId | CRM Transactioncurrency | TransactionCurrencyId |
|
1..n |
Table Relations From Other Tables
From Table | From Field | ||
---|---|---|---|
CRM Contract | BillToAddress |
|
1..n |
CRM Post | RegardingObjectId |
|
1..n |