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
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
Opportunity_lines_expense_categories_fk expense_category_id Opportunity_lines expense_category_id 1