Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

RQLINEDTL


                             RQLINEDTL FILE

                        Requisition Line Details

This file contains requisition line detail records. These are created if the
item is an inventory item and it was picked from or returned to multiple bins
and/or is lot or serial tracked.

UPDATED BY

RQ35.1    RQ39.1    RQ39.2    RQ39.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RQD-COMPANY            Numeric 4                                 RQ35.1  RQ39.1
Element: Company       Identifies the AP company if the          RQ39.2  RQ39.3
                       resource type = V.  Identifies the HR
                       company if the resource type = E.  It is
                       blank for type A, P or Q resources.

RQD-REQ-NUMBER         Numeric 7                                 RQ35.1  RQ39.1
Element: Requisition NuThis is the assigned number to identify   RQ39.2  RQ39.3
                       this requisition.

RQD-LINE-NBR           Numeric 6                                 RQ35.1  RQ39.1
Element: Line Number   This is the requisition line number.      RQ39.2  RQ39.3

RQD-BIN                Alpha 7                                   RQ35.1  RQ39.1
Element: Bin           This field contains a storage area for    RQ39.2  RQ39.3
                       an item or any number of items.

RQD-LOT-SERIAL         Alpha 16                                  RQ35.1  RQ39.1
Element: Serial Number This is the lot/sublot or serial number   RQ39.2  RQ39.3
                       for this detail record.

RQD-UOM                Alpha 4                                   RQ35.1  RQ39.1
Element: Unit of MeasurThis field contains the valid stock       RQ39.2  RQ39.3
                       unit of measure for this item.


RQD-UOM-MULT           Signed 13.7                               RQ35.1  RQ39.1
Unit of Measure        This field contains the multiplier for    RQ39.2  RQ39.3
Multiplier             converting this unit of measure to the
                       stock unit of measure.

RQD-QUANTITY           Signed 13.4                               RQ35.1  RQ39.1
Element: Quantity      This is the detail transaction quantity.  RQ39.2  RQ39.3

                         RQLINEDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RQDSET1   COMPANY       This index is used to access a           RQ35.1  RQ39.1
          REQ-NUMBER    requisition line detail record by        RQ39.2  RQ39.3
          LINE-NBR      company; requisition number; line; bin,
          BIN           lot number, serial number, or a
          LOT-SERIAL    combination thereof; and unit of
          UOM           measure.

                         RQLINEDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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

                         RQLINEDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

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