WHSHCRTNIN – No description in the Lawson data dictionary

System
Warehouse (WH)
Prefix
WCN
Primary key
COMPANY, LOCATION, SHIPMENT-NBR, CARTON-NBR
Fields
18
Updated by
2 programs
Referenced by
0 programs

WHSHCRTNIN is a Lawson Warehouse table (prefix WCN); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, CARTON-NBR (WCNSET1). It is related 1:1 to WHSHPMNTIN and 1:M to WHSLCRTNIN. It is updated by WH52.4 and WH520. The table has 18 fields, 1 index and 3 documented relations.

About WHSHCRTNIN

No description in the Lawson data dictionary.

Fields (18)

Column = COBOL field name without the WCN- 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
#WCN-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.4
#WCN-LOCATION PK
LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.WH52.4
#WCN-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.4
#WCN-CARTON-NBR PK
CARTON_NBR		Alpha 20—WH52.4
#WCN-PROCESS-DATE
PROCESS_DATE		Numeric 8 (yyyymmdd)—WH52.4
#WCN-UPDATE-TIME
UPDATE_TIME		Numeric 6This field contains the system time when the record was updated.WH52.4
#WCN-CRTN-TRACK-NBR
CRTN_TRACK_NBR		Alpha 30—WH52.4
#WCN-CARTON-TYPE
CARTON_TYPE		Alpha 3—WH52.4
#WCN-CARTON-SIZE
CARTON_SIZE		Alpha 3—WH52.4
#WCN-CRTN-SHIP-UNIT
CRTN_SHIP_UNIT		Alpha 1—WH52.4
#WCN-CARTON-CUBIC
CARTON_CUBIC		Signed 9.3—WH52.4
#WCN-CRTN-EST-WT
CRTN_EST_WT		Signed 9.3—WH52.4
#WCN-CRTN-ACTUAL-WT
CRTN_ACTUAL_WT		Signed 9.3—WH52.4
#WCN-CRTN-TOTAL-QTY
CRTN_TOTAL_QTY		Signed 13.4—WH52.4
#WCN-FRT-CHG-CURR
FRT_CHG_CURR		Signed 18.2—WH52.4
#WCN-PACKAGE-DESC
PACKAGE_DESC		Alpha 30—WH52.4
#WCN-INT-REF-USER1
INT_REF_USER1		Alpha 20—WH52.4
#WCN-INT-REF-USER2
INT_REF_USER2		Alpha 30—WH52.4

Indexes (1)

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
WCNSET1
  1. COMPANY
  2. LOCATION
  3. SHIPMENT-NBR
  4. CARTON-NBR
PrimaryWH52.4, WH520

Relations

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

One to one (1) — lookups and parents

RelationTableRulesConditionField map
WhshpmntinWHSHPMNTINRequired
WCN-COMPANY→WSI-COMPANY
WCN-LOCATION→WSI-LOCATION
WCN-SHIPMENT-NBR→WSI-SHIPMENT-NBR

One to many (2) — child tables

RelationTableRulesConditionField map
WhslcrtninWHSLCRTNIN
WCN-COMPANY→WCL-COMPANY
WCN-LOCATION→WCL-LOCATION
WCN-SHIPMENT-NBR→WCL-SHIPMENT-NBR
WCN-CARTON-NBR→WCL-CARTON-NBR
—→WCL-SHIP-LINE-NBR
WhslcrtnlineWHSLCRTNIN
WCN-COMPANY→WCL-COMPANY
WCN-LOCATION→WCL-LOCATION
WCN-SHIPMENT-NBR→WCL-SHIPMENT-NBR
WCN-CARTON-NBR→WCL-CARTON-NBR
—→WCL-CRTN-LINE-NBR

Programs

Updated by (2)