| Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
| accounting_book_id |
NUMBER |
|
39 |
0 |
|
|
Accounting book ID |
| accounting_period_id |
NUMBER |
|
39 |
0 |
|
|
Accounting period ID |
| allocated_contract_cost_amount |
NUMBER |
|
20 |
2 |
|
|
Allocated contract cost amount |
| allocation_amount |
NUMBER |
|
20 |
2 |
|
|
Allocation amount |
| allocation_amount_foreign |
NUMBER |
|
20 |
2 |
|
|
Allocation foreign currency amount |
| allocation_type |
VARCHAR2 |
128 |
|
|
|
|
Allocation type |
| alternate_quantity |
NUMBER |
|
39 |
0 |
|
|
Alternate quantity |
| alternate_unit_id |
NUMBER |
|
39 |
0 |
|
|
Alternate unit ID |
| amortization_end_date |
TIMESTAMP |
|
|
|
|
|
Amortization end date |
| amortization_schedule_id |
NUMBER |
|
39 |
0 |
|
|
Amortization schedule ID |
| amortization_start_date |
TIMESTAMP |
|
|
|
|
|
Amortization start date |
| amortization_template_id |
NUMBER |
|
39 |
0 |
|
|
Amortization template ID |
| calculated_amount |
NUMBER |
|
20 |
2 |
|
|
Calculated amount |
| calculated_amount_foreign |
NUMBER |
|
20 |
2 |
|
|
Calculated foreign currency amount |
| class_id |
NUMBER |
|
39 |
0 |
|
|
Class ID |
| contract_cost_allocation_pct |
NUMBER |
|
39 |
0 |
|
|
Contract cost allocation percent |
| contract_exp_offset_acct_id |
NUMBER |
|
39 |
0 |
|
|
Contract expense offset account ID |
| contract_expense_account_id |
NUMBER |
|
39 |
0 |
|
|
Contract expense account ID |
| cost_amortization_amount |
NUMBER |
|
20 |
2 |
|
|
Cost amortization amount |
| create_plan_on_event_type |
VARCHAR2 |
128 |
|
|
|
|
Whether to create a revenue recognition plan on the event type |
| currency_id |
NUMBER |
|
39 |
0 |
|
|
Currency ID |
| date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
| date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
| deferral_account_id |
NUMBER |
|
39 |
0 |
|
|
Deferral account ID |
| department_id |
NUMBER |
|
39 |
0 |
|
|
Department ID |
| disc_sales_amount_foreign |
NUMBER |
|
20 |
2 |
|
|
Discounted sales foreign currency amount |
| discounted_sales_amount |
NUMBER |
|
20 |
2 |
|
|
Discounted sales amount |
| end_date |
TIMESTAMP |
|
|
|
|
|
End date |
| entity_id |
NUMBER |
|
39 |
0 |
|
|
Entity ID |
| exchange_rate |
NUMBER |
|
30 |
15 |
|
|
Exchange rate |
| expense_migrate_adjust_acct_id |
NUMBER |
|
39 |
0 |
|
|
Expense migrate adjust account ID |
| fair_value |
NUMBER |
|
30 |
15 |
|
|
Fair value |
| fair_value_foreign |
NUMBER |
|
30 |
15 |
|
|
Fair value in foreign currency |
| forecast_end_date |
TIMESTAMP |
|
|
|
|
|
Forecast end date |
| forecast_start_date |
TIMESTAMP |
|
|
|
|
|
Forecast start date |
| fx_adjustment_account_id |
NUMBER |
|
39 |
0 |
|
|
Foreign exchange adjustment account ID |
| is_bom_item_type |
VARCHAR2 |
3 |
|
|
|
|
Is bill of materials item type |
| is_fair_value_override |
VARCHAR2 |
3 |
|
|
|
|
Fair value override |
| is_fair_value_vsoe |
VARCHAR2 |
3 |
|
|
|
|
Whether fair value is VSOE |
| is_hold_rev_rec |
VARCHAR2 |
3 |
|
|
|
|
Whether to put revenue recognition plan on hold |
| is_permit_discount |
VARCHAR2 |
3 |
|
|
|
|
Whether the revenue element permits discount |
| is_posting_discount_applied |
VARCHAR2 |
3 |
|
|
|
|
Whether the posting discount is applied |
| item_id |
NUMBER |
|
39 |
0 |
|
|
Item ID |
| item_labor_cost_amount |
NUMBER |
|
20 |
2 |
|
|
Item labor cost amount |
| item_resale_cost_amount |
NUMBER |
|
20 |
2 |
|
|
Item resale cost amount |
| labor_deferred_expense_acct_id |
NUMBER |
|
39 |
0 |
|
|
Labor deferred expense account ID |
| labor_expense_acct_id |
NUMBER |
|
39 |
0 |
|
|
Labor expense account ID |
| last_merge_from_arrangement_id |
NUMBER |
|
39 |
0 |
|
|
Last merge from arrangement ID |
| location_id |
NUMBER |
|
39 |
0 |
|
|
Location ID |
| new_standard_migrate_date |
TIMESTAMP |
|
|
|
|
|
New standard migrate date |
| parent_bom_element_id |
NUMBER |
|
39 |
0 |
|
|
Parent bill of materials element ID |
| pending_action |
VARCHAR2 |
250 |
|
|
|
|
Pending action |
| quantity |
NUMBER |
|
18 |
8 |
|
|
Quantity |
| recognition_account_id |
NUMBER |
|
39 |
0 |
|
|
Recognition account ID |
| reference_id |
VARCHAR2 |
4000 |
|
|
|
|
Reference ID |
| return_revenue_element_id |
NUMBER |
|
39 |
0 |
|
|
Return revenue element ID |
| rev_rec_forecast_rule_id |
NUMBER |
|
39 |
0 |
|
|
Revenue recognition forecast rule ID |
| rev_rec_rule_id |
NUMBER |
|
39 |
0 |
|
|
Revenue recognition rule ID |
| revenue_allocation_group |
VARCHAR2 |
60 |
|
|
|
|
Revenue allocation group |
| revenue_allocation_ratio |
NUMBER |
|
39 |
0 |
|
|
Revenue allocation ratio |
| revenue_element_id |
NUMBER |
|
39 |
0 |
|
|
Revenue elements ID |
| revenue_element_number |
VARCHAR2 |
99 |
|
|
|
|
Revenue element number |
| revenue_migrate_adjust_acct_id |
NUMBER |
|
39 |
0 |
|
|
Revenue migrate adjust account ID |
| sales_amount |
NUMBER |
|
20 |
2 |
|
|
Sales amount |
| sales_amount_foreign |
NUMBER |
|
20 |
2 |
|
|
Foreign currency sales amount |
| source_date |
TIMESTAMP |
|
|
|
|
|
Source date |
| source_id |
NUMBER |
|
39 |
0 |
|
|
Source ID |
| source_transaction_id |
NUMBER |
|
39 |
0 |
|
|
Source transaction ID. This field is no longer supported. |
| source_type |
VARCHAR2 |
250 |
|
|
|
|
Source Type |
| start_date |
TIMESTAMP |
|
|
|
|
|
Start date |
| subsidiary_id |
NUMBER |
|
39 |
0 |
|
|
Subsidiary ID |
| term_in_days |
NUMBER |
|
39 |
0 |
|
|
Term in days |
| term_in_months |
NUMBER |
|
39 |
0 |
|
|
Term in months |
| unbilled_receivable_group |
VARCHAR2 |
60 |
|
|
|
|
Unbilled receivable group |