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
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_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 64 Status
unbilled_receivable_grouping VARCHAR2 60 Unbilled receivable grouping

Primary key

PK Column Name

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
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
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