Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                              REQLINE FILE

                            Requisition Line

This file contains the line item information for the requisition.

REFERENCED BY

AP115     AP220     AP30.2    AP30.4    AP305     API1.1
IC130     MA126     MA63.1    MA65.1    MA68.1    PO135
PO136     PO26.1    POCP.1    POIF.1    POIJ.1    RQ111
RQ230     RQ235     RQ50.1    RQCP.1    WH130     WH33.1
WH33.2    WH33.3    WH33.4    WH33.5    WH33.6    WH33.8
WH33.9    WH34.1    WH34.2    WH34.3    WH34.4    IC243
PC210

UPDATED BY

DR100     IC141     IC142     IC83.1    RQ11.1    RQ12.1
RQ13.1    RQ140     RQ300     RQ39.1    RQ39.2    RQ39.3
RQ40.1    RQ41.1    RQ42.1    RQ44.1    RQ44.2

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

RLN-COMPANY          Numeric 4                                   DR100   IC141
Company              Enter the company number defined in         IC142   IC83.1
                     IC01.1 (Company) or MA00.1 (Company).       POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-REQ-NUMBER       Numeric 7                                   DR100   IC141
Requisition Number   This is the requisition number.             IC142   IC83.1
                     Requisition  numbers are automatically      POIF.1  POIG.1
                     assigned if  the company is set up for      RQ11.1  RQ12.1
                     automatic numbering in IC01.1 (Company)     RQ13.1
                     or MA00.1 (Company). Otherwise,
                     requisition numbers are user defined.

                     Automatically assigned requisition
                     numbers are incremented by one from the
                     last number used, as defined in IC01.1
                     or MA00.1.

RLN-REQ-NUMBER-A     Alpha 10                                    DR100   IC141
Req Number A         This field is used to connect Warehouse     IC142   IC83.1
                     system demand records with the              POIF.1  POIG.1
                     requisitions to facilitate Drill Around     RQ11.1  RQ12.1
                     activity.                                   RQ13.1

RLN-LINE-NBR         Numeric 6                                   DR100   IC141
Line Number          This is the system-assigned line number     IC142   IC83.1
                     for the requested line. The system          POIF.1  POIG.1
                     increments this by one with each            RQ11.1  RQ12.1
                     requested line.                             RQ13.1

RLN-ITEM             Alpha 32                                    DR100   IC141
Item Number          This is the item number to be               IC142   IC83.1
                     requested. If you are requesting a          POIF.1  POIG.1
                     Nonstock item, this item must be defined    RQ11.1  RQ12.1
                     in IC11 (Item Master).  If the requested    RQ13.1
                     item is an Inventory item, the item must
                     be defined in IC11 (Item Master) and
                     defined in IC12 (Item Location) for the
                     "from" location. If the item is either
                     Service or Special item, the item number
                     field is user-defined.

RLN-ITEM-TYPE        Alpha 1                                     DR100   IC141
Item Type            Enter the type of item requested.           IC142   IC83.1
                                                                 POIF.1  POIG.1
                     An inventoried item is maintained in        RQ11.1  RQ12.1
                     inventory and must be defined in IC11       RQ13.1
                     (Item Master) and IC12 (Item Location)
                     for the "from" location.
                     A nonstock item is set up in IC11 (Item
                     Master) but is not maintained in
                     inventory.
                     An X (special order) item is not set up
                     in IC11 (Item Master) and is not being
                     tracked in inventory.
                     A service is not defined in IC11 (Item
                     Master) and does not require receiving.
                     I = Inventoried
                     S = Service
                     X = Special
                     N = Non-stock

RLN-SERVICE-CODE     Alpha 1                                     DR100   IC141
Service Code         Q = Quantity                                IC142   IC83.1
                     " " = Not Service Item                      POIF.1  POIG.1
                     A = Amount                                  RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-DESCRIPTION      Alpha 30  (Lower Case)                      DR100   IC141
Description          Enter the description of the item.  Use     IC142   IC83.1
                     IC11 (Item Master) to enter the             POIF.1  POIG.1
                     description for inventory and nonstock      RQ11.1  RQ12.1
                     type items. If the item type is either      RQ13.1
                     an I or an N, the description can not be
                     changed. If the item is a special order
                     (X) or service (S) item, you must enter
                     a description of the requested item.

