Invoice Entity Metadata

  • Article

[Applies to: Microsoft Dynamics CRM 2011]

The following information is for the invoice entity in a default, uncustomized installation of Microsoft Dynamics CRM. The schema name and early bound class for this entity is Invoice.

To view the entity metadata for your organization, install the Metadata Browser solution described in Browse the Metadata for Your Organization.

In This Topic

Entity Metadata

Privilege Metadata

Attribute Metadata

One-to-Many Relationships

Many-to-Many Relationships

Many-to-One Relationships

Entity Metadata

The following table shows the metadata for the invoice entity.

Entity metadata property Value

OTC

1090

EntityLogicalName

invoice

DisplayName

Invoice

IsCustomizable

True

OwnershipType

UserOwned

IsAvailableOffline

True

AutoRouteToOwnerQueue

False

CanBeInManyToMany

True

CanBePrimaryEntityInRelationship

True

CanBeRelatedEntityInRelationship

True

CanCreateAttributes

True

CanCreateCharts

True

CanCreateForms

True

CanCreateViews

True

CanModifyAdditionalSettings

True

CanTriggerWorkflow

True

IsActivity

False

IsActivityParty

True

IsAuditEnabled

False

IsChildEntity

False

IsConnectionsEnabled

canmodifyconnectionsettings

IsCustomEntity

False

IsDocumentManagementEnabled

False

IsDuplicateDetectionEnabled

False

IsEnabledForCharts

True

IsImportable

True

IsIntersect

False

IsMailMergeEnabled

False

IsManaged

True

IsMappable

True

IsReadingPaneEnabled

True

IsRenameable

True

IsValidForAdvancedFind

True

IsValidForQueue

False

IsVisibleInMobile

False

PrimaryIdAttribute

invoiceid

PrimaryNameAttribute

name

ReportViewName

FilteredInvoice

RecurrenceBaseEntityLogicalName

DisplayCollectionName

Invoices

Description

Order that has been billed.

Privilege Metadata

The following table shows the privilege metadata for the invoice entity.

PrivilegeName Id Type CanBeBasic CanBeDeep CanBeGlobal CanBeLocal

prvAppendInvoice

a3360786-e99f-4ee9-965c-a24ed6bd9be7

Append

True

True

True

True

prvAppendToInvoice

6cf5ebf1-a6da-4522-b51d-86f54ad13fa3

AppendTo

True

True

True

True

prvAssignInvoice

17a4e6ce-9815-404a-86f5-925c2ce4ae49

Assign

True

True

True

True

prvCreateInvoice

0b005177-7e27-4f91-909e-17cff6476023

Create

True

True

True

True

prvDeleteInvoice

3e14a3c0-f07d-49a8-8691-eca43f2dd173

Delete

True

True

True

True

prvOverridePriceEngineInvoice

748f74bf-055c-4fd3-835f-a9ecb7449315

None

True

True

True

True

prvReadInvoice

824b86c8-7851-4abe-9d99-e281e8f1d504

Read

True

True

True

True

prvShareInvoice

12289bc7-b3ff-4846-8fb6-50cec63f5b7b

Share

True

True

True

True

prvWriteInvoice

31ab0ac9-7a6c-4a9e-b982-5065863f142e

Write

True

True

True

True

Attribute Metadata

The following table shows the attribute metadata for the invoice entity.

LogicalName SchemaName Type RequiredLevel CanBeSecuredForCreate CanBeSecuredForRead CanBeSecuredForUpdate IsAuditEnabled IsCustomAttribute IsCustomizable IsManaged IsPrimaryId IsPrimaryName IsRenameable IsSecured IsValidForAdvancedFind IsValidForCreate IsValidForRead IsValidForUpdate DisplayName Description DeprecatedVersion

accountid

AccountId

Lookup

None

False

False

False

True

False

True

True

False

False

False

False

False

False

True

False

Account

Unique identifier of the account with which the invoice is associated.

billto_city

BillTo_City

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To City

City name in the billing address.

billto_country

BillTo_Country

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To Country/Region

Country/region name in the billing address.

billto_fax

