 |
Lawson Insight Technical Documentation |
|
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
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 WH130 WH132
Company This field contains the company 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-SYSTEM-CD Alpha 2 WH130 WH132
System Code This field indicates on which Lawson WH190 WH30.1
system the document originated. WH30.2 WH30.3
OE = Customer Order WH30.4 WH31.1
RQ = Requisitions WH31.2 WH31.3
CX = Case Cart 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) WH130 WH132
Doc Nbr This field contains the document number WH190 WH30.1
of the shipment line that contains WH30.2 WH30.3
details. 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 WH130 WH132
Location Code This field contains a valid stock WH190 WH30.1
location within the company inventory. 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 WH130 WH132
Shipment Number This field contains the shipment WH190 WH30.1
number. One document can have several WH30.2 WH30.3
shipment numbers if the items were not WH30.4 WH31.1
shipped at the same time. 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 WH130 WH132
Line Number This field contains the shipment line WH190 WH30.1
number. 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 WH130 WH132
Component Sequence This field contains the component WH190 WH30.1
Number sequence number of the component item WH30.2 WH30.3
that contains details. 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 WH130 WH132
Bin This field contains the bin assigned to WH190 WH30.1
the shipment line. 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 WH130 WH132
Lot Number This field contains the lot assigned to WH190 WH30.1
the shipment line. 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 WH130 WH132
Sublot Number This field contains the sublot assigned WH190 WH30.1
to the shipment line. 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 WH130 WH132
Serial Number This field contains the serial number WH190 WH30.1
assigned to the shipment line. 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 WH130 WH132
Unit of Measure This field contains the unit of measure WH190 WH30.1
assigned to the shipment line. 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 WH130 WH132
Unit of Measure This field contains the multiplier for WH190 WH30.1
Multiplier converting this unit of measure to the WH30.2 WH30.3
stock unit of measure. 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 WH130 WH132
Quantity This field contains the requested WH190 WH30.1
shipment line quantity. 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 WH130 WH132
Catch Weight This field contains the catch weight WH190 WH30.1
Quantity quantity in 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
WH34.5 WH40.1
WH40.2 WH520
WH830
WHD-UPDATE-DATE Numeric 8 (yyyymmdd) WH130 WH132
Update Date This field contains the date the record WH190 WH30.1
was updated. 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 WH130 WH132
Update Time This field contains the system time WH190 WH30.1
when the record was updated. 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
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
Uom String This field contains the 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 RQ300 WH126
LOCATION updating the table. WH130 WH131
SHIPMENT-NBR WH132 WH190
LINE-NBR WH222 WH224
COMPONENT-SEQ WH30.1 WH30.2
BIN WH30.3 WH30.4
LOT WH31.1 WH31.2
SUBLOT WH31.3 WH31.4
UOM WH32.1 WH32.2
SERIAL WH32.3 WH32.4
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.7 WH33.8
WH33.9 WH34.1
...
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 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
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
|