CRM Invoice

Table

CRM Invoice

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

Fields

#	Name	Type
1	InvoiceId (InvoiceId)	GUID	ExternalName: invoiceid ExternalType: Uniqueidentifier ExternalAccess: Insert Description: Unique identifier of the invoice.
2	OpportunityId (OpportunityId)	GUID	ExternalName: opportunityid ExternalType: Lookup Description: Choose the opportunity that the invoice is related to for reporting and analytics. TableRelation: "CRM Opportunity".OpportunityId
3	PriorityCode (PriorityCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: prioritycode ExternalType: Picklist Description: Select the priority so that preferred customers or critical issues are handled quickly.
4	SalesOrderId (SalesOrderId)	GUID	ExternalName: salesorderid ExternalType: Lookup Description: Choose the order related to the invoice to make sure the order is fulfilled and invoiced correctly. TableRelation: "CRM Salesorder".SalesOrderId
5	OwningUser (OwningUser)	GUID	ExternalName: owninguser ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the user who owns the invoice. TableRelation: "CRM Systemuser".SystemUserId
6	OwningBusinessUnit (OwningBusinessUnit)	GUID	ExternalName: owningbusinessunit ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the business unit that owns the invoice. TableRelation: "CRM Businessunit".BusinessUnitId
7	LastBackofficeSubmit (LastBackofficeSubmit)	Date	ExternalName: lastbackofficesubmit ExternalType: DateTime Description: Enter the date and time when the invoice was last submitted to an accounting or ERP system for processing.
8	PriceLevelId (PriceLevelId)	GUID	ExternalName: pricelevelid ExternalType: Lookup Description: Choose the price list associated with this record to make sure the products associated with the campaign are offered at the correct prices. TableRelation: "CRM Pricelevel".PriceLevelId
9	AccountId (AccountId)	GUID	ExternalName: accountid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the account with which the invoice is associated. TableRelation: "CRM Account".AccountId
10	ContactId (ContactId)	GUID	ExternalName: contactid ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the contact associated with the invoice. TableRelation: "CRM Contact".ContactId
11	InvoiceNumber (InvoiceNumber)	Text100	ExternalName: invoicenumber ExternalType: String ExternalAccess: Insert Description: Shows the identifying number or code of the invoice.
12	Name (Name)	Text250	ExternalName: name ExternalType: String Description: Type a descriptive name for the invoice.
13	Description (Description)	BLOB [Memo]	ExternalName: description ExternalType: Memo Description: Type additional information to describe the invoice, such as shipping details or product substitutions.
14	DiscountAmount (DiscountAmount)	Decimal	ExternalName: discountamount ExternalType: Money Description: Type the discount amount for the invoice if the customer is eligible for special savings.
15	FreightAmount (FreightAmount)	Decimal	ExternalName: freightamount ExternalType: Money Description: Type the cost of freight or shipping for the products included in the invoice for use in calculating the total amount due.
16	TotalAmount (TotalAmount)	Decimal	ExternalName: totalamount ExternalType: Money ExternalAccess: Modify Description: Shows the total amount due, calculated as the sum of the products, discount, freight, and taxes for the invoice.
17	TotalLineItemAmount (TotalLineItemAmount)	Decimal	ExternalName: totallineitemamount ExternalType: Money ExternalAccess: Modify Description: Shows the sum of all existing and write-in products included on the invoice, based on the specified price list and quantities.
18	TotalLineItemDiscountAmount (TotalLineItemDiscountAmount)	Decimal	ExternalName: totallineitemdiscountamount ExternalType: Money ExternalAccess: Modify Description: Shows the Manual Discount amounts specified on all products included in the invoice. This value is reflected in the Detail Amount field on the invoice and is added to any discount amount or rate specified on the invoice.
19	TotalAmountLessFreight (TotalAmountLessFreight)	Decimal	ExternalName: totalamountlessfreight ExternalType: Money ExternalAccess: Modify Description: Shows the total product amount due, minus any discounts. This value is added to freight and tax amounts in the calculation for the total amount due for the invoice.
20	TotalDiscountAmount (TotalDiscountAmount)	Decimal	ExternalName: totaldiscountamount ExternalType: Money ExternalAccess: Modify Description: Shows the total discount amount, based on the discount price and rate entered on the invoice.
21	CreatedBy (CreatedBy)	GUID	ExternalName: createdby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record. TableRelation: "CRM Systemuser".SystemUserId
22	TotalTax (TotalTax)	Decimal	ExternalName: totaltax ExternalType: Money ExternalAccess: Modify Description: Shows the total of the Tax amounts specified on all products included in the invoice, included in the Total Amount due calculation for the invoice.
23	ShippingMethodCode (ShippingMethodCode)	Option	[ ,Airborne,DHL,FedEx,UPS,PostalMail,FullLoad,WillCall] OptionOrdinalValues: [-1;1;2;3;4;5;6;7] InitValue: [ ] ExternalName: shippingmethodcode ExternalType: Picklist Description: Select a shipping method for deliveries sent to this address.
24	PaymentTermsCode (PaymentTermsCode)	Option	[ ,Net30,2%10Net30,Net45,Net60] OptionOrdinalValues: [-1;1;2;3;4] InitValue: [ ] ExternalName: paymenttermscode ExternalType: Picklist Description: Select the payment terms to indicate when the customer needs to pay the total amount.
25	CreatedOn (CreatedOn)	DateTime	ExternalName: createdon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was created. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
26	ModifiedBy (ModifiedBy)	GUID	ExternalName: modifiedby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record. TableRelation: "CRM Systemuser".SystemUserId
27	ModifiedOn (ModifiedOn)	DateTime	ExternalName: modifiedon ExternalType: DateTime ExternalAccess: Read Description: Shows the date and time when the record was last updated. The date and time are displayed in the time zone selected in Microsoft Dynamics CRM options.
28	StateCode (StateCode)	Option	[Active,Closed(deprecated),Paid,Canceled] OptionOrdinalValues: [0;1;2;3] InitValue: Active ExternalName: statecode ExternalType: State ExternalAccess: Modify Description: Shows whether the invoice is active, paid, or canceled. Paid and canceled invoices are read-only and can't be edited unless they are reactivated.
29	StatusCode (StatusCode)	Option	[ ,New,PartiallyShipped,Billed,Booked(appliestoservices),Installed(appliestoservices),Canceled(deprecated),PaidinFull(deprecated),Complete,Partial,Canceled] OptionOrdinalValues: [-1;1;2;4;5;6;3;7;100001;100002;100003] InitValue: [ ] ExternalName: statuscode ExternalType: Status Description: Select the invoice's status.
30	ShipTo_Name (ShipTo_Name)	Text200	ExternalName: shipto_name ExternalType: String Description: Type a name for the customer's shipping address, such as "Headquarters" or "Field office", to identify the address.
31	VersionNumber (VersionNumber)	BigInteger	ExternalName: versionnumber ExternalType: BigInt ExternalAccess: Read Description: Version number of the invoice.
32	PricingErrorCode (PricingErrorCode)	Option	[None,DetailError,MissingPriceLevel,InactivePriceLevel,MissingQuantity,MissingUnitPrice,MissingProduct,InvalidProduct,MissingPricingCode,InvalidPricingCode,MissingUOM,ProductNotInPriceLevel,MissingPriceLevelAmount,MissingPriceLevelPercentage,MissingPrice,MissingCurrentCost,MissingStandardCost,InvalidPriceLevelAmount,InvalidPriceLevelPercentage,InvalidPrice,InvalidCurrentCost,InvalidStandardCost,InvalidRoundingPolicy,InvalidRoundingOption,InvalidRoundingAmount,PriceCalculationError,InvalidDiscountType,DiscountTypeInvalidState,InvalidDiscount,InvalidQuantity,InvalidPricingPrecision,MissingProductDefaultUOM,MissingProductUOMSchedule,InactiveDiscountType,InvalidPriceLevelCurrency,PriceAttributeOutOfRange,BaseCurrencyAttributeOverflow,BaseCurrencyAttributeUnderflow] OptionOrdinalValues: [0;1;2;3;4;5;6;7;8;9;10;11;12;13;14;15;16;17;18;19;20;21;22;23;24;25;26;27;28;29;30;31;32;33;34;35;36;37] InitValue: None ExternalName: pricingerrorcode ExternalType: Picklist Description: Type of pricing error for the invoice.
33	ShipTo_Line1 (ShipTo_Line1)	Text250	ExternalName: shipto_line1 ExternalType: String Description: Type the first line of the customer's shipping address.
34	ShipTo_Line2 (ShipTo_Line2)	Text250	ExternalName: shipto_line2 ExternalType: String Description: Type the second line of the customer's shipping address.
35	ShipTo_Line3 (ShipTo_Line3)	Text250	ExternalName: shipto_line3 ExternalType: String Description: Type the third line of the shipping address.
36	ShipTo_City (ShipTo_City)	Text80	ExternalName: shipto_city ExternalType: String Description: Type the city for the customer's shipping address.
37	ShipTo_StateOrProvince (ShipTo_StateOrProvince)	Text50	ExternalName: shipto_stateorprovince ExternalType: String Description: Type the state or province for the shipping address.
38	ShipTo_Country (ShipTo_Country)	Text80	ExternalName: shipto_country ExternalType: String Description: Type the country or region for the customer's shipping address.
39	ShipTo_PostalCode (ShipTo_PostalCode)	Text20	ExternalName: shipto_postalcode ExternalType: String Description: Type the ZIP Code or postal code for the shipping address.
40	WillCall (WillCall)	Boolean	ExternalName: willcall ExternalType: Boolean Description: Select whether the products included in the invoice should be shipped to the specified address or held until the customer calls with further pick up or delivery instructions.
41	ShipTo_Telephone (ShipTo_Telephone)	Text50	ExternalName: shipto_telephone ExternalType: String Description: Type the phone number for the customer's shipping address.
42	BillTo_Name (BillTo_Name)	Text200	ExternalName: billto_name ExternalType: String Description: Type a name for the customer's billing address, such as "Headquarters" or "Field office", to identify the address.
43	ShipTo_FreightTermsCode (ShipTo_FreightTermsCode)	Option	DefaultValue OptionOrdinalValues: 1 InitValue: DefaultValue ExternalName: shipto_freighttermscode ExternalType: Picklist Description: Select the freight terms to make sure shipping orders are processed correctly.
44	ShipTo_Fax (ShipTo_Fax)	Text50	ExternalName: shipto_fax ExternalType: String Description: Type the fax number for the customer's shipping address.
45	BillTo_Line1 (BillTo_Line1)	Text250	ExternalName: billto_line1 ExternalType: String Description: Type the first line of the customer's billing address.
46	BillTo_Line2 (BillTo_Line2)	Text250	ExternalName: billto_line2 ExternalType: String Description: Type the second line of the customer's billing address.
47	BillTo_Line3 (BillTo_Line3)	Text250	ExternalName: billto_line3 ExternalType: String Description: Type the third line of the billing address.
48	BillTo_City (BillTo_City)	Text80	ExternalName: billto_city ExternalType: String Description: Type the city for the customer's billing address.
49	BillTo_StateOrProvince (BillTo_StateOrProvince)	Text50	ExternalName: billto_stateorprovince ExternalType: String Description: Type the state or province for the billing address.
50	BillTo_Country (BillTo_Country)	Text80	ExternalName: billto_country ExternalType: String Description: Type the country or region for the customer's billing address.
51	BillTo_PostalCode (BillTo_PostalCode)	Text20	ExternalName: billto_postalcode ExternalType: String Description: Type the ZIP Code or postal code for the billing address.
52	BillTo_Telephone (BillTo_Telephone)	Text50	ExternalName: billto_telephone ExternalType: String Description: Type the phone number for the customer's billing address.
53	BillTo_Fax (BillTo_Fax)	Text50	ExternalName: billto_fax ExternalType: String Description: Type the fax number for the customer's billing address.
54	DiscountPercentage (DiscountPercentage)	Decimal	ExternalName: discountpercentage ExternalType: Decimal Description: Type the discount rate that should be applied to the Detail Amount field, for use in calculating the Pre-Freight Amount and Total Amount values for the invoice.
55	ContactIdName (ContactIdName)	Text160	ExternalName: contactidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Contact".FullName WHERE (ContactId=FIELD(ContactId)))	FlowField
56	AccountIdName (AccountIdName)	Text160	ExternalName: accountidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Account".Name WHERE (AccountId=FIELD(AccountId)))	FlowField
57	OpportunityIdName (OpportunityIdName)	Text250	ExternalName: opportunityidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Opportunity".Name WHERE (OpportunityId=FIELD(OpportunityId)))	FlowField
58	SalesOrderIdName (SalesOrderIdName)	Text250	ExternalName: salesorderidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Salesorder".Name WHERE (SalesOrderId=FIELD(SalesOrderId)))	FlowField
59	PriceLevelIdName (PriceLevelIdName)	Text100	ExternalName: pricelevelidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Pricelevel".Name WHERE (PriceLevelId=FIELD(PriceLevelId)))	FlowField
60	CreatedByName (CreatedByName)	Text200	ExternalName: createdbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedBy)))	FlowField
61	ModifiedByName (ModifiedByName)	Text200	ExternalName: modifiedbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedBy)))	FlowField
62	CustomerId (CustomerId)	GUID	ExternalName: customerid ExternalType: Customer Description: Select the customer account or contact to provide a quick link to additional customer details, such as account information, activities, and opportunities. TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;
63	CustomerIdType (CustomerIdType)	Option	[ ,account,contact] ExternalName: customeridtype ExternalType: EntityName
64	OwnerId (OwnerId)	GUID	ExternalName: ownerid ExternalType: Owner Description: Enter the user or team who is assigned to manage the record. This field is updated every time the record is assigned to a different user. TableRelation: IF (OwnerIdType=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (OwnerIdType=CONST(team)) "CRM Team".TeamId;
65	OwnerIdType (OwnerIdType)	Option	[ ,systemuser,team] ExternalName: owneridtype ExternalType: EntityName
66	IsPriceLocked (IsPriceLocked)	Boolean	ExternalName: ispricelocked ExternalType: Boolean ExternalAccess: Modify Description: Select whether prices specified on the invoice are locked from any further updates.
67	DateDelivered (DateDelivered)	Date	ExternalName: datedelivered ExternalType: DateTime Description: Enter the date when the products included in the invoice were delivered.
68	DueDate (DueDate)	Date	ExternalName: duedate ExternalType: DateTime Description: Enter the date by which the invoice should be paid by the customer.
69	TimeZoneRuleVersionNumber (TimeZoneRuleVersionNumber)	Integer	MinValue: -1 ExternalName: timezoneruleversionnumber ExternalType: Integer Description: For internal use only.
70	ImportSequenceNumber (ImportSequenceNumber)	Integer	ExternalName: importsequencenumber ExternalType: Integer ExternalAccess: Insert Description: Unique identifier of the data import or data migration that created this record.
71	OverriddenCreatedOn (OverriddenCreatedOn)	Date	ExternalName: overriddencreatedon ExternalType: DateTime ExternalAccess: Insert Description: Date and time that the record was migrated.
72	ExchangeRate (ExchangeRate)	Decimal	ExternalName: exchangerate ExternalType: Decimal ExternalAccess: Read Description: Shows the conversion rate of the record's currency. The exchange rate is used to convert all money fields in the record from the local currency to the system's default currency.
73	UTCConversionTimeZoneCode (UTCConversionTimeZoneCode)	Integer	MinValue: -1 ExternalName: utcconversiontimezonecode ExternalType: Integer Description: Time zone code that was in use when the record was created.
74	TransactionCurrencyId (TransactionCurrencyId)	GUID	ExternalName: transactioncurrencyid ExternalType: Lookup ExternalAccess: Insert Description: Choose the local currency for the record to make sure budgets are reported in the correct currency. TableRelation: "CRM Transactioncurrency".TransactionCurrencyId
75	TransactionCurrencyIdName (TransactionCurrencyIdName)	Text100	ExternalName: transactioncurrencyidname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Transactioncurrency".CurrencyName WHERE (TransactionCurrencyId=FIELD(TransactionCurrencyId)))	FlowField
76	TotalLineItemAmount_Base (TotalLineItemAmount_Base)	Decimal	ExternalName: totallineitemamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Detail Amount field converted to the system's default base currency. The calculation uses the exchange rate specified in the Currencies area.
77	TotalLineItemDiscountAmount_Ba (TotalLineItemDiscountAmount_Ba)	Decimal	ExternalName: totallineitemdiscountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the total of the Manual Discount amounts specified on all products included in the invoice. This value is reflected in the Detail Amount field on the invoice and is added to any discount amount or rate specified on the invoice.
78	TotalTax_Base (TotalTax_Base)	Decimal	ExternalName: totaltax_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Tax field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
79	TotalAmountLessFreight_Base (TotalAmountLessFreight_Base)	Decimal	ExternalName: totalamountlessfreight_base ExternalType: Money ExternalAccess: Read Description: Shows the Pre-Freight Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
80	DiscountAmount_Base (DiscountAmount_Base)	Decimal	ExternalName: discountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Invoice Discount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
81	TotalAmount_Base (TotalAmount_Base)	Decimal	ExternalName: totalamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
82	FreightAmount_Base (FreightAmount_Base)	Decimal	ExternalName: freightamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Freight Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
83	TotalDiscountAmount_Base (TotalDiscountAmount_Base)	Decimal	ExternalName: totaldiscountamount_base ExternalType: Money ExternalAccess: Read Description: Shows the Total Discount Amount field converted to the system's default base currency for reporting purposes. The calculation uses the exchange rate specified in the Currencies area.
84	CreatedOnBehalfBy (CreatedOnBehalfBy)	GUID	ExternalName: createdonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who created the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
85	CreatedOnBehalfByName (CreatedOnBehalfByName)	Text200	ExternalName: createdonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(CreatedOnBehalfBy)))	FlowField
86	ModifiedOnBehalfBy (ModifiedOnBehalfBy)	GUID	ExternalName: modifiedonbehalfby ExternalType: Lookup ExternalAccess: Read Description: Shows who last updated the record on behalf of another user. TableRelation: "CRM Systemuser".SystemUserId
87	ModifiedOnBehalfByName (ModifiedOnBehalfByName)	Text200	ExternalName: modifiedonbehalfbyname ExternalType: String ExternalAccess: Read CalcFormula: Lookup("CRM Systemuser".FullName WHERE (SystemUserId=FIELD(ModifiedOnBehalfBy)))	FlowField
88	OwningTeam (OwningTeam)	GUID	ExternalName: owningteam ExternalType: Lookup ExternalAccess: Read Description: Unique identifier of the team who owns the invoice. TableRelation: "CRM Team".TeamId
89	BillTo_Composite (BillTo_Composite)	BLOB [Memo]	ExternalName: billto_composite ExternalType: Memo ExternalAccess: Read Description: Shows the complete Bill To address.
90	ShipTo_Composite (ShipTo_Composite)	BLOB [Memo]	ExternalName: shipto_composite ExternalType: Memo ExternalAccess: Read Description: Shows the complete Ship To address.
91	ProcessId (ProcessId)	GUID	ExternalName: processid ExternalType: Uniqueidentifier Description: Shows the ID of the process.
92	StageId (StageId)	GUID	ExternalName: stageid ExternalType: Uniqueidentifier Description: Shows the ID of the stage.
93	EntityImageId (EntityImageId)	GUID	ExternalName: entityimageid ExternalType: Uniqueidentifier ExternalAccess: Read Description: For internal use only.
94	TraversedPath (TraversedPath)	Text250	ExternalName: traversedpath ExternalType: String Description: For internal use only.

