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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
WHCSET1COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQPrimaryCX100, CX20.1, CX20.2, CX20.4, CX20.5, CX220, CX30.1, CX300 +22 more (list truncated in source)
WHCSET2COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR, COMPONENT-SEQ, ITEMSubsetWhere (DETAIL-REQ = "Y")WH130, WH190, WH30.1, WH30.2, WH31.1, WH31.2, WH32.1, WH32.2 +8 more
WHCSET3COMPANY, LOCATION, SHIPMENT-NBR, COMPONENT-SEQ, LINE-NBRWH33.7, WH34.1, WH34.2, WH34.3, WH34.4

Relations

One to one (7) — lookups and parents

RelationTableRulesConditionField map
IccompanyICCOMPANYRequiredWHC-COMPANY → ICC-COMPANY
IclocationICLOCATIONRequiredWHC-COMPANY → ICL-COMPANY, WHC-LOCATION → ICL-LOCATION
ItemlocITEMLOCRequiredWHC-COMPANY → ITL-COMPANY, WHC-LOCATION → ITL-LOCATION, WHC-ITEM → ITL-ITEM
ItemmastITEMMASTRequiredICC-ITEM-GROUP → ITE-ITEM-GROUP, WHC-ITEM → ITE-ITEM
ShiplineWHSHIPLINERequiredWHC-COMPANY → WHL-COMPANY, WHC-LOCATION → WHL-LOCATION, WHC-SHIPMENT-NBR → WHL-SHIPMENT-NBR, WHC-LINE-NBR → WHL-LINE-NBR
ShipmentWHSHIPMENTRequiredWHC-COMPANY → WHS-COMPANY, WHC-LOCATION → WHS-LOCATION, WHC-SHIPMENT-NBR → WHS-SHIPMENT-NBR
WhdemndhdrWHDEMNDHDRRequiredWHC-COMPANY → WDH-COMPANY, WHC-SYSTEM-CD → WDH-SYSTEM-CD, WHC-DOC-NBR → WDH-DOC-NBR

One to many (1) — child tables

RelationTableRulesConditionField map
ShiplnedtlWHSHLDTLWHC-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)