Export-Only File Formats

Export Page - Other Data Exports

Exploded Demand Forecasts

Exported Demand Forecasts 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 Replenishment+.

Column Name	Type	Max Length	Values
PartNumber	text	50
Revision	text	10
Location	text	32
WeekBeginning	date
Value	int

Part Detail

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 Replenishment+.

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
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
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

Committed Order History (Exported Order History)

Committed Order History 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 Replenishment+.

Column Name	Type	Max Length	Values
Date	date
PartNumber	text	50
Revision	text	10
Location	text	32
OrderNumber	text	100
Description	text
OrderType	integer		PO = Purchase Order WO = Work Order TO = Transfer Order
OrderDate	date
RequestDate	date
PromiseDate	date
StartDate	date
DueDate	date
Quantity	decimal	18.5
QuantityTo	decimal	18.5
RecommendedQuantity	decimal	18.5
Vendor	text	100
VendorId	text	100
UnitCost	decimal	18.5
LinkCode	text	100
CreatedByUser	text	100
UnitOfMeasure	text	20
UnitOfMeasureTo	text	20
SalesOrderNumber	integer
LineItem	integer
Planner	text
BufferProfile	text	50	Valid Buffer Profile name for the matching Location
PartType	integer		Make Distributed
MaterialType	text
Variance	decimal	18.5
ExtendedCost	decimal	18.5
VarianceCost	decimal	18.5
OrderReceiptDate	date
Late	integer
Priority	integer		lower numbers mean higher priority
Customer	text
Notes	text
VarianceNotes	text
Source	text
UDF1	text	400
UDF2	text	400
UDF3	text	400
UDF4	text	400
UDF5	text	400
UDF6	text	400
UDF7	text	400
UDF8	text	400
UDF9	text	400
UDF10	text	400
UDF11	text	400
UDF12	text	400
UDF13	text	400
UDF14	text	400
UDF15	text	400
UDF16	text	400

Workbench Export

The Workbench 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 Replenishment+.

Column Name	Type	Max Length	Values
Priority	integer		lower numbers mean higher priority
% of Buffer	decimal	18.5
Part Number	text	50
Location	text	32
Rev	text	10
Description	text	2GB	1 billion characters
Spike	boolean		Is Order Spike
R+ Alert	decimal	18.5
Reorder Qty	decimal	18.5
Reorder Qty (From)	decimal	18.5
On Hand	decimal	18.5
Supply Orders	decimal	18.5
Supply Order Follow Up By	date
Supply Order Note	text	255
Demand Allocations	decimal	18.5
Net Flow	decimal	18.5
Targeted Inventory	decimal	18.5
RPlus Lead Time	integer
InventoryPlanning	text	10	(valid buffer profile name for location) RO = Replenishment Override MM = Min/Max NB = Non-Buffered LTM = Lead Time Managed
Fixed Lead Time	integer
Effective Lead Time	integer
Goods Receipt Time	integer
ToG	decimal	18.5	Top Of Red
ToY	decimal	18.5	Top Of Yellow
ToR	decimal	18.5	Top Of Red
Issued Qty	decimal	18.5
Planner	text	25
Vendor	text	100
Part Type	integer		Buy Make Distributed
Material Type	text	50
Unit Of Measure	text	20
Unit Of Measure (From)	text	20
Unit Of Measure (From) Quantity	decimal	18.5
Unit Of Measure (To)	text	20
Unit Of Measure (To) Quantity	decimal	18.5
Unit Of Measure (To) Rounding Digits	integer
Average Daily Use	decimal	18.5
Adjustment Factor Value	decimal	18.5	Planned Adjustment Factor
User Defined 1	text	400
User Defined 2	text	400
User Defined 3	text	400
User Defined 4	text	400
User Defined 5	text	400
User Defined 6	text	400
User Defined 7	text	400
User Defined 8	text	400
User Defined 9	text	400
User Defined 10	text	400
User Defined 11	text	400
User Defined 12	text	400
User Defined 13	text	400
User Defined 14	text	400
User Defined 15	text	400
User Defined 16	text	400
Schedule Order Date	date
Request Date	date
Order Receipt Date	date
Vendor ID	text	100	Vendor Identifier
Forecasted Daily Usage	decimal	18.5
Effective Daily Usage	decimal	18.5
Alert Type	text	100	CurrentInventoryAlert ProjectedStockOutAlert MaterialSynchronizationAlert LeadTimeManagedSummary
Alert Status	text	100	STOCK OUT STOCK OUT WITH DEMAND (date of alert)
Availability Shortage	boolean		Material Availability Shortage
Raw Materials Cost	decimal	18.5

Pending Orders - Committed Order History (Exported Order History)

Exported Order History 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 Replenishment+.

Column Name	Type	Max Length	Values
Date	date
PartNumber	text	50
Revision	text	10
Location	text	32
OrderNumber	text	100
Description	text
OrderType	integer		PO = Purchase Order WO = Work Order TO = Transfer Order
OrderDate	date
RequestDate	date
PromiseDate	date
StartDate	date
DueDate	date
Quantity	decimal	18.5
QuantityTo	decimal	18.5
RecommendedQuantity	decimal	18.5	Recommended Order Quantity
Vendor	text	100
VendorId	text	100	Vendor Identifier
UnitCost	decimal	18.5
LinkCode	text	100
CreatedByUser	text	100
UnitOfMeasure	text	20
UnitOfMeasureTo	text	20
SalesOrderNumber	integer
LineItem	integer
Planner	text
BufferProfile	text	50	Valid Buffer Profile name for the matching Location
PartType	integer		Buy Make Distributed
MaterialType	text
Variance	decimal	18.5
ExtendedCost	decimal	18.5
VarianceCost	decimal	18.5
OrderReceiptDate	date
Late	integer
Priority	integer		lower numbers mean higher priority
Customer	text
Notes	text
VarianceNotes	text
Source	text
UDF1	text	400
UDF2	text	400
UDF3	text	400
UDF4	text	400
UDF5	text	400
UDF6	text	400
UDF7	text	400
UDF8	text	400
UDF9	text	400
UDF10	text	400
UDF11	text	400
UDF12	text	400
UDF13	text	400
UDF14	text	400
UDF15	text	400
UDF16	text	400

