SplendidCRM Enterprise Data Dictionary

Table ACCOUNTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
ACCOUNT_NUMBER nvarchar (30) Account Number
NAME nvarchar (150) Name
ACCOUNT_TYPE nvarchar (25) Account Type
PARENT_ID uniqueidentifier Parent ID
INDUSTRY nvarchar (25) Industry
ANNUAL_REVENUE nvarchar (25) Annual Revenue
PHONE_FAX nvarchar (25) Phone Fax
BILLING_ADDRESS_STREET nvarchar (150) Billing Street
BILLING_ADDRESS_CITY nvarchar (100) Billing City
BILLING_ADDRESS_STATE nvarchar (100) Billing State
BILLING_ADDRESS_POSTALCODE nvarchar (20) Billing Postal Code
BILLING_ADDRESS_COUNTRY nvarchar (100) Billing Country
DESCRIPTION nvarchar (max) Description
RATING nvarchar (25) Rating
PHONE_OFFICE nvarchar (25) Phone Office
PHONE_ALTERNATE nvarchar (25) Phone Alternate
EMAIL1 nvarchar (100) Email
EMAIL2 nvarchar (100) Other Email
WEBSITE nvarchar (255) Website
OWNERSHIP nvarchar (100) Ownership
EMPLOYEES nvarchar (10) Employees
SIC_CODE nvarchar (10) Sic Code
TICKER_SYMBOL nvarchar (10) Ticker Symbol
SHIPPING_ADDRESS_STREET nvarchar (150) Shipping Street
SHIPPING_ADDRESS_CITY nvarchar (100) Shipping City
SHIPPING_ADDRESS_STATE nvarchar (100) Shipping State
SHIPPING_ADDRESS_POSTALCODE nvarchar (20) Shipping Postal Code
SHIPPING_ADDRESS_COUNTRY nvarchar (100) Shipping Country
CAMPAIGN_ID uniqueidentifier Campaign ID
TEAM_SET_ID uniqueidentifier Team Set ID

Table ACCOUNTS_BUGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID
BUG_ID uniqueidentifier BUGS.ID

Table ACCOUNTS_CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID
CASE_ID uniqueidentifier CASES.ID

Table ACCOUNTS_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTACT_ID uniqueidentifier CONTACTS.ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID

Table ACCOUNTS_DOCUMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
DOCUMENT_REVISION_ID uniqueidentifier DOCUMENT_REVISIONS.ID

Table ACCOUNTS_OPPORTUNITIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID

Table ACCOUNTS_THREADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID
THREAD_ID uniqueidentifier THREADS.ID

Table ACCOUNTS_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID
USER_ID uniqueidentifier USERS.ID

Table ACL_ACTIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (150)
CATEGORY nvarchar (100)
ACLTYPE nvarchar (100)
ACLACCESS int

Table ACL_FIELDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ROLE_ID uniqueidentifier
NAME nvarchar (150)
CATEGORY nvarchar (100)
ACLACCESS int

Table ACL_FIELDS_ALIASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ALIAS_NAME nvarchar (50)
ALIAS_MODULE_NAME nvarchar (25)
NAME nvarchar (50)
MODULE_NAME nvarchar (25)

Table ACL_ROLES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (150) Name
DESCRIPTION nvarchar (max) Description

Table ACL_ROLES_ACTIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ROLE_ID uniqueidentifier ACL_ROLES.ID
ACTION_ID uniqueidentifier ACL_ACTIONS.ID
ACCESS_OVERRIDE int

Table ACL_ROLES_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ROLE_ID uniqueidentifier ACL_ROLES.ID
USER_ID uniqueidentifier USERS.ID
ACCESS_OVERRIDE int

Table AUDIT_EVENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
AUDIT_ID uniqueidentifier Audit ID
AUDIT_TABLE nvarchar (50) Audit Table
AUDIT_TOKEN varchar (255) Audit Token
AUDIT_ACTION int Audit Action
AUDIT_PARENT_ID uniqueidentifier Audit Parent ID

Table BUGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
BUG_NUMBER nvarchar (30) Bug Number
NAME nvarchar (255) Name
STATUS nvarchar (25) Status
PRIORITY nvarchar (25) Priority
DESCRIPTION nvarchar (max) Description
RESOLUTION nvarchar (255) Resolution
FOUND_IN_RELEASE nvarchar (255) Found In Release
TYPE nvarchar (255) Type
FIXED_IN_RELEASE nvarchar (255) Fixed In Release
WORK_LOG nvarchar (max) Work Log
SOURCE nvarchar (255) Source
PRODUCT_CATEGORY nvarchar (255) Category
TEAM_SET_ID uniqueidentifier Team Set ID

Table BUGS_THREADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
BUG_ID uniqueidentifier BUGS.ID
THREAD_ID uniqueidentifier THREADS.ID

Table BUGS_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
BUG_ID uniqueidentifier BUGS.ID
USER_ID uniqueidentifier USERS.ID

Table CALL_DETAIL_RECORDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
UNIQUEID nvarchar (32)
ACCOUNT_CODE_ID uniqueidentifier
START_TIME datetime
ANSWER_TIME datetime
END_TIME datetime
DURATION int
BILLABLE_SECONDS int
SOURCE nvarchar (80)
DESTINATION nvarchar (80)
DESTINATION_CONTEXT nvarchar (80)
CALLERID nvarchar (80)
SOURCE_CHANNEL nvarchar (80)
DESTINATION_CHANNEL nvarchar (80)
DISPOSITION nvarchar (45)
AMA_FLAGS nvarchar (80)
LAST_APPLICATION nvarchar (80)
LAST_DATA nvarchar (80)
USER_FIELD nvarchar (255)

Table CALL_MARKETING

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CAMPAIGN_ID uniqueidentifier CAMPAIGNS.IDCampaign ID
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (255) Call Name
STATUS nvarchar (25) Status
DISTRIBUTION nvarchar (25) Distribution
ALL_PROSPECT_LISTS bit All Target Lists
SUBJECT nvarchar (50) Subject
DURATION_HOURS int Duration Hours
DURATION_MINUTES int Duration Minutes
DATE_START datetime Start Date
TIME_START datetime
DATE_END datetime End Date
TIME_END datetime
REMINDER_TIME int
DESCRIPTION nvarchar (max) Description

Table CALL_MARKETING_PROSPECT_LISTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROSPECT_LIST_ID uniqueidentifier PROSPECT_LISTS.ID
CALL_MARKETING_ID uniqueidentifier CALL_MARKETING.ID

Table CALLS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (150) Subject
DURATION_HOURS int Duration Hours
DURATION_MINUTES int Duration Minutes
DATE_START datetime Start Date
TIME_START datetime Start Time
DATE_END datetime End Date
PARENT_TYPE nvarchar (25) Parent Type
PARENT_ID uniqueidentifier Parent ID
STATUS nvarchar (25) Status
DIRECTION nvarchar (25) Direction
REMINDER_TIME int Reminder Time
DESCRIPTION nvarchar (max) Description
OUTLOOK_ID nvarchar (255) Outlook ID
TEAM_SET_ID uniqueidentifier Team Set ID
EMAIL_REMINDER_TIME int Email Reminder Time
SMS_REMINDER_TIME int SMS Reminder Time
REPEAT_TYPE nvarchar (25) Repeat Type
REPEAT_INTERVAL int Repeat Interval
REPEAT_DOW nvarchar (7) Days of the Week
REPEAT_UNTIL datetime Repeat Until
REPEAT_COUNT int Repeat Count
REPEAT_PARENT_ID uniqueidentifier Repeat Parent ID
RECURRING_SOURCE nvarchar (25) Recurring Source
ALL_DAY_EVENT bit

Table CALLS_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CALL_ID uniqueidentifier CALLS.ID
CONTACT_ID uniqueidentifier CONTACTS.ID
REQUIRED bit
ACCEPT_STATUS nvarchar (25)
EMAIL_REMINDER_SENT bit
SMS_REMINDER_SENT bit

Table CALLS_LEADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CALL_ID uniqueidentifier CALLS.ID
LEAD_ID uniqueidentifier LEADS.ID
REQUIRED bit
ACCEPT_STATUS nvarchar (25)
EMAIL_REMINDER_SENT bit
SMS_REMINDER_SENT bit

Table CALLS_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CALL_ID uniqueidentifier CALLS.ID
USER_ID uniqueidentifier USERS.ID
REQUIRED bit
ACCEPT_STATUS nvarchar (25)
REMINDER_DISMISSED bit
EMAIL_REMINDER_SENT bit
SMS_REMINDER_SENT bit

Table CAMPAIGN_LOG

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CAMPAIGN_ID uniqueidentifier Campaign ID
TARGET_TRACKER_KEY uniqueidentifier Target Tracker Key
TARGET_ID uniqueidentifier Target ID
TARGET_TYPE nvarchar (25) Target Type
ACTIVITY_TYPE nvarchar (25) Activity Type
ACTIVITY_DATE datetime Activity Date
RELATED_ID uniqueidentifier Related ID
RELATED_TYPE nvarchar (25) Related Type
ARCHIVED bit Archived
HITS int Hits
LIST_ID uniqueidentifier List ID
MORE_INFORMATION nvarchar (100) More Information
MARKETING_ID uniqueidentifier Marketing ID

Table CAMPAIGN_TRKRS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TRACKER_NAME nvarchar (30) Tracker Name
TRACKER_URL nvarchar (255) Tracker Url
TRACKER_KEY nvarchar (30) Tracker Key
CAMPAIGN_ID uniqueidentifier CAMPAIGNS.IDCampaign ID
IS_OPTOUT bit Is Optout

Table CAMPAIGNS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TRACKER_KEY nvarchar (30) Tracker Key
TRACKER_COUNT int Tracker Count
IMPRESSIONS int Impressions
NAME nvarchar (50) Name
REFER_URL nvarchar (255) Refer Url
TRACKER_TEXT nvarchar (255) Tracker Text
START_DATE datetime Start Date
END_DATE datetime End Date
STATUS nvarchar (25) Status
BUDGET money (19, 4) Budget
BUDGET_USDOLLAR money (19, 4) Budget US Dollar
EXPECTED_COST money (19, 4) Expected Cost
EXPECTED_COST_USDOLLAR money (19, 4) Expected Cost US Dollar
ACTUAL_COST money (19, 4) Actual Cost
ACTUAL_COST_USDOLLAR money (19, 4) Actual Cost US Dollar
EXPECTED_REVENUE money (19, 4) Expected Revenue
EXPECTED_REVENUE_USDOLLAR money (19, 4) Expected Revenue US Dollar
CAMPAIGN_TYPE nvarchar (25) Campaign Type
FREQUENCY nvarchar (25) Frequency
OBJECTIVE nvarchar (max) Objective
CONTENT nvarchar (max) Content
CURRENCY_ID uniqueidentifier Currency ID
TEAM_SET_ID uniqueidentifier Team Set ID

Table CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
CASE_NUMBER nvarchar (30) Case Number
NAME nvarchar (255) Name
ACCOUNT_NAME nvarchar (100) Account Name
ACCOUNT_ID uniqueidentifier Account ID
B2C_CONTACT_ID uniqueidentifier Contact ID
STATUS nvarchar (25) Status
PRIORITY nvarchar (25) Priority
TYPE nvarchar (25) Type
DESCRIPTION nvarchar (max) Description
RESOLUTION nvarchar (max) Resolution
WORK_LOG nvarchar (max) Work Log
TEAM_SET_ID uniqueidentifier Team Set ID

Table CASES_BUGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CASE_ID uniqueidentifier CASES.ID
BUG_ID uniqueidentifier BUGS.ID

Table CASES_THREADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CASE_ID uniqueidentifier CASES.ID
THREAD_ID uniqueidentifier THREADS.ID

Table CASES_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CASE_ID uniqueidentifier CASES.ID
USER_ID uniqueidentifier USERS.ID

Table CHARTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TEAM_SET_ID uniqueidentifier Team Set ID
NAME nvarchar (150) Name
MODULE_NAME nvarchar (25) Module Name
CHART_TYPE nvarchar (25) Chart Type
RDL nvarchar (max) RDL
PRE_LOAD_EVENT_ID uniqueidentifier
POST_LOAD_EVENT_ID uniqueidentifier

Table CONFIG

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CATEGORY nvarchar (32) Category
NAME nvarchar (60) Name
VALUE nvarchar (max) Value

Table CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
SALUTATION nvarchar (25) Salutation
FIRST_NAME nvarchar (100) First Name
LAST_NAME nvarchar (100) Last Name
LEAD_SOURCE nvarchar (100) Lead Source
TITLE nvarchar (50) Title
DEPARTMENT nvarchar (100) Department
REPORTS_TO_ID uniqueidentifier Reports To ID
BIRTHDATE datetime Birthdate
DO_NOT_CALL bit Do Not Call
PHONE_HOME nvarchar (25) Phone Home
PHONE_MOBILE nvarchar (25) Phone Mobile
PHONE_WORK nvarchar (25) Phone Work
PHONE_OTHER nvarchar (25) Phone Other
PHONE_FAX nvarchar (25) Phone Fax
EMAIL1 nvarchar (100) Email
EMAIL2 nvarchar (100) Other Email
ASSISTANT nvarchar (75) Assistant
ASSISTANT_PHONE nvarchar (25) Assistant Phone
EMAIL_OPT_OUT bit Email Opt Out
INVALID_EMAIL bit Invalid Email
SMS_OPT_IN nvarchar (25) SMS Opt In
TWITTER_SCREEN_NAME nvarchar (20) Twitter Screen Name
PRIMARY_ADDRESS_STREET nvarchar (150) Primary Street
PRIMARY_ADDRESS_CITY nvarchar (100) Primary City
PRIMARY_ADDRESS_STATE nvarchar (100) Primary State
PRIMARY_ADDRESS_POSTALCODE nvarchar (20) Primary Postal Code
PRIMARY_ADDRESS_COUNTRY nvarchar (100) Primary Country
ALT_ADDRESS_STREET nvarchar (150) Alternate Street
ALT_ADDRESS_CITY nvarchar (100) Alternate City
ALT_ADDRESS_STATE nvarchar (100) Alternate State
ALT_ADDRESS_POSTALCODE nvarchar (20) Alternate Postal Code
ALT_ADDRESS_COUNTRY nvarchar (100) Alternate Country
DESCRIPTION nvarchar (max) Description
PORTAL_NAME nvarchar (255) Portal Name
PORTAL_PASSWORD nvarchar (32) Portal Password
PORTAL_ACTIVE bit Portal Active
PORTAL_APP nvarchar (255) Portal App
CAMPAIGN_ID uniqueidentifier Campaign ID
TEAM_SET_ID uniqueidentifier Team Set ID

