| Name | Type | Length | Precision | Scale | References | In | Description |
|---|---|---|---|---|---|---|---|
| accounting_period_id | NUMBER | 39 | 0 |
accounting_period_id |
Accounting_periods |
Accounting period ID | |
| amount | NUMBER | 20 | 2 | Amount | |||
| date_created | TIMESTAMP | Date created | |||||
| date_last_modified | TIMESTAMP | Date last modified | |||||
| deferred_expense_account_id | NUMBER | 39 | 0 |
account_id |
Accounts |
Deferred expense account ID | |
| expense_account_id | NUMBER | 39 | 0 |
account_id |
Accounts |
Expense account ID | |
| is_recognized | VARCHAR2 | 3 | Is recognized | ||||
| journal_id | NUMBER | 39 | 0 |
transaction_id |
Transactions |
Journal ID | |
| plan_id | NUMBER | 39 | 0 |
plan_id |
Expense_plans |
Plan ID | |
| planned_expense_type | VARCHAR2 | 250 | Planned expense type |
| FK Name | FK Column Name | PK Table Name | PK Column Name | Key Seq |
|---|---|---|---|---|
| expense_plan_lines_accounting_periods_fk | accounting_period_id | Accounting_periods | accounting_period_id | 1 |
| expense_plan_lines_accounts_fk | deferred_expense_account_id | Accounts | account_id | 1 |
| expense_plan_lines_accounts_fk_1 | expense_account_id | Accounts | account_id | 1 |
| expense_plan_lines_expense_plans_fk | plan_id | Expense_plans | plan_id | 1 |
| expense_plan_lines_transactions_fk | journal_id | Transactions | transaction_id | 1 |