REQLINE FILE
Requisition Line
This file contains the line item information for the requisition.
REFERENCED BY
RQ111 RQ230 RQ235 RQ240 RQ40.1 RQ41.1
RQ44.1 RQ44.2 RQ50.1 WH222 IN20.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
OE113 OE129 OE14.4 OE15.1 OE15.2 OE15.3
OE15.4 OE15.5 OE15.7 OE510 OE810 OE920
PO22.1 PO22.3 RQ42.1 IC243 PC210 PO121
UPDATED BY
BL92.1 DR100 IC141 IC142 IC83.1 OE114
PO100 PO20.1 PO30.1 PO35.1 PO530 RQ10.1
RQ10.2 RQ10.3 RQ10.5 RQ11.1 RQ12.1 RQ120
RQ125 RQ13.1 RQ20.1 RQ20.2 RQ20.4 RQ300
RQ35.1 RQ39.1 RQ39.2 RQ39.3 RQ500 RQ961
WH130 WH132 WH190 WH20.7 WH30.1 WH30.2
WH30.3 WH31.1 WH31.2 WH31.3 WH32.1 WH32.2
WH32.3 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
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 RQ10.1 RQ10.3
Setup). RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-REQ-NUMBER Numeric 7 DR100 IC141
Requisition Number This is the requisition number. IC142 IC83.1
Requisition numbers are automatically RQ10.1 RQ10.3
assigned if the company is set up for RQ11.1 RQ20.1
automatic numbering in IC01.1 (Company) RQ35.1 RQ500
or MA00.1 (Company Setup). Otherwise, RQ961 WH20.7
requisition numbers are user defined.
Automatically assigned requisition
numbers are incremented by one from the
last number used, as defined in IC01.1
or MA00.1.
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 RQ10.1 RQ10.3
increments this by one with each RQ11.1 RQ20.1
requested line. RQ35.1 RQ500
RQ961 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 PO20.1 RQ10.1
Nonstock item, this item must be defined RQ10.3 RQ11.1
in IC11.1 (Item Master). If the RQ20.1 RQ35.1
requested item is an Inventory item, the RQ500 RQ961
item must be defined in IC11.1 (Item WH20.7
Master) and defined in IC12.1 (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 DR100 IC141
Item Type Enter the type of item requested. IC142 IC83.1
PO20.1 RQ10.1
An inventoried item is maintained in RQ10.3 RQ11.1
inventory and must be defined in IC11 RQ20.1 RQ35.1
(Item Master) and IC12 (Item Location) RQ500 RQ961
for the "from" location. WH20.7
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 = Inventory
S = Service
X = Special
N = Non-stock
RLN-DESCRIPTION Alpha 30 (Lower Case) DR100 IC141
Description Enter the description of the item. Use IC142 IC83.1
IC11.1 (Item Master) to enter the PO20.1 RQ10.1
description for inventory and nonstock RQ10.3 RQ11.1
type items. If the item type is either RQ20.1 RQ35.1
an I or an N, the description cannot be RQ500 RQ961
changed. If the item is a special order WH20.7 WH222
(X) or service (S) item, you must enter
a description of the requested item.
RLN-QUANTITY Signed 13.4 DR100 IC141
Quantity Enter the requested quantity. If left IC142 IC83.1
blank, this defaults to 1. PO20.1 RQ10.1
RQ10.3 RQ11.1
RQ20.1 RQ35.1
RQ500 RQ961
WH20.7
RLN-BUY-UOM Alpha 4 DR100 IC141
Buying Unit of This is the item's buy unit of measure. IC142 IC83.1
Measure If the item is inventory or nonstock, PO20.1 RQ10.1
this is the standard buy unit of measure RQ10.3 RQ11.1
defined in the IC11.1 (Item Master) UOM RQ125 RQ20.1
tab. RQ20.2 RQ35.1
RQ500 RQ961
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. PO20.1 RQ10.1
RQ10.3 RQ11.1
RQ20.1 RQ35.1
RQ500 RQ961
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 unit of measure to stock unit of RQ10.1 RQ10.3
measure. RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-SHIPPED-QTY Signed 13.4 BL92.1 DR100
Shipped Quantity This is the quantity that has been IC141 IC142
shipped. It is used only with inventory IC83.1 OE114
items. RQ10.1 RQ10.3
RQ11.1 RQ120
RQ20.1 RQ35.1
RQ500 RQ961
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
RLN-DELIVERED-QTY Signed 13.4 DR100 IC141
Delivered Quantity This is the quantity that has been IC142 IC83.1
issued or transferred to the requesting RQ10.1 RQ10.3
location. This quantity is updated when RQ11.1 RQ120
the delivery ticket is printed in RQ120 RQ20.1 RQ35.1
(Delivery Ticket). RQ500 RQ961
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 RQ10.1 RQ10.3
(Requisition Returns). RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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 RQ961
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. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-ZERO-COST-FL Alpha 1 DR100 IC141
Zero Cost Flag Zero Unit Cost Line Flag - setting this IC142 IC83.1
flag to "Y" will ignore the edit that RQ10.1 RQ10.3
requires a unit cost to be entered for RQ11.1 RQ20.1
an inventory item. Sometimes the actual RQ35.1 RQ500
unit cost for an item is zero and this RQ961 WH20.7
flag will allow that item to be
requested.
Y
N
RLN-NO-CHARGE-FL Alpha 1 DR100 IC141
No Charge Flag This field indicates the item's unit IC142 IC83.1
cost is zero. This defaults to No. If RQ10.1 RQ10.3
Yes, this field prevents the system from RQ11.1 RQ20.1
pricing the item. No charge invoices RQ35.1 RQ500
are not passed to the Accounts Payable RQ961 WH20.7
system for payment.
Y
N
RLN-VPRI-UOM Alpha 4 DR100 IC141
Vendor Price Unit This is the Vendor Pricing Unit of IC142 IC83.1
of Measure Measure defined in PO13.1 (Item/Vendor). RQ10.1 RQ10.3
Only inventory and nonstock items have RQ11.1 RQ125
a vendor price unit of measure. RQ20.1 RQ20.2
RQ35.1 RQ500
RQ961 WH20.7
RLN-VPRI-UOM-MULT Signed 13.7 DR100 IC141
Vendor Price UOM This is the Vendor Pricing Unit of IC142 IC83.1
Multiplier Measure multiplier, which is used to RQ10.1 RQ10.3
convert quantity and unit cost to stock RQ11.1 RQ125
unit of measure. RQ20.1 RQ20.2
RQ35.1 RQ500
RQ961 WH20.7
RLN-COST-CD Alpha 1 DR100 IC141
Unit Cost Origin Unit cost origin code IC142 IC83.1
Code E = Entered RQ10.1 RQ10.3
L = Last Cost RQ11.1 RQ20.1
Q = Quote RQ35.1 RQ500
S = Standard Order WH20.7
O = Order Entry
C = Contract
N = Last PO Created
Y = Copied from PO
P = Override contract
D = Standard Cost
A = Average Cost
RLN-CONTRACT-NBR Alpha 14 DR100 IC141
Contract Number This is a number to indicate to the IC142 IC83.1
vendor which price agreement an item or RQ10.1 RQ10.3
items are operating under. RQ11.1 RQ20.1
RQ35.1 RQ500
If this number is entered on or WH20.7
defaulted to a purchase order line, it
is an indication of the vendor contract
that line is tied to. The contract
number can be defaulted to the purchase
order line. The default occurs by
leaving the field blank when creating
the purchase order and having the system
attempt to find a contract number from a
contract-type standard order. The system
finds the number based on the item
number for the line and vendor for the
purchase order.
If no contract number is entered on or
defaulted to the line from a contract
type standard order, a contract number
entered on the purchase order header
will default to the line.
A contract number can also be tied to a
blanket type standard order, and any
purchase orders created from the blanket
order will have the contract number from
the blanket on the header and lines.
The contract number can also be
defaulted to a requisition line as the
requisition line is created. The
contract number will then be carried
over to the purchase order line that is
created from the requisition line.
RLN-CANCEL-BO-FL Alpha 1 BL92.1 DR100
Cancel Back Order This flag indicates whether the IC141 IC142
Flag backordered quantity is to be canceled IC83.1 OE114
and the line is to be considered closed. RQ10.1 RQ10.3
N RQ11.1 RQ120
Y = *BO CANCELLED* RQ20.1 RQ35.1
RQ500 RQ961
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
RLN-VENDOR Alpha 9 DR100 IC141
Vendor ID The vendor's identification code. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ125
RQ20.1 RQ35.1
RQ500 RQ961
WH20.7
RLN-PURCH-FR-LOC Alpha 4 DR100 IC141
Purchase From The vendor's purchase from location. IC142 IC83.1
Location Code RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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 RQ10.1 RQ10.3
items that a requester can enter on a RQ11.1 RQ20.1
requisition. RQ35.1 RQ500
RQ961 WH20.7
RLN-PURCH-MINOR Alpha 4 DR100 IC141
Purch Minor Purchase Class Minor Field. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-BUYER Alpha 3 DR100 IC141
Buyer Buyer code, defaulted from the IC142 IC83.1
Requisition Header or Item Location file RQ10.1 RQ10.3
if the buyer code is blank. RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-FROM-COMPANY Numeric 4 DR100 IC141
From-Company The company from which the requisition IC142 IC83.1
gets replenished. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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 RQ10.1 RQ10.3
order ship to location that receives the RQ11.1 RQ20.1
items. RQ35.1 RQ500
RQ961 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 RQ10.1 RQ10.3
noninventory location. RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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. RQ10.1 RQ10.3
This date defaults from the requested RQ11.1 RQ20.1
delivery date on the requisition header. RQ35.1 RQ500
RQ961 WH20.7
RLN-LATE-DL-DATE Numeric 8 (yyyymmdd) DR100 IC141
Late Delivery Date This field contains the late delivery IC142 IC83.1
date. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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 RQ10.1 RQ10.2
multiple line distributions for RQ10.3 RQ11.1
noninventory items. The code is not RQ20.1 RQ35.1
valid for inventory tracked items. When RQ500 RQ961
the requested line is converted to a WH20.7
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-REFERENCE Alpha 10 (Lower Case) DR100 IC141
Reference This field is not used. It will be IC142 IC83.1
removed in a future release. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
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 RQ10.1 RQ10.3
line is picked in WH30.1 (Picking RQ11.1 RQ20.1
Feedback by Shipment). RQ35.1 RQ500
IS = Issues RQ961 WH20.7
DT = Direct Transfer
IT = Intransit Transfer
RLN-IF-REF-NBR Numeric 9 DR100 IC141
Reference Number This field contains an internally IC142 IC83.1
generated reference number used by the RQ10.1 RQ10.3
Requisition system. It is used to link RQ11.1 RQ120
the requisition line with the PO RQ125 RQ20.1
Interface record. RQ20.2 RQ20.4
RQ35.1 RQ500
RQ961 WH20.7
RLN-PO-NUMBER Alpha 7 (Right Justified) DR100 IC141
PO Number This is the purchase order to which IC142 IC83.1
this line has been assigned. PO100 RQ10.1
RQ10.3 RQ11.1
RQ120 RQ20.1
RQ20.4 RQ35.1
RQ500 RQ961
WH20.7
RLN-PO-RELEASE Numeric 6 DR100 IC141
PO Release Number This is the purchase order release IC142 IC83.1
(created from a Blanket or Standing PO100 RQ10.1
order) to which this line has been RQ10.3 RQ11.1
assigned. RQ120 RQ20.1
RQ20.4 RQ35.1
RQ500 RQ961
WH20.7
RLN-PO-RELEASE-3 Derived
Po Release 3 The PO release number converted to a
three-character field for purposes of
display and printing the shorter field.
RLN-PO-LINE-NBR Numeric 6 DR100 IC141
PO Line Number The PO line number to which this IC142 IC83.1
requisition line has been assigned. PO100 RQ10.1
RQ10.3 RQ11.1
RQ120 RQ20.1
RQ20.4 RQ35.1
RQ500 RQ961
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 RQ10.1 RQ10.3
location and to extract the tax data RQ11.1 RQ20.1
from the Tax file based on this tax RQ35.1 RQ500
code. This field value is passed to the RQ961 WH20.7
PO when the PO is created.
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 RQ10.1 RQ10.3
location. This field value is passed to RQ11.1 RQ20.1
the PO when the PO is created. RQ35.1 RQ500
N = Nontaxable RQ961 WH20.7
Y = Taxable
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 RQ10.1 RQ10.3
when it is purchased. This field value RQ11.1 RQ20.1
is passed to the PO when the PO line is RQ35.1 RQ500
created. RQ961 WH20.7
N = No
Y = Yes
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 RQ10.1 RQ10.3
a PO. RQ11.1 RQ20.1
N = No RQ35.1 RQ500
Y = Yes RQ961 WH20.7
RLN-LAST-COMM-SEQ Numeric 3 DR100 IC141
Last Comment This is the sequence number of the last IC142 IC83.1
Sequence Number comment line entered for this RQ10.1 RQ10.3
requisition line. RQ10.5 RQ11.1
RQ20.1 RQ35.1
RQ500 RQ961
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 RQ10.1 RQ10.3
used for multiple bins, lots, or serial RQ11.1 RQ20.1
tracked items. RQ35.1 RQ500
RQ961 WH20.7
RLN-KIT-ITEM Alpha 32 DR100 IC141
Kit Item Parent item made up of component IC142 IC83.1
items. Not currently used. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-COMPONENT-SEQ Numeric 3 DR100 IC141
Component Sequence Kit component sequence number. For IC142 IC83.1
Number future use. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-VEN-ITEM Alpha 32 DR100 IC141
Vendor Item The vendor's identifier for this item. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-STATUS Numeric 1 BL92.1 DR100
Status This is the processing status of a IC141 IC142
requisition line. IC83.1 OE114
0 = Open RQ10.1 RQ10.3
9 = Closed RQ11.1 RQ12.1
RQ120 RQ13.1
RQ20.1 RQ35.1
RQ500 RQ961
WH130 WH132
WH190 WH20.7
WH30.1 WH30.2
WH30.3 WH31.1
WH31.2 WH31.3
WH32.1 WH32.2
WH32.3 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
RLN-BIN Alpha 7 DR100 IC141
Bin This field contains a storage area for IC142 IC83.1
an item or any number of items. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-CURRENCY-CD Alpha 5 DR100 IC141
Currency Code This is the currency code for this IC142 IC83.1
requisition. Not currently used, the RQ10.1 RQ10.3
currency of the requisition is the base RQ11.1 RQ20.1
currency defined in the General Ledger RQ35.1 RQ500
company. RQ961 WH20.7
RLN-CREATE-PO-CD Alpha 1 DR100 IC141
Create Purchase This code indicates whether this IC142 IC83.1
Order Code inventory item is to be purchased using PO30.1 PO35.1
a PO instead of picked from inventory. PO530 RQ10.1
All noninventory items have this flag RQ10.3 RQ11.1
set to (Y)es. RQ20.1 RQ35.1
N = Pick From Inventory RQ500 RQ961
Y = Create PO WH20.7
R = PO Received, Now Pick
RLN-ZIP-PO-FL Alpha 1 DR100 IC141
Zip Po Fl This flag indicates that this line on IC142 IC83.1
the requisition can be selected to be RQ10.1 RQ10.3
automatically converted into a purchase RQ11.1 RQ20.1
order by RQ125 (PO Generation).. RQ35.1 RQ500
Y = Yes RQ961 WH20.7
N = No
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 RQ10.1 RQ10.3
when the PO is created. RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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 RQ10.1 RQ10.3
when the PO is created. RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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 RQ10.1 RQ10.3
when the PO is created. RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-HOLD-CD Alpha 4 DR100 IC141
Hold Cd This field is not used. It will be IC142 IC83.1
removed in a future release. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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 RQ10.1 RQ10.3
0 to 99, with 99 being the highest. This RQ11.1 RQ20.1
field defaults to 50. This field is RQ35.1 RQ500
used in the Warehouse module to RQ961 WH20.7
determine the order in which inventory
demand gets allocated.
RLN-DELIVER-TO Alpha 30 DR100 IC141
Deliver To Name This field can be used to specify where IC142 IC83.1
to deliver the items. This field prints RQ10.1 RQ10.3
on the delivery ticket when you run RQ11.1 RQ20.1
RQ120 (Delivery Ticket). RQ35.1 RQ500
RQ961 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. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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 RQ10.1 RQ10.3
manufacturer is tied to an item. RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-PRICE Signed 15.2 DR100 IC141
Price This field is not used. It will be IC142 IC83.1
removed in a future release. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-CHARGE-NBR Alpha 10 DR100 IC141
Charge Number This field is not used. It will be IC142 IC83.1
removed in a future release. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-CHARGEABLE-FL Alpha 1 DR100 IC141
Chargeable Flag This field is not used. It will be IC142 IC83.1
removed in a future release. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 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 RQ10.1 RQ10.2
invoice. RQ10.3 RQ11.1
RQ20.1 RQ35.1
RQ500 RQ961
WH20.7
RLN-OPEN-RQ-QTY Derived
Open Rq Qty This quantity is the quantity that is
still open on the line. It is the
ordered quantity minus the delivered
quantity.
RLN-KIT-FL Alpha 1 DR100 IC141
Kit Flag This field is used to indicate that IC142 IC83.1
this transaction is for kit item. RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-KIT-ALLOC-FL Alpha 1 DR100 IC141
Kit Allocation Flag For future use. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ20.1
RQ35.1 RQ500
RQ961 WH20.7
RLN-REQ-NUMBER-A Derived
Req Number A This field is used to connect Warehouse
system demand records with the
requisitions to facilitate Drill Around
activity.
RLN-ACCT-UNIT Alpha 15 DR100 IC141
Accounting Unit The accounting unit is a shorthand IC142 IC83.1
notation representing the variable level RQ10.1 RQ10.3
number. When used in the General Ledger RQ11.1 RQ20.1
Account Master file, the accounting unit RQ35.1 RQ500
must be defined in the General Ledger RQ961
Names file as a posting accounting unit.
RLN-ACCOUNT Numeric 6 DR100 IC141
Account This field along with the accounting IC142 IC83.1
unit and subaccount make up the location RQ10.1 RQ10.3
(account) where amounts and other RQ11.1 RQ20.1
account information is stored. RQ35.1 RQ500
RQ961
RLN-SUB-ACCT Numeric 4 DR100 IC141
Subaccount This field contains the subaccount from IC142 IC83.1
your general ledger chart of accounts RQ10.1 RQ10.3
that was charged with the amount carried RQ11.1 RQ20.1
on this record. RQ35.1 RQ500
RQ961
RLN-ACTIVITY Alpha 15 DR100 IC141
Activity Activities are the processes or IC142 IC83.1
procedures that produce work. Cost RQ10.1 RQ10.2
objects (products, services, customers, RQ10.3 RQ11.1
and so on) are the reasons for RQ20.1 RQ35.1
performing the activity. Activities and RQ500 RQ961
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
When you add or change a requisition
line distribution for a specific
activity, the Requisition system logic
checks the activity budget. If the
activity is assigned to an activity
group for which a budget is defined and
if the distribution will result in
going over the activity budget, an
error message displays: "Add or change
complete; activity budget will be
exceeded." This message only displays
prior to release of the requisition.
If no overage of the activity budget
will result, the system creates a budget
commitment record when you release the
requisition.
RLN-ACCT-CATEGORY Alpha 5 DR100 IC141
Account Category Account categories are groupings of IC142 IC83.1
costs, revenues, or a combination of RQ10.1 RQ10.2
both used for reporting and inquiries RQ10.3 RQ11.1
for activities in the Activity RQ20.1 RQ35.1
Management system. All transactions are RQ500 RQ961
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
RLN-ASSET-TEMPLATE Alpha 10 DR100 IC141
Asset Template A user-defined asset template IC142 IC83.1
identifies general asset creation RQ10.1 RQ10.3
parameters that you can use to quickly RQ11.1 RQ20.1
add assets with minimal keying. Using a RQ35.1 RQ500
template lets you default many data RQ961 WH20.7
items associated with a new asset.
You can use an asset template to
process quick asset additions in AM20.1
(Quick Addition) and to create assets
and asset books from Accounts Payable
and Activity Management interface
information. Asset templates are
required if you define new assets as a
result of transactions interfaced from
the Purchase Order or Accounts Payable
systems.
RLN-ASSET Numeric 10 DR100 IC141
Asset Number The asset number contains up to ten IC142 IC83.1
numeric characters that uniquely RQ10.1 RQ10.3
identify an asset. Assets are RQ11.1 RQ20.1
automatically numbered system-wide. RQ35.1 RQ500
RQ961 WH20.7
REQLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RLNSET1 COMPANY This index is used to access a BL92.1 DR100
REQ-NUMBER requisition line record by company, IC141 IC142
LINE-NBR requisition number, and line number. IC83.1 OE114
PO100 RQ10.1
RQ10.2 RQ10.3
RQ10.5 RQ11.1
RQ111 RQ12.1
RQ120 RQ13.1
RQ20.1 RQ230
RQ235 RQ240
RQ300 RQ35.1
RQ39.1 RQ39.2
RQ39.3 RQ40.1
RQ41.1 RQ44.1
RQ44.2 RQ50.1
...
RLNSET2 FROM-COMPANY This index is used to access a RQ120
FROM-LOCATION requisition line record by company,
COMPANY requesting location, requisition number,
REQ-LOCATION line number, from company, and from
REQ-NUMBER location.
LINE-NBR KeyChange, Subset
Where SHIPPED-QTY > Zeroes
RLNSET3 FROM-COMPANY This index is used to access a PO100 RQ20.2
FROM-LOCATION requisition line record by from company, RQ20.4
ITEM from location, item, requisition number,
REQ-NUMBER and line number.
LINE-NBR KeyChange, Subset
Where ITEM-TYPE != "I"
Or CREATE-PO-CD = "Y"
RLNSET4 COMPANY This index is used to access a BL92.1 IN20.1
IF-REF-NBR requisition line record by company, if OE10.1 OE10.2
REQ-DEL-DATE reference number, requested delivery OE10.3 OE10.4
REQ-NUMBER date, requisition number, and line OE10.5 OE10.6
LINE-NBR number. OE10.7 OE10.8
KeyChange, Subset OE11.1 OE11.4
Where IF-REF-NBR != Zeroes OE11.8 OE11.9
OE110 OE113
OE114 OE129
OE14.4 OE15.1
OE15.2 OE15.3
OE15.4 OE15.5
OE15.7 OE510
OE810 OE920
PO100 PO20.1
...
RLNSET5 COMPANY This index is used to access a 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 RQ125
VENDOR requisition line record for a specific
PURCH-FR-LOC vendor and purchase from location.
REQ-NUMBER KeyChange, Subset
LINE-NBR Where CREATE-PO-CD = "Y"
ITEM And IF-REF-NBR = Zeroes
RLNSET8 COMPANY This index is used to access a PO121 RQ20.4
PO-NUMBER requisition line record used to create a
PO-RELEASE specific purchase order line.
PO-LINE-NBR KeyChange, Subset
REQ-NUMBER Where PO-NUMBER != Spaces
LINE-NBR
REQLINE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
From Location ICLOCATION Required
RLN-FROM-COMPANY -> ICL-COMPANY
RLN-FROM-LOCATION -> ICL-LOCATION
Ic Company ICCOMPANY Required
RLN-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-COMPANY -> ITL-COMPANY
RLN-FROM-LOCATION -> ITL-LOCATION
RLN-ITEM -> ITL-ITEM
Mmuaval MMUAVAL Not Required
RLN-COMPANY -> MUA-COMPANY
"RQ" -> MUA-SYSTEM-CD
Spaces -> MUA-LOCATION
"IS" -> MUA-DOC-TYPE
Spaces -> MUA-DOC-NBR
RLN-REQ-NUMBER -> MUA-DOC-NBR-NUM
RLN-LINE-NBR -> MUA-LINE-NBR
Po Company POCOMPANY Required
When RLN-ITEM-TYPE != "I"
RLN-COMPANY -> PCY-COMPANY
Po Item Vendor POITEMVEN Not Required
RLN-COMPANY -> PIV-COMPANY
RLN-ITEM -> PIV-ITEM
RLN-VENDOR -> PIV-VENDOR
Pointerfac POINTERFAC Required
RLN-COMPANY -> PIF-COMPANY
"RQ" -> PIF-ORIGIN-CD
RLN-IF-REF-NBR -> PIF-IF-REF-NBR
Zeroes -> PIF-ORDER-NBR
Zeroes -> PIF-LINE-NBR
Zeroes -> PIF-SEQ
Poline POLINE Not Required
Valid When RLN-PO-NUMBER != Spaces
RLN-COMPANY -> PLI-COMPANY
RLN-PO-NUMBER -> PLI-PO-NUMBER
RLN-PO-RELEASE -> PLI-PO-RELEASE
RLN-PO-LINE-NBR -> PLI-LINE-NBR
Purchase Order PURCHORDER Required
When RLN-PO-NUMBER != Spaces
RLN-COMPANY -> PCR-COMPANY
RLN-PO-NUMBER -> PCR-PO-NUMBER
RLN-PO-RELEASE -> PCR-PO-RELEASE
Req Location RQLOC Required
RLN-COMPANY -> RQL-COMPANY
RLN-REQ-LOCATION -> RQL-REQ-LOCATION
Requisition REQHEADER Required
RLN-COMPANY -> RQH-COMPANY
RLN-REQ-NUMBER -> RQH-REQ-NUMBER
Vendor APVENMAST Not Required
ICC-ITEM-GROUP -> VEN-VENDOR-GROUP
RLN-VENDOR -> VEN-VENDOR
Whdemand WHDEMAND Required
RLN-FROM-COMPANY -> WDM-COMPANY
"RQ" -> WDM-SYSTEM-CD
WDH-DOC-NBR -> WDM-DOC-NBR
RLN-LINE-NBR -> WDM-LINE-NBR
Zeroes -> WDM-COMPONENT-SEQ
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 Delete Cascades
RLN-COMPANY -> MMD-COMPANY
"RQ" -> MMD-SYSTEM-CD
Spaces -> MMD-LOCATION
"IS" -> MMD-DOC-TYPE
Spaces -> MMD-DOC-NBR
RLN-REQ-NUMBER -> MMD-DOC-NBR-NUM
RLN-LINE-NBR -> MMD-LINE-NBR
RLN-COMPONENT-SEQ -> MMD-COMPONENT-SEQ
Spaces -> MMD-AOC-CODE
MMD-LINE-SEQ
Itemsub ITEMSUB
ICC-ITEM-GROUP -> ITS-ITEM-GROUP
RLN-ITEM -> ITS-ITEM
ITS-SUB-ITEM
Line Comments RQCOMMENTS Delete Cascades
RLN-COMPANY -> RCM-COMPANY
RLN-REQ-NUMBER -> RCM-REQ-NUMBER
RLN-LINE-NBR -> RCM-LINE-NBR
RCM-SEQ
Po Model POINTERFAC
RLN-COMPANY -> PIF-COMPANY
RLN-FROM-LOCATION -> PIF-LOCATION
RLN-ITEM -> PIF-ITEM
PIF-EARLY-DL-DATE
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
|