RQTRANS – Requisition Transactions

System
Requisitions (RQ)
Prefix
RQT
Primary key
FROM-COMPANY, FROM-LOCATION, DOC-TYPE, REQ-NUMBER, DOC-NBR-NUM, SEQ, LINE-NBR
Fields
22
Updated by
232 programs
Referenced by
7 programs

RQTRANS is the Requisition Transactions table in Lawson Requisitions (prefix RQT). It is indexed by FROM-COMPANY, FROM-LOCATION, DOC-TYPE, REQ-NUMBER, DOC-NBR-NUM, SEQ, LINE-NBR (RQTSET1); alternate indexes: RQTSET2, RQTSET3 and RQTSET4. It is related 1:1 to ICLOCATION, ICCOMPANY, ITEMMAST, ITEMLOC, REQHEADER, REQLINE and RQLOC. It is updated by AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 and 224 more and referenced by IC182, IC285, IC84.1, IC84.2, PC210, RQ230 and RQ50.1. The table has 22 fields, 4 indexes and 7 documented relations.

About RQTRANS

This file is the history of all deliveries for all requisitions. This file contains all requisition line types: inventory, nonstock, special order, and services.

Fields (22)

Column = COBOL field name without the RQT- 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
#RQT-FROM-COMPANY PK
FROM_COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-FROM-LOCATION PK
FROM_LOCATION		Alpha 5This is the inventory location that supplied the items or it is the purchase order ship to location that received the items.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-DOC-TYPE PK
DOC_TYPE		Alpha 2This field contains the type of transaction.
  • DT Direct Transfer
  • IS Issue
  • IT Transfer Issue
  • PO PO Receiving
  • RR Requisition Return
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-REQ-NUMBER PK
REQ_NUMBER		Numeric 7This is the assigned number to identify this requisition.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-DOC-NBR-NUM PK
DOC_NBR_NUM		Numeric 10—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-SEQ PK
SEQ		Numeric 3The delivery or return sequence number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-LINE-NBR PK
LINE_NBR		Numeric 6This field contains the requisition line number.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-TRANS-DATE SET2 SET3 SET4
TRANS_DATE		Numeric 8 (yyyymmdd)The date of the transaction.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-ITEM-TYPE
ITEM_TYPE		Alpha 1This field identifies the line item type.
  • I Inventoried
  • N Non-stock
  • X Special
  • S Service
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-ITEM SET2 SET4
ITEM		Alpha 32This field contains the item identifier.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-QUANTITY
QUANTITY		Signed 13.4This is the delivered quantity.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-STOCK-UOM
STOCK_UOM		Alpha 4This field contains the valid stock unit of measure for this item.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-UNIT-COST
UNIT_COST		Signed 18.5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-COMPANY SET3 SET4
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-REQ-LOCATION SET3 SET4
REQ_LOCATION		Alpha 5The location requisitioning items. This location can be an inventory or noninventory location.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-NOTE
NOTE		Alpha 12This is the return note entered when this transaction was created in RQ35.1 (Requisition Returns).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-PURCH-MAJOR
PURCH_MAJOR		Alpha 4This is the purchasing major class code that was entered on the requisition line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-PURCH-MINOR
PURCH_MINOR		Alpha 4This is the purchasing minor class code that was entered on the requisition line.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-TRAN-UNIT-COST
TRAN_UNIT_COST		Signed 18.5—AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-TRAN-CURR-CODE
TRAN_CURR_CODE		Alpha 5This field contains the company base currency code established in Company (GL10.1 ).AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-CNV-RATE
CNV_RATE		Signed 14.7Currency conversion rate at Purchase Order entry time.AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +52 more (list truncated in source)
#RQT-LINE-EXT
LINE_EXT		Derived——

Indexes (4)

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
RQTSET1
  1. FROM-COMPANY
  2. FROM-LOCATION
  3. DOC-TYPE
  4. REQ-NUMBER
  5. DOC-NBR-NUM
  6. SEQ
  7. LINE-NBR
PrimaryAP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RQTSET2
  1. FROM-COMPANY
  2. FROM-LOCATION
  3. ITEM
  4. TRANS-DATE ↓
  5. DOC-TYPE
  6. REQ-NUMBER
  7. DOC-NBR-NUM
  8. SEQ
  9. LINE-NBR
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RQTSET3
  1. COMPANY
  2. REQ-LOCATION
  3. TRANS-DATE
  4. REQ-NUMBER
  5. DOC-TYPE
  6. DOC-NBR-NUM
  7. SEQ
  8. LINE-NBR
AP125, AP126, AP131, AP20.1, AP20.2, AP20.3, AP20.4, AP20.5 +22 more (list truncated in source)
RQTSET4
  1. COMPANY
  2. REQ-LOCATION
  3. ITEM
  4. TRANS-DATE
  5. REQ-NUMBER
  6. DOC-TYPE
  7. DOC-NBR-NUM
  8. SEQ
  9. LINE-NBR
RQ300

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
ICLOCATIONICCOMPANYITEMMASTITEMLOCREQHEADERREQLINERQLOCRQTRANS

One to one (7) — lookups and parents

RelationTableRulesConditionField map
From LocationICLOCATIONRequired
RQT-FROM-COMPANY→ICL-COMPANY
RQT-FROM-LOCATION→ICL-LOCATION
IccompanyICCOMPANYRequired
RQT-COMPANY→ICC-COMPANY
ItemITEMMASTRequiredWhen RQT-ITEM-TYPE = "I" Or RQT-ITEM-TYPE = "N"
ICC-ITEM-GROUP→ITE-ITEM-GROUP
RQT-ITEM→ITE-ITEM
ItemlocITEMLOCRequiredWhen RQT-ITEM-TYPE = "I"
RQT-FROM-COMPANY→ITL-COMPANY
RQT-FROM-LOCATION→ITL-LOCATION
RQT-ITEM→ITL-ITEM
Req HeaderREQHEADERRequired
RQT-COMPANY→RQH-COMPANY
RQT-REQ-NUMBER→RQH-REQ-NUMBER
Req LineREQLINERequired
RQT-COMPANY→RLN-COMPANY
RQT-REQ-NUMBER→RLN-REQ-NUMBER
RQT-LINE-NBR→RLN-LINE-NBR
Rq LocationRQLOCRequired
RQT-COMPANY→RQL-COMPANY
RQT-REQ-LOCATION→RQL-REQ-LOCATION

Programs

Updated by (232)

Referenced by (7)