Income_accounts

Columns

Name	Type	Length	Precision	Scale	References	In	Description
account_number	VARCHAR2	60					Account number
comments	VARCHAR2	25					Comments
current_balance	NUMBER		39	0			Current balance
date_last_modified	TIMESTAMP						Date Last Modified
desription	VARCHAR2	60					Description
full_name	VARCHAR2	4000					Full name
income_account_extid	VARCHAR2	255					Income account external ID
income_account_id	NUMBER		39	0	account_id	Accounts	Income account ID
is_including_child_subs	VARCHAR2	3					Whether includes child subsidiaries
is_summary	VARCHAR2	3					Whether is a summary
isinactive	VARCHAR2	3					Account is inactive
legal_name	VARCHAR2	400					Legal name
name	VARCHAR2	93					Name
parent_id	NUMBER		39	0			Subaccount of

Primary key

PK Column Name
income_account_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
income_accounts_accounts_fk	income_account_id	Accounts	account_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Subscription_plans_income_accounts_fk	income_account_id	Subscription_plans	income_account_id	1