MAC-PAC Homecontact ussupport login 
Documentation > MAC-PAC Reference Library > Manufacturing > Inventory Control > Screens > Warehouse Balance > IC220S03 - Descriptive Data

IC220S03 - Descriptive Data

 

 

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.