WHSHIPCOMP – Shipment Line Kit Component

System
Warehouse (WH)
Prefix
WHC
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ
Fields
13
Updated by
45 programs
Referenced by
1 program

WHSHIPCOMP is the Shipment Line Kit Component table in Lawson Warehouse (prefix WHC). It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ (WHCSET1); alternate indexes: WHCSET2 and WHCSET3. It is related 1:1 to ICCOMPANY, ICLOCATION, ITEMLOC, ITEMMAST, WHSHIPLINE, WHSHIPMENT and WHDEMNDHDR and 1:M to WHSHLDTL. It is updated by CX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 and 37 more and referenced by WHD3.1. The table has 13 fields, 3 indexes and 8 documented relations.

About WHSHIPCOMP

The Shipment Line Kit Component file contains shipment line records for component items.

Fields (13)

Column = COBOL field name without the WHC- 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
#WHC-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
#WHC-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 +24 more
#WHC-DOC-NBR
DOC_NBR		Alpha 10 (Right Justified)This field contains the document number associated with the shipment line.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
#WHC-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
#WHC-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
#WHC-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
#WHC-COMPONENT-SEQ PK
COMPONENT_SEQ		Numeric 3This field contains the component sequence number of the component item.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
#WHC-ITEM SET2
ITEM		Alpha 32This field contains the item identifier.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
#WHC-QUANTITY
QUANTITY		Signed 13.4This field contains the requested quantity of the item.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WHC-DETAIL-QTY
DETAIL_QTY		Signed 13.4This field shows the total quantity of all details assigned to component items.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +25 more
#WHC-DETAIL-REQ
DETAIL_REQ		Alpha 1This field indicates whether component items require details to be assigned.
  • Y Yes
  • N No
WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WHC-UNIT-COST
UNIT_COST		Signed 18.5This field contains the unit cost of the component item.WH130, WH132, WH190, WH30.1, WH30.2, WH30.3, WH30.4, WH31.1 +24 more
#WHC-GLBL-LINE-TYPE
GLBL_LINE_TYPE		Alpha 15——

Indexes (3)

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
WHCSET1
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. LINE-NBR
  5. COMPONENT-SEQ
PrimaryCX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source)
WHCSET2
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. LINE-NBR
  5. COMPONENT-SEQ
  6. ITEM
SubsetWhere (DETAIL-REQ = "Y")WH130, WH190, WH30.1, WH30.2, WH31.1, WH31.2, WH32.1, WH32.2 +8 more
WHCSET3
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. COMPONENT-SEQ
  5. LINE-NBR
WH33.7, WH34.1, WH34.2, WH34.3, WH34.4

Relations

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

One to one (7) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequired
WHC-COMPANY→ICC-COMPANY
IclocationICLOCATIONRequired
WHC-COMPANY→ICL-COMPANY
WHC-LOCATION→ICL-LOCATION
ItemlocITEMLOCRequired
WHC-COMPANY→ITL-COMPANY
WHC-LOCATION→ITL-LOCATION
WHC-ITEM→ITL-ITEM
ItemmastITEMMASTRequired
ICC-ITEM-GROUP→ITE-ITEM-GROUP
WHC-ITEM→ITE-ITEM
ShiplineWHSHIPLINERequired
WHC-COMPANY→WHL-COMPANY
WHC-LOCATION→WHL-LOCATION
WHC-SHIPMENT-NBR→WHL-SHIPMENT-NBR
WHC-LINE-NBR→WHL-LINE-NBR
ShipmentWHSHIPMENTRequired
WHC-COMPANY→WHS-COMPANY
WHC-LOCATION→WHS-LOCATION
WHC-SHIPMENT-NBR→WHS-SHIPMENT-NBR
WhdemndhdrWHDEMNDHDRRequired
WHC-COMPANY→WDH-COMPANY
WHC-SYSTEM-CD→WDH-SYSTEM-CD
WHC-DOC-NBR→WDH-DOC-NBR

One to many (1) — child tables

RelationTableRulesConditionField map
ShiplnedtlWHSHLDTL
WHC-COMPANY→WHD-COMPANY
WHC-LOCATION→WHD-LOCATION
WHC-SHIPMENT-NBR→WHD-SHIPMENT-NBR
WHC-LINE-NBR→WHD-LINE-NBR
WHC-COMPONENT-SEQ→WHD-COMPONENT-SEQ
—→WHD-BIN
—→WHD-LOT
—→WHD-SUBLOT
—→WHD-UOM
—→WHD-SERIAL

Programs

Updated by (45)

Referenced by (1)