[Home] [Help] [Dependency Information]
Object Name: | BIL_DIMV_SALESFORCE |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | BIL.BIL_DIMV_SALESFORCE |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
BIL_DIMV_SALESFORCE - Dimension view used to provide descriptive information for salesforce
members (salesreps), using resource_id in jtf_rs_resource_extns table.
.
Source is Oracle Applications Human Resource and CRM Foundation schemas.
.
.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SALESFORCE_PK | NUMBER | Resource identifier for salesrep | ||
RESOURCE_NUMBER | VARCHAR2 | (30) | Resource Number for sales person. This is a Unique and shown to user on forms. | |
SALESFORCE_STATUS | NUMBER | Status of salesrep whether he or she is active in AR or not ( Used for OTHER type of Salesreps) | ||
SALESFORCE_TYPE | VARCHAR2 | (30) | Category of Resource. Validating from JTF_OBJECTS_VL. Allowed values: EMPLOYEE, PARTNER, PARTY, SUPPLIER_CONTACT, OTHER | |
EMPLOYEE_PERSON_FK | VARCHAR2 | (30) | Salesrep employee id | |
LAST_NAME | VARCHAR2 | (150) | Salesrep last name | |
FIRST_NAME | VARCHAR2 | (150) | Salesrep first name | |
FULL_NAME | VARCHAR2 | (301) | Salesrep full name | |
COMPENSATION_CURRENCY_CODE | VARCHAR2 | (15) | Currency in which salesrep is compensated | |
START_DATE_ACTIVE | DATE | Date this Resource becomes active, if limited | ||
END_DATE_ACTIVE | DATE | Date this Resource becomes inactive, if limited | ||
EMPLOYMENT_STATUS_FK | VARCHAR2 | (30) | User defined category. For example Full-Time Permanent or Part-Time Permanent. | |
JOB_FK | NUMBER | Salesrep job title | ||
MANAGING_EMPLOYEE_ID | NUMBER | Employee id of salesrep's manager | ||
ID | VARCHAR2 | (40) | Salesrep id | |
VALUE | VARCHAR2 | (80) | Salesrep name |
Cut, paste (and edit) the following text to query this object:
SELECT SALESFORCE_PK
, RESOURCE_NUMBER
, SALESFORCE_STATUS
, SALESFORCE_TYPE
, EMPLOYEE_PERSON_FK
, LAST_NAME
, FIRST_NAME
, FULL_NAME
, COMPENSATION_CURRENCY_CODE
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, EMPLOYMENT_STATUS_FK
, JOB_FK
, MANAGING_EMPLOYEE_ID
, ID
, VALUE
FROM APPS.BIL_DIMV_SALESFORCE;
|
|
|