Expense_categories
The Other > Expense Category custom field is available for the Expense Categories table.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| description |
VARCHAR2 |
999 |
|
|
|
|
Description |
| expense_account_id |
NUMBER |
|
39 |
0 |
|
|
Expense account ID |
| expense_category_extid |
VARCHAR2 |
255 |
|
|
|
|
Expense category external ID |
| expense_category_id |
NUMBER |
|
39 |
0 |
|
|
Expense category ID |
| expense_item_id |
NUMBER |
|
39 |
0 |
|
|
Expense item ID |
| is_personal_corp_card_expense |
VARCHAR2 |
3 |
|
|
|
|
|
| isinactive |
VARCHAR2 |
3 |
|
|
|
|
Category is inactive |
| name |
VARCHAR2 |
61 |
|
|
|
|
Name |
| rate_required |
VARCHAR2 |
3 |
|
|
|
|
Rate required |
Primary key
| PK Column Name |
| expense_category_id |
Foreign keys referencing this table
| FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
| Expense_categories_subs_map_expense_categories_fk |
expense_category_id |
Expense_categories_subs_map |
expense_category_id |
1 |
| Imported_employee_expenses_expense_categories_fk |
expense_category_id |
Imported_employee_expenses |
expense_category_id |
1 |
| Opportunity_lines_expense_categories_fk |
expense_category_id |
Opportunity_lines |
expense_category_id |
1 |