REQLINE – Requisition Line

System
Requisitions (RQ)
Prefix
RLN
Primary key
COMPANY, REQ-NUMBER, LINE-NBR
Fields
113
Updated by
242 programs
Referenced by
47 programs

REQLINE is the Requisition Line table in Lawson Requisitions (prefix RLN). It is indexed by COMPANY, REQ-NUMBER, LINE-NBR (RLNSET1); alternate indexes: RLNSET10, RLNSET11, RLNSET12, RLNSET2, RLNSET3, RLNSET4, RLNSET5, RLNSET6 and 3 more. It is related 1:1 to APCOMPANY, COMMCODES, ICLOCATION, HCPATPROC, ICCOMPANY, ITEMMAST, ITEMLOC, MMUAVAL and 12 more and 1:M to MMDIST, ITEMSUB, WHLOCRULE, POINTAUDIT, POLINESRC, RQAOCDTL, RQAUDIT, RQLINEDTL and 3 more. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 234 more and referenced by AM19.1, AM19.2, AP115, AP220, AP305, CX05.1, CX05.2, CX805 and 39 more. The table has 113 fields, 12 indexes and 31 documented relations.

About REQLINE

This file contains the line item information for the requisition.

Fields (113)

Column = COBOL field name without the RLN- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#RLN-COMPANY PK
COMPANY		Numeric 4Enter the company number defined in Company (IC01.1) or Company (MA01.1).DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-REQ-NUMBER PK
REQ_NUMBER		Numeric 7This is the requisition number. Requisition numbers are automatically assigned if the company is set up for automatic numbering in IC01.1 (Company) or MA00.1 (Company). Otherwise, 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.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-REQ-NUMBER-A SET2 SET9
REQ_NUMBER_A		Alpha 10 (Right Justified)This field is used to connect Warehouse system demand records with the requisitions to facilitate Drill Around activity.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-LINE-NBR PK
LINE_NBR		Numeric 6This is the system-assigned line number for the requested line. The system increments this by one with each requested line.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-ITEM SET10 SET11 SET3 SET5 SET6 SET8
ITEM		Alpha 32This is the item number to be requested. If you are requesting a Nonstock item, this item must be defined in IC11 (Item Master). If the requested item is an Inventory item, the item must be defined in IC11 (Item Master) and 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.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-ITEM-TYPE SET7
ITEM_TYPE		Alpha 1Enter the type of item requested. An inventoried item is maintained in inventory and must be defined in IC11 (Item Master) and IC12 (Item Location) for the "from" location. 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
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-SERVICE-CODE
SERVICE_CODE		Alpha 1" " = Not Service Item
  • Q Quantity
  • A Amount
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)Enter the description of the item. Use IC11 (Item Master) to enter the description for inventory and nonstock type items. If the item type is either an I or an N, the description can not be changed. If the item is a special order (X) or service (S) item, you must enter a description of the requested item.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +12 more
#RLN-QUANTITY
QUANTITY		Signed 13.4Enter the requested quantity. If left blank, this defaults to 1.AP20.1, AP20.2, AP20.3, AP20.4, AP20.5, AP20.7, AP25.1, AP25.2 +52 more (list truncated in source)
#RLN-ENTERED-UOM SET10
ENTERED_UOM		Alpha 4This field contains the valid stock unit of measure for this item.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-ENT-UOM-MULT
ENT_UOM_MULT		Signed 13.7This field contains the multiplier for converting this unit of measure to the stock unit of measure.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-RETURN-QTY
RETURN_QTY		Signed 13.4This field contains the desired quantity.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-DTL-RET-QTY
DTL_RET_QTY		Signed 13.4This is the total of the returned quantity from the detail records. Detail records are created for multiple bins, lot, or serial tracked items.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +7 more
#RLN-UNIT-COST
UNIT_COST		Signed 18.5This field contains the unit cost in base currency. When the PO is created, then the cost on the PO will be reflected in transaction currency.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-COST-OPTION
COST_OPTION		Alpha 1—
  • 1 Cost Required
  • 2 No Charge
  • 3 Vendor Determined
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-OVERIDE-CST-FL
OVERIDE_CST_FL		Alpha 1—
  • Y Yes
  • N No
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-CREATE-PO-FL
CREATE_PO_FL		Alpha 1—
  • Y Yes
  • N No
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-AGREEMENT-REF SET10
AGREEMENT_REF		Alpha 30—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-VENDOR
VENDOR		Alpha 9 (Right Justified)The vendor's identification code.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PURCH-FR-LOC
PURCH_FR_LOC		Alpha 4The vendor's purchase from location.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PURCH-MAJOR
PURCH_MAJOR		Alpha 4Purchase Class Major Field. This field can be used to control the classes of items that a requester can enter on a requisition.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PURCH-MINOR
PURCH_MINOR		Alpha 4Purchase Class Minor Field.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-BUYER
BUYER		Alpha 3Buyer code, defaulted from the Requisition Header or Item Location file if the buyer code is blank.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-FROM-COMPANY SET3 SET9
FROM_COMPANY		Numeric 4The company from which the requisition gets replenished.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-FROM-LOCATION SET3
FROM_LOCATION		Alpha 5This field contains a valid stocking location within the company inventory.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-REQ-LOCATION SET11 SET5 SET6
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-REQ-DEL-DATE SET5
REQ_DEL_DATE		Numeric 8 (yyyymmdd)This is the date that the requester would like the items to be delivered. This date defaults from the requested delivery date on the requisition header.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-LATE-DL-DATE
LATE_DL_DATE		Numeric 8 (yyyymmdd)This field contains the late delivery date.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-CREATION-DATE SET11 SET12 SET6
CREATION_DATE		Numeric 8 (yyyymmdd)This is the date that this line was added to the requisition.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-DIST-CODE
DIST_CODE		Alpha 9This user-defined code is defined in the Terms system. The code allows multiple line distributions for noninventory items. The code is not valid for inventory tracked items. When the requested line is converted to a 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.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +12 more
#RLN-IC-TRANS-TYPE
IC_TRANS_TYPE		Alpha 2This code indicates the type of inventory transaction created when the line is picked in WH30 (Picking Feedback).
  • IS Issues
  • DT Direct Transfer
  • IT Intransit Transfer
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PO-CODE
PO_CODE		Alpha 4This is the purchase order code.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PURCH-TAX-CD
PURCH_TAX_CD		Alpha 10This code is used to determine if this item is taxable when purchased at this location and to extract the tax data from the Tax file based on this tax code. This field value is passed to the PO when the PO is created.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PURCH-TAX-FL
PURCH_TAX_FL		Alpha 1This flag specifies if this item is taxable when it is purchased for this location. This field value is passed to the PO when the PO is created.
  • N Nontaxable
  • Y Taxable
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-CERT-REQ-FL
CERT_REQ_FL		Alpha 1This flag indicates whether a certification is required for this line when it is purchased. This field value is passed to the PO when the PO line is created.
  • N No
  • Y Yes
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-INSP-REQ-FL
INSP_REQ_FL		Alpha 1This flag indicates whether this item has to be inspected when received using a PO.
  • N No
  • Y Yes
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-LAST-RET-SEQ
LAST_RET_SEQ		Numeric 3This field contains the record sequence number.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-VEN-ITEM SET10
VEN_ITEM		Alpha 32The vendor's identifier for this item.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-STATUS
STATUS		Numeric 1This is the processing status of a requisition line.
  • 0 Unreleased
  • 1 Released
  • 8 Rejected
  • 9 Processed
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-CLOSED-FL
CLOSED_FL		Alpha 1The Closed Flag.
  • Y Yes
  • N No
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RLN-BIN
BIN		Alpha 7This field contains a storage area for an item or any number of items.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +12 more
#RLN-PO-USER-FLD-2
PO_USER_FLD_2		Alpha 2Purchase order line user defined field. This field is passed to the PO line when the PO is created.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PO-USER-FLD-4
PO_USER_FLD_4		Alpha 30 (Lower Case)Purchase order line user defined field. This field is passed to the PO line when the PO is created.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PO-USER-FLD-6
PO_USER_FLD_6		Alpha 15 (Lower Case)Purchase order line user defined field. This field is passed to the PO line when the PO is created.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-USER-DATE-3
USER_DATE_3		Numeric 8 (yyyymmdd)This field displays the system date when this was created.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-USER-DATE-4
USER_DATE_4		Numeric 8 (yyyymmdd)This field displays the system date when this was created.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-ALLOC-PRI
ALLOC_PRI		Numeric 2This is the allocation priority for this requisition. Valid values are from 0 to 99, with 99 being the highest. This field defaults to 50. This field is used in the Warehouse module to determine the order in which inventory demand gets allocated.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-DELIVER-TO
DELIVER_TO		Alpha 30 (Lower Case)This field can be used to specify where to deliver the items. This field prints on the delivery ticket when you run Delivery Ticket Print program.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-MANUF-CODE
MANUF_CODE		Alpha 4This is a user defined code that indicates the manufacturer of an item.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-MANUF-DIVISION
MANUF_DIVISION		Alpha 4This is a user defined code that indicates which division of a manufacturer is tied to an item.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-MANUF-NBR
MANUF_NBR		Alpha 35This is the identifier that the manufacturer has assigned to an item.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-LAST-DIST-SEQ
LAST_DIST_SEQ		Numeric 4An automatically assigned sequence number.DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +12 more
#RLN-NEW-REQ
NEW_REQ		Alpha 1—
  • N No
  • Y Yes
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-FILL-OR-KILL
FILL_OR_KILL		Alpha 1—
  • F Fill Backorders
  • K Kill Backorders
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-KILL-QUANTITY
KILL_QUANTITY		Signed 13.4—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +13 more
#RLN-ENTERED-ITEM
ENTERED_ITEM		Alpha 25—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-COST-CD
COST_CD		Alpha 1Unit cost origin code
  • E Entered
  • L Last Cost
  • C Contract
  • T Catalog/Quote
  • B Blanket
  • P Last PO Created
  • I Inventory Cost
  • G Punchout
  • Y Tier - Company Participant
  • N Tier - IC Location Participant
  • Q Tier - Req Loc Participant
  • W Website
  • V Procurement Template Agrmt Ref
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-ENTRY-FL
ENTRY_FL		Alpha 1—
  • 1 Item
  • 2 UPC
  • 3 UPN1
  • 4 UPN2
  • 5 NDC
  • 6 SKU
DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-RQSRC-MACHINE
RQSRC_MACHINE		Alpha 6DROYAL ESIOB HBOC OMNICL PAREXC PERSE PYXIS INTER EAMDR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PAR-ORDER-ID
PAR_ORDER_ID		Alpha 20—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-APPROVED-FL
APPROVED_FL		Alpha 1—RQ13.1, RQ13.2
#RLN-CAP-TECH-FLAG
CAP_TECH_FLAG		Numeric 1—
  • 0 None
  • 1 Capital
  • 2 Technical
  • 3 Both
—
#RLN-PFLOW-APRV-LVL
PFLOW_APRV_LVL		Alpha 20—RQ13.2
#RLN-PUNCHOUT-ID
PUNCHOUT_ID		Alpha 64—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PFLOW-CREATED
PFLOW_CREATED		Numeric 1—
  • 0 PFlow work unit not created
  • 1 PFlow work unit created
RQ13.2
#RLN-TRAN-UNIT-COST
TRAN_UNIT_COST		Signed 18.5—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-TRAN-CURR-CODE
TRAN_CURR_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-CNV-RATE
CNV_RATE		Signed 14.7Currency conversion rate at Purchase Order entry time.DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-COMMIT-REMAIN
COMMIT_REMAIN		Signed 13.4This field contains the desired quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RLN-RQ-SOURCE
RQ_SOURCE		Numeric 2—
  • 00 Upgrade
  • 01 IC142
  • 02 IC141
  • 03 IC83
  • 04 RQ35
  • 05 RQ500
  • 06 RQC
  • 07 RQ10
  • 08 DR100
  • 09 Website
  • 99 Mobile Requisitions
  • 97 Perfect Commerce
  • 98 SciQuest
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-SS-EVENT-REQD
SS_EVENT_REQD		Numeric 1—
  • 0 No
  • 1 Yes
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-COMMODITY-CODE
COMMODITY_CODE		Alpha 35—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-P-CARD-FLAG
P_CARD_FLAG		Numeric 1——
#RLN-PCARD-NBR
PCARD_NBR		Alpha 16——
#RLN-CONTRACT-GROUP
CONTRACT_GROUP		Alpha 4—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-CM-CONTRACT
CM_CONTRACT		Numeric 15—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-TIER
TIER		Alpha 4—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-PREFERRED-FLAG
PREFERRED_FLAG		Numeric 1—
  • 0 No
  • 1 Contract
  • 2 Manufacturer
  • 3 Contract and Manufacturer
DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-DER-ORIGIN-CD
DER_ORIGIN_CD		Derived——
#RLN-DER-REQUESTER
DER_REQUESTER		Derived——
#RLN-DER-CLOSE-STAT
DER_CLOSE_STAT		Derived——
#RLN-APPROVAL-VAL
APPROVAL_VAL		DerivedThis 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.—
#RLN-PVN-OBJ-ID
PVN_OBJ_ID		Numeric 12—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-PART-SEQ-NBR
PART_SEQ_NBR		Numeric 6—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-PIF-CXL-QTY
PIF_CXL_QTY		Signed 13.4—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RLN-PROD-TAX-CAT
PROD_TAX_CAT		Alpha 15—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-LOCATION-RULE
LOCATION_RULE		Alpha 12—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-RELEASED-DATE
RELEASED_DATE		Numeric 8 (yyyymmdd)—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.3 +9 more
#RLN-RELEASED-TIME
RELEASED_TIME		Numeric 8—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.3 +9 more
#RLN-REL-OPER-ID
REL_OPER_ID		Alpha 10—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.3 +9 more
#RLN-APR-REJ-DATE
APR_REJ_DATE		Numeric 8 (yyyymmdd)—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.3 +9 more
#RLN-APR-REJ-TIME
APR_REJ_TIME		Numeric 8—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.3 +9 more
#RLN-APR-REJ-OPR-ID
APR_REJ_OPR_ID		Alpha 10—DR100, IC141, IC142, IC83.1, PO100, PO23.1, RQ10.1, RQ10.3 +9 more
#RLN-GTIN
GTIN		Numeric 14—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PO-USER-FLD-7
PO_USER_FLD_7		Alpha 10 (Lower Case)——
#RLN-EAM-OPER-NBR
EAM_OPER_NBR		Numeric 4—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-EAM-SEQ-NBR
EAM_SEQ_NBR		Numeric 4—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-EAM-WO-NBR
EAM_WO_NBR		Numeric 8—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-CREATION-TIME
CREATION_TIME		Numeric 8—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-PATIENT-LNAME
PATIENT_LNAME		Alpha 30 (Lower Case)——
#RLN-PATIENT-FNAME
PATIENT_FNAME		Alpha 15 (Lower Case)——
#RLN-PATIENT-MINIT
PATIENT_MINIT		Alpha 1——
#RLN-PAT-VISIT-NBR
PAT_VISIT_NBR		Alpha 12——
#RLN-SERIAL
SERIAL		Alpha 16——
#RLN-SS-EVENT-NBR
SS_EVENT_NBR		Numeric 8——
#RLN-PUNCHOUT-UGNAM
PUNCHOUT_UGNAM		Alpha 40 (Lower Case)—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-CREATED-BY
CREATED_BY		Alpha 10—DR100, IC141, IC142, IC83.1, RQ10.1, RQ10.3, RQ10.4, RQ10.5 +4 more
#RLN-LAST-UPDT-DATE SET12
LAST_UPDT_DATE		Numeric 8 (yyyymmdd)—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RLN-LAST-UPDT-TIME
LAST_UPDT_TIME		Numeric 8—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RLN-LAST-UPDATE-BY
LAST_UPDATE_BY		Alpha 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RLN-HPP-OBJ-ID
HPP_OBJ_ID		Numeric 12—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +12 more
#RLN-CN-CODE
CN_CODE		Alpha 2—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more
#RLN-GLBL-LINE-TYPE
GLBL_LINE_TYPE		Alpha 15—DR100, IC141, IC142, IC83.1, PO100, PO23.1, POIF.1, POIG.1 +11 more

