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
WH126 WH131 WH224
UPDATED BY
BL92.1 RQ300 WH130 WH132 WH190 WH222
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
WHD0.1 WHD2.1 WHD3.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHD-COMPANY Numeric 4 BL92.1 WH130
Element: Company This field contains the company number. 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 WH130
Element: System Cd This field indicates on which Lawson WH132 WH190
system the document originated. WH30.1 WH30.2
OE = Customer Order WH30.3 WH30.4
RQ = Requisitions WH31.1 WH31.2
CX = Case Cart 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 WH130
Element: Doc Nbr This field contains the document number WH132 WH190
of the shipment line that contains WH30.1 WH30.2
details. 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 WH130
Element: Location This field contains a valid stock WH132 WH190
location within the company inventory. 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 WH130
Element: Shipment Nbr This field contains the shipment WH132 WH190
number. One document can have several WH30.1 WH30.2
shipment numbers if the items were not WH30.3 WH30.4
shipped at the same time. 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 WH130
Element: Line Nbr This field contains the shipment line WH132 WH190
number. 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 WH130
Element: Seq This field contains the component WH132 WH190
sequence number of the component item WH30.1 WH30.2
that contains details. 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 WH130
Element: Bin This field contains the bin assigned to WH132 WH190
the shipment line. 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 WH130
Element: Lot This field contains the lot assigned to WH132 WH190
the shipment line. 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 WH130
Element: Sublot This field contains the sublot assigned WH132 WH190
to the shipment line. 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 WH130
Element: Serial This field contains the serial number WH132 WH190
assigned to the shipment line. 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 WH130
Element: Uom This field contains the unit of measure WH132 WH190
assigned to the shipment line. 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 WH130
Element: Uom Mult This field contains the multiplier for WH132 WH190
converting this unit of measure to the WH30.1 WH30.2
stock unit of measure. 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 WH130
Element: Quantity This field contains the requested WH132 WH190
shipment line quantity. 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 WH130
Element: Quantity This field contains the catch weight WH132 WH190
quantity in stock unit of measure. 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
WHD2.1
WHD-UPDATE-DATE Numeric 8 (yyyymmdd) BL92.1 WH130
Element: Update Date This field contains the date the record WH132 WH190
was updated. 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 WH130
Element: Update Time This field contains the system time WH132 WH190
when the record was updated. 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 BL92.1 RQ300
LOCATION WH126 WH130
SHIPMENT-NBR WH131 WH132
LINE-NBR WH190 WH222
COMPONENT-SEQ WH224 WH30.1
BIN WH30.2 WH30.3
LOT WH30.4 WH31.1
SUBLOT WH31.2 WH31.3
UOM WH31.4 WH32.1
SERIAL WH32.2 WH32.3
WH32.4 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.7
WH33.8 WH33.9
...
WHDSET2 COMPANY KeyChange WH130 WH30.4
LOCATION WH31.4 WH32.4
SHIPMENT-NBR WH33.7 WHD3.1
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
|