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
IC20.1 IC20.2 IC21.1 IC21.2 IC22.1 IC22.2
IC24.1 IC24.2 IC25.1 IC500 RQ120 RQ300
RQ35.1 RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
IS IC24.1 IC24.2
DT IC25.1 IC500
IT RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
IC24.1 IC24.2
IC25.1 IC500
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
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
RQ120 RQ35.1
RQ964
RQT-PURCH-MAJOR Alpha 4 RQ120 RQ964
Purch Major This is the purchasing major class code
that was entered on the requisition
line.
RQT-PURCH-MINOR Alpha 4 RQ120 RQ964
Purch Minor This is the purchasing minor class code
that was entered on the requisition
line.
RQT-EXT-COST Derived
Ext Cost This field was created to be used by
the third party tools for reporting.
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
SEQ number, sequence number, and line IC25.1 IC500
LINE-NBR number. RQ235
RQTSET2 FROM-COMPANY This index is used to access a RQ50.1
FROM-LOCATION requisition delivery history record for
ITEM a transaction date defined for an item
TRANS-DATE assigned a specific from company and
DOC-TYPE from location.
REQ-NUMBER
SEQ
LINE-NBR
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
SEQ IC500 PC210
LINE-NBR RQ230 RQ300
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
|