Order Inventory Mgmt

Primary key, system generated by a sequence that will uniquely identify a single supplier or supplier/department record.

Indicator used to determine if orders for the supplier or supplier/department should be scaled to meet constraints. This indicator is used for both replenishment and manual orders. Valid values are: Y - Yes. Scale orders to meet constraints. N - No. Do not scale orders to meet constraints.

Determines the scaling constraint level when scaling orders for the supplier or supplier/department. Valid values include: O - Order level. Scaling constraints apply to the entire order. L - Location level. Scaling constraints apply to each location on the order.

Determines if the minimum scaling constraint or the maximum scaling constraint should be used as the objective when scaling the order for the supplier or supplier/department. This applies to both scaling constraints. Valid values include: M - Minimum. Scaling objective is the minimum scaling constraint. For example, if the minimum scaling constraint is 20,000lbs and the maximum scaling constraint is 40,000lbs, orders under 20,000lbs would be scaled to at least 20,000lbs. X - Maximum. Scaling objective is the maximum scaling constraint. For example, if the minimum scaling constraint is 20,000lbs and the maximum scaling constraint is 40,000lbs, orders under 40,000lbs would be scaled to 40,000lbs.

The type of the supplier or supplier/departments primary constraint. Valid values include: A - Amount (ex. $US) M - Mass (ex. kilograms) V - Volume (ex. cubic feet) P - Pallets C - Case E - Each S = Stat Case