WHSHIPLINE – Shipment Line

System
Warehouse (WH)
Prefix
WHL
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR
Fields
43
Updated by
53 programs
Referenced by
212 programs

WHSHIPLINE is the Shipment Line table in Lawson Warehouse (prefix WHL). It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR (WHLSET1); alternate indexes: WHLSET2, WHLSET3, WHLSET4, WHLSET6 and WHLSET7. It is related 1:1 to CXPREFITEM, COLINE, ICCOMPANY, ICLOCATION, ITEMLOC, ITEMMAST, REQLINE, WHSHIPMENT and 4 more and 1:M to WHSHLDTL, SOHDETAIL, ITCOMMENT, ITSERIAL, WHSHIPCOMP and WHSHLAUD. It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 45 more and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 204 more. The table has 43 fields, 6 indexes and 27 documented relations.

About WHSHIPLINE

The Shipment Line file contains shipment line records.

Fields (43)

Column = COBOL field name without the WHL- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
WHL-COMPANY PK
COMPANY
Numeric 4This field contains the company number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-SYSTEM-CD
SYSTEM_CD
Alpha 2This field indicates from 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 +25 more
WHL-DOC-NBR
DOC_NBR
Alpha 10 (Right Justified)This field contains the document number assigned to this shipment line.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-SHIPMENT-NBR PK
SHIPMENT_NBR
Numeric 10This 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 +25 more
WHL-LINE-NBR PK
LINE_NBR
Numeric 6This field contains the shipment line number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-LINE-TYPE
LINE_TYPE
Alpha 1This field contains the type of item found on this shipment line.
  • I Inventoried Item
  • N Nonstock Item
  • X Special Item
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-ITEM
ITEM
Alpha 32This field contains the item identifier.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-DESCRIPTION
DESCRIPTION
Alpha 30 (Lower Case)This field contains the description of the line item.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-LOCATION PK
LOCATION
Alpha 5This field contains a valid stock location within the company inventory.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-PRINTED-QTY
PRINTED_QTY
Signed 13.4This field contains the quantity that was printed on the pick list to be picked.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-TRAN-UOM
TRAN_UOM
Alpha 4This field indicates the unit of measure from the document.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-TRAN-UOM-MULT
TRAN_UOM_MULT
Signed 13.7This field is the conversion factor to convert to stock unit of measure.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-IN-PROCESS-QTY
IN_PROCESS_QTY
Signed 13.4This field contains the in-process quantity, which is the shipment line quantity currently in process.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-SHIPPED-QTY
SHIPPED_QTY
Signed 13.4This field contains the quantity that was shipped in stock unit of measure. For catch weight items, the shipped quantity is in secondary unit of measure.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-DELIVERED-QTY
DELIVERED_QTY
Signed 13.4This is the quantity that has been issued or transferred to the requesting location. This quantity is updated by PO221 (Delivery Ticket).
WHL-CATCH-WT-QTY
CATCH_WT_QTY
Signed 13.4This field contains the catch weight quantity in stock unit of measure.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +26 more
WHL-PRE-ASMBLD-KIT
PRE_ASMBLD_KIT
Signed 13.4This field contains the make-to-order kit quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHL-KIT-COMP-QTY
KIT_COMP_QTY
Signed 13.4This field contains the desired quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHL-DETAIL-QTY
DETAIL_QTY
Signed 13.4This field shows the total quantity of details assigned to the shipment line.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +26 more
WHL-DTL-CTW-QTY
DTL_CTW_QTY
Signed 13.4This field contains the catch weight quantity for shipment lines with details.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +26 more
WHL-DETAIL-REQ
DETAIL_REQ
Alpha 1This field indicates whether or not details are required for shipment lines.
  • Y Yes
  • N No
  • I Interfaced
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-WALK-THRU-REQ
WALK_THRU_REQ
Alpha 1This field indicates that a shipment line is out of balance.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +27 more
WHL-UNIT-COST
UNIT_COST
Signed 18.5This field contains the unit cost of the shipment line.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-WEIGHT
WEIGHT
Signed 9.3This field contains the shipment line's calculated weight based on the item master stock weight and the line's quantity in stock unit of measure.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-CUBIC-FEET
CUBIC_FEET
Signed 9.3This field contains the shipment line's calculated cubic measurement based on the item master stock cubic and the shipment line's quantity in stock unit of measure.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-MSDS-REQ-FL
MSDS_REQ_FL
Alpha 1This field indicates if a Material Safety Data Sheet is required for the item of this shipment line. This flag is originally set at item master.
  • Y Yes
  • N No
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-MSDS-DT
MSDS_DT
Numeric 8 (yyyymmdd)This field contains the date that a Material Safety Data Sheet is being sent to a customer ship to for this shipment line.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-MSDS-DOCUMENT
MSDS_DOCUMENT
Alpha 30The document number that references the Material Safety Data Sheet that is being sent for this shipment line.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-MSDS-VERSION
MSDS_VERSION
Alpha 4The version number of the MSDS document that is being sent with this shipment line.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-OPR-CODE
OPR_CODE
Alpha 10 (Lower Case)This field contains the operator code or user ID of the person who last updated this record.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-UPDATE-DATE
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 +25 more
WHL-UPDATE-TIME
UPDATE_TIME
Numeric 6This field contains the system time when the record was updated.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-FULL-VOID-FL
FULL_VOID_FL
Alpha 1Indicates that shipment line has been voided. No quantities will be shipped from this line.
  • Y Voided
  • N Not Voided
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHL-REQ-COMPANY
REQ_COMPANY
Numeric 4This field contains the requesting company.
WHL-OPEN-QUANTITY
OPEN_QUANTITY
DerivedThis field contains the total of the in-process quantity and the backorder quantity.
WHL-PARTIAL
PARTIAL
DerivedThis field is used to help determine if a shipment is partial or not.
WHL-PARTIAL-VALUE
PARTIAL_VALUE
DerivedThis field indicates whether or not a shipment is partial.
WHL-SUPLMNTARY-UOM
SUPLMNTARY_UOM
Alpha 4This field contains the valid stock unit of measure for this item.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHL-SUPLMNTARY-QTY
SUPLMNTARY_QTY
Signed 13.4This field contains the desired quantity.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHL-ICN-CODE
ICN_CODE
Alpha 8WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHL-RQSRC-MACHINE
RQSRC_MACHINE
Alpha 6WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHL-PAR-ORDER-ID
PAR_ORDER_ID
Alpha 20WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
WHL-GLBL-LINE-TYPE
GLBL_LINE_TYPE
Alpha 15WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more

