WHSHLDTL

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
CX100 CX20.1 CX20.2 CX20.4 CX20.5 CX220
CX30.1 CX300 CX506 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 WH32.5 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
Element: Company
Numeric 4
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 WH32.5
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
Element: System Cd
Alpha 2
This field indicates on which Lawson system the document originated.
OE = Customer Order
RQ = Requisitions
CX = Case Cart
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 WH32.5
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
Element: Doc Nbr
Alpha 10 (Right Justified)
This field contains the document number of the shipment line that contains details.
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 WH32.5
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
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
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 WH32.5
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
Element: Shipment Nbr
Numeric 10
This field contains the shipment number. One document can have several shipment numbers if the items were not shipped at the same time.
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 WH32.5
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
Element: Line Nbr
Numeric 6
This field contains the shipment line 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 WH32.5
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
Element: Seq
Numeric 3
This field contains the component sequence number of the component item that contains details.
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 WH32.5
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
Element: Bin
Alpha 7
This field contains the bin assigned to the shipment line.
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 WH32.5
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
Element: Lot
Alpha 10
This field contains the lot assigned to the shipment line.
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 WH32.5
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
Element: Sublot
Alpha 6
This field contains the sublot assigned to the shipment line.
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 WH32.5
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
Element: Serial
Alpha 16
This field contains the serial number assigned to the shipment line.
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 WH32.5
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
Element: Uom
Alpha 4
This field contains the unit of measure assigned to the shipment line.
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 WH32.5
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
Element: Uom Mult
Signed 13.7
This field contains the multiplier for converting this unit of measure to the stock unit of measure.
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 WH32.5
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
Element: Quantity
Signed 13.4
This field contains the requested shipment line quantity.
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 WH32.5
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
Element: Quantity
Signed 13.4
This field contains the catch weight quantity in stock unit of measure.
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 WH32.5
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
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
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 WH32.5
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
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
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 WH32.5
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
Element: Lot String
Derived
This field contains the string that represents the lot/sublot or serial number (they are mutually exclusive).
WHD-BIN-STRING
Element: Bin String
Derived
This field contains the bin/serial string for printing pick lists.
WHD-SERIAL-STRING
Element: Serial String
Derived
This field contains the string field that represents the serial number.
WHD-UOM-STRING
Element: Uom String
Derived
This field contains the string representing the unit of measure.
WHD-PRINT-STRING
Element: Print String
Derived
This field indicates the lot, bin, serial number, or unit of measure to print on the pick list.
WHD-ITEM-X
Element: Item X
Derived
This field indicates either the shipment line or the component line item.
WHD-ITEM-XG
Element: Item Xg
Derived
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
LOCATION
SHIPMENT-NBR
LINE-NBR
COMPONENT-SEQ
BIN
LOT
SUBLOT
UOM
SERIAL
...
CX100 CX20.1
CX20.2 CX20.4
CX20.5 CX220
CX30.1 CX300
CX506 RQ300
WH126 WH130
WH131 WH132
WH190 WH222
WH224 WH30.1
WH30.2 WH30.3
WH30.4 WH31.1
WH31.2 WH31.3
WH31.4 WH32.1
WH32.2 WH32.3
WH32.4 WH32.5
WHDSET2 COMPANY
LOCATION
SHIPMENT-NBR
BIN
LOT
SUBLOT
SERIAL
UOM
LINE-NBR
COMPONENT-SEQ
KeyChange
WH130 WH30.4
WH31.4 WH32.4
WH33.7 WHD3.1


WHSHLDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED 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
NAME
RELATED 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


File created: Thu Jun 09 02:33:56 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.