 |
Lawson Insight Technical Documentation |
|
WHSHIPLINE FILE
Shipment Line
The Shipment Line file contains shipment line records.
REFERENCED BY
BL123 WH126 WH131 WH140 WH224 POIF.1
RQ44.1 RQ44.2
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 WH34.5 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHL-COMPANY Numeric 4 WH130 WH33.1
Company This field contains the company number. WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-SYSTEM-CD Alpha 2 WH130 WH33.1
System Code This field indicates from which Lawson WH33.2 WH33.3
system the document originated. WH33.4 WH33.5
OE = Customer Order WH33.6 WH33.7
RQ = Requisitions WH33.8 WH33.9
CX = Case Cart WH34.1 WH34.2
WH34.3 WH34.4
WHL-DOC-NBR Alpha 10 (Right Justified) WH130 WH33.1
Doc Nbr This field contains the document number WH33.2 WH33.3
assigned to this shipment line. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-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.7
shipped at the same time. WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-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.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-LINE-TYPE Alpha 1 WH130 WH33.1
Line Type This field contains the type of item WH33.2 WH33.3
found on this shipment line. WH33.4 WH33.5
I = Inventoried Item WH33.6 WH33.7
N = Nonstock Item WH33.8 WH33.9
X = Special Item WH34.1 WH34.2
WH34.3 WH34.4
WHL-ITEM Alpha 32 WH130 WH33.1
Item Number This field contains the item WH33.2 WH33.3
identifier. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-DESCRIPTION Alpha 30 (Lower Case) WH130 WH33.1
Description This field contains the description of WH33.2 WH33.3
the line item. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-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.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-PRINTED-QTY Signed 13.4 WH130 WH33.1
Printed on Pick This field contains the quantity that WH33.2 WH33.3
List Quantity was printed on the pick list to be WH33.4 WH33.5
picked. WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-TRAN-UOM Alpha 4 WH130 WH33.1
Transaction Unit of This field indicates the unit of WH33.2 WH33.3
Measure measure from the document. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-TRAN-UOM-MULT Signed 13.7 WH130 WH33.1
Transaction UOM This field is the conversion factor to WH33.2 WH33.3
Multiplier convert to stock unit of measure. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-IN-PROCESS-QTY Signed 13.4 WH130 WH33.1
In-Process Quantity This field contains the in-process WH33.2 WH33.3
quantity, which is the shipment line WH33.4 WH33.5
quantity currently in process. WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-SHIPPED-QTY Signed 13.4 WH130 WH33.1
Shipped Quantity This field contains the quantity that WH33.2 WH33.3
was shipped in stock unit of measure. WH33.4 WH33.5
For catch weight items, the shipped WH33.6 WH33.7
quantity is in secondary unit of WH33.8 WH33.9
measure. WH34.1 WH34.2
WH34.3 WH34.4
WHL-DELIVERED-QTY Signed 13.4
Delivered Quantity This is the quantity that has been
issued or transferred to the requesting
location. This quantity is updated by
PO221 (Delivery Ticket).
WHL-CATCH-WT-QTY Signed 13.4 WH130 WH33.1
Catch Weight This field contains the catch weight WH33.2 WH33.3
Quantity quantity in stock unit of measure. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHL-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
WHL-KIT-COMP-QTY Signed 13.4 WH130 WH33.1
Kit Comp Qty The total component quantity of the WH33.2 WH33.3
shipping line kit item. WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHL-DETAIL-QTY Signed 13.4 WH130 WH33.1
Detail Quantity This field shows the total quantity of WH33.2 WH33.3
details assigned to the shipment line. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-DTL-CTW-QTY Signed 13.4 WH130 WH33.1
Detail Catch Weight This field contains the catch weight WH33.2 WH33.3
Quantity quantity for shipment lines with WH33.4 WH33.5
details. WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH34.5
WHL-DETAIL-REQ Alpha 1 WH130 WH33.1
Detail Required This field indicates whether or not WH33.2 WH33.3
details are required for shipment lines. WH33.4 WH33.5
Y = Yes WH33.6 WH33.7
N = No WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-WALK-THRU-REQ Alpha 1 WH130 WH33.1
Walk Thru Required This field indicates that a shipment WH33.2 WH33.3
line is out of balance. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH34.5
WHL-UNIT-COST Signed 13.5 WH130 WH33.1
Unit Cost This field contains the unit cost of WH33.2 WH33.3
the shipment line. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-WEIGHT Signed 9.3 WH130 WH33.1
Unit Weight This field contains the shipment line's WH33.2 WH33.3
calculated weight based on the item WH33.4 WH33.5
master stock weight and the line's WH33.6 WH33.7
quantity in stock unit of measure. WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-CUBIC-FEET Signed 9.3 WH130 WH33.1
Cubic Feet This field contains the shipment line's WH33.2 WH33.3
calculated cubic measurement based on WH33.4 WH33.5
the item master stock cubic and the WH33.6 WH33.7
shipment line's quantity in stock unit WH33.8 WH33.9
of measure. WH34.1 WH34.2
WH34.3 WH34.4
WHL-MSDS-REQ-FL Alpha 1
MSDS Required Flag This field indicates if a Material
Safety Data Sheet is required for the
item of this shipment line. This flag is
originally set at item master.
Y = Yes
N = No
WHL-MSDS-DT Numeric 8 (yyyymmdd) WH130 WH33.1
MSDS Date This field contains the date that a WH33.2 WH33.3
Material Safety Data Sheet is being sent WH33.4 WH33.5
to a customer ship to for this shipment WH33.6 WH33.7
line. WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-MSDS-DOCUMENT Alpha 30
Msds Document The document number that references the
Material Safety Data Sheet that is being
sent for this shipment line.
WHL-MSDS-VERSION Alpha 4
Msds Version The version number of the MSDS document
that is being sent with this shipment
line.
WHL-OPR-CODE Alpha 10 (Lower Case) WH130 WH33.1
Operator Code This field contains the operator code WH33.2 WH33.3
or user ID of the person who last WH33.4 WH33.5
updated this record. WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-UPDATE-DATE Numeric 8 (yyyymmdd) WH130 WH33.1
Update Date This field contains the date the record WH33.2 WH33.3
was updated. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-UPDATE-TIME Numeric 6 WH130 WH33.1
Update Time This field contains the system time WH33.2 WH33.3
when the record was updated. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHL-FULL-VOID-FL Alpha 1 WH130 WH33.1
Full Void Fl Indicates that shipment line has been WH33.2 WH33.3
voided. No quantities will be shipped WH33.4 WH33.5
from this line. WH33.6 WH33.7
Y = Voided WH33.8 WH33.9
N = Not Voided WH34.1 WH34.2
WH34.3 WH34.4
WHL-REQ-COMPANY Numeric 4
Req Company This field contains the requesting
company.
WHL-OPEN-QUANTITY Derived
Open Quantity This field contains the total of the
in-process quantity and the backorder
quantity.
WHL-PARTIAL Derived
Partial This field is used to help determine if
a shipment is partial or not.
WHL-PARTIAL-VALUE Derived
Partial Value This field indicates whether or not a
shipment is partial.
WHL-SUPLMNTARY-UOM Alpha 4 WH130 WH33.1
Suplmntary Uom WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHL-SUPLMNTARY-QTY Signed 13.4 WH130 WH33.1
Suplmntary Qty WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHSHIPLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHLSET1 COMPANY Primary index used for accessing and BL123 RQ300
LOCATION updating the table. WH126 WH130
SHIPMENT-NBR WH131 WH140
LINE-NBR WH224 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
WH34.5
WHLSET2 COMPANY Used to find shipment lines by the POIF.1 RQ44.1
SYSTEM-CD originating system. RQ44.2 WH130
DOC-NBR WH33.1 WH33.2
LINE-NBR WH33.3 WH33.4
SHIPMENT-NBR WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHLSET3 COMPANY Used to find shipment lines that need WH130 WH33.1
LOCATION to have details assigned. WH33.2 WH33.3
SHIPMENT-NBR Subset WH33.4 WH33.5
LINE-NBR Where (WALK-THRU-REQ = "Y" ) WH34.1 WH34.2
ITEM WH34.3 WH34.4
WHLSET4 COMPANY Used to find shipment lines that do not
LOCATION require details (but other lines on the
SHIPMENT-NBR same shipment do require details).
LINE-NBR Subset
Where DETAIL-REQ = "N"
WHLSET5 COMPANY KeyChange
LOCATION
SHIPMENT-NBR
FULL-VOID-FL
LINE-NBR
WHLSET6 COMPANY This index was created as a solution to WH33.7
LOCATION the Find Next/Prev Flag error. It is
LINE-NBR only used where a modify must be done
SHIPMENT-NBR within a 850-FIND-NLT or 850-FIND-BEGRNG
loop.
WHSHIPLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Caseline CXPREFITEM Required
When WHL-SYSTEM-CD = "CX"
WHL-COMPANY -> CPI-COMPANY
WHS-REQ-LOCATION -> CPI-REQ-LOCATION
WHL-DOC-NBR -> CPI-CASE
WHL-LINE-NBR -> CPI-IF-REF-NBR
Coline COLINE Required
When WHL-SYSTEM-CD = "OE"
WHL-COMPANY -> COL-COMPANY
WDH-DOC-NBR-NUM -> COL-ORDER-NBR
WHL-LINE-NBR -> COL-LINE-NBR
Iccompany ICCOMPANY Required
WHL-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Required
WHL-COMPANY -> ICL-COMPANY
WHL-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
When WHL-LINE-TYPE = "I"
WHL-COMPANY -> ITL-COMPANY
WHL-LOCATION -> ITL-LOCATION
WHL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
When WHL-LINE-TYPE = "I"
Or WHL-LINE-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WHL-ITEM -> ITE-ITEM
Reqline REQLINE Required
When WHL-SYSTEM-CD = "RQ"
WDM-REQ-COMPANY -> RLN-COMPANY
WDM-DOC-NBR-NUM -> RLN-REQ-NUMBER
WHL-LINE-NBR -> RLN-LINE-NBR
Shipment WHSHIPMENT Required
WHL-COMPANY -> WHS-COMPANY
WHL-LOCATION -> WHS-LOCATION
WHL-SHIPMENT-NBR -> WHS-SHIPMENT-NBR
Whdemand WHDEMAND Required
WHL-COMPANY -> WDM-COMPANY
WHL-SYSTEM-CD -> WDM-SYSTEM-CD
WHL-DOC-NBR -> WDM-DOC-NBR
WHL-LINE-NBR -> WDM-LINE-NBR
Zeroes -> WDM-COMPONENT-SEQ
WHL-LOCATION -> WDM-LOCATION
Whdemndhdr WHDEMNDHDR Required
WHL-COMPANY -> WDH-COMPANY
WHL-SYSTEM-CD -> WDH-SYSTEM-CD
WHL-DOC-NBR -> WDH-DOC-NBR
Whwebtrack WHWEBTRACK Not Required
WHL-COMPANY -> WST-COMPANY
WHL-LOCATION -> WST-LOCATION
WHL-SHIPMENT-NBR -> WST-SHIPMENT-NBR
WHL-LINE-NBR -> WST-LINE-NBR
Whwhluf WHWHLUF Not Required
WHL-COMPANY -> WLU-COMPANY
WHL-LOCATION -> WLU-LOCATION
WHL-SHIPMENT-NBR -> WLU-SHIPMENT-NBR
WHL-LINE-NBR -> WLU-LINE-NBR
WHSHIPLINE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Attached Bins WHSHLDTL
Valid When WHL-LOT-TRACK-FL = "N"
And WHL-BIN-TRACK-FL = "Y"
And WHL-SER-TRACK-FL = "N"
WHL-COMPANY -> WHD-COMPANY
WHL-LOCATION -> WHD-LOCATION
WHL-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
WHL-LINE-NBR -> WHD-LINE-NBR
Zeroes -> WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Attached Lots WHSHLDTL
Valid When WHL-LOT-TRACK-FL = "Y"
WHL-COMPANY -> WHD-COMPANY
WHL-LINE-TYPE -> WHD-LOCATION
WHL-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
WHL-LINE-NBR -> WHD-LINE-NBR
Zeroes -> WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Attached Sers WHSHLDTL
Valid When WHL-SER-TRACK-FL = "I"
WHL-COMPANY -> WHD-COMPANY
WHL-LOCATION -> WHD-LOCATION
WHL-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
WHL-LINE-NBR -> WHD-LINE-NBR
Zeroes -> WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Attached Uoms WHSHLDTL
Valid When WHL- = WHL-
And WHL-LOT-TRACK-FL = "N"
And WHL-SER-TRACK-FL = "N"
And WHL-BIN-TRACK-FL = "N"
WHL-COMPANY -> WHD-COMPANY
WHL-LOCATION -> WHD-LOCATION
WHL-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
WHL-LINE-NBR -> WHD-LINE-NBR
Zeroes -> WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Bins SOHDETAIL
Valid When WHL-LOT-TRACK-FL = "N"
And WHL-BIN-TRACK-FL = "Y"
And WHL-SER-TRACK-FL = "N"
WHL-COMPANY -> SDT-COMPANY
WHL-LOCATION -> SDT-LOCATION
WHL-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Itcomment ITCOMMENT
ICC-ITEM-GROUP -> ICO-ITEM-GROUP
WHL-ITEM -> ICO-ITEM
ICO-LANGUAGE-CODE
ICO-SEQ
Itserial ITSERIAL
Valid When WHL-SER-TRACK-FL = "R"
WHL-COMPANY -> SER-COMPANY
WHL-ITEM -> SER-ITEM
SER-SERIAL
Itserials ITSERIAL
Valid When WHL-SER-TRACK-FL = "I"
WHL-COMPANY -> SER-COMPANY
WHL-ITEM -> SER-ITEM
SER-SERIAL
Lots SOHDETAIL
Valid When WHL-LOT-TRACK-FL = "Y"
WHL-COMPANY -> SDT-COMPANY
WHL-LOCATION -> SDT-LOCATION
WHL-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Shiplnedtl WHSHLDTL
WHL-COMPANY -> WHD-COMPANY
WHL-LOCATION -> WHD-LOCATION
WHL-SHIPMENT-NBR -> WHD-SHIPMENT-NBR
WHL-LINE-NBR -> WHD-LINE-NBR
WHD-COMPONENT-SEQ
WHD-BIN
WHD-LOT
WHD-SUBLOT
WHD-UOM
WHD-SERIAL
Sohdetail SOHDETAIL
WHL-COMPANY -> SDT-COMPANY
WHL-LOCATION -> SDT-LOCATION
WHL-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Uoms SOHDETAIL
Valid When WHL- = WHL-
And WHL-LOT-TRACK-FL = "N"
And WHL-SER-TRACK-FL = "N"
And WHL-BIN-TRACK-FL = "N"
WHL-COMPANY -> SDT-COMPANY
WHL-LOCATION -> SDT-LOCATION
WHL-ITEM -> SDT-ITEM
SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
Whshipcomp WHSHIPCOMP
WHL-COMPANY -> WHC-COMPANY
WHL-LOCATION -> WHC-LOCATION
WHL-SHIPMENT-NBR -> WHC-SHIPMENT-NBR
WHL-LINE-NBR -> WHC-LINE-NBR
WHC-COMPONENT-SEQ
Whshlaud WHSHLAUD
WHL-COMPANY -> WHA-COMPANY
WHL-LOCATION -> WHA-LOCATION
WHL-SHIPMENT-NBR -> WHA-SHIPMENT-NBR
WHL-LINE-NBR -> WHA-LINE-NBR
WHA-STATUS
|