Sales_reps

The Entity Fields custom field is available for the Sales Reps table.

Columns

Name Type Length Precision Scale References In Description
account_number VARCHAR2 4000 Account number
address VARCHAR2 999 Address
address1 VARCHAR2 150 Address line 1
address2 VARCHAR2 150 Address line 2
address3 VARCHAR2 150 Address line 3
approval_limit NUMBER 20 2 Approval limit
approver_id NUMBER 39 0 Approver ID
birthdate TIMESTAMP Birth date
city VARCHAR2 50 City
class_id NUMBER 39 0 Class ID
country VARCHAR2 50 Country
create_date TIMESTAMP Create date
date_last_modified TIMESTAMP Date last modified (GMT)
department_id NUMBER 39 0 Department ID
email VARCHAR2 254 Email
employee_type_id NUMBER 39 0 Employee type ID
firstname VARCHAR2 32 First name
full_name VARCHAR2 1800 Full name
identification_number VARCHAR2 11 Social security number
initials VARCHAR2 3 Initials
isinactive VARCHAR2 3 Employee is inactive
lastname VARCHAR2 32 Last name
loginaccess VARCHAR2 3 Login access
midname VARCHAR2 32 Middle name
name VARCHAR2 83 Name
notes VARCHAR2 4000 Notes
phone VARCHAR2 100 Phone
sales_rep_extid VARCHAR2 255 Sales rep external ID
sales_rep_id NUMBER 39 0 Sales rep ID
sales_role_id NUMBER 39 0 Sales role
salutation VARCHAR2 30 Salutation
state VARCHAR2 50 State
subsidiary_id NUMBER 39 0 Subsidiary ID
supervisor_id NUMBER 39 0 Supervisor ID
zipcode VARCHAR2 36 Zip code

Primary key

PK Column Name
sales_rep_id

Foreign keys referencing this table

FK Name PK Column Name FK Table Name FK Column Name Key Seq
Posting_account_activity_sales_reps_fk sales_rep_id Posting_account_activity sales_rep_id 1