WHSHPMNTIN – No description in the Lawson data dictionary
- System
- Warehouse (WH)
- Prefix
WSI- Primary key
COMPANY,LOCATION,SHIPMENT-NBR- Fields
- 32
- Updated by
- 2 programs
- Referenced by
- 0 programs
WHSHPMNTIN is a Lawson Warehouse table (prefix WSI); no description in the lawson data dictionary. It is indexed by COMPANY, LOCATION, SHIPMENT-NBR (WSISET1); alternate indexes: WSISET2 and WSISET3. It is related 1:M to WHSHCRTNIN, WHSHLINEIN and WHSHTRKIN. It is updated by WH52.1 and WH520. The table has 32 fields, 3 indexes and 3 documented relations.
About WHSHPMNTIN
No description in the Lawson data dictionary.
Fields (32)
Column = COBOL field name without the WSI- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
WSI-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 |
WSI-LOCATION PKLOCATION | Alpha 5 | This field contains a valid stocking location within the company inventory. | WH52.1 |
WSI-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 |
WSI-BATCH-NBRBATCH_NBR | Numeric 6 | This identifies the batch the entered invoices, debit memos, and credit memos are a part of. | WH52.1 |
WSI-STATUSSTATUS | Numeric 1 | This field displays the status of the transaction. | WH52.1 |
WSI-PROCESS-DATEPROCESS_DATE | Numeric 8 (yyyymmdd) | — | WH52.1 |
WSI-UPDATE-TIMEUPDATE_TIME | Numeric 6 | This field contains the system time when the record was updated. | WH52.1 |
WSI-GL-DATEGL_DATE | Numeric 8 (yyyymmdd) | This field contains the general ledger posting date. | WH52.1 |
WSI-BOL-NBRBOL_NBR | Alpha 22 | This field contains the Bill of Lading number. | WH52.1 |
WSI-CARRIERCARRIER | Alpha 9 (Right Justified) | The vendor's identification code. | WH52.1 |
WSI-METHODMETHOD | Alpha 10 | The method. | WH52.1 |
WSI-TRANS-IDTRANS_ID | Alpha 20 | — | WH52.1 |
WSI-FREIGHT-CODEFREIGHT_CODE | Alpha 2 | This field contains the freight code. This is must be valid in OEFRTCODE. This determines whether carrier and charge are allowed for the shipment. | WH52.1 |
WSI-FRT-CHG-CURRFRT_CHG_CURR | Signed 18.2 | — | WH52.1 |
WSI-WHS-CARTONSWHS_CARTONS | Numeric 6 | — | WH52.1 |
WSI-CUBIC-FEETCUBIC_FEET | Signed 9.3 | This field contains the unit cubic feet of the item based on the stocking UOM. | WH52.1 |
WSI-WEIGHTWEIGHT | Signed 9.3 | This field contains the unit weight of the item based on the stocking UOM. | WH52.1 |
WSI-POD-RETRN-DTPOD_RETRN_DT | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | WH52.1 |
WSI-PICK-DATEPICK_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | WH52.1 |
WSI-PACK-DATEPACK_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | WH52.1 |
WSI-SHIP-DATESHIP_DATE | Numeric 8 (yyyymmdd) | This field displays the system date when this was created. | WH52.1 |
WSI-CUST-PO-NBRCUST_PO_NBR | Alpha 22 | — | WH52.1 |
WSI-VENDORVENDOR | Alpha 9 (Right Justified) | The vendor's identification code. | WH52.1 |
WSI-EXT-ACCT-ENTEXT_ACCT_ENT | Alpha 22 (Lower Case) | — | WH52.1 |
WSI-EXT-LOCATIONEXT_LOCATION | Alpha 22 (Lower Case) | — | WH52.1 |
WSI-EXT-SHIP-NBREXT_SHIP_NBR | Alpha 100 (Lower Case) | — | WH52.1 |
WSI-GLBL-DOC-TYPEGLBL_DOC_TYPE | Alpha 10 | — | WH52.1 |
WSI-WHS-USR-FLD-01WHS_USR_FLD_01 | Alpha 20 | — | WH52.1 |
WSI-WHS-USR-FLD-02WHS_USR_FLD_02 | Alpha 20 | — | WH52.1 |
WSI-WHS-USR-FLD-03WHS_USR_FLD_03 | Alpha 20 | — | WH52.1 |
WSI-WHS-USR-FLD-04WHS_USR_FLD_04 | Alpha 20 | — | WH52.1 |
WSI-WHS-USR-FLD-05WHS_USR_FLD_05 | Alpha 20 | — | WH52.1 |
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 |
|---|---|---|---|---|
WSISET1 | COMPANY, LOCATION, SHIPMENT-NBR | Primary | WH52.1, WH52.2, WH52.3, WH52.4, WH52.5, WH520 | |
WSISET2 | COMPANY, LOCATION, PROCESS-DATE, SHIPMENT-NBR | — | ||
WSISET3 | COMPANY, LOCATION, BATCH-NBR, SHIPMENT-NBR | — |
Relations
One to many (3) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Whshcrtnin | WHSHCRTNIN | WSI-COMPANY → WCN-COMPANY (WCNSET1), WSI-LOCATION → WCN-LOCATION, WSI-SHIPMENT-NBR → WCN-SHIPMENT-NBR, WCN-CARTON-NBR | ||
| Whshlinein | WHSHLINEIN | WSI-COMPANY → WLI-COMPANY, WSI-LOCATION → WLI-LOCATION, WSI-SHIPMENT-NBR → WLI-SHIPMENT-NBR, WLI-LINE-NBR | ||
| Whshtrkin | WHSHTRKIN | WSI-COMPANY → WTI-COMPANY, WSI-LOCATION → WTI-LOCATION, WSI-SHIPMENT-NBR → WTI-SHIPMENT-NBR, WTI-TRACKING-NBR |