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. |