 |
Lawson Insight Technical Documentation |
|
WHSHLDTL FILE
Shipment Line Detail
The Shipment Line Detail file holds records of shipment line items that are
tracked by bin, lot, serial number, or multiple unit of measure.
REFERENCED BY
WH126 WH131 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 WH34.5 RQ300
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHD-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
WHD-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
WHD-DOC-NBR Alpha 10 (Right Justified) WH130 WH33.1
Doc Nbr This field contains the document number WH33.2 WH33.3
of the shipment line that contains WH33.4 WH33.5
details. WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHD-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
WHD-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
WHD-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
WHD-COMPONENT-SEQ Numeric 3 WH130 WH33.1
Component Sequence This field contains the component WH33.2 WH33.3
Number sequence number of the component item WH33.4 WH33.5
that contains details. WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHD-BIN Alpha 7 WH130 WH33.1
Bin This field contains the bin assigned to 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
WHD-LOT Alpha 10 WH130 WH33.1
Lot Number This field contains the lot assigned to 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
WHD-SUBLOT Alpha 6 WH130 WH33.1
Sublot Number This field contains the sublot assigned WH33.2 WH33.3
to the shipment line. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHD-SERIAL Alpha 16 WH130 WH33.1
Serial Number This field contains the serial number WH33.2 WH33.3
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
WHD-UOM Alpha 4 WH130 WH33.1
Unit of Measure This field contains the unit of measure WH33.2 WH33.3
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
WHD-UOM-MULT Signed 13.7 WH130 WH33.1
Unit of Measure This field contains the multiplier for WH33.2 WH33.3
Multiplier converting this unit of measure to the WH33.4 WH33.5
stock unit of measure. WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHD-QUANTITY Signed 13.4 WH130 WH33.1
Quantity This field contains the requested WH33.2 WH33.3
shipment line quantity. WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WHD-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.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH34.5
WHD-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.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHD-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.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
WHD-LOT-STRING Derived
Lot String This field contains the string that
represents the lot/sublot or serial
number (they are mutually exclusive).
WHD-BIN-STRING Derived
Bin String This field contains the bin/serial
string for printing pick lists.
WHD-SERIAL-STRING Derived
Serial String This field contains the string field
that represents the serial number.
WHD-UOM-STRING Derived
Uom String This field contains the string
representing the unit of measure.
WHD-PRINT-STRING Derived
Print String This field indicates the lot, bin,
serial number, or unit of measure to
print on the pick list.
WHD-ITEM-X Derived
Item X This field indicates either the
shipment line or the component line
item.
WHD-ITEM-XG Derived
Item Xg This field is used to help display the
shipment line or component line item.
WHSHLDTL FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WHDSET1 COMPANY Primary index used for accessing and RQ300 WH126
LOCATION updating the table. WH130 WH131
SHIPMENT-NBR WH224 WH33.1
LINE-NBR WH33.2 WH33.3
COMPONENT-SEQ WH33.4 WH33.5
BIN WH33.6 WH33.7
LOT WH33.8 WH33.9
SUBLOT WH34.1 WH34.2
UOM WH34.3 WH34.4
SERIAL WH34.5
WHDSET2 COMPANY Used to find shipments in bin sequence. WH33.7
LOCATION
SHIPMENT-NBR KeyChange
BIN
LOT
SUBLOT
SERIAL
UOM
LINE-NBR
COMPONENT-SEQ
WHSHLDTL FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WHD-COMPANY -> ICC-COMPANY
Iclocation ICLOCATION Not Required
WHD-COMPANY -> ICL-COMPANY
WHD-LOCATION -> ICL-LOCATION
Itemloc ITEMLOC Required
WHD-COMPANY -> ITL-COMPANY
WHD-LOCATION -> ITL-LOCATION
WHD-ITEM-XG -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WHD-ITEM-XG -> ITE-ITEM
Itemmast X ITEMMAST Not Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WHD-ITEM-XG -> ITE-ITEM
Shipcomp WHSHIPCOMP Required
When WHD-COMPONENT-SEQ > Zeroes
WHD-COMPANY -> WHC-COMPANY
WHD-LOCATION -> WHC-LOCATION
WHD-SHIPMENT-NBR -> WHC-SHIPMENT-NBR
WHD-LINE-NBR -> WHC-LINE-NBR
WHD-COMPONENT-SEQ -> WHC-COMPONENT-SEQ
Shipline WHSHIPLINE Required
WHD-COMPANY -> WHL-COMPANY
WHD-LOCATION -> WHL-LOCATION
WHD-SHIPMENT-NBR -> WHL-SHIPMENT-NBR
WHD-LINE-NBR -> WHL-LINE-NBR
Shipment WHSHIPMENT Required
WHD-COMPANY -> WHS-COMPANY
WHD-LOCATION -> WHS-LOCATION
WHD-SHIPMENT-NBR -> WHS-SHIPMENT-NBR
Sohdetail SOHDETAIL Required
When WHD-BIN-TRACK-FL = "Y"
WHD-COMPANY -> SDT-COMPANY
WHD-LOCATION -> SDT-LOCATION
WHL-ITEM -> SDT-ITEM
WHD-BIN -> SDT-BIN
WHD-UOM -> SDT-UOM
WHD-LOT -> SDT-LOT
WHD-SUBLOT -> SDT-SUBLOT
WHSHLDTL FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Com Itcomment ITCOMMENT
ICC-ITEM-GROUP -> ICO-ITEM-GROUP
WHC-ITEM -> ICO-ITEM
ICO-LANGUAGE-CODE
ICO-SEQ
Soh SOHDETAIL
WHD-COMPANY -> SDT-COMPANY
WHD-LOCATION -> SDT-LOCATION
WHL-ITEM -> SDT-ITEM
WHD-UOM -> SDT-UOM
SDT-LOT
SDT-SUBLOT
SDT-BIN
|