This file is the history of all deliveries for all requisitions. This file
contains all requisition line types: inventory, nonstock, special order, and
services.
| FIELD NAME |
DESCRIPTION/VALID VALUES |
UPDATED BY |
RQT-FROM-COMPANY
Element: Company | Numeric 4
Identifies 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.
|
|
RQT-FROM-LOCATION
Element: Location | Alpha 5
This is the inventory location that
supplied the items or it is the purchase
order ship to location that received the
items.
|
|
RQT-DOC-TYPE
Element: Doc Type | Alpha 2
This field contains the type of
transaction.
DT = Direct Transfer
IS = Issue
IT = Transfer Issue
PO = PO Receiving
RR = Requisition Return |
|
RQT-REQ-NUMBER
Element: Req Number | Numeric 7
This is the assigned number to identify
this requisition.
|
|
RQT-DOC-NBR-NUM
Element: Doc Nbr Num | Numeric 10
|
|
RQT-SEQ
Element: Seq | Numeric 3
The delivery or return sequence number.
|
|
RQT-LINE-NBR
Element: Line Nbr | Numeric 6
This field contains the requisition
line number.
|
|
RQT-TRANS-DATE
Element: Trans Date | Numeric 8 (yyyymmdd)
The date of the transaction.
|
|
RQT-ITEM-TYPE
Element: Item Type | Alpha 1
This field identifies the line item
type.
I = Inventoried
N = Non-stock
X = Special
S = Service |
|
RQT-ITEM
Element: Item | Alpha 32
This field contains the item
identifier.
|
|
RQT-QUANTITY
Element: Quantity | Signed 13.4
This is the delivered quantity.
|
|
RQT-STOCK-UOM
Element: Uom | Alpha 4
This field contains the valid stock
unit of measure for this item.
|
|
RQT-UNIT-COST
Element: Intl Cost | Signed 18.5
|
|
RQT-COMPANY
Element: Company | Numeric 4
Identifies 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.
|
|
RQT-REQ-LOCATION
Element: Req Location | Alpha 5
The location requisitioning items.
This location can be an inventory or
noninventory location.
|
|
RQT-NOTE
Element: Note | Alpha 12
This is the return note entered when
this transaction was created in RQ35.1
(Requisition Returns).
|
|
RQT-PURCH-MAJOR
Element: Major Class | Alpha 4
This is the purchasing major class code
that was entered on the requisition
line.
|
|
RQT-PURCH-MINOR
Element: Minor Class | Alpha 4
This is the purchasing minor class code
that was entered on the requisition
line.
|
|
RQT-TRAN-UNIT-COST
Element: Intl Cost | Signed 18.5
|
|
RQT-TRAN-CURR-CODE
Element: Currency Code | Alpha 5
This field contains the company base
currency code established in Company
(GL10.1 ).
|
|
RQT-CNV-RATE
Element: Ent Cnv Rate | Signed 14.7
Currency conversion rate at Purchase
Order entry time.
|
|
RQT-LINE-EXT
Element: Line Ext | Derived
|
|