RLN-QUANTITY         Signed 13.4                                 DR100   IC141
Quantity             Enter the requested quantity.  If left      IC142   IC83.1
                     blank, this defaults to 1.                  POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-ENTERED-UOM      Alpha 4                                     DR100   IC141
Entered Unit of      This is the valid Unit Of Measure of        IC142   IC83.1
Measure              the entered quantity.                       POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-ENT-UOM-MULT     Signed 13.7                                 DR100   IC141
Entered UOM          This is the multiplier that relates the     IC142   IC83.1
Multiplier           entered UOM to stock UOM.                   POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-RETURN-QTY       Signed 13.4                                 DR100   IC141
Quantity Returned    This is the quantity returned for           IC142   IC83.1
                     credit from the requester using RQ35.1      POIF.1  POIG.1
                     (Requisition Returns).                      RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-DTL-RET-QTY      Signed 13.4                                 RQ39.1  RQ39.2
Dtl Ret Qty          This is the total of the returned           RQ39.3
                     quantity from the detail records. Detail
                     records are created for multiple bins,
                     lot, or serial tracked items.

RLN-UNIT-COST        Signed 13.5                                 DR100   IC141
Unit Cost            This field contains the unit cost.          IC142   IC83.1
                                                                 POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-COST-OPTION      Alpha 1                                     DR100   IC141
Cost Option          1 = Cost Required                           IC142   IC83.1
                     2 = No Charge                               POIF.1  POIG.1
                     3 = Vendor Determined                       RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-OVERIDE-CST-FL   Alpha 1                                     DR100   IC141
Overide Cst Fl       Y = Yes                                     IC142   IC83.1
                     N = No                                      POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-CREATE-PO-FL     Alpha 1                                     DR100   IC141
Create Po Fl         Y = Yes                                     IC142   IC83.1
                     N = No                                      POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-AGREEMENT-REF    Alpha 30                                    DR100   IC141
Agreement Ref                                                    IC142   IC83.1
                                                                 POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-VENDOR           Alpha 9  (Right Justified)                  DR100   IC141
Vendor ID            The vendor's identification code.           IC142   IC83.1
                                                                 POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-PURCH-FR-LOC     Alpha 4                                     DR100   IC141
Purchase From        The vendor's purchase from location.        IC142   IC83.1
Location Code                                                    POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-PURCH-MAJOR      Alpha 4                                     DR100   IC141
Purch Major          Purchase Class Major Field.  This field     IC142   IC83.1
                     can be used to control the classes of       POIF.1  POIG.1
                     items that a requester can enter on a       RQ11.1  RQ12.1
                     requisition.                                RQ13.1

RLN-PURCH-MINOR      Alpha 4                                     DR100   IC141
Purch Minor          Purchase Class Minor Field.                 IC142   IC83.1
                                                                 POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-BUYER            Alpha 3                                     DR100   IC141
Buyer                Buyer code, defaulted from the              IC142   IC83.1
                     Requisition Header or Item Location file    POIF.1  POIG.1
                     if the buyer code is blank.                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-FROM-COMPANY     Numeric 4                                   DR100   IC141
From Company         The company from which the requisition      IC142   IC83.1
                     gets replenished.                           POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-FROM-LOCATION    Alpha 5                                     DR100   IC141
From Location        This is the inventory location that         IC142   IC83.1
                     supplies the items or it is the purchase    POIF.1  POIG.1
                     order ship to location that receives the    RQ11.1  RQ12.1
                     items.                                      RQ13.1

RLN-REQ-LOCATION     Alpha 5                                     DR100   IC141
To Location          The location requisitioning items.          IC142   IC83.1
                     This location can be an inventory or        POIF.1  POIG.1
                     noninventory location.                      RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-REQ-DEL-DATE     Numeric 8  (yyyymmdd)                       DR100   IC141
Requested Delivery   This is the date that the requester         IC142   IC83.1
Date                 would like the items to be delivered.       POIF.1  POIG.1
                     This date defaults from the requested       RQ11.1  RQ12.1
                     delivery date on the requisition header.    RQ13.1

RLN-LATE-DL-DATE     Numeric 8  (yyyymmdd)                       DR100   IC141
Late Delivery Date   This field contains the late delivery       IC142   IC83.1
                     date.                                       POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-CREATION-DATE    Numeric 8  (yyyymmdd)                       DR100   IC141
Creation Date        This is the date that this line was         IC142   IC83.1
                     added to the requisition.                   POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-DIST-CODE        Alpha 9                                     DR100   IC141
