Account_period_activity
Important: This table does not return totals by class or location. Use the
Posting_account_activity table to get the widest variety of groupings for account activity, including account, subaccount, class, department, location, and subsidiary.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
account_id |
NUMBER |
|
39 |
0 |
account_id
|
Accounts
|
Account ID |
accounting_book_id |
NUMBER |
|
39 |
0 |
accounting_book_id
|
Accounting_books
|
Accounting book ID |
accounting_period_id |
NUMBER |
|
39 |
0 |
accounting_period_id
|
Accounting_periods
|
Accounting period ID |
amount |
NUMBER |
|
39 |
0 |
|
|
Amount |
department_id |
NUMBER |
|
39 |
0 |
department_id
|
Departments
|
Department ID |
is_hidden_custom_line |
VARCHAR2 |
3 |
|
|
|
|
Whether the custom line is hidden |
subsidiary_id |
NUMBER |
|
39 |
0 |
subsidiary_id
|
Subsidiaries
|
Subsidiary ID |
Primary key (Composite)
PK Column Name |
accounting_book_id |
account_id |
accounting_period_id |
subsidiary_id |
department_id |
is_hidden_custom_line |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
account_period_activity_accounting_books_fk |
accounting_book_id |
Accounting_books |
accounting_book_id |
1 |
account_period_activity_accounting_periods_fk |
accounting_period_id |
Accounting_periods |
accounting_period_id |
1 |
account_period_activity_accounts_fk |
account_id |
Accounts |
account_id |
1 |
account_period_activity_departments_fk |
department_id |
Departments |
department_id |
1 |
account_period_activity_subsidiaries_fk |
subsidiary_id |
Subsidiaries |
subsidiary_id |
1 |
This table is included in the following domains
Domain diagrams
Expense_amortization
General_accounting