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


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

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