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