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.

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

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`WHBSET1`	`COMPANY`, `LOCATION`, `BATCH-NBR`	Primary		WH130, WH30.3, WH31.3, WH32.3, WH82.1
`WHBSET2`	`COMPANY`, `LOCATION`, `BATCH-NBR*`			—

Relations

One to one (2) — lookups and parents

Relation	Table	Rules	Condition	Field map
Iccompany	ICCOMPANY	Required		`WHB-COMPANY` → `ICC-COMPANY (ICCSET1)`
Iclocation	ICLOCATION	Required		`WHB-COMPANY` → `ICL-COMPANY`, `WHB-LOCATION` → `ICL-LOCATION`

One to many (2) — child tables

Relation	Table	Rules	Condition	Field map
Shipment	WHSHIPMENT			`WHB-COMPANY` → `WHS-COMPANY`, `WHB-LOCATION` → `WHS-LOCATION`, `WHB-BATCH-NBR` → `WHS-BATCH-NBR`, → `WHS-SHIPMENT-NBR`
Shipmentall	WHSHIPMENT			`WHB-COMPANY` → `WHS-COMPANY`, `WHB-LOCATION` → `WHS-LOCATION`, `WHB-BATCH-NBR` → `WHS-BATCH-NBR`, → `WHS-SHIPMENT-NBR`

WHBATCH – Warehouse Batch

About WHBATCH

Fields (9)

Indexes (2)

Relations

One to one (2) — lookups and parents

One to many (2) — child tables

Programs

Updated by (1)

Referenced by (4)