Alerts - Current Inventory

Current Inventory 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 Replenishment+.

Column Name	Type	Max Length	Values
Order Notes	text
Alert Type	text	100	CurrentInventoryAlert ProjectedStockOutAlert MaterialSynchronizationAlert LeadTimeManagedSummary
Alert Status	text	100	STOCK OUT STOCK OUT WITH DEMAND (actual date of alert)
Part Number	text	50
Rev	text	10	Revision
Location	text	32
Description	text	2GB	1 billion characters
On Hand	integer
Issued Qty	decimal	18.5
Supply Orders	integer
Demand Allocations	decimal	18.5
Part Type	integer		Buy Make Distributed
Planner	text
InventoryPlanning	text	10	(valid buffer profile name for location) RO = Replenishment Override MM = Min/Max NB = Non-Buffered LTM = Lead Time Managed
Vendor	text	100
Vendor ID	text	100	Vendor Identifier

Advanced Planning Module

Simulation Part Forecast

Column Name	Type	Max Length	Values
PartNumber	text	50
Revision	text	10
Location	text	32
Description	text
Date	date
TopOfGreen	decimal	18.5
TopOfYellow	decimal	18.5
TopOfRed	decimal	18.5
ReorderPoint	decimal	18.5
RedZoneBase	decimal	18.5
ProjectedDailyDemand	decimal	18.5
ProjectedNewSupply	decimal	18.5
ProjectedSupplyDueToday	decimal	18.5
ProjectedOpenSupply	decimal	18.5
ProjectedQualifiedDemand	decimal	18.5
NetFlow	decimal	18.5
ProjectedInventory	decimal	18.5
ProjectedEDU	decimal	18.5
PlannerCode	text	25
MaterialType	text	50
PartType	text		Buy Make Distributed
InventoryMethod	text		NB = Non-Buffered Replenished MM = Min/Max RO = Replenishment Override LTM = Lead Time Managed
BufferProfile	text	50	valid buffer profile name
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
UserDefined9	text	400
UserDefined10	text	400
UserDefined11	text	400
UserDefined12	text	400
UserDefined13	text	400
UserDefined14	text	400
UserDefined15	text	400
UserDefined16	text	400

Simulation Part Weekly Summary

Column Name	Type	Max Length	Values
PartNumber	text	50
Revision	text	10
Location	text	32
Description	text
WeekStarting	date
Year	integer
WeekNumber	integer
WorkingDayCount	integer
SimulationWeek	integer
TotalProjectedDailyDemand	decimal	18.5
ProjectedNewSupplySum	decimal	18.5
AverageProjectedInventory	decimal	18.5
ProjectedInventoryStatus	integer		lower numbers mean higher severity
DailyUsageStatus	integer		lower numbers mean higher severity
PlannerCode	text	25
MaterialType	text	50
PartType	text		Buy Make Distributed
InventoryMethod	text		NB = Non-Buffered Replenished MM = Min/Max RO = Replenishment Override LTM = Lead Time Managed
BufferProfile	text	50
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
UserDefined9	text	400
UserDefined10	text	400
UserDefined11	text	400
UserDefined12	text	400
UserDefined13	text	400
UserDefined14	text	400
UserDefined15	text	400
UserDefined16	text	400

Simulation Projected Supply

Column Name	Type	Max Length	Values
PartNumber	text	50
Revision	text	10
Location	text	32
OrderNumber	text	100
OrderDate	date
PromiseDate	date
Quantity	decimal	18.5
Type	text		PO = Purchase Order WO = Work Order TO = Transfer Order
Status	text		Committed Exported Pending
Description	text
PlannerCode	text	25
MaterialType	text
PartType	text		Buy Make Distributed
InventoryMethod	text		NB = Non-Buffered Replenished MM = Min/Max RO = Replenishment Override LTM = Lead Time Managed
BufferProfile	text	50	valid buffer profile name
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
UserDefined9	text	400
UserDefined10	text	400
UserDefined11	text	400
UserDefined12	text	400
UserDefined13	text	400
UserDefined14	text	400
UserDefined15	text	400
UserDefined16	text	400

Smart Buffer Profiler - Demand History Analysis

Demand History Analysis 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 Replenishment+.

Column Name	Type	Max Length	Values
Part Number	text	50
Rev	text	10
Location	text	32
Part Type	text		Buy Make Distributed
Description	text
Total Qty	decimal	18.5	Total Quantity
Num Pulls	int		Number of pulls in demand history
Avg Qty	decimal	18.5	Average pull quantity for DHA horizon
Standard Deviation	decimal	18.5	Std Dev for DHA horizon
ADU	decimal	18.5	Average Daily Usage for Settings horizon
DHA ADU	decimal	18.5	Average Daily Usage for DHA horizon
CoV	integer		Coefficient of Variation for DHA horizon
Max Pull	decimal	18.5	Maximum pull quantity within DHA horizon