|
|
RQTEMPLINE FILE
Requisition Template Lines
This file contains the items on a requisition template.
REFERENCED BY
DR100 IC141 IC142 IC83.1 RQ10.1 RQ10.3
RQ11.1 RQ20.1 RQ215 RQ35.1 RQ500
UPDATED BY
RQ115 RQ15.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
RQX-COMPANY Numeric 4 RQ15.1
Company The company number represents an
established company and is entered on
all function codes.
RQX-REQ-LOCATION Alpha 5 RQ15.1
To Location The location requisitioning items.
This location can be an inventory or
noninventory location.
RQX-REQUESTER Alpha 10 (Lower Case) RQ15.1
Requester This is the person who requested this
requisition.
RQX-TEMPLATE-ID Alpha 10 RQ15.1
Template Id This is an identifier for the template
to differentiate it from other templates
within the requesting location or for
the requester.
RQX-LINE-NBR Numeric 6 RQ15.1
Line Number This field contains the line number.
RQX-ITEM Alpha 32 RQ15.1
Item Number This field contains the item
identifier.
RQX-DESCRIPTION Alpha 30 (Lower Case) RQ115 RQ15.1
Description This is the description of the item.
RQX-ITEM-TYPE Alpha 1 RQ15.1
Item Type This field identifies the line item
type.
RQX-UOM Alpha 4 RQ15.1
Unit of Measure This field contains the valid stock
unit of measure for this item.
RQX-QUANTITY Signed 13.4 RQ15.1
Quantity This field contains the requested
quantity.
RQX-ACCT-UNIT Alpha 15 RQ15.1
Accounting 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.
RQX-ACCOUNT Numeric 6 RQ15.1
Account This field along with the accounting
unit and subaccount make up the location
(account) where amounts and other
account information is stored.
RQX-SUB-ACCT Numeric 4 RQ15.1
Subaccount This field contains the subaccount from
your general ledger chart of accounts
that was charged with the amount carried
on this record.
RQX-PURCH-MAJOR Alpha 4 RQ15.1
Purch Major This is the purchasing major class
code. This field is user defined in the
Inventory Control system. Entering this
field will limit the requester to
ordering only items within this major
class.
RQX-PURCH-MINOR Alpha 4 RQ15.1
Purch Minor This is the purchasing minor class
code. This code is user defined in the
Inventory Control system. Entering a
value in this field will limit the
requester to ordering only items within
this minor class within the major class.
RQX-ACTIVITY Alpha 15 RQ15.1
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. Activities and
cost object activities are used
synonymously in the Activity Management
system. Direct costs are posted to
activities, and indirect costs are
allocated to activities based on
activity drivers.
Activities are grouped or organized by
activity levels. There are two kinds of
activities: "posting allowed" and
"summary only." Use posting level
activities to budget and maintain all
posted transactions. Summary activities
or macro activities combine information
and balances from lower level activities
for reporting and inquiries.
When you add or change a requisition
line distribution for a specific
activity, the Requisition system logic
checks the activity budget. If the
activity is assigned to an activity
group for which a budget is defined and
if the distribution will result in
going over the activity budget, an
error message displays: "Add or change
complete; activity budget will be
exceeded." This message only displays
prior to release of the requisition.
If no overage of the activity budget
will result, the system creates a budget
commitment record when you release the
requisition.
RQX-ACCT-CATEGORY Alpha 5 RQ15.1
Account 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.
RQX-REPL-FROM-CO Numeric 4 RQ15.1
Repl From Co This is the source company from which
this line will be replenished.
RQX-REPL-FROM-LOC Alpha 5 RQ15.1
Replenishment From This is the source location from which
Location the requisition location gets
replenished.
RQX-CREATE-PO-CD Alpha 1 RQ15.1
Create Purchase This code indicates whether this
Order Code inventory item is to be purchased using
a PO instead of picked from inventory.
RQTEMPLINE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
RQXSET1 COMPANY This index is used to access a DR100 IC141
REQ-LOCATION requisition template line record for a IC142 IC83.1
REQUESTER specific template line assigned to a RQ10.1 RQ10.3
TEMPLATE-ID specific requester at a company RQ11.1 RQ115
LINE-NBR requesting location. RQ15.1 RQ20.1
RQ215 RQ35.1
RQ500
RQXSET2 COMPANY This index is used to access RQ10.3 RQ15.1
REQ-LOCATION requisition template line data for a
REQUESTER specific template item defined for a
TEMPLATE-ID requester at a specific company
ITEM requesting location.
RQXSET3 COMPANY This index is used to access a RQ10.3
REQ-LOCATION requisition template line record for a
REQUESTER specific line number and defined for a
TEMPLATE-ID specific requester at a company
DESCRIPTION requesting location.
LINE-NBR
|