WHSHLAUD – Shipment Line Audit

System
Warehouse (WH)
Prefix
WHA
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, STATUS
Fields
10
Updated by
45 programs
Referenced by
181 programs

WHSHLAUD is the Shipment Line Audit table in Lawson Warehouse (prefix WHA). It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, STATUS (WHASET1); alternate indexes: WHASET2. It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 37 more and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 173 more. The table has 10 fields, 2 indexes and 0 documented relations.

About WHSHLAUD

The Shipment Line Audit file contains changes made to shipment lines.

Fields (10)

Column = COBOL field name without the WHA- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
WHA-COMPANY PK
COMPANY
Numeric 4This field contains the company number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHA-LOCATION PK
LOCATION
Alpha 5This field contains a valid stock location within the company inventory.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHA-SYSTEM-CD
SYSTEM_CD
Alpha 2This field indicates on which Lawson system the document originated.
  • OE Customer Order
  • RQ Requisitions
  • CX Case Cart
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHA-DOC-NBR
DOC_NBR
Alpha 10 (Right Justified)This field indicates the document number for the shipment line.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHA-SHIPMENT-NBR PK
SHIPMENT_NBR
Numeric 10This field contains the shipment number. One document can have several shipment numbers if the items were not shipped at the same time.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHA-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the shipment line number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHA-STATUS PK
STATUS
Numeric 1This field indicates the shipment status.
  • 0 Printed
  • 1 Picked
  • 2 Packed
  • 3 Shipped
  • 4 Released
  • 5 Closed
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHA-PRE-ASMBLD-KIT
PRE_ASMBLD_KIT
Signed 13.4This field contains the make-to-order kit quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHA-QUANTITY
QUANTITY
Signed 13.4This field contains the backordered, voided, or overshipped shipment line quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHA-ACTION-CD
ACTION_CD
Alpha 1This field indicates the action taken on the shipment line (backorder, void, or overship).
  • B Backorder
  • V Void
  • O Overship
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more

Indexes (2)

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

IndexKeysFlagsConditionUsed in
WHASET1COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, STATUSPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
WHASET2COMPANY, LOCATION, SHIPMENT-NBR, STATUS, LINE-NBR, ACTION-CDKeyChangeWH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more

Programs

Updated by (45)

Referenced by (181)