BillTo_Fax

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To Fax

Fax number for the billing address.

billto_line1

BillTo_Line1

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To Street 1

First line for entering billing address information.

billto_line2

BillTo_Line2

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To Street 2

Second line for entering billing address information.

billto_line3

BillTo_Line3

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To Street 3

Third line for entering billing address information.

billto_name

BillTo_Name

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To Name

Name to enter for the billing address.

billto_postalcode

BillTo_PostalCode

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To ZIP/Postal Code

ZIP Code or postal code in the billing address.

billto_stateorprovince

BillTo_StateOrProvince

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To State/Province

State or province in the billing address.

billto_telephone

BillTo_Telephone

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Bill To Phone

Telephone number associated with the billing address.

contactid

ContactId

Lookup

None

False

False

False

True

False

True

True

False

False

False

False

False

False

True

False

Contact

Unique identifier of the contact associated with the invoice.

createdby

CreatedBy

Lookup

None

False

False

False

False

False

True

True

False

False

True

False

True

False

True

False

Created By

Unique identifier of the user who created the invoice.

createdon

CreatedOn

DateTime

None

False

False

False

False

False

True

True

False

False

True

False

True

False

True

False

Created On

Date and time when the invoice was created.

createdonbehalfby

CreatedOnBehalfBy

Lookup

None

False

False

False

False

False

True

True

False

False

True

False

True

False

True

False

Created By (Delegate)

Unique identifier of the delegate user who created the invoice.

customerid

CustomerId

Customer

SystemRequired

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Customer

Unique identifier of the account or contact associated with the invoice.

datedelivered

DateDelivered

DateTime

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Date Delivered

Date all products in the invoice were delivered.

description

Description

Memo

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Description

Description of the invoice.

discountamount

DiscountAmount

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Invoice Discount Amount

Discount specified as a monetary amount for the invoice.

discountamount_base

DiscountAmount_Base

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Invoice Discount Amount (Base)

Base currency equivalent of the discount specified as a monetary amount for the invoice.

discountpercentage

DiscountPercentage

Decimal

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Invoice Discount (%)

Discount specified as a percentage for the invoice.

duedate

DueDate

DateTime

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Due Date

Date by which the invoice needs to be paid.

exchangerate

ExchangeRate

Decimal

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Exchange Rate

Exchange rate for the currency associated with the invoice with respect to the base currency.

freightamount

FreightAmount

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Freight Amount

Cost of freight for the invoice.

freightamount_base

FreightAmount_Base

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Freight Amount (Base)

Base currency equivalent of the cost of freight for the invoice.

importsequencenumber

ImportSequenceNumber

Integer

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

False

Import Sequence Number

Unique identifier of the data import or data migration that created this record.

invoiceid

InvoiceId

Uniqueidentifier

SystemRequired

False

False

False

False

False

True

True

True

False

True

False

True

True

True

False

Invoice

Unique identifier of the invoice.

invoicenumber

InvoiceNumber

String

SystemRequired

False

False

False

True

False

True

True

False

False

True

False

True

True

True

False

Invoice ID

Invoice number.

ispricelocked

IsPriceLocked

Boolean

ApplicationRequired

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Prices Locked

Information about whether invoice pricing is locked.

lastbackofficesubmit

LastBackofficeSubmit

DateTime

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Last Submitted to Backoffice

Date and time when the invoice was last submitted to Microsoft Great Plains.

modifiedby

ModifiedBy

Lookup

None

False

False

False

False

False

True

True

False

False

True

False

True

False

True

False

Modified By

Unique identifier of the user who last modified the invoice.

modifiedon

ModifiedOn

DateTime

None

False

False

False

False

False

True

True

False

False

True

False

True

False

True

False

Modified On

Date and time when the invoice was last modified.

modifiedonbehalfby

ModifiedOnBehalfBy

Lookup

None

False

False

False

False

False

True

True

False

False

True

False

True

False

True

False

Modified By (Delegate)

Unique identifier of the delegate user who last modified the invoice.

name

Name

String

ApplicationRequired

False

False

False

True

False

True

