Lawson Insight Technical Documentation |
|
REQHEADER
REQHEADER FILE
Requisition Header
This file contains the header information for each requisition.
REFERENCED BY
PO136 POI4.1 POI6.1 RQ39.1 RQ39.2 RQ39.3
RQCP.1 RQIC.1 RQID.1 RQIG.1 RQIH.1 WH110
WH120 WH21.1 WH21.2 WH21.3 WH21.4 WH210
WH22.1 WH224 RQ01.1 RQ04.1 RQII.1 RQ02.1
UPDATED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP21.1 AP23.1 AP25.1
AP25.2 AP26.1 AP27.1 AP30.4 API1.1 BL120
BL122 BL130 BL20.1 BL20.3 BL21.2 BL21.5
BL29.1 BL29.2 BL520 BL820 BL92.1 CXCP.1
MA180 MA41.1 MA41.2 MA41.4 MA41.7 MA43.1
MA43.2 MA43.3 MA43.7 MA530 MA531 MA60.2
MA60.3 MA60.5 MA61.1 MA66.2 MA66.3 MA67.2
MA67.3 MA68.2 MA68.3 MA68.5 MA70.1 MA75.1
MA80.1 MAI1.1 PD10.1 PD10.2 PD130 PD20.1
PD20.2 PD20.3 PO100 PO101 PO122 PO131
PO190 PO20.1 PO21.1 PO21.2 PO21.3 PO21.4
PO21.5 PO22.1 PO23.1 PO24.1 PO25.1 PO25.5
PO25.6 PO25.7 PO27.2 PO29.1 PO30.1 PO30.2
PO30.3 PO300 PO31.1 PO31.2 PO32.2 PO32.4
PO33.1 PO34.1 PO35.1 PO36.1 PO36.2 PO38.1
PO39.1 PO39.2 PO44.1 PO50.1 PO52.1 PO520
PO536 POCP.1 POI3.1 POID.1 POII.1 POIJ.1
RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ111 RQ12.1
RQ13.1 RQ13.2 RQ140 RQ300 RQ35.1 RQ40.1
RQ41.1 RQ44.1 RQ44.2 RQ500 RQD0.1 RQD1.1
RQIB.1 RQIF.1 RQIJ.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH25.1 WH25.2 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 WHD2.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQH-COMPANY Numeric 4 RQ10.1 RQ10.3
Element: Company Enter the company number established in RQ11.1 RQ13.2
Company (IC01.1) or Company (MA01.1). RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-REQ-NUMBER Numeric 7 RQ10.1 RQ10.3
Element: Req Number Requisition numbers are automatically RQ11.1 RQ13.2
assigned if the company is set up for RQ35.1 RQ500
automatic numbering in Company (IC01.1) RQIB.1 RQIF.1
or Company (MA01.1). Otherwise, RQII.1 RQIJ.1
requisition numbers are user defined.
Automatically assigned requisition
numbers are incremented by one from the
last number used, as defined in IC01.1
or MA01.1.
RQH-REQUESTER Alpha 10 (Lower Case) RQ10.1 RQ10.3
Element: Requester This is the person, department, or area RQ11.1 RQ13.2
requesting items. Requesters are defined RQ35.1 RQ500
in Requesters (RQ04.1). RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-REQ-LOCATION Alpha 5 RQ10.1 RQ10.3
Element: Req Location This is the location requesting items. RQ11.1 RQ13.2
This location can be an inventory RQ35.1 RQ500
location defined in Location (IC02.1) or RQIB.1 RQIF.1
a non-inventory location. All requesting RQII.1 RQIJ.1
locations must be defined in Requesting
Locations (RQ01.1). Requesting locations
may be assigned to the requester in the
Requesters (RQ04.1) Main tab. The
requesting location defaults to the
requisition based on the requester. You
can override this with each requisition.
RQH-REQ-DEL-DATE Numeric 8 (yyyymmdd) RQ10.1 RQ10.3
Element: Date This is the requested delivery date. RQ11.1 RQ13.2
RQ35.1 RQ500
If left blank, this field defaults to RQIB.1 RQIF.1
the system date. The requested delivery RQII.1 RQIJ.1
date is used to schedule backorder WH132 WH222
allocations (that is, requisitions with
the oldest requisition delivery date
having backorders are filled before
later dated requisitions for the same
item). You can override this date.
RQH-CREATION-DATE Numeric 8 (yyyymmdd) RQ10.1 RQ10.3
Element: Creation Date This is the date that this line was RQ11.1 RQ13.2
added to the requisition. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-REFERENCE-NO Alpha 10 (Right Justified) RQ10.1 RQ10.3
Element: Reference No RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-REQ-DESC Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: Req Desc RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-FROM-COMPANY Numeric 4 RQ10.1 RQ10.3
Element: Company Identifies the AP company if the RQ11.1 RQ13.2
resource type = V. Identifies the HR RQ35.1 RQ500
company if the resource type = E. It is RQIB.1 RQIF.1
blank for type A, P or Q resources. RQII.1 RQIJ.1
RQH-FROM-LOCATION Alpha 5 RQ10.1 RQ10.3
Element: Location This field contains a valid stocking RQ11.1 RQ13.2
location within the company inventory. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-DELIVER-TO Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: Deliver To This is additional information RQ11.1 RQ13.2
regarding where the requested items are RQ35.1 RQ500
to be delivered. This is a user-defined RQIB.1 RQIF.1
field that displays online and on the RQII.1 RQIJ.1
delivery ticket.
RQH-BUYER-CODE Alpha 3 RQ10.1 RQ10.3
Element: Buyer The user defined buyer code defined in RQ11.1 RQ13.2
Buyer (PO04.1). RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-VENDOR Alpha 9 (Right Justified) RQ10.1 RQ10.3
Element: Vendor Enter the suggested vendor code for the RQ11.1 RQ13.2
requisition. The vendor code defaults to RQ35.1 RQ500
all subsequent requisition lines. The RQIB.1 RQIF.1
suggested vendor prints on the RQII.1 RQIJ.1
requisition when you run Print
Requisitions (RQ111).The vendor can be
changed when a purchase order is
created. The vendor must be defined in
Vendor (AP10.1).
RQH-PURCH-FR-LOC Alpha 4 RQ10.1 RQ10.3
Element: Purch Fr Loc Enter the suggested purchase from RQ11.1 RQ13.2
location for the entered vendor. Vendors RQ35.1 RQ500
can have multiple purchase from RQIB.1 RQIF.1
locations. The purchase from location RQII.1 RQIJ.1
code prints on the requisition when you
run Print Requisitions (RQ111). As with
the vendor code, the purchase from
location can be changed when a purchase
order is created for the requisition.
The purchase from location code must be
defined in Vendor Location (AP10.2).
RQH-VENDOR-NAME Alpha 30 RQ10.1 RQ10.3
Element: Vendor Name Enter the recommended vendor's name for RQ11.1 RQ13.2
the requisition. If left blank, this RQ35.1 RQ500
defaults to the vendor's name defined in RQIB.1 RQIF.1
the Accounts Payable (AP) Vendor form. RQII.1 RQIJ.1
RQH-PRINT-REQ-FL Alpha 1 RQ10.1 RQ10.3
Element: All Flag This flag indicates whether you want to RQ11.1 RQ111
print the requisition in RQ111 (Print RQ13.2 RQ35.1
Requisitions). This flag defaults based RQ500 RQIB.1
on the approval assigned to the RQIF.1 RQII.1
requester. It can be overridden when the RQIJ.1
requisition is created.
Once the requisition has been printed,
this flag is changed to No, do not print
the requisition. You can print the
requisition after it has been printed by
specifying the requisition in RQ111
(Print Requisitions).
N = No
Y = Yes
RQH-LAST-LINE-NBR Numeric 6 RQ10.1 RQ10.3
Element: Line Nbr The number of the last line item added RQ11.1 RQ13.2
to the requisition. This number RQ35.1 RQ500
determines what the next line number is RQIB.1 RQIF.1
when you add another item. RQII.1 RQIJ.1
RQH-LAST-DEL-SEQ Numeric 3 PO30.1 PO30.2
Element: Seq This field contains the record sequence PO30.3 POID.1
number. RQ10.1 RQ10.3
RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-RETURN-SEQ Numeric 3 RQ10.1 RQ10.3
Element: Seq This number indicates the number of RQ11.1 RQ13.2
times a return has been made against a RQ35.1 RQ500
requisition. RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-STATUS Numeric 1 PO100 PO23.1
Element: Status This is the processing status of the RQ10.1 RQ10.3
requisition as described below. RQ11.1 RQ12.1
RQ13.1 RQ13.2
Released = Requisition has been released RQ35.1 RQ500
in RQ10.1 (Requisition). RQD1.1 RQIB.1
RQIF.1 RQII.1
Unreleased = Requisition added but not RQIJ.1
released in RQ10.1 (Requisition).
Closed = Every requisition line is fully
delivered or backorders are canceled.
Rejected = The approver has rejected the
requisition. This closes the
requisition, which cannot be reopened.
Processed = The requisition has been
fully approved.
0 = Unreleased
1 = Released
5 = In Process
9 = Processed
8 = Rejected
RQH-PO-USER-FLD-1 Alpha 1 RQ10.1 RQ10.3
Element: Po User Fld 1 Purchase Order header user field one. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PO-USER-FLD-3 Alpha 30 RQ10.1 RQ10.3
Element: User Field2 Purchase Order header user field three. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PO-USER-FLD-5 Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: User Fld2 Purchase Order header user field five. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-USER-DATE-1 Numeric 8 (yyyymmdd) RQ10.1 RQ10.3
Element: Date This field displays the system date RQ11.1 RQ13.2
when this was created. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-USER-DATE-2 Numeric 8 (yyyymmdd) RQ10.1 RQ10.3
Element: Date This field displays the system date RQ11.1 RQ13.2
when this was created. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-LAST-APRV-DT Numeric 8 (yyyymmdd) RQ10.1 RQ10.3
Element: Date This is the last approval date for the RQ11.1 RQ12.1
requisition. Requisitions are approved RQ13.1 RQ13.2
in RQ12.1 (Approval Review). RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-APPROVED-FL Alpha 1 RQ10.1 RQ10.3
Element: All Flag This flag indicates that this RQ11.1 RQ12.1
requisition has been approved at all RQ13.1 RQ13.2
required approval levels. Required RQ35.1 RQ500
approval levels are defined by amount in RQIB.1 RQIF.1
RQ02.1 (Approval Codes). RQII.1 RQIJ.1
N = No
Y = Yes
RQH-ATTAIN-LEVEL Numeric 1 RQ10.1 RQ10.3
Element: Aprv Level This is the highest approval level RQ11.1 RQ12.1
required for the requisition. The RQ13.1 RQ13.2
requisition must be approved at this RQ35.1 RQ500
level for further processing. RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-APRV-LEVEL Numeric 1 RQ10.1 RQ10.3
Element: Aprv Level This is the approval level that this RQ11.1 RQ12.1
requisition has attained so far in RQ13.1 RQ13.2
RQ12.1 (Approval Review). RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-NBR-LINES Numeric 6 RQ10.1 RQ10.3
Element: Nbr Lines This is the number of detail lines. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-CLOSED-LINES Numeric 6 RQD1.1
Element: Closed Lines This is the number of closed detail
lines on the requisition. When the
number of closed lines equals the number
of lines, the requisition status is set
to closed in RQ120 (Delivery Ticket).
RQH-CLOSED-FL Alpha 1 AP125 AP126
Element: Closed Fl The Closed Flag. AP131 AP20.1
Y = Yes AP20.2 AP20.3
N = No AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
MA180 MA41.1
MA41.2 MA41.4
MA41.7 MA43.1
MA43.2 MA43.3
MA43.7 MA530
MA531 MA60.2
MA60.3 MA60.5
MA61.1 MA66.2
MA66.3 MA67.2
MA67.3 MA68.2
MA68.3 MA68.5
MA70.1 MA75.1
MA80.1 MAI1.1
PD10.1 PD10.2
PD130 PD20.1
...
RQH-I-TOTAL Signed 18.2 RQ10.1 RQ10.3
Element: Intl Amt RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-N-TOTAL Signed 18.2 RQ10.1 RQ10.3
Element: Intl Amt RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-X-S-TOTAL Signed 18.2 RQ10.1 RQ10.3
Element: Intl Amt RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PRINTED-FL Alpha 1 RQ10.1 RQ10.3
Element: Printed Fl This flag indicates whether the RQ11.1 RQ111
requisition has been printed in RQ111 RQ13.2 RQ35.1
(Print Requisitions). RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-ALLOC-PRI Numeric 2 RQ10.1 RQ10.3
Element: Alloc Pri This is the allocation priority for RQ11.1 RQ13.2
this requisition. Valid values are from RQ35.1 RQ500
0 to 99, with 99 being the highest. This RQIB.1 RQIF.1
field defaults to 50. This field is RQII.1 RQIJ.1
used in the Warehouse module to
determine the order in which inventory
demand gets allocated.
RQH-QUOTE-FL Alpha 1 RQ10.1 RQ10.3
Element: Quote Fl This flag indicates if the buyer should RQ11.1 RQ13.2
get quotes for this requisition before RQ35.1 RQ500
it is turned into a purchase order. RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-RETURN-NOTE Alpha 12 RQ10.1 RQ10.3
Element: Note This is a user defined field available RQ11.1 RQ13.2
for data entry in RQ35.1 (Requisition RQ35.1 RQ500
Returns). RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-RETURN-DATE Numeric 8 (yyyymmdd) RQ10.1 RQ10.3
Element: Date This is the return transaction date for RQ11.1 RQ13.2
a requisition item processed in RQ35.1 RQ35.1 RQ500
(Requisition Returns). RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-ACTIVITY Alpha 15 RQ10.1 RQ10.3
Element: Activity Activities are the processes or RQ11.1 RQ13.2
procedures that produce work. Cost RQ35.1 RQ500
objects (products, services, customers, RQIB.1 RQIF.1
and so on) are the reasons for RQII.1 RQIJ.1
performing the activity.
RQH-ACCT-CATEGORY Alpha 5 RQ10.1 RQ10.3
Element: Acct Category Account categories are groupings of RQ11.1 RQ13.2
costs, revenues, or a combination of RQ35.1 RQ500
both used for reporting and inquiries RQIB.1 RQIF.1
for activities in the Activity RQII.1 RQIJ.1
Management system. All transactions are
posted to an account category within an
activity. You can assign a specific
General Ledger account or range of
accounts (company, accounting unit,
account, and subaccount) that make up
the transactions posted to an account
category using AC07.1 (Account
Assignment).
Period-to-date, year-to-date, and
life-to-date balances are maintained by
account category for activities. Account
categories must be assigned to
activities before you do any budgeting
or transaction processing.
Valid account category types are:
cost
revenue
accrual
pass thru
RQH-BILL-CATEGORY Alpha 32 RQ10.1 RQ10.3
Element: Bill Category RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-ACCT-UNIT Alpha 15 RQ10.1 RQ10.3
Element: Acct Unit The accounting unit is a shorthand RQ11.1 RQ13.2
notation representing the variable level RQ35.1 RQ500
number. When used in the General Ledger RQIB.1 RQIF.1
Account Master file, the accounting unit RQII.1 RQIJ.1
must be defined in the General Ledger
Names file as a posting accounting unit.
RQH-ACCOUNT Numeric 6 RQ10.1 RQ10.3
Element: Account This field along with the accounting RQ11.1 RQ13.2
unit and subaccount make up the location RQ35.1 RQ500
(account) where amounts and other RQIB.1 RQIF.1
account information is stored. RQII.1 RQIJ.1
RQH-SUB-ACCT Numeric 4 RQ10.1 RQ10.3
Element: Sub Acct This field contains the subaccount from RQ11.1 RQ13.2
your general ledger chart of accounts RQ35.1 RQ500
that was charged with the amount carried RQIB.1 RQIF.1
on this record. RQII.1 RQIJ.1
RQH-DIST-COMPANY Numeric 4 RQ10.1 RQ10.3
Element: Company Identifies the AP company if the RQ11.1 RQ13.2
resource type = V. Identifies the HR RQ35.1 RQ500
company if the resource type = E. It is RQIB.1 RQIF.1
blank for type A, P or Q resources. RQII.1 RQIJ.1
RQH-ASSET Numeric 10 RQ10.1 RQ10.3
Element: Asset The asset number contains up to ten RQ11.1 RQ13.2
numeric characters that uniquely RQ35.1 RQ500
identify an asset. Assets are RQIB.1 RQIF.1
automatically numbered system-wide. RQII.1 RQIJ.1
RQH-ASSET-TEMPLATE Alpha 10 RQ10.1 RQ10.3
Element: Asset TemplateA user-defined asset template RQ11.1 RQ13.2
identifies general asset creation RQ35.1 RQ500
parameters that you can use to quickly RQIB.1 RQIF.1
add assets with minimal keying. Using a RQII.1 RQIJ.1
template lets you default many data
items associated with a new asset.
You can use an asset template to
process quick asset additions in AM20.1
(Quick Addition) and to create assets
and asset books from Accounts Payable
and Activity Management interface
information. Asset templates are
required if you define new assets as a
result of transactions interfaced from
the Lawson Purchase Order or Accounts
Payable systems.
RQH-PURCH-TAX-CD Alpha 10 RQ10.1 RQ10.3
Element: Tax Code This field contains a code representing RQ11.1 RQ13.2
specific tax information. This must be RQ35.1 RQ500
valid Tax Code. RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PURCH-TAX-FL Alpha 1 RQ10.1 RQ10.3
Element: Purch Tax Fl This field indicates if this item is RQ11.1 RQ13.2
taxable when it is purchased for this RQ35.1 RQ500
location. Valid values are: RQIB.1 RQIF.1
N = Nontaxable. Default value. RQII.1 RQIJ.1
Y = Taxable.
RQH-OPERATOR-ID Alpha 10 RQ10.1 RQ10.3
Element: Operator This is the terminal signon identifier RQ11.1 RQ13.2
when this requisition was added to the RQ35.1 RQ500
database. RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-DROPSHIP-FL Alpha 1 RQ10.1 RQ10.3
Element: Dropship Fl This flag indicates whether goods being RQ11.1 RQ13.2
shipped by the vendor directly to a non RQ35.1 RQ500
standard location need to have the RQIB.1 RQIF.1
receiving process performed. RQII.1 RQIJ.1
Y = Yes
N = No
RQH-SH-NAME Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: Name Displays the company description. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-ADDR1 Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: Addr1 This field contains the first line of RQ11.1 RQ13.2
address information. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-ADDR2 Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: Addr1 This field contains the first line of RQ11.1 RQ13.2
address information. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-ADDR3 Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: Addr1 This field contains the first line of RQ11.1 RQ13.2
address information. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-ADDR4 Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: Addr1 This field contains the first line of RQ11.1 RQ13.2
address information. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-CITY-ADDR5 Alpha 18 (Lower Case) RQ10.1 RQ10.3
Element: City This field contains the city of the RQ11.1 RQ13.2
address. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-STATE-PROV Alpha 2 RQ10.1 RQ10.3
Element: State Prov The state or province. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-POST-CODE Alpha 10 (Lower Case) RQ10.1 RQ10.3
Element: Sh Post Code This is the ship to mail code. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-COUNTRY-CD Alpha 2 RQ10.1 RQ10.3
Element: Sh Country Cd RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-COUNTRY Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: Country This field contains the country of the RQ11.1 RQ13.2
address, or it can be used for RQ35.1 RQ500
additional information such as an RQIB.1 RQIF.1
attention name. RQII.1 RQIJ.1
RQH-SH-COUNTY Alpha 25 (Lower Case) RQ10.1 RQ10.3
Element: County The county for the company address. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-PHONE-PREF Alpha 6 RQ10.1 RQ10.3
Element: Phone Prefix The telephone number country code. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-PHONE Alpha 15 RQ10.1 RQ10.3
Element: Phone Phone number. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-PHONE-EXT Alpha 5 RQ10.1 RQ10.3
Element: Phone Ext This field contains the telephone RQ11.1 RQ13.2
extension number. RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-SH-CONTACT Alpha 30 (Lower Case) RQ10.1 RQ10.3
Element: Addr Contact This is the name of the main contact. RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-CAPITAL-TOTAL Signed 15.4
Element: Capital Total
RQH-TECH-TOTAL Signed 15.4
Element: Tech Total
RQH-CAP-TECH-TOTAL Signed 15.4
Element: Cap Tech Total
RQH-RECORD-SOURCE Numeric 2
Element: Record Source 01 = RQ10
02 = E-Requisitions
03 = RQ500
04 = IC83
05 = IC142
RQH-PFLOW-APRV-LVL Alpha 20 RQ10.1 RQ10.3
Element: Pflow Aprv Lvl RQ11.1 RQ13.1
RQ13.2 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-APPROVAL-TYPE Alpha 1 RQ10.1 RQ10.3
Element: Approval Type The type of approval record. RQ11.1 RQ13.2
0 = Header approval-Approval codes RQ35.1 RQ500
1 = Header approval-Process Flow RQIB.1 RQIF.1
2 = Line approval RQII.1 RQIJ.1
3 = No approval required
RQH-APPROVE-CD Alpha 5 RQ10.1 RQ10.3
Element: Approve Cd This is a code to identify the approval RQ11.1 RQ13.2
process (levels) that a requisition has RQ35.1 RQ500
to pass before it can be picked or RQIB.1 RQIF.1
purchased. RQII.1 RQIJ.1
RQH-BASE-CURR-CODE Alpha 5 RQ10.1 RQ10.3
Element: Currency Code This field contains the company base RQ11.1 RQ13.2
currency code established in Company RQ35.1 RQ500
(GL10.1 ). RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-TRAN-CURR-CODE Alpha 5 RQ10.1 RQ10.3
Element: Currency Code This field contains the company base RQ11.1 RQ13.2
currency code established in Company RQ35.1 RQ500
(GL10.1 ). RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-POB-NAME Alpha 30 (Lower Case)
Element: Name Displays the company description.
RQH-POB-ADDR1 Alpha 30 (Lower Case)
Element: Addr1 This field contains the first line of
address information.
RQH-POB-ADDR2 Alpha 30 (Lower Case)
Element: Addr1 This field contains the first line of
address information.
RQH-POB-ADDR3 Alpha 30 (Lower Case)
Element: Addr1 This field contains the first line of
address information.
RQH-POB-ADDR4 Alpha 30 (Lower Case)
Element: Addr1 This field contains the first line of
address information.
RQH-POB-CITY-ADDR5 Alpha 18 (Lower Case)
Element: City This field contains the city of the
address.
RQH-POB-STATE-PROV Alpha 2
Element: State Prov The state or province.
RQH-POB-POSTAL-CD Alpha 10 (Lower Case)
Element: Postal Code This field contains the postal code.
RQH-POB-COUNTRY-CD Alpha 2
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
RQH-POB-COUNTY Alpha 25 (Lower Case)
Element: County The county for the company address.
RQH-POB-CONTACT Alpha 30 (Lower Case)
Element: Addr Contact This is the name of the main contact.
RQH-RQ-SOURCE Numeric 2 RQ10.1 RQ10.3
Element: Rq Source 00 = Upgrade RQ11.1 RQ13.2
01 = IC142 RQ35.1 RQ500
02 = IC141 RQIB.1 RQIF.1
03 = IC83 RQII.1 RQIJ.1
04 = RQ35
05 = RQ500
06 = RSS
07 = RQ10
08 = DR100
RQH-ONE-SRC-ONE-PO Numeric 1 RQ10.1 RQ10.3
Element: One Src One Po0 RQ11.1 RQ13.2
1 RQ35.1 RQ500
2 = One Requisition to One PO RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-PCARD-NBR Alpha 16
Element: Pcard Nbr
RQH-SS-EVENT-REQD Numeric 1 RQ10.1 RQ10.3
Element: Ss Event Reqd RQ11.1 RQ13.2
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-APPROVAL-VAL Derived
Element: Approval Val This field is a sum of the three item
total fields (I Total, N Total, and S X
Total amount fields). This value is the
total value of the requisition. It is
used for approval processing.
RQH-WF-CO-REQ-NBR Derived
Element: Wf Co Req Nbr Used for Enterprise Workflow drill
around.
RQH-DER-STATUS Derived
Element: Der Status
REQHEADER FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQHSET1 COMPANY AP125 AP126
REQ-NUMBER AP131 AP20.1
AP20.2 AP20.3
AP20.4 AP20.5
AP20.7 AP21.1
AP23.1 AP25.1
AP25.2 AP26.1
AP27.1 AP30.4
API1.1 BL120
BL122 BL130
BL20.1 BL20.3
BL21.2 BL21.5
BL29.1 BL29.2
BL520 BL820
BL92.1 CXCP.1
...
RQHSET2 COMPANY KeyChange RQ01.1 RQ111
REQ-LOCATION RQ140 RQ300
REQUESTER RQ40.1
REQ-NUMBER
RQHSET3 REQUESTER RQ10.1 RQ35.1
REQ-NUMBER* RQ500 RQIF.1
COMPANY
RQHSET4 FROM-COMPANY KeyChange RQ41.1
FROM-LOCATION
STATUS
COMPANY
REQ-NUMBER
RQHSET5 COMPANY KeyChange, Subset
REFERENCE-NO Where REFERENCE-NO != Spaces
REQ-NUMBER
RQHSET6 COMPANY KeyChange, Subset
REQ-DESC Where REQ-DESC != Spaces
REQ-NUMBER
RQHSET7 REQUESTER RQ04.1 RQ10.1
REQ-NUMBER RQ500 RQCP.1
COMPANY RQD1.1 RQIF.1
RQII.1 RQIJ.1
RQHSET8 COMPANY Subset RQ02.1
REQ-NUMBER Where STATUS = Zeroes
REQHEADER FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Approve Code RQAPPCODE Required
RQH-COMPANY -> RAC-COMPANY
REQ-APPROVE-CD -> RAC-APPROVE-CD
From Location ICLOCATION Required
RQH-FROM-COMPANY -> ICL-COMPANY
RQH-FROM-LOCATION -> ICL-LOCATION
Ic Company ICCOMPANY Required
RQH-FROM-COMPANY -> ICC-COMPANY
Mmuaval MMUAVAL Not Required
RQH-COMPANY -> MUA-COMPANY
"RQ" -> MUA-SYSTEM-CD
RQH-FROM-LOCATION -> MUA-LOCATION
"RQ" -> MUA-DOC-TYPE
Spaces -> MUA-DOC-NUMBER
RQH-REQ-NUMBER -> MUA-DOC-NBR-NUM
Spaces -> MUA-PO-CODE
Zeroes -> MUA-LINE-NBR
Zeroes -> MUA-API-OBJ-ID
Zeroes -> MUA-SEQ-NBR
Porqhuf PORQHUF Not Required, Delete Cascades
RQH-COMPANY -> UFH-COMPANY
RQH-REQ-NUMBER -> UFH-REQ-NUMBER
Req Location RQLOC Required
RQH-COMPANY -> RQL-COMPANY
RQH-REQ-LOCATION -> RQL-REQ-LOCATION
Requester REQUESTER Required
RQH-REQUESTER -> REQ-REQUESTER
REQHEADER FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Approvals RQAPPROVE Delete Cascades
RQH-COMPANY -> RAP-COMPANY
RQH-REQ-NUMBER -> RAP-REQ-NUMBER
RAP-APRV-LEVEL
Req Lines REQLINE Delete Cascades
RQH-COMPANY -> RLN-COMPANY
RQH-REQ-NUMBER -> RLN-REQ-NUMBER
RLN-LINE-NBR
|