Planned_standard_costs
This table includes standard cost-related data for items at a specific location. This table does not return the cost category. Use the Standard_cost_components child table to get the costs category. The planned_standard_costs table's data is available only for accounts with the Standard Costing feature enabled.
Columns
Name |
Type |
Length |
Precision |
Scale |
References |
In |
Description |
date_created |
TIMESTAMP |
|
|
|
|
|
Date created |
date_last_modified |
TIMESTAMP |
|
|
|
|
|
Date last modified |
item_id |
NUMBER |
|
39 |
0 |
item_id
|
Items
|
Item ID |
location_id |
NUMBER |
|
39 |
0 |
location_id
|
Locations
|
Location ID |
memo |
VARCHAR2 |
4000 |
|
|
|
|
Memo |
planned_standard_cost_id |
NUMBER |
|
39 |
0 |
|
|
Planned standard cost ID |
standard_cost_version_id |
NUMBER |
|
39 |
0 |
|
|
Standard cost version ID |
Primary key
PK Column Name |
planned_standard_cost_id |
Foreign keys in this table
FK Name |
FK Column Name |
PK Table Name |
PK Column Name |
Key Seq |
planned_standard_costs_items_fk |
item_id |
Items |
item_id |
1 |
planned_standard_costs_locations_fk |
location_id |
Locations |
location_id |
1 |
Foreign keys referencing this table
FK Name |
PK Column Name |
FK Table Name |
FK Column Name |
Key Seq |
Standard_cost_components_planned_standard_costs_fk |
planned_standard_cost_id |
Standard_cost_components |
planned_standard_cost_id |
1 |