True

False

True

True

False

True

True

True

True

Name

Name of the invoice.

opportunityid

OpportunityId

Lookup

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Opportunity

Unique identifier of the opportunity with which the invoice is associated.

overriddencreatedon

OverriddenCreatedOn

DateTime

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

False

Record Created On

Date and time that the record was migrated.

ownerid

OwnerId

Owner

SystemRequired

False

False

False

True

False

True

True

False

False

True

False

True

True

True

False

Owner

Unique identifier of the user or team who owns the invoice.

owningbusinessunit

OwningBusinessUnit

Lookup

None

False

False

False

False

False

True

True

False

False

False

False

False

False

True

False

Owning Business Unit

Unique identifier of the business unit that owns the invoice.

owningteam

OwningTeam

Lookup

None

False

False

False

False

False

True

True

False

False

False

False

False

False

True

False

Owning Team

Unique identifier of the team who owns the invoice.

owninguser

OwningUser

Lookup

None

False

False

False

False

False

True

True

False

False

False

False

False

False

True

False

Owning User

Unique identifier of the user who owns the invoice.

paymenttermscode

PaymentTermsCode

Picklist

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Payment Terms

Payment terms for the invoice.

pricelevelid

PriceLevelId

Lookup

ApplicationRequired

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Price List

Unique identifier of the price list associated with the invoice.

pricingerrorcode

PricingErrorCode

Picklist

None

False

False

False

True

False

True

True

False

False

False

False

False

True

True

True

Pricing Error

Type of pricing error for the invoice.

prioritycode

PriorityCode

Picklist

None

False

False

False

True

False

True

True

False

False

True

False

False

True

True

True

Priority

Priority of the invoice.

salesorderid

SalesOrderId

Lookup

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Order

Unique identifier of the order that is associated with the invoice.

shippingmethodcode

ShippingMethodCode

Picklist

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Shipping Method

Method of shipment for the invoice.

shipto_city

ShipTo_City

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To City

City name in the shipping address.

shipto_country

ShipTo_Country

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To Country/Region

Country/region name in the shipping address.

shipto_fax

ShipTo_Fax

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To Fax

Fax number for the shipping address.

shipto_freighttermscode

ShipTo_FreightTermsCode

Picklist

None

False

False

False

True

False

True

True

False

False

True

False

False

True

True

True

Ship To Freight Terms

Freight terms for the shipping address.

shipto_line1

ShipTo_Line1

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To Street 1

First line for entering shipping address information.

shipto_line2

ShipTo_Line2

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To Street 2

Second line for entering shipping address information.

shipto_line3

ShipTo_Line3

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To Street 3

Third line for entering shipping address information.

shipto_name

ShipTo_Name

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To Name

Name to enter for the shipping address.

shipto_postalcode

ShipTo_PostalCode

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To ZIP/Postal Code

ZIP Code or postal code in the shipping address.

shipto_stateorprovince

ShipTo_StateOrProvince

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To State/Province

State or province in the shipping address.

shipto_telephone

ShipTo_Telephone

String

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To Phone

Telephone number associated with the shipping address.

statecode

StateCode

State

SystemRequired

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Status

Status of the invoice.

statuscode

StatusCode

Status

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Status Reason

Reason for the status of the invoice.

timezoneruleversionnumber

TimeZoneRuleVersionNumber

Integer

None

False

False

False

False

False

True

True

False

False

False

False

False

True

True

True

Time Zone Rule Version Number

For internal use only.

totalamount

TotalAmount

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Amount

Total price for the invoice.

totalamount_base

TotalAmount_Base

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Amount (Base)

Base currency equivalent of the total price for the invoice.

totalamountlessfreight

TotalAmountLessFreight

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Pre-Freight Amount

Total price minus the freight charges for the invoice.

totalamountlessfreight_base

TotalAmountLessFreight_Base

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Pre-Freight Amount (Base)

Base currency equivalent of the total price minus the freight charges for the invoice.

totaldiscountamount

TotalDiscountAmount

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Discount Amount

Total discount for the invoice.

totaldiscountamount_base

