Transaction_line_book_map

Columns

Name Type Length Precision Scale References In Description
account_id NUMBER 39 0 account_id
Accounts
Account ID
accounting_book_id NUMBER 39 0 accounting_book_id
Accounting_books
Accounting Book ID
alt_sales_amount NUMBER 20 2 Alt sales amount
amortization_residual VARCHAR2 42 Amortization residual
amount NUMBER 20 2 Amount
amount_linked NUMBER 20 2 Amount linked
bill_variance_status VARCHAR2 50 Bill variance status
catch_up_period_id NUMBER 39 0 Catch up period ID
date_rev_rec_end TIMESTAMP Date revenue received end
date_rev_rec_start TIMESTAMP Date revenue received start
date_revenue_committed TIMESTAMP Date revenue committed
gross_amount NUMBER 39 0 Gross amount
is_hold_rev_rec VARCHAR2 3 Whether to put revenue recognition plan on hold
quantity_committed NUMBER 18 8 Quantity committed
schedule_id NUMBER 39 0 schedule_id
Revrecschedules
Schedule ID
transaction_id NUMBER 39 0 transaction_id
Transaction_lines
Transaction ID
transaction_line_id NUMBER 39 0 transaction_line_id
Transaction_lines
Transaction Line ID
vsoe_allocation NUMBER 20 2 VSOE allocation

Primary key (Composite)

PK Column Name
accounting_book_id
transaction_id
transaction_line_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
transaction_line_book_map_accounting_books_fk accounting_book_id Accounting_books accounting_book_id 1
transaction_line_book_map_accounts_fk account_id Accounts account_id 1
transaction_line_book_map_revrecschedules_fk schedule_id Revrecschedules schedule_id 1
transaction_line_book_map_transaction_lines_fk transaction_id Transaction_lines transaction_id 1
transaction_line_book_map_transaction_lines_fk transaction_line_id Transaction_lines transaction_line_id 2

This table is included in the following domains

Domains
Multibooks
Revenue_recognition

Domain diagrams

Multibooks
Revenue_recognition