Posting_account_activity
Important: You can use this table, instead of the
Account_activity and
Account_period_activity tables, to get the widest variety of groupings for account activity, including account, subaccount, class, department, location, and subsidiary. You need to include a Group By statement in your query to organize results. This table includes the same data that is used to calculate results in financial statement reports, however, this table does not include layout information that is used to build these reports.
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 |
activity_date |
TIMESTAMP |
|
|
|
|
|
Activity date |
amount |
NUMBER |
|
25 |
2 |
|
|
Amount |
amount_foreign |
NUMBER |
|
25 |
2 |
|
|
Foreign amount |
class_id |
NUMBER |
|
39 |
0 |
class_id
|
Classes
|
Class ID |
custom_transaction_type_id |
NUMBER |
|
39 |
0 |
|
|
Custom transaction type 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
|
Subsidiary ID |
transaction_type |
VARCHAR2 |
8 |
|
|
|
|
Transaction type |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
posting_account_activity_accounting_books_fk |
accounting_book_id |
Accounting_books |
accounting_book_id |
1 |
posting_account_activity_accounting_periods_fk |
accounting_period_id |
Accounting_periods |
accounting_period_id |
1 |
posting_account_activity_accounts_fk |
account_id |
Accounts |
account_id |
1 |
posting_account_activity_classes_fk |
class_id |
Classes |
class_id |
1 |
posting_account_activity_departments_fk |
department_id |
Departments |
department_id |
1 |
posting_account_activity_items_fk |
item_id |
Items |
item_id |
1 |
posting_account_activity_locations_fk |
location_id |
Locations |
location_id |
1 |
posting_account_activity_partners_fk |
partner_id |
Partners |
partner_id |
1 |
posting_account_activity_promotion_codes_fk |
promotion_code_id |
Promotion_codes |
promotion_code_id |
1 |
posting_account_activity_sales_reps_fk |
sales_rep_id |
Sales_reps |
sales_rep_id |
1 |
posting_account_activity_subsidiaries_fk |
subsidiary_id |
Subsidiaries |
subsidiary_id |
1 |
This table is included in the following domains
Domain diagrams
General_accounting