Diagrams


Table

CRM Invoice

DynamicsDocs.comCRM Invoice«Table 5355»CRM InvoiceInvoiceId [PK]OpportunityIdPriorityCode; [DefaultValue]SalesOrderIdOwningUserOwningBusinessUnitLastBackofficeSubmitPriceLevelIdAccountIdContactIdInvoiceNumberNameDescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightTotalDiscountAmountCreatedByTotalTaxShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...CreatedOnModifiedByModifiedOnStateCode; [Active,Closed<deprecated>,...StatusCode; [,New,PartiallyShipped,Bil...ShipTo_NameVersionNumber...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5356»CRM InvoicedetailInvoiceDetailId [PK]SalesRepIdIsProductOverriddenLineItemNumberIsCopiedInvoiceIdQuantityBackorderedUoMIdProductIdActualDeliveryOnQuantityManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountQuantityCancelledShippingTrackingNumberExtendedAmountDescriptionIsPriceOverriddenShipTo_NamePricingErrorCode; [None,DetailError,Mi...TaxCreatedOnShipTo_Line1CreatedByModifiedByShipTo_Line2ShipTo_Line3ModifiedOn...«Table 5343»CRM OpportunityOpportunityId [PK]PriceLevelIdOpportunityRatingCode; [Hot,Warm,Cold]PriorityCode; [DefaultValue]ContactIdAccountIdNameStepIdDescriptionEstimatedValueStepNameSalesStageCode; [DefaultValue]ParticipatesInWorkflowPricingErrorCode; [None,DetailError,Mi...EstimatedCloseDateCloseProbabilityActualValueActualCloseDateOwningUserOwningBusinessUnitCreatedOnCreatedByModifiedOnModifiedByVersionNumberStateCode; [Open,Won,Lost]StatusCode; [,InProgress,OnHold,Won,Ca...IsRevenueSystemCalculatedContactIdNameAccountIdNamePriceLevelIdName...«Table 5353»CRM SalesorderSalesOrderId [PK]OpportunityIdQuoteIdPriorityCode; [DefaultValue]SubmitStatusOwningUserSubmitDateOwningBusinessUnitSubmitStatusDescriptionPriceLevelIdLastBackofficeSubmitAccountIdContactIdOrderNumberNamePricingErrorCode; [None,DetailError,Mi...DescriptionDiscountAmountFreightAmountTotalAmountTotalLineItemAmountTotalLineItemDiscountAmountTotalAmountLessFreightTotalDiscountAmountRequestDeliveryByTotalTaxShippingMethodCode; [,Airborne,DHL,Fed...PaymentTermsCode; [,Net30,2%10Net30,Ne...FreightTermsCode; [,FOB,NoCharge]CreatedByCreatedOn...«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«Table 5364»CRM BusinessunitBusinessUnitId [PK]OrganizationIdNameDescriptionDivisionNameFileAsNameTickerSymbolStockExchangeUTCOffsetCreatedOnModifiedOnCreditLimitCostCenterWebSiteUrlFtpSiteUrlEMailAddressInheritanceMaskCreatedByModifiedByWorkflowSuspendedParentBusinessUnitIdIsDisabledDisabledReasonVersionNumberParentBusinessUnitIdNameAddress1_AddressIdAddress1_AddressTypeCode; [DefaultValu...Address1_NameAddress1_Line1Address1_Line2Address1_Line3...«Table 5346»CRM PricelevelPriceLevelId [PK]OrganizationIdNameDescriptionShippingMethodCode; [DefaultValue]BeginDatePaymentMethodCode; [DefaultValue]FreightTermsCode; [DefaultValue]EndDateCreatedByCreatedOnModifiedByModifiedOnStateCode; [Active,Inactive]VersionNumberStatusCode; [,Active,Inactive]CreatedByNameModifiedByNameOrganizationIdNameImportSequenceNumberTransactionCurrencyIdOverriddenCreatedOnTimeZoneRuleVersionNumberUTCConversionTimeZoneCodeTransactionCurrencyIdNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameExchangeRate«Table 5341»CRM AccountAccountId [PK]AccountCategoryCode; [,PreferredCustom...DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...CustomerTypeCode; [,Competitor,Consult...AccountRatingCode; [DefaultValue]IndustryCode; [,Accounting,Agriculture...TerritoryCode; [DefaultValue]AccountClassificationCode; [DefaultVal...BusinessTypeCode; [DefaultValue]OwningBusinessUnitTraversedPathOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]PrimaryContactIdParticipatesInWorkflowNameAccountNumberRevenueNumberOfEmployeesDescriptionSICOwnershipCode; [,Public,Private,Subsid...MarketCapSharesOutstandingTickerSymbolStockExchangeWebSiteURLFtpSiteURL...«Table 5342»CRM ContactContactId [PK]DefaultPriceLevelIdCustomerSizeCode; [DefaultValue]CustomerTypeCode; [DefaultValue]PreferredContactMethodCode; [Any,Email...LeadSourceCode; [DefaultValue]OwningBusinessUnitOwningUserPaymentTermsCode; [,Net30,2%10Net30,Ne...ShippingMethodCode; [DefaultValue]AccountIdParticipatesInWorkflowIsBackofficeCustomerSalutationJobTitleFirstNameDepartmentNickNameMiddleNameLastNameSuffixYomiFirstNameFullNameYomiMiddleNameYomiLastNameAnniversaryBirthDateGovernmentIdYomiFullNameDescriptionEmployeeId...«Table 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId<OpportunityId><SalesOrderId><OwningBusinessUnit><PriceLevelId><AccountId><CustomerId><ContactId><CustomerId><OwnerId><OwningTeam><TransactionCurrencyId><RegardingObjectId><InvoiceId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectOwningBusinessU><SalesRepId><TransactionCurrencyId><OwnerId><PriceLevelId><ContactId><CustomerId><ParentContactId><AccountId><CustomerId><ParentAccountId><OwningBusinessUnit><OwnerId><OwningTeam><RegardingObjectId><TransactionCurrencyId><OpportunityId><OwningBusinessUnit><PriceLevelId><AccountId><CustomerId><ContactId><CustomerId><OwnerId><OwningTeam><TransactionCurrencyId><BusinessUnitId><TransactionCurrencyId><AdministratorId><ParentBusinessUnitId><TransactionCurrencyId><OwningBusinessUnit><OwningBusinessUnit><BusinessUnitId><TransactionCurrencyId><DefaultPriceLevelId><DefaultPriceLevelId><PrimaryContactId><AccountId><ParentCustomerId><ParentAccountId><MasterId><OwnerId><OwningTeam><TransactionCurrencyId><ParentContactId><MasterId><ParentCustomerId><OwnerId><OwningTeam><TransactionCurrencyId><TransactionCurrencyId>

Drag with mouse | Use controls on the right | Click on tables | Write to me with ideas and feedback

Fields

# Name Type
1 InvoiceId GUID
2 OpportunityId GUID
3 PriorityCode Option
4 SalesOrderId GUID
5 OwningUser GUID
6 OwningBusinessUnit GUID
7 LastBackofficeSubmit Date
8 PriceLevelId GUID
9 AccountId GUID
10 ContactId GUID
11 InvoiceNumber Text100
12 Name Text250
13 Description BLOB [Memo]
14 DiscountAmount Decimal
15 FreightAmount Decimal
16 TotalAmount Decimal
17 TotalLineItemAmount Decimal
18 TotalLineItemDiscountAmount Decimal
19 TotalAmountLessFreight Decimal
20 TotalDiscountAmount Decimal
21 CreatedBy GUID
22 TotalTax Decimal
23 ShippingMethodCode Option
24 PaymentTermsCode Option
25 CreatedOn DateTime
26 ModifiedBy GUID
27 ModifiedOn DateTime
28 StateCode Option
29 StatusCode Option
30 ShipTo_Name Text200
31 VersionNumber BigInteger
32 PricingErrorCode Option
33 ShipTo_Line1 Text250
34 ShipTo_Line2 Text250
35 ShipTo_Line3 Text250
36 ShipTo_City Text80
37 ShipTo_StateOrProvince Text50
38 ShipTo_Country Text80
39 ShipTo_PostalCode Text20
40 WillCall Boolean
41 ShipTo_Telephone Text50
42 BillTo_Name Text200
43 ShipTo_FreightTermsCode Option
44 ShipTo_Fax Text50
45 BillTo_Line1 Text250
46 BillTo_Line2 Text250
47 BillTo_Line3 Text250
48 BillTo_City Text80
49 BillTo_StateOrProvince Text50
50 BillTo_Country Text80
51 BillTo_PostalCode Text20
52 BillTo_Telephone Text50
53 BillTo_Fax Text50
54 DiscountPercentage Decimal
55 ContactIdName Text160 FlowField
56 AccountIdName Text160 FlowField
57 OpportunityIdName Text250 FlowField
58 SalesOrderIdName Text250 FlowField
59 PriceLevelIdName Text100 FlowField
60 CreatedByName Text200 FlowField
61 ModifiedByName Text200 FlowField
62 CustomerId GUID
63 CustomerIdType Option
64 OwnerId GUID
65 OwnerIdType Option
66 IsPriceLocked Boolean
67 DateDelivered Date
68 DueDate Date
69 TimeZoneRuleVersionNumber Integer
70 ImportSequenceNumber Integer
71 OverriddenCreatedOn Date
72 ExchangeRate Decimal
73 UTCConversionTimeZoneCode Integer
74 TransactionCurrencyId GUID
75 TransactionCurrencyIdName Text100 FlowField
76 TotalLineItemAmount_Base Decimal
77 TotalLineItemDiscountAmount_Ba Decimal
78 TotalTax_Base Decimal
79 TotalAmountLessFreight_Base Decimal
80 DiscountAmount_Base Decimal
81 TotalAmount_Base Decimal
82 FreightAmount_Base Decimal
83 TotalDiscountAmount_Base Decimal
84 CreatedOnBehalfBy GUID
85 CreatedOnBehalfByName Text200 FlowField
86 ModifiedOnBehalfBy GUID
87 ModifiedOnBehalfByName Text200 FlowField
88 OwningTeam GUID
89 BillTo_Composite BLOB [Memo]
90 ShipTo_Composite BLOB [Memo]
91 ProcessId GUID
92 StageId GUID
93 EntityImageId GUID
94 TraversedPath Text250

Keys

# Fields
0 InvoiceId Clustered: Yes
1 Name

Table Relations To Other Tables

Field Related Table Related Field
CustomerId CRM Account AccountId 1..n
OwningBusinessUnit CRM Businessunit BusinessUnitId 1..n
CustomerId CRM Contact ContactId 1..n
OpportunityId CRM Opportunity OpportunityId 1..n
PriceLevelId CRM Pricelevel PriceLevelId 1..n
SalesOrderId CRM Salesorder SalesOrderId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
OwningTeam CRM Team TeamId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n

Table Relations From Other Tables

From Table From Field
CRM Invoicedetail InvoiceId 1..n
CRM Post RegardingObjectId 1..n