|
|
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
BL92.1 CX05.1 CX05.2 CX100 CX15.1 CX20.1
CX20.2 CX20.4 CX20.5 CX205 CX207 CX220
CX225 CX230 CX235 CX240 CX30.1 CX300
CX50.1 CX504 CX506 CX805 CXCP.1 DR100
IC141 IC142 IC145 IC182 IC21.1 IC21.2
IC243 IC283 IC45.1 IC500 IC527 IC83.1
IN20.1 OE10.1 OE10.2 OE10.3 OE10.4 OE10.5
OE10.6 OE10.7 OE10.8 OE11.1 OE11.4 OE11.8
OE11.9 OE110 OE113 OE114 OE129 OE14.4
OE15.1 OE15.2 OE15.3 OE15.4 OE15.5 OE15.7
OE30.1 OE30.2 OE30.3 OE30.4 OE30.5 OE30.6
OE30.7 OE30.9 OE510 OE810 OE830 OE920
OE950 PO100 PO117 PO17.1 PO20.1 PO21.1
PO21.6 PO217 PO22.1 PO22.2 PO22.3 PO221
PO25.2 PO28.4 PO30.1 PO31.1 PO821 RQ04.1
RQ10.1 RQ10.3 RQ11.1 RQ111 RQ12.1 RQ120
RQ15.1 RQ20.1 RQ20.2 RQ20.3 RQ20.4 RQ201
RQ215 RQ230 RQ235 RQ240 RQ35.1 RQ39.1
RQ39.2 RQ39.3 RQ40.1 RQ42.1 RQ44.1 RQ44.2
RQ500 RQ961 SEA2.1 WH130 WH132 WH190
WH20.2 WH20.7 WH222 WH30.1 WH30.2 WH30.3
WH31.1 WH31.2 WH31.3 WH32.1 WH32.2 WH32.3
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 RQ963
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQL-COMPANY Numeric 4 IC81.1 IC840
Buyer The company number represents an RQ01.1 RQ810
established company and is entered on RQ963
all function codes.
RQL-REQ-LOCATION Alpha 5 IC81.1 IC840
To Location The location requisitioning items. RQ01.1 RQ810
This location can be an inventory or RQ963
noninventory location.
RQL-NAME Alpha 30 (Lower Case) IC81.1 IC840
Name The requesting location name or RQ01.1 RQ810
description. RQ963
RQL-ADDR1 Alpha 30 (Lower Case) RQ01.1 RQ810
Address 1 This field contains the first line of RQ963
address information.
RQL-ADDR2 Alpha 30 (Lower Case) RQ01.1 RQ810
Address 2 This field contains the second line of RQ963
address information.
RQL-ADDR3 Alpha 30 (Lower Case) RQ01.1 RQ810
Address 3 This field contains the third line of RQ963
address information.
RQL-ADDR4 Alpha 30 (Lower Case) RQ01.1 RQ810
Address 4 This field contains the fourth line of RQ963
address information.
RQL-CITY-ADDR5 Alpha 18 (Lower Case) RQ01.1 RQ810
City or Address 5 The city or address line five. RQ963
RQL-STATE-PROV Alpha 2 RQ01.1 RQ810
State or Province The state or province. RQ963
RQL-POSTAL-CODE Alpha 10 (Lower Case) RQ01.1 RQ810
Postal Code This field contains the postal code. RQ963
RQL-COUNTRY Alpha 30 (Lower Case) RQ01.1 RQ810
Country or Other This field contains the country of the RQ963
address, or it can be used for
additional information such as an
attention name.
RQL-ISS-ACCT-UNIT Alpha 15 IC81.1 IC840
Issues Offset This is the default accounting unit for RQ01.1 RQ810
Accounting Unit issues. RQ963
RQL-ISS-ACCOUNT Numeric 6 IC81.1 IC840
Issues Offset This is the default account number for RQ01.1 RQ810
Account Number issues. RQ963
RQL-ISS-SUB-ACCT Numeric 4 IC81.1 IC840
Issues Offset This is the default sub account number RQ01.1 RQ810
Subaccount for issues. RQ963
RQL-IC-TRANS-TYPE Alpha 2 IC81.1 IC840
Inventory This code indicates the type of RQ01.1 RQ810
Transaction Type inventory transaction created when the RQ963
line is picked in WH30.1 (Picking
Feedback by Shipment).
IS = Issues
DT = Direct Transfer
IT = Intransit Transfer
RQL-BUYER-CODE Alpha 3 RQ01.1 RQ810
Buyer Code The user defined buyer identifier. RQ963
RQL-FROM-LOCATION Alpha 5 IC81.1 IC840
From-Location This is the inventory location that RQ01.1 RQ810
supplies the items or it is the purchase RQ963
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 RQ810 RQ963
From-Company This is the company that is the source
of the items. When entered here, it is
the default company on the requisition.
RQLOC FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQLSET1 COMPANY This index is used to access a BL92.1 CX05.1
REQ-LOCATION requesting location record. CX05.2 CX100
CX15.1 CX20.1
CX20.2 CX20.4
CX20.5 CX205
CX207 CX220
CX225 CX230
CX235 CX240
CX30.1 CX300
CX50.1 CX504
CX506 CX805
CXCP.1 DR100
IC141 IC142
IC145 IC182
IC21.1 IC21.2
...
RQLOC FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Buyer BUYER Required
When RQL-BUYER-CODE != Spaces
RQL-COMPANY -> BUY-COMPANY
RQL-BUYER-CODE -> BUY-BUYER-CODE
From Location ICLOCATION Required
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
RQLOC FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Poloccon POLOCCON
RQL-COMPANY -> PLO-COMPANY
RQL-REQ-LOCATION -> PLO-REQ-LOCATION
PLO-ORDER-NAME
Templates RQTEMP
RQL-COMPANY -> RQM-COMPANY
RQL-REQ-LOCATION -> RQM-REQ-LOCATION
Spaces -> RQM-REQUESTER
RQM-TEMPLATE-ID
|