WHSHIPMENT – Shipment

System
Warehouse (WH)
Prefix
WHS
Primary key
COMPANY, LOCATION, SHIPMENT-NBR
Fields
64
Updated by
47 programs
Referenced by
221 programs

WHSHIPMENT is the Shipment table in Lawson Warehouse (prefix WHS). It is indexed by COMPANY, LOCATION, SHIPMENT-NBR (WHSSET1); alternate indexes: WHSSET10, WHSSET11, WHSSET2, WHSSET3, WHSSET4, WHSSET5, WHSSET6, WHSSET7 and 2 more. It is related 1:1 to APCOMPANY, APVENMAST, CXCASEHEAD, CUSTORDER, ICCOMPANY, ICLOCATION, OEMETHOD, REQHEADER and 4 more and 1:M to WHSHIPLINE, WHSHLDTL and WHSHTRK. It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 39 more and referenced by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 213 more. The table has 64 fields, 11 indexes and 16 documented relations.

About WHSHIPMENT

The Shipment file carries a record for every shipment created for every document.

Fields (64)

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

Field / columnTypeDescription & valuesUpdated by
WHS-COMPANY PK
COMPANY
Numeric 4This field contains the company number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-SYSTEM-CD
SYSTEM_CD
Alpha 2This field indicates on 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 +17 more
WHS-DOC-NBR
DOC_NBR
Alpha 10 (Right Justified)This field contains the document number within the shipment.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-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 +17 more
WHS-DOC-TYPE
DOC_TYPE
Alpha 2This field contains the type of document. For warehouse purposes, this is the shipping document.
  • SH Shipment
WHS-CUST-SHIP-TO
CUST_SHIP_TO
Numeric 4This field contains the ship-to customer number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-REQ-LOCATION
REQ_LOCATION
Alpha 5This field contains the requesting location. This location can be an inventory or nonstock location.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-DESTINATION
DESTINATION
Alpha 15This field represents the destination to which shipments are being sent.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-PROCESS-LEVEL
PROCESS_LEVEL
Alpha 5This field contains the process level assigned to the document.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-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 +17 more
WHS-BATCH-NBR
BATCH_NBR
Numeric 6This identifies the batch number assigned to the shipment when you ran Pick List Print (WH130).WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-STATUS
STATUS
Numeric 1This field contains the status of the shipment.
  • 0 Printed
  • 1 Picked
  • 2 Packed
  • 3 Shipped
  • 4 Released
  • 5 Closed
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +18 more
WHS-OPR-CODE
OPR_CODE
Alpha 10 (Lower Case)This field contains the operator code or the user ID of the person who last updated this record.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-PICKING-REQ
PICKING_REQ
Alpha 1This field indicates whether or not picking feedback is required based on the process type.
  • Y Yes
  • N No
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-PACKING-REQ
PACKING_REQ
Alpha 1This field indicates whether or not packing feedback is required based on the process type.
  • Y Yes
  • N No
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-PRINT-DATE
PRINT_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-PICK-DATE
PICK_DATE
Numeric 8 (yyyymmdd)This field contains the date that picking feedback was performed. The system date defaults.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-PACK-DATE
PACK_DATE
Numeric 8 (yyyymmdd)This field contains the pack date. The system date defaults but can be overridden if you are using the WH20 form series.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-SHIP-DATE
SHIP_DATE
Numeric 8 (yyyymmdd)This field displays the system date when this was created.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-GL-DATE
GL_DATE
Numeric 8 (yyyymmdd)This field contains the general ledger posting date.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-EST-DEL-DATE
EST_DEL_DATE
Numeric 8 (yyyymmdd)This field contains the expected ship date. If you leave the field blank and no ship days are defined on the document's process level, the document date defaults. If ship days exist on the process level, ship days are added to the document date to calculate the expected ship date.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-VENDOR
VENDOR
Alpha 9 (Right Justified)The vendor's identification code.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-PO-FLAG
PO_FLAG
Alpha 1This field indicates whether or not shipment lines that create purchase orders are based on purchase order receipt.
  • Y Based on PO Receipt
  • N Not Related to PO
