WHSLCRTNIN – No description in the Lawson data dictionary

System
Warehouse (WH)
Prefix
WCL
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, CARTON-NBR, SHIP-LINE-NBR
Fields
17
Updated by
2 programs
Referenced by
0 programs

WHSLCRTNIN is a Lawson Warehouse table (prefix WCL); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, CARTON-NBR, SHIP-LINE-NBR (WCLSET1); alternate indexes: WCLSET2 and WCLSET3. It is related 1:1 to WHSHCRTNIN. It is updated by WH52.3 and WH520. The table has 17 fields, 3 indexes and 1 documented relation.

About WHSLCRTNIN

No description in the Lawson data dictionary.

Fields (17)

Column = COBOL field name without the WCL- 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
#WCL-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.WH52.3
#WCL-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.WH52.3
#WCL-SHIPMENT-NBR PK
SHIPMENT_NBR		Numeric 10This field contains the shipment number. One order can have several shipment numbers if the items of the order were not shipped at the same time.WH52.3
#WCL-CARTON-NBR PK
CARTON_NBR		Alpha 20—WH52.3
#WCL-SHIP-LINE-NBR PK
SHIP_LINE_NBR		Numeric 6—WH52.3
#WCL-CRTN-LINE-NBR SET3
CRTN_LINE_NBR		Numeric 6—WH52.3
#WCL-PROCESS-DATE
PROCESS_DATE		Numeric 8 (yyyymmdd)—WH52.3
#WCL-UPDATE-TIME
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.WH52.3
#WCL-PACKGE-BARCODE
PACKGE_BARCODE		Alpha 20—WH52.3
#WCL-TO-BE-PCK-UNIT
TO_BE_PCK_UNIT		Signed 9.3—WH52.3
#WCL-UNITS-PACKED
UNITS_PACKED		Signed 9.3—WH52.3
#WCL-TO-BE-PCK-BOXS
TO_BE_PCK_BOXS		Signed 9.3—WH52.3
#WCL-BOXES-PACKED
BOXES_PACKED		Signed 9.3—WH52.3
#WCL-ASSORTMENT-NBR
ASSORTMENT_NBR		Alpha 12—WH52.3
#WCL-PALLET-ID
PALLET_ID		Alpha 20—WH52.3
#WCL-INT-REF-USER3
INT_REF_USER3		Alpha 20—WH52.3
#WCL-INT-REF-USER4
INT_REF_USER4		Alpha 30—WH52.3

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
WCLSET1
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. CARTON-NBR
  5. SHIP-LINE-NBR
Primary—
WCLSET2
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. SHIP-LINE-NBR
  5. CARTON-NBR
WH52.1, WH52.3, WH520
WCLSET3
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. CARTON-NBR
  5. CRTN-LINE-NBR
—

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
WhshcrtninWHSHCRTNINRequired
WCL-COMPANY→WCN-COMPANY (WCNSET1)
WCL-LOCATION→WCN-LOCATION
WCL-SHIPMENT-NBR→WCN-SHIPMENT-NBR
WCL-CARTON-NBR→WCN-CARTON-NBR

Programs

Updated by (2)