The Entity Fields custom field is available for the Support Reps table.
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 | |||
VARCHAR2 | 254 | ||||||
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 |
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 |