 |
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
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 IC20.1 IC20.2 IC21.1 IC21.2 IC22.1
IC22.2 IC24.1 IC24.2 IC25.1 IC28.1 IC500
MA180 MA43.9 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.3 MA67.1 MA67.2 MA70.1
MAI1.1 PO100 PO101 PO122 PO131 PO20.1
PO21.2 PO21.3 PO21.4 PO21.5 PO22.1 PO23.1
PO29.1 PO30.1 PO30.2 PO30.3 PO300 PO31.1
PO31.2 PO32.2 PO33.1 PO34.1 PO35.1 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
POI3.1 POID.1 POIE.1 POII.1 POIJ.1 RQ10.1
RQ10.2 RQ300 RQ35.1 WH130 WH132 WH190
WH20.2 WH20.7 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.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
RQT-FROM-COMPANY Numeric 4 AP125 AP126
From Company This is the company that is the source AP131 AP25.1
of the items. AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-FROM-LOCATION Alpha 5 AP125 AP126
From Location This is the inventory location that AP131 AP25.1
supplied the items or it is the purchase AP25.2 AP26.1
order ship to location that received the AP27.1 IC20.1
items. IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-DOC-TYPE Alpha 2 AP125 AP126
Document Type This field contains the type of AP131 AP25.1
transaction. AP25.2 AP26.1
DT = Direct Transfer AP27.1 IC20.1
IS = Issue IC20.2 IC21.1
IT = Transfer Issue IC21.2 IC22.1
PO = PO Receiving IC22.2 IC24.1
RR = Requisition Return IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-REQ-NUMBER Numeric 7 AP125 AP126
Requisition Number This is the assigned number to identify AP131 AP25.1
this requisition. AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-DOC-NBR-NUM Numeric 10 AP125 AP126
Doc Nbr Num AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-SEQ Numeric 3 AP125 AP126
Sequence Number The delivery or return sequence number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-LINE-NBR Numeric 6 AP125 AP126
Line Number This field contains the requisition AP131 AP25.1
line number. AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-TRANS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Transaction Date The date of the transaction. AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-ITEM-TYPE Alpha 1 AP125 AP126
Item Type This field identifies the line item AP131 AP25.1
type. AP25.2 AP26.1
I = Inventoried AP27.1 IC20.1
N = Non-stock IC20.2 IC21.1
X = Special IC21.2 IC22.1
S = Service IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-ITEM Alpha 32 AP125 AP126
Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-QUANTITY Signed 13.4 AP125 AP126
Quantity This is the delivered quantity. AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-STOCK-UOM Alpha 4 AP125 AP126
Stocking Unit of This is the stock unit of measure for AP131 AP25.1
Measure the item. AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-UNIT-COST Signed 13.5 AP125 AP126
Unit Cost This field contains the unit cost. AP131 AP25.1
AP25.2 AP26.1
AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-COMPANY Numeric 4 AP125 AP126
Company The company number represents an AP131 AP25.1
established company and is entered on AP25.2 AP26.1
all function codes. AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-REQ-LOCATION Alpha 5 AP125 AP126
To Location The location requisitioning items. AP131 AP25.1
This location can be an inventory or AP25.2 AP26.1
noninventory location. AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-NOTE Alpha 12 AP125 AP126
Note This is the return note entered when AP131 AP25.1
this transaction was created in RQ35.1 AP25.2 AP26.1
(Requisition Returns). AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-PURCH-MAJOR Alpha 4 AP125 AP126
Purch Major This is the purchasing major class code AP131 AP25.1
that was entered on the requisition AP25.2 AP26.1
line. AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
RQT-PURCH-MINOR Alpha 4 AP125 AP126
Purch Minor This is the purchasing minor class code AP131 AP25.1
that was entered on the requisition AP25.2 AP26.1
line. AP27.1 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
MAI1.1 PO100
PO101 PO122
PO131 PO20.1
PO21.2 PO21.3
PO21.4 PO21.5
PO22.1 PO23.1
PO29.1 PO30.1
PO30.2 PO30.3
PO300 PO31.1
PO31.2 PO32.2
PO33.1 PO34.1
PO35.1 PO38.1
PO39.1 PO39.2
PO44.1 PO50.1
PO52.1 PO520
...
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 AP125 AP126
FROM-LOCATION requisition delivery history record for AP131 AP25.1
DOC-TYPE a specific from company and from AP25.2 AP26.1
REQ-NUMBER location, document type, requisition AP27.1 IC20.1
DOC-NBR-NUM number, sequence number, and line IC20.2 IC21.1
SEQ number. IC21.2 IC22.1
LINE-NBR IC22.2 IC24.1
IC24.2 IC25.1
IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
...
RQTSET2 FROM-COMPANY This index is used to access a AP125 AP126
FROM-LOCATION requisition delivery history record for AP131 AP25.1
ITEM a transaction date defined for an item AP25.2 AP26.1
TRANS-DATE assigned a specific from company and AP27.1 IC20.1
DOC-TYPE from location. IC20.2 IC21.1
REQ-NUMBER IC21.2 IC22.1
DOC-NBR-NUM IC22.2 IC24.1
SEQ IC24.2 IC25.1
LINE-NBR IC28.1 IC500
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
MA67.2 MA70.1
...
RQTSET3 COMPANY This index is used to access a AP125 AP126
REQ-LOCATION requisition delivery history record for AP131 AP25.1
TRANS-DATE a transaction date defined for an item AP25.2 AP26.1
REQ-NUMBER having a specific requisition number and AP27.1 IC182
DOC-TYPE document number. IC20.1 IC20.2
DOC-NBR-NUM IC21.1 IC21.2
SEQ IC22.1 IC22.2
LINE-NBR IC24.1 IC24.2
IC25.1 IC28.1
IC500 PC210
MA180 MA43.9
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.3 MA67.1
...
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
|