Distribution Code    This user-defined code is defined in        IC142   IC83.1
                     the Terms system. The code allows           POIF.1  POIG.1
                     multiple line distributions for             RQ11.1  RQ12.1
                     noninventory items. The code is not         RQ13.1
                     valid for inventory tracked items. When
                     the requested line is converted to a
                     purchase order line, the program passes
                     the distribution code with its
                     distributions to the Purchase Order
                     system. If the item is requested from
                     multiple requisitions, the system tracks
                     all the distributions for the item. The
                     distributions are expensed when an
                     invoice is processed in the Accounts
                     Payable system.

RLN-IC-TRANS-TYPE    Alpha 2                                     DR100   IC141
Inventory            This code indicates the type of             IC142   IC83.1
Transaction Type     inventory transaction created when the      POIF.1  POIG.1
                     line is picked in WH30 (Picking             RQ11.1  RQ12.1
                     Feedback).                                  RQ13.1
                     IS = Issues
                     DT = Direct Transfer
                     IT = Intransit Transfer

RLN-PO-CODE          Alpha 4                                     DR100   IC141
Po Code              This is the purchase order code.            IC142   IC83.1
                                                                 POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-PURCH-TAX-CD     Alpha 10                                    DR100   IC141
Purchasing Tax       This code is used to determine if this      IC142   IC83.1
Table Code           item is taxable when purchased at this      POIF.1  POIG.1
                     location and to extract the tax data        RQ11.1  RQ12.1
                     from the Tax file based on this tax         RQ13.1
                     code. This field value is passed to the
                     PO when the PO is created.

RLN-PURCH-TAX-FL     Alpha 1                                     DR100   IC141
Purchasing Tax Flag  This flag specifies if this item is         IC142   IC83.1
                     taxable when it is purchased for this       POIF.1  POIG.1
                     location. This field value is passed to     RQ11.1  RQ12.1
                     the PO when the PO is created.              RQ13.1
                     N = Nontaxable
                     Y = Taxable

RLN-CERT-REQ-FL      Alpha 1                                     DR100   IC141
Certification        This flag indicates whether a               IC142   IC83.1
Required Flag        certification is required for this line     POIF.1  POIG.1
                     when it is purchased. This field value      RQ11.1  RQ12.1
                     is passed to the PO when the PO line is     RQ13.1
                     created.
                     N = No
                     Y = Yes

RLN-INSP-REQ-FL      Alpha 1                                     DR100   IC141
Inspection Required  This flag indicates whether this item       IC142   IC83.1
Flag                 has to be inspected when received using     POIF.1  POIG.1
                     a PO.                                       RQ11.1  RQ12.1
                     N = No                                      RQ13.1
                     Y = Yes

RLN-LAST-RET-SEQ     Numeric 3                                   DR100   IC141
Last Returned        This is the sequence number of the last     IC142   IC83.1
Sequence             return detail record. Detail records are    POIF.1  POIG.1
                     used for multiple bins, lots, or serial     RQ11.1  RQ12.1
                     tracked items.                              RQ13.1

RLN-KIT-ITEM         Alpha 32
Kit Item             Parent item made up of component
                     items.  Not currently used.

RLN-COMPONENT-SEQ    Numeric 3                                   DR100   IC141
Component Sequence   Kit component sequence number.  For         IC142   IC83.1
Number               future use.                                 POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-VEN-ITEM         Alpha 32                                    DR100   IC141
Vendor Item          The vendor's identifier for this item.      IC142   IC83.1
                                                                 POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-STATUS           Numeric 1                                   DR100   IC141
Status               This is the processing status of a          IC142   IC83.1
                     requisition line.                           POIF.1  POIG.1
                     0 = Unreleased                              RQ11.1  RQ12.1
                     1 = Released                                RQ13.1
                     8 = Rejected
                     9 = Processed

RLN-CLOSED-FL        Alpha 1                                     DR100   IC141
Closed Flag          The Closed Flag.                            IC142   IC83.1
                     Y = Yes                                     POIF.1  POIG.1
                     N = No                                      RQ11.1  RQ12.1
                                                                 RQ13.1  RQ140
                                                                 RQ300   RQ40.1
                                                                 RQ41.1  RQ42.1
                                                                 RQ44.1  RQ44.2

