WILLIAMS CO 001 INVENTORY CONTROL 4/12/95
DSP01 WHS DW1 WAREHOUSE BALANCE FILE MAINTENANCE CHANGE (DESC)
Part Number BOLT-100 100 LB BOLT Type PUR SKU EA
Leadtime Demand .000 Reorder Quantity .000
Safety Stock Quantity .000 Target Stock Quantity .000
Minimum Stock Quantity .000 Maximum Stock Quantity .000
Primary Stock Location DW1W001 Minimum Order Quantity .000
Replenishment Leadtime 015 Dk-To-Stk Leadtime .00
Std Part Dist Leadtime 6
Planner Code A Inspection Required
Inv Reservation Window 007 Preferred Vendor V01
Buyer Code PO Generation Mode N
Substitute Buyer Vendor Relation Reqd Y
Packing Container Code Shipping Container Code
Packing Container Qty .000 Shipping Container Qty .000
Freight Rating Code FC-10000000
F2=Command F3=Exit F4=Prompt F9=Inquiry
F10=Function Select F15=Rekey Data
This screen is used to define stock policies for a part as it is used within the specified warehouse. Depending on whether a manufacturing or distribution company/warehouse was entered on the Function Select screen will determine which Change Description screen will appear. Some fields do not affect system processing. However, these fields would be useful to create a reorder point report and/or program should your business requirements demand it.
COMPANY/WAREHOUSE
Display only. The company/warehouse in which the maintenance is being performed.
PART NUMBER/PART DESCRIPTION
Display only. The number of the part and its corresponding description for which the maintenance is being performed.
PART TYPE
Display only. The standard part types are:
PUR - Purchased Part
MFG - Manufactured Part
RAW - Raw Material
PLN - Planning Part
REF - Reference Part
B/T - Build-Thru Part
N/S - Non-Standard Part
TRN - Transfer Part
NSK - Non-Stock Part
STOCKKEEPING UNIT OF MEASURE
Display only. The unit of measure in which the part is stocked.
LEADTIME DEMAND
Optional. The demand which would occur during the replenishment lead time, expressed in stockkeeping units (DOES NOT AFFECT SYSTEM PROCESSING).
REORDER QUANTITY
Optional. The typical order quantity of this part which might be in a classical Economic Order Quantity (EOQ) calculation (DOES NOT AFFECT SYSTEM PROCESSING).
SAFETY STOCK QUANTITY
Optional. Safety stock quantity specifies an inventory balance that you wish to hold on hand in case of emergency situations. Should be defined in stockkeeping units of measure. The safety stock quantity on the Part Master File is used by Master Scheduling and MRP to plan orders or schedules to include safety stock requirements. The safety stock quantity on the Warehouse Balance File does not affect system processing.
TARGET STOCK QUANTITY
Optional. Target stock quantity specifies an inventory balance that you might wish to obtain as an average balance from period to period and would be considered an ideal level of inventory investment considering your inventory carrying costs, as well as other factors (DOES NOT AFFECT SYSTEM PROCESSING).
MINIMUM STOCK QUANTITY
Optional. Minimum stock quantity specifies an inventory balance that would be the lowest you would want to have at any given time, taking into consideration your level of customer service and any safety stock to be set aside (DOES NOT AFFECT SYSTEM PROCESSING).
MAXIMUM STOCK QUANTITY
Optional. Maximum stock quantity specifies an inventory balance which would be the highest you would want to have at any given time, taking into consideration the costs of carrying the inventory and any space limitations due to stock location sizes or percentage of total inventory policies (DOES NOT AFFECT SYSTEM PROCESSING).
PRIMARY STOCKING LOCATION
Required. The stocking location entered will be used as a default when shipping against a sales order in the Order Processing module. Must be a valid location.
MINIMUM ORDER QUANTITY
Optional. Minimum order quantity specifies the smallest order quantity which you would place to a vendor or another distribution facility. This takes into consideration any fixed order costs (setup costs) which would make it economically unfeasible to order a smaller quantity (DOES NOT AFFECT SYSTEM PROCESSING).
REPLENISHMENT LEADTIME
Optional. The lead time between the placement and receipt of a purchase or transfer order (DOES NOT AFFECT SYSTEM PROCESSING).
INVENTORY RESERVATION WINDOW
Optional. Number of days before the promise ship date that inventory reservation should be attempted. The valid value of this field will depend on the value of the future reservation option flag in the Warehouse Description File. If the flag is Y, the inventory reservation window should be numeric. If the flag is N, the reservation window should be *ZEROS or *BLANKS. The inventory reservation window is kept on the Warehouse Description record if the Warehouse Balance record reads '0'. The Warehouse Description record can be overridden by entering the number of days in the Warehouse Balance record.
DOCK-TO-STOCK LEAD TIME
Optional. Used to indicate the lead time in days between item delivery and inventory availability (APPEARS ONLY FOR DISTRIBUTION WAREHOUSES).
STANDARD PART DISTRIBUTION LEADTIME
Optional. This field is used to calculate the earliest ship date if the Standard Part Distribution Leadtime Flag on Reference File category 412 is set to Y-Yes. You define the Standard Part Distribution Leadtime in days.
PLANNER CODE
Optional. Identifies the planner responsible for the part. The planner code must exist on Reference File category 235.
INSPECTION REQUIRED
Optional. Enter a default inspection code for the part when this part requires inspection before and/or after inventory transactions occur. Must be a valid inspection code on Reference File category 237 (APPEARS ONLY FOR DISTRIBUTION WAREHOUSES).
INVENTORY RESERVATION WINDOW
Optional. Number of days before the promise ship date that inventory reservation should be attempted. The valid value of this field will depend on the value of the future reservation option flag in the Warehouse Description File. If the flag is Y, the inventory reservation window should be numeric. If the flag is N, the reservation window should be *ZEROS or *BLANKS. The inventory reservation window is kept on the Warehouse Description record if the Warehouse Balance record reads '0'. The Warehouse Description record can be overridden by entering the number of days in the Warehouse Balance record.
PREFERRED VENDOR
Optional. This identifies the preferred vendor for the part. This information defaults from the Part Master File, but may be overwritten.
BUYER CODE
Optional. Indicates a main buyer in the purchasing department responsible for the procurement of this part (APPEARS ONLY FOR DISTRIBUTION WAREHOUSES).
PO GENERATION MODE
Required. Used to indicate if planned requisitions for from Requirements Planning or Master Scheduling may be covered by a purchase order. If the value is Y, planned requisitions may be covered by a purchase order without first being released. If the value is N, planned requisitions must be first released before a purchase order may cover them. (APPEARS ONLY FOR DISTRIBUTION WAREHOUSES.)
SUBSTITUTE BUYER
Optional. Used to indicate a secondary buyer responsible for the procurement of this part (APPEARS ONLY FOR DISTRIBUTION WAREHOUSES).
ITEM/VENDOR RELATIONSHIP REQUIRED FLAG
Required. Used to indicate if an item/vendor relationship is necessary before placing a purchase order. Valid values are Y (Yes) or N (No) (APPEARS ONLY FOR DISTRIBUTION WAREHOUSES).
PACKING CONTAINER CODE
Optional. This field identifies the container in which the part is initially packed. If entered, the Packing Container Code must exist on the Container Master File.
SHIPPING CONTAINER CODE
Optional. This field identifies the container in which the part's packing containers are placed for shipping. If entered, the Shipping Container Code must exist on the Container Master File.
PACKING CONTAINER QUANTITY
Required (if a Packing Container Code is entered). This field identifies the part quantity in stockkeeping unit of measure that can be packed in a packing container. The value entered must not be zero.
SHIPPING CONTAINER QUANTITY
Required (if a Shipping Container Code is entered). This field identifies the part quantity in stockkeeping unit of measure that can be shipped in a shipping container. The value entered must not be zero.
FREIGHT RATING CODE
Optional. This field identifies a user-defined freight description code. If entered, the Freight Rating Code must exist on Reference File category I75. Each freight rating code classifies items by specific freight rates. Line items are grouped by freight rating code on the bill of lading.
COMMAND KEYS
Enter - Process request.
F2 - Display a window where a fast path option or mnemonic can be entered. Fast path allows the next menu selection to be made directly from this screen. When the window is displayed, pressing F3 will remove it.
F3 - Exit program and return to menu.
F4 - Display a list of values for the field where the cursor is positioned. If you select one of the items from the list, it will be returned to the application screen.
F9 - Enter the Warehouse Balance File inquiry program.
F10 - Return to the Function Select screen for option selection without updating any information that you may have entered on the screen.
F15 - Clear screen values.
|