Keys

#	Fields
0	InvoiceId (InvoiceId)		Clustered: Yes
1	Name (Name)

Table Relations To Other Tables

Field	Related Table	Related Field
CustomerId (CustomerId)	CRM Account	AccountId (AccountId)	TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
OwningBusinessUnit (OwningBusinessUnit)	CRM Businessunit	BusinessUnitId (BusinessUnitId)	TableRelation: "CRM Businessunit".BusinessUnitId	1..n
CustomerId (CustomerId)	CRM Contact	ContactId (ContactId)	TableRelation: IF (CustomerIdType=CONST(account)) "CRM Account".AccountId ELSE IF (CustomerIdType=CONST(contact)) "CRM Contact".ContactId;	1..n
OpportunityId (OpportunityId)	CRM Opportunity	OpportunityId (OpportunityId)	TableRelation: "CRM Opportunity".OpportunityId	1..n
PriceLevelId (PriceLevelId)	CRM Pricelevel	PriceLevelId (PriceLevelId)	TableRelation: "CRM Pricelevel".PriceLevelId	1..n
SalesOrderId (SalesOrderId)	CRM Salesorder	SalesOrderId (SalesOrderId)	TableRelation: "CRM Salesorder".SalesOrderId	1..n
ModifiedOnBehalfBy (ModifiedOnBehalfBy)	CRM Systemuser	SystemUserId (SystemUserId)	TableRelation: "CRM Systemuser".SystemUserId	1..n
OwningTeam (OwningTeam)	CRM Team	TeamId (TeamId)	TableRelation: "CRM Team".TeamId	1..n
TransactionCurrencyId (TransactionCurrencyId)	CRM Transactioncurrency	TransactionCurrencyId (TransactionCurrencyId)	TableRelation: "CRM Transactioncurrency".TransactionCurrencyId	1..n

