WHBATCH FILE

                            Warehouse Batch

The Warehouse Batch file contains records for batches.  Batch numbers are
assigned when you run WH130 (Pick List Print) to print a pick list.

REFERENCED BY

WH30.2    WH31.2    WH32.2

UPDATED BY

OE114     WH130     WH965

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WHB-COMPANY          Numeric 4                                   OE114   WH130
Company              This field contains the company number.     WH965

WHB-LOCATION         Alpha 5                                     OE114   WH130
Location             This field contains a valid stock           WH965
                     location within the company inventory.

WHB-BATCH-NBR        Numeric 6                                   OE114   WH130
Batch Number         This field identifies the batch number      WH965
                     assigned to the shipment.

WHB-FIRST-SHIP-NBR   Numeric 10                                  OE114   WH130
First Ship Number    This field contains the first shipment      WH965
                     contained in this batch.

WHB-LAST-SHIP-NBR    Numeric 10                                  OE114   WH130
Last Ship Number     This field contains the last shipment       WH965
                     number contained in this batch.

WHB-WEIGHT           Signed 9.3                                  OE114   WH130
Weight               This field contains the total weight in     WH965
                     all shipments for the batch.

WHB-CUBIC-FEET       Signed 9.3                                  OE114   WH130
Cubic Feet           This field contains the cubic feet          WH965
                     total in all shipments for the batch.

WHB-CARTONS          Numeric 6                                   WH965
Cartons              This field contains the total number of
                     cartons in all shipments for the batch.

WHB-ROUTE            Numeric 4                                   OE114   WH130
Route                This field contains the route number.       WH965
                     The route assigned to the ship-to
                     customer defaults from the Order Entry
                     Route file.

                         WHBATCH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WHBSET1   COMPANY       Primary index used for accessing and     OE114   WH130
          LOCATION      updating the table.                      WH30.2  WH31.2
          BATCH-NBR                                              WH32.2  WH965

                         WHBATCH FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Iccompany      ICCOMPANY    Required

                            WHB-COMPANY      -> ICC-COMPANY

Iclocation     ICLOCATION   Required

                            WHB-COMPANY      -> ICL-COMPANY
                            WHB-LOCATION     -> ICL-LOCATION

                         WHBATCH FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Shipment       WHSHIPMENT

                            WHB-COMPANY      -> WHS-COMPANY
                            WHB-LOCATION     -> WHS-LOCATION
                            WHB-BATCH-NBR    -> WHS-BATCH-NBR
                                                WHS-SHIPMENT-NBR