Export-Only File Formats

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
Demand Allocations	decimal	18.5
Available Stock	decimal	18.5
RPlus Lead Time	integer
Inventory Planning	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
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)

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
AvailableStock	decimal	18.5
ProjectedInventory	decimal	18.5
ProjectedEDU	decimal	18.5

Simulation Part Weekly Summary

Column Name	Type	Max Length	Values
PartNumber	text	50
Revision	text	10
Location	text	32
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

Simulation Projected Supply

Column Name	Type	Max Length	Values
PartNumber	text	50
Revision	text	10
Location	text	32
WorkOrderNumber	text	100
DueDate	date
WorkOrderQuantity	decimal	18.5
SequenceNumber	integer
RoutingName	text