Table CONTACTS_BUGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTACT_ID uniqueidentifier CONTACTS.ID
BUG_ID uniqueidentifier BUGS.ID
CONTACT_ROLE nvarchar (50)

Table CONTACTS_CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTACT_ID uniqueidentifier CONTACTS.ID
CASE_ID uniqueidentifier CASES.ID
CONTACT_ROLE nvarchar (50)

Table CONTACTS_DOCUMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTACT_ID uniqueidentifier CONTACTS.ID
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
DOCUMENT_REVISION_ID uniqueidentifier DOCUMENT_REVISIONS.ID

Table CONTACTS_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTACT_ID uniqueidentifier CONTACTS.ID
USER_ID uniqueidentifier USERS.ID

Table CONTRACT_TYPES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (100) Name
LIST_ORDER int List Order

Table CONTRACT_TYPES_DOCUMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTRACT_TYPE_ID uniqueidentifier CONTRACT_TYPES.ID
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID

Table CONTRACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (255) Name
REFERENCE_CODE nvarchar (255) Reference Code
STATUS nvarchar (25) Status
TYPE_ID uniqueidentifier Type ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.IDAccount ID
B2C_CONTACT_ID uniqueidentifier Contact ID
START_DATE datetime Start Date
END_DATE datetime End Date
COMPANY_SIGNED_DATE datetime Company Signed Date
CUSTOMER_SIGNED_DATE datetime Customer Signed Date
EXPIRATION_NOTICE datetime Expiration Notice
CURRENCY_ID uniqueidentifier Currency ID
TOTAL_CONTRACT_VALUE money (19, 4) Total Contract Value
TOTAL_CONTRACT_VALUE_USDOLLAR money (19, 4) Total Contract Value US Dollar
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table CONTRACTS_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTRACT_ID uniqueidentifier CONTRACTS.ID
CONTACT_ID uniqueidentifier CONTACTS.ID

Table CONTRACTS_DOCUMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTRACT_ID uniqueidentifier CONTRACTS.ID
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
DOCUMENT_REVISION_ID uniqueidentifier DOCUMENT_REVISIONS.ID

Table CONTRACTS_OPPORTUNITIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTRACT_ID uniqueidentifier CONTRACTS.ID
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID

Table CONTRACTS_PRODUCTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTRACT_ID uniqueidentifier CONTRACTS.ID
PRODUCT_ID uniqueidentifier

Table CONTRACTS_QUOTES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTRACT_ID uniqueidentifier CONTRACTS.ID
QUOTE_ID uniqueidentifier QUOTES.ID

Table CREDIT_CARDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ACCOUNT_ID uniqueidentifier ACCOUNTS.IDAccount ID
CONTACT_ID uniqueidentifier Contact ID
NAME nvarchar (150) Name
CARD_TYPE nvarchar (25) Card Type
CARD_NUMBER nvarchar (100) Card Number
CARD_NUMBER_DISPLAY nvarchar (10) Card Number Display
SECURITY_CODE nvarchar (10) Security Code
EXPIRATION_DATE datetime Expiration Date
BANK_NAME nvarchar (150) Bank Name
BANK_ROUTING_NUMBER nvarchar (100) Bank Routing Number
IS_PRIMARY bit Is Primary
IS_ENCRYPTED bit Is Encrypted
ADDRESS_STREET nvarchar (150) Street
ADDRESS_CITY nvarchar (100) City
ADDRESS_STATE nvarchar (100) State
ADDRESS_POSTALCODE nvarchar (20) Postal Code
ADDRESS_COUNTRY nvarchar (100) Country

Table CURRENCIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (36) Name
SYMBOL nvarchar (36) Symbol
ISO4217 nvarchar (3) ISO 4217 Code
CONVERSION_RATE float (53, 0) Conversion Rate
STATUS nvarchar (25) Status

Table CUSTOM_FIELDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
SET_NUM int
FIELD0 nvarchar (255)
FIELD1 nvarchar (255)
FIELD2 nvarchar (255)
FIELD3 nvarchar (255)
FIELD4 nvarchar (255)
FIELD5 nvarchar (255)
FIELD6 nvarchar (255)
FIELD7 nvarchar (255)
FIELD8 nvarchar (255)
FIELD9 nvarchar (255)

Table DASHBOARDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (100)
DESCRIPTION nvarchar (max)
CONTENT nvarchar (max)

Table DASHLETS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CATEGORY nvarchar (25)
MODULE_NAME nvarchar (50)
CONTROL_NAME nvarchar (100)
TITLE nvarchar (100)
DASHLET_ENABLED bit
ALLOW_MULTIPLE bit

Table DASHLETS_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
DETAIL_NAME nvarchar (50)
MODULE_NAME nvarchar (50)
CONTROL_NAME nvarchar (100)
DASHLET_ORDER int
DASHLET_ENABLED bit
TITLE nvarchar (100)

Table DETAILVIEWS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50)
MODULE_NAME nvarchar (25)
VIEW_NAME nvarchar (50)
LABEL_WIDTH nvarchar (10)
FIELD_WIDTH nvarchar (10)
DATA_COLUMNS int
PRE_LOAD_EVENT_ID uniqueidentifier
POST_LOAD_EVENT_ID uniqueidentifier
SCRIPT nvarchar (max)

Table DETAILVIEWS_FIELDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
DETAIL_NAME nvarchar (50)
FIELD_INDEX int
FIELD_TYPE nvarchar (25)
DEFAULT_VIEW bit
DATA_LABEL nvarchar (150)
DATA_FIELD nvarchar (100)
DATA_FORMAT nvarchar (100)
URL_FIELD nvarchar (max)
URL_FORMAT nvarchar (max)
URL_TARGET nvarchar (60)
LIST_NAME nvarchar (50)
COLSPAN int
MODULE_TYPE nvarchar (25)
TOOL_TIP nvarchar (150)
PARENT_FIELD nvarchar (30)

Table DETAILVIEWS_RELATIONSHIPS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
DETAIL_NAME nvarchar (50)
MODULE_NAME nvarchar (50)
CONTROL_NAME nvarchar (100)
RELATIONSHIP_ORDER int
RELATIONSHIP_ENABLED bit
TITLE nvarchar (100)
TABLE_NAME nvarchar (50)
PRIMARY_FIELD nvarchar (50)
SORT_FIELD nvarchar (50)
SORT_DIRECTION nvarchar (10)

Table DISCOUNTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (100) Name
PRICING_FORMULA nvarchar (25) Pricing Formula
PRICING_FACTOR float (53, 0) Pricing Factor

Table DOCUMENT_REVISIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CHANGE_LOG nvarchar (255)
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
FILENAME nvarchar (255)
FILE_EXT nvarchar (25)
FILE_MIME_TYPE nvarchar (100)
REVISION nvarchar (25)
CONTENT varbinary (max)

Table DOCUMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
DOCUMENT_NAME nvarchar (255) Document Name
ACTIVE_DATE datetime Active Date
EXP_DATE datetime Exp Date
DESCRIPTION nvarchar (max) Description
CATEGORY_ID nvarchar (25) Category ID
SUBCATEGORY_ID nvarchar (25) Subcategory ID
STATUS_ID nvarchar (25) Status ID
DOCUMENT_REVISION_ID uniqueidentifier Document Revision ID
MAIL_MERGE_DOCUMENT bit Mail Merge Document
RELATED_DOC_ID uniqueidentifier Related Doc ID
RELATED_DOC_REV_ID uniqueidentifier Related Doc Rev ID
IS_TEMPLATE bit Is Template
TEMPLATE_TYPE nvarchar (25) Document Type
PRIMARY_MODULE nvarchar (25) Primary Module
SECONDARY_MODULE nvarchar (25) Secondary Module
TEAM_SET_ID uniqueidentifier Team Set ID

Table DOCUMENTS_BUGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
BUG_ID uniqueidentifier BUGS.ID
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
DOCUMENT_REVISION_ID uniqueidentifier DOCUMENT_REVISIONS.ID

Table DOCUMENTS_CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CASE_ID uniqueidentifier CASES.ID
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
DOCUMENT_REVISION_ID uniqueidentifier DOCUMENT_REVISIONS.ID

Table DOCUMENTS_QUOTES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
QUOTE_ID uniqueidentifier QUOTES.ID
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
DOCUMENT_REVISION_ID uniqueidentifier DOCUMENT_REVISIONS.ID

Table DYNAMIC_BUTTONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
VIEW_NAME nvarchar (50) View Name
CONTROL_INDEX int Control Index
CONTROL_TYPE nvarchar (25) Control Type
DEFAULT_VIEW bit Default View
MODULE_NAME nvarchar (25) Module Name
MODULE_ACCESS_TYPE nvarchar (100) Module Access Type
TARGET_NAME nvarchar (25) Target Name
TARGET_ACCESS_TYPE nvarchar (100) Target Access Type
MOBILE_ONLY bit Mobile Only
ADMIN_ONLY bit Admin Only
EXCLUDE_MOBILE bit Exclude Mobile
HIDDEN bit Hidden
CONTROL_TEXT nvarchar (150) Control Text
CONTROL_TOOLTIP nvarchar (150) Control Tooltip
CONTROL_ACCESSKEY nvarchar (150) Control Accesskey
CONTROL_CSSCLASS nvarchar (50) Control Cssclass
TEXT_FIELD nvarchar (200) Text Field
ARGUMENT_FIELD nvarchar (200) Argument Field
COMMAND_NAME nvarchar (50) Command Name
URL_FORMAT nvarchar (255) Url Format
URL_TARGET nvarchar (20) Url Target
ONCLICK_SCRIPT nvarchar (255) Onclick Script

Table EDITVIEWS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50)
MODULE_NAME nvarchar (25)
VIEW_NAME nvarchar (50)
LABEL_WIDTH nvarchar (10)
FIELD_WIDTH nvarchar (10)
DATA_COLUMNS int
NEW_EVENT_ID uniqueidentifier
PRE_LOAD_EVENT_ID uniqueidentifier
POST_LOAD_EVENT_ID uniqueidentifier
VALIDATION_EVENT_ID uniqueidentifier
PRE_SAVE_EVENT_ID uniqueidentifier
POST_SAVE_EVENT_ID uniqueidentifier
SCRIPT nvarchar (max)

Table EDITVIEWS_FIELDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EDIT_NAME nvarchar (50)
FIELD_INDEX int
FIELD_TYPE nvarchar (25)
DEFAULT_VIEW bit
DATA_LABEL nvarchar (150)
DATA_FIELD nvarchar (100)
DATA_FORMAT nvarchar (100)
DISPLAY_FIELD nvarchar (100)
CACHE_NAME nvarchar (50)
DATA_REQUIRED bit
UI_REQUIRED bit
ONCLICK_SCRIPT nvarchar (max)
FORMAT_SCRIPT nvarchar (255)
FORMAT_TAB_INDEX int
FORMAT_MAX_LENGTH int
FORMAT_SIZE int
FORMAT_ROWS int
FORMAT_COLUMNS int
COLSPAN int
ROWSPAN int
FIELD_VALIDATOR_ID uniqueidentifier
FIELD_VALIDATOR_MESSAGE nvarchar (150)
MODULE_TYPE nvarchar (25)
TOOL_TIP nvarchar (150)
RELATED_SOURCE_MODULE_NAME nvarchar (50)
RELATED_SOURCE_VIEW_NAME nvarchar (50)
RELATED_SOURCE_ID_FIELD nvarchar (30)
RELATED_SOURCE_NAME_FIELD nvarchar (100)
RELATED_VIEW_NAME nvarchar (50)
RELATED_ID_FIELD nvarchar (30)
RELATED_NAME_FIELD nvarchar (100)
RELATED_JOIN_FIELD nvarchar (30)
PARENT_FIELD nvarchar (30)

Table EDITVIEWS_RELATIONSHIPS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EDIT_NAME nvarchar (50)
MODULE_NAME nvarchar (50)
CONTROL_NAME nvarchar (100)
RELATIONSHIP_ORDER int
RELATIONSHIP_ENABLED bit
NEW_RECORD_ENABLED bit
EXISTING_RECORD_ENABLED bit
TITLE nvarchar (100)
ALTERNATE_VIEW nvarchar (50)

Table EMAIL_IMAGES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
FILENAME nvarchar (255)
FILE_EXT nvarchar (25)
FILE_MIME_TYPE nvarchar (100)
CONTENT varbinary (max)

Table EMAIL_MARKETING

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (255) Name
FROM_ADDR nvarchar (100) From Email Address
FROM_NAME nvarchar (100) From Name
DATE_START datetime Start Date
TIME_START datetime Start Time
TEMPLATE_ID uniqueidentifier EMAIL_TEMPLATES.IDTemplate ID
CAMPAIGN_ID uniqueidentifier CAMPAIGNS.IDCampaign ID
INBOUND_EMAIL_ID uniqueidentifier Inbound Email ID
STATUS nvarchar (25) Status
ALL_PROSPECT_LISTS bit All Target Lists
REPLY_TO_NAME nvarchar (100) Reply-To Name
REPLY_TO_ADDR nvarchar (100) Reply-To Address

Table EMAIL_MARKETING_PROSPECT_LISTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROSPECT_LIST_ID uniqueidentifier PROSPECT_LISTS.ID
EMAIL_MARKETING_ID uniqueidentifier EMAIL_MARKETING.ID

Table EMAIL_TEMPLATES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
PUBLISHED bit Published
READ_ONLY bit Read Only
TEXT_ONLY bit Text Only
NAME nvarchar (255) Name
DESCRIPTION nvarchar (max) Description
SUBJECT nvarchar (255) Subject
BODY nvarchar (max) Body
BODY_HTML nvarchar (max) Body
TEAM_SET_ID uniqueidentifier Team Set ID

