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.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
WCL-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.3 |
WCL-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | WH52.3 |
WCL-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.3 |
WCL-CARTON-NBR PKCARTON_NBR | Alpha 20 | — | WH52.3 |
WCL-SHIP-LINE-NBR PKSHIP_LINE_NBR | Numeric 6 | — | WH52.3 |
WCL-CRTN-LINE-NBRCRTN_LINE_NBR | Numeric 6 | — | WH52.3 |
WCL-PROCESS-DATEPROCESS_DATE | Numeric 8 (yyyymmdd) | — | WH52.3 |
WCL-UPDATE-TIMEUPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | WH52.3 |
WCL-PACKGE-BARCODEPACKGE_BARCODE | Alpha 20 | — | WH52.3 |
WCL-TO-BE-PCK-UNITTO_BE_PCK_UNIT | Signed 9.3 | — | WH52.3 |
WCL-UNITS-PACKEDUNITS_PACKED | Signed 9.3 | — | WH52.3 |
WCL-TO-BE-PCK-BOXSTO_BE_PCK_BOXS | Signed 9.3 | — | WH52.3 |
WCL-BOXES-PACKEDBOXES_PACKED | Signed 9.3 | — | WH52.3 |
WCL-ASSORTMENT-NBRASSORTMENT_NBR | Alpha 12 | — | WH52.3 |
WCL-PALLET-IDPALLET_ID | Alpha 20 | — | WH52.3 |
WCL-INT-REF-USER3INT_REF_USER3 | Alpha 20 | — | WH52.3 |
WCL-INT-REF-USER4INT_REF_USER4 | Alpha 30 | — | WH52.3 |
Indexes (3)
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 |
|---|---|---|---|---|
WCLSET1 | COMPANY, LOCATION, SHIPMENT-NBR, CARTON-NBR, SHIP-LINE-NBR | Primary | — | |
WCLSET2 | COMPANY, LOCATION, SHIPMENT-NBR, SHIP-LINE-NBR, CARTON-NBR | WH52.1, WH52.3, WH520 | ||
WCLSET3 | COMPANY, LOCATION, SHIPMENT-NBR, CARTON-NBR, CRTN-LINE-NBR | — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Whshcrtnin | WHSHCRTNIN | Required | WCL-COMPANY → WCN-COMPANY (WCNSET1), WCL-LOCATION → WCN-LOCATION, WCL-SHIPMENT-NBR → WCN-SHIPMENT-NBR, WCL-CARTON-NBR → WCN-CARTON-NBR |