Transaction_book_map

Columns

Name Type Length Precision Scale References In Description
accounting_book_id NUMBER 39 0 accounting_book_id
Accounting_books
Accounting Book ID
date_revenue_committed TIMESTAMP Date revenue committed
exchange_rate NUMBER 30 15 Exchange rate
is_vsoe_bundle VARCHAR2 3 Is VSOE bundle
needs_revenue_commitment VARCHAR2 3 Needs revenue commitment
revenue_commitment_status VARCHAR2 480 Revenue commitment status
revenue_status VARCHAR2 480 Revenue status
transaction_id NUMBER 39 0 transaction_id
Transactions
Transaction ID

Primary key (Composite)

PK Column Name
accounting_book_id
transaction_id

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
transaction_book_map_accounting_books_fk accounting_book_id Accounting_books accounting_book_id 1
transaction_book_map_transactions_fk transaction_id Transactions transaction_id 1

This table is included in the following domains

Domains
Multibooks

Domain diagrams

Multibooks