RLN-BIN              Alpha 7                                     DR100   IC141
Bin                  This field contains a storage area for      IC142   IC83.1
                     an item or any number of items.             POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-PO-USER-FLD-2    Alpha 2                                     DR100   IC141
Purchase Order User  Purchase order line user defined field.     IC142   IC83.1
Field 2              This field is passed to the PO line         POIF.1  POIG.1
                     when the PO is created.                     RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-PO-USER-FLD-4    Alpha 30  (Lower Case)                      DR100   IC141
Purchase Order User  Purchase order line user defined field.     IC142   IC83.1
Field 4              This field is passed to the PO line         POIF.1  POIG.1
                     when the PO is created.                     RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-PO-USER-FLD-6    Alpha 15  (Lower Case)                      DR100   IC141
Purchase Order User  Purchase order line user defined field.     IC142   IC83.1
Field 6              This field is passed to the PO line         POIF.1  POIG.1
                     when the PO is created.                     RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-USER-DATE-3      Numeric 8  (yyyymmdd)                       DR100   IC141
User Date 3          This field contains the third               IC142   IC83.1
                     user-definable date.                        POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-USER-DATE-4      Numeric 8  (yyyymmdd)                       DR100   IC141
User Date 4          This field contains the fourth              IC142   IC83.1
                     user-definable date.                        POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-ALLOC-PRI        Numeric 2                                   DR100   IC141
Alloc Pri            This is the allocation priority for         IC142   IC83.1
                     this requisition. Valid values are from     POIF.1  POIG.1
                     0 to 99, with 99 being the highest. This    RQ11.1  RQ12.1
                     field defaults to 50.  This field is        RQ13.1
                     used in the Warehouse module to
                     determine the order in which inventory
                     demand gets allocated.

RLN-DELIVER-TO       Alpha 30  (Lower Case)                      DR100   IC141
Deliver To Name      This field can be used to specify where     IC142   IC83.1
                     to deliver the items.  This field prints    POIF.1  POIG.1
                     on the delivery ticket when you run         RQ11.1  RQ12.1
                     Delivery Ticket Print program.              RQ13.1

RLN-MANUF-CODE       Alpha 4                                     DR100   IC141
Manufacturer's Code  This is a user defined code that            IC142   IC83.1
                     indicates the manufacturer of an item.      POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-MANUF-DIVISION   Alpha 4                                     DR100   IC141
Manufacturer's       This is a user defined code that            IC142   IC83.1
Division             indicates which division of a               POIF.1  POIG.1
                     manufacturer is tied to an item.            RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-MANUF-NBR        Alpha 15                                    DR100   IC141
Manufacturer's Item  This is the identifier that the             IC142   IC83.1
Number               manufacturer has assigned to an item.       POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-LAST-DIST-SEQ    Numeric 4                                   DR100   IC141
Last Distribution    Used by the system to track the last        IC142   IC83.1
Sequence Nbr         payment record number used for the          POIF.1  POIG.1
                     invoice.                                    RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-KIT-FL           Alpha 1                                     DR100   IC141
Kit Flag             This field is used to indicate that         IC142   IC83.1
                     this transaction is for kit item.           POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-KIT-ALLOC-FL     Alpha 1
Kit Allocation Flag  For future use.

RLN-NEW-REQ          Alpha 1
New Req              N = No
                     Y = Yes

RLN-FILL-OR-KILL     Alpha 1                                     DR100   IC141
Fill Or Kill         F = Fill Backorders                         IC142   IC83.1
                     K = Kill Backorders                         POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-KILL-QUANTITY    Signed 13.4                                 DR100   IC141
Kill Quantity                                                    IC142   IC83.1
                                                                 POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-ENTERED-ITEM     Alpha 25                                    DR100   IC141
Entered Item                                                     IC142   IC83.1
                                                                 POIF.1  POIG.1
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1

RLN-COST-CD          Alpha 1                                     DR100   IC141
Unit Cost Origin     Unit cost origin code                       IC142   IC83.1
Code                 E = Entered                                 POIF.1  POIG.1
                     L = Last Cost                               RQ11.1  RQ12.1
                     C = Contract                                RQ13.1
                     T = Catalog/Quote
                     B = Blanket
                     P = Last PO Created
                     I = Inventory Issue Cost

