Expense_plans

Columns

Name	Type	Length	Precision	Scale	References	In	Description
accounting_period_id	NUMBER		39	0	accounting_period_id	Accounting_periods	Accounting period ID
comments	VARCHAR2	500					Comments
date_created	TIMESTAMP						Date created
date_last_modified	TIMESTAMP						Date last modified
end_date	TIMESTAMP						End date
expense_plan_status	VARCHAR2	128					Expense plan status
expense_plan_type	VARCHAR2	128					Expense plan type
expense_rule_id	NUMBER		39	0	expense_rule_id	Expense_amortization_rules	Expense rule ID
is_hold_expense	VARCHAR2	3					Is hold expense
plan_id	NUMBER		39	0			Plan ID
plan_number	VARCHAR2	99					Plan number
reforecast_method	VARCHAR2	150					Reforecast method
related_revenue_arrangement_id	NUMBER		39	0	transaction_id	Transactions	Related revenue arrangement ID
related_revenue_element_id	NUMBER		39	0	revenue_element_id	Revenue_elements	Related revenue element ID
residual	NUMBER		20	2			Residual
start_date	TIMESTAMP						Start date
transaction_book_id	NUMBER		39	0	accounting_book_id	Accounting_books	Transaction book ID
transaction_doc_id	NUMBER		39	0	transaction_id	Transaction_lines	Transaction document ID
transaction_line_id	NUMBER		39	0	transaction_line_id	Transaction_lines	Transaction line ID

Primary key

PK Column Name
plan_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
expense_plans_accounting_books_fk	transaction_book_id	Accounting_books	accounting_book_id	1
expense_plans_accounting_periods_fk	accounting_period_id	Accounting_periods	accounting_period_id	1
expense_plans_expense_amortization_rules_fk	expense_rule_id	Expense_amortization_rules	expense_rule_id	1
expense_plans_revenue_elements_fk	related_revenue_element_id	Revenue_elements	revenue_element_id	1
expense_plans_transaction_lines_fk	transaction_doc_id	Transaction_lines	transaction_id	1
expense_plans_transaction_lines_fk_1	transaction_line_id	Transaction_lines	transaction_line_id	1
expense_plans_transactions_fk	related_revenue_arrangement_id	Transactions	transaction_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Expense_plan_lines_expense_plans_fk	plan_id	Expense_plan_lines	plan_id	1