Lawson Insight Technical Documentation |
|
REQLINE
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 CXCP.1 IC130 IC140 IC28.1
IC531 MA180 MA41.1 MA41.2 MA41.4 MA41.7
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 MA75.1 MA80.1
MAI1.1 PO101 PO122 PO131 PO135 PO136
PO20.1 PO21.1 PO21.2 PO21.3 PO21.4 PO21.5
PO22.1 PO25.1 PO25.5 PO25.6 PO25.7 PO26.1
PO27.2 PO285 PO29.1 PO30.1 PO30.2 PO30.3
PO300 PO31.1 PO31.2 PO32.1 PO32.2 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 POD0.1 POI3.1 POIF.1 POIG.1 POII.1
POIJ.1 POIM.1 MM280 MM80.1 MM80.2 RQ111
RQ230 RQ235 RQ50.1 RQCP.1 RQIJ.1 WH20.2
WH20.7 WH222 WH224 WHD0.1 WO132 WO140
IC243 PC210 RQ240
UPDATED BY
DR100 IC141 IC142 IC83.1 PO100 PO23.1
POID.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 RQD0.1 RQD1.1 RQIE.1 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 WHD2.1
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 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 RQ35.1
RQ500 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 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 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 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 RQ35.1
defined in IC12 (Item Location) for the RQ500 RQIF.1
"from" location. If the item is either
Service or Special item, the item number
field is user-defined.
RLN-ITEM-TYPE Alpha 1 DR100 IC141
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 RQ35.1
A nonstock item is set up in IC11 (Item RQ500 RQIF.1
Master) but is not maintained in
inventory.
An X (special order) item is not set up
in IC11 (Item Master) and is not being
tracked in inventory.
A service is not defined in IC11 (Item
Master) and does not require receiving.
I = Inventoried
S = Service
X = Special
N = Non-stock
RLN-SERVICE-CODE Alpha 1 DR100 IC141
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 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 RQ35.1
(X) or service (S) item, you must enter RQ500 RQIF.1
a description of the requested item. 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 RQ35.1
RQ500 RQIF.1
RLN-ENTERED-UOM Alpha 4 DR100 IC141
Element: Unit of Measure 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
RLN-ENT-UOM-MULT Signed 13.7 DR100 IC141
Unit of Measure IC142 IC83.1
Multiplier PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.3
RQ11.1 RQ12.1
RQ13.1 RQ35.1
RQ500 RQIF.1
RLN-RETURN-QTY Signed 13.4 DR100 IC141
Element: 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
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 RQ35.1 RQ39.1
records are created for multiple bins, RQ39.2 RQ39.3
lot, or serial tracked items. RQ500 RQIF.1
RLN-UNIT-COST Signed 13.5 DR100 IC141
Element: Base 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
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 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 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 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 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 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 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 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 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 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 RQ35.1
RQ500 RQIF.1
RLN-FROM-LOCATION Alpha 5 DR100 IC141
Element: Location 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
RLN-REQ-LOCATION Alpha 5 DR100 IC141
Element: Location 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
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 RQ35.1
RQ500 RQIF.1
RLN-LATE-DL-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: Date 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
RLN-CREATION-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: Date 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
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 RQ35.1 RQ500
the distribution code with its RQIE.1 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 RQ35.1
IT = Intransit Transfer 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 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 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 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 RQ35.1
Y = Yes 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 RQ35.1
RQ500 RQIF.1
RLN-LAST-RET-SEQ Numeric 3 DR100 IC141
Element: Sequence Number 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
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 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 RQ35.1
RQ500 RQIF.1
RLN-CLOSED-FL Alpha 1 DR100 IC141
Element: All Flag Y = Yes IC142 IC83.1
N = No PO100 PO23.1
POID.1 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 RQD0.1
RQD1.1 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
WHD2.1
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 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 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 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 RQ35.1
RQ500 RQIF.1
RLN-USER-DATE-3 Numeric 8 (yyyymmdd) DR100 IC141
Element: Date 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
RLN-USER-DATE-4 Numeric 8 (yyyymmdd) DR100 IC141
Element: Date 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
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 RQ35.1
demand gets allocated. 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 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 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 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 RQ35.1
RQ500 RQIF.1
RLN-LAST-DIST-SEQ Numeric 4 DR100 IC141
Element: Sequence Number IC142 IC83.1
PO100 PO23.1
POIF.1 POIG.1
RQ10.1 RQ10.2
RQ10.3 RQ11.1
RQ12.1 RQ13.1
RQ35.1 RQ500
RQIE.1 RQIF.1
RLN-NEW-REQ Alpha 1 DR100 IC141
Element: New Req N = No IC142 IC83.1
Y = Yes 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 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 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 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 RQ35.1
P = Last PO Created RQ500 RQIF.1
I = Inventory Issue Cost
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 RQ35.1
RQ500 RQIF.1
RLN-RQSRC-MACHINE Alpha 6 DR100 IC141
Element: Rqsrc Machine The name of the dispenser machine that IC142 IC83.1
is keeping track of the medical supply PO100 PO23.1
and that produces the requisition POIF.1 POIG.1
request when the quantity of that supply RQ10.1 RQ10.3
goes below the par level. RQ11.1 RQ12.1
DROYAL RQ13.1 RQ35.1
ESIOB RQ500 RQIF.1
HBOC
OMNICL
PAREXC
PERSE
PYXIS
SSI
RLN-PAR-ORDER-ID Alpha 20 DR100 IC141
Element: Par Order Id This is the identifier of the order or IC142 IC83.1
request when the quantity of a medical PO100 PO23.1
supply falls below the par level at one POIF.1 POIG.1
of the special dispensers that can RQ10.1 RQ10.3
produce such a request. RQ11.1 RQ12.1
RQ13.1 RQ35.1
RQ500 RQIF.1
RLN-APPROVED-FL Alpha 1
Element: All Flag
RLN-CAP-TECH-FLAG Numeric 1
Element: Cap Tech Flag 0 = None
1 = Capital
2 = Technical
3 = Both
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 RQ35.1
RQ500 RQIF.1
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
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
CXCP.1 DR100
IC130 IC140
IC141 IC142
IC28.1 IC531
IC83.1 MA180
...
RLNSET2 COMPANY This index is used to access a AP125 AP126
REQ-NUMBER-A requisition line record by company, AP131 AP20.1
LINE-NBR requesting location, requisition number, AP20.2 AP20.3
line number, from company, and from AP20.4 AP20.5
location. AP20.7 AP23.1
Subset AP25.1 AP25.2
Where ITEM-TYPE = "I" AP26.1 AP27.1
AP30.4 API1.1
IC28.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
...
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, RQ10.3 RQ11.1
REQ-NUMBER and line number. RQ12.1 RQ13.1
LINE-NBR KeyChange RQ35.1 RQ500
RQCP.1 RQIF.1
RLNSET4 COMPANY This index is used to access a POID.1 RQ10.1
REQ-NUMBER requisition line record by company, if RQ10.3 RQ11.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,
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 RQ240
CREATION-DATE requesting location, creation date, RQD1.1
ITEM item, requisition number, and line
REQ-NUMBER number.
LINE-NBR KeyChange
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 RQ10.3
ITEM-TYPE KeyChange RQ11.1 RQ12.1
RQ13.1 RQ35.1
RQ500 RQIF.1
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 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
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
|