Account_period_activity_pe

This table includes all transactions. Note that when the ID of the balance_from_subsidiary_id and the subsidiary_id fields are different, the Period End Journal transaction represents transactions from the source subsidiary. When both fields have the same ID, the Period End Journal transaction represents transactions from the posting 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
balance_from_subsidiary_id NUMBER 39 0 Source subsidiary ID
department_id NUMBER 39 0 Department ID
is_hidden_custom_line VARCHAR2 3 Whether the custom line is hidden
subsidiary_id NUMBER 39 0 subsidiary_id
Subsidiaries
Posting subsidiary ID

Primary key (Composite)

PK Column Name
accounting_book_id
account_id
accounting_period_id
subsidiary_id
department_id
balance_from_subsidiary_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_pe_accounting_books_fk accounting_book_id Accounting_books accounting_book_id 1
account_period_activity_pe_accounting_periods_fk accounting_period_id Accounting_periods accounting_period_id 1
account_period_activity_pe_accounts_fk account_id Accounts account_id 1
account_period_activity_pe_subsidiaries_fk subsidiary_id Subsidiaries subsidiary_id 1