TotalDiscountAmount_Base

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Discount Amount (Base)

Base currency equivalent of the total discount for the invoice.

totallineitemamount

TotalLineItemAmount

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Detail Amount

Total line item amount for the invoice.

totallineitemamount_base

TotalLineItemAmount_Base

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Detail Amount (Base)

Base currency equivalent of the total line item amount for the invoice

totallineitemdiscountamount

TotalLineItemDiscountAmount

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Line Item Discount Amount

Total line item discount for the invoice.

totallineitemdiscountamount_base

TotalLineItemDiscountAmount_Base

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Line Item Discount Amount (Base)

Base currency equivalent of the total line item discount for the invoice.

totaltax

TotalTax

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Tax

Total tax for the invoice.

totaltax_base

TotalTax_Base

Money

None

False

False

False

True

False

True

True

False

False

True

False

True

False

True

False

Total Tax (Base)

Base currency equivalent of the total tax for the invoice.

transactioncurrencyid

TransactionCurrencyId

Lookup

ApplicationRequired

False

False

False

True

False

True

True

False

False

True

False

True

True

True

False

Currency

Unique identifier of the currency associated with the invoice.

utcconversiontimezonecode

UTCConversionTimeZoneCode

Integer

None

False

False

False

False

False

True

True

False

False

False

False

False

True

True

True

UTC Conversion Time Zone Code

Time zone code that was in use when the record was created.

versionnumber

VersionNumber

BigInt

None

False

False

False

False

False

False

True

False

False

False

False

False

False

True

False

Version Number

Version number of the invoice.

willcall

WillCall

Boolean

None

False

False

False

True

False

True

True

False

False

True

False

True

True

True

True

Ship To

Information about whether the customer will call for the invoiced products or the products are to be shipped.

One-to-Many Relationships

The following table shows the entities that are the referencing entity in a one-to-many relationship with the invoice entity.

Relationship schema name Referencing entity

invoice_activity_parties

activityparty

Invoice_ActivityPointers

activitypointer

Invoice_Annotation

annotation

Invoice_Appointments

appointment

Invoice_AsyncOperations

asyncoperation

Invoice_BulkDeleteFailures

bulkdeletefailure

invoice_connections2

connection

invoice_connections1

connection

Invoice_Emails

email

Invoice_Faxes

fax

invoice_details

invoicedetail

Invoice_Letters

letter

Invoice_Phonecalls

phonecall

invoice_principalobjectattributeaccess

principalobjectattributeaccess

Invoice_ProcessSessions

processsession

Invoice_RecurringAppointmentMasters

recurringappointmentmaster

Invoice_ServiceAppointments

serviceappointment

Invoice_Tasks

task

userentityinstancedata_invoice

userentityinstancedata

Many-to-Many Relationships

The following table shows the many-to-many relationships for the invoice entity.

Relationship schema name Entity 1 Entity 2 Intersect entity name

contactinvoices_association

invoice

contact

contactinvoices

Many-to-One Relationships

The following table shows the entities that are the referenced entity in a many-to-one relationship with the invoice entity.

Relationship schema name Referenced entity

invoice_customer_accounts

account

business_unit_invoices

businessunit

invoice_customer_contacts

contact

opportunity_invoices

opportunity

owner_invoices

owner

price_level_invoices

pricelevel

order_invoices

salesorder

lk_invoice_createdonbehalfby

systemuser

lk_invoicebase_modifiedby

systemuser

lk_invoice_modifiedonbehalfby

systemuser

system_user_invoices

systemuser

lk_invoicebase_createdby

systemuser

team_invoices

team

transactioncurrency_invoice

transactioncurrency

See Also

Reference

EntityMetadata
AttributeMetadata
OneToManyRelationshipMetadata
ManyToManyRelationshipMetadata

Concepts

Quote, Order and Invoice Entities
Invoice Entity Messages and Methods
Invoice Entity OptionSet Attribute Metadata
Invoice Entity Privileges

Microsoft Dynamics CRM 2011
Send comments about this topic to Microsoft.
© 2013 Microsoft Corporation. All rights reserved.