Indexes (12)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
RLNSET1
  1. COMPANY
  2. REQ-NUMBER
  3. LINE-NBR
PrimaryAM19.1, AM19.2, AP115, AP125, AP126, AP131, AP20.1, AP20.2 +22 more (list truncated in source)
RLNSET10
  1. COMPANY
  2. REQ-NUMBER
  3. AGREEMENT-REF
  4. ITEM
  5. VEN-ITEM
  6. ENTERED-UOM
  7. LINE-NBR
KeyChange, SubsetWhere (AGREEMENT-REF != Spaces)AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RLNSET11
  1. COMPANY
  2. REQ-LOCATION
  3. ITEM
  4. CREATION-DATE ↓
  5. REQ-NUMBER ↓
  6. LINE-NBR
KeyChange—
RLNSET12
  1. COMPANY
  2. REQ-NUMBER
  3. CREATION-DATE
  4. LAST-UPDT-DATE
  5. LINE-NBR
KeyChange—
RLNSET2
  1. COMPANY
  2. REQ-NUMBER-A
  3. LINE-NBR
SubsetWhere ITEM-TYPE = "I"AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RLNSET3
  1. FROM-COMPANY
  2. FROM-LOCATION
  3. ITEM
  4. REQ-NUMBER
  5. LINE-NBR
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RLNSET4
  1. COMPANY
  2. REQ-NUMBER
  3. LINE-NBR
