Resource dimension
Module: Opportunity Management
RESOURCE_ID
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column |
---|---|---|---|---|---|---|---|
RESOURCE_ID | NUMBER | 38 | 0 | True | Unique identifier for the sales Resource Party | ||
SOURCE_RECORD_ID | VARCHAR2 | 64 | Unique identifier | ||||
RESOURCE_PROFILE_ID | NUMBER | 38 | 0 | the sales Resource Party | |||
NAME | VARCHAR2 | 512 | Resource name. | ||||
EMAIL_ADDRESS | VARCHAR2 | 512 | Resource Email Address | ||||
PRIMARY_ORGANIZATION_ID | NUMBER | Organization code for sales resource | DW_INTERNAL_ORG_D_TL | ORGANIZATION_ID | |||
JOB_TITLE_CODE | VARCHAR2 | 64 | Job title code for Sales Resource | DW_CXS_JOB_TITLE_D_TL | CODE | ||
JOB_TITLE | VARCHAR2 | 128 | Job title for Sales Resource | ||||
PHONE | VARCHAR2 | 64 | Phone Number of Sales Resource | ||||
PRIMARY_ROLE_CODE | VARCHAR2 | 64 | Role code of Sales Resource | DW_CXS_SALES_RESOURCE_ROLE_CODE_TL | CODE | ||
ADDRESS1 | VARCHAR2 | 256 | First line of the Identifying address | ||||
ADDRESS2 | VARCHAR2 | 256 | Second line of the Identifying address | ||||
ADDRESS3 | VARCHAR2 | 256 | Third line of the Identifying address | ||||
ADDRESS4 | VARCHAR2 | 256 | Fourth line of the Identifying address | ||||
CITY | VARCHAR2 | 64 | City of the Identifying address | ||||
COUNTRY | VARCHAR2 | 16 | The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address. | ||||
COUNTY | VARCHAR2 | 64 | County of the Identifying address | ||||
POSTAL_CODE | VARCHAR2 | 64 | Postal Code of the Identifying address | ||||
PROVINCE | VARCHAR2 | 64 | Province of the Identifying address | ||||
STATE | VARCHAR2 | 64 | State of the Identifying address | ||||
LATITUDE | NUMBER | Used to store Latitude Information for the Location for Spatial Proximity and containment purposes | |||||
LONGITUDE | NUMBER | Used to store Longitude Information for the Location for Spatial Proximity and containment purposes | |||||
END_DATE_ACTIVE | DATE | Indicates the date at which the resource becomes inactive | |||||
START_DATE_ACTIVE | DATE | Date this role-resource becomes active | |||||
CREATION_DATE | TIMESTAMP | who column for creation date |
Copyright © 2019, 2023, Oracle and/or its affiliates.