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