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.


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
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
Year of accounting period

Primary key

PK Column Name

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


Domain diagrams