Part

Get Parts v2.0

GET https://yoursite.demanddriventech.com/odata/v2/part

This endpoint allows you to get all parts for the current dataset. This endpoint does not currently accept parameters.

200 Part(s) successfully retrieved.

{
    "@odata.context": "https://yoursite.demanddriventech.com/odata/v2/$metadata#part",
    "value": [
        {
            "DataSetId": 1,
            "Id": 47666,
            "LocationId": 88,
            "BufferProfileId": 10796,
            "PartNumber": "Washers",
            "Revision": "",
            "Location": "Plant3",
            "Description": "",
            "InventoryMethod": "Replenished",
            "PartType": "Make",
            "DailyUsageType": "Average Daily Usage",
            "Priority": "Low",
            "DisableAutoProfile": false,
            "UnitOfMeasure": "EA",
            "FixedLeadTime": 10,
            "GoodsReceiptTime": 0,
            "AutoApproveRecommendedOrders": false,
            "AlertHorizon": 1,
            "AverageDailyUsage": 1.0,
            "DecoupledLeadTime": false,
            "OrderCycle": 0,
            "ManualTopOfRed": 0.0,
            "ManualTopOfYellow": 0.0,
            "ManualTopOfGreen": 0.0,
            "OutSourceCost": 0.0,
            "RawMaterialsCost": 0.0,
            "PlannerCode": "Gary",
            "MaterialType": "",
            "Notes": "",
            "Vendor": "",
            "VendorIdentifier": "",
            "IncludeInMAC": true,
            "TodaysPAF": 1.0,
            "TodaysYZAF": 0.0,
            "YZAFValue": 0.0,
            "TodaysRZAF": 0.0,
            "RZAFValue": 0.0,
            "CDAFTargetedInventory": 0.0,
            "TopOfGreen": 20.0,
            "TopOfYellow": 15.0,
            "TopOfRed": 5.0,
            "ReorderPoint": 15.0,
            "RedZoneBase": 4.0,
            "PercentageOfToR": 0.5,
            "PercentageOfToRSpike": 0.5,
            "OrderSpikeHorizon": 1.0,
            "BufferAlertLevel": 2.5,
            "IsOrderSpike": false,
            "LTMTotalOrders": 0.0,
            "MaterialAvailabilityShortage": false,
            "MaterialAvailabilityShortageAsChild": false,
            "SupplyOrderQty": 20.0,
            "DemandAllocationQty": 0.0,
            "OnHandQty": 0.0,
            "IssuedQty": 0.0,
            "InventoryQty": 0.0,
            "NetFlowQty": 20.0,
            "NetFlowPercentage": 1.0,
            "TargetedInventory": 7.5,
            "EffectiveDailyUsage": 1.0,
            "EffectiveLeadTime": 10,
            "RPlusLeadTime": 10,
            "CustomOrderDueDate": "2020-07-01T00:00:00-07:00",
            "InventoryPlanning": "M11",
            "DaysUntilYellow": 5,
            "UserDefined1": "",
            "UserDefined2": "",
            "UserDefined3": "",
            "UserDefined4": "",
            "UserDefined5": "",
            "UserDefined6": "",
            "UserDefined7": "",
            "UserDefined8": "",
            "UserDefined9": "",
            "UserDefined10": "",
            "UserDefined11": "",
            "UserDefined12": "",
            "UserDefined13": "",
            "UserDefined14": "",
            "UserDefined15": "",
            "UserDefined16": ""
        }
    ]
}

Part Fields

Field Name	Type
DataSetId	int
Id	int
LocationId	int
BufferProfileId	int?
PreviewBufferProfileId	int?
PlanningCalendarId	int?
PlannedAdjustmentFactorId	int?
PartNumber	text
Revision	text
Location	text
InventoryMethod	InventoryMethodType
Description	text
DiableAutoProfile	boolean
BufferProfileId	int
PlanningCalendarid	int
UnitOfMeasure	text
PartType	PartType
DailyUsageType	DailyUsageType
FixedLeadTime	int
GoodReceiptTime	int
AutoApproveRecommendedOrders	boolean
AlertHorizon	int
AverageDailyUsage	decimal
DecoupledLeadTime	boolean
OrderCycle	int
OrderMaximumQty	decimal?
OrderMinimumQty	decimal?
OrderMultipleQty	decimal?
ForecastedDailyUsage	decimal?
ManualTopOfRed	decimal
ManualTopOfYellow	decimal
ManualTopOfGreen	decimal
OutSourceCost	decimal
RawMaterialsCost	decimal
PlannerCode	text
MaterialType	text
Notes	text
Vendor	text
VendorIdentifier	text
IncludeInMAC	boolean
TodaysPAF	decimal
TodaysYZAF	decimal
YZAFName	text
YZAFValue	decimal
YZAFType	CycleDayAdjustmentFactorCoverageType
TodaysRZAF	decimal
RZAFName	text
RZAFValue	decimal
RZAFType	CycleDayAdjustmentFactorCoverageType
CDAFTargetedInventoryType	CycleDayAdjustmentFactorCoverageType
TopOfGreen	decimal
TopOfYellow	decimal
TopOfRed	decimal
ReorderPoint	decimal
PercentageOfToR	decimal
PercentageOfToRSpike	decimal
OrderSpikeHorizon	decimal
BufferAlertLevel	decimal?
AlertSeverity	AlertSeverity
IsOrderSpike	bool
LTMTotalOrders	decimal
MaterialAvailabilityShortage	bool
MaterialAvailabilityShortageAsChild	bool
ReminderStatus	Priority
SupplyOrderQty	decimal
SupplyOrderFollowUpBy	date?
SupplyOrderNote	text
DemandAllocationQty	decimal
OnHandQty	decimal
IssuedQty	decimal
InventoryQty	decimal
NetFlowQty	decimal
NetFlowPercentage	decimal
TargtedInventory	decimal
EffectiveDailyUsage	decimal
EffectiveLeadTime	int
RPlusLeadTime	int
Priority	Priority
DateDate	date?
CustomOrderDueDate	date?
ScheduleOrderDate	date?
RequestDate	date?
OrderReceiptDate	date?
ReorderQuantityFrom	decimal?
ReorderQuantityTo	decimal?
InventoryPlanning	text
DaysUntilYellow	int?
UserDefined1	text
UserDefined2	text
UserDefined3	text
UserDefined4	text
UserDefined5	text
UserDefined6	text
UserDefined7	text
UserDefined8	text
UserDefined9	text
UserDefined10	text
UserDefined11	text
UserDefined12	text
UserDefined13	text
UserDefined14	text
UserDefined15	text
UserDefined16	text

AlertSeverity

Value
Critical
High
Medium
Low
Lowest
None

CycleDayAdjustmentFactorCoverageType

Value
None
Days
Units

DailyUsageType

Value	Description
ADU	Average daily usage
FDU	Forecast daily usage
Blend	Blended

InventoryMethodType

Value	Description
NB	Non-Buffered
Replenished	Replenished
MM	Min-Max
RO	Replenished Override
LTM	Lead Time Managed

PartType

Value
Make
Buy
Distributed

Priority

Critical	Net Flow is below the red zone (0), or below set threshold within the red zone
Red	Net flow is within the red zone
Yellow	Net Flow is within the yellow zone
Green	Net Flow is within the green zone
OToG	Net Flow exceeds top of green value
Inactive	Part does not have any active supply or demand orders against it
Invalid	Can be triggered by two errors: (1) Buffer Profile does not match Part Type (ie. a buy part with a make buffer profile) (2) Part has a maximum order value that is causing too many orders to be generated (number of orders exceed 2048 orders)