Accounting_books
The table lists all Accounting Books in the system and their fields.
Columns
| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| accounting_book_extid |
VARCHAR2 |
255 |
|
|
|
|
Accounting Book Extension ID |
| accounting_book_id |
NUMBER |
|
39 |
0 |
|
|
Accounting book ID |
| accounting_book_name |
VARCHAR2 |
31 |
|
|
|
|
Name of the book |
| base_book_id |
NUMBER |
|
39 |
0 |
accounting_book_id
|
Accounting_books
|
Base book ID |
| date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
| date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
| effective_period_id |
NUMBER |
|
39 |
0 |
|
|
Effective Period ID |
| form_template_component_id |
VARCHAR2 |
16 |
|
|
|
|
form template component ID |
| form_template_id |
NUMBER |
|
39 |
0 |
|
|
Form template ID |
| is_adjustment_only |
VARCHAR2 |
3 |
|
|
|
|
Is adjustment only |
| is_arrangement_level_reclass |
VARCHAR2 |
3 |
|
|
|
|
Whether arrangement level unbilled receivable reclassification is used |
| is_consolidated |
VARCHAR2 |
3 |
|
|
|
|
Whether is consolidated |
| is_contingent_revenue_handling |
VARCHAR2 |
3 |
|
|
|
|
Whether handles contingent revenue |
| is_include_child_subsidiaries |
VARCHAR2 |
3 |
|
|
|
|
Whether includes child subsidiaries |
| is_primary |
VARCHAR2 |
3 |
|
|
|
|
Whether book is primary or secondary |
| is_two_step_revenue_allocation |
VARCHAR2 |
3 |
|
|
|
|
Whether two-step revenue allocation is used |
| status |
VARCHAR2 |
128 |
|
|
|
|
Status |
| unbilled_receivable_grouping |
VARCHAR2 |
60 |
|
|
|
|
Unbilled receivable grouping |
Primary key
| PK Column Name |
| accounting_book_id |
Foreign keys in this table
| FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
| accounting_books_accounting_books_fk |
base_book_id |
Accounting_books |
accounting_book_id |
1 |
Foreign keys referencing this table
| FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
| Account_activity_accounting_books_fk |
accounting_book_id |
Account_activity |
accounting_book_id |
1 |
| Account_period_activity_accounting_books_fk |
accounting_book_id |
Account_period_activity |
accounting_book_id |
1 |
| Account_period_activity_pe_accounting_books_fk |
accounting_book_id |
Account_period_activity_pe |
accounting_book_id |
1 |
| Accounting_books_accounting_books_fk |
accounting_book_id |
Accounting_books |
base_book_id |
1 |
| Budget_accounting_books_fk |
accounting_book_id |
Budget |
accounting_book_id |
1 |
| Expense_plans_accounting_books_fk |
accounting_book_id |
Expense_plans |
transaction_book_id |
1 |
| Global_account_map_accounting_books_fk |
accounting_book_id |
Global_account_map |
accounting_book_id |
1 |
| Item_account_map_accounting_books_fk |
accounting_book_id |
Item_account_map |
accounting_book_id |
1 |
| Posting_account_activity_accounting_books_fk |
accounting_book_id |
Posting_account_activity |
accounting_book_id |
1 |
| Posting_account_activity_pe_accounting_books_fk |
accounting_book_id |
Posting_account_activity_pe |
accounting_book_id |
1 |
| Transaction_book_map_accounting_books_fk |
accounting_book_id |
Transaction_book_map |
accounting_book_id |
1 |
| Transaction_line_book_map_accounting_books_fk |
accounting_book_id |
Transaction_line_book_map |
accounting_book_id |
1 |
This table is included in the following domains
Domain diagrams
Multibooks
