JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

Invoice

This is a table representing the Invoice entities in Dynamics CRM.

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the invoice.

AccountId_Id String True

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

AccountId_LogicalName String True

AccountId_Name String True

BillTo_City String False

City name in the billing address.

BillTo_Country String False

Country/region name in the billing address.

BillTo_Fax String False

Fax number for the billing address.

BillTo_Line1 String False

First line for entering billing address information.

BillTo_Line2 String False

Second line for entering billing address information.

BillTo_Line3 String False

Third line for entering billing address information.

BillTo_Name String False

Name to enter for the billing address.

BillTo_PostalCode String False

ZIP Code or postal code in the billing address.

BillTo_StateOrProvince String False

State or province in the billing address.

BillTo_Telephone String False

Telephone number associated with the billing address.

ContactId_Id String True

Unique identifier of the contact associated with the invoice.

ContactId_LogicalName String True

ContactId_Name String True

CreatedBy_Id String True

Unique identifier of the user who created the invoice.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the invoice was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the invoice.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CustomerId_Id String False

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

CustomerId_LogicalName String False

CustomerId_Name String False

DateDelivered Datetime False

Date all products in the invoice were delivered.

Description String False

Description of the invoice.

DiscountAmount Double False

Discount specified as a monetary amount for the invoice.

DiscountAmount_Base Double True

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

DiscountPercentage Double False

Discount specified as a percentage for the invoice.

DueDate Datetime False

Date by which the invoice needs to be paid.

ExchangeRate Double True

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

FreightAmount Double False

Cost of freight for the invoice.

FreightAmount_Base Double True

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

ImportSequenceNumber Integer False

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

InvoiceId String False

Unique identifier of the invoice.

InvoiceNumber String False

Invoice number.

IsPriceLocked Boolean True

Information about whether invoice pricing is locked.

LastBackofficeSubmit Datetime False

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

ModifiedBy_Id String True

Unique identifier of the user who last modified the invoice.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the invoice was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the invoice.

OpportunityId_Id String False

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

OpportunityId_LogicalName String False

OpportunityId_Name String False

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

OwnerId_Id String False

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

OwnerId_LogicalName String False

OwnerId_Name String False

OwningBusinessUnit_Id String True

Unique identifier of the business unit that owns the invoice.

OwningBusinessUnit_LogicalName String True

OwningBusinessUnit_Name String True

OwningTeam_Id String True

Unique identifier of the team who owns the invoice.

OwningTeam_LogicalName String True

OwningTeam_Name String True

OwningUser_Id String True

Unique identifier of the user who owns the invoice.

OwningUser_LogicalName String True

OwningUser_Name String True

PaymentTermsCode String False

Payment terms for the invoice.

PriceLevelId_Id String False

Unique identifier of the price list associated with the invoice.

PriceLevelId_LogicalName String False

PriceLevelId_Name String False

PricingErrorCode String False

Type of pricing error for the invoice.

PriorityCode String False

Priority of the invoice.

SalesOrderId_Id String False

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

SalesOrderId_LogicalName String False

SalesOrderId_Name String False

ShippingMethodCode String False

Method of shipment for the invoice.

ShipTo_City String False

City name in the shipping address.

ShipTo_Country String False

Country/region name in the shipping address.

ShipTo_Fax String False

Fax number for the shipping address.

ShipTo_FreightTermsCode String False

Freight terms for the shipping address.

ShipTo_Line1 String False

First line for entering shipping address information.

ShipTo_Line2 String False

Second line for entering shipping address information.

ShipTo_Line3 String False

Third line for entering shipping address information.

ShipTo_Name String False

Name to enter for the shipping address.

ShipTo_PostalCode String False

ZIP Code or postal code in the shipping address.

ShipTo_StateOrProvince String False

State or province in the shipping address.

ShipTo_Telephone String False

Telephone number associated with the shipping address.

StateCode String True

Status of the invoice.

StatusCode String False

Reason for the status of the invoice.

TimeZoneRuleVersionNumber Integer False

For internal use only.

TotalAmount Double True

Total price for the invoice.

TotalAmount_Base Double True

Base currency equivalent of the total price for the invoice.

TotalAmountLessFreight Double True

Total price minus the freight charges for the invoice.

TotalAmountLessFreight_Base Double True

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

TotalDiscountAmount Double True

Total discount for the invoice.

TotalDiscountAmount_Base Double True

Base currency equivalent of the total discount for the invoice.

TotalLineItemAmount Double True

Total line item amount for the invoice.

TotalLineItemAmount_Base Double True

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

TotalLineItemDiscountAmount Double True

Total line item discount for the invoice.

TotalLineItemDiscountAmount_Base Double True

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

TotalTax Double True

Total tax for the invoice.

TotalTax_Base Double True

Base currency equivalent of the total tax for the invoice.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the invoice.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UTCConversionTimeZoneCode Integer False

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

WillCall Boolean False

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

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462