Lawson Insight Technical Documentation |
|
REQLINE
REQLINE FILE
Requisition Line
This file contains the line item information for the requisition.
REFERENCED BY
AM19.1 AM19.2 AP115 AP220 AP305 API2.1
MA310 MA63.1 MA65.1 PO135 PO136 PO26.1
PO285 POD0.1 POIE.1 POIF.1 POIG.1 POIM.1
MM280 MM80.1 MM80.2 RQ111 RQ230 RQ235
RQ50.1 RQCP.1 RQIB.1 RQIJ.1 WHD0.1 RQ240
IC11.1
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 CXCP.1
IC130 MA180 MA41.1 MA41.2 MA41.4 MA41.7
MA43.1 MA43.2 MA43.3 MA43.7 MA530 MA531
MA60.2 MA60.3 MA60.5 MA61.1 MA66.2 MA66.3
MA67.2 MA67.3 MA68.2 MA68.3 MA68.5 MA70.1
MA75.1 MA80.1 MAI1.1 PD10.1 PD10.2 PD130
PD20.1 PD20.2 PD20.3 PO100 PO101 PO122
PO131 PO190 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.1 PO24.1 PO25.1
PO25.5 PO25.6 PO25.7 PO27.2 PO29.1 PO30.1
PO30.2 PO30.3 PO300 PO31.1 PO31.2 PO32.2
PO32.4 PO33.1 PO34.1 PO35.1 PO36.1 PO36.2
PO38.1 PO39.1 PO39.2 PO44.1 PO50.1 PO52.1
PO520 PO536 POCP.1 POI3.1 POID.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 RQD0.1 RQD1.1 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 WHD2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RLN-COMPANY Numeric 4 PO100 PO23.1
Element: Company Enter the company number defined in POIF.1 POIG.1
Company (IC01.1) or Company (MA01.1). RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-REQ-NUMBER Numeric 7 PO100 PO23.1
Element: Req Number This is the requisition number. POIF.1 POIG.1
Requisition numbers are automatically RQ10.1 RQ10.3
assigned if the company is set up for RQ11.1 RQ12.1
automatic numbering in IC01.1 (Company) RQ13.1 RQ13.2
or MA00.1 (Company). Otherwise, RQ35.1 RQ500
requisition numbers are user defined. RQIF.1
Automatically assigned requisition
numbers are incremented by one from the
last number used, as defined in IC01.1
or MA00.1.
RLN-REQ-NUMBER-A Alpha 10 PO100 PO23.1
Element: Req Number A This field is used to connect Warehouse POIF.1 POIG.1
system demand records with the RQ10.1 RQ10.3
requisitions to facilitate Drill Around RQ11.1 RQ12.1
activity. RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-LINE-NBR Numeric 6 PO100 PO23.1
Element: Line Nbr This is the system-assigned line number POIF.1 POIG.1
for the requested line. The system RQ10.1 RQ10.3
increments this by one with each RQ11.1 RQ12.1
requested line. RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-ITEM Alpha 32 PO100 PO23.1
Element: Item This is the item number to be POIF.1 POIG.1
requested. If you are requesting a RQ10.1 RQ10.3
Nonstock item, this item must be defined RQ11.1 RQ12.1
in IC11 (Item Master). If the requested RQ13.1 RQ13.2
item is an Inventory item, the item must RQ35.1 RQ500
be defined in IC11 (Item Master) and RQIF.1
defined in IC12 (Item Location) for the
"from" location. If the item is either
Service or Special item, the item number
field is user-defined.
RLN-ITEM-TYPE Alpha 1 PO100 PO23.1
Element: Item Type Enter the type of item requested. POIF.1 POIG.1
RQ10.1 RQ10.3
An inventoried item is maintained in RQ11.1 RQ12.1
inventory and must be defined in IC11 RQ13.1 RQ13.2
(Item Master) and IC12 (Item Location) RQ35.1 RQ500
for the "from" location. RQIF.1
A nonstock item is set up in IC11 (Item
Master) but is not maintained in
inventory.
An X (special order) item is not set up
in IC11 (Item Master) and is not being
tracked in inventory.
A service is not defined in IC11 (Item
Master) and does not require receiving.
I = Inventoried
S = Service
X = Special
N = Non-stock
RLN-SERVICE-CODE Alpha 1 PO100 PO23.1
Element: Service Code Q = Quantity POIF.1 POIG.1
" " = Not Service Item RQ10.1 RQ10.3
A = Amount RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-DESCRIPTION Alpha 30 (Lower Case) PO100 PO23.1
Element: Description Enter the description of the item. Use POIF.1 POIG.1
IC11 (Item Master) to enter the RQ10.1 RQ10.3
description for inventory and nonstock RQ11.1 RQ12.1
type items. If the item type is either RQ13.1 RQ13.2
an I or an N, the description can not be RQ35.1 RQ500
changed. If the item is a special order RQIF.1 WH222
(X) or service (S) item, you must enter
a description of the requested item.
RLN-QUANTITY Signed 13.4 PO100 PO23.1
Element: Quantity Enter the requested quantity. If left POIF.1 POIG.1
blank, this defaults to 1. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-ENTERED-UOM Alpha 4 PO100 PO23.1
Element: Uom This field contains the valid stock POIF.1 POIG.1
unit of measure for this item. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-ENT-UOM-MULT Signed 13.7 PO100 PO23.1
Element: Uom Mult This field contains the multiplier for POIF.1 POIG.1
converting this unit of measure to the RQ10.1 RQ10.3
stock unit of measure. RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-RETURN-QTY Signed 13.4 PO100 PO23.1
Element: Quantity This field contains the desired POIF.1 POIG.1
quantity. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-DTL-RET-QTY Signed 13.4 RQ10.1 RQ10.3
Element: Quantity This is the total of the returned RQ11.1 RQ35.1
quantity from the detail records. Detail RQ39.1 RQ39.2
records are created for multiple bins, RQ39.3 RQ500
lot, or serial tracked items. RQIF.1
RLN-UNIT-COST Signed 18.5 PO100 PO23.1
Element: Intl Cost This field contains the unit cost in POIF.1 POIG.1
base currency. When the PO is created, RQ10.1 RQ10.3
then the cost on the PO will be RQ11.1 RQ12.1
reflected in transaction currency. RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-COST-OPTION Alpha 1 PO100 PO23.1
Element: Cost Option 1 = Cost Required POIF.1 POIG.1
2 = No Charge RQ10.1 RQ10.3
3 = Vendor Determined RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-OVERIDE-CST-FL Alpha 1 PO100 PO23.1
Element: Overide Cst FlY = Yes POIF.1 POIG.1
N = No RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-CREATE-PO-FL Alpha 1 PO100 PO23.1
Element: Create Po Fl Y = Yes POIF.1 POIG.1
N = No RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-AGREEMENT-REF Alpha 30 PO100 PO23.1
Element: Agreement Ref 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) PO100 PO23.1
Element: Vendor The vendor's identification code. 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 PO100 PO23.1
Element: Purch Fr Loc The vendor's purchase from location. 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 PO100 PO23.1
Element: Major Class Purchase Class Major Field. This field POIF.1 POIG.1
can be used to control the classes of RQ10.1 RQ10.3
items that a requester can enter on a RQ11.1 RQ12.1
requisition. RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PURCH-MINOR Alpha 4 PO100 PO23.1
Element: Minor Class Purchase Class Minor Field. 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 PO100 PO23.1
Element: Buyer Buyer code, defaulted from the POIF.1 POIG.1
Requisition Header or Item Location file RQ10.1 RQ10.3
if the buyer code is blank. RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-FROM-COMPANY Numeric 4 PO100 PO23.1
Element: Company The company from which the requisition POIF.1 POIG.1
gets replenished. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-FROM-LOCATION Alpha 5 PO100 PO23.1
Element: Location This field contains a valid stocking POIF.1 POIG.1
location within the company inventory. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-REQ-LOCATION Alpha 5 PO100 PO23.1
Element: Req Location The location requisitioning items. POIF.1 POIG.1
This location can be an inventory or RQ10.1 RQ10.3
noninventory location. RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-REQ-DEL-DATE Numeric 8 (yyyymmdd) PO100 PO23.1
Element: Date This is the date that the requester POIF.1 POIG.1
would like the items to be delivered. RQ10.1 RQ10.3
This date defaults from the requested RQ11.1 RQ12.1
delivery date on the requisition header. RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-LATE-DL-DATE Numeric 8 (yyyymmdd) PO100 PO23.1
Element: Late Dl Date This field contains the late delivery POIF.1 POIG.1
date. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-CREATION-DATE Numeric 8 (yyyymmdd) PO100 PO23.1
Element: Creation Date This is the date that this line was POIF.1 POIG.1
added to the requisition. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-DIST-CODE Alpha 9 PO100 PO23.1
Element: Dist Code This user-defined code is defined in POIF.1 POIG.1
the Terms system. The code allows RQ10.1 RQ10.2
multiple line distributions for RQ10.3 RQ11.1
noninventory items. The code is not RQ12.1 RQ13.1
valid for inventory tracked items. When RQ13.2 RQ35.1
the requested line is converted to a RQ500 RQIF.1
purchase order line, the program passes
the distribution code with its
distributions to the Purchase Order
system. If the item is requested from
multiple requisitions, the system tracks
all the distributions for the item. The
distributions are expensed when an
invoice is processed in the Accounts
Payable system.
RLN-IC-TRANS-TYPE Alpha 2 PO100 PO23.1
Element: Ic Trans Type This code indicates the type of POIF.1 POIG.1
inventory transaction created when the RQ10.1 RQ10.3
line is picked in WH30 (Picking RQ11.1 RQ12.1
Feedback). RQ13.1 RQ13.2
IS = Issues RQ35.1 RQ500
DT = Direct Transfer RQIF.1
IT = Intransit Transfer
RLN-PO-CODE Alpha 4 PO100 PO23.1
Element: Po Code This is the purchase order code. 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 PO100 PO23.1
Element: Tax Code This code is used to determine if this POIF.1 POIG.1
item is taxable when purchased at this RQ10.1 RQ10.3
location and to extract the tax data RQ11.1 RQ12.1
from the Tax file based on this tax RQ13.1 RQ13.2
code. This field value is passed to the RQ35.1 RQ500
PO when the PO is created. RQIF.1
RLN-PURCH-TAX-FL Alpha 1 PO100 PO23.1
Element: Purch Tax Fl This flag specifies if this item is POIF.1 POIG.1
taxable when it is purchased for this RQ10.1 RQ10.3
location. This field value is passed to RQ11.1 RQ12.1
the PO when the PO is created. RQ13.1 RQ13.2
N = Nontaxable RQ35.1 RQ500
Y = Taxable RQIF.1
RLN-CERT-REQ-FL Alpha 1 PO100 PO23.1
Element: Cert Req Fl This flag indicates whether a POIF.1 POIG.1
certification is required for this line RQ10.1 RQ10.3
when it is purchased. This field value RQ11.1 RQ12.1
is passed to the PO when the PO line is RQ13.1 RQ13.2
created. RQ35.1 RQ500
N = No RQIF.1
Y = Yes
RLN-INSP-REQ-FL Alpha 1 PO100 PO23.1
Element: All Flag This flag indicates whether this item POIF.1 POIG.1
has to be inspected when received using RQ10.1 RQ10.3
a PO. RQ11.1 RQ12.1
N = No RQ13.1 RQ13.2
Y = Yes RQ35.1 RQ500
RQIF.1
RLN-LAST-RET-SEQ Numeric 3 PO100 PO23.1
Element: Seq This field contains the record sequence POIF.1 POIG.1
number. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-VEN-ITEM Alpha 32 PO100 PO23.1
Element: Item The vendor's identifier for this item. 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 PO100 PO23.1
Element: Status This is the processing status of a POIF.1 POIG.1
requisition line. RQ10.1 RQ10.3
0 = Unreleased RQ11.1 RQ12.1
1 = Released RQ13.1 RQ13.2
8 = Rejected RQ35.1 RQ500
9 = Processed RQIF.1
RLN-CLOSED-FL Alpha 1 AP125 AP126
Element: Closed Fl The Closed Flag. AP131 AP20.1
Y = Yes AP20.2 AP20.3
N = No AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
RLN-BIN Alpha 7 PO100 PO23.1
Element: Bin This field contains a storage area for POIF.1 POIG.1
an item or any number of items. 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 PO100 PO23.1
Element: Po User Fld 2 Purchase order line user defined field. POIF.1 POIG.1
This field is passed to the PO line RQ10.1 RQ10.3
when the PO is created. RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PO-USER-FLD-4 Alpha 30 (Lower Case) PO100 PO23.1
Element: User Fld2 Purchase order line user defined field. POIF.1 POIG.1
This field is passed to the PO line RQ10.1 RQ10.3
when the PO is created. RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-PO-USER-FLD-6 Alpha 15 (Lower Case) PO100 PO23.1
Element: User Fld3 Purchase order line user defined field. POIF.1 POIG.1
This field is passed to the PO line RQ10.1 RQ10.3
when the PO is created. RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-USER-DATE-3 Numeric 8 (yyyymmdd) PO100 PO23.1
Element: Date This field displays the system date POIF.1 POIG.1
when this was created. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-USER-DATE-4 Numeric 8 (yyyymmdd) PO100 PO23.1
Element: Date This field displays the system date POIF.1 POIG.1
when this was created. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-ALLOC-PRI Numeric 2 PO100 PO23.1
Element: Alloc Pri This is the allocation priority for POIF.1 POIG.1
this requisition. Valid values are from RQ10.1 RQ10.3
0 to 99, with 99 being the highest. This RQ11.1 RQ12.1
field defaults to 50. This field is RQ13.1 RQ13.2
used in the Warehouse module to RQ35.1 RQ500
determine the order in which inventory RQIF.1
demand gets allocated.
RLN-DELIVER-TO Alpha 30 (Lower Case) PO100 PO23.1
Element: Deliver To This field can be used to specify where POIF.1 POIG.1
to deliver the items. This field prints RQ10.1 RQ10.3
on the delivery ticket when you run RQ11.1 RQ12.1
Delivery Ticket Print program. RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-MANUF-CODE Alpha 4 PO100 PO23.1
Element: Manuf Code This is a user defined code that POIF.1 POIG.1
indicates the manufacturer of an item. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-MANUF-DIVISION Alpha 4 PO100 PO23.1
Element: Manuf DivisionThis is a user defined code that POIF.1 POIG.1
indicates which division of a RQ10.1 RQ10.3
manufacturer is tied to an item. RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-MANUF-NBR Alpha 15 PO100 PO23.1
Element: Manuf Nbr This is the identifier that the POIF.1 POIG.1
manufacturer has assigned to an item. RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-LAST-DIST-SEQ Numeric 4 PO100 PO23.1
Element: Seq Nbr An automatically assigned sequence POIF.1 POIG.1
number. RQ10.1 RQ10.2
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIF.1
RLN-NEW-REQ Alpha 1 RQ10.1 RQ10.3
Element: New Req N = No RQ11.1 RQ35.1
Y = Yes RQ500 RQIF.1
RLN-FILL-OR-KILL Alpha 1 PO100 PO23.1
Element: Fill Or Kill F = Fill Backorders POIF.1 POIG.1
K = Kill Backorders RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-KILL-QUANTITY Signed 13.4 PO100 PO23.1
Element: Kill Quantity 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 PO100 PO23.1
Element: Entered Item 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 PO100 PO23.1
Element: Cost Cd Unit cost origin code POIF.1 POIG.1
E = Entered RQ10.1 RQ10.3
L = Last Cost RQ11.1 RQ12.1
C = Contract RQ13.1 RQ13.2
T = Catalog/Quote RQ35.1 RQ500
B = Blanket RQIF.1
P = Last PO Created
I = Inventory Issue Cost
G = Punchout
RLN-ENTRY-FL Alpha 1 PO100 PO23.1
Element: Entry Fl 1 = Item POIF.1 POIG.1
2 = UPC RQ10.1 RQ10.3
3 = UPN1 RQ11.1 RQ12.1
4 = UPN2 RQ13.1 RQ13.2
5 = NDC RQ35.1 RQ500
6 = SKU RQIF.1
RLN-RQSRC-MACHINE Alpha 6 PO100 PO23.1
Element: Rqsrc Machine DROYAL POIF.1 POIG.1
ESIOB RQ10.1 RQ10.3
HBOC RQ11.1 RQ12.1
OMNICL RQ13.1 RQ13.2
PAREXC RQ35.1 RQ500
PERSE RQIF.1
PYXIS
RLN-PAR-ORDER-ID Alpha 20 PO100 PO23.1
Element: Par Order Id 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
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 PO100 PO23.1
Element: Punchout Id 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 PO100 PO23.1
Element: Intl Cost POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ13.2
RQ35.1 RQ500
RQIF.1
RLN-TRAN-CURR-CODE Alpha 5 RQ10.1 RQ10.3
Element: Currency Code This field contains the company base RQ11.1 RQ35.1
currency code established in Company RQ500 RQIF.1
(GL10.1 ).
RLN-CNV-RATE Signed 14.7 RQ10.1 RQ10.3
Element: Ent Cnv Rate Currency conversion rate at Purchase RQ11.1 RQ35.1
Order entry time. RQ500 RQIF.1
RLN-COMMIT-REMAIN Signed 13.4 AP125 AP126
Element: Quantity This field contains the desired AP131 AP20.1
quantity. AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
IC130 MA180
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.7
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.2 MA67.3
MA68.2 MA68.3
MA68.5 MA70.1
MA75.1 MA80.1
MAI1.1 PD10.1
PD10.2 PD130
...
RLN-RQ-SOURCE Numeric 2 RQ10.1 RQ10.3
Element: Rq Source 00 = Upgrade RQ11.1 RQ35.1
01 = IC142 RQ500 RQIF.1
02 = IC141
03 = IC83
04 = RQ35
05 = RQ500
06 = RSS
07 = RQ10
08 = DR100
RLN-SS-EVENT-REQD Numeric 1 RQ10.1 RQ10.3
Element: Ss Event Reqd 0 = No RQ11.1 RQ35.1
1 = Yes RQ500 RQIF.1
RLN-COMMODITY-CODE Alpha 35 RQ10.1 RQ10.3
Element: Commodity Code RQ11.1 RQ35.1
RQ500 RQIF.1
RLN-P-CARD-FLAG Numeric 1
Element: Flag Num
RLN-PCARD-NBR Alpha 16
Element: Pcard Nbr
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 AM19.1 AM19.2
REQ-NUMBER AP115 AP125
LINE-NBR AP126 AP131
AP20.1 AP20.2
AP20.3 AP20.4
AP20.5 AP20.7
AP21.1 AP220
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.2
AP30.4 AP305
API1.1 API2.1
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
...
RLNSET2 COMPANY Subset IC130 WH30.1
REQ-NUMBER-A Where ITEM-TYPE = "I" WH30.2 WH31.1
LINE-NBR WH31.2 WH32.1
WH32.2
RLNSET3 FROM-COMPANY KeyChange AP125 AP126
FROM-LOCATION AP131 AP20.1
ITEM AP20.2 AP20.3
REQ-NUMBER AP20.4 AP20.5
LINE-NBR AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 IC130
...
RLNSET4 COMPANY Subset AP125 AP126
REQ-NUMBER Where (CLOSED-FL != "Y" ) AP131 AP20.1
LINE-NBR AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
RLNSET5 COMPANY KeyChange RQ42.1
REQ-LOCATION
ITEM
REQ-DEL-DATE
REQ-NUMBER
LINE-NBR
RLNSET6 COMPANY KeyChange RQ10.1 RQ10.3
REQ-LOCATION RQ11.1 RQ13.2
CREATION-DATE RQ240 RQ35.1
ITEM RQ500 RQD1.1
REQ-NUMBER RQIB.1 RQIF.1
LINE-NBR RQIJ.1
RLNSET7 COMPANY KeyChange PO100 PO23.1
REQ-NUMBER POIF.1 RQ10.1
LINE-NBR RQ12.1 RQ13.1
ITEM-TYPE RQ13.2 RQ35.1
RQ500 RQIF.1
RLNSET8 COMPANY IC11.1
ITEM
REQ-NUMBER
LINE-NBR
RLNSET9 FROM-COMPANY KeyChange, Subset
REQ-NUMBER-A Where COMPANY != FROM-COMPANY
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 (CPYSET1)
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 Not 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
Porlnuf PORLNUF Not Required, Delete Cascades
RLN-COMPANY -> UFQ-COMPANY
RLN-REQ-NUMBER -> UFQ-REQ-NUMBER
RLN-LINE-NBR -> UFQ-LINE-NBR
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
"RQ" -> 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
RLN-REQ-NUMBER-A -> WHL-DOC-NBR
RLN-LINE-NBR -> WHL-LINE-NBR
WHL-SHIPMENT-NBR
Whshipment WHSHIPMENT
RLN-FROM-COMPANY -> WHS-COMPANY
RLN-FROM-LOCATION -> WHS-LOCATION
RLN-REQ-NUMBER-A -> WHS-DOC-NBR
WHS-SHIPMENT-NBR
|