Indexes (6)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WHLSET1COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBRPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
WHLSET2COMPANY, SYSTEM-CD, DOC-NBR, LINE-NBR, SHIPMENT-NBRPOIF.1, POIG.1, RQ10.1, RQ10.4, RQ140, RQ270, RQ35.1, RQ44.1 +22 more (list truncated in source)
WHLSET3COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, ITEMSubsetWhere (WALK-THRU-REQ = "Y")WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +22 more
WHLSET4COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBRSubsetWhere DETAIL-REQ = "N"
WHLSET6COMPANY, LOCATION, LINE-NBR, SHIPMENT-NBRWH30.1, WH30.2, WH31.1, WH31.2, WH32.1, WH32.2, WH33.1, WH33.2 +7 more
WHLSET7COMPANY, LOCATION, ITEM, SHIPMENT-NBR, LINE-NBRIC216, WH82.1

Relations

One to one (12) — lookups and parents

RelationTableRulesConditionField map
CaselineCXPREFITEMRequiredWhen WHL-SYSTEM-CD = "CX"WHL-COMPANYCPI-COMPANY, WHS-REQ-LOCATIONCPI-REQ-LOCATION, WHL-DOC-NBRCPI-CASE, WHL-LINE-NBRCPI-IF-REF-NBR
ColineCOLINERequiredWhen WHS-SYSTEM-CD = "OE"WHL-COMPANYCOL-COMPANY, WDH-DOC-NBR-NUMCOL-ORDER-NBR, WHL-LINE-NBRCOL-LINE-NBR
IccompanyICCOMPANYRequiredWHL-COMPANYICC-COMPANY
IclocationICLOCATIONRequiredWHL-COMPANYICL-COMPANY, WHL-LOCATIONICL-LOCATION
ItemlocITEMLOCRequiredWhen WHL-LINE-TYPE = "I"WHL-COMPANYITL-COMPANY, WHL-LOCATIONITL-LOCATION, WHL-ITEMITL-ITEM
ItemmastITEMMASTRequiredWhen WHL-LINE-TYPE = "I" Or WHL-LINE-TYPE = "N"ICC-ITEM-GROUPITE-ITEM-GROUP, WHL-ITEMITE-ITEM
ReqlineREQLINERequiredWhen -SYSTEM-CD = "R"WDM-REQ-COMPANYRLN-COMPANY, WDM-DOC-NBR-NUMRLN-REQ-NUMBER, WHL-LINE-NBRRLN-LINE-NBR
ShipmentWHSHIPMENTRequiredWHL-COMPANYWHS-COMPANY, WHL-LOCATIONWHS-LOCATION, WHL-SHIPMENT-NBRWHS-SHIPMENT-NBR
WhdemandWHDEMANDRequiredWHL-COMPANYWDM-COMPANY, WHL-SYSTEM-CDWDM-SYSTEM-CD, WHL-DOC-NBRWDM-DOC-NBR, WHL-LINE-NBRWDM-LINE-NBR, ZeroesWDM-COMPONENT-SEQ, WHL-LOCATIONWDM-LOCATION
WhdemndhdrWHDEMNDHDRRequiredWHL-COMPANYWDH-COMPANY, WHL-SYSTEM-CDWDH-SYSTEM-CD, WHL-DOC-NBRWDH-DOC-NBR
WhwebtrackWHWEBTRACKNot RequiredWHL-COMPANYWST-COMPANY, WHL-LOCATIONWST-LOCATION, WHL-SHIPMENT-NBRWST-SHIPMENT-NBR, WHL-LINE-NBRWST-LINE-NBR
WhwhlufWHWHLUFNot RequiredWHL-COMPANYWLU-COMPANY, WHL-LOCATIONWLU-LOCATION, WHL-SHIPMENT-NBRWLU-SHIPMENT-NBR, WHL-LINE-NBRWLU-LINE-NBR

