RQLOC

Requesting Locations

This file contains the valid requesting locations for the company. If the transaction type is an Issue, the requesting location does not have to be a valid inventory stock location. It can be a user defined entity, such as a department, cost center, or machine. If the transaction type is a T (Direct Transfer) or X (Intransit Transfer), the requesting location has to be a defined as a location in Inventory Control.

REFERENCED 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 API2.1
MA41.1 MA41.2 MA41.4 MA41.7 MA43.1 MA43.2
MA43.3 MA43.4 MA43.6 MA43.7 MAI1.1 PO04.3
PO136 PO15.1 PO15.2 PO15.4 PO190 PO204
PO300 PO520 POCP.1 POI3.1 POI7.1 POII.1
POIJ.1 POIM.1 MM280 MX223 RQ50.1


UPDATED BY
AP510 MX500 RQ01.1 RQ01.2 RQ01.3 RQBL.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQL-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.
AP510 RQ01.1
RQL-REQ-LOCATION
Element: Req Location
Alpha 5
The location requisitioning items. This location can be an inventory or noninventory location.
AP510 RQ01.1
RQL-NAME
Element: Name
Alpha 30 (Lower Case)
The requesting location name or description.
AP510 RQ01.1
RQL-ADDR1
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 RQ01.1
RQL-ADDR2
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 RQ01.1
RQL-ADDR3
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 RQ01.1
RQL-ADDR4
Element: Addr1
Alpha 30 (Lower Case)
This field contains the first line of address information.
AP510 RQ01.1
RQL-CITY-ADDR5
Element: City
Alpha 18 (Lower Case)
This field contains the city of the address.
AP510 RQ01.1
RQL-STATE-PROV
Element: State Prov
Alpha 2
The state or province.
AP510 RQ01.1
RQL-COUNTY
Element: County
Alpha 25 (Lower Case)
The county for the company address.
AP510 RQ01.1
RQL-POSTAL-CODE
Element: Postal Code
Alpha 10 (Lower Case)
This field contains the postal code.
AP510 RQ01.1
RQL-COUNTRY-CODE
Element: Country Code
Alpha 2
The country code. Required for VAT and intrastat reporting. Must be defined in IN01.1 (Country Maintenance).
AP510 RQ01.1
RQL-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.
AP510 RQ01.1
RQL-ISS-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.
AP510 RQ01.1
RQL-ISS-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.
AP510 RQ01.1
RQL-ISS-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.
AP510 RQ01.1
RQL-IC-TRANS-TYPE
Element: Ic Trans Type
Alpha 2
This code indicates the type of inventory transaction that will be created when the line is picked.
IS = Issues
DT = Direct Transfer
IT = Intransit Transfer
AP510 RQ01.1
RQL-BUYER-CODE
Element: Buyer
Alpha 3
AP510 RQ01.1
RQL-FROM-LOCATION
Element: Location
Alpha 5
This is the inventory location that supplies the items or it is the purchase order ship to location that receives the items. When entered here, it is the default from location on the requisition.
AP510 RQ01.1
RQL-FROM-COMPANY
Element: Company
Numeric 4
This is the company that is the source of the items. When entered here, it is the default company on the requisition.
AP510 RQ01.1
RQL-PO-CODE
Element: Po Code
Alpha 4
This is the purchase order code that will default from a requesting location to a purchase order.
AP510 RQ01.1
RQL-PROCESS-LEVEL
Element: Process Level
Alpha 5
This field contains the process level, which is the reporting hierarchy below company.
AP510 RQ01.1
RQL-FILL-OR-KILL
Element: Fill Or Kill
Alpha 1

F = Fill Backorders
K = Kill Backorders
AP510 RQ01.1
RQL-STOCKLESS-FL
Element: All Flag
Alpha 1
AP510 RQ01.1
RQL-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.
AP510 RQ01.1
RQL-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
AP510 RQ01.1
RQL-BILL-CATEGORY
Element: Bill Category
Alpha 32
AP510 RQ01.1
RQL-APPROVAL-TYPE
Element: Approval Type
Alpha 1
The type of approval record.
" " = Use from IC Company
0 = Header approval-Approval codes
1 = Header approval-Process Flow
2 = Line approval
3 = No approval required
AP510 RQ01.1
RQL-ACTIVE-STATUS
Element: Active Status
Alpha 1
The status of the account. If Inactive, no posting can be done to the account.
A = Active
I = Inactive
AP510 RQ01.1
RQL-RQL-OBJ-ID
Element: Obj Id
Numeric 12
This is the object identifier. It is used to relate commitments or posted transactions back to the originating subsystems. Each subsystem record that is updated as a commitment or posted transaction is assigned an object identifier. The object identifier is maintained in the subsystem files and in the Activity Commitments Detail and Activity Transaction files. The object identifier is a unique key used to drill back from Activity Management to the subsystems.
AP510 MX500
RQ01.1 RQBL.1
RQL-ONE-SRC-ONE-PO
Element: One Src One Po
Numeric 1

0 = No
1 = One Requisition to One PO
AP510 RQ01.1
RQL-PCARD-NBR
Element: Pcard Nbr
Alpha 16
RQL-GLN-NBR
Element: Gln Nbr
Alpha 13
AP510 RQ01.1
RQL-LOCATION-RULE
Element: Rule Name
Alpha 12
AP510 RQ01.1
RQL-PURCH-TAX-CD
Element: Tax Code
Alpha 10
AP510 RQ01.1
RQL-PURCH-TAX-FL
Element: Purch Tax Fl
Alpha 1
AP510 RQ01.1


RQLOC FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQLSET1 COMPANY
REQ-LOCATION
...
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
AP510 API1.1
API2.1 MX500
MA41.1 MA41.2
MA41.4 MA41.7
MA43.1 MA43.2
MA43.3 MA43.4
MA43.6 MA43.7
RQLSET2 RQL-OBJ-ID
KeyChange, Subset
WhereRQL-OBJ-ID !=Zeroes
MX223 MX500
RQ01.4 RQ01.5
RQ50.1 RQBL.1


RQLOC FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Buyer BUYER Not Required
PCG-PROCURE-GROUP->BUY-PROCURE-GROUP
RQL-BUYER-CODE->BUY-BUYER-CODE
From Location ICLOCATION Not Required
Valid When RQL-FROM-LOCATION !=Spaces
RQL-COMPANY->ICL-COMPANY
RQL-FROM-LOCATION->ICL-LOCATION
Glnloc GLNLOC Not Required
Valid When RQL-GLN-NBR !=Spaces
PCG-ITEM-GROUP->GLO-ITEM-GROUP
RQL-GLN-NBR->GLO-GLN-NBR
Glnlocdtl GLNLOCDTL Not Required
Valid When RQL-GLN-NBR !=Spaces
ICC-ITEM-GROUP->GLX-ITEM-GROUP
4->GLX-GLN-TYPE
RQL-COMPANY->GLX-COMPANY
RQL-REQ-LOCATION->GLX-LOCATION
Spaces->GLX-BIN
RQL-GLN-NBR->GLX-GLN-NBR
Ic Company ICCOMPANY Required
RQL-COMPANY->ICC-COMPANY
Ic Location ICLOCATION Not Required
RQL-COMPANY->ICL-COMPANY
RQL-REQ-LOCATION->ICL-LOCATION
Procuregrp PROCUREGRP Required
ICC-ITEM-GROUP->PCG-ITEM-GROUP


File created: Wed Jun 08 20:51:36 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.