WHS-ROUTE
ROUTE
Numeric 4This field contains the route number. The route assigned to the ship-to customer defaults from the Route file.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-STOP
STOP
Numeric 4This field contains the stop within the route. If left blank, the stop associated with the ship-to customer defaults from the Route file.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-BOL-NBR
BOL_NBR
Alpha 22This field contains the Bill of Lading number for the shipment.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-CARRIER
CARRIER
Alpha 9 (Right Justified)This field contains the carrier number. The carrier must be valid in Accounts Payable.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-METHOD
METHOD
Alpha 10This field contains the shipping method that you defined using Shipping Method (WH11.1).WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-TRANS-ID
TRANS_ID
Alpha 20This field contains the transportation identification, which prints on the invoice and Bill of Lading.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-FREIGHT-CODE
FREIGHT_CODE
Alpha 2This field contains the freight code. This must be valid in the Order Entry Freight Code file. This determines whether carrier and charge are allowed for the shipment.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-FREIGHT-REQ
FREIGHT_REQ
Alpha 1This field indicates whether or not freight charges are required on this shipment. Freight codes are defined in the Lawson Billing system.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-FRT-CHG-CURR
FRT_CHG_CURR
Signed 18.2This field contains the freight charge amount in billing currency.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +18 more
WHS-CARTONS
CARTONS
Numeric 6This field contains the total number of cartons in the shipment.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-CUBIC-FEET
CUBIC_FEET
Signed 9.3This field contains the total of all the shipment line's calculated cubic measurements based on the item master stock cubic values.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHS-CUBIC-ADJ
CUBIC_ADJ
Signed 9.3This field contains a shipment level adjustment to the total of all the shipment line's calculated cubic measurements.
WHS-CUBIC-TOTAL
CUBIC_TOTAL
Signed 9.3This field contains the shipment's total cubic measurement which is the sum of the shipment line's calculated totals and the shipment level adjustment.
WHS-WEIGHT
WEIGHT
Signed 9.3This field contains the total of all the shipment line's calculated weight based on the item master stock weight values.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
WHS-WEIGHT-ADJ
WEIGHT_ADJ
Signed 9.3This field contains a shipment level adjustment to the total of all the shipment line's calculated weight.
WHS-WEIGHT-TOTAL
WEIGHT_TOTAL
Signed 9.3This field contains the shipment's total weight which is the sum of the shipment line's calculated totals and the shipment level adjustment.
WHS-PACK-LIST-FL
PACK_LIST_FL
Alpha 1
  • Y Yes
  • N No
WH130, WH132, WH190, WH224, WH30.1, WH30.2, WH30.3, WH30.4 +18 more
WHS-POD-PRT-FL
POD_PRT_FL
Alpha 1This field represents the Proof of Delivery (POD) Print flag. WH126 (POD Print) sets this flag to Yes after printing a POD.
  • Y Yes
  • N No
WH126, WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4 +18 more
WHS-POD-RETRN-DT
POD_RETRN_DT
Numeric 8 (yyyymmdd)This field contains the date the Proof of Delivery (POD) form is returned with an acknowledgment.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-INVC-PREFIX
INVC_PREFIX
Alpha 2This field contains the invoice prefix that is assigned from either the billing company or process level, depending on the invoice-level option chosen.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-INVC-NUMBER
INVC_NUMBER
Numeric 8This field contains the invoice number assigned by the system.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-REQ-COMPANY
REQ_COMPANY
Numeric 4This field contains the requesting company.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-DOC-NBR-NUM
DOC_NBR_NUM
Numeric 10This field contains the numeric version of the document number.
WHS-ORIGIN
ORIGIN
DerivedThis literal helps to indicate in which Lawson system the document originated.
WHS-DAYS-LATE
DAYS_LATE
DerivedThis field contains the number of days after the requested date that you sent a shipment.
WHS-DAYS-LATE-COND
DAYS_LATE_COND
DerivedThis flag helps to indicate whether or not a shipment was late.
WHS-DAYS-LATE-CTR
DAYS_LATE_CTR
DerivedThis flag will be either zero or one, indicating if the shipment was late or not.
WHS-LAST-DATE
LAST_DATE
DerivedThis field contains the last activity date for the shipment. In other words, when the last activity such as picking or packing feedback was performed.
WHS-RDY-TO-STATUS
RDY_TO_STATUS
DerivedThis field indicates the shipment status the shipment is about to go to, based on the process type.
WHS-RDY-TO-LITERAL
RDY_TO_LITERAL
DerivedThis literal is used to help display the status a shipment is about to go to.
WHS-INTRASTAT-NBR
INTRASTAT_NBR
Numeric 12The number assigned by the Intrastat system to a transaction that involves Intrastat reporting after it has been added.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-FOB-CODE
FOB_CODE
Alpha 3The user defined Free On Board Code.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-PORT-CD
PORT_CD
Alpha 5The Intrastat port code. Must be define in IN04.1 (Port Maintenance)WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-NOTC
NOTC
Alpha 2The Nature of Transaction code. Must be a valid code defined in IN07.1 (NOTC Maintenance).WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-STAT-PROC
STAT_PROC
Alpha 6The statistical procedure code applied to the data. The code must be defined in IN06.1. (Statistical Procedure Maintenance).WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-VAT-REG-NBR
VAT_REG_NBR
Alpha 12The number component of the VAT Registration Number. This field together with the Registration Country field make up the VAT Registration Number.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-EXT-ACCT-ENT
EXT_ACCT_ENT
Alpha 22 (Lower Case)WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-EXT-LOCATION
EXT_LOCATION
Alpha 22 (Lower Case)WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-EXT-SHIP-NBR
EXT_SHIP_NBR
Alpha 100 (Lower Case)WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-GLBL-DOC-TYPE
GLBL_DOC_TYPE
Alpha 10WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more
WHS-TEMP-HOLD
TEMP_HOLD
Alpha 1
  • S Sent for Approval
  • A Approved by Engine
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +17 more

Indexes (11)

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

