|
|
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 AP23.1 AP25.1 AP25.2
AP26.1 AP27.1 AP30.4 API1.1 CXCP.1 DR100
IC12.1 IC12.2 IC125 IC130 IC140 IC141
IC142 IC182 IC21.1 IC21.2 IC225 IC226
IC243 IC244 IC270 IC28.1 IC281 IC282
IC283 IC285 IC320 IC33.1 IC330 IC36.1
IC45.1 IC500 IC520 IC521 IC522 IC523
IC524 IC525 IC526 IC527 IC530 IC531
IC598 IC82.1 IC83.1 IC84.1 IC84.2 PC120
SEA1.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 PO04.3 PO100
PO101 PO115 PO122 PO131 PO134 PO15.1
PO15.2 PO16.1 PO20.1 PO204 PO21.1 PO21.2
PO21.3 PO21.4 PO21.5 PO22.1 PO223 PO23.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 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 RQ140
RQ201 RQ230 RQ235 RQ240 RQ300 RQ35.1
RQ39.1 RQ39.2 RQ39.3 RQ40.1 RQ41.1 RQ42.1
RQ44.1 RQ44.2 RQ500 RQD0.1 RQD1.1 RQIA.1
RQIB.1 RQIC.1 RQID.1 RQIE.1 RQIF.1 RQIG.1
RQIH.1 RQII.1 RQIJ.1 SEA2.1 SEA3.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 WO132
WO140
UPDATED BY
IC81.1 IC840 RQ01.1 RQ810
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQL-COMPANY Numeric 4 IC81.1 IC840
Element: Buyer The company number represents an RQ01.1 RQ810
established company and is entered on
all function codes.
RQL-REQ-LOCATION Alpha 5 IC81.1 IC840
Element: Location Code RQ01.1 RQ810
RQL-NAME Alpha 30 (Lower Case) IC81.1 IC840
Element: Name The requesting location name or RQ01.1 RQ810
description.
RQL-ADDR1 Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Address 1 This field contains the first line of
address information.
RQL-ADDR2 Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Address 1
RQL-ADDR3 Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Address 1
RQL-ADDR4 Alpha 30 (Lower Case) RQ01.1 RQ810
Element: Address 1
RQL-CITY-ADDR5 Alpha 18 (Lower Case) RQ01.1 RQ810
Element: City
RQL-STATE-PROV Alpha 2 RQ01.1 RQ810
Element: State or ProviThe 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 or OthThis 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 IC81.1 IC840
Element: Accounting Unit RQ01.1 RQ810
RQL-ISS-ACCOUNT Numeric 6 IC81.1 IC840
Element: Account RQ01.1 RQ810
RQL-ISS-SUB-ACCT Numeric 4 IC81.1 IC840
Element: Subaccount RQ01.1 RQ810
RQL-IC-TRANS-TYPE Alpha 2 IC81.1 IC840
Inventory This code indicates the type of RQ01.1 RQ810
Transaction Type 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 IC81.1 IC840
Element: Location Code This is the inventory location that RQ01.1 RQ810
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 IC81.1 IC840
Element: Company This is the company that is the source RQ01.1 RQ810
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 IC81.1 RQ01.1
Element: Fill Or Kill F = Fill Backorders RQ810
K = Kill Backorders
RQL-FIELD-ENTRY Alpha 1
Element: Field Entry 1 = Item Number
2 = NDC
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: Account CategoAccount 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.
RQLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQLSET1 COMPANY This index is used to access a AP125 AP126
REQ-LOCATION requesting location record. 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 DR100
IC12.1 IC12.2
IC125 IC130
IC140 IC141
IC142 IC182
IC21.1 IC21.2
IC225 IC226
...
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 != "SPACE"
RQL-COMPANY -> ICL-COMPANY
RQL-FROM-LOCATION -> ICL-LOCATION
Ic Company ICCOMPANY Required
RQL-COMPANY -> ICC-COMPANY
Ic Location ICLOCATION Required
When RQL-IC-TRANS-TYPE = "T"
Or RQL-IC-TRANS-TYPE = "X"
RQL-COMPANY -> ICL-COMPANY
RQL-REQ-LOCATION -> ICL-LOCATION
Procuregrp PROCUREGRP Required
ICC-ITEM-GROUP -> PCG-ITEM-GROUP
RQLOC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Templates RQTEMP
RQL-COMPANY -> RQM-COMPANY
RQL-REQ-LOCATION -> RQM-REQ-LOCATION
Spaces -> RQM-REQUESTER
RQM-TEMPLATE-ID
|