RLN-ENTRY-FL         Alpha 1                                     DR100   IC141
Entry Fl             1 = Item                                    IC142   IC83.1
                     2 = UPC                                     POIF.1  POIG.1
                     3 = UPN1                                    RQ11.1  RQ12.1
                     4 = UPN2                                    RQ13.1
                     5 = NDC
                     6 = SKU

RLN-DER-ORIGIN-CD    Derived
Der Origin Cd

RLN-DER-REQUESTER    Derived
Der Requester

                         REQLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RLNSET1   COMPANY       This index is used to access a           AP115   AP220
          REQ-NUMBER    requisition line record by company,      AP30.2  AP30.4
          LINE-NBR      requisition number, and line number.     AP305   API1.1
                                                                 DR100   IC130
                                                                 IC141   IC142
                                                                 IC83.1  MA126
                                                                 MA63.1  MA65.1
                                                                 MA68.1  PO135
                                                                 PO136   PO26.1
                                                                 POCP.1  POIF.1
                                                                 POIJ.1  RQ11.1
                                                                 RQ111   RQ12.1
                                                                 RQ13.1  RQ140
                                                                 RQ230   RQ235
                                                                 RQ300   RQ39.1
                                                                 ...

RLNSET2   COMPANY       This index is used to access a           POIJ.1  WH130
          REQ-NUMBER-A  requisition line record by company,      WH33.1  WH33.2
          LINE-NBR      requesting location, requisition number, WH33.3  WH33.4
                        line number, from company, and from      WH33.5  WH33.6
                        location.                                WH33.8  WH33.9
                        Subset                                   WH34.1  WH34.2
                        Where ITEM-TYPE = "I"                    WH34.3  WH34.4

RLNSET3   FROM-COMPANY  This index is used to access a           DR100   IC141
          FROM-LOCATION requisition line record by from company, IC142   IC83.1
          ITEM          from location, item, requisition number, RQ11.1  RQ12.1
          REQ-NUMBER    and line number.                         RQ13.1
          LINE-NBR      KeyChange

RLNSET4   COMPANY       This index is used to access a           DR100   IC141
          REQ-NUMBER    requisition line record by company, if   IC142   IC83.1
          LINE-NBR      reference number, requested delivery     RQ11.1  RQ140
                        date, requisition number, and line       RQ300   RQ40.1
                        number.                                  RQ41.1  RQ44.1
                        Subset                                   RQ44.2
                        Where (CLOSED-FL != "Y" )

RLNSET5   COMPANY       This index is used to access a           RQ42.1
          REQ-LOCATION  requisition line record by company,
          ITEM          requesting location, item, requested
          REQ-DEL-DATE  delivery date, requisition number, and
          REQ-NUMBER    line number.
          LINE-NBR      KeyChange

RLNSET6   COMPANY       This index is used to access a           IC243   IC83.1
          REQ-LOCATION  requisition line record by company,      PC210
          CREATION-DATE requesting location, creation date,
          ITEM          item, requisition number, and line
          REQ-NUMBER    number.
          LINE-NBR      KeyChange

                         REQLINE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Ap Company     APCOMPANY    Not Required

                            PCY-COMPANY          -> CPY-COMPANY

From Location  ICLOCATION   Required

                            RLN-FROM-COMPANY     -> ICL-COMPANY
                            RLN-FROM-LOCATION    -> ICL-LOCATION

Ic Company     ICCOMPANY    Required

                            RLN-FROM-COMPANY     -> ICC-COMPANY

Item           ITEMMAST     Required
                            When RLN-ITEM-TYPE = "I"
                            Or   RLN-ITEM-TYPE = "N"

                            ICC-ITEM-GROUP       -> ITE-ITEM-GROUP
                            RLN-ITEM             -> ITE-ITEM

Item Location  ITEMLOC      Required
                            When RLN-ITEM-TYPE = "I"

                            RLN-FROM-COMPANY     -> ITL-COMPANY
                            RLN-FROM-LOCATION    -> ITL-LOCATION
                            RLN-ITEM             -> ITL-ITEM

Mmuaval        MMUAVAL      Required

                            RLN-COMPANY          -> MUA-COMPANY
                            "RQ"                 -> MUA-SYSTEM-CD
                            RLN-FROM-LOCATION    -> MUA-LOCATION
                            "RQ"                 -> MUA-DOC-TYPE
                            Spaces               -> MUA-DOC-NUMBER
                            RLN-REQ-NUMBER       -> MUA-DOC-NBR-NUM
                            Spaces               -> MUA-PO-CODE
                            RLN-LINE-NBR         -> MUA-LINE-NBR
                            Zeroes               -> MUA-API-OBJ-ID
                            Zeroes               -> MUA-SEQ-NBR

