 |
Lawson Insight Technical Documentation |
|
RQTRANS FILE
Requisition Transactions
This file is the history of all deliveries for all requisitions. This file
contains all requisition line types: inventory, nonstock, special order, and
services.
REFERENCED BY
RQ235 RQ50.1 IC182 PC210 RQ230 PHI6.1
UPDATED BY
IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2
IC24.1 IC24.2 IC25.1 IC500 POID.1 POIJ.1
RQ300 WH130 WH33.1 WH33.2 WH33.3 WH33.4
WH33.5 WH33.6 WH33.8 WH33.9 WH34.1 WH34.2
WH34.3 WH34.4
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQT-FROM-COMPANY Numeric 4 IC20.1 IC20.2
From Company This is the company that is the source IC21.1 IC21.2
of the items. IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-FROM-LOCATION Alpha 5 IC20.1 IC20.2
From Location This is the inventory location that IC21.1 IC21.2
supplied the items or it is the purchase IC22.1 IC22.2
order ship to location that received the IC24.1 IC24.2
items. IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-DOC-TYPE Alpha 2 IC20.1 IC20.2
Document Type This field contains the type of IC21.1 IC21.2
transaction. IC22.1 IC22.2
DT = Direct Transfer IC24.1 IC24.2
IS = Issue IC25.1 IC500
IT = Transfer Issue POID.1 POIJ.1
PO = PO Receiving WH130 WH33.1
RR = Requisition Return WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-REQ-NUMBER Numeric 7 IC20.1 IC20.2
Requisition Number This is the assigned number to identify IC21.1 IC21.2
this requisition. IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-DOC-NBR-NUM Numeric 10 IC20.1 IC20.2
Doc Nbr Num IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-SEQ Numeric 3 IC20.1 IC20.2
Sequence Number The delivery or return sequence number. IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-LINE-NBR Numeric 6 IC20.1 IC20.2
Line Number This field contains the requisition IC21.1 IC21.2
line number. IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-TRANS-DATE Numeric 8 (yyyymmdd) IC20.1 IC20.2
Transaction Date The date of the transaction. IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-ITEM-TYPE Alpha 1 IC20.1 IC20.2
Item Type This field identifies the line item IC21.1 IC21.2
type. IC22.1 IC22.2
I = Inventoried IC24.1 IC24.2
N = Non-stock IC25.1 IC500
X = Special POID.1 POIJ.1
S = Service WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-ITEM Alpha 32 IC20.1 IC20.2
Item Number This field contains the item IC21.1 IC21.2
identifier. IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-QUANTITY Signed 13.4 IC20.1 IC20.2
Quantity This is the delivered quantity. IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-STOCK-UOM Alpha 4 IC20.1 IC20.2
Stocking Unit of This is the stock unit of measure for IC21.1 IC21.2
Measure the item. IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-UNIT-COST Signed 13.5 IC20.1 IC20.2
Unit Cost This field contains the unit cost. IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-COMPANY Numeric 4 IC20.1 IC20.2
Company The company number represents an IC21.1 IC21.2
established company and is entered on IC22.1 IC22.2
all function codes. IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-REQ-LOCATION Alpha 5 IC20.1 IC20.2
To Location The location requisitioning items. IC21.1 IC21.2
This location can be an inventory or IC22.1 IC22.2
noninventory location. IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-NOTE Alpha 12 IC20.1 IC20.2
Note This is the return note entered when IC21.1 IC21.2
this transaction was created in RQ35.1 IC22.1 IC22.2
(Requisition Returns). IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-PURCH-MAJOR Alpha 4 IC20.1 IC20.2
Purch Major This is the purchasing major class code IC21.1 IC21.2
that was entered on the requisition IC22.1 IC22.2
line. IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-PURCH-MINOR Alpha 4 IC20.1 IC20.2
Purch Minor This is the purchasing minor class code IC21.1 IC21.2
that was entered on the requisition IC22.1 IC22.2
line. IC24.1 IC24.2
IC25.1 IC500
POID.1 POIJ.1
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQT-LINE-EXT Derived
Line Ext
RQTRANS FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQTSET1 FROM-COMPANY This index is used to access a IC20.1 IC20.2
FROM-LOCATION requisition delivery history record for IC21.1 IC21.2
DOC-TYPE a specific from company and from IC22.1 IC22.2
REQ-NUMBER location, document type, requisition IC24.1 IC24.2
DOC-NBR-NUM number, sequence number, and line IC25.1 IC500
SEQ number. POID.1 POIJ.1
LINE-NBR RQ235 WH130
WH33.1 WH33.2
WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
RQTSET2 FROM-COMPANY This index is used to access a IC20.1 IC20.2
FROM-LOCATION requisition delivery history record for IC21.1 IC21.2
ITEM a transaction date defined for an item IC22.1 IC22.2
TRANS-DATE assigned a specific from company and IC24.1 IC24.2
DOC-TYPE from location. IC25.1 IC500
REQ-NUMBER POID.1 POIJ.1
DOC-NBR-NUM RQ50.1 WH130
SEQ WH33.1 WH33.2
LINE-NBR WH33.3 WH33.4
WH33.5 WH33.6
WH33.8 WH33.9
WH34.1 WH34.2
WH34.3 WH34.4
RQTSET3 COMPANY This index is used to access a IC182 IC20.1
REQ-LOCATION requisition delivery history record for IC20.2 IC21.1
TRANS-DATE a transaction date defined for an item IC21.2 IC22.1
REQ-NUMBER having a specific requisition number and IC22.2 IC24.1
DOC-TYPE document number. IC24.2 IC25.1
DOC-NBR-NUM IC500 PC210
SEQ POID.1 POIJ.1
LINE-NBR RQ230 RQ300
WH130 WH33.1
WH33.2 WH33.3
WH33.4 WH33.5
WH33.6 WH33.8
WH33.9 WH34.1
WH34.2 WH34.3
WH34.4
RQTSET4 COMPANY PHI6.1
REQ-LOCATION
ITEM
TRANS-DATE
REQ-NUMBER
DOC-TYPE
DOC-NBR-NUM
SEQ
LINE-NBR
RQTRANS FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
From Location ICLOCATION Required
RQT-FROM-COMPANY -> ICL-COMPANY
RQT-FROM-LOCATION -> ICL-LOCATION
Iccompany ICCOMPANY Required
RQT-COMPANY -> ICC-COMPANY
Item ITEMMAST Required
When RQT-ITEM-TYPE = "I"
Or RQT-ITEM-TYPE = "N"
ICC-ITEM-GROUP -> ITE-ITEM-GROUP
RQT-ITEM -> ITE-ITEM
Itemloc ITEMLOC Required
When RQT-ITEM-TYPE = "I"
RQT-FROM-COMPANY -> ITL-COMPANY
RQT-FROM-LOCATION -> ITL-LOCATION
RQT-ITEM -> ITL-ITEM
Req Header REQHEADER Required
RQT-COMPANY -> RQH-COMPANY
RQT-REQ-NUMBER -> RQH-REQ-NUMBER
Req Line REQLINE Required
RQT-COMPANY -> RLN-COMPANY
RQT-REQ-NUMBER -> RLN-REQ-NUMBER
RQT-LINE-NBR -> RLN-LINE-NBR
Rq Location RQLOC Required
RQT-COMPANY -> RQL-COMPANY
RQT-REQ-LOCATION -> RQL-REQ-LOCATION
|