RQLINEDTL – Requisition Line Details
- System
- Requisitions (RQ)
- Prefix
RQD- Primary key
COMPANY,REQ-NUMBER,LINE-NBR,BIN,LOT-SERIAL,UOM- Fields
- 8
- Updated by
- 5 programs
- Referenced by
- 0 programs
RQLINEDTL is the Requisition Line Details table in Lawson Requisitions (prefix RQD). It is indexed by COMPANY, REQ-NUMBER, LINE-NBR, BIN, LOT-SERIAL, UOM (RQDSET1). It is related 1:1 to REQLINE and ITSERIAL and 1:M to RQLINEDTL and RQAUDIT. It is updated by RQ35.1, RQ39.1, RQ39.2, RQ39.3 and RQD0.1. The table has 8 fields, 1 index and 4 documented relations.
About RQLINEDTL
No description in the Lawson data dictionary.
Fields (8)
Column = COBOL field name without the RQD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.
| Field / column | Type | Description & values | Updated by |
|---|---|---|---|
RQD-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. | RQ35.1, RQ39.1, RQ39.2, RQ39.3 |
RQD-REQ-NUMBER PKREQ_NUMBER | Numeric 7 | This is the assigned number to identify this requisition. | RQ35.1, RQ39.1, RQ39.2, RQ39.3 |
RQD-LINE-NBR PKLINE_NBR | Numeric 6 | This is the requisition line number. | RQ35.1, RQ39.1, RQ39.2, RQ39.3 |
RQD-BIN PKBIN | Alpha 7 | This field contains a storage area for an item or any number of items. | RQ35.1, RQ39.1, RQ39.2, RQ39.3 |
RQD-LOT-SERIAL PKLOT_SERIAL | Alpha 16 | — | RQ35.1, RQ39.1, RQ39.2, RQ39.3 |
RQD-UOM PKUOM | Alpha 4 | This field contains the valid stock unit of measure for this item. | RQ35.1, RQ39.1, RQ39.2, RQ39.3 |
RQD-UOM-MULTUOM_MULT | Signed 13.7 | This field contains the multiplier for converting this unit of measure to the stock unit of measure. | RQ35.1, RQ39.1, RQ39.2, RQ39.3 |
RQD-QUANTITYQUANTITY | Signed 13.4 | This is the detail transaction quantity. | RQ35.1, RQ39.1, RQ39.2, RQ39.3 |
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 |
|---|---|---|---|---|
RQDSET1 | COMPANY, REQ-NUMBER, LINE-NBR, BIN, LOT-SERIAL, UOM | Primary | RQ35.1, RQ39.1, RQ39.2, RQ39.3, RQD0.1 |
Relations
One to one (2) — lookups and parents
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Req Line | REQLINE | Required | RQD-COMPANY → RLN-COMPANY, RQD-REQ-NUMBER → RLN-REQ-NUMBER, RQD-LINE-NBR → RLN-LINE-NBR | |
| Serial | ITSERIAL | Not Required | RQD-COMPANY → SER-COMPANY, RLN-ITEM → SER-ITEM, RQD-LOT-SERIAL → SER-SERIAL |
One to many (2) — child tables
| Relation | Table | Rules | Condition | Field map |
|---|---|---|---|---|
| Return Detail | RQLINEDTL | Delete Restricted | RQD-COMPANY → RQD-COMPANY, RQD-REQ-NUMBER → RQD-REQ-NUMBER, RQD-LINE-NBR → RQD-LINE-NBR, RQD-BIN, RQD-LOT-SERIAL, RQD-UOM | |
| Rqaudit | RQAUDIT | "LD" → RHA-AUDIT-TYPE, RQD-COMPANY → RHA-COMPANY, RQD-REQ-NUMBER → RHA-REQ-NUMBER, RQD-LINE-NBR → RHA-LINE-NBR, Zeroes → RHA-LINE-SEQ, RQD-BIN → RHA-BIN, RQD-LOT-SERIAL → RHA-LOT-SERIAL, RQD-UOM → RHA-UOM, RHA-DATE, RHA-TIME, RHA-FLD-NBR |