ODBC Driver for Salesforce Data Cloud

Build 24.0.9175

Account

The Account DMO is a Data Cloud data model object for how a party wantsto interact with your company. Provided in both the Sales and Service Data Kits.

Columns

Name Type References Description
Account Business Type Varchar The business type of the account.
Account Description Varchar A text description of the contact account.
Account ID Varchar A unique ID used as the primary key for the account DMO.
Account Name Varchar The name of the contact account.
Account Number Varchar The number assigned to the contact account.
Account Ownership Type Varchar The ownership type of the account.
Account Rating Type Varchar The rating type of the account.
Account Source Varchar The source of the account.
Account Type Varchar The reference ID for the type of contact account, for example, aloyalty account or business credit account.
Account Service Entitlements Varchar
Account Website URL Varchar The website URL for the account.
Annual Revenue Amount Double The annual revenue amount for the account.
Assign Territory Flag Varchar An indicator if an account needs an assigned territory.
Auto Pay Enabled Flag Varchar An indicator if auto pay is enabled for this contact.
Auto Payment Amount Double The amount to be automatically paid next time.
Auto Payment Amount Currency Varchar The currency of the auto payment amount.
Auto Payment Method Varchar A reference ID for the payment method for auto pay, for example acredit card or bank account.
Balance Amount Double The number in an account balance, for example, 100 points, 3miles, or 6 visits.
Balance Amount Currency Varchar The balance amount’s currency.
Balance Amount Limit Varchar The max balance allowed, for example a credit limit.
Balance Amount Limit Currency Varchar The balance amount limit’s currency.
Balance Unit Of Measure Varchar A reference ID for the unit of measure for balance, for examplemoney, points, or miles.
Balance Unit Of Measure Currency Varchar A reference ID for the currency type used if balance unit ofmeasure is money.
Bill Contact Address Varchar A reference ID for the contact point billing address.
Bill Delivery Method Varchar A reference ID for the preference to send the bill via electronicor physical mail delivery.
Bill Frequency Varchar The frequency for billing the account.
Contact Point Address Varchar A reference ID for the contact point address.
Contact Point App Varchar A reference ID for the contact point app.
Contact Point Email Varchar A reference ID for the contact point email.
Contact Point Location Varchar A reference ID for the contact point location.
Contact Point Phone Varchar A reference ID for the contact point phone.
Contact Point Social Varchar A reference ID for the contact point social.
Created Date Datetime The date the record was created.
Data Source Varchar A reference ID for the logical name of the object where thisrecord came from, whether that is a name of a cloud storage file oranother connector’s external object.
Data Source Object Varchar A reference ID for the logical name of the object where thisrecord came from, whether that is a name of a cloud storage file oranother connector’s external object.
Default Freight Terms Varchar A reference ID to the standard freight terms for this contact forexample, Free On Board Shipping Point (FOB).
Default Price Book Varchar A reference ID to the standard price book for thiscontact.
Effective Date Datetime The effective date of the record.
Employee Count Double The count of employees.
End Date Datetime The end date of the record.
External Record ID Varchar A reference ID for an external data source system.
External Source ID Varchar A reference ID for the system in which the external record ID wasassigned.
Fax Phone Varchar A reference ID to the fax number for the account.
General Ledger Account Varchar A reference ID for a contact’s financial account where credit anddebits are posted.
Hold Status Reason Varchar A reference ID for the reason why the account is on hold.
Individual Varchar A reference ID for the individual associated with theaccount.
Internal Organization Varchar A reference ID to the business unit or other internalorganization that owns the business account.
Is Active Varchar An indicator if the account is active.
Is Customer Varchar An indicator if the account is a customer account.
Is Internal Varchar An indicator if the account is an internal account.
Is Partner Varchar An indicator if the account is a partner account.
Is Seller Varchar An indicator if the account is a seller account.
Is Supplier Varchar An indicator if the account is a supplier account.
Last Activity Date Datetime The date of the most recent account activity.
Last Modified Date Datetime The date when a user last modified the record.
Next Interaction Date Datetime The date when the account should be contacted again.
Next Review Date Datetime The date when the account should be reviewed again.
Ninety Day Balance Amount Double The account balance 90 days ago.
Ninety Day Balance Amount Currency Varchar The 90-day account balance currency.
Operating Hours Varchar A reference ID to the operating hours associated with theaccount.
Order Delivery Method Varchar A reference ID to the standard method for delivery such asovernight or in-person pickup.
Organization Varchar A reference ID to the account organization.
Parent Account Varchar A reference ID to the parent contact account.
Party Varchar A reference ID to the parent party, for example, an individual,business, or affiliation group.
Party Object Varchar A reference ID to the associated party object.
Party Role Varchar A reference ID to the associated party role, for example, acustomer, supplier, or competitor.
Party Web Address Varchar A reference ID to the associated party web address.
Payment Term Varchar The payment term for the account.
Primary Industry Varchar The primary industry for the account.
Primary Sales Contact Point Varchar A reference ID for the best way to communicate with the contactregarding sales.
Primary Sales Rep Varchar A reference ID for the sales owner of the account.
Review Frequency Varchar The frequency for reviewing the account.
Sales Phone Varchar A reference ID for the phone number for this account.
Shipping Address Varchar A reference ID for the shipping billing address.
Shipping Contact Varchar A reference ID for the shipping contact.
Shipping Email Varchar A reference ID for the email used for shipping inquiries.
Shipping Phone Varchar A reference ID for the phone for shipping inquiries.
Sixty Day Balance Amount Double The account balance 60 days ago.
Sixty Day Balance Amount Currency Varchar The 60-day account balance currency.
SLA Expiration Date Datetime The date when a Service Level Agreement (SLA) expires.
SLA Type Varchar A reference ID for the contact’s Service Level Agreement (SLA)type.
Source System Identifier Varchar The identifier for the source system.
Source System Modified Date Datetime The date and time for when the source system wasmodified.
Thirty Day Balance Amount Double The account balance 30 days ago.
Thirty Day Balance Amount Currency Varchar The 30-day account balance currency.
Use As Billing Account Varchar An indicator if the account is used for billing purposes.
Use As Sales Account Varchar An indicator if the account is used for sales.
Use As Service Account Varchar An indicator if the account is used for service.
Use As Shipping Account Varchar An indicator if the account is used for shippingpurposes.
Website Varchar The website address for the account.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 24.0.9175