Required files for security access

This table shows a list of required files for security access for RQ and RQC XML.

Users should have security for programs RQIA, RQIB, RQIC, RQID, RQIF, RQIG, RQIH, RQII, and RQIJ. These users should also have security access to RQ, IC, and PO. In addition, the users will need security to L_HREQ , L_HRLN, L_HRQH, L_DREQ, L_DRLN, and L_DRQH to add comments in RQC.

See the information about setting up security for users in the Resources and Security Administration Guide.

System code Table name Description System Invoked programs
AP APACCRCODE Invoice Accrual Code Accounts Payable
AP APAPIHIST AP History Accounts Payable ACAC
AP APDISTRIB Invoice Distribution Header Accounts Payable ACTA
AP APINVOICE Accounts Payable Invoice Accounts Payable API4
AP APPAYMENT Invoice Payment Accounts Payable IFAC
AP APPROCLEV Accounts Payable Process Level Accounts Payable IFCU
AP APCOMPANY Accounts Payable Company Accounts Payable IFOB
AP APDISTCODE Distribution Code Detail Accounts Payable IFSG
AP EEADVANCE Employee Advance Accounts Payable SLSE
AP EEEXPENSE Employee Expense Accounts Payable SLSU
AP APHLDINV Hold Accounts Payable IFLU
AP APUAVAL AP User Analysis Value Accounts Payable IFUP
AP APVENADDR AP Vendor Address Accounts Payable ACSB
AP APVENGROUP Vendor Group Accounts Payable AMCO
AP APVENMAST AP Vendor/Cost default Vendor drill around Accounts Payable
AR ARCUSTOMER AR Company Customer Accounts Receivable API3
AR ARCOMP AR Company Accounts Receivable ICCP
AR CUSTDESC AR Group Customer Accounts Receivable ICI1
AR NATBALANCE AR National Account Balance Accounts Receivable ICI8
AR NATACCT AR National Account Accounts Receivable IFAU
AR OECUST Customer Order Processing Accounts Receivable IFFC
AR STATICCUST AR Override Static Cust Agings Accounts Receivable IFGT
AC ACACCTCAT Activity Account Categories Activity Management GLCC
AC ACACTIVITY Activity Activity Management IFRS
AC ACACTGRP Activity Group Activity Management IFSC
AC ACCOMMIT Activity Commitments Activity Management
AC ACCOMMITX Activity Commitments Detail Activity Management
AM AMBOOK Asset Book Name Asset Management POBL
AM AMASSET Asset Asset Management POCP
AM AMTEMPLATE Asset Template Asset Management POIF
BL OECOMPANY Order Entry Company

Billing

POIH
BL OEFRTCODE Order Entry Freight Code

Billing

