| |
Form |
Purpose |
| Budget & Ledger Queries |
FGIBAVL |
Check budget availability by Fund, Org., and Account (rolled up by budget pool) |
| FGIBDSR |
View budget status using higher levels of FOAPAL |
| FGIBDST |
View budget status using any element of FOAPAL |
| FGITBAL |
View current balance for specific fund |
| FGITRND |
Query on revenue/expense trans activity by FOAPAL |
| FGIGLAC |
Query on General Ledger trans activity by FOAPAL |
| FRIGITD |
Project to Date Funds - View budget status using any element of FOAPAL |
| FGITBSR |
View current fund balance |
| FRIGTRD |
Project to Date Funds - Query on detail trans activity by FOAPAL, date, transaction type, etc. |
| Entity Search |
FTMVEND |
View vendor information including addresses |
| FTIIDEN |
Search the Finance database for specific persons and entities |
| SOADDRQ |
Address lookup for employees, students, and vendors |
| Purchasing Queries |
FPIOPOF |
Display all open purchase orders by any combination of fund, organization, account, and program |
| FPIOPOV |
Display all open purchase orders for a particular vendor |
| FPIPURR |
View current purchase/blanket order or change order information |
| FOICOMM |
View expanded list of commodities for a PO, Req, or Invoice |
| FOICACT |
Displays the accounting distribution by commodity for PO, Req, or Invoice |
| Accounts Payable Queries |
FAIINVE |
Query all the info related to a specific invoice |
| FAIVNDH |
Lists all invoices & checks related to a specific vendor |
| FAIINVL |
Query open/paid invoices by PO |
| Document Queries |
FGIDOCR |
Displays posting detail for a specific document |
| FGIENCD |
Display all transactions which have been posted against an encumbrance |
| FOIDOCH |
Identifies & provides status of all documents in the processing path of a specified document |
| Banner Accounts - 6 digits |
Assets & Liabilities |
Gxxxxx |
| Budget Pools |
9xx000 and 914500 |
| Expenditures IntraTransfers Out |
9xxxxx and 8xxxxx
|
| Fund Balance |
G3xxxx |
| Revenues IntraTransfers In |
1xxxxx and 8xxxxx |