IndexKeysFlagsConditionUsed in
WHSSET1COMPANY, LOCATION, SHIPMENT-NBRPrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
WHSSET10COMPANY, LOCATION, SHIPMENT-NBR*SubsetWhere STATUS < 4WH82.1
WHSSET11COMPANY, LOCATION, SHIPMENT-NBR*
WHSSET2COMPANY, LOCATION, BOL-NBR, SHIPMENT-NBRKeyChange, SubsetWhere (BOL-NBR != Spaces)WH140, WH40.2
WHSSET3COMPANY, LOCATION, CARRIER, BOL-NBR, SHIPMENT-NBRKeyChangeWH40.1
WHSSET4COMPANY, LOCATION, BATCH-NBR, SHIPMENT-NBRSubsetWhere (STATUS = 3)WH190
WHSSET5COMPANY, LOCATION, BATCH-NBR, SHIPMENT-NBRWH130, WH131, WH132, WH30.3, WH31.3, WH32.3, WH80.4
WHSSET6COMPANY, LOCATION, DOC-NBR, SHIPMENT-NBRSubsetWhere (SYSTEM-CD = "OE") And (STATUS = 4)
WHSSET7COMPANY, SYSTEM-CD, DOC-NBR, SHIPMENT-NBR, LOCATIONCX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source)
WHSSET8COMPANY, LOCATION, SYSTEM-CD, DOC-NBR, SHIPMENT-NBRWH130, WH30.1, WH31.1, WH32.1
WHSSET9COMPANY, SHIPMENT-NBR, LOCATIONWH130, WH132, WH190, WH224, WH30.1, WH30.2, WH30.3, WH30.4 +18 more

Relations

One to one (12) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredWhen WHS-CARRIER != SpacesWHS-COMPANYCPY-COMPANY
ApvenmastAPVENMASTRequiredWhen WHS-CARRIER != SpacesCPY-VENDOR-GROUPVEN-VENDOR-GROUP, WHS-CARRIERVEN-VENDOR
CaseheaderCXCASEHEADRequiredWhen WHS-SYSTEM-CD = "CX"WHS-COMPANYCXH-COMPANY, WHS-REQ-LOCATIONCXH-REQ-LOCATION, WHS-DOC-NBRCXH-CASE
CustorderCUSTORDERRequiredWhen WHS-SYSTEM-CD = "OE"WHS-COMPANYCOR-COMPANY, WDH-DOC-NBR-NUMCOR-ORDER-NBR
IccompanyICCOMPANYRequiredWHS-COMPANYICC-COMPANY
IclocationICLOCATIONRequiredWHS-COMPANYICL-COMPANY, WHS-LOCATIONICL-LOCATION
OemethodOEMETHODNot RequiredValid When WHS-METHOD != SpacesWHS-COMPANYOMT-COMPANY, WHS-METHODOMT-METHOD
ReqheaderREQHEADERRequiredWhen WHS-SYSTEM-CD = "RQ"WHS-REQ-COMPANYRQH-COMPANY, WDH-DOC-NBR-NUMRQH-REQ-NUMBER
ShiptoSHIPTONot RequiredWHS-COMPANYSHP-COMPANY, COR-CUSTOMERSHP-CUSTOMER, WHS-CUST-SHIP-TOSHP-SHIP-TO
WhdemndhdrWHDEMNDHDRRequiredWHS-COMPANYWDH-COMPANY, WHS-SYSTEM-CDWDH-SYSTEM-CD, WHS-DOC-NBRWDH-DOC-NBR
WhsbodWHSBODNot Required, Delete CascadesWHS-COMPANYWBA-COMPANY, WHS-LOCATIONWBA-LOCATION, WHS-SHIPMENT-NBRWBA-SHIPMENT-NBR
WhwhsufWHWHSUFNot RequiredWHS-COMPANYWSU-COMPANY, WHS-LOCATIONWSU-LOCATION, WHS-SHIPMENT-NBRWSU-SHIPMENT-NBR

One to many (4) — child tables

RelationTableRulesConditionField map
No DetailsWHSHIPLINEWHS-COMPANYWHL-COMPANY, WHS-LOCATIONWHL-LOCATION, WHS-SHIPMENT-NBRWHL-SHIPMENT-NBR, WHL-LINE-NBR
ShiplineWHSHIPLINEWHS-COMPANYWHL-COMPANY, WHS-LOCATIONWHL-LOCATION, WHS-SHIPMENT-NBRWHL-SHIPMENT-NBR, WHL-LINE-NBR
ShiplnedtlWHSHLDTLWHS-COMPANYWHD-COMPANY, WHS-LOCATIONWHD-LOCATION, WHS-SHIPMENT-NBRWHD-SHIPMENT-NBR, WHD-BIN, WHD-LOT, WHD-SUBLOT, WHD-SERIAL, WHD-UOM, WHD-LINE-NBR, WHD-COMPONENT-SEQ
WhshtrkWHSHTRKWHS-COMPANYWHT-COMPANY, WHS-LOCATIONWHT-LOCATION, WHS-SHIPMENT-NBRWHT-SHIPMENT-NBR, WHT-TRACKING-NBR

Programs

Updated by (47)

Referenced by (221)