Expense_amortization_rules

Columns

Name	Type	Length	Precision	Scale	References	In	Description
amount_source	VARCHAR2	150					Amount source
contra_account_id	NUMBER		39	0	account_id	Accounts	Contra account ID
date_created	TIMESTAMP						Date created
date_last_modified	TIMESTAMP						Date last modified
end_date_change_impact	VARCHAR2	150					End date change impact
end_date_source	VARCHAR2	150					End date source
expense_rule_id	NUMBER		39	0			Expense rule ID
initial_amount	VARCHAR2	42					Initial amount
name	VARCHAR2	99					Name
period_offset	NUMBER		39	0			Period offset
recognition_period	NUMBER		39	0			Recognition period
reforecast_method	VARCHAR2	150					Reforecast method
residual	VARCHAR2	42					Residual
rule_method	VARCHAR2	150					Rule method
start_date_source	VARCHAR2	150					Start date source
start_offset	NUMBER		39	0			Start offset
term_in_days	NUMBER		39	0			Term in days
term_in_months	NUMBER		39	0			Term in months

Primary key

PK Column Name
expense_rule_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
expense_amortization_rules_accounts_fk	contra_account_id	Accounts	account_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Expense_plans_expense_amortization_rules_fk	expense_rule_id	Expense_plans	expense_rule_id	1