Table EMAILMAN

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAILMAN_NUMBER nvarchar (30) Email Manager Number
USER_ID uniqueidentifier USERS.IDUser ID
CAMPAIGN_ID uniqueidentifier CAMPAIGNS.IDCampaign ID
MARKETING_ID uniqueidentifier EMAIL_MARKETING.IDMarketing ID
LIST_ID uniqueidentifier List ID
SEND_DATE_TIME datetime Send Date Time
IN_QUEUE bit In Queue
IN_QUEUE_DATE datetime In Queue Date
SEND_ATTEMPTS int Send Attempts
RELATED_ID uniqueidentifier Related ID
RELATED_TYPE nvarchar (100) Related Type
INBOUND_EMAIL_ID uniqueidentifier Inbound Email ID

Table EMAILMAN_SENT

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_ID uniqueidentifier USERS.ID
TEMPLATE_ID uniqueidentifier EMAIL_TEMPLATES.ID
FROM_EMAIL nvarchar (255)
FROM_NAME nvarchar (255)
MODULE_ID uniqueidentifier
CAMPAIGN_ID uniqueidentifier CAMPAIGNS.ID
MARKETING_ID uniqueidentifier EMAIL_MARKETING.ID
LIST_ID uniqueidentifier ID
MODULE nvarchar (100)
SEND_DATE_TIME datetime
INVALID_EMAIL bit
IN_QUEUE bit
IN_QUEUE_DATE datetime
SEND_ATTEMPTS int

Table EMAILS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (255) Subject
DATE_START datetime Start Date
TIME_START datetime Start Time
PARENT_TYPE nvarchar (25) Parent Type
PARENT_ID uniqueidentifier Parent ID
DESCRIPTION nvarchar (max) Description
DESCRIPTION_HTML nvarchar (max) Description
FROM_ADDR nvarchar (100) From Email Address
FROM_NAME nvarchar (100) From Name
TO_ADDRS nvarchar (max) To
CC_ADDRS nvarchar (max) Cc Addrs
BCC_ADDRS nvarchar (max) Bcc Addrs
TO_ADDRS_IDS nvarchar (max) To Addrs Ids
TO_ADDRS_NAMES nvarchar (max) To Addrs Names
TO_ADDRS_EMAILS nvarchar (max) To Addrs Emails
CC_ADDRS_IDS nvarchar (max) Cc Addrs Ids
CC_ADDRS_NAMES nvarchar (max) Cc Addrs Names
CC_ADDRS_EMAILS nvarchar (max) Cc Addrs Emails
BCC_ADDRS_IDS nvarchar (max) Bcc Addrs Ids
BCC_ADDRS_NAMES nvarchar (max) Bcc Addrs Names
BCC_ADDRS_EMAILS nvarchar (max) Bcc Addrs Emails
TYPE nvarchar (25) Type
STATUS nvarchar (25) Status
MESSAGE_ID varchar (851) Message ID
REPLY_TO_NAME nvarchar (100) Reply To Name
REPLY_TO_ADDR nvarchar (100) Reply To Addr
INTENT nvarchar (25) Intent
MAILBOX_ID uniqueidentifier Mailbox ID
RAW_SOURCE nvarchar (max) Raw Source
TEAM_SET_ID uniqueidentifier Team Set ID

Table EMAILS_ACCOUNTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID

Table EMAILS_BUGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
BUG_ID uniqueidentifier BUGS.ID

Table EMAILS_CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
CASE_ID uniqueidentifier CASES.ID

Table EMAILS_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
CONTACT_ID uniqueidentifier CONTACTS.ID
CAMPAIGN_DATA nvarchar (max)

Table EMAILS_CONTRACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
CONTRACT_ID uniqueidentifier CONTRACTS.ID
CAMPAIGN_DATA nvarchar (max)

Table EMAILS_LEADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
LEAD_ID uniqueidentifier LEADS.ID
CAMPAIGN_DATA nvarchar (max)

Table EMAILS_OPPORTUNITIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID

Table EMAILS_ORDERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
ORDER_ID uniqueidentifier ORDERS.ID

Table EMAILS_PROJECT_TASKS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
PROJECT_TASK_ID uniqueidentifier PROJECT_TASK.ID

Table EMAILS_PROJECTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
PROJECT_ID uniqueidentifier PROJECT.ID

Table EMAILS_PROSPECTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
PROSPECT_ID uniqueidentifier PROSPECTS.ID
CAMPAIGN_DATA nvarchar (max)

Table EMAILS_QUOTES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
QUOTE_ID uniqueidentifier QUOTES.ID

Table EMAILS_TASKS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
TASK_ID uniqueidentifier TASKS.ID

Table EMAILS_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
EMAIL_ID uniqueidentifier EMAILS.ID
USER_ID uniqueidentifier USERS.ID
CAMPAIGN_DATA nvarchar (max)

Table EXCHANGE_FOLDERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
REMOTE_KEY varchar (800)
MODULE_NAME nvarchar (25)
PARENT_ID uniqueidentifier Parent ID
PARENT_NAME nvarchar (255)
WELL_KNOWN_FOLDER bit

Table EXCHANGE_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
EXCHANGE_ALIAS nvarchar (60)
EXCHANGE_EMAIL nvarchar (100)
EXCHANGE_WATERMARK varchar (100)

Table FEEDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TITLE nvarchar (100) Title
DESCRIPTION nvarchar (max) Description
URL nvarchar (255) URL
TEAM_SET_ID uniqueidentifier Team Set ID

Table FIELD_VALIDATORS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50) Name
VALIDATION_TYPE nvarchar (50) Validation Type
REGULAR_EXPRESSION nvarchar (2000) Regular Expression
DATA_TYPE nvarchar (25) Data Type
MININUM_VALUE nvarchar (255) Mininum Value
MAXIMUM_VALUE nvarchar (255) Maximum Value
COMPARE_OPERATOR nvarchar (25) Compare Operator

Table FIELDS_META_DATA

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (255)
LABEL nvarchar (255)
CUSTOM_MODULE nvarchar (255)
DATA_TYPE nvarchar (255)
MAX_SIZE int
REQUIRED_OPTION nvarchar (255)
DEFAULT_VALUE nvarchar (255)
EXT1 nvarchar (255)
EXT2 nvarchar (255)
EXT3 nvarchar (255)
AUDITED bit
MASS_UPDATE bit

Table FILES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
NAME nvarchar (255)
CONTENT varbinary (max)

Table FORECASTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TIMEPERIOD_ID uniqueidentifier
FORECAST_TYPE nvarchar (25)
OPP_COUNT int
OPP_WEIGH_VALUE int
BEST_CASE int
LIKELY_CASE int
WORST_CASE int
USER_ID uniqueidentifier

Table FORECASTS_OPPORTUNITIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
FORECAST_ID uniqueidentifier FORECASTS.ID
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID

Table FORUM_TOPICS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (150) Name
LIST_ORDER int List Order

Table FORUMS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TEAM_ID uniqueidentifier Team ID
TITLE nvarchar (150) Title
CATEGORY nvarchar (150) Topic
THREADCOUNT int Threads
THREADANDPOSTCOUNT int Posts
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table GRIDVIEWS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50)
MODULE_NAME nvarchar (25)
VIEW_NAME nvarchar (50)
PRE_LOAD_EVENT_ID uniqueidentifier
POST_LOAD_EVENT_ID uniqueidentifier
SCRIPT nvarchar (max)

Table GRIDVIEWS_COLUMNS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
GRID_NAME nvarchar (50)
COLUMN_INDEX int
COLUMN_TYPE nvarchar (25)
DEFAULT_VIEW bit
HEADER_TEXT nvarchar (150)
SORT_EXPRESSION nvarchar (50)
ITEMSTYLE_WIDTH nvarchar (10)
ITEMSTYLE_CSSCLASS nvarchar (50)
ITEMSTYLE_HORIZONTAL_ALIGN nvarchar (10)
ITEMSTYLE_VERTICAL_ALIGN nvarchar (10)
ITEMSTYLE_WRAP bit
DATA_FIELD nvarchar (50)
DATA_FORMAT nvarchar (25)
URL_FIELD nvarchar (max)
URL_FORMAT nvarchar (max)
URL_TARGET nvarchar (60)
LIST_NAME nvarchar (50)
URL_MODULE nvarchar (25)
URL_ASSIGNED_FIELD nvarchar (30)
MODULE_TYPE nvarchar (25)
PARENT_FIELD nvarchar (30)

Table IFRAMES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (255) Name
URL nvarchar (255) URL
TYPE nvarchar (255) Type
PLACEMENT nvarchar (255) Placement
STATUS bit Status

Table IMAGES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
FILENAME nvarchar (255)
FILE_EXT nvarchar (25)
FILE_MIME_TYPE nvarchar (100)
CONTENT varbinary (max)

Table IMPORT_MAPS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
NAME nvarchar (150)
SOURCE nvarchar (25)
MODULE nvarchar (25)
HAS_HEADER bit
IS_PUBLISHED bit
CONTENT nvarchar (max)
RULES_XML nvarchar (max)

Table INBOUND_EMAIL_AUTOREPLY

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
AUTOREPLIED_TO nvarchar (100)
AUTOREPLIED_NAME nvarchar (100)

Table INBOUND_EMAILS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (255) Name
STATUS nvarchar (25) Status
SERVER_URL nvarchar (100) Mail Server
EMAIL_USER nvarchar (100) Email User
EMAIL_PASSWORD nvarchar (100) Email Password
PORT int Port
MAILBOX_SSL bit Use SSL
SERVICE nvarchar (50) Service
MAILBOX nvarchar (50) Mailbox
DELETE_SEEN bit Delete Seen
ONLY_SINCE bit Only Since
MAILBOX_TYPE nvarchar (10) Mailbox Type
TEMPLATE_ID uniqueidentifier Template ID
STORED_OPTIONS nvarchar (max) Stored Options
GROUP_ID uniqueidentifier Group ID
FROM_NAME nvarchar (100) From Name
FROM_ADDR nvarchar (100) From Email Address
FILTER_DOMAIN nvarchar (100) Filter Domain
IS_PERSONAL bit
REPLY_TO_NAME nvarchar (100) Reply-To Name
REPLY_TO_ADDR nvarchar (100) Reply-To Address

Table INVOICES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
QUOTE_ID uniqueidentifier Quote ID
ORDER_ID uniqueidentifier Order ID
OPPORTUNITY_ID uniqueidentifier Opportunity ID
INVOICE_NUM nvarchar (30) Invoice Number
NAME nvarchar (150) Name
PAYMENT_TERMS nvarchar (25) Payment Terms
INVOICE_STAGE nvarchar (25) Invoice Stage
PURCHASE_ORDER_NUM nvarchar (50) Purchase Order Num
DUE_DATE datetime Due Date
EXCHANGE_RATE float (53, 0) Exchange Rate
CURRENCY_ID uniqueidentifier Currency ID
TAXRATE_ID uniqueidentifier TAX_RATES.IDTaxrate ID
SHIPPER_ID uniqueidentifier SHIPPERS.IDShipper ID
SUBTOTAL money (19, 4) Subtotal
SUBTOTAL_USDOLLAR money (19, 4) Subtotal US Dollar
DISCOUNT money (19, 4) Discount
DISCOUNT_USDOLLAR money (19, 4) Discount US Dollar
SHIPPING money (19, 4) Shipping
SHIPPING_USDOLLAR money (19, 4) Shipping US Dollar
TAX money (19, 4) Tax
TAX_USDOLLAR money (19, 4) Tax US Dollar
TOTAL money (19, 4) Total
TOTAL_USDOLLAR money (19, 4) Total US Dollar
AMOUNT_DUE money (19, 4) Amount Due
AMOUNT_DUE_USDOLLAR money (19, 4) Amount Due US Dollar
BILLING_ADDRESS_STREET nvarchar (150) Billing Street
BILLING_ADDRESS_CITY nvarchar (100) Billing City
BILLING_ADDRESS_STATE nvarchar (100) Billing State
BILLING_ADDRESS_POSTALCODE nvarchar (20) Billing Postal Code
BILLING_ADDRESS_COUNTRY nvarchar (100) Billing Country
SHIPPING_ADDRESS_STREET nvarchar (150) Shipping Street
SHIPPING_ADDRESS_CITY nvarchar (100) Shipping City
SHIPPING_ADDRESS_STATE nvarchar (100) Shipping State
SHIPPING_ADDRESS_POSTALCODE nvarchar (20) Shipping Postal Code
SHIPPING_ADDRESS_COUNTRY nvarchar (100) Shipping Country
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table INVOICES_ACCOUNTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
INVOICE_ID uniqueidentifier INVOICES.ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID
ACCOUNT_ROLE nvarchar (25)

Table INVOICES_CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
INVOICE_ID uniqueidentifier INVOICES.ID
CASE_ID uniqueidentifier CASES.ID

Table INVOICES_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
INVOICE_ID uniqueidentifier INVOICES.ID
CONTACT_ID uniqueidentifier CONTACTS.ID
CONTACT_ROLE nvarchar (25)

Table INVOICES_LINE_ITEMS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
INVOICE_ID uniqueidentifier INVOICES.IDInvoice ID
LINE_GROUP_ID uniqueidentifier Line Group ID
LINE_ITEM_TYPE nvarchar (25) Line Item Type
POSITION int Position
NAME nvarchar (100) Name
MFT_PART_NUM nvarchar (50) Mft Part Num
VENDOR_PART_NUM nvarchar (50) Vendor Part Num
PRODUCT_TEMPLATE_ID uniqueidentifier Product Template ID
PARENT_TEMPLATE_ID uniqueidentifier Parent Template ID
TAX_CLASS nvarchar (25) Tax Class
QUANTITY float (53, 0) Quantity
COST_PRICE money (19, 4) Cost
COST_USDOLLAR money (19, 4) Cost US Dollar
LIST_PRICE money (19, 4) List Price
LIST_USDOLLAR money (19, 4) List US Dollar
UNIT_PRICE money (19, 4) Unit Price
UNIT_USDOLLAR money (19, 4) Unit US Dollar
TAXRATE_ID uniqueidentifier Tax Rate
TAX money (19, 4) Tax
TAX_USDOLLAR money (19, 4) Tax US Dollar
EXTENDED_PRICE money (19, 4) Extended Price
EXTENDED_USDOLLAR money (19, 4) Extended US Dollar
DISCOUNT_ID uniqueidentifier Discount ID
PRICING_FORMULA nvarchar (25) Pricing Formula
PRICING_FACTOR float (53, 0) Pricing Factor
DISCOUNT_PRICE money (19, 4) Discount Price
DISCOUNT_USDOLLAR money (19, 4) Discount US Dollar
DESCRIPTION nvarchar (max) Description

