Accounting_books
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 | ||||
| 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 | 128 | Status | ||||
| unbilled_receivable_grouping | VARCHAR2 | 60 | Unbilled receivable grouping |
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 |
| 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 |
| 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
Multibooks
