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)
def_acct_corp_card_expenses_id	NUMBER		39	0	account_id	Accounts	ID of the default account for corporate card in expense report
def_expense_report_currency_id	NUMBER		39	0	currency_id	Currencies
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 in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
sales_reps_accounts_fk	def_acct_corp_card_expenses_id	Accounts	account_id	1
sales_reps_currencies_fk	def_expense_report_currency_id	Currencies	currency_id	1

Foreign keys referencing this table

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