Table INVOICES_PAYMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
INVOICE_ID uniqueidentifier INVOICES.ID
PAYMENT_ID uniqueidentifier PAYMENTS.ID
AMOUNT money (19, 4)
AMOUNT_USDOLLAR money (19, 4)

Table KBDOCUMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (255) Name
KBDOC_APPROVER_ID uniqueidentifier Approver
IS_EXTERNAL_ARTICLE bit Is External Article
ACTIVE_DATE datetime Active Date
EXP_DATE datetime Expiration Date
STATUS nvarchar (25) Status
REVISION nvarchar (25) Revision
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID
KBTAG_SET_LIST nvarchar (max) Tag

Table KBDOCUMENTS_CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
KBDOCUMENT_ID uniqueidentifier KBDOCUMENTS.ID
CASE_ID uniqueidentifier CASES.ID

Table KBDOCUMENTS_KBTAGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
KBDOCUMENT_ID uniqueidentifier KBDOCUMENTS.ID
KBTAG_ID uniqueidentifier KBTAGS.ID

Table KBTAGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_TAG_ID uniqueidentifier Parent Tag ID
TAG_NAME nvarchar (100) Tag Name
FULL_TAG_NAME nvarchar (max) Full Tag Name

Table LANGUAGES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (10) Language
LCID int LCID
ACTIVE bit Active
NATIVE_NAME nvarchar (80) Native Name
DISPLAY_NAME nvarchar (80) Display Name

Table LAST_ACTIVITY

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ACTIVITY_TYPE nvarchar (25)
ACTIVITY_ID uniqueidentifier
LAST_ACTIVITY_DATE datetime Last Activity Date

Table LEADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
CONVERTED bit Converted
SALUTATION nvarchar (25) Salutation
FIRST_NAME nvarchar (100) First Name
LAST_NAME nvarchar (100) Last Name
TITLE nvarchar (100) Title
REFERED_BY nvarchar (100) Referred By
LEAD_SOURCE nvarchar (100) Lead Source
LEAD_SOURCE_DESCRIPTION nvarchar (max) Lead Source Description
STATUS nvarchar (100) Status
STATUS_DESCRIPTION nvarchar (max) Status Description
DEPARTMENT nvarchar (100) Department
REPORTS_TO_ID uniqueidentifier Reports To ID
BIRTHDATE datetime
DO_NOT_CALL bit Do Not Call
PHONE_HOME nvarchar (25) Phone Home
PHONE_MOBILE nvarchar (25) Phone Mobile
PHONE_WORK nvarchar (25) Phone Work
PHONE_OTHER nvarchar (25) Phone Other
PHONE_FAX nvarchar (25) Phone Fax
EMAIL1 nvarchar (100) Email
EMAIL2 nvarchar (100) Other Email
ASSISTANT nvarchar (75) Assistant
ASSISTANT_PHONE nvarchar (25) Assistant Phone
WEBSITE nvarchar (255) Website
EMAIL_OPT_OUT bit Email Opt Out
INVALID_EMAIL bit Invalid Email
SMS_OPT_IN nvarchar (25) SMS Opt In
TWITTER_SCREEN_NAME nvarchar (20) Twitter Screen Name
PRIMARY_ADDRESS_STREET nvarchar (150) Primary Street
PRIMARY_ADDRESS_CITY nvarchar (100) Primary City
PRIMARY_ADDRESS_STATE nvarchar (100) Primary State
PRIMARY_ADDRESS_POSTALCODE nvarchar (20) Primary Postal Code
PRIMARY_ADDRESS_COUNTRY nvarchar (100) Primary Country
ALT_ADDRESS_STREET nvarchar (150) Alternate Street
ALT_ADDRESS_CITY nvarchar (100) Alternate City
ALT_ADDRESS_STATE nvarchar (100) Alternate State
ALT_ADDRESS_POSTALCODE nvarchar (20) Alternate Postal Code
ALT_ADDRESS_COUNTRY nvarchar (100) Alternate Country
DESCRIPTION nvarchar (max) Description
ACCOUNT_NAME nvarchar (150) Account Name
ACCOUNT_DESCRIPTION nvarchar (max) Account Description
CONTACT_ID uniqueidentifier Contact ID
ACCOUNT_ID uniqueidentifier Account ID
OPPORTUNITY_ID uniqueidentifier Opportunity ID
OPPORTUNITY_NAME nvarchar (255) Opportunity Name
OPPORTUNITY_AMOUNT nvarchar (50) Opportunity Amount
PORTAL_NAME nvarchar (255) Portal Name
PORTAL_APP nvarchar (255) Portal App
CAMPAIGN_ID uniqueidentifier Campaign ID
TEAM_SET_ID uniqueidentifier Team Set ID

Table LEADS_DOCUMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
LEAD_ID uniqueidentifier LEADS.ID
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
DOCUMENT_REVISION_ID uniqueidentifier DOCUMENT_REVISIONS.ID

Table LEADS_THREADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
LEAD_ID uniqueidentifier LEADS.ID
THREAD_ID uniqueidentifier THREADS.ID

Table LEADS_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
LEAD_ID uniqueidentifier LEADS.ID
USER_ID uniqueidentifier USERS.ID

Table LINKED_DOCUMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
PARENT_TYPE nvarchar (25)
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
DOCUMENT_REVISION_ID uniqueidentifier DOCUMENT_REVISIONS.ID

Table MANUFACTURERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50) Name
STATUS nvarchar (25) Status
LIST_ORDER int List Order

Table MEETINGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (150) Subject
LOCATION nvarchar (50) Location
DURATION_HOURS int Duration Hours
DURATION_MINUTES int Duration Minutes
DATE_START datetime Start Date
TIME_START datetime Start Time
DATE_END datetime End Date
STATUS nvarchar (25) Status
PARENT_TYPE nvarchar (25) Parent Type
PARENT_ID uniqueidentifier Parent ID
REMINDER_TIME int Reminder Time
DESCRIPTION nvarchar (max) Description
OUTLOOK_ID nvarchar (255) Outlook ID
TEAM_SET_ID uniqueidentifier Team Set ID
EMAIL_REMINDER_TIME int Email Reminder Time
SMS_REMINDER_TIME int SMS Reminder Time
REPEAT_TYPE nvarchar (25) Repeat Type
REPEAT_INTERVAL int Repeat Interval
REPEAT_DOW nvarchar (7) Days of the Week
REPEAT_UNTIL datetime Repeat Until
REPEAT_COUNT int Repeat Count
REPEAT_PARENT_ID uniqueidentifier Repeat Parent ID
RECURRING_SOURCE nvarchar (25) Recurring Source
ALL_DAY_EVENT bit

Table MEETINGS_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
MEETING_ID uniqueidentifier MEETINGS.ID
CONTACT_ID uniqueidentifier CONTACTS.ID
REQUIRED bit
ACCEPT_STATUS nvarchar (25)
EMAIL_REMINDER_SENT bit
SMS_REMINDER_SENT bit

Table MEETINGS_LEADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
MEETING_ID uniqueidentifier MEETINGS.ID
LEAD_ID uniqueidentifier LEADS.ID
REQUIRED bit
ACCEPT_STATUS nvarchar (25)
EMAIL_REMINDER_SENT bit
SMS_REMINDER_SENT bit

Table MEETINGS_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
MEETING_ID uniqueidentifier MEETINGS.ID
USER_ID uniqueidentifier USERS.ID
REQUIRED bit
ACCEPT_STATUS nvarchar (25)
REMINDER_DISMISSED bit
EMAIL_REMINDER_SENT bit
SMS_REMINDER_SENT bit

Table MODULES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
MODULE_NAME nvarchar (25) Module Name
DISPLAY_NAME nvarchar (50) Display Name
RELATIVE_PATH nvarchar (50) Relative Path
MODULE_ENABLED bit Module Enabled
TAB_ENABLED bit Tab Enabled
MOBILE_ENABLED bit Mobile Enabled
TAB_ORDER int Tab Order
PORTAL_ENABLED bit Portal Enabled
CUSTOM_ENABLED bit Custom Enabled
REPORT_ENABLED bit Report Enabled
IMPORT_ENABLED bit Import Enabled
SYNC_ENABLED bit Sync Enabled
REST_ENABLED bit REST Enabled
IS_ADMIN bit Is Admin
CUSTOM_PAGING bit Custom Paging
MASS_UPDATE_ENABLED bit Mass Update Enabled
DEFAULT_SEARCH_ENABLED bit Default Search
TABLE_NAME nvarchar (30) Table Name
EXCHANGE_SYNC bit Exchange Sync
EXCHANGE_FOLDERS bit Exchange Folders
EXCHANGE_CREATE_PARENT bit Exchange Create Parent
DUPLICATE_CHECHING_ENABLED bit Duplicate Checking Enabled

Table MODULES_GROUPS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
GROUP_NAME nvarchar (25)
MODULE_NAME nvarchar (50)
MODULE_ORDER int
MODULE_MENU bit

Table NOTE_ATTACHMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
DESCRIPTION nvarchar (255)
NOTE_ID uniqueidentifier
FILENAME nvarchar (255)
FILE_EXT nvarchar (25)
FILE_MIME_TYPE nvarchar (100)
ATTACHMENT varbinary (max)

Table NOTES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (255) Subject
FILENAME nvarchar (255) Filename
FILE_MIME_TYPE nvarchar (100) File Mime Type
PARENT_TYPE nvarchar (25) Parent Type
PARENT_ID uniqueidentifier Parent ID
CONTACT_ID uniqueidentifier Contact ID
PORTAL_FLAG bit Display in Portal
EMBED_FLAG bit Embed in email
DESCRIPTION nvarchar (max) Description
NOTE_ATTACHMENT_ID uniqueidentifier Note Attachment ID
TEAM_SET_ID uniqueidentifier Team Set ID

Table NUMBER_SEQUENCES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (60) Name
ALPHA_PREFIX nvarchar (10) Alpha Prefix
ALPHA_SUFFIX nvarchar (10) Alpha Suffix
SEQUENCE_STEP int Sequence Step
NUMERIC_PADDING int Numeric Padding
CURRENT_VALUE int Current Value

Table OAUTH_TOKENS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
NAME nvarchar (25)
TOKEN nvarchar (200)
SECRET nvarchar (50)

Table OAUTHKEYS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
NAME nvarchar (25)
TOKEN nvarchar (200)
SECRET nvarchar (50)
VERIFIER nvarchar (50)

Table OPPORTUNITIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (150) Name
OPPORTUNITY_TYPE nvarchar (255) Opportunity Type
LEAD_SOURCE nvarchar (50) Lead Source
AMOUNT money (19, 4) Amount
AMOUNT_BACKUP nvarchar (25) Amount Backup
AMOUNT_USDOLLAR money (19, 4) Amount US Dollar
CURRENCY_ID uniqueidentifier Currency ID
DATE_CLOSED datetime Date Closed
NEXT_STEP nvarchar (100) Next Step
SALES_STAGE nvarchar (25) Sales Stage
PROBABILITY float (53, 0) Probability(%)
DESCRIPTION nvarchar (max) Description
CAMPAIGN_ID uniqueidentifier Campaign ID
TEAM_SET_ID uniqueidentifier Team Set ID
B2C_CONTACT_ID uniqueidentifier Contact ID

Table OPPORTUNITIES_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
CONTACT_ID uniqueidentifier CONTACTS.ID
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID
CONTACT_ROLE nvarchar (50)

Table OPPORTUNITIES_DOCUMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID
DOCUMENT_ID uniqueidentifier DOCUMENTS.ID
DOCUMENT_REVISION_ID uniqueidentifier DOCUMENT_REVISIONS.ID

Table OPPORTUNITIES_THREADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
THREAD_ID uniqueidentifier THREADS.ID
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID

Table OPPORTUNITIES_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID
USER_ID uniqueidentifier USERS.ID

Table ORDERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
QUOTE_ID uniqueidentifier Quote ID
ORDER_NUM nvarchar (30) Order Number
NAME nvarchar (150) Name
PAYMENT_TERMS nvarchar (25) Payment Terms
ORDER_STAGE nvarchar (25) Order Stage
PURCHASE_ORDER_NUM nvarchar (50) Purchase Order Num
ORIGINAL_PO_DATE datetime Original P.O. Date
DATE_ORDER_DUE datetime Date Order Due
DATE_ORDER_SHIPPED datetime Date Order Shipped
SHOW_LINE_NUMS bit Show Line Nums
CALC_GRAND_TOTAL bit Calc Grand Total
EXCHANGE_RATE float (53, 0) Exchange Rate
CURRENCY_ID uniqueidentifier Currency ID
TAXRATE_ID uniqueidentifier TAX_RATES.IDTaxrate ID
SHIPPER_ID uniqueidentifier SHIPPERS.IDShipper ID
SUBTOTAL money (19, 4) Subtotal
SUBTOTAL_USDOLLAR money (19, 4) Subtotal US Dollar
DISCOUNT money (19, 4) Discount
DISCOUNT_USDOLLAR money (19, 4) Discount US Dollar
SHIPPING money (19, 4) Shipping
SHIPPING_USDOLLAR money (19, 4) Shipping US Dollar
TAX money (19, 4) Tax
TAX_USDOLLAR money (19, 4) Tax US Dollar
TOTAL money (19, 4) Total
TOTAL_USDOLLAR money (19, 4) Total US Dollar
BILLING_ADDRESS_STREET nvarchar (150) Billing Street
BILLING_ADDRESS_CITY nvarchar (100) Billing City
BILLING_ADDRESS_STATE nvarchar (100) Billing State
BILLING_ADDRESS_POSTALCODE nvarchar (20) Billing Postal Code
BILLING_ADDRESS_COUNTRY nvarchar (100) Billing Country
SHIPPING_ADDRESS_STREET nvarchar (150) Shipping Street
SHIPPING_ADDRESS_CITY nvarchar (100) Shipping City
SHIPPING_ADDRESS_STATE nvarchar (100) Shipping State
SHIPPING_ADDRESS_POSTALCODE nvarchar (20) Shipping Postal Code
SHIPPING_ADDRESS_COUNTRY nvarchar (100) Shipping Country
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table ORDERS_ACCOUNTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ORDER_ID uniqueidentifier ORDERS.ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID
ACCOUNT_ROLE nvarchar (25)