One to many (15) — child tables

RelationTableRulesConditionField map
Atch Ser RecptWHSHLDTLValid When ITE-SER-TRACK-FL = "R"WHL-COMPANYWHD-COMPANY, WHL-LOCATIONWHD-LOCATION, WHL-SHIPMENT-NBRWHD-SHIPMENT-NBR, WHL-LINE-NBRWHD-LINE-NBR, ZeroesWHD-COMPONENT-SEQ, WHD-BIN, WHD-LOT, WHD-SUBLOT, WHD-UOM, WHD-SERIAL
Attached BinsWHSHLDTLValid When ITE-LOT-TRACK-FL = "N" And ITL-BIN-TRACK-FL = "Y" And ITE-SER-TRACK-FL = "N"WHL-COMPANYWHD-COMPANY, WHL-LOCATIONWHD-LOCATION, WHL-SHIPMENT-NBRWHD-SHIPMENT-NBR, WHL-LINE-NBRWHD-LINE-NBR, ZeroesWHD-COMPONENT-SEQ, WHD-BIN, WHD-LOT, WHD-SUBLOT, WHD-UOM, WHD-SERIAL
Attached LotsWHSHLDTLValid When ITE-LOT-TRACK-FL = "Y"WHL-COMPANYWHD-COMPANY, WHL-LOCATIONWHD-LOCATION, WHL-SHIPMENT-NBRWHD-SHIPMENT-NBR, WHL-LINE-NBRWHD-LINE-NBR, ZeroesWHD-COMPONENT-SEQ, WHD-BIN, WHD-LOT, WHD-SUBLOT, WHD-UOM, WHD-SERIAL
Attached SersWHSHLDTLValid When ITE-SER-TRACK-FL = "I"WHL-COMPANYWHD-COMPANY, WHL-LOCATIONWHD-LOCATION, WHL-SHIPMENT-NBRWHD-SHIPMENT-NBR, WHL-LINE-NBRWHD-LINE-NBR, ZeroesWHD-COMPONENT-SEQ, WHD-BIN, WHD-LOT, WHD-SUBLOT, WHD-UOM, WHD-SERIAL
Attached UomsWHSHLDTLValid When SDT- = WHL- And ITE-LOT-TRACK-FL = "N" And ITE-SER-TRACK-FL = "N" And ITL-BIN-TRACK-FL = "N"WHL-COMPANYWHD-COMPANY, WHL-LOCATIONWHD-LOCATION, WHL-SHIPMENT-NBRWHD-SHIPMENT-NBR, WHL-LINE-NBRWHD-LINE-NBR, ZeroesWHD-COMPONENT-SEQ, WHD-BIN, WHD-LOT, WHD-SUBLOT, WHD-UOM, WHD-SERIAL
BinsSOHDETAILValid When ITE-LOT-TRACK-FL = "N" And ITL-BIN-TRACK-FL = "Y" And ITE-SER-TRACK-FL = "N"WHL-COMPANYSDT-COMPANY, WHL-LOCATIONSDT-LOCATION, WHL-ITEMSDT-ITEM, SDT-UOM, SDT-LOT, SDT-SUBLOT, SDT-BIN
ItcommentITCOMMENTICC-ITEM-GROUPICO-ITEM-GROUP, WHL-ITEMICO-ITEM, ICO-LANGUAGE-CODE, ICO-SEQ
ItserialITSERIALValid When ITE-SER-TRACK-FL = "R"WHL-COMPANYSER-COMPANY, WHL-ITEMSER-ITEM, SER-SERIAL
ItserialsITSERIALValid When ITE-SER-TRACK-FL = "I"WHL-COMPANYSER-COMPANY, WHL-ITEMSER-ITEM, SER-SERIAL
LotsSOHDETAILValid When ITE-LOT-TRACK-FL = "Y"WHL-COMPANYSDT-COMPANY, WHL-LOCATIONSDT-LOCATION, WHL-ITEMSDT-ITEM, SDT-UOM, SDT-LOT, SDT-SUBLOT, SDT-BIN
ShiplnedtlWHSHLDTLWHL-COMPANYWHD-COMPANY, WHL-LOCATIONWHD-LOCATION, WHL-SHIPMENT-NBRWHD-SHIPMENT-NBR, WHL-LINE-NBRWHD-LINE-NBR, WHD-COMPONENT-SEQ, WHD-BIN, WHD-LOT, WHD-SUBLOT, WHD-UOM, WHD-SERIAL
SohdetailSOHDETAILWHL-COMPANYSDT-COMPANY, WHL-LOCATIONSDT-LOCATION, WHL-ITEMSDT-ITEM, SDT-UOM, SDT-LOT, SDT-SUBLOT, SDT-BIN
UomsSOHDETAILValid When SDT- = WHL- And ITE-LOT-TRACK-FL = "N" And ITE-SER-TRACK-FL = "N" And ITL-BIN-TRACK-FL = "N"WHL-COMPANYSDT-COMPANY, WHL-LOCATIONSDT-LOCATION, WHL-ITEMSDT-ITEM, SDT-UOM, SDT-LOT, SDT-SUBLOT, SDT-BIN
WhshipcompWHSHIPCOMPWHL-COMPANYWHC-COMPANY, WHL-LOCATIONWHC-LOCATION, WHL-SHIPMENT-NBRWHC-SHIPMENT-NBR, WHL-LINE-NBRWHC-LINE-NBR, WHC-COMPONENT-SEQ
WhshlaudWHSHLAUDWHL-COMPANYWHA-COMPANY, WHL-LOCATIONWHA-LOCATION, WHL-SHIPMENT-NBRWHA-SHIPMENT-NBR, WHL-LINE-NBRWHA-LINE-NBR, WHA-STATUS

Programs

Updated by (53)

Referenced by (212)