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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET2
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 SET2
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 SET3 SET7
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 8—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WHL-RQSRC-MACHINE
RQSRC_MACHINE
Alpha 6—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WHL-PAR-ORDER-ID
PAR_ORDER_ID
Alpha 20—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WHL-GLBL-LINE-TYPE
GLBL_LINE_TYPE
Alpha 15—WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more

Indexes (6)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WHLSET1
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. LINE-NBR
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
WHLSET2
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-NBR
  4. LINE-NBR
  5. SHIPMENT-NBR
POIF.1, POIG.1, RQ10.1, RQ10.4, RQ140, RQ270, RQ35.1, RQ44.1 +22 more (list truncated in source)
WHLSET3
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. LINE-NBR
  5. ITEM
SubsetWhere (WALK-THRU-REQ = "Y")WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +22 more
WHLSET4
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. LINE-NBR
SubsetWhere DETAIL-REQ = "N"—
WHLSET6
  1. COMPANY
  2. LOCATION
  3. LINE-NBR
  4. SHIPMENT-NBR
WH30.1, WH30.2, WH31.1, WH31.2, WH32.1, WH32.2, WH33.1, WH33.2 +7 more
WHLSET7
  1. COMPANY
  2. LOCATION
  3. ITEM
  4. SHIPMENT-NBR
  5. LINE-NBR
IC216, WH82.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
CXPREFITEMCOLINEICCOMPANYICLOCATIONITEMLOCITEMMASTREQLINEWHSHIPMENTWHDEMANDWHDEMNDHDRWHWEBTRACKWHWHLUFWHSHLDTLSOHDETAILITCOMMENTITSERIALWHSHIPCOMPWHSHLAUDWHSHIPLINE

One to one (12) — lookups and parents

RelationTableRulesConditionField map
CaselineCXPREFITEMRequiredWhen WHL-SYSTEM-CD = "CX"
WHL-COMPANY→CPI-COMPANY
WHS-REQ-LOCATION→CPI-REQ-LOCATION
WHL-DOC-NBR→CPI-CASE
WHL-LINE-NBR→CPI-IF-REF-NBR
ColineCOLINERequiredWhen WHS-SYSTEM-CD = "OE"
WHL-COMPANY→COL-COMPANY
WDH-DOC-NBR-NUM→COL-ORDER-NBR
WHL-LINE-NBR→COL-LINE-NBR
IccompanyICCOMPANYRequired
WHL-COMPANY→ICC-COMPANY
IclocationICLOCATIONRequired
WHL-COMPANY→ICL-COMPANY
WHL-LOCATION→ICL-LOCATION
ItemlocITEMLOCRequiredWhen WHL-LINE-TYPE = "I"
WHL-COMPANY→ITL-COMPANY
WHL-LOCATION→ITL-LOCATION
WHL-ITEM→ITL-ITEM
ItemmastITEMMASTRequiredWhen WHL-LINE-TYPE = "I" Or WHL-LINE-TYPE = "N"
ICC-ITEM-GROUP→ITE-ITEM-GROUP
WHL-ITEM→ITE-ITEM
ReqlineREQLINERequiredWhen -SYSTEM-CD = "R"
WDM-REQ-COMPANY→RLN-COMPANY
WDM-DOC-NBR-NUM→RLN-REQ-NUMBER
WHL-LINE-NBR→RLN-LINE-NBR
ShipmentWHSHIPMENTRequired
WHL-COMPANY→WHS-COMPANY
WHL-LOCATION→WHS-LOCATION
WHL-SHIPMENT-NBR→WHS-SHIPMENT-NBR
WhdemandWHDEMANDRequired
WHL-COMPANY→WDM-COMPANY
WHL-SYSTEM-CD→WDM-SYSTEM-CD
WHL-DOC-NBR→WDM-DOC-NBR
WHL-LINE-NBR→WDM-LINE-NBR
Zeroes→WDM-COMPONENT-SEQ
WHL-LOCATION→WDM-LOCATION
WhdemndhdrWHDEMNDHDRRequired
WHL-COMPANY→WDH-COMPANY
WHL-SYSTEM-CD→WDH-SYSTEM-CD
WHL-DOC-NBR→WDH-DOC-NBR
WhwebtrackWHWEBTRACKNot Required
WHL-COMPANY→WST-COMPANY
WHL-LOCATION→WST-LOCATION
WHL-SHIPMENT-NBR→WST-SHIPMENT-NBR
WHL-LINE-NBR→WST-LINE-NBR
WhwhlufWHWHLUFNot Required
WHL-COMPANY→WLU-COMPANY
WHL-LOCATION→WLU-LOCATION
WHL-SHIPMENT-NBR→WLU-SHIPMENT-NBR
WHL-LINE-NBR→WLU-LINE-NBR

