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

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 SET7 SET8
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 SET6 SET7 SET8
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 SET4 SET5
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 SET2 SET3
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 SET3
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 10—WH130, 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 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
WHSSET1
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
WHSSET10
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR ↓
SubsetWhere STATUS < 4WH82.1
WHSSET11
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR ↓
—
WHSSET2
  1. COMPANY
  2. LOCATION
  3. BOL-NBR
  4. SHIPMENT-NBR
KeyChange, SubsetWhere (BOL-NBR != Spaces)WH140, WH40.2
WHSSET3
  1. COMPANY
  2. LOCATION
  3. CARRIER
  4. BOL-NBR
  5. SHIPMENT-NBR
KeyChangeWH40.1
WHSSET4
  1. COMPANY
  2. LOCATION
  3. BATCH-NBR
  4. SHIPMENT-NBR
SubsetWhere (STATUS = 3)WH190
WHSSET5
  1. COMPANY
  2. LOCATION
  3. BATCH-NBR
  4. SHIPMENT-NBR
WH130, WH131, WH132, WH30.3, WH31.3, WH32.3, WH80.4
WHSSET6
  1. COMPANY
  2. LOCATION
  3. DOC-NBR
  4. SHIPMENT-NBR
SubsetWhere (SYSTEM-CD = "OE") And (STATUS = 4)—
WHSSET7
  1. COMPANY
  2. SYSTEM-CD
  3. DOC-NBR
  4. SHIPMENT-NBR
  5. LOCATION
CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source)
WHSSET8
  1. COMPANY
  2. LOCATION
  3. SYSTEM-CD
  4. DOC-NBR
  5. SHIPMENT-NBR
WH130, WH30.1, WH31.1, WH32.1
WHSSET9
  1. COMPANY
  2. SHIPMENT-NBR
  3. LOCATION
WH130, WH132, WH190, WH224, WH30.1, WH30.2, WH30.3, WH30.4 +18 more

Relations

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

One to one (12) — lookups and parents

RelationTableRulesConditionField map
ApcompanyAPCOMPANYRequiredWhen WHS-CARRIER != Spaces
WHS-COMPANY→CPY-COMPANY
ApvenmastAPVENMASTRequiredWhen WHS-CARRIER != Spaces
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
WHS-CARRIER→VEN-VENDOR
CaseheaderCXCASEHEADRequiredWhen WHS-SYSTEM-CD = "CX"
WHS-COMPANY→CXH-COMPANY
WHS-REQ-LOCATION→CXH-REQ-LOCATION
WHS-DOC-NBR→CXH-CASE
CustorderCUSTORDERRequiredWhen WHS-SYSTEM-CD = "OE"
WHS-COMPANY→COR-COMPANY
WDH-DOC-NBR-NUM→COR-ORDER-NBR
IccompanyICCOMPANYRequired
WHS-COMPANY→ICC-COMPANY
IclocationICLOCATIONRequired
WHS-COMPANY→ICL-COMPANY
WHS-LOCATION→ICL-LOCATION
OemethodOEMETHODNot RequiredValid When WHS-METHOD != Spaces
WHS-COMPANY→OMT-COMPANY
WHS-METHOD→OMT-METHOD
ReqheaderREQHEADERRequiredWhen WHS-SYSTEM-CD = "RQ"
WHS-REQ-COMPANY→RQH-COMPANY
WDH-DOC-NBR-NUM→RQH-REQ-NUMBER
ShiptoSHIPTONot Required
WHS-COMPANY→SHP-COMPANY
COR-CUSTOMER→SHP-CUSTOMER
WHS-CUST-SHIP-TO→SHP-SHIP-TO
WhdemndhdrWHDEMNDHDRRequired
WHS-COMPANY→WDH-COMPANY
WHS-SYSTEM-CD→WDH-SYSTEM-CD
WHS-DOC-NBR→WDH-DOC-NBR
WhsbodWHSBODNot Required, Delete Cascades
WHS-COMPANY→WBA-COMPANY
WHS-LOCATION→WBA-LOCATION
WHS-SHIPMENT-NBR→WBA-SHIPMENT-NBR
WhwhsufWHWHSUFNot Required
WHS-COMPANY→WSU-COMPANY
WHS-LOCATION→WSU-LOCATION
WHS-SHIPMENT-NBR→WSU-SHIPMENT-NBR

One to many (4) — child tables

RelationTableRulesConditionField map
No DetailsWHSHIPLINE
WHS-COMPANY→WHL-COMPANY
WHS-LOCATION→WHL-LOCATION
WHS-SHIPMENT-NBR→WHL-SHIPMENT-NBR
—→WHL-LINE-NBR
ShiplineWHSHIPLINE
WHS-COMPANY→WHL-COMPANY
WHS-LOCATION→WHL-LOCATION
WHS-SHIPMENT-NBR→WHL-SHIPMENT-NBR
—→WHL-LINE-NBR
ShiplnedtlWHSHLDTL
WHS-COMPANY→WHD-COMPANY
WHS-LOCATION→WHD-LOCATION
WHS-SHIPMENT-NBR→WHD-SHIPMENT-NBR
—→WHD-BIN
—→WHD-LOT
—→WHD-SUBLOT
—→WHD-SERIAL
—→WHD-UOM
—→WHD-LINE-NBR
—→WHD-COMPONENT-SEQ
WhshtrkWHSHTRK
WHS-COMPANY→WHT-COMPANY
WHS-LOCATION→WHT-LOCATION
WHS-SHIPMENT-NBR→WHT-SHIPMENT-NBR
—→WHT-TRACKING-NBR

Programs

Updated by (47)

Referenced by (221)