WHBATCH – Warehouse Batch

System
Warehouse (WH)
Prefix
WHB
Primary key
COMPANY, LOCATION, BATCH-NBR
Fields
9
Updated by
1 program
Referenced by
4 programs

WHBATCH is the Warehouse Batch table in Lawson Warehouse (prefix WHB). It is indexed by COMPANY, LOCATION, BATCH-NBR (WHBSET1); alternate indexes: WHBSET2. It is related 1:1 to ICCOMPANY and ICLOCATION and 1:M to WHSHIPMENT. It is updated by WH130 and referenced by WH30.3, WH31.3, WH32.3 and WH82.1. The table has 9 fields, 2 indexes and 4 documented relations.

About WHBATCH

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

Fields (9)

Column = COBOL field name without the WHB- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#WHB-COMPANY PK
COMPANY		Numeric 4This field contains the company number.WH130
#WHB-LOCATION PK
LOCATION		Alpha 5This field contains a valid stock location within the company inventory.WH130
#WHB-BATCH-NBR PK
BATCH_NBR		Numeric 6This field identifies the batch number assigned to the shipment.WH130
#WHB-FIRST-SHIP-NBR
FIRST_SHIP_NBR		Numeric 10This field contains the first shipment contained in this batch.WH130
#WHB-LAST-SHIP-NBR
LAST_SHIP_NBR		Numeric 10This field contains the last shipment number contained in this batch.WH130
#WHB-WEIGHT
WEIGHT		Signed 9.3This field contains the total weight in all shipments for the batch.WH130
#WHB-CUBIC-FEET
CUBIC_FEET		Signed 9.3This field contains the cubic feet total in all shipments for the batch.WH130
#WHB-CARTONS
CARTONS		Numeric 6This field contains the total number of cartons in all shipments for the batch.—
#WHB-ROUTE
ROUTE		Numeric 4This field contains the route number. The route assigned to the ship-to customer defaults from the Order Entry Route file.WH130

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WHBSET1
  1. COMPANY
  2. LOCATION
  3. BATCH-NBR
PrimaryWH130, WH30.3, WH31.3, WH32.3, WH82.1
WHBSET2
  1. COMPANY
  2. LOCATION
  3. BATCH-NBR ↓
—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICCOMPANYICLOCATIONWHSHIPMENTWHBATCH

One to one (2) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
WHB-COMPANY→ICC-COMPANY (ICCSET1)
IclocationICLOCATIONRequired
WHB-COMPANY→ICL-COMPANY
WHB-LOCATION→ICL-LOCATION

One to many (2) — child tables

RelationTableRulesConditionField map
ShipmentWHSHIPMENT
WHB-COMPANY→WHS-COMPANY
WHB-LOCATION→WHS-LOCATION
WHB-BATCH-NBR→WHS-BATCH-NBR
—→WHS-SHIPMENT-NBR
ShipmentallWHSHIPMENT
WHB-COMPANY→WHS-COMPANY
WHB-LOCATION→WHS-LOCATION
WHB-BATCH-NBR→WHS-BATCH-NBR
—→WHS-SHIPMENT-NBR

Programs

Updated by (1)

Referenced by (4)