WHSHLINEIN – No description in the Lawson data dictionary
- System
- Warehouse (WH)
- Prefix
WLI- Primary key
COMPANY,LOCATION,SHIPMENT-NBR,LINE-NBR- Fields
- 27
- Updated by
- 2 programs
- Referenced by
- 0 programs
WHSHLINEIN is a Lawson Warehouse table (prefix WLI); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR, LINE-NBR (WLISET1); alternate indexes: WLISET2. It is related 1:1 to WHSHPMNTIN and 1:M to WHSLCRTNIN. It is updated by WH52.1 and WH520. The table has 27 fields, 2 indexes and 2 documented relations.
About WHSHLINEIN
No description in the Lawson data dictionary.
Fields (27)
Column = COBOL field name without the WLI- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#WLI-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.1 |
#WLI-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | WH52.1 |
#WLI-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.1 |
#WLI-LINE-NBR PKLINE_NBR | Numeric 6 | This field contains the line number. | WH52.1 |
#WLI-PROCESS-DATE SET2PROCESS_DATE | Numeric 8 (yyyymmdd) | — | WH52.1 |
#WLI-UPDATE-TIMEUPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | WH52.1 |
#WLI-ITEMITEM | Alpha 32 | This field contains the item identifier. | WH52.1 |
#WLI-LINE-TYPELINE_TYPE | Alpha 1 | This field contains the type of inventory on this line. | WH52.1 |
#WLI-STOCK-UOMSTOCK_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | WH52.1 |
#WLI-TRAN-UOMTRAN_UOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | WH52.1 |
#WLI-TRAN-UOM-MULTTRAN_UOM_MULT | Signed 13.7 | This field contains the multiplier for converting this unit of measure to the stock unit of measure. | WH52.1 |
#WLI-IN-PROCESS-QTYIN_PROCESS_QTY | Signed 13.4 | This field contains the desired quantity. | WH52.1 |
#WLI-SHIPPED-QTYSHIPPED_QTY | Signed 13.4 | This field contains the desired quantity. | WH52.1 |
#WLI-CATCH-WT-QTYCATCH_WT_QTY | Signed 13.4 | This field contains the desired quantity. | WH52.1 |
#WLI-PRE-ASMBLD-KITPRE_ASMBLD_KIT | Signed 13.4 | — | WH52.1 |
#WLI-DETAIL-QTYDETAIL_QTY | Signed 13.4 | This field contains the desired quantity. | WH52.1 |
#WLI-DTL-CTW-QTYDTL_CTW_QTY | Signed 13.4 | This field contains the desired quantity. | WH52.1 |
#WLI-UNIT-COSTUNIT_COST | Signed 18.5 | — | WH52.1 |
#WLI-WEIGHTWEIGHT | Signed 9.3 | This field contains the unit weight of the item based on the stocking UOM. | WH52.1 |
#WLI-CUBIC-FEETCUBIC_FEET | Signed 9.3 | This field contains the unit cubic feet of the item based on the stocking UOM. | WH52.1 |
#WLI-MSDS-DTMSDS_DT | Numeric 8 (yyyymmdd) | This date is the date that a new Material Safety Data Sheet should be sent from the vendor. | WH52.1 |
#WLI-GLBL-LINE-TYPEGLBL_LINE_TYPE | Alpha 15 | — | WH52.1 |
#WLI-WHL-USR-FLD-01WHL_USR_FLD_01 | Alpha 20 | — | WH52.1 |
#WLI-WHL-USR-FLD-02WHL_USR_FLD_02 | Alpha 20 | — | WH52.1 |
#WLI-WHL-USR-FLD-03WHL_USR_FLD_03 | Alpha 20 | — | WH52.1 |
#WLI-WHL-USR-FLD-04WHL_USR_FLD_04 | Alpha 20 | — | WH52.1 |
#WLI-WHL-USR-FLD-05WHL_USR_FLD_05 | Alpha 20 | — | WH52.1 |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
WLISET1 |
| Primary | WH52.1, WH52.2, WH52.3, WH520 | |
WLISET2 |
| — |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Whshpmntin | WHSHPMNTIN | Required |
|
One to many (1) — child tables
| Relation | Table | Rules | Condition | Field map | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Whslcrtnin | WHSLCRTNIN |
|