POI6
CX CXITEMHIST Case Cart Item History Case Carts POI4
CX CXPREFITEM Preference Items Case Carts POI7
CX CXPTMPITEM Template Items Case Carts POI9
CX CXBURDEN Case Cart Burden Case Carts POIA
CX CXCOMPANY Case Cart Company Case Carts POIL
CX CXCASEPREF Case Cart Preferences Case Carts POIX
CX CXCPIUAVAL Case Carts POIG
ED EDUSER Punchout Vendors by User Punchout
GL FBDETAIL Budget Detail General Ledger POII
GL FBHEADER Budget Header General Ledger POIJ
GL FBFUNDDTL General Ledger POI1
GL GLAMOUNTS General Ledger Amounts General Ledger POIM
GL GLTRANS General Ledger Transactions General Ledger SLFD
GL GLCOMMIT General Ledger RQCP
GL GLCOMMITX General Ledger SLUA
IF CUCONV Currency Conversion General Ledger Setup SLSR
IF CURELAT Currency Relationships General Ledger Setup RQIA
IF GLADDRESS General Ledger Address General Ledger Setup RQIB
IF GLCODES General Ledger Codes General Ledger Setup RQIC
IF GLCHART General Ledger Chart General Ledger Setup RQID
IF GLCHARTSUM General Ledger Chart Summary General Ledger Setup RQIF
IF GLCHARTDTL General Ledger Chart Detail General Ledger Setup RQIG
IF GLINTCO General Ledger Intercompany General Ledger Setup RQIH
IF GLMASTER General Ledger Account Master General Ledger Setup RQII
IF GLNAMES General Ledger Names General Ledger Setup RQIJ
IF GLSYSTEM General Ledger Company General Ledger Setup RQ12
IF SYSTEMCODE System Code General Ledger Setup PO15
IC COMPONENT Components of a Kit Inventory Control
IC HCCHRGITEM Charge Item Inventory Control
IC HCPATCHRG Patient Charge Inventory Control
IC HCPATVISIT Patient Visit Inventory Control
IC ICBIN Bin Numbers Inventory Control
IC ICCATEGORY GL Account Category Inventory Control
IC ICCOMPANY Inventory Company Information Inventory Control
IC ICHISTORY Transaction History Inventory Control
IC ICITEMCODE Commodity Code Inventory Control
IC ICLOCATION Company Location Inventory Control
IC ICLOT Lots with Expire Date/On Hold Inventory Control
IC ICRECEIPTS Costing Record Inventory Control
IC ICRPTGRP Report Group Inventory Control
IC ICTRANS Inventory Transaction Inventory Control
IC ICTRANSDTL Inventory Transaction Detail Inventory Control
IC ICUSRFLDEF Inventory Control
IC ICVALUOM Valid Units Of Measure Inventory Control
IC ITCOMMENT Item Comments Inventory Control
IC ITEMGROUP Item Group Inventory Control
IC ITEMLOC Item Location Inventory Control
IC ITEMMAST Item Master Inventory Control
IC ITEMNDC Item National Drug Code Pharmacy
IC ITEMSKU Item SKU Inventory Control
IC ITEMSRC Inventory Control
IC ITEMSUB Item Substitute Inventory Control
IC ITEMUPC Item Universal Product Code Inventory Control
IC ITEMUPN1 Item UPN1 Inventory Control
IC ITEMUPN2 Item UPN2 Inventory Control
IC ITSERIAL Serial Numbers Inventory Control
IC KITITEM Kit Item Inventory Control
IC KWDDETAIL Inventory Control
IC KWDMASTER Inventory Control
IC KWDSETUP Inventory Control
IC KWDSYNONYM Inventory Control
IC MAJORCL Major Class Inventory Control
IC MINORCL Minor Class Inventory Control
IC REASON Reason Code Inventory Control
IC SOHDETAIL Inventory Control
MA MACOMPANY Matching Company Matching
MA MAELMGPREL Matching Element Group Matching
MA MAELMVALUE MA Element Value Matching
MA MAINVDTL Matching Invoice Detail Matching
MA MAMATCHTBL Match Table Matching
MA MAMTCHELEM Matching Elements Matching
MA MAMTCHRULE Matching Rules Matching
MA MAPOINV Matching Purchase Order Matching
MA MAPOOLCNT Matching Pool Count Matching
MA MAREASONCD Matching Reason Code Matching
MA MATCHCLASS Match Class Matching
OE COLINE Customer Order Line Order Entry
OE CUSTORDER Customer Order File Order Entry
OE OEROUTE Order Entry Route Order Entry
OE COSGBLK Order Entry Order Entry
OE ORDERTYPE Order Type Order Entry
PO BUYCLASS PO Buyer Purch Class Auth Purchase Order
PO BUYCMPLOC PO Buyer Company/Location Purchase Order
PO BUYER PO Buyer Master Purchase Order
PO BUYVENPF PO Buyer Vendor Pruchase From Purchase Order
PO MMDIST Account Distributions Purchase Order
PO MMUAVAL PO Account Distribution Value Purchase Order
PO POAGMTPART PO Agreement Participant Purchase Order
PO POAGMTPRIC PO Agreement Pricing Purchase Order
PO POAOCDTL Add On Cost Detail Purchase Order
PO POAOCMAST Add On Cost Master Purchase Order
PO POAOCSPRD Add On Cost Spread Purchase Order
PO POAUDIT Audit Records Purchase Order
PO POAUDRULES Audit Rules Purchase Order
PO POAUDTYPE Audit Types Purchase Order
PO POCODE Purchase Order Codes Purchase Order
PO POCOMPANY Company System Master Purchase Order
PO POHDROUT Purchase Order Header Out Purchase Order
PO POHDRPVT Purchase Order Header Pivot Purchase Order
PO POINTAOC Interface Add On Cost Purchase Order
PO POINTERFAC Interface File Purchase Order
PO POITEMVEN PO Vendor Item Information Purchase Order
PO POLINE Line Items Purchase Order
PO POLINEOUT Purchase Order Line Out Purchase Order
PO POLINEPVT Purchase Order Line Pivot Purchase Order
PO POLINESRC PO Line Source Purchase Order
PO POMESSAGE Buyer Messages Purchase Order
PO POPCRUF PO User Field Purchase Order
PO POPLIUF PO User Field Purchase Order
PO PORECADJHD Receiving Adjustments Header Purchase Order
PO PORECADJLN Receiving Adjustments Line Purchase Order
PO PORECEIVE PO Receivers Purchase Order
PO PORECLINE PO Line Item Receivings Purchase Order
PO PORETURNHD PO Return Header Purchase Order
PO PORETURNLN PO Return Line Purchase Order
PO POREVISION PO Revision Purchase Order
PO POTRACK PO Tracking Purchase Order
PO POTRANSDTL PO Transaction Detail Purchase Order
PO POUSRFLDEF Purchase Order User Field Purchase Order
PO POVAGRMTHD PO Vendor Agreement Header Purchase Order
PO POVAGRMTLN PO Vendor Agreement Line Purchase Order
PO POVENDLOC Vendor Location Master Purchase Order
PO POVENDOR PO Vendor Master Purchase Order
PO PROCTEMP Procurement Template Purchase Order
PO PROCTEMPLN Procurement Template Line Purchase Order
PO PROCTMPPAR Procurement Template Participant Purchase Order
PO PROCUREGRP Procurement Group Purchase Order
PO PURCHORDER Purchase Order Master Purchase Order
PO RECAOCDTL Receiving AOC Detail Purchase Order
PO STCOMMCODE PO Standard Comment Codes Purchase Order
RQ RQAPPCODE Requisition Approval Codes

