Inventory Detail - Technical Specification

The data used to generate this dashboard is based on the following:

Analytical Object

AO_PAI_Performance360_InventoryTrend

Query Object

QO_PAI_Performance360_InventoryTrend

Data Source

PAI Advanced

Cab File

SPM_PAI_Advanced.cab

Query Object Primary Table

IPCS_STOCK_AMOUNT

IPCS_STOCK_LEVEL

Query Object Tables

IPCS_PREPROCESSED

IPCS_PART_MASTER

IPCS_LOC_MASTER

IPCS_PART_TYPE

IPCS_PART_FAMILY

IPCS_LOC_TYPE

IPCS_STOCK_AMOUNT

IPCS_STOCK_LEVEL

Parameters

Name	Description	Default
PO_PAI_InventoryTrendHorizonMonths	The number of months to build the analytical object	12

Predecessor Jobs

Archival

Build Type

The following build types are supported:

• Full

Build Frequency

These build frequencies are supported:

• Daily

• Weekly

• Monthly

• Period

• Part Number

• Location Type

• Part Family

• Part Type

• Location

Measure	Mathematical Function
Inventory Value sum	Sum of inventoryvalue
Critically Short Sum	Sum of criticallyshort
Backorder Sum	Sum of Backorder
In Range Sum	Sum of Inrange
In Excess Sum	Sum of Inexcess
No of Months	Distinct count
Inventory	Inventory Value Sum / No of Months
Critically Short	Critically Short Sum / No of Months
In Range	In Range Sum / No of Months
In Excess	In Excess Sum / No of Months
Backorder	Backorder Sum / No of Months

Was this helpful?