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 | 128 | Bill variance status | ||||
| catch_up_period_id | NUMBER | 39 | 0 | Catch up period ID | |||
| date_created | TIMESTAMP | Date created | |||||
| date_last_modified | TIMESTAMP | Date last modified | |||||
| 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 | |||||
| gl_number | VARCHAR2 | 80 | GL number | ||||
| gl_sequence | VARCHAR2 | 256 | GL sequence | ||||
| gl_sequence_id | NUMBER | 39 | 0 | GL sequence ID | |||
| 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
