JDBC Driver for Microsoft Dynamics CRM

Build 22.0.8462

BusinessUnit

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

Columns

Name Type ReadOnly Description
Id [KEY] String False

Unique identifier of the business unit.

Address1_AddressId String False

Unique identifier for address 1.

Address1_AddressTypeCode String False

Type of address for address 1, such as billing, shipping, or primary address.

Address1_City String False

City name for address 1.

Address1_Country String False

Country/region name for address 1.

Address1_County String False

County name for address 1.

Address1_Fax String False

Fax number for address 1.

Address1_Latitude Double False

Latitude for address 1.

Address1_Line1 String False

First line for entering address 1 information.

Address1_Line2 String False

Second line for entering address 1 information.

Address1_Line3 String False

Third line for entering address 1 information.

Address1_Longitude Double False

Longitude for address 1.

Address1_Name String False

Name to enter for address 1.

Address1_PostalCode String False

ZIP Code or postal code for address 1.

Address1_PostOfficeBox String False

Post office box number for address 1.

Address1_ShippingMethodCode String False

Method of shipment for address 1.

Address1_StateOrProvince String False

State or province for address 1.

Address1_Telephone1 String False

First telephone number associated with address 1.

Address1_Telephone2 String False

Second telephone number associated with address 1.

Address1_Telephone3 String False

Third telephone number associated with address 1.

Address1_UPSZone String False

United Parcel Service (UPS) zone for address 1.

Address1_UTCOffset Integer False

UTC offset for address 1. This is the difference between local time and standard Coordinated Universal Time.

Address2_AddressId String False

Unique identifier for address 2.

Address2_AddressTypeCode String False

Type of address for address 2, such as billing, shipping, or primary address.

Address2_City String False

City name for address 2.

Address2_Country String False

Country/region name for address 2.

Address2_County String False

County name for address 2.

Address2_Fax String False

Fax number for address 2.

Address2_Latitude Double False

Latitude for address 2.

Address2_Line1 String False

First line for entering address 2 information.

Address2_Line2 String False

Second line for entering address 2 information.

Address2_Line3 String False

Third line for entering address 2 information.

Address2_Longitude Double False

Longitude for address 2.

Address2_Name String False

Name to enter for address 2.

Address2_PostalCode String False

ZIP Code or postal code for address 2.

Address2_PostOfficeBox String False

Post office box number for address 2.

Address2_ShippingMethodCode String False

Method of shipment for address 2.

Address2_StateOrProvince String False

State or province for address 2.

Address2_Telephone1 String False

First telephone number associated with address 2.

Address2_Telephone2 String False

Second telephone number associated with address 2.

Address2_Telephone3 String False

Third telephone number associated with address 2.

Address2_UPSZone String False

United Parcel Service (UPS) zone for address 2.

Address2_UTCOffset Integer False

UTC offset for address 2. This is the difference between local time and standard Coordinated Universal Time.

BusinessUnitId String False

Unique identifier of the business unit.

CalendarId_Id String False

Fiscal calendar associated with the business unit.

CalendarId_LogicalName String False

CalendarId_Name String False

CostCenter String False

Name of the business unit cost center.

CreatedBy_Id String True

Unique identifier of the user who created the business unit.

CreatedBy_LogicalName String True

CreatedBy_Name String True

CreatedOn Datetime True

Date and time when the business unit was created.

CreatedOnBehalfBy_Id String True

Unique identifier of the delegate user who created the businessunit.

CreatedOnBehalfBy_LogicalName String True

CreatedOnBehalfBy_Name String True

CreditLimit Double False

Credit limit for the business unit.

Description String False

Description of the business unit.

DisabledReason String True

Reason for disabling the business unit.

DivisionName String False

Name of the division to which the business unit belongs.

EMailAddress String False

email address for the business unit.

ExchangeRate Double True

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

FileAsName String False

Alternative name under which the business unit can be filed.

FtpSiteUrl String False

FTP site URL for the business unit.

ImportSequenceNumber Integer False

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

InheritanceMask Integer False

Inheritance mask for the business unit.

IsDisabled Boolean True

Information about whether the business unit is enabled or disabled.

ModifiedBy_Id String True

Unique identifier of the user who last modified the business unit.

ModifiedBy_LogicalName String True

ModifiedBy_Name String True

ModifiedOn Datetime True

Date and time when the business unit was last modified.

ModifiedOnBehalfBy_Id String True

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

ModifiedOnBehalfBy_LogicalName String True

ModifiedOnBehalfBy_Name String True

Name String False

Name of the business unit.

OrganizationId_Id String True

Unique identifier of the organization associated with the business unit.

OrganizationId_LogicalName String True

OrganizationId_Name String True

OverriddenCreatedOn Datetime False

Date and time that the record was migrated.

ParentBusinessUnitId_Id String False

Unique identifier for the parent business unit.

ParentBusinessUnitId_LogicalName String False

ParentBusinessUnitId_Name String False

Picture String False

Picture or diagram of the business unit.

StockExchange String False

Stock exchange on which the business is listed.

TickerSymbol String False

Stock exchange ticker symbol for the business unit.

TransactionCurrencyId_Id String False

Unique identifier of the currency associated with the businessunit.

TransactionCurrencyId_LogicalName String False

TransactionCurrencyId_Name String False

UTCOffset Integer False

UTC offset for the business unit. This is the difference between local time and standard Coordinated Universal Time.

WebSiteUrl String False

Web site URL for the business unit.

WorkflowSuspended Boolean False

Information about whether workflow or sales process rules have been suspended.

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