Table 12131 "Item Cost History" (IT)

IT country layer · Microsoft.Inventory.Costing · BC29-30 · source at ea08af5e · facts from BC29

An object of the IT localization, not part of W1.

Properties

Property	Value
Caption	Item Cost History
DataClassification	CustomerContent

Fields

Explanation: the field’s ToolTip in the code; without one, the ToolTip of a page control bound to the field (marked via the page); without that, its Caption (marked caption) when that differs from the name.

No.	Name	Type	Explanation	Notes
1	Item No.	Code[20]	—	TableRelation Item; not editable
2	Competence Year	Date	—	not editable
3	Description	Text[100]	—	not editable
4	Base Unit of Measure	Code[10]	—	TableRelation “Item Unit of Measure”.Code where(“Item No.” = field(“Item No.”)); not editable
5	Inventory Valuation	Option	—	OptionCaption: Weighted Average,Average,FIFO,LIFO,Discrete LIFO; not editable
6	Start Year Inventory	Decimal	—	not editable
7	End Year Inventory	Decimal	—	not editable
8	Year Average Cost	Decimal	—	not editable
9	Weighted Average Cost	Decimal	—	not editable
10	FIFO Cost	Decimal	—	not editable
11	LIFO Cost	Decimal	—	not editable
12	Discrete LIFO Cost	Decimal	—	not editable
13	Expected Cost Exist	Boolean	—	not editable
14	Definitive	Boolean	—	not editable
15	Purchase Quantity	Decimal	—	not editable
16	Purchase Amount	Decimal	—	not editable
17	Production Quantity	Decimal	—	not editable
18	Production Amount	Decimal	—	not editable
19	Direct Components Amount	Decimal	—	not editable
21	Direct Routing Amount	Decimal	—	not editable
22	Overhead Routing Amount	Decimal	—	not editable
23	Subcontracted Amount	Decimal	—	not editable
24	Estimated WIP Consumption	Boolean	—	not editable
25	Components Valuation	Option	—	OptionCaption: Average Cost,Weighted Average Cost; not editable

Keys

Key1: Item No., Competence Year (clustered)

Procedures

GetCompCost(ComponentValuation: Option "Average Cost","Weighted Average Cost"): Decimal

Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: bcatlas_resolve_node(object_type: "table", object_name: "Item Cost History"), then bcatlas_get_procedure_body or bcatlas_get_neighbors on the returned id.

A IT country object, not part of W1: the default corpus does not have it; bcatlas_list_countries shows which countries the atlas has.