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