Table ORDERS_CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ORDER_ID uniqueidentifier ORDERS.ID
CASE_ID uniqueidentifier CASES.ID

Table ORDERS_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ORDER_ID uniqueidentifier ORDERS.ID
CONTACT_ID uniqueidentifier CONTACTS.ID
CONTACT_ROLE nvarchar (25)

Table ORDERS_LINE_ITEMS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ORDER_ID uniqueidentifier ORDERS.IDOrder ID
LINE_GROUP_ID uniqueidentifier Line Group ID
LINE_ITEM_TYPE nvarchar (25) Line Item Type
POSITION int Position
NAME nvarchar (100) Name
MFT_PART_NUM nvarchar (50) Mft Part Num
VENDOR_PART_NUM nvarchar (50) Vendor Part Num
PRODUCT_TEMPLATE_ID uniqueidentifier Product Template ID
PARENT_TEMPLATE_ID uniqueidentifier Parent Template ID
TAX_CLASS nvarchar (25) Tax Class
QUANTITY float (53, 0) Quantity
COST_PRICE money (19, 4) Cost
COST_USDOLLAR money (19, 4) Cost US Dollar
LIST_PRICE money (19, 4) List Price
LIST_USDOLLAR money (19, 4) List US Dollar
UNIT_PRICE money (19, 4) Unit Price
UNIT_USDOLLAR money (19, 4) Unit US Dollar
TAXRATE_ID uniqueidentifier Tax Rate
TAX money (19, 4) Tax
TAX_USDOLLAR money (19, 4) Tax US Dollar
EXTENDED_PRICE money (19, 4) Extended Price
EXTENDED_USDOLLAR money (19, 4) Extended US Dollar
DISCOUNT_ID uniqueidentifier Discount ID
PRICING_FORMULA nvarchar (25) Pricing Formula
PRICING_FACTOR float (53, 0) Pricing Factor
DISCOUNT_PRICE money (19, 4) Discount Price
DISCOUNT_USDOLLAR money (19, 4) Discount US Dollar
DESCRIPTION nvarchar (max) Description
SERIAL_NUMBER nvarchar (50) Serial Number
ASSET_NUMBER nvarchar (50) Asset Number
DATE_ORDER_SHIPPED datetime Date Order Shipped
DATE_SUPPORT_EXPIRES datetime Date Support Expires
DATE_SUPPORT_STARTS datetime Date Support Starts
SUPPORT_NAME nvarchar (50) Support Name
SUPPORT_CONTACT nvarchar (50) Support Contact
SUPPORT_TERM nvarchar (25) Support Term
SUPPORT_DESCRIPTION nvarchar (max) Support Description

Table ORDERS_OPPORTUNITIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ORDER_ID uniqueidentifier ORDERS.ID
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID

Table OUTBOUND_EMAILS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50) Name
TYPE nvarchar (15) Type
USER_ID uniqueidentifier User ID
MAIL_SENDTYPE nvarchar (8) Send Type
MAIL_SMTPTYPE nvarchar (20) SMTP Type
MAIL_SMTPSERVER nvarchar (100) SMTP Server
MAIL_SMTPPORT int Port
MAIL_SMTPUSER nvarchar (100) Login
MAIL_SMTPPASS nvarchar (100) Password
MAIL_SMTPAUTH_REQ bit Use SMTP Authentication?
MAIL_SMTPSSL int Enable SMTP over SSL
FROM_NAME nvarchar (100) From Name
FROM_ADDR nvarchar (100) From Email Address

Table OUTBOUND_SMS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (60) Name
USER_ID uniqueidentifier User ID
FROM_NUMBER nvarchar (100) From Number

Table PAYMENT_GATEWAYS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50) Name
GATEWAY nvarchar (25) Gateway
LOGIN nvarchar (50) Login
PASSWORD nvarchar (100) Password
TEST_MODE bit Test Mode
DESCRIPTION nvarchar (max) Description

Table PAYMENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.IDAccount ID
B2C_CONTACT_ID uniqueidentifier Contact ID
PAYMENT_NUM nvarchar (30) Payment Number
PAYMENT_DATE datetime Payment Date
PAYMENT_TYPE nvarchar (25) Payment Type
CUSTOMER_REFERENCE nvarchar (50) Customer Reference
EXCHANGE_RATE float (53, 0) Exchange Rate
CURRENCY_ID uniqueidentifier Currency ID
AMOUNT money (19, 4) Amount
AMOUNT_USDOLLAR money (19, 4) Amount US Dollar
BANK_FEE money (19, 4) Bank Fee
BANK_FEE_USDOLLAR money (19, 4) Bank Fee US Dollar
CREDIT_CARD_ID uniqueidentifier Credit Card ID
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table PAYMENTS_TRANSACTIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PAYMENT_ID uniqueidentifier
PAYMENT_GATEWAY nvarchar (25)
TRANSACTION_TYPE nvarchar (25)
AMOUNT money (19, 4)
CURRENCY_ID uniqueidentifier
INVOICE_NUMBER nvarchar (400)
DESCRIPTION nvarchar (max)
CREDIT_CARD_ID uniqueidentifier
CARD_NAME nvarchar (150)
CARD_TYPE nvarchar (25)
CARD_NUMBER_DISPLAY nvarchar (10)
BANK_NAME nvarchar (150)
ACCOUNT_ID uniqueidentifier
ADDRESS_STREET nvarchar (150)
ADDRESS_CITY nvarchar (100)
ADDRESS_STATE nvarchar (100)
ADDRESS_POSTALCODE nvarchar (20)
ADDRESS_COUNTRY nvarchar (100)
EMAIL nvarchar (100)
PHONE nvarchar (25)
STATUS nvarchar (25)
TRANSACTION_NUMBER nvarchar (50)
REFERENCE_NUMBER nvarchar (50)
AUTHORIZATION_CODE nvarchar (50)
AVS_CODE nvarchar (250)
ERROR_CODE nvarchar (20)
ERROR_MESSAGE nvarchar (max)

Table PHONE_NUMBERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
PARENT_TYPE nvarchar (25)
PHONE_TYPE nvarchar (25)
NORMALIZED_NUMBER nvarchar (50)

Table POSTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
THREAD_ID uniqueidentifier THREADS.IDThread ID
TITLE nvarchar (255) Title
DESCRIPTION_HTML nvarchar (max) Description

Table PRODUCT_BUNDLE_NOTES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
DESCRIPTION nvarchar (max)

Table PRODUCT_BUNDLE_QUOTE

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
BUNDLE_ID uniqueidentifier PRODUCT_BUNDLES.ID
QUOTE_ID uniqueidentifier QUOTES.ID

Table PRODUCT_BUNDLES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (150)
BUNDLE_STAGE nvarchar (25)
CURRENCY_ID uniqueidentifier
SUBTOTAL money (19, 4)
SUBTOTAL_USDOLLAR money (19, 4)
TAX money (19, 4)
TAX_USDOLLAR money (19, 4)
SHIPPING money (19, 4)
SHIPPING_USDOLLAR money (19, 4)
TOTAL money (19, 4)
TOTAL_USDOLLAR money (19, 4)
DESCRIPTION nvarchar (max)

Table PRODUCT_CATEGORIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
NAME nvarchar (50) Name
DESCRIPTION nvarchar (max) Description
LIST_ORDER int List Order

Table PRODUCT_PRODUCT

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
CHILD_ID uniqueidentifier

Table PRODUCT_TEMPLATES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (100) Name
STATUS nvarchar (25) Status
QUANTITY int Quantity
DATE_AVAILABLE datetime Date Available
DATE_COST_PRICE datetime Date-Cost-Price
ACCOUNT_ID uniqueidentifier ACCOUNTS.IDAccount ID
MANUFACTURER_ID uniqueidentifier MANUFACTURERS.IDManufacturer ID
CATEGORY_ID uniqueidentifier PRODUCT_CATEGORIES.IDCategory ID
TYPE_ID uniqueidentifier PRODUCT_TYPES.IDType ID
WEBSITE nvarchar (255) Website
MFT_PART_NUM nvarchar (100) Mft Part Num
VENDOR_PART_NUM nvarchar (100) Vendor Part Num
TAX_CLASS nvarchar (25) Tax Class
TAXRATE_ID uniqueidentifier Tax Rate
WEIGHT float (53, 0) Weight
MINIMUM_OPTIONS int Minimum Options
MAXIMUM_OPTIONS int Maximum Options
QUICKBOOKS_ACCOUNT nvarchar (50) QuickBooks Account
CURRENCY_ID uniqueidentifier Currency ID
COST_PRICE money (19, 4) Cost
COST_USDOLLAR money (19, 4) Cost US Dollar
LIST_PRICE money (19, 4) List Price
LIST_USDOLLAR money (19, 4) List US Dollar
DISCOUNT_PRICE money (19, 4) Discount Price
DISCOUNT_USDOLLAR money (19, 4) Discount US Dollar
PRICING_FACTOR float (53, 0) Pricing Factor
PRICING_FORMULA nvarchar (25) Pricing Formula
DISCOUNT_ID uniqueidentifier Discount ID
SUPPORT_NAME nvarchar (50) Support Name
SUPPORT_CONTACT nvarchar (50) Support Contact
SUPPORT_DESCRIPTION nvarchar (255) Support Description
SUPPORT_TERM nvarchar (25) Support Term
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table PRODUCT_TYPES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50) Name
DESCRIPTION nvarchar (max) Description
LIST_ORDER int List Order

Table PRODUCTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TEAM_ID uniqueidentifier Team ID
PRODUCT_TEMPLATE_ID uniqueidentifier PRODUCT_TEMPLATES.IDProduct Template ID
NAME nvarchar (50) Name
STATUS nvarchar (25) Status
QUOTE_ID uniqueidentifier QUOTES.IDQuote ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.IDAccount ID
CONTACT_ID uniqueidentifier CONTACTS.IDContact ID
QUANTITY int Quantity
DATE_PURCHASED datetime Date Purchased
DATE_SUPPORT_EXPIRES datetime Date Support Expires
DATE_SUPPORT_STARTS datetime Date Support Starts
MANUFACTURER_ID uniqueidentifier MANUFACTURERS.IDManufacturer ID
CATEGORY_ID uniqueidentifier PRODUCT_CATEGORIES.IDCategory ID
TYPE_ID uniqueidentifier PRODUCT_TYPES.IDType ID
WEBSITE nvarchar (255) Website
MFT_PART_NUM nvarchar (50) Mft Part Num
VENDOR_PART_NUM nvarchar (50) Vendor Part Num
SERIAL_NUMBER nvarchar (50) Serial Number
ASSET_NUMBER nvarchar (50) Asset Number
TAX_CLASS nvarchar (25) Tax Class
WEIGHT float (53, 0) Weight
CURRENCY_ID uniqueidentifier Currency ID
COST_PRICE money (19, 4) Cost
COST_USDOLLAR money (19, 4) Cost US Dollar
LIST_PRICE money (19, 4) List Price
LIST_USDOLLAR money (19, 4) List US Dollar
BOOK_VALUE money (19, 4) Book Value
BOOK_VALUE_DATE datetime Book Value Date
DISCOUNT_PRICE money (19, 4) Discount Price
DISCOUNT_USDOLLAR money (19, 4) Discount US Dollar
PRICING_FACTOR float (53, 0) Pricing Factor
PRICING_FORMULA nvarchar (25) Pricing Formula
SUPPORT_NAME nvarchar (50) Support Name
SUPPORT_CONTACT nvarchar (50) Support Contact
SUPPORT_DESCRIPTION nvarchar (255) Support Description
SUPPORT_TERM nvarchar (25) Support Term
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table PROJECT

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (50) Name
ESTIMATED_START_DATE datetime Start Date
ESTIMATED_END_DATE datetime End Date
STATUS nvarchar (25) Status
PRIORITY nvarchar (25) Priority
IS_TEMPLATE bit Is Template
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table PROJECT_RELATION

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROJECT_ID uniqueidentifier PROJECT.ID
RELATION_TYPE nvarchar (25)
RELATION_ID uniqueidentifier

Table PROJECT_TASK

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (50) Name
STATUS nvarchar (25) Status
DATE_DUE datetime Due Date
TIME_DUE datetime Time Due
DATE_START datetime Start Date
TIME_START datetime Start Time
PARENT_ID uniqueidentifier Parent ID
PRIORITY nvarchar (25) Priority
DESCRIPTION nvarchar (max) Description
ORDER_NUMBER int Order Number
TASK_NUMBER int Task Number
DEPENDS_ON_ID uniqueidentifier Depends On
MILESTONE_FLAG bit Milestone
ESTIMATED_EFFORT float (53, 0) Estimated Effort (hrs)
ACTUAL_EFFORT float (53, 0) Actual Effort (hrs)
UTILIZATION int Utilization (%)
PERCENT_COMPLETE int Progress (%)
TEAM_SET_ID uniqueidentifier Team Set ID

Table PROJECT_THREADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROJECT_ID uniqueidentifier PROJECT.ID
THREAD_ID uniqueidentifier THREADS.ID

Table PROJECT_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROJECT_ID uniqueidentifier PROJECT.ID
USER_ID uniqueidentifier USERS.ID

