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.
| 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 | |
| activity_date | TIMESTAMP | Activity date | |||||
| amount | NUMBER | 25 | 2 | Amount | |||
| amount_foreign | NUMBER | 25 | 2 | Foreign amount | |||
| balance_from_subsidiary_id | NUMBER | 39 | 0 |
subsidiary_id |
Subsidiaries |
Source subsidiary ID | |
| class_id | NUMBER | 39 | 0 |
class_id |
Classes |
Class ID | |
| department_id | NUMBER | 39 | 0 |
department_id |
Departments |
Department ID | |
| entity_id | NUMBER | 39 | 0 | Entity ID | |||
| item_id | NUMBER | 39 | 0 |
item_id |
Items |
Item ID | |
| location_id | NUMBER | 39 | 0 |
location_id |
Locations |
Location ID | |
| partner_id | NUMBER | 39 | 0 |
partner_id |
Partners |
Partner ID | |
| promotion_code_id | NUMBER | 39 | 0 |
promotion_code_id |
Promotion_codes |
Promotion code ID | |
| quantity | NUMBER | 25 | 8 | Quantity | |||
| sales_rep_id | NUMBER | 39 | 0 |
sales_rep_id |
Sales_reps |
Sales representative ID | |
| subsidiary_id | NUMBER | 39 | 0 |
subsidiary_id |
Subsidiaries |
Posting subsidiary ID |
| FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
|---|---|---|---|---|
| posting_account_activity_pe_accounting_books_fk | accounting_book_id | Accounting_books | accounting_book_id | 1 |
| posting_account_activity_pe_accounting_periods_fk | accounting_period_id | Accounting_periods | accounting_period_id | 1 |
| posting_account_activity_pe_accounts_fk | account_id | Accounts | account_id | 1 |
| posting_account_activity_pe_classes_fk | class_id | Classes | class_id | 1 |
| posting_account_activity_pe_departments_fk | department_id | Departments | department_id | 1 |
| posting_account_activity_pe_items_fk | item_id | Items | item_id | 1 |
| posting_account_activity_pe_locations_fk | location_id | Locations | location_id | 1 |
| posting_account_activity_pe_partners_fk | partner_id | Partners | partner_id | 1 |
| posting_account_activity_pe_promotion_codes_fk | promotion_code_id | Promotion_codes | promotion_code_id | 1 |
| posting_account_activity_pe_sales_reps_fk | sales_rep_id | Sales_reps | sales_rep_id | 1 |
| posting_account_activity_pe_subsidiaries_fk | subsidiary_id | Subsidiaries | subsidiary_id | 1 |
| posting_account_activity_pe_subsidiaries_fk_2 | balance_from_subsidiary_id | Subsidiaries | subsidiary_id | 1 |