Accounting_books

Columns

Name	Type	Length	Precision	Scale	References	In	Description
accounting_book_extid	VARCHAR2	255					Accounting Book Extension ID
accounting_book_id	NUMBER		22	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		22	0			Effective Period ID
form_template_component_id	VARCHAR2	16					form template component ID
form_template_id	NUMBER		22	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

Primary key

PK Column Name
accounting_book_id

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

Domains
Multibooks

Domain diagrams