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    RQD0.1

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: Req Number    This is the assigned number to identify   RQ39.2  RQ39.3
                       this requisition.

RQD-LINE-NBR           Numeric 6                                 RQ35.1  RQ39.1
Element: Line Nbr      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                                                  RQ39.2  RQ39.3

RQD-UOM                Alpha 4                                   RQ35.1  RQ39.1
Element: Uom           This 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
Element: Uom Mult      This field contains the multiplier for    RQ39.2  RQ39.3
                       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                                                RQ35.1  RQ39.1
          REQ-NUMBER                                             RQ39.2  RQ39.3
          LINE-NBR                                               RQD0.1
          BIN
          LOT-SERIAL
          UOM

                         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