Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              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.

UPDATED BY

WH130

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

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

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

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

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

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

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

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

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

WHB-ROUTE            Numeric 4                                   WH130
Route                This field contains the route number.
                     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     WH130
          LOCATION      updating the table.
          BATCH-NBR

                         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