SubsetWhere (CLOSED-FL != "Y")AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RLNSET5
  1. COMPANY
  2. REQ-LOCATION
  3. ITEM
  4. REQ-DEL-DATE ↓
  5. REQ-NUMBER
  6. LINE-NBR
KeyChangeIC142, RQ270, RQ42.1
RLNSET6
  1. COMPANY
  2. REQ-LOCATION
  3. CREATION-DATE
  4. ITEM
  5. REQ-NUMBER
  6. LINE-NBR
KeyChangeDR100, IC141, IC142, IC243, IC83.1, PC210, RQ10.1, RQ10.3 +10 more
RLNSET7
  1. COMPANY
  2. REQ-NUMBER
  3. LINE-NBR
  4. ITEM-TYPE
KeyChangeAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RLNSET8
  1. COMPANY
  2. ITEM
  3. REQ-NUMBER
  4. LINE-NBR
IC11.1, IC243, ICI9.1
RLNSET9
  1. FROM-COMPANY
  2. REQ-NUMBER-A
  3. LINE-NBR
KeyChange, SubsetWhere COMPANY != FROM-COMPANY—

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
APCOMPANYCOMMCODESICLOCATIONHCPATPROCICCOMPANYITEMMASTITEMLOCMMUAVALPOCOMPANYPOCONTGRPPOCONTRACTPORLNUFPOVAGRMTLNPOVAPARTLN+6 more belowMMDISTITEMSUBWHLOCRULEPOINTAUDITPOLINESRCRQAOCDTLRQAUDITRQLINEDTLWHDEMANDWHSHIPLINEWHSHIPMENTREQLINE

One to one (20) — lookups and parents

RelationTableRulesConditionField map
Ap CompanyAPCOMPANYNot Required
PCY-COMPANY→CPY-COMPANY (CPYSET1)
CommcodesCOMMCODESNot Required
ITE-ITEM-GROUP→ISC-ITEM-GROUP
RLN-COMMODITY-CODE→ISC-COMMODITY-CODE
From LocationICLOCATIONRequired
RLN-FROM-COMPANY→ICL-COMPANY
RLN-FROM-LOCATION→ICL-LOCATION
HcpatprocHCPATPROCNot Required
RLN-HPP-OBJ-ID→HPP-OBJ-ID
Ic CompanyICCOMPANYRequired
RLN-FROM-COMPANY→ICC-COMPANY
ItemITEMMASTRequiredWhen RLN-ITEM-TYPE = "I" Or RLN-ITEM-TYPE = "N"
ICC-ITEM-GROUP→ITE-ITEM-GROUP
RLN-ITEM→ITE-ITEM
Item LocationITEMLOCRequiredWhen RLN-ITEM-TYPE = "I"
RLN-FROM-COMPANY→ITL-COMPANY
RLN-FROM-LOCATION→ITL-LOCATION
RLN-ITEM→ITL-ITEM
MmuavalMMUAVALNot 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 CompanyPOCOMPANYRequired
RLN-FROM-COMPANY→PCY-COMPANY
PocontgrpPOCONTGRPRequiredWhen RLN-CM-CONTRACT != Zeroes
RLN-CONTRACT-GROUP→CNG-CONTRACT-GROUP
PocontractPOCONTRACTRequiredWhen RLN-CM-CONTRACT != Zeroes
RLN-CONTRACT-GROUP→CMH-CONTRACT-GROUP
RLN-CM-CONTRACT→CMH-CM-CONTRACT
PorlnufPORLNUFNot Required, Delete Cascades
RLN-COMPANY→UFQ-COMPANY
RLN-REQ-NUMBER→UFQ-REQ-NUMBER
RLN-LINE-NBR→UFQ-LINE-NBR
PovagrmtlnPOVAGRMTLNNot Required
RLN-PVN-OBJ-ID→PVN-PVN-OBJ-ID
PovapartlnPOVAPARTLNNot Required
PCY-PROCURE-GROUP→TPL-PROCURE-GROUP
RLN-AGREEMENT-REF→TPL-VEN-AGRMT-REF
RLN-PVN-OBJ-ID→TPL-PVN-OBJ-ID
RLN-PART-SEQ-NBR→TPL-PART-SEQ-NBR
Req LocationRQLOCRequired
RLN-COMPANY→RQL-COMPANY
RLN-REQ-LOCATION→RQL-REQ-LOCATION
RequesterREQUESTERRequired
RQH-REQUESTER→REQ-REQUESTER
RequisitionREQHEADERRequired
RLN-COMPANY→RQH-COMPANY
RLN-REQ-NUMBER→RQH-REQ-NUMBER
VendorAPVENMASTNot Required
CPY-VENDOR-GROUP→VEN-VENDOR-GROUP
RLN-VENDOR→VEN-VENDOR
Whdemand PharWHDEMANDNot 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
WhdemndhdrWHDEMNDHDRNot Required
RLN-FROM-COMPANY→WDH-COMPANY
"RQ"→WDH-SYSTEM-CD
RLN-REQ-NUMBER→WDH-DOC-NBR-NUM

