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.
UPDATED BY
RQ300

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHD-COMPANY
Element: Company
Numeric 4
This field contains the company number.
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
WHD-DOC-NBR
Element: Doc Nbr
Alpha 10 (Right Justified)
This field contains the document number of the shipment line that contains details.
WHD-LOCATION
Element: Location
Alpha 5
This field contains a valid stock location within the company inventory.
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.
WHD-LINE-NBR
Element: Line Nbr
Numeric 6
This field contains the shipment line number.
WHD-COMPONENT-SEQ
Element: Seq
Numeric 3
This field contains the component sequence number of the component item that contains details.
WHD-BIN
Element: Bin
Alpha 7
This field contains the bin assigned to the shipment line.
WHD-LOT
Element: Lot
Alpha 10
This field contains the lot assigned to the shipment line.
WHD-SUBLOT
Element: Sublot
Alpha 6
This field contains the sublot assigned to the shipment line.
WHD-SERIAL
Element: Serial
Alpha 16
This field contains the serial number assigned to the shipment line.
WHD-UOM
Element: Uom
Alpha 4
This field contains the unit of measure assigned to the shipment line.
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.
WHD-QUANTITY
Element: Quantity
Signed 13.4
This field contains the requested shipment line quantity.
WHD-CATCH-WT-QTY
Element: Quantity
Signed 13.4
This field contains the catch weight quantity in stock unit of measure.
WHD-UPDATE-DATE
Element: Update Date
Numeric 8 (yyyymmdd)
This field contains the date the record was updated.
WHD-UPDATE-TIME
Element: Update Time
Numeric 6
This field contains the system time when the record was updated.
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
RQ300
WHDSET2 COMPANY
LOCATION
SHIPMENT-NBR
BIN
LOT
SUBLOT
SERIAL
UOM
LINE-NBR
COMPONENT-SEQ
KeyChange


WHSHLDTL FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Iccompany ICCOMPANY Required
WHD-COMPANY->ICC-COMPANY (ICCSET1)
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: Wed Jun 08 20:51:52 2016

Home
Contact Us



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