Contact resource dimension
Module: Opportunity Management
CONTACT_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
CONTACT_ID | NUMBER | 38 | 0 | True | Unique identifier for the Contact | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Unique identifier | ||||
FULL_NAME | VARCHAR2 | 512 | Competitor name. | ||||
ADDRESS_LINE_1 | VARCHAR2 | 256 | Contact address line 1 | ||||
ADDRESS_LINE_2 | VARCHAR2 | 256 | Contact address line 2 | ||||
ADDRESS_LINE_3 | VARCHAR2 | 256 | Contact address line 3 | ||||
ADDRESS_LINE_4 | VARCHAR2 | 256 | Contact address line 4 | ||||
CITY | VARCHAR2 | 64 | City | ||||
STATE | VARCHAR2 | 64 | State | ||||
POSTAL_CODE | VARCHAR2 | 64 | Postal Code | ||||
JOB_TITLE | VARCHAR2 | 128 | Job Title of Contact | ||||
EMAIL_ADDRESS | VARCHAR2 | 512 | Email Address of Contact | ||||
COUNTRY | VARCHAR2 | 16 | Country | ||||
CONTACT_OWNER_ID | NUMBER | 38 | 0 | Party identifier for sales resource marked as owner for contact | DW_CXS_RESOURCE_D | RESOURCE_ID | |
CONTACT_TYPE_CODE | VARCHAR2 | 64 | Contact type | DW_CXS_CONTACT_TYPE_CODE_D_TL | CODE | ||
COUNTY | VARCHAR2 | 64 | County | ||||
LATITUDE | NUMBER | Latitude | |||||
LONGITUDE | NUMBER | Longitude | |||||
INTERNAL_STATUS | VARCHAR2 | 16 | Internal status of a sales account | ||||
PROVINCE | VARCHAR2 | 64 | Province | ||||
PRIMARY_CUSTOMER_ID | NUMBER | 38 | 0 | Primary Customer Identifier | |||
SALES_ACCOUNT_ID | NUMBER | 38 | 0 | Sales account identifier |