Part Detail Export

The Part Detail Export is an export-only format. All columns below will be present in the export, although additional columns may be added or the order changed in future versions of Intuiflow.

Column Name	Type	Max Length	Values
PartNumber	text	50
Revision	text	10
Location	text	32
Description	text	2GB	1 billion characters
UnitOfMeasure	text	20
PartType	integer		1 = Buy 2 = Make 3 = Distributed
InventoryPlanning	text	10	(valid buffer profile name for location) RO = Replenishment Override MM = Min/Max NB = Non-Buffered LTM = Lead Time Managed
FixedLeadTime	integer
GoodsReceiptTime	integer
AverageDailyUsage	decimal	18.5
ForecastedDailyUsage	decimal	18.5
OrderCycle	integer
OrderMinimumQty	integer
OrderMaximumQty	integer
OrderMultipleQty	integer
CycleDayAdjustmentFactors	text
PlannedAdjustmentFactor	text
PlannerCode	text
PlanningCalendar	text
MaterialType	text	50
RawMaterialsCost	decimal	18.5
OutSourceCost	decimal	18.5
Vendor	text	100
VendorIdentifier	text	100
UserDefined1	text	400
UserDefined2	text	400
UserDefined3	text	400
UserDefined4	text	400
UserDefined5	text	400
UserDefined6	text	400
UserDefined7	text	400
UserDefined8	text	400
DecoupledLeadTime	boolean
DailyUsageType	Text	10	ADU = AverageDailyUsage FDU = ForecastedDailyUsage Blend = Blended Daily Usage
Notes	32767	No
AlertHorizon	integer
AutoApproveRecommendedOrders	boolean
UserDefined9	text	400
UserDefined10	text	400
UserDefined11	text	400
UserDefined12	text	400
UserDefined13	text	400
UserDefined14	text	400
UserDefined15	text	400
UserDefined16	text	400
DisableAutoProfile	boolean
SourceErp	text	100
SourceLocation	text	32
IncludeInMAC	boolean
AlertSeverity	text		None Critical High Medium
AlertStatus	text	100	STOCK OUT STOCK OUT WITH DEMAND (date of alert)
AlertType	text	100	CurrentInventoryAlert ProjectedStockOutAlert MaterialSynchronizationAlert LeadTimeManagedSummary
BufferAlertLevel	decimal	18.5
BufferProfile	text	50	Valid Buffer Profile name for the matching Location
CDAFTargetedInventory	integer
CDAFTargetedInventoryType	text		None (tbd)
DemandAllocations	integer
DueDateResponse	date
EffectiveDailyUsage	decimal	18.5
EffectiveLeadTime	integer
GreenZoneSize	decimal	18.5
InventoryQty	decimal	18.5
IsBuffered	boolean
IsOrderSpike	boolean
IssuedQty	decimal	18.5
LTMTotalOrders	integer
ManualTopOfGreen	integer
ManualTopOfRed	integer
ManualTopOfYellow	integer
NetFlow	integer
NetFlowPercentage	decimal	18.5
OnHandQty	integer
OrderReceiptDateResponse	date
PercentageOfTopOfRed
Priority	text		Critical Red Yellow Green OTOG Inactive
RedZoneBase	integer
ReminderStatus	text		OTOG Inactive
ReorderPoint	integer
ReorderQuantityFrom	integer
ReorderQuantityTo	integer
RequestDateResponse	date
RPlusLeadTime	integer
RZAFName	text
RZAFType	text		None Inactive
RZAFValue	integer
ScheduleOrderDateResponse	date
SupplyOrderFollowUpByResponse	text
SupplyOrderNote	text
SupplyOrders	integer
TargetedInventory	decimal	18.5
TodaysPAF	integer
TodaysRZAF	integer
TodaysYZAF	integer
TopOfGreen	decimal	18.5
TopOfRed	decimal	18.5
TopOfYellow	decimal	18.5
UnitOfMeasureFrom	text	20
UnitOfMeasureFromQuantity	decimal	18.5
UnitOfMeasureTo	text	20
UnitOfMeasureToQuantity	decimal	18.5
UnitOfMeasureToRoundingDigits	integer
YellowZoneSize	integer
YZAFName	text
YZAFType	text		None tbd
YZAFValue	integer
MaterialAvailabilityShortage	boolean
NetFlowMinusTopOfGreen	decimal	18.5
OnHandQtyMinusDemandAllocations	decimal	18.5
SourceErp	text	tbd
SourceLocation	text	32
IncludeInMAC	boolean