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.5 OE30.6 WH126 WH131 WH224
UPDATED BY
BL92.1 OE114 OE310 WH130 WH132 WH190
WH30.1 WH30.2 WH30.3 WH31.1 WH31.2 WH31.3
WH32.1 WH32.2 WH32.3 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 WH968 CX100 CX20.1
CX20.2 CX20.4 CX20.5 CX220 CX30.1 CX300
CX506 RQ300 WH222
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WHD-COMPANY Numeric 4 BL92.1 OE114
Company This field contains the company number. WH130 WH132
WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-SYSTEM-CD Alpha 2 BL92.1 OE114
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 WH31.1 WH31.2
CX = Case Cart WH31.3 WH32.1
WH32.2 WH32.3
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
WH968
WHD-DOC-NBR Alpha 10 (Right Justified) BL92.1 OE114
Document Number This field contains the document number WH130 WH132
of the shipment line that contains WH190 WH30.1
details. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-LOCATION Alpha 5 BL92.1 OE114
Location This field contains a valid stock WH130 WH132
location within the company inventory. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-SHIPMENT-NBR Numeric 10 BL92.1 OE114
Shipment Number This 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. WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-LINE-NBR Numeric 6 BL92.1 OE114
Line Number This field contains the shipment line WH130 WH132
number. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-COMPONENT-SEQ Numeric 3 BL92.1 OE114
Component Sequence This field contains the component WH130 WH132
sequence number of the component item WH190 WH30.1
that contains details. WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-BIN Alpha 7 BL92.1 OE114
Bin This field contains the bin assigned to WH130 WH132
the shipment line. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-LOT Alpha 10 BL92.1 OE114
Lot This field contains the lot assigned to WH130 WH132
the shipment line. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-SUBLOT Alpha 6 BL92.1 OE114
Sublot This field contains the sublot assigned WH130 WH132
to the shipment line. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-SERIAL Alpha 16 BL92.1 OE114
Serial This field contains the serial number WH130 WH132
assigned to the shipment line. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-UOM Alpha 4 BL92.1 OE114
Unit of Measure This field contains the unit of measure WH130 WH132
assigned to the shipment line. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
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
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-QUANTITY Signed 13.4 BL92.1 OE114
Quantity This field contains the requested WH130 WH132
shipment line quantity. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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 WH968
WHD-CATCH-WT-QTY Signed 13.4 BL92.1 OE114
Catch Weight This field contains the catch weight WH130 WH132
Quantity quantity in stock unit of measure. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
WH968
WHD-UPDATE-DATE Numeric 8 (yyyymmdd) BL92.1 OE114
Update Date This field contains the date the record WH130 WH132
was updated. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
WH968
WHD-UPDATE-TIME Numeric 6 BL92.1 OE114
Update Time This field contains the system time WH130 WH132
when the record was updated. WH190 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
WH32.2 WH32.3
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
WH968
WHD-POTENCY Signed 7.3 OE114 WH130
Potency This field is currently not used by the WH33.7 WH520
Lawson Inventory Control system. WH830 WH968
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
Unit of Measure This field contains the string
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 BL92.1 CX100
LOCATION updating the table. CX20.1 CX20.2
SHIPMENT-NBR CX20.4 CX20.5
LINE-NBR CX220 CX30.1
COMPONENT-SEQ CX300 CX506
BIN OE114 OE129
LOT OE30.5 OE30.6
SUBLOT OE310 RQ300
UOM WH126 WH130
SERIAL WH131 WH132
WH190 WH222
WH224 WH30.1
WH30.2 WH30.3
WH31.1 WH31.2
WH31.3 WH32.1
...
WHDSET2 COMPANY Used to find shipments in bin sequence. WH130 WH30.3
LOCATION WH31.3 WH32.3
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
WHL-LOCATION -> ITL-LOCATION
WHL-ITEM -> ITL-ITEM
Itemmast ITEMMAST Required
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
WHL-ITEM -> 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
Valid When WHD-COMPONENT-SEQ > Zeroes
ICC-ITEM-GROUP -> ICO-ITEM-GROUP
WHC-ITEM -> ICO-ITEM
Spaces -> ICO-LANGUAGE-CODE
ICO-SEQ
|