One to many (11) — child tables

RelationTableRulesConditionField map
AccountsMMDIST
RLN-COMPANY→MMD-COMPANY
RLN-REQ-NUMBER→MMD-DOC-NBR-NUM
RLN-LINE-NBR→MMD-LINE-NBR
—→MMD-LINE-SEQ
ItemsubITEMSUB
ICC-ITEM-GROUP→ITS-ITEM-GROUP
RLN-ITEM→ITS-ITEM
"S"→ITS-SUBTYPE
—→ITS-SUB-ITEM
Location RuleWHLOCRULE
RLN-FROM-COMPANY→WHU-COMPANY
RLN-LOCATION-RULE→WHU-LOCATION-RULE
—→WHU-LEVEL
PointauditPOINTAUDIT
PCY-PROCURE-GROUP→PII-PROCURE-GROUP
RLN-COMPANY→PII-OPER-COMPANY
"RQ"→PII-ORIGIN-CD
Spaces→PII-SOURCE-DOC-A
RLN-REQ-NUMBER→PII-SOURCE-DOC-N
RLN-LINE-NBR→PII-LINE-NBR
—→PII-UPDATE-DATE
—→PII-UPDATE-TIME
—→PII-FLD-NBR
—→PII-AUDIT-TYPE
—→PII-AUDIT-ACTION
PolinesrcPOLINESRCValid 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
RqaoclineRQAOCDTL
RLN-COMPANY→RAO-COMPANY
RLN-REQ-NUMBER→RAO-REQ-NUMBER
RLN-LINE-NBR→RAO-LINE-NBR
—→RAO-AOC-CODE
RqauditRQAUDIT
"LN"→RHA-AUDIT-TYPE
RLN-COMPANY→RHA-COMPANY
RLN-REQ-NUMBER→RHA-REQ-NUMBER
RLN-LINE-NBR→RHA-LINE-NBR
—→RHA-LINE-SEQ
—→RHA-BIN
—→RHA-LOT-SERIAL
—→RHA-UOM
—→RHA-DATE
—→RHA-TIME
—→RHA-FLD-NBR
RqlinedtlRQLINEDTL
RLN-COMPANY→RQD-COMPANY
RLN-REQ-NUMBER→RQD-REQ-NUMBER
RLN-LINE-NBR→RQD-LINE-NBR
—→RQD-BIN
—→RQD-LOT-SERIAL
—→RQD-UOM
WhdemandWHDEMAND
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
WhshiplineWHSHIPLINE
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
WhshipmentWHSHIPMENT
RLN-FROM-COMPANY→WHS-COMPANY
RLN-FROM-LOCATION→WHS-LOCATION
RLN-REQ-NUMBER-A→WHS-DOC-NBR
—→WHS-SHIPMENT-NBR

Programs

Updated by (242)

Referenced by (47)