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