Lawson Insight Technical Documentation |
|
RQTRANS
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
UPDATED BY
AP125 AP126 AP131 AP25.1 AP25.2 AP26.1
AP27.1 AP30.4 BL120 BL122 BL130 BL20.1
BL20.3 BL21.2 BL21.5 BL29.1 BL29.2 BL520
BL820 BL92.1 IC20.1 IC20.2 IC21.1 IC21.2
IC22.1 IC22.2 IC24.1 IC24.2 IC25.1 IC28.1
IC500 MA180 MA530 MA531 MA60.2 MA60.3
MA60.5 MA61.1 MA66.2 MA66.3 MA67.1 MA67.2
MA70.1 MA75.1 MA80.1 MAI1.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 OE111
OE113 OE114 OE116 OE129 OE13.2 OE13.3
OE13.5 OE13.6 OE14.4 OE30.1 OE30.2 OE30.3
OE30.4 OE30.5 OE30.6 OE30.7 OE30.9 OE510
OE530 OE81.1 OE810 OE830 OE90.1 OE90.2
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 WO132
WO140
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQT-FROM-COMPANY Numeric 4 AP125 AP126
Element: Company This is the company that is the source AP131 AP25.1
of the items. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-FROM-LOCATION Alpha 5 AP125 AP126
Element: Location Code 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 AP30.4
items. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-DOC-TYPE Alpha 2 AP125 AP126
Element: Document Type This field contains the type of AP131 AP25.1
transaction. AP25.2 AP26.1
DT = Direct Transfer AP27.1 AP30.4
IS = Issue BL120 BL122
IT = Transfer Issue BL130 BL20.1
PO = PO Receiving BL20.3 BL21.2
RR = Requisition Return BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-REQ-NUMBER Numeric 7 AP125 AP126
Element: Requisition NuThis is the assigned number to identify AP131 AP25.1
this requisition. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-DOC-NBR-NUM Numeric 10 AP125 AP126
Element: Doc Nbr Num AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-SEQ Numeric 3 AP125 AP126
Element: Sequence NumbeThe delivery or return sequence number. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-LINE-NBR Numeric 6 AP125 AP126
Element: Line Number This field contains the requisition AP131 AP25.1
line number. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-TRANS-DATE Numeric 8 (yyyymmdd) AP125 AP126
Element: Transaction DaThe date of the transaction. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-ITEM-TYPE Alpha 1 AP125 AP126
Element: Item Type This field identifies the line item AP131 AP25.1
type. AP25.2 AP26.1
I = Inventoried AP27.1 AP30.4
N = Non-stock BL120 BL122
X = Special BL130 BL20.1
S = Service BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-ITEM Alpha 32 AP125 AP126
Element: Item Number This field contains the item AP131 AP25.1
identifier. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-QUANTITY Signed 13.4 AP125 AP126
Element: Quantity This is the delivered quantity. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-STOCK-UOM Alpha 4 AP125 AP126
Element: Unit of MeasurThis is the stock unit of measure for AP131 AP25.1
the item. AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-UNIT-COST Signed 18.5 AP125 AP126
Element: Intl Cost This field contains the unit cost. AP131 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-COMPANY Numeric 4 AP125 AP126
Element: Company Identifies the AP company if the AP131 AP25.1
resource type = V. Identifies the HR AP25.2 AP26.1
company if the resource type = E. It is AP27.1 AP30.4
blank for type A, P or Q resources. BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-REQ-LOCATION Alpha 5 AP125 AP126
Element: To Location The location requisitioning items. AP131 AP25.1
This location can be an inventory or AP25.2 AP26.1
noninventory location. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-NOTE Alpha 12 AP125 AP126
Element: 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 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-PURCH-MAJOR Alpha 4 AP125 AP126
Element: Major Class This is the purchasing major class code AP131 AP25.1
that was entered on the requisition AP25.2 AP26.1
line. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-PURCH-MINOR Alpha 4 AP125 AP126
Element: Minor Class This is the purchasing minor class code AP131 AP25.1
that was entered on the requisition AP25.2 AP26.1
line. AP27.1 AP30.4
BL120 BL122
BL130 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.1
IC500 MA180
MA530 MA531
MA60.2 MA60.3
MA60.5 MA61.1
MA66.2 MA66.3
MA67.1 MA67.2
MA70.1 MA75.1
MA80.1 MAI1.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 OE111
...
RQT-TRAN-UNIT-COST Signed 18.5
Element: Intl Cost
RQT-TRAN-CURR-CODE Alpha 5
Element: Currency Code
RQT-CNV-RATE Signed 14.7
Entered Conversion
Rate
RQT-LINE-EXT Derived
Element: 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 AP30.4
DOC-NBR-NUM number, sequence number, and line BL120 BL122
SEQ number. BL130 BL20.1
LINE-NBR BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.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 AP30.4
DOC-TYPE from location. BL120 BL122
REQ-NUMBER BL130 BL20.1
DOC-NBR-NUM BL20.3 BL21.2
SEQ BL21.5 BL29.1
LINE-NBR BL29.2 BL520
BL820 BL92.1
IC20.1 IC20.2
IC21.1 IC21.2
IC22.1 IC22.2
IC24.1 IC24.2
IC25.1 IC28.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 AP30.4
DOC-TYPE document number. BL120 BL122
DOC-NBR-NUM BL130 BL20.1
SEQ BL20.3 BL21.2
LINE-NBR BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
IC182 IC20.1
IC20.2 IC21.1
IC21.2 IC22.1
IC22.2 IC24.1
IC24.2 IC25.1
...
RQTSET4 COMPANY
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 (ICLSET1)
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
|