One to many (15) — child tables

RelationTableRulesConditionField map
Atch Ser RecptWHSHLDTLValid When ITE-SER-TRACK-FL = "R"
WHL-COMPANY→WHD-COMPANY
WHL-LOCATION→WHD-LOCATION
WHL-SHIPMENT-NBR→WHD-SHIPMENT-NBR
WHL-LINE-NBR→WHD-LINE-NBR
Zeroes→WHD-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-COMPANY→WHD-COMPANY
WHL-LOCATION→WHD-LOCATION
WHL-SHIPMENT-NBR→WHD-SHIPMENT-NBR
WHL-LINE-NBR→WHD-LINE-NBR
Zeroes→WHD-COMPONENT-SEQ
—→WHD-BIN
—→WHD-LOT
—→WHD-SUBLOT
—→WHD-UOM
—→WHD-SERIAL
Attached LotsWHSHLDTLValid When ITE-LOT-TRACK-FL = "Y"
WHL-COMPANY→WHD-COMPANY
WHL-LOCATION→WHD-LOCATION
WHL-SHIPMENT-NBR→WHD-SHIPMENT-NBR
WHL-LINE-NBR→WHD-LINE-NBR
Zeroes→WHD-COMPONENT-SEQ
—→WHD-BIN
—→WHD-LOT
—→WHD-SUBLOT
—→WHD-UOM
—→WHD-SERIAL
Attached SersWHSHLDTLValid When ITE-SER-TRACK-FL = "I"
WHL-COMPANY→WHD-COMPANY
WHL-LOCATION→WHD-LOCATION
WHL-SHIPMENT-NBR→WHD-SHIPMENT-NBR
WHL-LINE-NBR→WHD-LINE-NBR
Zeroes→WHD-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-COMPANY→WHD-COMPANY
WHL-LOCATION→WHD-LOCATION
WHL-SHIPMENT-NBR→WHD-SHIPMENT-NBR
WHL-LINE-NBR→WHD-LINE-NBR
Zeroes→WHD-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-COMPANY→SDT-COMPANY
WHL-LOCATION→SDT-LOCATION
WHL-ITEM→SDT-ITEM
—→SDT-UOM
—→SDT-LOT
—→SDT-SUBLOT
—→SDT-BIN
ItcommentITCOMMENT
ICC-ITEM-GROUP→ICO-ITEM-GROUP
WHL-ITEM→ICO-ITEM
—→ICO-LANGUAGE-CODE
—→ICO-SEQ
ItserialITSERIALValid When ITE-SER-TRACK-FL = "R"
WHL-COMPANY→SER-COMPANY
WHL-ITEM→SER-ITEM
—→SER-SERIAL
ItserialsITSERIALValid When ITE-SER-TRACK-FL = "I"
WHL-COMPANY→SER-COMPANY
WHL-ITEM→SER-ITEM
—→SER-SERIAL
LotsSOHDETAILValid When ITE-LOT-TRACK-FL = "Y"
WHL-COMPANY→SDT-COMPANY
WHL-LOCATION→SDT-LOCATION
WHL-ITEM→SDT-ITEM
—→SDT-UOM
—→SDT-LOT
—→SDT-SUBLOT
—→SDT-BIN
ShiplnedtlWHSHLDTL
WHL-COMPANY→WHD-COMPANY
WHL-LOCATION→WHD-LOCATION
WHL-SHIPMENT-NBR→WHD-SHIPMENT-NBR
WHL-LINE-NBR→WHD-LINE-NBR
—→WHD-COMPONENT-SEQ
—→WHD-BIN
—→WHD-LOT
—→WHD-SUBLOT
—→WHD-UOM
—→WHD-SERIAL
SohdetailSOHDETAIL
WHL-COMPANY→SDT-COMPANY
WHL-LOCATION→SDT-LOCATION
WHL-ITEM→SDT-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-COMPANY→SDT-COMPANY
WHL-LOCATION→SDT-LOCATION
WHL-ITEM→SDT-ITEM
—→SDT-UOM
—→SDT-LOT
—→SDT-SUBLOT
—→SDT-BIN
WhshipcompWHSHIPCOMP
WHL-COMPANY→WHC-COMPANY
WHL-LOCATION→WHC-LOCATION
WHL-SHIPMENT-NBR→WHC-SHIPMENT-NBR
WHL-LINE-NBR→WHC-LINE-NBR
—→WHC-COMPONENT-SEQ
WhshlaudWHSHLAUD
WHL-COMPANY→WHA-COMPANY
WHL-LOCATION→WHA-LOCATION
WHL-SHIPMENT-NBR→WHA-SHIPMENT-NBR
WHL-LINE-NBR→WHA-LINE-NBR
—→WHA-STATUS

Programs

Updated by (53)

Referenced by (212)