Buffer Profile

Buffer Profiles are referenced by Parts and used for replenishment calculations.

Column Name	Type	Max Length	Required	Values
Description	text	250	No
RedZoneBase	integer		Yes	0 to 1000
RedOrderCycle	decimal	18.5	Yes	0 to 365
RedSafetyZone	integer		Yes	0 to 1000
YellowZoneBase	integer		Yes	0 to 1000
YellowOrderCycle	decimal	18.5	Yes	0 to 100
GreenZoneBase	integer		Yes	0 to 1000
GreenOrderCycle	decimal	18.5	Yes	0 to 100
GreenCalcMode	integer		Yes	0 = OrderCycle 1 = MoQ 2 = UseOverLeadTime
InventoryAlertLevel	integer		Yes	0 to 100
OrderSpikeAlertLevel	integer		No	0 to 100 (defaults to 0)
OrderSpikeHorizon	decimal	4.2	No	0 to 5 (defaults to 0)
Name	text	50	Yes	Cannot be one of the reserved Inventory Method names: “NB”, “Replenished”, “MM”, “RO”, “LTM”
Location	text	32	No
ProfileType	integer		No	0 = Custom 1 = Auto
PartType	integer		Yes	1 = Buy 2 = Make 3 = Distributed
RedCalcMode	integer		No	0 = Standard 1 = Statistical
RedZoneProbabilityFactor	decimal		No