Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback
Fields
# | Name | Type | ||
---|---|---|---|---|
1 | ContractId (ContractId) | GUID | ExternalName: contractid ExternalType: Uniqueidentifier ExternalAccess: Insert
|
|
2 | OwningBusinessUnit (OwningBusinessUnit) | GUID | ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read
|
|
3 | ContractServiceLevelCode (ContractServiceLevelCode) | Option | [Gold,Silver,Bronze] OptionOrdinalValues: [1;2;3] InitValue: Gold ExternalName: contractservicelevelcode ExternalType: Picklist
|
|
4 | ServiceAddress (ServiceAddress) | GUID | ExternalName: serviceaddress ExternalType: Lookup
|
|
5 | BillToAddress (BillToAddress) | GUID | ExternalName: billtoaddress ExternalType: Lookup
|
|
6 | OwningUser (OwningUser) | GUID | ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read
|
|
7 | ContactId (ContactId) | GUID | ExternalName: contactid ExternalType: Lookup ExternalAccess: Read
|
|
8 | AccountId (AccountId) | GUID | ExternalName: accountid ExternalType: Lookup ExternalAccess: Read
|
|
9 | BillingAccountId (BillingAccountId) | GUID | ExternalName: billingaccountid ExternalType: Lookup ExternalAccess: Read
|
|
10 | ContractNumber (ContractNumber) | Text100 | ExternalName: contractnumber ExternalType: String ExternalAccess: Insert
|
|
11 | BillingContactId (BillingContactId) | GUID | ExternalName: billingcontactid ExternalType: Lookup ExternalAccess: Read
|
|
12 | ActiveOn (ActiveOn) | Date | ExternalName: activeon ExternalType: DateTime
|
|
13 | ExpiresOn (ExpiresOn) | Date | ExternalName: expireson ExternalType: DateTime
|
|
14 | CancelOn (CancelOn) | Date | ExternalName: cancelon ExternalType: DateTime ExternalAccess: Read
|
|
15 | Title (Title) | Text100 | ExternalName: title ExternalType: String
|
|
16 | ContractLanguage (ContractLanguage) | BLOB [Memo] | ExternalName: contractlanguage ExternalType: Memo
|
|
17 | BillingStartOn (BillingStartOn) | Date | ExternalName: billingstarton ExternalType: DateTime
|
|
18 | EffectivityCalendar (EffectivityCalendar) | Text168 | ExternalName: effectivitycalendar ExternalType: String
|
|
19 | BillingEndOn (BillingEndOn) | Date | ExternalName: billingendon ExternalType: DateTime
|
|
20 | BillingFrequencyCode (BillingFrequencyCode) | Option | [Monthly,Bimonthly,Quarterly,Semiannually,Annually] OptionOrdinalValues: [1;2;3;4;5] InitValue: Monthly ExternalName: billingfrequencycode ExternalType: Picklist
|
|
21 | CreatedBy (CreatedBy) | GUID | ExternalName: createdby ExternalType: Lookup ExternalAccess: Read
|
|
22 | CreatedOn (CreatedOn) | DateTime | ExternalName: createdon ExternalType: DateTime ExternalAccess: Read
|
|
23 | ModifiedBy (ModifiedBy) | GUID | ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read
|
|
24 | AllotmentTypeCode (AllotmentTypeCode) | Option | [ ,NumberofCases,Time,CoverageDates] OptionOrdinalValues: [-1;1;2;3] InitValue: [ ] ExternalName: allotmenttypecode ExternalType: Picklist
|
|
25 | UseDiscountAsPercentage (UseDiscountAsPercentage) | Boolean | ExternalName: usediscountaspercentage ExternalType: Boolean ExternalAccess: Insert
|
|
26 | ModifiedOn (ModifiedOn) | DateTime | ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read
|
|
27 | TotalPrice (TotalPrice) | Decimal | ExternalName: totalprice ExternalType: Money ExternalAccess: Read
|
|
28 | VersionNumber (VersionNumber) | BigInteger | ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read
|
|
29 | TotalDiscount (TotalDiscount) | Decimal | ExternalName: totaldiscount ExternalType: Money ExternalAccess: Read
|
|
30 | StateCode (StateCode) | Option | [Draft,Invoiced,Active,OnHold,Canceled,Expired] OptionOrdinalValues: [0;1;2;3;4;5] InitValue: Draft ExternalName: statecode ExternalType: State ExternalAccess: Modify
|
|
31 | NetPrice (NetPrice) | Decimal | ExternalName: netprice ExternalType: Money ExternalAccess: Read
|
|
32 | StatusCode (StatusCode) | Option | [ ,Draft,Invoiced,Active,OnHold,Canceled,Expired] OptionOrdinalValues: [-1;1;2;3;4;5;6] InitValue: [ ] ExternalName: statuscode ExternalType: Status
|
|
33 | OriginatingContract (OriginatingContract) | GUID | ExternalName: originatingcontract ExternalType: Lookup ExternalAccess: Insert
|
|
34 | Duration (Duration) | Integer | ExternalName: duration ExternalType: Integer ExternalAccess: Read
|
|
35 | ContactIdName (ContactIdName) | Text160 | ExternalName: contactidname ExternalType: String ExternalAccess: Read
|
FlowField |
36 | AccountIdName (AccountIdName) | Text160 | ExternalName: accountidname ExternalType: String ExternalAccess: Read
|
FlowField |
37 | BillingContactIdName (BillingContactIdName) | Text160 | ExternalName: billingcontactidname ExternalType: String ExternalAccess: Read
|
FlowField |
38 | BillingAccountIdName (BillingAccountIdName) | Text160 | ExternalName: billingaccountidname ExternalType: String ExternalAccess: Read
|
FlowField |
39 | OriginatingContractName (OriginatingContractName) | Text100 | ExternalName: originatingcontractname ExternalType: String ExternalAccess: Read
|
FlowField |
40 | BillToAddressName (BillToAddressName) | Text200 | ExternalName: billtoaddressname ExternalType: String ExternalAccess: Read
|
FlowField |
41 | ServiceAddressName (ServiceAddressName) | Text200 | ExternalName: serviceaddressname ExternalType: String ExternalAccess: Read
|
FlowField |
42 | ContractTemplateAbbreviation (ContractTemplateAbbreviation) | Text20 | ExternalName: contracttemplateabbreviation ExternalType: String ExternalAccess: Read
|
|
43 | CreatedByName (CreatedByName) | Text200 | ExternalName: createdbyname ExternalType: String ExternalAccess: Read
|
FlowField |
44 | ModifiedByName (ModifiedByName) | Text200 | ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read
|
FlowField |
45 | CustomerId (CustomerId) | GUID | ExternalName: customerid ExternalType: Customer
|
|
46 | CustomerIdType (CustomerIdType) | Option | [ ,account,contact] ExternalName: customeridtype ExternalType: EntityName |
|
47 | BillingCustomerId (BillingCustomerId) | GUID | ExternalName: billingcustomerid ExternalType: Customer
|
|
48 | BillingCustomerIdType (BillingCustomerIdType) | Option | [ ,account,contact] ExternalName: billingcustomeridtype ExternalType: EntityName |
|
49 | OwnerId (OwnerId) | GUID | ExternalName: ownerid ExternalType: Owner
|
|
50 | OwnerIdType (OwnerIdType) | Option | [ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName |
|
51 | TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber) | Integer | MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer
|
|
52 | OverriddenCreatedOn (OverriddenCreatedOn) | Date | ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert
|
|
53 | ImportSequenceNumber (ImportSequenceNumber) | Integer | ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert
|
|
54 | UTCConversionTimeZoneCode (UTCConversionTimeZoneCode) | Integer | MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer
|
|
55 | TransactionCurrencyId (TransactionCurrencyId) | GUID | ExternalName: transactioncurrencyid ExternalType: Lookup ExternalAccess: Insert
|
|
56 | ExchangeRate (ExchangeRate) | Decimal | ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read
|
|
57 | TotalDiscount_Base (TotalDiscount_Base) | Decimal | ExternalName: totaldiscount_base ExternalType: Money ExternalAccess: Read
|
|
58 | NetPrice_Base (NetPrice_Base) | Decimal | ExternalName: netprice_base ExternalType: Money ExternalAccess: Read
|
|
59 | TransactionCurrencyIdName (TransactionCurrencyIdName) | Text100 | ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read
|
FlowField |
60 | TotalPrice_Base (TotalPrice_Base) | Decimal | ExternalName: totalprice_base ExternalType: Money ExternalAccess: Read
|
|
61 | CreatedOnBehalfBy (CreatedOnBehalfBy) | GUID | ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
62 | CreatedOnBehalfByName (CreatedOnBehalfByName) | Text200 | ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
63 | ModifiedOnBehalfBy (ModifiedOnBehalfBy) | GUID | ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read
|
|
64 | ModifiedOnBehalfByName (ModifiedOnBehalfByName) | Text200 | ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read
|
FlowField |
65 | OwningTeam (OwningTeam) | GUID | ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read
|
|
66 | EntityImageId (EntityImageId) | GUID | ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read
|
Keys
# | Fields | ||
---|---|---|---|
0 | ContractId (ContractId) | Clustered: Yes | |
1 | Title (Title) |
Table Relations To Other Tables
Field | Related Table | Related Field | ||
---|---|---|---|---|
BillingCustomerId (BillingCustomerId) | CRM Account | AccountId (AccountId) |
|
1..n |
OwningBusinessUnit (OwningBusinessUnit) | CRM Businessunit | BusinessUnitId (BusinessUnitId) |
|
1..n |
BillingCustomerId (BillingCustomerId) | CRM Contact | ContactId (ContactId) |
|
1..n |
OriginatingContract (OriginatingContract) | CRM Contract | ContractId (ContractId) |
|
1..n |
BillToAddress (BillToAddress) | CRM Customeraddress | CustomerAddressId (CustomerAddressId) |
|
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 Contract | OriginatingContract (OriginatingContract) |
|
1..n |
CRM Incident | ContractId (ContractId) |
|
1..n |
CRM Post | RegardingObjectId (RegardingObjectId) |
|
1..n |