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     AP125     AP126     AP131     AP20.1    AP20.2
AP20.3    AP20.4    AP20.5    AP20.7    AP220     AP23.1
AP25.1    AP25.2    AP26.1    AP27.1    AP30.2    AP30.4
AP305     API1.1    IC130     IC28.1    MA126     MA180
MA41.1    MA41.2    MA41.4    MA43.1    MA43.2    MA43.3
MA43.4    MA43.5    MA43.7    MA43.8    MA43.9    MA530
MA531     MA60.2    MA60.3    MA60.5    MA61.1    MA63.1
MA65.1    MA66.2    MA66.3    MA67.1    MA67.2    MA68.1
MA70.1    MAI1.1    PO101     PO122     PO131     PO135
PO136     PO20.1    PO21.2    PO21.3    PO21.4    PO21.5
PO22.1    PO25.6    PO26.1    PO27.3    PO29.1    PO30.1
PO30.2    PO30.3    PO300     PO31.1    PO31.2    PO32.1
PO32.2    PO33.1    PO34.1    PO35.1    PO38.1    PO39.1
PO39.2    PO44.1    PO50.1    PO52.1    PO520     POCP.1
POI3.1    POIE.1    POIF.1    POIG.1    POII.1    POIJ.1
POIM.1    RQ111     RQ230     RQ235     RQ50.1    RQCP.1
RQIB.1    WH130     WH132     WH190     WH222     WH30.1
WH30.2    WH30.3    WH30.4    WH31.1    WH31.2    WH31.3
WH31.4    WH32.1    WH32.2    WH32.3    WH32.4    WH33.1
WH33.2    WH33.3    WH33.4    WH33.5    WH33.6    WH33.8
WH33.9    WH34.1    WH34.2    WH34.3    WH34.4    WH40.1
WH40.2    WH520     WH830     IC243     PC210

UPDATED BY

DR100     IC141     IC142     IC83.1    PO100     PO23.1
RQ10.1    RQ10.2    RQ10.3    RQ11.1    RQ12.1    RQ13.1
RQ140     RQ300     RQ35.1    RQ39.1    RQ39.2    RQ39.3
RQ40.1    RQ41.1    RQ42.1    RQ44.1    RQ44.2    RQ500
RQIF.1    WH20.7    WH25.1    WH25.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).       PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-REQ-NUMBER       Numeric 7                                   DR100   IC141
Requisition Number   This is the requisition number.             IC142   IC83.1
                     Requisition  numbers are automatically      PO100   PO23.1
                     assigned if  the company is set up for      POIF.1  POIG.1
                     automatic numbering in IC01.1 (Company)     RQ10.1  RQ10.3
                     or MA00.1 (Company). Otherwise,             RQ11.1  RQ12.1
                     requisition numbers are user defined.       RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                     Automatically assigned requisition          WH20.7
                     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              PO100   PO23.1
                     requisitions to facilitate Drill Around     POIF.1  POIG.1
                     activity.                                   RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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          PO100   PO23.1
                     increments this by one with each            POIF.1  POIG.1
                     requested line.                             RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-ITEM             Alpha 32                                    DR100   IC141
Item Number          This is the item number to be               IC142   IC83.1
                     requested. If you are requesting a          PO100   PO23.1
                     Nonstock item, this item must be defined    POIF.1  POIG.1
                     in IC11 (Item Master).  If the requested    RQ10.1  RQ10.3
                     item is an Inventory item, the item must    RQ11.1  RQ12.1
                     be defined in IC11 (Item Master) and        RQ13.1  RQ35.1
                     defined in IC12 (Item Location) for the     RQ500   RQIF.1
                     "from" location. If the item is either      WH20.7
                     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
                                                                 PO100   PO23.1
                     An inventoried item is maintained in        POIF.1  POIG.1
                     inventory and must be defined in IC11       RQ10.1  RQ10.3
                     (Item Master) and IC12 (Item Location)      RQ11.1  RQ12.1
                     for the "from" location.                    RQ13.1  RQ35.1
                     A nonstock item is set up in IC11 (Item     RQ500   RQIF.1
                     Master) but is not maintained in            WH20.7
                     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                      PO100   PO23.1
                     A = Amount                                  POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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             PO100   PO23.1
                     description for inventory and nonstock      POIF.1  POIG.1
                     type items. If the item type is either      RQ10.1  RQ10.3
                     an I or an N, the description can not be    RQ11.1  RQ12.1
                     changed. If the item is a special order     RQ13.1  RQ35.1
                     (X) or service (S) item, you must enter     RQ500   RQIF.1
                     a description of the requested item.        WH20.7  WH222

