Classes

The Other Custom Fields > Class custom field is available for the Classes table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
class_extid	VARCHAR2	255					Class external ID
class_id	NUMBER		39	0			Class ID
date_last_modified	TIMESTAMP						Date last modified
full_name	VARCHAR2	4000					Full name
is_including_child_subs	VARCHAR2	3					Sets department to include child subsidiaries
isinactive	VARCHAR2	3					Inactive
name	VARCHAR2	60					Name
parent_id	NUMBER		39	0	class_id	Classes	Subclass of

Primary key

PK Column Name
class_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
classes_classes_fk	parent_id	Classes	class_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Accounts_classes_fk	class_id	Accounts	class_id	1
Billing_subscription_lines_classes_fk	class_id	Billing_subscription_lines	class_id	1
Billing_subscriptions_classes_fk	class_id	Billing_subscriptions	class_id	1
Budget_classes_fk	class_id	Budget	class_id	1
Classes_classes_fk	class_id	Classes	parent_id	1
Employee_time_classes_fk	class_id	Employee_time	class_id	1
Employees_classes_fk	class_id	Employees	class_id	1
Global_account_map_classes_fk	class_id	Global_account_map	class_id	1
Item_account_map_classes_fk	class_id	Item_account_map	class_id	1
Opportunity_lines_classes_fk	class_id	Opportunity_lines	class_id	1
Posting_account_activity_classes_fk	class_id	Posting_account_activity	class_id	1
Posting_account_activity_pe_classes_fk	class_id	Posting_account_activity_pe	class_id	1
Subscription_plans_classes_fk	class_id	Subscription_plans	class_id	1
Subsidiary_class_map_classes_fk	class_id	Subsidiary_class_map	class_id	1

This table is included in the following domains

Domains
Expense_amortization
Invoice_with_amortization
Multibooks

Domain diagrams