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
Domain diagrams
Expense_amortization
General_accounting
Invoice_with_amortization
Revenue_recognition