Table PROJECTS_ACCOUNTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROJECT_ID uniqueidentifier PROJECT.ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID

Table PROJECTS_BUGS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROJECT_ID uniqueidentifier PROJECT.ID
BUG_ID uniqueidentifier BUGS.ID

Table PROJECTS_CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROJECT_ID uniqueidentifier PROJECT.ID
CASE_ID uniqueidentifier CASES.ID

Table PROJECTS_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROJECT_ID uniqueidentifier PROJECT.ID
CONTACT_ID uniqueidentifier CONTACTS.ID

Table PROJECTS_OPPORTUNITIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROJECT_ID uniqueidentifier PROJECT.ID
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID

Table PROJECTS_QUOTES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROJECT_ID uniqueidentifier PROJECT.ID
QUOTE_ID uniqueidentifier QUOTES.ID

Table PROSPECT_LIST_CAMPAIGNS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROSPECT_LIST_ID uniqueidentifier PROSPECT_LISTS.ID
CAMPAIGN_ID uniqueidentifier CAMPAIGNS.ID

Table PROSPECT_LISTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (50) Name
DESCRIPTION nvarchar (max) Description
LIST_TYPE nvarchar (25) List Type
DOMAIN_NAME nvarchar (255) Domain Name
DYNAMIC_LIST bit Dynamic List
TEAM_SET_ID uniqueidentifier Team Set ID

Table PROSPECT_LISTS_PROSPECTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PROSPECT_LIST_ID uniqueidentifier PROSPECT_LISTS.ID
RELATED_ID uniqueidentifier
RELATED_TYPE nvarchar (25)

Table PROSPECT_LISTS_SQL

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
DYNAMIC_SQL nvarchar (max)
DYNAMIC_RDL nvarchar (max)

Table PROSPECTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TRACKER_KEY nvarchar (30) Tracker Key
SALUTATION nvarchar (25) Salutation
FIRST_NAME nvarchar (100) First Name
LAST_NAME nvarchar (100) Last Name
TITLE nvarchar (25) Title
DEPARTMENT nvarchar (255) Department
BIRTHDATE datetime Birthdate
DO_NOT_CALL bit Do Not Call
PHONE_HOME nvarchar (25) Phone Home
PHONE_MOBILE nvarchar (25) Phone Mobile
PHONE_WORK nvarchar (25) Phone Work
PHONE_OTHER nvarchar (25) Phone Other
PHONE_FAX nvarchar (25) Phone Fax
EMAIL1 nvarchar (100) Email
EMAIL2 nvarchar (100) Other Email
ASSISTANT nvarchar (75) Assistant
ASSISTANT_PHONE nvarchar (25) Assistant Phone
EMAIL_OPT_OUT bit Email Opt Out
INVALID_EMAIL bit Invalid Email
SMS_OPT_IN nvarchar (25) SMS Opt In
TWITTER_SCREEN_NAME nvarchar (20) Twitter Screen Name
PRIMARY_ADDRESS_STREET nvarchar (150) Primary Street
PRIMARY_ADDRESS_CITY nvarchar (100) Primary City
PRIMARY_ADDRESS_STATE nvarchar (100) Primary State
PRIMARY_ADDRESS_POSTALCODE nvarchar (20) Primary Postal Code
PRIMARY_ADDRESS_COUNTRY nvarchar (100) Primary Country
ALT_ADDRESS_STREET nvarchar (150) Alternate Street
ALT_ADDRESS_CITY nvarchar (100) Alternate City
ALT_ADDRESS_STATE nvarchar (100) Alternate State
ALT_ADDRESS_POSTALCODE nvarchar (20) Alternate Postal Code
ALT_ADDRESS_COUNTRY nvarchar (100) Alternate Country
DESCRIPTION nvarchar (max) Description
LEAD_ID uniqueidentifier Lead ID
ACCOUNT_NAME nvarchar (150) Account Name
CAMPAIGN_ID uniqueidentifier Campaign ID
TEAM_SET_ID uniqueidentifier Team Set ID

Table QUOTES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
QUOTE_NUM nvarchar (30) Quote Number
NAME nvarchar (150) Name
QUOTE_TYPE nvarchar (25) Quote Type
PAYMENT_TERMS nvarchar (25) Payment Terms
ORDER_STAGE nvarchar (25) Order Stage
QUOTE_STAGE nvarchar (25) Quote Stage
PURCHASE_ORDER_NUM nvarchar (50) Purchase Order Num
ORIGINAL_PO_DATE datetime Original P.O. Date
DATE_QUOTE_CLOSED datetime Date Quote Closed
DATE_QUOTE_EXPECTED_CLOSED datetime Date Quote Expected Closed
DATE_ORDER_SHIPPED datetime Date Order Shipped
SHOW_LINE_NUMS bit Show Line Nums
CALC_GRAND_TOTAL bit Calc Grand Total
EXCHANGE_RATE float (53, 0) Exchange Rate
CURRENCY_ID uniqueidentifier Currency ID
TAXRATE_ID uniqueidentifier TAX_RATES.IDTaxrate ID
SHIPPER_ID uniqueidentifier SHIPPERS.IDShipper ID
SUBTOTAL money (19, 4) Subtotal
SUBTOTAL_USDOLLAR money (19, 4) Subtotal US Dollar
DISCOUNT money (19, 4) Discount
DISCOUNT_USDOLLAR money (19, 4) Discount US Dollar
SHIPPING money (19, 4) Shipping
SHIPPING_USDOLLAR money (19, 4) Shipping US Dollar
TAX money (19, 4) Tax
TAX_USDOLLAR money (19, 4) Tax US Dollar
TOTAL money (19, 4) Total
TOTAL_USDOLLAR money (19, 4) Total US Dollar
BILLING_ADDRESS_STREET nvarchar (150) Billing Street
BILLING_ADDRESS_CITY nvarchar (100) Billing City
BILLING_ADDRESS_STATE nvarchar (100) Billing State
BILLING_ADDRESS_POSTALCODE nvarchar (20) Billing Postal Code
BILLING_ADDRESS_COUNTRY nvarchar (100) Billing Country
SHIPPING_ADDRESS_STREET nvarchar (150) Shipping Street
SHIPPING_ADDRESS_CITY nvarchar (100) Shipping City
SHIPPING_ADDRESS_STATE nvarchar (100) Shipping State
SHIPPING_ADDRESS_POSTALCODE nvarchar (20) Shipping Postal Code
SHIPPING_ADDRESS_COUNTRY nvarchar (100) Shipping Country
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table QUOTES_ACCOUNTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
QUOTE_ID uniqueidentifier QUOTES.ID
ACCOUNT_ID uniqueidentifier ACCOUNTS.ID
ACCOUNT_ROLE nvarchar (25)

Table QUOTES_CASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
QUOTE_ID uniqueidentifier QUOTES.ID
CASE_ID uniqueidentifier CASES.ID

Table QUOTES_CONTACTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
QUOTE_ID uniqueidentifier QUOTES.ID
CONTACT_ID uniqueidentifier CONTACTS.ID
CONTACT_ROLE nvarchar (25)

Table QUOTES_LINE_ITEMS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
QUOTE_ID uniqueidentifier QUOTES.IDQuote ID
LINE_GROUP_ID uniqueidentifier Line Group ID
LINE_ITEM_TYPE nvarchar (25) Line Item Type
POSITION int Position
NAME nvarchar (100) Name
MFT_PART_NUM nvarchar (50) Mft Part Num
VENDOR_PART_NUM nvarchar (50) Vendor Part Num
PRODUCT_TEMPLATE_ID uniqueidentifier Product Template ID
PARENT_TEMPLATE_ID uniqueidentifier Parent Template ID
TAX_CLASS nvarchar (25) Tax Class
QUANTITY float (53, 0) Quantity
COST_PRICE money (19, 4) Cost
COST_USDOLLAR money (19, 4) Cost US Dollar
LIST_PRICE money (19, 4) List Price
LIST_USDOLLAR money (19, 4) List US Dollar
UNIT_PRICE money (19, 4) Unit Price
UNIT_USDOLLAR money (19, 4) Unit US Dollar
TAXRATE_ID uniqueidentifier Tax Rate
TAX money (19, 4) Tax
TAX_USDOLLAR money (19, 4) Tax US Dollar
EXTENDED_PRICE money (19, 4) Extended Price
EXTENDED_USDOLLAR money (19, 4) Extended US Dollar
DISCOUNT_ID uniqueidentifier Discount ID
PRICING_FORMULA nvarchar (25) Pricing Formula
PRICING_FACTOR float (53, 0) Pricing Factor
DISCOUNT_PRICE money (19, 4) Discount Price
DISCOUNT_USDOLLAR money (19, 4) Discount US Dollar
DESCRIPTION nvarchar (max) Description

Table QUOTES_OPPORTUNITIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
QUOTE_ID uniqueidentifier QUOTES.ID
OPPORTUNITY_ID uniqueidentifier OPPORTUNITIES.ID

Table REGIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (150) Name
DESCRIPTION nvarchar (max) Description

Table REGIONS_COUNTRIES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
REGION_ID uniqueidentifier
COUNTRY nvarchar (50)

Table RELATIONSHIPS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
RELATIONSHIP_NAME nvarchar (150)
LHS_MODULE nvarchar (100)
LHS_TABLE nvarchar (64)
LHS_KEY nvarchar (64)
RHS_MODULE nvarchar (100)
RHS_TABLE nvarchar (64)
RHS_KEY nvarchar (64)
JOIN_TABLE nvarchar (64)
JOIN_KEY_LHS nvarchar (64)
JOIN_KEY_RHS nvarchar (64)
RELATIONSHIP_TYPE nvarchar (64)
RELATIONSHIP_ROLE_COLUMN nvarchar (64)
RELATIONSHIP_ROLE_COLUMN_VALUE nvarchar (50)
REVERSE bit

Table RELEASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50) Name
LIST_ORDER int List Order
STATUS nvarchar (25) Status

Table REPORTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (150) Name
MODULE_NAME nvarchar (25) Module Name
REPORT_TYPE nvarchar (25) Report Type
PUBLISHED bit Published
RDL nvarchar (max) Rdl
TEAM_SET_ID uniqueidentifier Team Set ID
PRE_LOAD_EVENT_ID uniqueidentifier
POST_LOAD_EVENT_ID uniqueidentifier

Table ROLES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (150)
DESCRIPTION nvarchar (max)
MODULES nvarchar (max)

Table ROLES_MODULES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ROLE_ID uniqueidentifier ROLES.ID
MODULE_ID varchar (36)
ALLOW bit

Table ROLES_USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ROLE_ID uniqueidentifier ROLES.ID
USER_ID uniqueidentifier USERS.ID

Table RULES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TEAM_SET_ID uniqueidentifier Team Set ID
NAME nvarchar (150)
MODULE_NAME nvarchar (25)
RULE_TYPE nvarchar (25)
DESCRIPTION nvarchar (max)
FILTER_SQL nvarchar (max)
FILTER_XML nvarchar (max)
RULES_XML nvarchar (max)
XOML nvarchar (max)

Table SAVED_SEARCH

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
DEFAULT_SEARCH_ID uniqueidentifier
NAME nvarchar (150)
SEARCH_MODULE nvarchar (150)
CONTENTS nvarchar (max)
DESCRIPTION nvarchar (max)

Table SCHEDULERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (255) Name
JOB nvarchar (255) Job
DATE_TIME_START datetime Date & Time Start
DATE_TIME_END datetime Date & Time End
JOB_INTERVAL nvarchar (100) Job Interval
TIME_FROM datetime Time From
TIME_TO datetime Time To
LAST_RUN datetime Last Run
STATUS nvarchar (25) Status
CATCH_UP bit Catch Up

Table SCHEDULERS_TIMES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
SCHEDULE_ID uniqueidentifier SCHEDULERS.ID
EXECUTE_TIME datetime
STATUS nvarchar (25)

Table SEMANTIC_MODEL_FIELDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TABLE_NAME nvarchar (64)
NAME nvarchar (64)
COLUMN_INDEX int
DATA_TYPE nvarchar (25)
FORMAT nvarchar (10)
WIDTH int
NULLABLE bit
IS_AGGREGATE bit
SORT_DESCENDING bit
IDENTIFYING_ATTRIBUTE bit
DETAIL_ATTRIBUTE bit
VALUE_SELECTION nvarchar (25)
CONTEXTUAL_NAME nvarchar (25)
DISCOURAGE_GROUPING bit
AGGREGATE_ATTRIBUTE bit
AGGREGATE_FUNCTION_NAME nvarchar (25)
DEFAULT_AGGREGATE bit
VARIATION_PARENT_ID uniqueidentifier

Table SEMANTIC_MODEL_ROLES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
LHS_TABLE nvarchar (64)
LHS_KEY nvarchar (64)
RHS_TABLE nvarchar (64)
RHS_KEY nvarchar (64)
CARDINALITY nvarchar (25)
NAME nvarchar (64)

Table SEMANTIC_MODEL_TABLES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (64)
COLLECTION_NAME nvarchar (64)
INSTANCE_SELECTION nvarchar (25)

Table SHIPPERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50) Name
STATUS nvarchar (25) Status
LIST_ORDER int List Order

Table SHORTCUTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
MODULE_NAME nvarchar (25) Module Name
DISPLAY_NAME nvarchar (150) Display Name
RELATIVE_PATH nvarchar (255) Relative Path
IMAGE_NAME nvarchar (50) Image Name
SHORTCUT_ENABLED bit Enabled
SHORTCUT_ORDER int Order
SHORTCUT_MODULE nvarchar (25) ACL Module
SHORTCUT_ACLTYPE nvarchar (100) ACL Type

Table SMS_MESSAGES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TEAM_SET_ID uniqueidentifier Team Set ID
MAILBOX_ID uniqueidentifier Mailbox ID
NAME nvarchar (1600) Message
DATE_START datetime Date Sent
TIME_START datetime
PARENT_TYPE nvarchar (25) Parent Type
PARENT_ID uniqueidentifier Parent ID
FROM_NUMBER nvarchar (20) From Number
TO_NUMBER nvarchar (20) To Number
TO_ID uniqueidentifier
TYPE nvarchar (25) Type
STATUS nvarchar (25) Status
MESSAGE_SID nvarchar (100)
FROM_LOCATION nvarchar (100) From Location
TO_LOCATION nvarchar (100) To Location

