Diagrams


Table

CRM Invoicedetail

DynamicsDocs.comCRM Invoicedetail«Table 5356»CRM InvoicedetailInvoiceDetailId [PK]SalesRepIdIsProductOverriddenLineItemNumberIsCopiedInvoiceIdQuantityBackorderedUoMIdProductIdActualDeliveryOnQuantityManualDiscountAmountProductDescriptionVolumeDiscountAmountPricePerUnitBaseAmountQuantityCancelledShippingTrackingNumberExtendedAmountDescriptionIsPriceOverriddenShipTo_NamePricingErrorCode; [None,DetailError,Mi...TaxCreatedOnShipTo_Line1CreatedByModifiedByShipTo_Line2ShipTo_Line3ModifiedOn...«Table 5344»CRM PostCreatedByCreatedByNameCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameOrganizationIdOrganizationIdNamePostId [PK]RegardingObjectIdRegardingObjectTypeCode; [,systemuser,...Source; [AutoPost,ManualPost]TextTimeZoneRuleVersionNumberType; [Check-in,Idea,News,PrivateMessa...UTCConversionTimeZoneCodeRegardingObjectOwnerIdRegardingObjectOwnerIdType; [,systemus...RegardingObjectOwningBusinessUModifiedByModifiedByNameModifiedOnBehalfByModifiedOnBehalfByNameModifiedOn«Table 5340»CRM SystemuserSystemUserId [PK]OrganizationIdBusinessUnitIdParentSystemUserIdFirstNameSalutationMiddleNameLastNamePersonalEMailAddressFullNameNickNameTitleInternalEMailAddressJobTitleMobileAlertEMailPreferredEmailCode; [DefaultValue]HomePhoneMobilePhonePreferredPhoneCode; [MainPhone,OtherPh...PreferredAddressCode; [MailingAddress,...PhotoUrlDomainNamePassportLoCreatedOnPassportHiDisabledReasonModifiedOnCreatedByEmployeeIdModifiedByIsDisabled...«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 5361»CRM UomUoMId [PK]BaseUoMNameUoMScheduleIdQuantityCreatedOnCreatedByModifiedByModifiedOnIsScheduleBaseUoMBaseUoMNameCreatedByNameModifiedByNameVersionNumberOrganizationIdImportSequenceNumberOverriddenCreatedOnCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByName«Table 5348»CRM ProductProductId [PK]DefaultUoMScheduleIdOrganizationIdNameDefaultUoMIdPriceLevelIdDescriptionProductTypeCode; [SalesInventory,Misce...ProductUrlPriceIsKitProductNumberSizeCurrentCostStockVolumeStandardCostStockWeightQuantityDecimalQuantityOnHandIsStockItemSupplierNameVendorNameVendorPartNumberCreatedOnModifiedOnCreatedByStateCode; [Active,Retired,Draft,Under...ModifiedByStatusCode; [,Active,Retired,Draft,Und...VersionNumberDefaultUoMIdName...«Table 5345»CRM TransactioncurrencyStatusCode; [,Active,Inactive]ModifiedOnStateCode; [Active,Inactive]VersionNumberModifiedByImportSequenceNumberOverriddenCreatedOnCreatedOnTransactionCurrencyId [PK]ExchangeRateCurrencySymbolCurrencyNameCreatedByISOCurrencyCodeOrganizationIdModifiedByNameCreatedByNameCurrencyPrecisionCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameEntityImageId«Table 5359»CRM TeamTeamId [PK]OrganizationIdBusinessUnitIdNameDescriptionEMailAddressCreatedOnModifiedOnCreatedByModifiedByVersionNumberCreatedByNameModifiedByNameBusinessUnitIdNameImportSequenceNumberOverriddenCreatedOnAdministratorIdIsDefaultAdministratorIdNameYomiNameCreatedOnBehalfByCreatedOnBehalfByNameModifiedOnBehalfByModifiedOnBehalfByNameTraversedPathTransactionCurrencyIdTransactionCurrencyIdNameExchangeRateTeamType; [Owner,Access]RegardingObjectIdSystemManaged...<SalesRepId><InvoiceId><UoMId><ProductId><TransactionCurrencyId><OwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectId><RegardingObjectOwnerId><RegardingObjectId><TransactionCurrencyId><AdministratorId><OwnerId><OwningTeam><TransactionCurrencyId><BaseUoM><DefaultUoMId><TransactionCurrencyId><ParentProductId><TransactionCurrencyId>

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

Fields

# Name Type
1 InvoiceDetailId GUID
2 SalesRepId GUID
3 IsProductOverridden Boolean
4 LineItemNumber Integer
5 IsCopied Boolean
6 InvoiceId GUID
7 QuantityBackordered Decimal
8 UoMId GUID
9 ProductId GUID
10 ActualDeliveryOn Date
11 Quantity Decimal
12 ManualDiscountAmount Decimal
13 ProductDescription Text250
14 VolumeDiscountAmount Decimal
15 PricePerUnit Decimal
16 BaseAmount Decimal
17 QuantityCancelled Decimal
18 ShippingTrackingNumber Text100
19 ExtendedAmount Decimal
20 Description BLOB [Memo]
21 IsPriceOverridden Boolean
22 ShipTo_Name Text200
23 PricingErrorCode Option
24 Tax Decimal
25 CreatedOn DateTime
26 ShipTo_Line1 Text250
27 CreatedBy GUID
28 ModifiedBy GUID
29 ShipTo_Line2 Text250
30 ShipTo_Line3 Text250
31 ModifiedOn DateTime
32 ShipTo_City Text80
33 ShipTo_StateOrProvince Text50
34 ShipTo_Country Text80
35 ShipTo_PostalCode Text20
36 WillCall Boolean
37 ShipTo_Telephone Text50
38 ShipTo_Fax Text50
39 ShipTo_FreightTermsCode Option
40 QuantityShipped Decimal
41 ProductIdName Text100 FlowField
42 UoMIdName Text100 FlowField
43 SalesRepIdName Text200 FlowField
44 InvoiceStateCode Option
45 CreatedByName Text200 FlowField
46 ModifiedByName Text200 FlowField
47 VersionNumber BigInteger
48 OwningUser GUID
49 InvoiceIsPriceLocked Boolean
50 OwningBusinessUnit GUID
51 ExchangeRate Decimal
52 TransactionCurrencyId GUID
53 UTCConversionTimeZoneCode Integer
54 TimeZoneRuleVersionNumber Integer
55 ImportSequenceNumber Integer
56 OverriddenCreatedOn Date
57 VolumeDiscountAmount_Base Decimal
58 BaseAmount_Base Decimal
59 PricePerUnit_Base Decimal
60 TransactionCurrencyIdName Text100 FlowField
61 Tax_Base Decimal
62 ExtendedAmount_Base Decimal
63 ManualDiscountAmount_Base Decimal
64 OwnerId GUID
65 OwnerIdType Option
66 CreatedOnBehalfBy GUID
67 CreatedOnBehalfByName Text200 FlowField
68 ModifiedOnBehalfBy GUID
69 ModifiedOnBehalfByName Text200 FlowField
70 SequenceNumber Integer
71 ParentBundleId GUID
72 ProductTypeCode Option
73 PropertyConfigurationStatus Option
74 ProductAssociationId GUID

Keys

# Fields
0 InvoiceDetailId Clustered: Yes

Table Relations To Other Tables

Field Related Table Related Field
InvoiceId CRM Invoice InvoiceId 1..n
ProductId CRM Product ProductId 1..n
ModifiedOnBehalfBy CRM Systemuser SystemUserId 1..n
OwnerId CRM Team TeamId 1..n
TransactionCurrencyId CRM Transactioncurrency TransactionCurrencyId 1..n
UoMId CRM Uom UoMId 1..n

Table Relations From Other Tables

From Table From Field
CRM Post RegardingObjectId 1..n