Requisitions

RQ RQAPPROVE Requisition Approvals Requisitions
RQ REQUESTER Requester Requisitions
RQ REQLINE Requisition Line Requisitions
RQ RQLINEDTL Requisition Line Details Requisitions
RQ REQHEADER Requisition Header Requisitions
RQ RQLOC Requesting Locations Requisitions
RQ RQPURCHCLS Requester's Purchasing Classes Requisitions
RQ RQTRANS Requisition Transactions Requisitions
RQ RQACCTU Requester's Accounting Units Requisitions
RQ RQCCFG RQC Main Configuration Requisitions
RQ RQCPNCHCFG RQC Punchout Configuration Requisitions
RQ RQCEXCCFG RQC Punchout Mapping Fields Requisitions
RQ RQCSETID RQC Set ID Flag Requisitions
RQ PORQHUF PO Requisition Header User Field Requisitions
RQ PORLNUF PO Requistion Line User Field Requisitions
TX INSTNBR Intrastat Company Numbers

Tax

TX INSTDETAIL Intrastat Detail Transactions Tax
TX INSTHEADER Intrastat Transaction Header Tax
TX INSTNOTC Intrastat NOTC codes Tax
TX INSTCMDTY Intrastat Tax
TX INSTATPROC Intrastat Statistical Procedur Tax
TX INSTREGN Intrastat Region Tax
TX INSTCTRYCD Intrastat Country Code Tax
TX INSTPORTS Intrastat PO Reports Tax
TX TXTAXCODE Tax Code Tax
TX TXCODEMAST Tax Code Master Tax
TX TXCOMPANY Tax Company Tax
TX TXTAXRATE Tax Rate Tax
TX TXTAXTABLE Tax Table Tax
TE TERMS Payment Terms Terms
WH COCOMP Demand Line Kit Components Warehouse
WH ICCOUT Warehouse
WH ROUTEDOC Route Document Warehouse
WH ROUTEHDR Route Header Warehouse
WH ROUTESTOP Route Stop Warehouse
WH WHDEMNDHDR Demand Header Warehouse
WH WHDEMAND Demand Warehouse
WH WHSHLAUD Shipment Line Audit Warehouse
WH WHSHIPCOMP Shipment Line Kit Component Warehouse
WH WHSHLDTL Shipment Line Detail Warehouse
WH WHSHIPLINE Shipment Line Warehouse
WH WHSHIPMENT Shipment Warehouse
WH WHPROCTYPE Shipment Process Type Warehouse
WF WFSETUP Workflow Configuration Setup Workflow