RLN-QUANTITY         Signed 13.4                                 DR100   IC141
Quantity             Enter the requested quantity.  If left      IC142   IC83.1
                     blank, this defaults to 1.                  PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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.                       PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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.                   PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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      PO100   PO23.1
                     (Requisition Returns).                      POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-DTL-RET-QTY      Signed 13.4                                 RQ35.1  RQ39.1
Dtl Ret Qty          This is the total of the returned           RQ39.2  RQ39.3
                     quantity from the detail records. Detail    RQ500   RQIF.1
                     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 in        IC142   IC83.1
                     base currency.  When the PO is created,     PO100   PO23.1
                     then the cost on the PO will be             POIF.1  POIG.1
                     reflected in transaction currency.          RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-COST-OPTION      Alpha 1                                     DR100   IC141
Cost Option          1 = Cost Required                           IC142   IC83.1
                     2 = No Charge                               PO100   PO23.1
                     3 = Vendor Determined                       POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-OVERIDE-CST-FL   Alpha 1                                     DR100   IC141
Overide Cst Fl       Y = Yes                                     IC142   IC83.1
                     N = No                                      PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-CREATE-PO-FL     Alpha 1                                     DR100   IC141
Create Po Fl         Y = Yes                                     IC142   IC83.1
                     N = No                                      PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-AGREEMENT-REF    Alpha 30                                    DR100   IC141
Agreement Ref                                                    IC142   IC83.1
                                                                 PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-VENDOR           Alpha 9  (Right Justified)                  DR100   IC141
Vendor ID            The vendor's identification code.           IC142   IC83.1
                                                                 PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-PURCH-FR-LOC     Alpha 4                                     DR100   IC141
Purchase From        The vendor's purchase from location.        IC142   IC83.1
Location Code                                                    PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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       PO100   PO23.1
                     items that a requester can enter on a       POIF.1  POIG.1
                     requisition.                                RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-PURCH-MINOR      Alpha 4                                     DR100   IC141
Purch Minor          Purchase Class Minor Field.                 IC142   IC83.1
                                                                 PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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

RLN-FROM-COMPANY     Numeric 4                                   DR100   IC141
From Company         The company from which the requisition      IC142   IC83.1
                     gets replenished.                           PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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    PO100   PO23.1
                     order ship to location that receives the    POIF.1  POIG.1
                     items.                                      RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-REQ-LOCATION     Alpha 5                                     DR100   IC141
To Location          The location requisitioning items.          IC142   IC83.1
                     This location can be an inventory or        PO100   PO23.1
                     noninventory location.                      POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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.       PO100   PO23.1
                     This date defaults from the requested       POIF.1  POIG.1
                     delivery date on the requisition header.    RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-LATE-DL-DATE     Numeric 8  (yyyymmdd)                       DR100   IC141
Late Delivery Date   This field contains the late delivery       IC142   IC83.1
                     date.                                       PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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.                   PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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           PO100   PO23.1
                     multiple line distributions for             POIF.1  POIG.1
                     noninventory items. The code is not         RQ10.1  RQ10.2
                     valid for inventory tracked items. When     RQ10.3  RQ11.1
                     the requested line is converted to a        RQ12.1  RQ13.1
                     purchase order line, the program passes     RQ35.1  RQ500
                     the distribution code with its              RQIF.1  WH20.7
                     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      PO100   PO23.1
                     line is picked in WH30 (Picking             POIF.1  POIG.1
                     Feedback).                                  RQ10.1  RQ10.3
                     IS = Issues                                 RQ11.1  RQ12.1
                     DT = Direct Transfer                        RQ13.1  RQ35.1
                     IT = Intransit Transfer                     RQ500   RQIF.1
                                                                 WH20.7

