 |
Lawson Insight Technical Documentation |
|
WHSHLAUD FILE
Shipment Line Audit
The Shipment Line Audit file contains changes made to shipment lines.
REFERENCED BY
WH224
UPDATED BY
WH130 WH33.1 WH33.2 WH33.3 WH33.4 WH33.5
WH33.6 WH33.7 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHA-COMPANY Numeric 4 WH130 WH33.1
Company This field contains the company number. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHA-LOCATION Alpha 5 WH130 WH33.1
Location Code This field contains a valid stock WH33.2 WH33.3
location within the company inventory. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHA-SYSTEM-CD Alpha 2 WH130 WH33.1
System Code This field indicates on which Lawson WH33.2 WH33.3
system the document originated. WH33.4 WH33.5
OE = Customer Order WH33.6 WH33.8
RQ = Requisitions WH33.9 WH34.1
CX = Case Cart WH34.2 WH34.3
WH34.4
WHA-DOC-NBR Alpha 10 (Right Justified) WH130 WH33.1
Doc Nbr This field indicates the document WH33.2 WH33.3
number for the shipment line. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHA-SHIPMENT-NBR Numeric 10 WH130 WH33.1
Shipment Number This field contains the shipment WH33.2 WH33.3
number. One document can have several WH33.4 WH33.5
shipment numbers if the items were not WH33.6 WH33.8
shipped at the same time. WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHA-LINE-NBR Numeric 6 WH130 WH33.1
Line Number This field contains the shipment line WH33.2 WH33.3
number. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHA-STATUS Numeric 1 WH130 WH33.1
Status This field indicates the shipment WH33.2 WH33.3
status. WH33.4 WH33.5
0 = Printed WH33.6 WH33.8
1 = Picked WH33.9 WH34.1
2 = Packed WH34.2 WH34.3
3 = Shipped WH34.4
4 = Released
5 = Closed
WHA-PRE-ASMBLD-KIT Signed 13.4 WH130 WH33.1
Pre-Assembled Kit This field contains the make-to-order WH33.2 WH33.3
kit quantity. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHA-QUANTITY Signed 13.4 WH130 WH33.1
Quantity This field contains the backordered, WH33.2 WH33.3
voided, or overshipped shipment line WH33.4 WH33.5
quantity. WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHA-ACTION-CD Alpha 1 WH130 WH33.1
Action Code This field indicates the action taken WH33.2 WH33.3
on the shipment line (backorder, void, WH33.4 WH33.5
or overship). WH33.6 WH33.8
B = Backorder WH33.9 WH34.1
V = Void WH34.2 WH34.3
O = Overship WH34.4
WHSHLAUD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHASET1 COMPANY Primary index used for accessing and RQ300 WH130
LOCATION updating the table. WH224 WH33.1
SHIPMENT-NBR WH33.2 WH33.3
LINE-NBR WH33.4 WH33.5
STATUS WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHASET2 COMPANY Used to find any changes that were made
LOCATION to shipment lines by shipment status.
SHIPMENT-NBR KeyChange
STATUS
LINE-NBR
ACTION-CD
|