Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

WHBATCH


                              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.3    WH31.3    WH32.3

UPDATED BY

WH130

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

WHB-FIRST-SHIP-NBR     Numeric 10                                WH130
Element: Shipment NumbeThis field contains the first shipment
                       contained in this batch.

WHB-LAST-SHIP-NBR      Numeric 10                                WH130
Element: Shipment NumbeThis field contains the last shipment
                       number contained in this batch.

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

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

WHB-CARTONS            Numeric 6
Element: Number of CartThis field contains the total number of
                       cartons in all shipments for the batch.

WHB-ROUTE              Numeric 4                                 WH130
Element: 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   WH30.3
          LOCATION      updating the table.                      WH31.3  WH32.3
          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