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
|