Support_reps

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

Columns

Name Type Length Precision Scale References In Description
account_number VARCHAR2 4000 Account
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 (GMT)
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 Give access
midname VARCHAR2 32 Middle name
name VARCHAR2 83 Name
notes VARCHAR2 4000 Notes
phone VARCHAR2 100 Phone
salutation VARCHAR2 30 Salutation
state VARCHAR2 50 State
subsidiary_id NUMBER 39 0 Subsidiary ID
supervisor_id NUMBER 39 0 Supervisor ID
support_rep_extid VARCHAR2 255 Support rep external ID
support_rep_id NUMBER 39 0 Support rep ID
zipcode VARCHAR2 36 Zip code

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
support_reps_accounts_fk def_acct_corp_card_expenses_id Accounts account_id 1
support_reps_currencies_fk def_expense_report_currency_id Currencies currency_id 1