|
|
RQLOC FILE
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 BL120
BL122 BL130 BL140 BL20.1 BL20.3 BL21.2
BL21.5 BL29.1 BL29.2 BL520 BL820 BL92.1
CXCP.1 IC12.1 IC12.2 IC130 IC320 IC330
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 PO04.3 PO100 PO101 PO115
PO122 PO131 PO134 PO15.1 PO15.2 PO150
PO16.1 PO190 PO20.1 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO223 PO23.1
PO234 PO24.1 PO25.1 PO25.3 PO25.5 PO25.6
PO25.7 PO254 PO258 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 PO54.1 PO54.2 PO54.3 PO54.4
PO58.1 PO58.2 POCP.1 POI3.1 POI7.1 POID.1
POIE.1 POII.1 POIJ.1 MM280 MM80.1 MM80.2
RQ04.1 RQ10.1 RQ10.2 RQ10.3 RQ11.1 RQ111
RQ12.1 RQ13.1 RQ13.2 RQ140 RQ201 RQ230
RQ235 RQ240 RQ35.1 RQ39.1 RQ39.2 RQ39.3
RQ40.1 RQ42.1 RQ44.1 RQ44.2 RQ500 RQD0.1
RQD1.1 RQIA.1 RQIB.1 RQIC.1 RQID.1 RQIF.1
RQIG.1 RQIH.1 RQII.1 RQIJ.1 WH110 WH130
WH132 WH190 WH20.2 WH20.7 WH222 WH226
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 MX223 RQ50.1
UPDATED BY
MX500 RQ01.1 RQ810 RQBL.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQL-COMPANY Numeric 4 RQ01.1 RQ810
Element: Company 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.
RQL-REQ-LOCATION Alpha 5 RQ01.1 RQ810
Element: Req Location The location requisitioning items.
This location can be an inventory or
noninventory location.
RQL-NAME Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Name The requesting location name or
description.
RQL-ADDR1 Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Addr1 This field contains the first line of
address information.
RQL-ADDR2 Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Addr1 This field contains the first line of
address information.
RQL-ADDR3 Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Addr1 This field contains the first line of
address information.
RQL-ADDR4 Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Addr1 This field contains the first line of
address information.
RQL-CITY-ADDR5 Alpha 18 (Lower Case) RQ01.1 RQ810
Element: City This field contains the city of the
address.
RQL-STATE-PROV Alpha 2 RQ01.1 RQ810
Element: State Prov The state or province.
RQL-COUNTY Alpha 25 (Lower Case) RQ01.1 RQ810
Element: County The county for the company address.
RQL-POSTAL-CODE Alpha 10 (Lower Case) RQ01.1 RQ810
Element: Postal Code This field contains the postal code.
RQL-COUNTRY-CODE Alpha 2 RQ01.1 RQ810
Element: Country Code The country code. Required for VAT and
intrastat reporting. Must be defined in
IN01.1 (Country Maintenance).
RQL-COUNTRY Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Country This field contains the country of the
address, or it can be used for
additional information such as an
attention name.
RQL-ISS-ACCT-UNIT Alpha 15 RQ01.1 RQ810
Element: Acct Unit 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.
RQL-ISS-ACCOUNT Numeric 6 RQ01.1 RQ810
Element: Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RQL-ISS-SUB-ACCT Numeric 4 RQ01.1 RQ810
Element: Sub Acct This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
RQL-IC-TRANS-TYPE Alpha 2 RQ01.1 RQ810
Element: Ic Trans Type 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
RQL-BUYER-CODE Alpha 3 RQ01.1 RQ810
Element: Buyer
RQL-FROM-LOCATION Alpha 5 RQ01.1 RQ810
Element: Location 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.
RQL-FROM-COMPANY Numeric 4 RQ01.1 RQ810
Element: Company This is the company that is the source
of the items. When entered here, it is
the default company on the requisition.
RQL-PO-CODE Alpha 4 RQ01.1 RQ810
Element: Po Code This is the purchase order code that
will default from a requesting location
to a purchase order.
RQL-PROCESS-LEVEL Alpha 5 RQ01.1 RQ810
Element: Process Level This field contains the process level,
which is the reporting hierarchy below
company.
RQL-FILL-OR-KILL Alpha 1 RQ01.1 RQ810
Element: Fill Or Kill F = Fill Backorders
K = Kill Backorders
RQL-STOCKLESS-FL Alpha 1 RQ01.1 RQ810
Element: All Flag
RQL-ACTIVITY Alpha 15 RQ01.1 RQ810
Element: Activity Activities are the processes or
procedures that produce work. Cost
objects (products, services, customers,
and so on) are the reasons for
performing the activity.
RQL-ACCT-CATEGORY Alpha 5 RQ01.1 RQ810
Element: Acct Category 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
RQL-BILL-CATEGORY Alpha 32 RQ01.1 RQ810
Element: Bill Category
RQL-APPROVAL-TYPE Alpha 1 RQ01.1 RQ810
Element: Approval Type 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
RQL-ACTIVE-STATUS Alpha 1 RQ01.1 RQ810
Element: Active Status The status of the account. If Inactive,
no posting can be done to the account.
A = Active
I = Inactive
RQL-RQL-OBJ-ID Numeric 12 MX500 RQ01.1
Element: Obj Id This is the object identifier. It is RQ810 RQBL.1
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.
RQL-ONE-SRC-ONE-PO Numeric 1 RQ01.1 RQ810
Element: One Src One Po0 = No
1 = One Requisition to One PO
RQL-PCARD-NBR Alpha 16
Element: Pcard Nbr
RQLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQLSET1 COMPANY AP125 AP126
REQ-LOCATION 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
BL140 BL20.1
BL20.3 BL21.2
BL21.5 BL29.1
BL29.2 BL520
BL820 BL92.1
...
RQLSET2 RQL-OBJ-ID KeyChange, Subset MX223 MX500
Where RQL-OBJ-ID != Zeroes RQ01.4 RQ01.5
RQ111 RQ230
RQ235 RQ240
RQ50.1 RQBL.1
RQLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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
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
|
