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