Lawson Insight Technical Documentation |
|
REQLINE
REQLINE FILE
Requisition Line
This file contains the line item information for the requisition.
REFERENCED BY
AP115 AP220 AP305 API1.1 IC130 MA126
MA63.1 MA65.1 MA68.1 PO135 PO136 PO25.5
PO26.1 PO27.2 PO285 POIF.1 POIG.1 POIM.1
MM280 RQ111 RQ230 RQ235 RQ50.1 RQCP.1
RQIB.1 RQIJ.1 WH224 IC243 PC210 RQ240
IC11.1
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 CXCP.1 DR100 IC140 IC141
IC142 IC28.1 IC531 IC83.1 MA180 MA530
MA531 MA60.2 MA60.3 MA60.5 MA61.1 MA66.2
MA66.3 MA67.1 MA67.2 MA70.1 MA75.1 MA80.1
MAI1.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE111 OE113 OE114 OE116
OE129 OE13.2 OE13.3 OE13.5 OE13.6 OE14.4
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE530 OE81.1 OE810
OE830 OE90.1 OE90.2 PO100 PO101 PO122
PO131 PO20.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO23.1 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 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 POID.1 POIE.1
POII.1 POIJ.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1
RQ12.1 RQ13.1 RQ13.2 RQ140 RQ300 RQ35.1
RQ39.1 RQ39.2 RQ39.3 RQ40.1 RQ41.1 RQ42.1
RQ44.1 RQ44.2 RQ500 RQIF.1 WH130 WH132
WH190 WH20.2 WH20.7 WH222 WH25.1 WH25.2
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 WO132 WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RLN-COMPANY Numeric 4 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-REQ-NUMBER Numeric 7 DR100 IC141
Element: Requisition NuThis 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 RQ13.2
RQ35.1 RQ500
Automatically assigned requisition RQIF.1
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
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-LINE-NBR Numeric 6 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-ITEM Alpha 32 DR100 IC141
Element: 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 RQ13.2
defined in IC12 (Item Location) for the RQ35.1 RQ500
"from" location. If the item is either RQIF.1
Service or Special item, the item number
field is user-defined.
RLN-ITEM-TYPE Alpha 1 DR100 IC141
Element: 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 RQ13.2
A nonstock item is set up in IC11 (Item RQ35.1 RQ500
Master) but is not maintained in RQIF.1
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
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-DESCRIPTION Alpha 30 (Lower Case) DR100 IC141
Element: 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 RQ13.2
(X) or service (S) item, you must enter RQ35.1 RQ500
a description of the requested item. RQIF.1 WH222
RLN-QUANTITY Signed 13.4 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-ENTERED-UOM Alpha 4 DR100 IC141
Element: Unit of MeasurThis is the valid Unit Of Measure of IC142 IC83.1
the entered quantity. PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-ENT-UOM-MULT Signed 13.7 DR100 IC141
Unit of Measure 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-RETURN-QTY Signed 13.4 DR100 IC141
Element: Quantity 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-DTL-RET-QTY Signed 13.4 DR100 IC141
Element: Quantity This is the total of the returned IC142 IC83.1
quantity from the detail records. Detail RQ10.1 RQ10.3
records are created for multiple bins, RQ11.1 RQ35.1
lot, or serial tracked items. RQ39.1 RQ39.2
RQ39.3 RQ500
RQIF.1
RLN-UNIT-COST Signed 18.5 DR100 IC141
Element: Intl 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-COST-OPTION Alpha 1 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-OVERIDE-CST-FL Alpha 1 DR100 IC141
Element: Overide Cst FlY = Yes IC142 IC83.1
N = No PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-CREATE-PO-FL Alpha 1 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-AGREEMENT-REF Alpha 30 DR100 IC141
Element: Agreement Ref IC142 IC83.1
PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-VENDOR Alpha 9 (Right Justified) DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PURCH-MAJOR Alpha 4 DR100 IC141
Element: Major Class 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PURCH-MINOR Alpha 4 DR100 IC141
Element: Minor Class Purchase Class Minor Field. IC142 IC83.1
PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-BUYER Alpha 3 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-FROM-COMPANY Numeric 4 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-FROM-LOCATION Alpha 5 DR100 IC141
Element: Location Code 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-REQ-LOCATION Alpha 5 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-REQ-DEL-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: Date This is the date that the requester IC142 IC83.1
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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-LATE-DL-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: Late Delivery 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-CREATION-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-DIST-CODE Alpha 9 DR100 IC141
Element: Distribution CThis 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 RQ13.2 RQ35.1
the distribution code with its RQ500 RQIF.1
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 RQ13.2
IT = Intransit Transfer RQ35.1 RQ500
RQIF.1
RLN-PO-CODE Alpha 4 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PURCH-TAX-CD Alpha 10 DR100 IC141
Element: Tax Code This code is used to determine if this IC142 IC83.1
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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PURCH-TAX-FL Alpha 1 DR100 IC141
Element: Purchasing TaxThis 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 RQ13.2
RQ35.1 RQ500
RQIF.1
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 RQ13.2
Y = Yes RQ35.1 RQ500
RQIF.1
RLN-INSP-REQ-FL Alpha 1 DR100 IC141
Element: All Flag This flag indicates whether this item IC142 IC83.1
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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-LAST-RET-SEQ Numeric 3 DR100 IC141
Element: Sequence NumbeThis is the sequence number of the last IC142 IC83.1
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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-VEN-ITEM Alpha 32 DR100 IC141
Element: Item Number 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-STATUS Numeric 1 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-CLOSED-FL Alpha 1 BL92.1 DR100
Element: Closed Flag The Closed Flag. IC141 IC142
Y = Yes IC83.1 OE114
N = No PO100 PO23.1
POID.1 POIF.1
POIG.1 RQ10.1
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ140
RQ300 RQ35.1
RQ40.1 RQ41.1
RQ42.1 RQ44.1
RQ44.2 RQ500
RQIF.1 WH130
WH132 WH190
WH25.1 WH25.2
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.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830
RLN-BIN Alpha 7 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ39.3
RQ500 RQIF.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 PO100 PO23.1
when the PO is created. POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PO-USER-FLD-4 Alpha 30 (Lower Case) DR100 IC141
Element: User Defined FPurchase order line user defined field. IC142 IC83.1
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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PO-USER-FLD-6 Alpha 15 (Lower Case) DR100 IC141
Element: User Defined FPurchase order line user defined field. IC142 IC83.1
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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-USER-DATE-3 Numeric 8 (yyyymmdd) DR100 IC141
Element: Date 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-USER-DATE-4 Numeric 8 (yyyymmdd) DR100 IC141
Element: Date 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-ALLOC-PRI Numeric 2 DR100 IC141
Element: 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 RQ13.2
demand gets allocated. RQ35.1 RQ500
RQIF.1
RLN-DELIVER-TO Alpha 30 (Lower Case) DR100 IC141
Element: Deliver To NamThis 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-MANUF-CODE Alpha 4 DR100 IC141
Element: Manufacturer'sThis 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 RQ13.2
RQ35.1 RQ500
RQIF.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 PO100 PO23.1
manufacturer is tied to an item. POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.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. PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-LAST-DIST-SEQ Numeric 4 DR100 IC141
Element: Sequence NumbeUsed by the system to track the last IC142 IC83.1
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
RQ13.2 RQ35.1
RQ500 RQIF.1
RLN-NEW-REQ Alpha 1 DR100 IC141
Element: New Req N = No IC142 IC83.1
Y = Yes RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIF.1
RLN-FILL-OR-KILL Alpha 1 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-KILL-QUANTITY Signed 13.4 DR100 IC141
Element: Kill Quantity IC142 IC83.1
PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1 WH25.1
WH25.2
RLN-ENTERED-ITEM Alpha 25 DR100 IC141
Element: Entered Item IC142 IC83.1
PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
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 RQ13.2
P = Last PO Created RQ35.1 RQ500
I = Inventory Issue Cost RQIF.1
G = Punchout
RLN-ENTRY-FL Alpha 1 DR100 IC141
Element: 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 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-RQSRC-MACHINE Alpha 6 DR100 IC141
Element: Rqsrc Machine DROYAL IC142 IC83.1
ESIOB PO100 PO23.1
HBOC POIF.1 POIG.1
OMNICL RQ10.1 RQ10.3
PAREXC RQ11.1 RQ12.1
PERSE RQ13.1 RQ13.2
PYXIS RQ35.1 RQ500
RQIF.1
RLN-PAR-ORDER-ID Alpha 20 DR100 IC141
Element: Par Order Id IC142 IC83.1
PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-APPROVED-FL Alpha 1 RQ13.2
Element: All Flag This flag indicates that this
requisition has been approved at all
required approval levels.
RLN-CAP-TECH-FLAG Numeric 1
Element: Cap Tech Flag 0 = None
1 = Capital
2 = Technical
3 = Both
RLN-PFLOW-APRV-LVL Alpha 20 RQ13.2
Element: Pflow Aprv Lvl
RLN-PUNCHOUT-ID Alpha 32 DR100 IC141
Element: Punchout Id IC142 IC83.1
PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PFLOW-CREATED Numeric 1 RQ13.2
Element: Pflow Created 0 = PFlow work unit not created
1 = PFlow work unit created
RLN-TRAN-UNIT-COST Signed 18.5
Element: Intl Cost
RLN-TRAN-CURR-CODE Alpha 5
Element: Currency Code
RLN-CNV-RATE Signed 14.7
Entered Conversion
Rate
RLN-COMMIT-REMAIN Signed 13.4 AP125 AP126
Element: Quantity AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
CXCP.1 DR100
IC140 IC28.1
IC531 IC83.1
MA180 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.1
MA67.2 MA70.1
MA75.1 MA80.1
MAI1.1 OE10.1
OE10.2 OE10.3
OE10.4 OE10.5
OE10.6 OE10.7
OE10.8 OE11.1
OE11.4 OE11.8
OE11.9 OE110
OE111 OE113
OE114 OE116
OE129 OE13.2
...
RLN-DER-ORIGIN-CD Derived
Element: Der Origin Cd
RLN-DER-REQUESTER Derived
Element: Der Requester
RLN-DER-CLOSE-STAT Derived
Element: Der Close Stat
RLN-APPROVAL-VAL Derived
Element: Approval Val This field is a sum of the three item
total fields (I Total, N Total, and S X
Total amount fields). This value is the
total value of the requisition. It is
used for approval processing.
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. AP220 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
DR100 IC130
IC140 IC141
...
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 AP30.4
location. BL120 BL122
Subset BL130 BL20.1
Where ITEM-TYPE = "I" BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC28.1 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
...
RLNSET3 FROM-COMPANY This index is used to access a IC83.1 PO100
FROM-LOCATION requisition line record by from company, PO23.1 RQ10.1
ITEM from location, item, requisition number, RQ12.1 RQ13.1
REQ-NUMBER and line number. RQ13.2 RQ35.1
LINE-NBR KeyChange RQ500 RQIF.1
RLNSET4 COMPANY This index is used to access a BL92.1 OE114
REQ-NUMBER requisition line record by company, if POID.1 RQ10.1
LINE-NBR reference number, requested delivery RQ140 RQ300
date, requisition number, and line RQ35.1 RQ40.1
number. RQ41.1 RQ44.1
Subset RQ44.2 RQIF.1
Where (CLOSED-FL != "Y" ) WH130 WH132
WH190 WH25.1
WH25.2 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.5
...
RLNSET5 COMPANY This index is used to access a IC142 RQ42.1
REQ-LOCATION requisition line record by company, RQCP.1
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 DR100 IC141
REQ-LOCATION requisition line record by company, IC142 IC243
CREATION-DATE requesting location, creation date, IC83.1 PC210
ITEM item, requisition number, and line RQ10.1 RQ10.3
REQ-NUMBER number. RQ11.1 RQ13.2
LINE-NBR KeyChange RQ240 RQ35.1
RQ500 RQIB.1
RQIF.1 RQIJ.1
RLNSET7 COMPANY This index is used to access a IC83.1 PO100
REQ-NUMBER requisition line record for a specific PO23.1 POIF.1
LINE-NBR vendor and purchase from location. RQ10.1 RQ12.1
ITEM-TYPE KeyChange RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLNSET8 COMPANY This index is used to access a IC11.1
ITEM requisition line record used to create a
REQ-NUMBER specific purchase order line.
LINE-NBR
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 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
Whdemand WHDEMAND
RLN-FROM-COMPANY -> WDM-COMPANY
"RQ" -> WDM-SYSTEM-CD
RLN-REQ-NUMBER-A -> WDM-DOC-NBR
RLN-LINE-NBR -> WDM-LINE-NBR
RLN-FROM-LOCATION -> WDM-LOCATION
WDM-COMPONENT-SEQ
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
|