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 20 2 Amount
amount_foreign NUMBER 20 2 Foreign amount
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
Subsidiary ID

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

Domains
General_accounting

Domain diagrams

General_accounting