Revrecschedulelines

Columns

Name Type Length Precision Scale References In Description
account_id NUMBER 39 0 account_id
Accounts
Account ID
accounting_period_id NUMBER 39 0 accounting_period_id
Accounting_periods
Accounting period ID
amount VARCHAR2 42 Amount
is_recognized VARCHAR2 3 Is rev rec schedule manually recognized
journal_id NUMBER 39 0 transaction_id
Transactions
Journal ID
schedule_id NUMBER 39 0 schedule_id
Revrecschedules
Revenue recognition Schedule ID

Foreign keys in this table

FK Name FK Column Name PK Table Name PK Column Name Key Seq
revrecschedulelines_accounting_periods_fk accounting_period_id Accounting_periods accounting_period_id 1
revrecschedulelines_accounts_fk account_id Accounts account_id 1
revrecschedulelines_revrecschedules_fk schedule_id Revrecschedules schedule_id 1
revrecschedulelines_transactions_fk journal_id Transactions transaction_id 1

This table is included in the following domains

Domains
General_accounting
Revenue_recognition

Domain diagrams

General_accounting
Revenue_recognition