Backorder Days (Technical Specification)

Analytics (with PAI) > Service Performance > Backorder Days > Backorder Days (Technical Specification)

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

Analytical Object

AO_PAI_BackorderDays

Query Object

QO_PAI_BackorderDays

Data Source

PAI Advanced

Cab File

SPM_PAI_Advanced.cab

Query Object Primary Table

IPCS_STOCK_AMOUNT

IPCS_STOCK_LEVEL

IPCS_FORECASTED_DATA

IPCS_ORDER_PLAN_SCALARS

IPCS_PLANNER_CODES

IPCS_DEMAND_HISTORY

IPCSV_MEO_CURRENT_PROD_SKU

Query Object Tables

IPCS_STOCK_AMOUNT

IPCS_PART_MASTER

IPCS_LOC_MASTER

IPCS_STOCK_LEVEL

IPCS_FORECASTED_DATA

IPCS_ORDER_PLAN_SCALARS

IPCS_PLANNER_CODES

IPCS_DEMAND_HISTORY

IPCSV_MEO_CURRENT_PROD_SKU

Parameters

Name	Description	Default
PO_PAI_SKU_Separator	The separator used to combine Part Number with Location and display as an SKU	__ (double underscore)

Predecessor Jobs

Archival

Build Type

The following build types are supported:

• Full

Build Frequency

These build frequencies are supported:

• Daily

Dimensions

• Category

• Location

• Part Number

• Period

• Planner Code

• SKU

Measures

Measure	Mathematical Function
Total Backorders	Sum of Backorderorig
On ASL with OnOrder	Sum of Aslwithonorder
On ASL without OnOrder	Sum of Aslwithoutonorder
Forced non-stock	Sum of Forcednonstock
System Chose Not to Stock and Forecast Exists	Sum of Nottostockforecastexist
System Chose Not to Stock and No Forecast Exists	Sum of Nottostocknoforecastexist
No Supply Source	Sum of Nosupplysource
First Time Demand	Sum of Firsttimedemand
Not Categorized	Sum of NotCategorized

Was this helpful?