Lawson Insight Technical Documentation |
|
WHSHLAUD
WHSHLAUD FILE
Shipment Line Audit
The Shipment Line Audit file contains changes made to shipment lines.
REFERENCED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 IC28.1 MA180
MA41.2 MA41.7 MA43.1 MA43.2 MA43.3 MA43.9
MA530 MA531 MA60.2 MA60.3 MA60.5 MA61.1
MA66.2 MA66.3 MA67.1 MA67.2 MA70.1 MA75.1
MA80.1 MAI1.1 PO100 PO101 PO122 PO131
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO25.1 PO25.5 PO25.6 PO25.7
PO27.2 PO29.1 PO30.1 PO30.2 PO30.3 PO300
PO31.1 PO31.2 PO32.2 PO33.1 PO34.1 PO35.1
PO36.1 PO36.2 PO38.1 PO39.1 PO39.2 PO44.1
PO50.1 PO52.1 PO520 PO536 POI3.1 POII.1
POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ35.1 RQD1.1
RQIE.1 WH20.2 WH20.7 WH224 WHD2.1 WO132
WO140
UPDATED BY
WH130 WH132 WH190 WH30.1 WH30.2 WH30.3
WH30.4 WH31.1 WH31.2 WH31.3 WH31.4 WH32.1
WH32.2 WH32.3 WH32.4 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 WHD0.1 RQ300 WH222
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHA-COMPANY Numeric 4 WH130 WH132
Element: Company This field contains the company number. WH190 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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
WHA-LOCATION Alpha 5 WH130 WH132
Element: Location Code This field contains a valid stock WH190 WH30.1
location within the company inventory. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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
WHA-SYSTEM-CD Alpha 2 WH130 WH132
Element: System Code This field indicates on which Lawson WH190 WH30.1
system the document originated. WH30.2 WH30.3
OE = Customer Order WH30.4 WH31.1
RQ = Requisitions WH31.2 WH31.3
CX = Case Cart WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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
WHA-DOC-NBR Alpha 10 (Right Justified) WH130 WH132
Element: Doc Nbr This field indicates the document WH190 WH30.1
number for the shipment line. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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
WHA-SHIPMENT-NBR Numeric 10 WH130 WH132
Element: Shipment NumbeThis field contains the shipment WH190 WH30.1
number. One document can have several WH30.2 WH30.3
shipment numbers if the items were not WH30.4 WH31.1
shipped at the same time. WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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
WHA-LINE-NBR Numeric 6 WH130 WH132
Element: Line Number This field contains the shipment line WH190 WH30.1
number. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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
WHA-STATUS Numeric 1 WH130 WH132
Element: Status This field indicates the shipment WH190 WH30.1
status. WH30.2 WH30.3
0 = Printed WH30.4 WH31.1
1 = Picked WH31.2 WH31.3
2 = Packed WH31.4 WH32.1
3 = Shipped WH32.2 WH32.3
4 = Released WH32.4 WH33.1
5 = Closed 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
WHA-PRE-ASMBLD-KIT Signed 13.4 WH130 WH132
Element: Pre-Assembled This field contains the make-to-order WH190 WH30.1
kit quantity. WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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
WHA-QUANTITY Signed 13.4 WH130 WH132
Element: Quantity This field contains the backordered, WH190 WH30.1
voided, or overshipped shipment line WH30.2 WH30.3
quantity. WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 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
WHA-ACTION-CD Alpha 1 WH130 WH132
Element: Action Code This field indicates the action taken WH190 WH30.1
on the shipment line (backorder, void, WH30.2 WH30.3
or overship). WH30.4 WH31.1
B = Backorder WH31.2 WH31.3
V = Void WH31.4 WH32.1
O = Overship WH32.2 WH32.3
WH32.4 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
WHSHLAUD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHASET1 COMPANY Primary index used for accessing and AP125 AP126
LOCATION updating the table. AP131 AP20.1
SHIPMENT-NBR AP20.2 AP20.3
LINE-NBR AP20.4 AP20.5
STATUS AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
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
|