Accounting_periods

Important: The following columns are provided for backward compatibility, but you are strongly discouraged from using them: closed_accounts_payable, closed_accounts_receivable, closed_all, closed_payroll. This new model is based on the locking of period transactions and completion of pre-close tasks before the period is closed.

Columns

Name	Type	Length	Precision	Scale	References	In	Description
accounting_period_id	NUMBER		39	0			Accounting period ID
closed	VARCHAR2	3					Whether the period is closed
closed_accounts_payable	VARCHAR2	3					Whether the period is closed for accounts payable (Use for backward compatibility only)
closed_accounts_receivable	VARCHAR2	3					Whether the period is closed for accounts receivable (Use for backward compatibility only)
closed_all	VARCHAR2	3					Whether the period is closed for all (Use for backward compatibility only)
closed_on	TIMESTAMP						Date period was closed
closed_payroll	VARCHAR2	3					Whether the period is closed for payroll (Use for backward compatibility only)
date_last_modified	TIMESTAMP						Date last modified
ending	TIMESTAMP						End date
fiscal_calendar_id	NUMBER		39	0			Fiscal calendar ID
full_name	VARCHAR2	597					Full name
is_adjustment	VARCHAR2	3					Whether the accounting period is an adjustment period
isinactive	VARCHAR2	3					Accounting period is inactive
locked_accounts_payable	VARCHAR2	3					Whether A/P locked
locked_accounts_receivable	VARCHAR2	3					Whether A/R locked
locked_all	VARCHAR2	3					Whether all locked
locked_payroll	VARCHAR2	3					Whether payroll locked
name	VARCHAR2	64					Name
parent_id	NUMBER		39	0	accounting_period_id	Accounting_periods	Subperiod of
quarter	VARCHAR2	3					Period is a quarter
starting	TIMESTAMP						Start date
year_0	VARCHAR2	3					Year
year_id	NUMBER		39	0	accounting_period_id	Accounting_periods	Year of accounting period

Primary key

PK Column Name
accounting_period_id

Foreign keys in this table

FK Name	FK Column Name	PK Table Name	PK Column Name	Key Seq
accounting_periods_accounting_periods_fk	parent_id	Accounting_periods	accounting_period_id	1
accounting_periods_accounting_periods_fk_2	year_id	Accounting_periods	accounting_period_id	1

Foreign keys referencing this table

FK Name	PK Column Name	FK Table Name	FK Column Name	Key Seq
Account_period_activity_accounting_periods_fk	accounting_period_id	Account_period_activity	accounting_period_id	1
Account_period_activity_pe_accounting_periods_fk	accounting_period_id	Account_period_activity_pe	accounting_period_id	1
Accounting_periods_accounting_periods_fk	accounting_period_id	Accounting_periods	parent_id	1
Accounting_periods_accounting_periods_fk_2	accounting_period_id	Accounting_periods	year_id	1
Amortization_sched_lines_accounting_periods_fk	accounting_period_id	Amortization_sched_lines	accounting_period_id	1
Budget_accounting_periods_fk	accounting_period_id	Budget	accounting_period_id	1
Consolidated_exchange_rates_accounting_periods_fk	accounting_period_id	Consolidated_exchange_rates	accounting_period_id	1
Customers_accounting_periods_fk	accounting_period_id	Customers	first_sale_period_id	1
Customers_accounting_periods_fk_2	accounting_period_id	Customers	last_sale_period_id	1
Expense_plan_lines_accounting_periods_fk	accounting_period_id	Expense_plan_lines	accounting_period_id	1
Expense_plans_accounting_periods_fk	accounting_period_id	Expense_plans	accounting_period_id	1
Opportunities_accounting_periods_fk	accounting_period_id	Opportunities	accounting_period_id	1
Posting_account_activity_accounting_periods_fk	accounting_period_id	Posting_account_activity	accounting_period_id	1
Posting_account_activity_pe_accounting_periods_fk	accounting_period_id	Posting_account_activity_pe	accounting_period_id	1
Revenue_plan_lines_accounting_periods_fk	accounting_period_id	Revenue_plan_lines	accounting_period_id	1
Revenue_plan_version_lines_accounting_periods_fk	accounting_period_id	Revenue_plan_version_lines	accounting_period_id	1
Revenue_plans_accounting_periods_fk	accounting_period_id	Revenue_plans	accounting_period_id	1
Revrecschedulelines_accounting_periods_fk	accounting_period_id	Revrecschedulelines	accounting_period_id	1

This table is included in the following domains

Domains
Expense_amortization
General_accounting
Invoice_with_amortization
Revenue_recognition

Domain diagrams

Expense_amortization

General_accounting

Invoice_with_amortization

Revenue_recognition