Table SUGARFAVORITES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
MODULE nvarchar (25)
RECORD_ID uniqueidentifier
NAME nvarchar (255)
DESCRIPTION nvarchar (50)

Table SUGARFEED

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TEAM_SET_ID uniqueidentifier Team Set ID
NAME nvarchar (255)
RELATED_MODULE nvarchar (100)
RELATED_ID uniqueidentifier
LINK_TYPE nvarchar (30)
LINK_URL nvarchar (255)
DESCRIPTION nvarchar (255)

Table SURVEY_PAGES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
SURVEY_ID uniqueidentifier Survey ID
NAME nvarchar (1000) Name
PAGE_NUMBER int Page Number
QUESTION_RANDOMIZATION nvarchar (25) Question Randomization
DESCRIPTION nvarchar (max) Description

Table SURVEY_PAGES_QUESTIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
SURVEY_PAGE_ID uniqueidentifier SURVEY_PAGES.ID
SURVEY_QUESTION_ID uniqueidentifier SURVEY_QUESTIONS.ID
QUESTION_NUMBER int

Table SURVEY_QUESTIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TEAM_SET_ID uniqueidentifier Team Set ID
NAME nvarchar (150) Name
DESCRIPTION nvarchar (max) Question Text
QUESTION_TYPE nvarchar (25) Question Type
DISPLAY_FORMAT nvarchar (25) Display Format
ANSWER_CHOICES nvarchar (max) Answer Choices
COLUMN_CHOICES nvarchar (max) Column Choices
FORCED_RANKING bit Forced Ranking
INVALID_DATE_MESSAGE nvarchar (max) Invalid date message
INVALID_NUMBER_MESSAGE nvarchar (max) Invalid number message
NA_ENABLED bit Add N/A
NA_LABEL nvarchar (max)
OTHER_ENABLED bit Add other field
OTHER_LABEL nvarchar (200) Other Label
OTHER_HEIGHT int
OTHER_WIDTH int
OTHER_AS_CHOICE bit Use other as choice
OTHER_ONE_PER_ROW bit One comment per row
OTHER_REQUIRED_MESSAGE nvarchar (max)
OTHER_VALIDATION_TYPE nvarchar (25) Validation
OTHER_VALIDATION_MIN nvarchar (10)
OTHER_VALIDATION_MAX nvarchar (10)
OTHER_VALIDATION_MESSAGE nvarchar (max) Validation Message
REQUIRED bit Required
REQUIRED_TYPE nvarchar (25) Required Type
REQUIRED_RESPONSES_MIN int
REQUIRED_RESPONSES_MAX int
REQUIRED_MESSAGE nvarchar (max) Required error message
VALIDATION_TYPE nvarchar (25) Validation
VALIDATION_MIN nvarchar (10)
VALIDATION_MAX nvarchar (10)
VALIDATION_MESSAGE nvarchar (max) Validate Message
VALIDATION_SUM_ENABLED bit Validate sum
VALIDATION_NUMERIC_SUM int
VALIDATION_SUM_MESSAGE nvarchar (max) Sum of choices
RANDOMIZE_TYPE nvarchar (25) Randomize
RANDOMIZE_NOT_LAST bit Last option not randomized.
SIZE_WIDTH nvarchar (10)
SIZE_HEIGHT nvarchar (10)
BOX_WIDTH nvarchar (10)
BOX_HEIGHT nvarchar (10)
COLUMN_WIDTH nvarchar (10) Column Width
PLACEMENT nvarchar (25) Placement
SPACING_LEFT int Left
SPACING_TOP int Top
SPACING_RIGHT int Right
SPACING_BOTTOM int Bottom
IMAGE_URL nvarchar (1000) Image URL

Table SURVEY_QUESTIONS_RESULTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
SURVEY_RESULT_ID uniqueidentifier Survey Result ID
SURVEY_ID uniqueidentifier Survey ID
SURVEY_PAGE_ID uniqueidentifier Survey Page ID
SURVEY_QUESTION_ID uniqueidentifier Survey Question ID
ANSWER_ID uniqueidentifier Answer ID
ANSWER_TEXT nvarchar (max) Answer
COLUMN_ID uniqueidentifier Column ID
COLUMN_TEXT nvarchar (max) Column
MENU_ID uniqueidentifier Menu ID
MENU_TEXT nvarchar (max) Menu
WEIGHT int Weight
OTHER_TEXT nvarchar (max) Other

Table SURVEY_RESULTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
SURVEY_ID uniqueidentifier Survey ID
PARENT_ID uniqueidentifier Parent ID
START_DATE datetime Start Date
SUBMIT_DATE datetime Submit Date
IS_COMPLETE bit Complete
IP_ADDRESS nvarchar (100) IP Address
USER_AGENT nvarchar (255) User Agent

Table SURVEY_THEMES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50) Name
SURVEY_FONT_FAMILY nvarchar (50) Survey Font Family
LOGO_BACKGROUND nvarchar (25) Logo Background Color
SURVEY_BACKGROUND nvarchar (25) Survey Background Color
SURVEY_TITLE_TEXT_COLOR nvarchar (25) Text Color
SURVEY_TITLE_FONT_SIZE nvarchar (25) Font Size
SURVEY_TITLE_FONT_STYLE nvarchar (25) Font Style
SURVEY_TITLE_FONT_WEIGHT nvarchar (25) Font Weight
SURVEY_TITLE_DECORATION nvarchar (25) Text Decoration
SURVEY_TITLE_BACKGROUND nvarchar (25) Background Color
PAGE_TITLE_TEXT_COLOR nvarchar (25) Text Color
PAGE_TITLE_FONT_SIZE nvarchar (25) Font Size
PAGE_TITLE_FONT_STYLE nvarchar (25) Font Style
PAGE_TITLE_FONT_WEIGHT nvarchar (25) Font Weight
PAGE_TITLE_DECORATION nvarchar (25) Text Decoration
PAGE_TITLE_BACKGROUND nvarchar (25) Background Color
PAGE_DESCRIPTION_TEXT_COLOR nvarchar (25) Text Color
PAGE_DESCRIPTION_FONT_SIZE nvarchar (25) Font Size
PAGE_DESCRIPTION_FONT_STYLE nvarchar (25) Font Style
PAGE_DESCRIPTION_FONT_WEIGHT nvarchar (25) Font Weight
PAGE_DESCRIPTION_DECORATION nvarchar (25) Text Decoration
PAGE_DESCRIPTION_BACKGROUND nvarchar (25) Background Color
QUESTION_HEADING_TEXT_COLOR nvarchar (25) Text Color
QUESTION_HEADING_FONT_SIZE nvarchar (25) Font Size
QUESTION_HEADING_FONT_STYLE nvarchar (25) Font Style
QUESTION_HEADING_FONT_WEIGHT nvarchar (25) Font Weight
QUESTION_HEADING_DECORATION nvarchar (25) Text Decoration
QUESTION_HEADING_BACKGROUND nvarchar (25) Background Color
QUESTION_CHOICE_TEXT_COLOR nvarchar (25) Text Color
QUESTION_CHOICE_FONT_SIZE nvarchar (25) Font Size
QUESTION_CHOICE_FONT_STYLE nvarchar (25) Font Style
QUESTION_CHOICE_FONT_WEIGHT nvarchar (25) Font Weight
QUESTION_CHOICE_DECORATION nvarchar (25) Text Decoration
QUESTION_CHOICE_BACKGROUND nvarchar (25) Background Color
PROGRESS_BAR_PAGE_WIDTH nvarchar (25) Page Width
PROGRESS_BAR_COLOR nvarchar (25) Bar Color
PROGRESS_BAR_BORDER_COLOR nvarchar (25) Border Color
PROGRESS_BAR_BORDER_WIDTH nvarchar (25) Border Width
PROGRESS_BAR_TEXT_COLOR nvarchar (25) Text Color
PROGRESS_BAR_FONT_SIZE nvarchar (25) Font Size
PROGRESS_BAR_FONT_STYLE nvarchar (25) Font Style
PROGRESS_BAR_FONT_WEIGHT nvarchar (25) Font Weight
PROGRESS_BAR_DECORATION nvarchar (25) Text Decoration
PROGRESS_BAR_BACKGROUND nvarchar (25) Background Color
ERROR_TEXT_COLOR nvarchar (25) Text Color
ERROR_FONT_SIZE nvarchar (25) Font Size
ERROR_FONT_STYLE nvarchar (25) Font Style
ERROR_FONT_WEIGHT nvarchar (25) Font Weight
ERROR_DECORATION nvarchar (25) Text Decoration
ERROR_BACKGROUND nvarchar (25) Background Color
EXIT_LINK_TEXT_COLOR nvarchar (25) Text Color
EXIT_LINK_FONT_SIZE nvarchar (25) Font Size
EXIT_LINK_FONT_STYLE nvarchar (25) Font Style
EXIT_LINK_FONT_WEIGHT nvarchar (25) Font Weight
EXIT_LINK_DECORATION nvarchar (25) Text Decoration
EXIT_LINK_BACKGROUND nvarchar (25) Background Color
REQUIRED_TEXT_COLOR nvarchar (25) Required Color
DESCRIPTION nvarchar (max) Description

Table SURVEYS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TEAM_SET_ID uniqueidentifier Team Set ID
NAME nvarchar (150) Name
STATUS nvarchar (25) Status
SURVEY_STYLE nvarchar (25) Style
PAGE_RANDOMIZATION nvarchar (25) Page Randomization
SURVEY_THEME_ID uniqueidentifier Survey Theme
DESCRIPTION nvarchar (max) Description

Table SYSTEM_EVENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TABLE_VERSION timestamp
TABLE_ID uniqueidentifier
TABLE_NAME nvarchar (50)
TABLE_ACTION int
TABLE_COLUMNS varbinary (128)
TABLE_TOKEN varchar (255)

Table SYSTEM_LOG

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_ID uniqueidentifier User ID
USER_NAME nvarchar (255) User Name
MACHINE nvarchar (60) Machine
ASPNET_SESSIONID nvarchar (50) ASP.NET Session ID
REMOTE_HOST nvarchar (100) Remote Host
SERVER_HOST nvarchar (100) Server Host
TARGET nvarchar (255) Target
RELATIVE_PATH nvarchar (255) Relative Path
PARAMETERS nvarchar (2000) Parameters
ERROR_TYPE nvarchar (25) Error Type
FILE_NAME nvarchar (255) File Name
METHOD nvarchar (450) Method
LINE_NUMBER int Line Number
MESSAGE nvarchar (max) Message

Table SYSTEM_REST_TABLES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TABLE_NAME nvarchar (50)
VIEW_NAME nvarchar (60)
MODULE_NAME nvarchar (25)
MODULE_NAME_RELATED nvarchar (25)
MODULE_SPECIFIC int
MODULE_FIELD_NAME nvarchar (50)
IS_SYSTEM bit
IS_ASSIGNED bit
ASSIGNED_FIELD_NAME nvarchar (50)
IS_RELATIONSHIP bit
HAS_CUSTOM bit
DEPENDENT_LEVEL int

Table SYSTEM_SYNC_LOG

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_ID uniqueidentifier User ID
MACHINE nvarchar (60) Machine
REMOTE_URL nvarchar (255) Remote URL
ERROR_TYPE nvarchar (25) Error Type
FILE_NAME nvarchar (255) File Name
METHOD nvarchar (450) Method
LINE_NUMBER int Line Number
MESSAGE nvarchar (max) Message

Table SYSTEM_SYNC_TABLES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TABLE_NAME nvarchar (50)
VIEW_NAME nvarchar (60)
MODULE_NAME nvarchar (25)
MODULE_NAME_RELATED nvarchar (25)
MODULE_SPECIFIC int
MODULE_FIELD_NAME nvarchar (50)
IS_SYSTEM bit
IS_ASSIGNED bit
ASSIGNED_FIELD_NAME nvarchar (50)
IS_RELATIONSHIP bit
HAS_CUSTOM bit
DEPENDENT_LEVEL int

Table SYSTEM_TRANSACTIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
SESSION_SPID int

Table TAB_GROUPS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (25)
TITLE nvarchar (100)
ENABLED bit
GROUP_ORDER int
GROUP_MENU bit

Table TASKS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (50) Subject
STATUS nvarchar (25) Status
DATE_DUE_FLAG bit Date Due Flag
DATE_DUE datetime Due Date
TIME_DUE datetime Time Due
DATE_START_FLAG bit Date Start Flag
DATE_START datetime Start Date
TIME_START datetime Start Time
PARENT_TYPE nvarchar (25) Parent Type
PARENT_ID uniqueidentifier Parent ID
CONTACT_ID uniqueidentifier Contact ID
PRIORITY nvarchar (25) Priority
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table TAX_RATES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50) Name
STATUS nvarchar (25) Status
VALUE money (19, 4) Percentage(%)
LIST_ORDER int List Order
QUICKBOOKS_TAX_VENDOR nvarchar (50) QuickBooks Tax Vendor
DESCRIPTION nvarchar (max) Description

Table TEAM_MEMBERSHIPS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TEAM_ID uniqueidentifier TEAMS.IDTeam ID
USER_ID uniqueidentifier USERS.ID
EXPLICIT_ASSIGN bit
IMPLICIT_ASSIGN bit
PRIVATE bit

Table TEAM_NOTICES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TEAM_ID uniqueidentifier Team ID
NAME nvarchar (50) Name
STATUS nvarchar (25) Status
DATE_START datetime Start Date
DATE_END datetime End Date
URL nvarchar (255) URL
URL_TITLE nvarchar (255) Url Title
DESCRIPTION nvarchar (max) Description
TEAM_SET_ID uniqueidentifier Team Set ID

Table TEAM_SETS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TEAM_SET_LIST varchar (851) Teams
TEAM_SET_NAME nvarchar (200) Teams

Table TEAM_SETS_TEAMS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TEAM_SET_ID uniqueidentifier TEAM_SETS.IDTeam Set ID
TEAM_ID uniqueidentifier TEAMS.IDTeam ID
PRIMARY_TEAM bit