Table Relations From Other Tables

From Table	From Field
CRM Invoicedetail	InvoiceId (InvoiceId)	TableRelation: "CRM Invoice".InvoiceId	1..n
CRM Post	RegardingObjectId (RegardingObjectId)	TableRelation: IF (RegardingObjectTypeCode=CONST(systemuser)) "CRM Systemuser".SystemUserId ELSE IF (RegardingObjectTypeCode=CONST(account)) "CRM Account".AccountId ELSE IF (RegardingObjectTypeCode=CONST(contact)) "CRM Contact".ContactId ELSE IF (RegardingObjectTypeCode=CONST(opportunity)) "CRM Opportunity".OpportunityId ELSE IF (RegardingObjectTypeCode=CONST(post)) "CRM Post".PostId ELSE IF (RegardingObjectTypeCode=CONST(transactioncurrency)) "CRM Transactioncurrency".TransactionCurrencyId ELSE IF (RegardingObjectTypeCode=CONST(pricelevel)) "CRM Pricelevel".PriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(productpricelevel)) "CRM Productpricelevel".ProductPriceLevelId ELSE IF (RegardingObjectTypeCode=CONST(product)) "CRM Product".ProductId ELSE IF (RegardingObjectTypeCode=CONST(incident)) "CRM Incident".IncidentId ELSE IF (RegardingObjectTypeCode=CONST(incidentresolution)) "CRM Incidentresolution".ActivityId ELSE IF (RegardingObjectTypeCode=CONST(quote)) "CRM Quote".QuoteId ELSE IF (RegardingObjectTypeCode=CONST(quotedetail)) "CRM Quotedetail".QuoteDetailId ELSE IF (RegardingObjectTypeCode=CONST(salesorder)) "CRM Salesorder".SalesOrderId ELSE IF (RegardingObjectTypeCode=CONST(salesorderdetail)) "CRM Salesorderdetail".SalesOrderDetailId ELSE IF (RegardingObjectTypeCode=CONST(invoice)) "CRM Invoice".InvoiceId ELSE IF (RegardingObjectTypeCode=CONST(invoicedetail)) "CRM Invoicedetail".InvoiceDetailId ELSE IF (RegardingObjectTypeCode=CONST(contract)) "CRM Contract".ContractId ELSE IF (RegardingObjectTypeCode=CONST(team)) "CRM Team".TeamId ELSE IF (RegardingObjectTypeCode=CONST(customeraddress)) "CRM Customeraddress".CustomerAddressId ELSE IF (RegardingObjectTypeCode=CONST(uom)) "CRM Uom".UoMId ELSE IF (RegardingObjectTypeCode=CONST(uomschedule)) "CRM Uomschedule".UoMScheduleId ELSE IF (RegardingObjectTypeCode=CONST(organization)) "CRM Organization".OrganizationId ELSE IF (RegardingObjectTypeCode=CONST(businessunit)) "CRM Businessunit".BusinessUnitId ELSE IF (RegardingObjectTypeCode=CONST(discount)) "CRM Discount".DiscountId ELSE IF (RegardingObjectTypeCode=CONST(discounttype)) "CRM Discounttype".DiscountTypeId;	1..n

Diagrams

Tables A-Z

a

b

c

d

e

f

g

h

i

j

l

m

n

o

p

q

r

s

t

u

v

w

x

z

Table

CRM Invoice

Fields

Keys

Table Relations To Other Tables

Table Relations From Other Tables