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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
WCN-COMPANY PKCOMPANY | Numeric 4 | Identifies 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 PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | WH52.4 |
WCN-SHIPMENT-NBR PKSHIPMENT_NBR | Numeric 10 | This 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 PKCARTON_NBR | Alpha 20 | — | WH52.4 |
WCN-PROCESS-DATEPROCESS_DATE | Numeric 8 (yyyymmdd) | — | WH52.4 |
WCN-UPDATE-TIMEUPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | WH52.4 |
WCN-CRTN-TRACK-NBRCRTN_TRACK_NBR | Alpha 30 | — | WH52.4 |
WCN-CARTON-TYPECARTON_TYPE | Alpha 3 | — | WH52.4 |
WCN-CARTON-SIZECARTON_SIZE | Alpha 3 | — | WH52.4 |
WCN-CRTN-SHIP-UNITCRTN_SHIP_UNIT | Alpha 1 | — | WH52.4 |
WCN-CARTON-CUBICCARTON_CUBIC | Signed 9.3 | — | WH52.4 |
WCN-CRTN-EST-WTCRTN_EST_WT | Signed 9.3 | — | WH52.4 |
WCN-CRTN-ACTUAL-WTCRTN_ACTUAL_WT | Signed 9.3 | — | WH52.4 |
WCN-CRTN-TOTAL-QTYCRTN_TOTAL_QTY | Signed 13.4 | — | WH52.4 |
WCN-FRT-CHG-CURRFRT_CHG_CURR | Signed 18.2 | — | WH52.4 |
WCN-PACKAGE-DESCPACKAGE_DESC | Alpha 30 | — | WH52.4 |
WCN-INT-REF-USER1INT_REF_USER1 | Alpha 20 | — | WH52.4 |
WCN-INT-REF-USER2INT_REF_USER2 | Alpha 30 | — | WH52.4 |
Indexes (1)
Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
WCNSET1 | COMPANY, LOCATION, SHIPMENT-NBR, CARTON-NBR | Primary | WH52.4, WH520 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Whshpmntin | WHSHPMNTIN | Required | WCN-COMPANY → WSI-COMPANY, WCN-LOCATION → WSI-LOCATION, WCN-SHIPMENT-NBR → WSI-SHIPMENT-NBR |
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Whslcrtnin | WHSLCRTNIN | WCN-COMPANY → WCL-COMPANY, WCN-LOCATION → WCL-LOCATION, WCN-SHIPMENT-NBR → WCL-SHIPMENT-NBR, WCN-CARTON-NBR → WCL-CARTON-NBR, WCL-SHIP-LINE-NBR | ||
| Whslcrtnline | WHSLCRTNIN | WCN-COMPANY → WCL-COMPANY, WCN-LOCATION → WCL-LOCATION, WCN-SHIPMENT-NBR → WCL-SHIPMENT-NBR, WCN-CARTON-NBR → WCL-CARTON-NBR, WCL-CRTN-LINE-NBR |