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