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 |