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