RLN-PO-CODE          Alpha 4                                     DR100   IC141
Po Code              This is the purchase order code.            IC142   IC83.1
                                                                 PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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      PO100   PO23.1
                     location and to extract the tax data        POIF.1  POIG.1
                     from the Tax file based on this tax         RQ10.1  RQ10.3
                     code. This field value is passed to the     RQ11.1  RQ12.1
                     PO when the PO is created.                  RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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       PO100   PO23.1
                     location. This field value is passed to     POIF.1  POIG.1
                     the PO when the PO is created.              RQ10.1  RQ10.3
                     N = Nontaxable                              RQ11.1  RQ12.1
                     Y = Taxable                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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     PO100   PO23.1
                     when it is purchased. This field value      POIF.1  POIG.1
                     is passed to the PO when the PO line is     RQ10.1  RQ10.3
                     created.                                    RQ11.1  RQ12.1
                     N = No                                      RQ13.1  RQ35.1
                     Y = Yes                                     RQ500   RQIF.1
                                                                 WH20.7

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     PO100   PO23.1
                     a PO.                                       POIF.1  POIG.1
                     N = No                                      RQ10.1  RQ10.3
                     Y = Yes                                     RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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    PO100   PO23.1
                     used for multiple bins, lots, or serial     POIF.1  POIG.1
                     tracked items.                              RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-VEN-ITEM         Alpha 32                                    DR100   IC141
Vendor Item          The vendor's identifier for this item.      IC142   IC83.1
                                                                 PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-STATUS           Numeric 1                                   DR100   IC141
Status               This is the processing status of a          IC142   IC83.1
                     requisition line.                           PO100   PO23.1
                     0 = Unreleased                              POIF.1  POIG.1
                     1 = Released                                RQ10.1  RQ10.3
                     8 = Rejected                                RQ11.1  RQ12.1
                     9 = Processed                               RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-CLOSED-FL        Alpha 1                                     DR100   IC141
Closed Flag          The Closed Flag.                            IC142   IC83.1
                     Y = Yes                                     PO100   PO23.1
                     N = No                                      POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ140
                                                                 RQ300   RQ35.1
                                                                 RQ40.1  RQ41.1
                                                                 RQ42.1  RQ44.1
                                                                 RQ44.2  RQ500
                                                                 RQIF.1  WH20.7
                                                                 WH25.1  WH25.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.             PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ39.3  RQ500
                                                                 RQIF.1  WH20.7

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         PO100   PO23.1
                     when the PO is created.                     POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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         PO100   PO23.1
                     when the PO is created.                     POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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         PO100   PO23.1
                     when the PO is created.                     POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-USER-DATE-3      Numeric 8  (yyyymmdd)                       DR100   IC141
User Date 3          This field contains the third               IC142   IC83.1
                     user-definable date.                        PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-USER-DATE-4      Numeric 8  (yyyymmdd)                       DR100   IC141
User Date 4          This field contains the fourth              IC142   IC83.1
                     user-definable date.                        PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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

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    PO100   PO23.1
                     on the delivery ticket when you run         POIF.1  POIG.1
                     Delivery Ticket Print program.              RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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.      PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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               PO100   PO23.1
                     manufacturer is tied to an item.            POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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.       PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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          PO100   PO23.1
                     invoice.                                    POIF.1  POIG.1
                                                                 RQ10.1  RQ10.2
                                                                 RQ10.3  RQ11.1
                                                                 RQ12.1  RQ13.1
                                                                 RQ35.1  RQ500
                                                                 RQIF.1  WH20.7

RLN-NEW-REQ          Alpha 1                                     RQ35.1  RQ500
New Req              N = No                                      RQIF.1
                     Y = Yes