Table TEAMS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (128) Name
DESCRIPTION nvarchar (max) Description
PRIVATE bit Private

Table TERMINOLOGY

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (150) Name
LANG nvarchar (10) Language
MODULE_NAME nvarchar (25) Module Name
LIST_NAME nvarchar (50) List Name
LIST_ORDER int List Order
DISPLAY_NAME nvarchar (max) Display Name

Table TERMINOLOGY_ALIASES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ALIAS_NAME nvarchar (50)
ALIAS_MODULE_NAME nvarchar (25)
ALIAS_LIST_NAME nvarchar (50)
NAME nvarchar (50)
MODULE_NAME nvarchar (25)
LIST_NAME nvarchar (50)

Table TERMINOLOGY_HELP

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (50)
LANG nvarchar (10)
MODULE_NAME nvarchar (25)
DISPLAY_TEXT nvarchar (max)

Table THREADS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
FORUM_ID uniqueidentifier FORUMS.IDForum ID
TITLE nvarchar (255) Title
IS_STICKY bit Is Sticky
POSTCOUNT int Replies
VIEW_COUNT int Views
DESCRIPTION_HTML nvarchar (max) Description

Table TIME_PERIODS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
NAME nvarchar (25)
START_DATE datetime
END_DATE datetime
IS_FISCAL_YEAR bit

Table TIMEZONES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (100)
STANDARD_NAME nvarchar (100)
STANDARD_ABBREVIATION nvarchar (10)
DAYLIGHT_NAME nvarchar (100)
DAYLIGHT_ABBREVIATION nvarchar (10)
BIAS int
STANDARD_BIAS int
DAYLIGHT_BIAS int
STANDARD_YEAR int
STANDARD_MONTH int
STANDARD_WEEK int
STANDARD_DAYOFWEEK int
STANDARD_HOUR int
STANDARD_MINUTE int
DAYLIGHT_YEAR int
DAYLIGHT_MONTH int
DAYLIGHT_WEEK int
DAYLIGHT_DAYOFWEEK int
DAYLIGHT_HOUR int
DAYLIGHT_MINUTE int
TZID nvarchar (50)
LINKED_TIMEZONE nvarchar (50)

Table TRACKER

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_ID uniqueidentifier
ACTION nvarchar (25)
MODULE_NAME nvarchar (25)
ITEM_ID uniqueidentifier
ITEM_SUMMARY nvarchar (255)

Table TWITTER_MESSAGES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TEAM_SET_ID uniqueidentifier Team Set ID
NAME nvarchar (140) Message
DESCRIPTION nvarchar (max) Description
DATE_START datetime Date Sent
TIME_START datetime
PARENT_TYPE nvarchar (25) Parent Type
PARENT_ID uniqueidentifier Parent ID
TYPE nvarchar (25) Type
STATUS nvarchar (25) Status
TWITTER_ID bigint Twitter ID
TWITTER_USER_ID bigint Twitter User ID
TWITTER_FULL_NAME nvarchar (20) Twitter Full Name
TWITTER_SCREEN_NAME nvarchar (15) Twitter Screen Name
ORIGINAL_ID bigint Original ID
ORIGINAL_USER_ID bigint Original User ID
ORIGINAL_FULL_NAME nvarchar (20) Original Full Name
ORIGINAL_SCREEN_NAME nvarchar (15) Original Screen Name

Table TWITTER_TRACK_MESSAGES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
TWITTER_TRACK_ID uniqueidentifier TWITTER_TRACKS.ID
TWITTER_MESSAGE_ID uniqueidentifier TWITTER_MESSAGES.ID

Table TWITTER_TRACKS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TEAM_SET_ID uniqueidentifier Team Set ID
NAME nvarchar (60) Track
LOCATION nvarchar (60) Location
TWITTER_USER_ID bigint Twitter User ID
TWITTER_SCREEN_NAME nvarchar (15) Twitter Screen Name
STATUS nvarchar (25) Status
TYPE nvarchar (25) Type
DESCRIPTION nvarchar (max) Description

Table UPGRADE_HISTORY

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
FILENAME nvarchar (255)
MD5SUM nvarchar (32)
TYPE nvarchar (30)
STATUS nvarchar (50)
VERSION nvarchar (10)

Table USER_PREFERENCES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
CATEGORY nvarchar (255)
CONTENT varbinary (max)

Table USERS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_NAME nvarchar (60) User Name
USER_PASSWORD nvarchar (30) User Password
USER_HASH nvarchar (32) User Hash
FIRST_NAME nvarchar (30) First Name
LAST_NAME nvarchar (30) Last Name
REPORTS_TO_ID uniqueidentifier Reports To ID
IS_ADMIN bit Is Admin
IS_ADMIN_DELEGATE bit Is Admin Delegate
RECEIVE_NOTIFICATIONS bit Receive Notifications
DESCRIPTION nvarchar (max) Description
TITLE nvarchar (50) Title
DEPARTMENT nvarchar (50) Department
PHONE_HOME nvarchar (50) Phone Home
PHONE_MOBILE nvarchar (50) Phone Mobile
PHONE_WORK nvarchar (50) Phone Work
PHONE_OTHER nvarchar (50) Phone Other
PHONE_FAX nvarchar (50) Phone Fax
EMAIL1 nvarchar (100) Email
EMAIL2 nvarchar (100) Other Email
STATUS nvarchar (25) Status
ADDRESS_STREET nvarchar (150) Street
ADDRESS_CITY nvarchar (100) City
ADDRESS_STATE nvarchar (100) State
ADDRESS_COUNTRY nvarchar (25) Country
ADDRESS_POSTALCODE nvarchar (9) Postal Code
USER_PREFERENCES nvarchar (max) User Preferences
PORTAL_ONLY bit Portal Only
EMPLOYEE_STATUS nvarchar (25) Employee Status
MESSENGER_ID nvarchar (25) Messenger ID
MESSENGER_TYPE nvarchar (25) Messenger Type
IS_GROUP bit Is Group
DEFAULT_TEAM uniqueidentifier Default Team
SYSTEM_GENERATED_PASSWORD bit System Generated Password
PWD_LAST_CHANGED datetime Pwd Last Changed
MAIL_SMTPUSER nvarchar (60) Mail Smtpuser
MAIL_SMTPPASS nvarchar (30) Mail Smtppass
GOOGLEAPPS_SYNC_CONTACTS bit
GOOGLEAPPS_SYNC_CALENDAR bit
GOOGLEAPPS_USERNAME nvarchar (100)
GOOGLEAPPS_PASSWORD nvarchar (100)
FACEBOOK_ID nvarchar (25)
ICLOUD_SYNC_CONTACTS bit
ICLOUD_SYNC_CALENDAR bit
ICLOUD_USERNAME nvarchar (100)
ICLOUD_PASSWORD nvarchar (100)
ICLOUD_CTAG_CONTACTS varchar (100)
ICLOUD_CTAG_CALENDAR varchar (100)
THEME nvarchar (25)
DATE_FORMAT nvarchar (25)
TIME_FORMAT nvarchar (25)
LANG nvarchar (10)
CURRENCY_ID uniqueidentifier
TIMEZONE_ID uniqueidentifier
SAVE_QUERY bit
GROUP_TABS bit
SUBPANEL_TABS bit
EXTENSION nvarchar (25)
SMS_OPT_IN nvarchar (25)

Table USERS_FEEDS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_ID uniqueidentifier USERS.ID
FEED_ID uniqueidentifier FEEDS.ID
RANK int

Table USERS_LAST_IMPORT

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
BEAN_TYPE nvarchar (25)
BEAN_ID uniqueidentifier

Table USERS_LOGINS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_ID uniqueidentifier User ID
USER_NAME nvarchar (60) User Name
LOGIN_TYPE nvarchar (25) Login Type
LOGIN_DATE datetime Login Date
LOGOUT_DATE datetime Logout Date
LOGIN_STATUS nvarchar (25) Login Status
ASPNET_SESSIONID nvarchar (50) ASP.NET Session ID
REMOTE_HOST nvarchar (100) Remote Host
SERVER_HOST nvarchar (100) Server Host
TARGET nvarchar (255) Target
RELATIVE_PATH nvarchar (255) Relative Path
USER_AGENT nvarchar (255) User Agent

Table USERS_PASSWORD_HISTORY

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_ID uniqueidentifier
USER_HASH nvarchar (32)

Table USERS_PASSWORD_LINK

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_NAME nvarchar (60)

Table USERS_SIGNATURES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_ID uniqueidentifier USERS.IDUser
NAME nvarchar (255) Name
SIGNATURE nvarchar (max) Signature
SIGNATURE_HTML nvarchar (max) Signature
PRIMARY_SIGNATURE bit Primary Signature

Table VCALS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
USER_ID uniqueidentifier
TYPE nvarchar (25)
SOURCE nvarchar (25)
CONTENT nvarchar (max)

Table VERSIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (255)
FILE_VERSION nvarchar (255)
DB_VERSION nvarchar (255)

Table WORKFLOW

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (100) Name
BASE_MODULE nvarchar (100) Base Module
AUDIT_TABLE nvarchar (50) Audit Table
STATUS bit Status
TYPE nvarchar (25) Type
FIRE_ORDER nvarchar (25) Fire Order
PARENT_ID uniqueidentifier Parent ID
RECORD_TYPE nvarchar (25) Record Type
LIST_ORDER_Y int Process Order
CUSTOM_XOML bit Custom Xoml
DESCRIPTION nvarchar (max) Description
FILTER_SQL nvarchar (max) SQL Filter
FILTER_XML nvarchar (max) Filter Xml
XOML nvarchar (max) Xoml
JOB_INTERVAL nvarchar (100) Job Interval
LAST_RUN datetime Last Run

Table WORKFLOW_ACTION_SHELLS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
NAME nvarchar (100) Name
ACTION_TYPE nvarchar (25) Action Type
PARAMETERS nvarchar (100) Parameters
REL_MODULE nvarchar (100) Related Module
REL_MODULE_TYPE nvarchar (25) Related Module Type
ACTION_MODULE nvarchar (100) Action Module
CUSTOM_XOML bit Custom Xoml
RDL nvarchar (max) Rdl
XOML nvarchar (max) Xoml

Table WORKFLOW_ACTIONS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
FIELD nvarchar (100)
VALUE nvarchar (max)
SET_TYPE nvarchar (25)
ADV_TYPE nvarchar (25)
PARENT_ID uniqueidentifier Parent ID
EXT1 nvarchar (100)
EXT2 nvarchar (100)
EXT3 nvarchar (100)

Table WORKFLOW_ALERT_SHELLS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
NAME nvarchar (100) Name
ALERT_TYPE nvarchar (25) Alert Type
SOURCE_TYPE nvarchar (25) Source Type
CUSTOM_TEMPLATE_ID uniqueidentifier Custom Template ID
CUSTOM_XOML bit Custom Xoml
ALERT_TEXT nvarchar (max) Alert Text
RDL nvarchar (max) Rdl
XOML nvarchar (max) Xoml
ASSIGNED_USER_ID uniqueidentifier Assigned User ID
TEAM_ID uniqueidentifier Team ID
TEAM_SET_ID uniqueidentifier Team Set ID

Table WORKFLOW_ALERT_TEMPLATES

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
NAME nvarchar (255) Name
BASE_MODULE nvarchar (100) Base Module
FROM_ADDR nvarchar (100) From Email Address
FROM_NAME nvarchar (100) From Name
DESCRIPTION nvarchar (max) Description
SUBJECT nvarchar (255) Subject
BODY nvarchar (max) Body
BODY_HTML nvarchar (max) Body

Table WORKFLOW_ALERTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
FIELD_VALUE nvarchar (100)
REL_EMAIL_VALUE nvarchar (100)
REL_MODULE1 nvarchar (100)
REL_MODULE2 nvarchar (100)
REL_MODULE1_TYPE nvarchar (25)
REL_MODULE2_TYPE nvarchar (25)
WHERE_FILTER bit
USER_TYPE nvarchar (25)
ARRAY_TYPE nvarchar (25)
RELATE_TYPE nvarchar (25)
ADDRESS_TYPE nvarchar (25)
PARENT_ID uniqueidentifier Parent ID
USER_DISPLAY_TYPE nvarchar (25)

Table WORKFLOW_EVENTS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
AUDIT_VERSION timestamp
AUDIT_ID uniqueidentifier Audit ID
AUDIT_TABLE nvarchar (50)
AUDIT_TOKEN varchar (255) Audit Token
AUDIT_ACTION int Audit Action
AUDIT_PARENT_ID uniqueidentifier

Table WORKFLOW_RUN

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
WORKFLOW_VERSION timestamp
WORKFLOW_ID uniqueidentifier
AUDIT_ID uniqueidentifier Audit ID
AUDIT_TABLE nvarchar (50)
STATUS nvarchar (25)
START_DATE datetime
END_DATE datetime
WORKFLOW_INSTANCE_ID uniqueidentifier
DESCRIPTION nvarchar (max)

Table WORKFLOW_TRANSACTION_LOG

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
AUDIT_TABLE nvarchar (50)
AUDIT_TOKEN varchar (255) Audit Token
WORKFLOW_ID uniqueidentifier
WORKFLOW_INSTANCE_ID uniqueidentifier

Table WORKFLOW_TRIGGER_SHELLS

Name Type NULL Comment
ID uniqueidentifier ID
DELETED bit Deleted
CREATED_BY uniqueidentifier Created By
DATE_ENTERED datetime Date Entered
MODIFIED_USER_ID uniqueidentifier Modified User ID
DATE_MODIFIED datetime Date Modified
DATE_MODIFIED_UTC datetime Date Modified UTC
PARENT_ID uniqueidentifier Parent ID
FIELD nvarchar (100) Field
TYPE nvarchar (25) Type
FRAME_TYPE nvarchar (25) Frame Type
EVAL nvarchar (max) Eval
SHOW_PAST bit Show Past
REL_MODULE nvarchar (100) Related Module
REL_MODULE_TYPE nvarchar (25) Related Module Type
PARAMETERS nvarchar (100) Parameters