Name | Type | Length | Precision | Scale | References | In | Description |
---|---|---|---|---|---|---|---|
account_id | NUMBER | 22 | 0 |
account_id |
Accounts |
Account ID | |
accounting_period_id | NUMBER | 22 | 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 | 22 | 0 |
transaction_id |
Transactions |
Journal ID | |
schedule_id | NUMBER | 22 | 0 |
schedule_id |
Revrecschedules |
Revenue recognition Schedule ID |
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 |
Domains |
---|
General_accounting |
Revenue_recognition |