Imported_employee_expenses
This table includes data related to the transaction details of imported corporate cards.
The table’s data is available only for accounts with the Expense Reports feature enabled.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
billed_amount |
NUMBER |
|
30 |
15 |
|
|
Billed amount |
billed_currency_id |
NUMBER |
|
39 |
0 |
currency_id
|
Currencies
|
Billed currency ID |
billed_tax_amount |
NUMBER |
|
30 |
15 |
|
|
Billed tax amount |
card_currency_id |
NUMBER |
|
39 |
0 |
currency_id
|
Currencies
|
Card currency ID |
cost_center |
VARCHAR2 |
13 |
|
|
|
|
Cost Center |
currency_exchange_rate |
NUMBER |
|
30 |
15 |
|
|
Currency exchange rate |
date_charge |
TIMESTAMP |
|
|
|
|
|
Date charge |
employee_id |
NUMBER |
|
39 |
0 |
employee_id
|
Employees
|
Employee ID |
expense_category_id |
NUMBER |
|
39 |
0 |
expense_category_id
|
Expense_categories
|
Expense Category ID |
format_profile_id |
NUMBER |
|
39 |
0 |
|
|
Format profile ID |
imported_empl_expense_extid |
VARCHAR2 |
255 |
|
|
|
|
Imported employee expense external ID |
imported_employee_expense_id |
NUMBER |
|
39 |
0 |
|
|
Imported employee expense ID |
is_corporate_card |
VARCHAR2 |
3 |
|
|
|
|
Whether the expense corresponds to a corporate card expense |
local_charge_amount |
NUMBER |
|
30 |
15 |
|
|
Local charge amount |
local_tax_amount |
NUMBER |
|
30 |
15 |
|
|
Local tax amount |
memo |
VARCHAR2 |
45 |
|
|
|
|
Memo |
source_id |
NUMBER |
|
39 |
0 |
source_type_id
|
Employee_expense_sources
|
ID of the source type of the imported employee expenses. This value corresponds to the source_type_id of the employee_expense_sources table. |
source_type_id |
VARCHAR2 |
16 |
|
|
|
|
Source type ID |
status_id |
VARCHAR2 |
20 |
|
|
|
|
Status ID |
transaction_id |
VARCHAR2 |
50 |
|
|
|
|
Transaction ID |
Primary key
PK Column Name |
imported_employee_expense_id |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
imported_employee_expenses_currencies_fk |
billed_currency_id |
Currencies |
currency_id |
1 |
imported_employee_expenses_currencies_fk_2 |
card_currency_id |
Currencies |
currency_id |
1 |
imported_employee_expenses_employee_expense_sources_fk |
source_id |
Employee_expense_sources |
source_type_id |
1 |
imported_employee_expenses_employees_fk |
employee_id |
Employees |
employee_id |
1 |
imported_employee_expenses_expense_categories_fk |
expense_category_id |
Expense_categories |
expense_category_id |
1 |