Lawson Insight Technical Documentation |
|
WHSHLDTL
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
OE129 OE30.4 OE30.5 OE30.6 WH126 WH131
WH224
UPDATED BY
BL92.1 OE114 OE310 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 WH34.5 WH40.1 WH40.2 WH520 WH830
RQ300 WH222
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHD-COMPANY Numeric 4 BL92.1 OE114
Element: Company This field contains the company number. 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
WHD-SYSTEM-CD Alpha 2 BL92.1 OE114
Element: 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 WH30.4 WH31.1
CX = Case Cart 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
WHD-DOC-NBR Alpha 10 (Right Justified) BL92.1 OE114
Element: Doc Nbr This field contains the document number WH130 WH132
of the shipment line that contains WH190 WH30.1
details. 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
WHD-LOCATION Alpha 5 BL92.1 OE114
Element: Location Code This field contains a valid stock WH130 WH132
location within the company inventory. 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
WHD-SHIPMENT-NBR Numeric 10 BL92.1 OE114
Element: Shipment NumbeThis 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. 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
WHD-LINE-NBR Numeric 6 BL92.1 OE114
Element: Line Number This field contains the shipment line WH130 WH132
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.7
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
WH40.1 WH40.2
WH520 WH830
WHD-COMPONENT-SEQ Numeric 3 BL92.1 OE114
Element: Sequence NumbeThis field contains the component WH130 WH132
sequence number of the component item WH190 WH30.1
that contains details. 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
WHD-BIN Alpha 7 BL92.1 OE114
Element: Bin This field contains the bin assigned to WH130 WH132
the shipment line. 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
WHD-LOT Alpha 10 BL92.1 OE114
Element: Lot Number This field contains the lot assigned to WH130 WH132
the shipment line. 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
WHD-SUBLOT Alpha 6 BL92.1 OE114
Element: Sublot Number This field contains the sublot assigned WH130 WH132
to the shipment line. 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
WHD-SERIAL Alpha 16 BL92.1 OE114
Element: Serial Number This field contains the serial number WH130 WH132
assigned to the shipment line. 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
WHD-UOM Alpha 4 BL92.1 OE114
Element: Unit of MeasurThis field contains the unit of measure WH130 WH132
assigned to the shipment line. 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
WHD-UOM-MULT Signed 13.7 BL92.1 OE114
Unit of Measure This field contains the multiplier for WH130 WH132
Multiplier converting this unit of measure to the WH190 WH30.1
stock unit of measure. 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
WHD-QUANTITY Signed 13.4 BL92.1 OE114
Element: Quantity This field contains the requested WH130 WH132
shipment line quantity. 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
WHD-CATCH-WT-QTY Signed 13.4 BL92.1 OE114
Element: Quantity This field contains the catch weight WH130 WH132
quantity in stock unit of measure. 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
WH34.5 WH40.1
WH40.2 WH520
WH830
WHD-UPDATE-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Element: Update Date This field contains the date the record WH130 WH132
was updated. 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
WHD-UPDATE-TIME Numeric 6 BL92.1 OE114
Element: Update Time This field contains the system time WH130 WH132
when the record was updated. 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
WHD-LOT-STRING Derived
Element: Lot String This field contains the string that
represents the lot/sublot or serial
number (they are mutually exclusive).
WHD-BIN-STRING Derived
Element: Bin String This field contains the bin/serial
string for printing pick lists.
WHD-SERIAL-STRING Derived
Element: Serial String This field contains the string field
that represents the serial number.
WHD-UOM-STRING Derived
Element: Uom String This field contains the string
representing the unit of measure.
WHD-PRINT-STRING Derived
Element: Print String This field indicates the lot, bin,
serial number, or unit of measure to
print on the pick list.
WHD-ITEM-X Derived
Element: Item X This field indicates either the
shipment line or the component line
item.
WHD-ITEM-XG Derived
Element: 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 BL92.1 OE114
LOCATION updating the table. OE129 OE30.4
SHIPMENT-NBR OE30.5 OE30.6
LINE-NBR OE310 RQ300
COMPONENT-SEQ WH126 WH130
BIN WH131 WH132
LOT WH190 WH222
SUBLOT WH224 WH30.1
UOM WH30.2 WH30.3
SERIAL WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH33.1
WH33.2 WH33.3
...
WHDSET2 COMPANY Used to find shipments in bin sequence. WH130 WH30.4
LOCATION WH31.4 WH32.4
SHIPMENT-NBR KeyChange WH33.7
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 ITL-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
|