RLN-FILL-OR-KILL     Alpha 1                                     DR100   IC141
Fill Or Kill         F = Fill Backorders                         IC142   IC83.1
                     K = Kill Backorders                         PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-KILL-QUANTITY    Signed 13.4                                 DR100   IC141
Kill Quantity                                                    IC142   IC83.1
                                                                 PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7  WH25.1
                                                                 WH25.2

RLN-ENTERED-ITEM     Alpha 25                                    DR100   IC141
Entered Item                                                     IC142   IC83.1
                                                                 PO100   PO23.1
                                                                 POIF.1  POIG.1
                                                                 RQ10.1  RQ10.3
                                                                 RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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

RLN-ENTRY-FL         Alpha 1                                     DR100   IC141
Entry Fl             1 = Item                                    IC142   IC83.1
                     2 = UPC                                     PO100   PO23.1
                     3 = UPN1                                    POIF.1  POIG.1
                     4 = UPN2                                    RQ10.1  RQ10.3
                     5 = NDC                                     RQ11.1  RQ12.1
                     6 = SKU                                     RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

RLN-RQSRC-MACHINE    Alpha 6
Rqsrc Machine

RLN-PAR-ORDER-ID     Alpha 20
Par Order Id

RLN-DER-ORIGIN-CD    Derived
Der Origin Cd

RLN-DER-REQUESTER    Derived
Der Requester

RLN-DER-CLOSE-STAT   Derived
Der Close Stat

                         REQLINE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RLNSET1   COMPANY       This index is used to access a           AP115   AP125
          REQ-NUMBER    requisition line record by company,      AP126   AP131
          LINE-NBR      requisition number, and line number.     AP20.1  AP20.2
                                                                 AP20.3  AP20.4
                                                                 AP20.5  AP20.7
                                                                 AP220   AP23.1
                                                                 AP25.1  AP25.2
                                                                 AP26.1  AP27.1
                                                                 AP30.2  AP30.4
                                                                 AP305   API1.1
                                                                 DR100   IC130
                                                                 IC141   IC142
                                                                 IC28.1  IC83.1
                                                                 MA126   MA180
                                                                 MA41.1  MA41.2
                                                                 ...

RLNSET2   COMPANY       This index is used to access a           AP125   AP126
          REQ-NUMBER-A  requisition line record by company,      AP131   AP25.1
          LINE-NBR      requesting location, requisition number, AP25.2  AP26.1
                        line number, from company, and from      AP27.1  IC28.1
                        location.                                MA180   MA43.9
                        Subset                                   MA530   MA531
                        Where ITEM-TYPE = "I"                    MA60.2  MA60.3
                                                                 MA60.5  MA61.1
                                                                 MA66.3  MA67.1
                                                                 MA67.2  MA70.1
                                                                 MAI1.1  PO100
                                                                 PO101   PO122
                                                                 PO131   PO20.1
                                                                 PO21.2  PO21.3
                                                                 PO21.4  PO21.5
                                                                 ...

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, PO100   PO23.1
          REQ-NUMBER    and line number.                         RQ10.1  RQ10.3
          LINE-NBR      KeyChange                                RQ11.1  RQ12.1
                                                                 RQ13.1  RQ35.1
                                                                 RQ500   RQIF.1
                                                                 WH20.7

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     RQ10.1  RQ10.3
                        date, requisition number, and line       RQ11.1  RQ140
                        number.                                  RQ300   RQ35.1
                        Subset                                   RQ40.1  RQ41.1
                        Where (CLOSED-FL != "Y" )                RQ44.1  RQ44.2
                                                                 WH25.1  WH25.2

RLNSET5   COMPANY       This index is used to access a           IC142   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

RLNSET7   COMPANY       This index is used to access a           DR100   IC141
          REQ-NUMBER    requisition line record for a specific   IC142   IC83.1
          LINE-NBR      vendor and purchase from location.       PO100   PO23.1
          ITEM-TYPE     KeyChange                                POIF.1  RQ10.1
                                                                 RQ10.3  RQ11.1
                                                                 RQ12.1  RQ13.1
                                                                 RQ35.1  RQ500
                                                                 RQIF.1  WH20.7

                         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