Revenue_plan_version_lines

Columns

Name Type Length Precision Scale References In Description
accounting_period_id NUMBER 39 0 accounting_period_id
Accounting_periods
amount NUMBER 20 2
comments VARCHAR2 200
date_created TIMESTAMP
deferral_account_id NUMBER 39 0 account_id
Accounts
journal_id NUMBER 39 0 transaction_id
Transactions
plan_version_id NUMBER 39 0 plan_version_id
Revenue_plan_versions
planned_revenue_type VARCHAR2 250
recognition_account_id NUMBER 39 0 account_id
Accounts

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
revenue_plan_version_lines_accounting_periods_fk accounting_period_id Accounting_periods accounting_period_id 1
revenue_plan_version_lines_accounts_fk deferral_account_id Accounts account_id 1
revenue_plan_version_lines_accounts_fk_1 recognition_account_id Accounts account_id 1
revenue_plan_version_lines_revenue_plan_versions_fk plan_version_id Revenue_plan_versions plan_version_id 1
revenue_plan_version_lines_transactions_fk journal_id Transactions transaction_id 1