Lawson Insight Technical Documentation |
|
REQHEADER
REQHEADER FILE
Requisition Header
This file contains the header information for each requisition.
REFERENCED BY
AP125 AP126 AP131 AP20.1 AP20.2 AP20.3
AP20.4 AP20.5 AP20.7 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 CXCP.1 IC243
IC28.1 MA180 MA41.2 MA41.7 MA43.1 MA43.2
MA43.3 MA43.9 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 PO100 PO101
PO122 PO131 PO20.1 PO21.1 PO21.2 PO21.3
PO21.4 PO21.5 PO22.1 PO23.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 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 POI4.1 POI6.1 POII.1 POIJ.1
RQ39.1 RQ39.2 RQ39.3 RQ42.1 RQCP.1 RQIC.1
RQID.1 RQIE.1 RQIG.1 RQIH.1 WH110 WH120
WH20.1 WH20.2 WH20.3 WH20.4 WH20.5 WH20.6
WH20.7 WH21.1 WH21.2 WH21.3 WH21.4 WH210
WH22.1 WH222 WH224 WO120 WO131 WO132
WO133 WO140 WO20.1 WO30.1 WO32.1 WO32.2
WO32.3 WO32.4 WO32.5 WO40.1 WO40.2 WO40.3
WO40.4 WO40.5 WO41.1 WO41.2 WO41.3 WO41.4
WO42.1 WO42.2 WO42.3 WO42.4 WO42.5 WO45.1
WOEX.1 WOSP.1 RQ01.1 RQ04.1 RQII.1
UPDATED BY
DR100 IC141 IC142 IC83.1 POID.1 RQ10.1
RQ10.3 RQ11.1 RQ111 RQ12.1 RQ13.1 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 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.5
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 DR100 IC141
Element: Company Enter the company number established in IC142 IC83.1
IC01.1 (Company) or MA00.1 (Company). RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-REQ-NUMBER Numeric 7 DR100 IC141
Element: Requisition NuRequisition numbers are automatically IC142 IC83.1
assigned if the company is set up for RQ10.1 RQ10.3
automatic numbering in IC01.1 (Company) RQ11.1 RQ35.1
or MA00.1 (Company). Otherwise, RQ500 RQIB.1
requisition numbers are user defined. RQIF.1 RQII.1
RQIJ.1
Automatically assigned requisition
numbers are incremented by one from the
last number used, as defined in IC01.1
or MA00.1.
RQH-REQUESTER Alpha 10 (Lower Case) DR100 IC141
Element: Requester This is the person, department, or area IC142 IC83.1
requesting items. Requesters are defined RQ10.1 RQ10.3
in RQ04.1 (Requesters). RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-REQ-LOCATION Alpha 5 DR100 IC141
Element: Location Code This is the location requesting items. IC142 IC83.1
This location can be an inventory RQ10.1 RQ10.3
location defined in IC02.1 (Location) or RQ11.1 RQ35.1
a noninventory location. All requesting RQ500 RQIB.1
locations must be defined in RQ01.1 RQIF.1 RQII.1
(Requesting Locations). Requesting RQIJ.1
locations may be assigned to the
requester in the RQ04.1 (Requesters)
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) DR100 IC141
Element: Date This is the requested delivery date. IC142 IC83.1
RQ10.1 RQ10.3
If left blank, this field defaults to RQ11.1 RQ35.1
the system date. The requested delivery RQ500 RQIB.1
date is used to schedule backorder RQIF.1 RQII.1
allocations (that is, requisitions with RQIJ.1 WH132
the oldest requisition delivery date WH222
having backorders are filled before
later dated requisitions for the same
item). You can override this date.
RQH-CREATION-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: Date IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-REFERENCE-NO Alpha 10 (Right Justified) DR100 IC141
Element: Reference No IC142 IC83.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-REQ-DESC Alpha 30 (Lower Case) DR100 IC141
Element: Req Desc IC142 IC83.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-FROM-COMPANY Numeric 4 DR100 IC141
Element: Company IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-FROM-LOCATION Alpha 5 DR100 IC141
Element: Location Code IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-DELIVER-TO Alpha 30 (Lower Case) DR100 IC141
Element: Deliver To NamThis is additional information IC142 IC83.1
regarding where the requested items are RQ10.1 RQ10.3
to be delivered. This is a user-defined RQ11.1 RQ35.1
field that displays online and on the RQ500 RQIB.1
delivery ticket printed by RQ120 RQIF.1 RQII.1
(Delivery Ticket). RQIJ.1
RQH-BUYER-CODE Alpha 3 DR100 IC141
Element: Buyer The user defined buyer code defined in IC142 IC83.1
MA04.1 (Buyer). RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-VENDOR Alpha 9 (Right Justified) DR100 IC141
Element: Vendor ID Enter the suggested vendor code for the IC142 IC83.1
requisition. The vendor code defaults to RQ10.1 RQ10.3
all subsequent requisition lines. The RQ11.1 RQ35.1
suggested vendor prints on the RQ500 RQIB.1
requisition when you run RQ111 (Print RQIF.1 RQII.1
Requisitions).The vendor can be changed RQIJ.1
when a purchase order is created. The
vendor must be defined in the Accounts
Payable (AP) Vendor form.
RQH-PURCH-FR-LOC Alpha 4 DR100 IC141
Purchase From Enter the suggested purchase from IC142 IC83.1
Location Code location for the entered vendor. Vendors RQ10.1 RQ10.3
can have multiple purchase from RQ11.1 RQ35.1
locations. The purchase from location RQ500 RQIB.1
code prints on the requisition when you RQIF.1 RQII.1
run RQ111 (Print Requisitions). As with RQIJ.1
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 the Accounts Payable (AP)
Alternate Location form.
RQH-VENDOR-NAME Alpha 30 DR100 IC141
Element: Vendor Name Enter the recommended vendor's name for IC142 IC83.1
the requisition. If left blank, this RQ10.1 RQ10.3
defaults to the vendor's name defined in RQ11.1 RQ35.1
the Accounts Payable (AP) Vendor form. RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PRINT-REQ-FL Alpha 1 DR100 IC141
Element: All Flag This flag indicates whether you want to IC142 IC83.1
print the requisition in RQ111 (Print RQ10.1 RQ10.3
Requisitions). This flag defaults based RQ11.1 RQ111
on the approval assigned to the RQ35.1 RQ500
requester. It can be overridden when the RQIB.1 RQIF.1
requisition is created. RQII.1 RQIJ.1
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 DR100 IC141
Element: Line Number The number of the last line item added IC142 IC83.1
to the requisition. This number RQ10.1 RQ10.3
determines what the next line number is RQ11.1 RQ35.1
when you add another item. RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-LAST-DEL-SEQ Numeric 3 DR100 IC141
Element: Sequence Number IC142 IC83.1
POID.1 RQ10.1
RQ10.3 RQ11.1
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-RETURN-SEQ Numeric 3 DR100 IC141
Element: Sequence NumbeThis number indicates the number of IC142 IC83.1
times a return has been made against a RQ10.1 RQ10.3
requisition. RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-STATUS Numeric 1 DR100 IC141
Element: Status This is the processing status of the IC142 IC83.1
requisition as described below. PO100 PO23.1
RQ10.1 RQ10.3
Released = Requisition has been released RQ11.1 RQ12.1
in RQ10.1 (Requisition). RQ13.1 RQ35.1
RQ500 RQIB.1
Unreleased = Requisition added but not RQIF.1 RQII.1
released in RQ10.1 (Requisition). RQIJ.1
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
9 = Processed
8 = Rejected
RQH-PO-USER-FLD-1 Alpha 1 DR100 IC141
Element: Account Flag Purchase Order header user field one. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PO-USER-FLD-3 Alpha 10 (Lower Case) DR100 IC141
Item Mster User Purchase Order header user field three. IC142 IC83.1
Defined Field2 RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PO-USER-FLD-5 Alpha 30 (Lower Case) DR100 IC141
Element: User Defined FPurchase Order header user field five. IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-USER-DATE-1 Numeric 8 (yyyymmdd) DR100 IC141
Element: Date IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-USER-DATE-2 Numeric 8 (yyyymmdd) DR100 IC141
Element: Date IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-LAST-APRV-DT Numeric 8 (yyyymmdd) DR100 IC141
Element: Date This is the last approval date for the IC142 IC83.1
requisition. Requisitions are approved RQ10.1 RQ10.3
in RQ12.1 (Approval Review). RQ11.1 RQ12.1
RQ13.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-APPROVED-FL Alpha 1 DR100 IC141
Element: All Flag This flag indicates that this IC142 IC83.1
requisition has been approved at all RQ10.1 RQ10.3
required approval levels. Required RQ11.1 RQ12.1
approval levels are defined by amount in RQ13.1 RQ35.1
RQ02.1 (Approval Codes). RQ500 RQIB.1
N = No RQIF.1 RQII.1
Y = Yes RQIJ.1
RQH-ATTAIN-LEVEL Numeric 1 DR100 IC141
Element: Approval LevelThis is the highest approval level IC142 IC83.1
required for the requisition. The RQ10.1 RQ10.3
requisition must be approved at this RQ11.1 RQ12.1
level for further processing. RQ13.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-APRV-LEVEL Numeric 1 DR100 IC141
Element: Approval LevelThis is the approval level that this IC142 IC83.1
requisition has attained so far in RQ10.1 RQ10.3
RQ12.1 (Approval Review). RQ11.1 RQ12.1
RQ13.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-NBR-LINES Numeric 6 DR100 IC141
Element: Line Number IC142 IC83.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-CLOSED-LINES Numeric 6 RQD1.1
Element: Line Number 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 DR100 IC141
Element: All Flag Y = Yes IC142 IC83.1
N = No POID.1 RQ10.1
RQ10.3 RQ11.1
RQ140 RQ300
RQ35.1 RQ40.1
RQ41.1 RQ44.1
RQ44.2 RQ500
RQD1.1 RQIB.1
RQIF.1 RQII.1
RQIJ.1 WH130
WH132 WH190
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.5 WH34.1
WH34.2 WH34.3
WH34.4 WH40.1
WH40.2 WH520
WH830 WHD2.1
RQH-I-TOTAL Signed 15.4 DR100 IC141
Element: I Total Total amount (quantity times unit cost) IC142 IC83.1
of all inventory items on the RQ10.1 RQ10.3
requisition. RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-N-TOTAL Signed 15.4 DR100 IC141
Element: I Total IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-X-S-TOTAL Signed 15.4 DR100 IC141
Element: I Total IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PRINTED-FL Alpha 1 DR100 IC141
Element: Printed Flag This flag indicates whether the IC142 IC83.1
requisition has been printed in RQ111 RQ10.1 RQ10.3
(Print Requisitions). RQ11.1 RQ111
RQ35.1 RQ500
RQIB.1 RQIF.1
RQII.1 RQIJ.1
RQH-ALLOC-PRI Numeric 2 DR100 IC141
Element: Alloc Pri This is the allocation priority for IC142 IC83.1
this requisition. Valid values are from RQ10.1 RQ10.3
0 to 99, with 99 being the highest. This RQ11.1 RQ35.1
field defaults to 50. This field is RQ500 RQIB.1
used in the Warehouse module to RQIF.1 RQII.1
determine the order in which inventory RQIJ.1
demand gets allocated.
RQH-QUOTE-FL Alpha 1 DR100 IC141
Element: Quote Flag This flag indicates if the buyer should IC142 IC83.1
get quotes for this requisition before RQ10.1 RQ10.3
it is turned into a purchase order. RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-RETURN-NOTE Alpha 12 DR100 IC141
Element: Note This is a user defined field available IC142 IC83.1
for data entry in RQ35.1 (Requisition RQ10.1 RQ10.3
Returns). RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-RETURN-DATE Numeric 8 (yyyymmdd) DR100 IC141
Element: Date This is the return transaction date for IC142 IC83.1
a requisition item processed in RQ35.1 RQ10.1 RQ10.3
(Requisition Returns). RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-ACTIVITY Alpha 15 DR100 IC141
Element: Activity Activities are the processes or IC142 IC83.1
procedures that produce work. Cost RQ10.1 RQ10.3
objects (products, services, customers, RQ11.1 RQ35.1
and so on) are the reasons for RQ500 RQIB.1
performing the activity. RQIF.1 RQII.1
RQIJ.1
RQH-ACCT-CATEGORY Alpha 5 DR100 IC141
Element: Account CategoAccount categories are groupings of IC142 IC83.1
costs, revenues, or a combination of RQ10.1 RQ10.3
both used for reporting and inquiries RQ11.1 RQ35.1
for activities in the Activity RQ500 RQIB.1
Management system. All transactions are RQIF.1 RQII.1
posted to an account category within an RQIJ.1
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.
RQH-ACCT-UNIT Alpha 15 DR100 IC141
Element: Accounting UniThe accounting unit is a shorthand IC142 IC83.1
notation representing the variable level RQ10.1 RQ10.3
number. When used in the General Ledger RQ11.1 RQ35.1
Account Master file, the accounting unit RQ500 RQIB.1
must be defined in the General Ledger RQIF.1 RQII.1
Names file as a posting accounting unit. RQIJ.1
RQH-ACCOUNT Numeric 6 DR100 IC141
Element: Account This field along with the accounting IC142 IC83.1
unit and subaccount make up the location RQ10.1 RQ10.3
(account) where amounts and other RQ11.1 RQ35.1
account information is stored. RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SUB-ACCT Numeric 4 DR100 IC141
Element: Subaccount This field contains the subaccount from IC142 IC83.1
your general ledger chart of accounts RQ10.1 RQ10.3
that was charged with the amount carried RQ11.1 RQ35.1
on this record. RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-DIST-COMPANY Numeric 4 DR100 IC141
Element: Company IC142 IC83.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-ASSET Numeric 10 DR100 IC141
Element: Asset Number The asset number contains up to ten IC142 IC83.1
numeric characters that uniquely RQ500 RQIB.1
identify an asset. Assets are RQIF.1 RQII.1
automatically numbered system-wide. RQIJ.1
RQH-ASSET-TEMPLATE Alpha 10 DR100 IC141
Element: Asset TemplateA user-defined asset template IC142 IC83.1
identifies general asset creation RQ500 RQIB.1
parameters that you can use to quickly RQIF.1 RQII.1
add assets with minimal keying. Using a 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 DR100 IC141
Element: Tax Code IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-PURCH-TAX-FL Alpha 1 DR100 IC141
Element: Purchasing TaxThis field indicates if this item is IC142 IC83.1
taxable when it is purchased for this RQ10.1 RQ10.3
location. Valid values are: RQ11.1 RQ35.1
N = Nontaxable. Default value. RQ500 RQIB.1
Y = Taxable. RQIF.1 RQII.1
RQIJ.1
RQH-OPERATOR-ID Alpha 10 DR100 IC141
Element: Operator Code This is the terminal signon identifier IC142 IC83.1
when this requisition was added to the RQ10.1 RQ10.3
database. RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-DROPSHIP-FL Alpha 1 DR100 IC141
Element: Dropship Flag This flag indicates whether goods being IC142 IC83.1
shipped by the vendor directly to a non RQ10.1 RQ10.3
standard location need to have the RQ11.1 RQ35.1
receiving process performed. RQ500 RQIB.1
Y = Yes RQIF.1 RQII.1
N = No RQIJ.1
RQH-DROPSH-REQ-LOC Alpha 1 DR100 IC141
Element: Dropsh Req LocY = Yes IC142 IC83.1
N = No RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-NAME Alpha 30 (Lower Case) DR100 IC141
Element: Name IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-ADDR1 Alpha 30 (Lower Case) DR100 IC141
Element: Address 1 IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-ADDR2 Alpha 30 (Lower Case) DR100 IC141
Element: Address 1 IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-ADDR3 Alpha 30 (Lower Case) DR100 IC141
Element: Address 1 IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-ADDR4 Alpha 30 (Lower Case) DR100 IC141
Element: Address 1 IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-CITY-ADDR5 Alpha 18 (Lower Case) DR100 IC141
Element: City IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-STATE-PROV Alpha 2 DR100 IC141
Element: State or Province IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-POST-CODE Alpha 10 (Lower Case) DR100 IC141
Element: Postal Code IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-COUNTRY-CD Alpha 2 DR100 IC141
Element: Sh Country Cd IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-COUNTRY Alpha 30 (Lower Case) DR100 IC141
Element: Country or Other IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-COUNTY Alpha 25 (Lower Case) DR100 IC141
Element: County IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-PHONE-PREF Alpha 6 DR100 IC141
Telephone Country IC142 IC83.1
Code RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-PHONE Alpha 15 DR100 IC141
Element: Telephone Number IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-PHONE-EXT Alpha 5 DR100 IC141
Element: Telephone Extension IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ35.1
RQ500 RQIB.1
RQIF.1 RQII.1
RQIJ.1
RQH-SH-CONTACT Alpha 30 (Lower Case) DR100 IC141
Element: Contact IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 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 DR100 IC141
Element: Pflow Aprv Lvl IC142 IC83.1
RQ10.1 RQ10.3
RQ11.1 RQ13.1
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 This index is used to access AP125 AP126
REQ-NUMBER requisition header records for a AP131 AP20.1
specific company and requisition AP20.2 AP20.3
number. AP20.4 AP20.5
AP20.7 AP23.1
AP25.1 AP25.2
AP26.1 AP27.1
AP30.4 API1.1
CXCP.1 DR100
IC141 IC142
IC243 IC28.1
IC83.1 MA180
MA41.2 MA41.7
MA43.1 MA43.2
MA43.3 MA43.9
...
RQHSET2 COMPANY This index is used to access DR100 IC141
REQ-LOCATION requisition header records by RQ01.1 RQ140
REQUESTER requisition number for a requester at a RQ40.1
REQ-NUMBER specific company and requesting
location.
KeyChange
RQHSET3 REQUESTER Used for SEA database lookups
REQ-NUMBER*
COMPANY
RQHSET4 FROM-COMPANY This index is used to access RQ41.1
FROM-LOCATION requisition header records that have a
STATUS specific requisition number, status,
REQ-NUMBER from company, and from location.
KeyChange
RQHSET5 COMPANY This index is used to access a
REFERENCE-NO requisition header record issued for a
REQ-NUMBER specific company buyer and having a
specific requisition number and status.
Subset
Where REFERENCE-NO != Spaces
RQHSET6 COMPANY Subset
REQ-DESC Where REQ-DESC != Spaces
REQ-NUMBER
RQHSET7 REQUESTER This index is used to access a IC83.1 RQ04.1
REQ-NUMBER requisition header record for a specific RQ10.1 RQ500
COMPANY company, requester, and requisition RQCP.1 RQD1.1
number. RQIF.1 RQII.1
RQIJ.1
RQHSET8 COMPANY Subset
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 (RACSET1)
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 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
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
|