Requisition Header
This file contains the header information for each requisition.
REFERENCED BY
| CX05.1 | CX05.2 | CX805 | IC216 | IC243 | ICIA.1 |
| POI6.1 | RQ02.1 | RQ270 | RQ39.1 | RQ39.2 | RQ39.3 |
| RQCP.1 | RQIC.1 | RQID.1 | RQIG.1 | RQIH.1 | RQII.1 |
| WH110 | WH120 | WH21.1 | WH21.2 | WH21.3 | WH21.4 |
| WH210 | WH22.1 | WH224 |
| FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RQH-COMPANY Element: Company | Numeric 4 Enter the company number established in Company (IC01.1) or Company (MA01.1). |
|
||||||||||||||||||||
| RQH-REQ-NUMBER Element: Req Number | Numeric 7 Requisition numbers are automatically assigned if the company is set up for automatic numbering in Company (IC01.1) or Company (MA01.1). Otherwise, 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 Element: Requester | Alpha 10 (Lower Case) This is the person, department, or area requesting items. Requesters are defined in Requesters (RQ04.1). |
|
||||||||||||||||||||
| RQH-REQ-LOCATION Element: Req Location | Alpha 5 This is the location requesting items. This location can be an inventory location defined in Location (IC02.1) or a non-inventory location. All requesting 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 Element: Date | Numeric 8 (yyyymmdd) This is the requested delivery date. If left blank, this field defaults to the system date. The requested delivery date is used to schedule backorder 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 Element: Creation Date | Numeric 8 (yyyymmdd) This is the date that this line was added to the requisition. |
|
||||||||||||||||||||
| RQH-REFERENCE-NO Element: Reference No | Alpha 10 (Right Justified) |
|
||||||||||||||||||||
| RQH-REQ-DESC Element: Req Desc | Alpha 30 (Lower Case) |
|
||||||||||||||||||||
| RQH-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. |
|
||||||||||||||||||||
| RQH-FROM-LOCATION Element: Location | Alpha 5 This field contains a valid stocking location within the company inventory. |
|
||||||||||||||||||||
| RQH-DELIVER-TO Element: Deliver To | Alpha 30 (Lower Case) This is additional information regarding where the requested items are to be delivered. This is a user-defined field that displays online and on the delivery ticket. |
|
||||||||||||||||||||
| RQH-BUYER-CODE Element: Buyer | Alpha 3 The user defined buyer code defined in Buyer (PO04.1). |
|
||||||||||||||||||||
| RQH-VENDOR Element: Vendor | Alpha 9 (Right Justified) Enter the suggested vendor code for the requisition. The vendor code defaults to all subsequent requisition lines. The suggested vendor prints on the 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 Element: Purch Fr Loc | Alpha 4 Enter the suggested purchase from location for the entered vendor. Vendors can have multiple purchase from locations. The purchase from location 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 Element: Vendor Name | Alpha 30 Enter the recommended vendor's name for the requisition. If left blank, this defaults to the vendor's name defined in the Accounts Payable (AP) Vendor form. |
|
||||||||||||||||||||
| RQH-PRINT-REQ-FL Element: All Flag | Alpha 1 This flag indicates whether you want to print the requisition in RQ111 (Print Requisitions). This flag defaults based on the approval assigned to the requester. It can be overridden when the 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 Element: Line Nbr | Numeric 6 The number of the last line item added to the requisition. This number determines what the next line number is when you add another item. |
|
||||||||||||||||||||
| RQH-LAST-DEL-SEQ Element: Seq | Numeric 3 This field contains the record sequence number. |
|
||||||||||||||||||||
| RQH-RETURN-SEQ Element: Seq | Numeric 3 This number indicates the number of times a return has been made against a requisition. |
|
||||||||||||||||||||
| RQH-STATUS Element: Status | Numeric 1 This is the processing status of the requisition as described below. Released = Requisition has been released in RQ10.1 (Requisition). Unreleased = Requisition added but not 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 Element: Po User Fld 1 | Alpha 1 Purchase Order header user field one. |
|
||||||||||||||||||||
| RQH-PO-USER-FLD-3 Element: User Field2 | Alpha 30 Purchase Order header user field three. |
|
||||||||||||||||||||
| RQH-PO-USER-FLD-5 Element: User Fld2 | Alpha 30 (Lower Case) Purchase Order header user field five. |
|
||||||||||||||||||||
| RQH-USER-DATE-1 Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||||||||||||||||
| RQH-USER-DATE-2 Element: Date | Numeric 8 (yyyymmdd) This field displays the system date when this was created. |
|
||||||||||||||||||||
| RQH-LAST-APRV-DT Element: Date | Numeric 8 (yyyymmdd) This is the last approval date for the requisition. Requisitions are approved in RQ12.1 (Approval Review). |
|
||||||||||||||||||||
| RQH-APPROVED-FL Element: All Flag | Alpha 1 This flag indicates that this requisition has been approved at all required approval levels. Required approval levels are defined by amount in RQ02.1 (Approval Codes). N = No Y = Yes |
|
||||||||||||||||||||
| RQH-ATTAIN-LEVEL Element: Aprv Level | Numeric 1 This is the highest approval level required for the requisition. The requisition must be approved at this level for further processing. |
|
||||||||||||||||||||
| RQH-APRV-LEVEL Element: Aprv Level | Numeric 1 This is the approval level that this requisition has attained so far in RQ12.1 (Approval Review). |
|
||||||||||||||||||||
| RQH-NBR-LINES Element: Nbr Lines | Numeric 6 This is the number of detail lines. |
|
||||||||||||||||||||
| RQH-CLOSED-LINES Element: Closed Lines | Numeric 6 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 Element: Closed Fl | Alpha 1 The Closed Flag. Y = Yes N = No |
|||||||||||||||||||||
| RQH-I-TOTAL Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||
| RQH-N-TOTAL Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||
| RQH-X-S-TOTAL Element: Intl Amt | Signed 18.2 |
|
||||||||||||||||||||
| RQH-PRINTED-FL Element: Printed Fl | Alpha 1 This flag indicates whether the requisition has been printed in RQ111 (Print Requisitions). |
|
||||||||||||||||||||
| RQH-ALLOC-PRI Element: Alloc Pri | Numeric 2 This is the allocation priority for this requisition. Valid values are from 0 to 99, with 99 being the highest. This field defaults to 50. This field is used in the Warehouse module to determine the order in which inventory demand gets allocated. |
|
||||||||||||||||||||
| RQH-QUOTE-FL Element: Quote Fl | Alpha 1 This flag indicates if the buyer should get quotes for this requisition before it is turned into a purchase order. |
|
||||||||||||||||||||
| RQH-RETURN-NOTE Element: Note | Alpha 12 This is a user defined field available for data entry in RQ35.1 (Requisition Returns). |
|
||||||||||||||||||||
| RQH-RETURN-DATE Element: Date | Numeric 8 (yyyymmdd) This is the return transaction date for a requisition item processed in RQ35.1 (Requisition Returns). |
|
||||||||||||||||||||
| RQH-ACTIVITY Element: Activity | Alpha 15 Activities are the processes or procedures that produce work. Cost objects (products, services, customers, and so on) are the reasons for performing the activity. |
|
||||||||||||||||||||
| RQH-ACCT-CATEGORY Element: Acct Category | Alpha 5 Account categories are groupings of costs, revenues, or a combination of both used for reporting and inquiries for activities in the Activity 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 Element: Bill Category | Alpha 32 |
|
||||||||||||||||||||
| RQH-ACCT-UNIT Element: Acct Unit | Alpha 15 The accounting unit is a shorthand notation representing the variable level number. When used in the General Ledger Account Master file, the accounting unit must be defined in the General Ledger Names file as a posting accounting unit. |
|
||||||||||||||||||||
| RQH-ACCOUNT Element: Account | Numeric 6 This field along with the accounting unit and subaccount make up the location (account) where amounts and other account information is stored. |
|
||||||||||||||||||||
| RQH-SUB-ACCT Element: Sub Acct | Numeric 4 This field contains the subaccount from your general ledger chart of accounts that was charged with the amount carried on this record. |
|
||||||||||||||||||||
| RQH-DIST-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. |
|
||||||||||||||||||||
| RQH-ASSET Element: Asset | Numeric 10 The asset number contains up to ten numeric characters that uniquely identify an asset. Assets are automatically numbered system-wide. |
|
||||||||||||||||||||
| RQH-ASSET-TEMPLATE Element: Asset Template | Alpha 10 A user-defined asset template identifies general asset creation parameters that you can use to quickly add assets with minimal keying. Using a 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 Element: Tax Code | Alpha 10 This field contains a code representing specific tax information. This must be valid Tax Code. |
|
||||||||||||||||||||
| RQH-PURCH-TAX-FL Element: Purch Tax Fl | Alpha 1 This field indicates if this item is taxable when it is purchased for this location. Valid values are: N = Nontaxable. Default value. Y = Taxable. |
|
||||||||||||||||||||
| RQH-OPERATOR-ID Element: Operator | Alpha 10 This is the terminal signon identifier when this requisition was added to the database. |
|
||||||||||||||||||||
| RQH-DROPSHIP-FL Element: Dropship Fl | Alpha 1 This flag indicates whether goods being shipped by the vendor directly to a non standard location need to have the receiving process performed. Y = Yes N = No |
|
||||||||||||||||||||
| RQH-SH-NAME Element: Name | Alpha 30 (Lower Case) Displays the company description. |
|
||||||||||||||||||||
| RQH-SH-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||
| RQH-SH-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||
| RQH-SH-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||
| RQH-SH-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||
| RQH-SH-CITY-ADDR5 Element: City | Alpha 18 (Lower Case) This field contains the city of the address. |
|
||||||||||||||||||||
| RQH-SH-STATE-PROV Element: State Prov | Alpha 2 The state or province. |
|
||||||||||||||||||||
| RQH-SH-POST-CODE Element: Sh Post Code | Alpha 10 (Lower Case) This is the ship to mail code. |
|
||||||||||||||||||||
| RQH-SH-COUNTRY-CD Element: Sh Country Cd | Alpha 2 |
|
||||||||||||||||||||
| RQH-SH-COUNTRY Element: Country | Alpha 30 (Lower Case) This field contains the country of the address, or it can be used for additional information such as an attention name. |
|
||||||||||||||||||||
| RQH-SH-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address. |
|
||||||||||||||||||||
| RQH-SH-PHONE-PREF Element: Phone Prefix | Alpha 6 The telephone number country code. |
|
||||||||||||||||||||
| RQH-SH-PHONE Element: Phone | Alpha 15 Phone number. |
|
||||||||||||||||||||
| RQH-SH-PHONE-EXT Element: Phone Ext | Alpha 5 This field contains the telephone extension number. |
|
||||||||||||||||||||
| RQH-SH-CONTACT Element: Addr Contact | Alpha 30 (Lower Case) This is the name of the main contact. |
|
||||||||||||||||||||
| RQH-CAPITAL-TOTAL Element: Capital Total | Signed 15.4 |
|
||||||||||||||||||||
| RQH-TECH-TOTAL Element: Tech Total | Signed 15.4 |
|
||||||||||||||||||||
| RQH-CAP-TECH-TOTAL Element: Cap Tech Total | Signed 15.4 |
|
||||||||||||||||||||
| RQH-RECORD-SOURCE Element: Record Source | Numeric 2 01 = RQ10 02 = E-Requisitions 03 = RQ500 04 = IC83 05 = IC142 |
|
||||||||||||||||||||
| RQH-PFLOW-APRV-LVL Element: Pflow Aprv Lvl | Alpha 20 |
|
||||||||||||||||||||
| RQH-APPROVAL-TYPE Element: Approval Type | Alpha 1 The type of approval record. 0 = Header approval-Approval codes 1 = Header approval-Process Flow 2 = Line approval 3 = No approval required |
|
||||||||||||||||||||
| RQH-APPROVE-CD Element: Approve Cd | Alpha 5 This is a code to identify the approval process (levels) that a requisition has to pass before it can be picked or purchased. |
|
||||||||||||||||||||
| RQH-BASE-CURR-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||||
| RQH-TRAN-CURR-CODE Element: Currency Code | Alpha 5 This field contains the company base currency code established in Company (GL10.1 ). |
|
||||||||||||||||||||
| RQH-POB-NAME Element: Name | Alpha 30 (Lower Case) Displays the company description. |
|
||||||||||||||||||||
| RQH-POB-ADDR1 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||
| RQH-POB-ADDR2 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||
| RQH-POB-ADDR3 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||
| RQH-POB-ADDR4 Element: Addr1 | Alpha 30 (Lower Case) This field contains the first line of address information. |
|
||||||||||||||||||||
| RQH-POB-CITY-ADDR5 Element: City | Alpha 18 (Lower Case) This field contains the city of the address. |
|
||||||||||||||||||||
| RQH-POB-STATE-PROV Element: State Prov | Alpha 2 The state or province. |
|
||||||||||||||||||||
| RQH-POB-POSTAL-CD Element: Postal Code | Alpha 10 (Lower Case) This field contains the postal code. |
|
||||||||||||||||||||
| RQH-POB-COUNTRY-CD Element: Country Code | Alpha 2 The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance). |
|
||||||||||||||||||||
| RQH-POB-COUNTY Element: County | Alpha 25 (Lower Case) The county for the company address. |
|
||||||||||||||||||||
| RQH-POB-CONTACT Element: Addr Contact | Alpha 30 (Lower Case) This is the name of the main contact. |
|
||||||||||||||||||||
| RQH-RQ-SOURCE Element: Rq Source | Numeric 2 00 = Upgrade 01 = IC142 02 = IC141 03 = IC83 04 = RQ35 05 = RQ500 06 = RQC 07 = RQ10 08 = DR100 97 = Perfect Commerce 98 = SciQuest |
|
||||||||||||||||||||
| RQH-ONE-SRC-ONE-PO Element: One Src One Po | Numeric 1 0 1 2 = One Requisition to One PO |
|
||||||||||||||||||||
| RQH-PCARD-NBR Element: Pcard Nbr | Alpha 16 |
|
||||||||||||||||||||
| RQH-SS-EVENT-REQD Element: Ss Event Reqd | Numeric 1 |
|
||||||||||||||||||||
| RQH-APPROVAL-VAL Element: Approval Val | Derived 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 Element: Wf Co Req Nbr | Derived Used for Enterprise Workflow drill around. |
|
||||||||||||||||||||
| RQH-DER-STATUS Element: Der Status | Derived |
|
||||||||||||||||||||
| RQH-POB-PHONE-PREF Element: Phone Prefix | Alpha 6 |
|
||||||||||||||||||||
| RQH-POB-PHONE Element: Phone | Alpha 15 |
|
||||||||||||||||||||
| RQH-POB-PHONE-EXT Element: Phone Ext | Alpha 5 |
|
||||||||||||||||||||
| RQH-POB-EMAIL-ADDR Element: Email Address | Alpha 60 (Lower Case) |
|
||||||||||||||||||||
| RQH-LOCATION-RULE Element: Rule Name | Alpha 12 |
|
||||||||||||||||||||
| RQH-RELEASED-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||
| RQH-RELEASED-TIME Element: Time | Numeric 8 |
|
||||||||||||||||||||
| RQH-REL-OPER-ID Element: Operator | Alpha 10 |
|
||||||||||||||||||||
| RQH-APR-REJ-DATE Element: Date | Numeric 8 (yyyymmdd) |
|
||||||||||||||||||||
| RQH-APR-REJ-TIME Element: Time | Numeric 8 |
|
||||||||||||||||||||
| RQH-APR-REJ-OPR-ID Element: Operator | Alpha 10 |
|
||||||||||||||||||||
| RQH-PO-USER-FLD-7 Element: User Fld 7 | Alpha 10 (Lower Case) |
|
||||||||||||||||||||
| RQH-CREATION-TIME Element: Time | Numeric 8 |
|
| NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RQHSET1 |
COMPANY REQ-NUMBER |
|
|||||||||||||||||
| RQHSET2 |
COMPANY REQ-LOCATION REQUESTER REQ-NUMBER |
|
| ||||||||||||||||
| RQHSET3 |
REQUESTER REQ-NUMBER* COMPANY |
|
| ||||||||||||||||
| RQHSET4 |
FROM-COMPANY FROM-LOCATION STATUS COMPANY REQ-NUMBER |
|
| ||||||||||||||||
| RQHSET5 |
COMPANY REFERENCE-NO REQ-NUMBER |
|
|||||||||||||||||
| RQHSET6 |
COMPANY REQ-DESC REQ-NUMBER |
|
|||||||||||||||||
| RQHSET7 |
REQUESTER REQ-NUMBER COMPANY |
|
| ||||||||||||||||
| RQHSET8 |
COMPANY REQ-NUMBER |
|
| ||||||||||||||||
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Approve Code | RQAPPCODE |
Required
| ||||||||||||||||||||||||||||||
| From Location | ICLOCATION |
Required
| ||||||||||||||||||||||||||||||
| Ic Company | ICCOMPANY |
Required
| ||||||||||||||||||||||||||||||
| Mmuaval | MMUAVAL |
Not Required
| ||||||||||||||||||||||||||||||
| Porqhuf | PORQHUF |
Not Required, Delete Cascades
| ||||||||||||||||||||||||||||||
| Req Location | RQLOC |
Required
| ||||||||||||||||||||||||||||||
| Requester | REQUESTER |
Required
|
| RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| Approvals | RQAPPROVE |
Delete Cascades
| |||||||||
| Location Rule | WHLOCRULE |
| |||||||||
| Req Lines | REQLINE |
Delete Cascades
|
All trademarks and registered trademarks are the property of their
respective owners.