Po Company     POCOMPANY    Required
                            When RLN-ITEM-TYPE != "I"

                            RLN-FROM-COMPANY     -> PCY-COMPANY

Req Location   RQLOC        Required

                            RLN-COMPANY          -> RQL-COMPANY
                            RLN-REQ-LOCATION     -> RQL-REQ-LOCATION

Requester      REQUESTER    Required

                            RQH-REQUESTER        -> REQ-REQUESTER

Requisition    REQHEADER    Required

                            RLN-COMPANY          -> RQH-COMPANY
                            RLN-REQ-NUMBER       -> RQH-REQ-NUMBER

Vendor         APVENMAST    Not Required

                            CPY-VENDOR-GROUP     -> VEN-VENDOR-GROUP
                            RLN-VENDOR           -> VEN-VENDOR

Whdemand       WHDEMAND     Not Required

                            RLN-FROM-COMPANY     -> WDM-COMPANY
                            "RQ"                 -> WDM-SYSTEM-CD
                            RLN-REQ-NUMBER-A     -> WDM-DOC-NBR
                            RLN-LINE-NBR         -> WDM-LINE-NBR
                            Zeroes               -> WDM-COMPONENT-SEQ
                            RLN-FROM-LOCATION    -> WDM-LOCATION

Whdemand Phar  WHDEMAND     Not Required

                            RLN-COMPANY          -> WDM-COMPANY
                            "PH"                 -> WDM-SYSTEM-CD
                            RLN-REQ-NUMBER-A     -> WDM-DOC-NBR
                            RLN-LINE-NBR         -> WDM-LINE-NBR
                            Zeroes               -> WDM-COMPONENT-SEQ
                            RLN-FROM-LOCATION    -> WDM-LOCATION

Whdemndhdr     WHDEMNDHDR   Not Required

                            RLN-FROM-COMPANY     -> WDH-COMPANY
                            "RQ"                 -> WDH-SYSTEM-CD
                            RLN-REQ-NUMBER       -> WDH-DOC-NBR-NUM

                         REQLINE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Accounts       MMDIST

                            RLN-COMPANY          -> MMD-COMPANY
                            RLN-REQ-NUMBER       -> MMD-DOC-NBR-NUM
                            RLN-LINE-NBR         -> MMD-LINE-NBR
                                                    MMD-LINE-SEQ

Itemsub        ITEMSUB

                            ICC-ITEM-GROUP       -> ITS-ITEM-GROUP
                            RLN-ITEM             -> ITS-ITEM
                            "S"                  -> ITS-SUBTYPE
                                                    ITS-SUB-ITEM

Polinesrc      POLINESRC
                            Valid When RLN-CREATE-PO-FL =  "Y"
                                  And  RLN-STATUS       >= 1

                            RLN-COMPANY          -> PLS-OPER-COMPANY
                            "R"                  -> PLS-ORIGIN-CD
                            RLN-REQ-NUMBER       -> PLS-SOURCE-DOC-N
                            RLN-LINE-NBR         -> PLS-SRC-LINE-NBR
                                                    PLS-PO-CODE
                                                    PLS-PO-NUMBER
                                                    PLS-PO-RELEASE
                                                    PLS-LINE-NBR

Rqlinedtl      RQLINEDTL

                            RLN-COMPANY          -> RQD-COMPANY
                            RLN-REQ-NUMBER       -> RQD-REQ-NUMBER
                            RLN-LINE-NBR         -> RQD-LINE-NBR
                                                    RQD-BIN
                                                    RQD-LOT-SERIAL
                                                    RQD-UOM

Whshipline     WHSHIPLINE

                            RLN-FROM-COMPANY     -> WHL-COMPANY
                            "RQ"                 -> WHL-SYSTEM-CD
                            WDH-DOC-NBR          -> WHL-DOC-NBR
                            RLN-LINE-NBR         -> WHL-LINE-NBR
                                                    WHL-SHIPMENT-NBR

Whshipment     WHSHIPMENT

                            RLN-FROM-COMPANY     -> WHS-COMPANY
                            RLN-FROM-LOCATION    -> WHS-LOCATION
                            WDH-DOC-NBR          -> WHS-DOC-NBR
                                                    WHS-SHIPMENT-NBR