Revaluation

The Transaction Body Fields and Transaction Column Fields custom fields are available for the Revaluation table.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
account_id	NUMBER		39	0			Account ID
balance	NUMBER		39	0			Base currency balance
curr_fx_rate	NUMBER		30	15			Current exchange rate
currency_id	NUMBER		39	0			Currency ID
entity_id	NUMBER		39	0			Entity ID
fx_balance	NUMBER		21	3			Foreign currency balance
is_tax_reg_override	VARCHAR2	3
legal_name	VARCHAR2	400
net_variance	NUMBER		20	2			Net variance
prior_variance	NUMBER		39	0			Prior variance
promotion_code_instance_id	NUMBER		39	0			Promotion code ID
reval_class	NUMBER		39	0			Revaluation class
reval_department	NUMBER		39	0			Revaluation department
reval_line_id	NUMBER		39	0			Revaluation journal entry line ID
reval_location	NUMBER		39	0			Revaluation location
reval_memo	VARCHAR2	4000					Revaluation memo
reval_tran_id	NUMBER		39	0			Revaluation journal entry transaction ID
reval_tran_period_id	NUMBER		39	0			Revaluation journal entry posting period
reval_type	VARCHAR2	24					Revaluation transaction type
subsidiary_id	NUMBER		39	0			Subsidiary ID
tax_reg_id	NUMBER		39	0			This field is no longer supported.
total_variance	NUMBER		39	0			Total variance
tran_date	TIMESTAMP						Source transaction posting date
tran_fx_rate	NUMBER		30	15			Transaction exchange rate
tran_id	NUMBER		39	0			Source transaction ID
variance	NUMBER		20	2			Variance
variance_account_id	NUMBER		39	0	account_id	Accounts

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
revaluation_accounts_fk	variance_account_id	Accounts	account_id	1