USAS User’s Manual –
Chapter 9 – Financial Inquiry (continued)
Financial Inquiry Screens
Note: Financial Inquiry screens in this chapter are arranged in numerical order.
64 Document Record Inquiry
The 64 Document Record Inquiry screen displays the financial balances for any agency, the document number, or the suffix for general ledger accounts supported in the Document Financial (DF) Table. This includes Pre-encumbrances, Encumbrances, Accounts Receivable, and Due To/From accounts. This screen also includes all documents tracked in the DF as determined by the 28A Transaction Code Profile for DF table posting.
A picture of the USAS Document Record Inquiry screen
TEXAS S064 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 03:11 PM
LINK TO: DOCUMENT RECORD INQUIRY PROD
AGENCY: 999 DOC NO/SFX: E1035842
CREATE DATE: 090195 CLOSE DATE: 082295
INQ TYPE: CB (MA, PA, YA, CB, PY, PP)
INQ YEAR: 96 INQ MONTH: 09 DOC BALANCE: .00
BT TITLE AMOUNT BT TITLE AMOUNT
01 ORIGINAL AMOUNT 17.00
03 LIQUIDATIONS 17.00
04 COLLECTIONS/PMTS 17.00
F1-HELP F3-END F4-INTERRUPT F8-FRWD
Allowed Access Paths
Allowed Access Paths are:
- Agency, Document Number; or
- Agency, Document Number, and Document Suffix (Control Key).
Calculated Balance
Calculated Balance is:
- Document Balance.
Note: For more information, see the Calculated Balances section at the end of this chapter.
65 General Ledger Record Inquiry
The 65 General Ledger Record Inquiry screen displays amounts at the lowest level in the classification structure by Agency, Transaction Code, and Comptroller General Ledger Account. The amounts displayed are debits and credits divided into direct and indirect expense categories.
A picture of the USAS General Ledger Record Inquiry screen
TEXAS S065 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 04:03 PM
LINK TO: GENERAL LEDGER RECORD INQUIRY PROD
AGY: 999 COMP/AGY GL: 5501
INDEX: PCA: 24200 COMP/AGY OBJ: 7260 ORG CODE:
PGM CD: 3008 APPN YR: 96 APPN NO: 13008 APPD FUND: 0001
FUND: 0001 GRANT/PH: SUBGRANTEE:
PROJ/PH: AGY CD - 1: 2: 3:
NACUBO SUBFUND: FUNCTION:
TC: 225 CONTRACT: DEBT/INV#:
INQ TYPE: YA (MA, PA, YA, CB)
INQ YEAR: 96 INQ MONTH: 09
BEGINNING BALANCE DEBIT CREDIT ENDING BALANCE
DIR: .00 348.75 .00 348.75
IND: .00 .00 .00 .00
BAL: .00 348.75 .00 348.75
F1-HELP F3-END F4-INTERRUPT F8-FRWD
Allowed Access Paths
Allowed Access Paths are:- Agency and Comptroller General Ledger;
- Agency, Comptroller General Ledger, and Agency General Ledger; or Full Record Key (Control Key-top seven lines).
Note: Which fields in the control key are valid for an access path is dependent on posting options selected by the Agency. For example, the agency may not establish and track grants in USAS.
Calculated Balance
Calculated Balance: None.
66 Grant Record Inquiry
The 66 Grant Record Inquiry screen displays financial balances for an Agency, Grant Number, or Grant Number and Phase. It also includes Object and Fund Level information if the Grant Financial Table is posted with Object and Fund codes.
A picture of the USAS Grant Record Inquiry screen
TEXAS S066 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 04:18 PM
LINK TO: GRANT RECORD INQUIRY PROD
AGENCY: 999 GRANT NO/PH: 777777
FUND: COMP AGY/OBJ: GRANT OBJECT: 4
TITLE: SPECIAL BORDER PROJECTS
GRANT CAT: 66.000 ENVIRONMENTAL PROTECTION AGENCY
GRANTOR ID: 30003992184000
GRANTOR NAME: ENVIRONMENTAL PROTECTION AGENCY
GRANT TYPE: 01
INQ TYPE: CB (MA, PA, YA, CB, PY, PP)
INQ YEAR: 96 INQ MONTH: 09 EXPEND BUDGET BALANCE: 11,300.95-
BT TITLE AMOUNT BT TITLE AMOUNT
15 CASH EXPENDITURES 11,300.95
17 ACCRUED EXPENDITURES .00
F1-HELP F3-END F4-INTERRUPT F8-FRWD
A picture of the USAS Grant Record Inquiry screen
TEXAS S066 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 04:20 PM
LINK TO: GRANT RECORD INQUIRY PROD
AGENCY: 999 GRANT NO/PH: 777777
FUND: COMP AGY/OBJ: 3700 GRANT OBJECT: 4
TITLE: SPECIAL BORDER PROJECTS
GRANT CAT: 66.000 ENVIRONMENTAL PROTECTION AGENCY
GRANTOR ID: 3111311111100
GRANTOR NAME: ENVIRONMENTAL PROTECTION AGENCY
GRANT TYPE: 01
INQ TYPE: CB (MA, PA, YA, CB, PY, PP)
INQ YEAR: 96 INQ MONTH: 09 EXPEND BUDGET BALANCE: .00
BT TITLE AMOUNT BT TITLE AMOUNT
12 CASH REVENUES 31,839.00
14 ACCRUED REVENUES .00
28 AMOUNT BILLED 31,839.00
F1-HELP F3-END F4-INTERRUPT F8-FRWD
Allowed Access Paths
Allowed Access Paths are:
- Agency, Grant Number;
- Agency, Grant Number/Phase;
- Agency, Grant Number/Phase, and/or Fund or Object; or
- Agency, Grant Number/Phase, Fund, and Object (Control Key).
Note: If no Grant Object is entered, then the Grant Object will default to the first Grant Object established for that grant in the D48 Grant Object Profile.
Note: Which access paths are valid is dependent on how the agency chooses to set the Grant Phase Table posting indicators. Refer to the USAS User’s Manual, Chapter 12 – Understanding Financial Tables, for more information.
Calculated Balance Calculated Balance is:
Expenditure Budget Balance.
Note:For more information, see the Calculated Balances section at the end of this chapter.
68 Contract Record Inquiry
The 68 Contract Record Inquiry screen displays the contract budget, outstanding encumbrances, total expenditures, and the contract balance.
A picture of the USAS Contract Record Inquiry screen
TEXAS S068 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 04:24 PM
LINK TO: CONTRACT RECORD INQUIRY PROD
AGENCY: 999 CONTRACT NO:000000055
AMENDMENT NO: CHANGE NO: TYPE: 5 COMP NO:
DESCRIPTION: COMPUTER HARDWARE AND SOFTWARE ASSISTANCE
VENDOR NO/MC: 111122111511 000 NAME: APPLIED INC
INQ TYPE: CB (MA, PA, YA, CB, PY, PP)
INQ YEAR: 96 INQ MONTH:
BUDGET: .00 BALANCE: .00
BT TITLE AMOUNT BT TITLE AMOUNT
F1-HELP F3-END F4-INTERRUPT F8-FRWD
Allowed Access Path
Allowed Access Path is:
- Agency and Contract Number (Control Key).
Calculated Balance
Calculated Balance is:
- Contract Budget.
Note: For more information, see the Calculated Balances section at the end of this chapter.
69 Agency/Fund Record Inquiry
The 69 Agency/Fund Record Inquiry screen displays Appropriation Balances and summarizes across the Appropriation Number at the Agency, Appropriation Year, and Appropriated Fund/Fund level.
A picture of the Agency/Fund Record Summary Inquiry screen
TEXAS S069 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 05:19 PM
LINK TO: AGENCY/FUND RECORD INQUIRY PROD
AGENCY: 999 AP YEAR: 96 FUND: 0001
INQ TYPE: CB (MA, PA, YA, CB, PY, PP)
INQ YEAR: 96 INQ MONTH:
NET CASH ACT: 57,838,624.87- APPN ACCR CSH AVAIL: 1,247,755,533.85
APPN CASH AVAIL: 1,247,786,324.13 APPN ENC CASH AVAIL: 1,247,755,533.85
BT TITLE AMOUNT BT TITLE AMOUNT
01 APPROP ORIGINAL B 3,446,664,798.00 21 CASH TRANSFERS OU 5,714,111.02
02 APPROP REVISIONS 10,581,402.90
03 APPROP TRSFRS OUT 62,417,733.00
04 APPROP TRSFRS IN 101,017,733.00
11 EST COLLECTD REVE 2,190,221,251.90
12 CASH REVENUES 9,302.87
15 CASH EXPENDITURES 54,522,742.95
16 CASH RSRVD - PAYR 38,322,659.30
17 ACCRUED EXPENDITU 30,790.28
20 CASH TRANSFERS IN 40,711,585.53
F1-HELP F3-END F4-INTERRUPT
Allowed Access Path
Allowed Access Path is:
- Agency, Appropriation Year, and Fund.
Calculated Balances
Calculated Balances are:
- Net Cash Activity;
- Appropriation Cash Available;
- Appropriation Accrued Cash Available;
- Appropriation Encumbered Cash Available.
Note: For more information, see the Calculated Balances section at the end of this chapter.
80 Project Record Inquiry
The 80 Project Record screen displays financial balances for an agency, project number, or project number and phase. It includes Object and Fund Level information if the Project Financial Table is posted with Object and Fund codes.
A picture of the USAS Project Record Inquiry screen
TEXAS S080 UNIFORM STATEWIDE ACCOUNTING SYSTEM 11/10/95 09:53 AM
LINK TO: PROJECT RECORD INQUIRY
AGENCY: PROJ NO/PH:
FUND: COMP/AGY OBJ: AGY OBJ GROUP:
TITLE: PROJECT TYPE:
PROJECT MANAGER:
INQ TYPE: CB (MA, PA, YA, CB, PY, PP)
INQ YEAR: INQ MONTH: EXPEND BUDGET BALANCE:
NET CASH ACTIVITY:
BT TITLE AMOUNT BT TITLE AMOUNT
F1-HELP F3-END F4-INTERRUPT F8-FRWD
Allowed Access Paths
Allowed Access Paths are:
- Agency and Project Number;
- Agency, Project Number/Phase;
- Agency, Project Number/Phase, and Fund or Object; or
- Agency, Project Number and Phase, Fund and Object (Control Key).
Note: Which access paths are valid is dependent on how the agency chooses to set the Project Table posting indicators. Refer to the USAS User’s Manual, Chapter 12-Understanding Financial Tables, for more information.
Calculated Balances
Calculated Balances are:
- Expenditure Budget Balance;
- Net Cash Activity.
Note: For more information, see the Calculated Balances section at the end of this chapter.
84 Accounting Event Record Inquiry
The 84 Accounting Event Record Inquiry screen displays transaction level by transaction ID. Up to eight Comptroller General Ledger accounts are shown for the transaction to indicate the full accounting impact. This inquiry displays all transactions posted to USAS.
A picture of the USAS Accounting Event Record Inquiry screen
TEXAS S084 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 05:28 PM
LINK TO: ACCOUNTING EVENT RECORD INQUIRY PROD
BATCH: AGENCY 999 DATE 082295 TYPE 4 NO 444 SEQ NO
GL: DR1 5501 CR1 1009 DR2 CR2 DR3 CR3 DR4 9005 CR4 9001
DOC DATE: 071995 EFF DATE: 082295 DUE DATE: SERV DATE: 080895
CUR DOC/SFX: 2604862 003 REF DOC/SFX: E1035842 001 MOD: F AGENCY: 999
TRANS CODE: 231 INDEX: 02111 PCA: 01014 AY: 95 COMP/AGY OBJ: 7273 0482
AMOUNT: 17.00 RVS: DISCOUNT: .00 FO: PDT: RC
CI: PROP #: 1099: REQ NO: 999-5-35842
INV-NO: 7162 DT: DESC: PRESTO BUSINESS CARDS
VEND/MC: 11122111911 000 NAME: PRESTO BUSINESS CARDS INC
CONT NO: CITY: SAN ANTONIO ST: TX ZIP: 78212 0000
PMT-NO: 116181111 DT: 082295 AP NO: 11112 FUND: 5490 AGY GL: 5501
GRANT NO/PH: SUB GRANTEE: PROJ NO/PH:
MPCD: AGY CD-1: 2: 3: NACUBO SUBFUND:
DEBT/INVEST ISSUE #: PMT TYPE: INT TM: BK:
DISC-DT: TM: PEN-DT: TM: PEN AMT: .00
LAST PROC - DT: 19950822 TIME: 0729 APPROVAL DT: 082295
F1-HELP F3-END F4-INTERRUPT F8-FORWARD F9-S085 F10-S086 F11-S037 F12-S064
Allowed Access Path
Allowed Access Path is:
- Transaction ID (Batch Agency, Batch Date, Batch Type, Batch Number, and Batch Sequence Number).
Note: The following elements do not appear on the 84 Accounting Event Record Inquiry screen: PCC, Document Count, Document Amount, Document Agency, Debt Investment Number, and Recurring Transaction Index Number.
Calculated Balance
Calculated Balance: None.
Note: The following financial inquiry screens are the only financial inquiry screens which provide document and transaction-level detail information. All other financial inquiry screens provide summarized data (for example, by Appropriation, Comptroller Object, Compt G/L, etc.).
- 84 Accounting Event Record
- 85 Vendor Transaction
- 86 Document Transaction
Note: When using the Inactive AE table, several additional elements are omitted from the screen. These omitted elements include Doc Date, Due Date, Service Date, PDT, Invoice No, City, State, Zip Code, Last Processing Date and Time, and Approval Date.
85 Vendor Transaction Inquiry
The 85 Vendor Transaction Inquiry screen displays important elements for up to seven transactions at a time when the following selection criteria is met: Vendor Number/Mail Code, Agency, Document Type, and Starting Effective Date. Only transactions with vendor numbers are displayed on the screen.
A picture of the USAS Vendor Transaction Inquiry screen
TEXAS S085 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 05:31 PM
LINK TO: VENDOR TRANSACTION INQUIRY PROD
VEND NO/MC: 11122111911 000 AGY: 999 DOC TYPE: E STARTING EFF DATE:
VEND NAME: PRESTO INC
S CUR DOC/SFX INVOICE # DUDT TC PDT PMT- # DATE D APDT TRANS AMT R
REF DOC/SFX INDEX PCA AY COBJ AOBJ
E1114911 001 210 0818 15.00
04205 05014 95 7273 0482
E1115111 001 210 0821 18.00
01011 27001 95 7273 0482
E1111911 001 210 0816 113.00
07621 25010 95 7273 0482
E1111901 001 210 0816 62.00
07641 25004 95 7273 0482
E1114411 001 210 0815 36.00
04212 05014 95 7273 0482
E1118011 001 210 0814 15.00
05111 05005 95 7273 0482
E1110211 001 210 0811 10.50
03931 29001 95 7273 0482
F1-HELP F3-END F4-INTERRUPT F8-FORWARD F9-S084 F10-S086 F11-S037 F12-S064
Allowed Access Paths
Allowed Access Paths are:
- Vendor Number, Mail Code, Agency, and Document Type; or
- Vendor Number, Mail Code, Agency, Document Type (the first digit of the current document number), and Starting Effective Date (Control Key).
Calculated Balance
Calculated Balance: None.
Note: Transactions are sorted by the most recent effective date first. The Starting Eff Date is the latest effective date to be displayed. The default is the current date. Invoice No, Due Date, PDT, DMI, and Approval Date are not included on the transactions from the Inactive AE table.
86 Document Transaction Inquiry
The 86 Document Transaction Inquiry screen displays important elements for up to seven transactions at a time when the following selection criteria is met: Agency and Document Number or Agency and Document Number/Suffix.
A picture of the USAS Document Transaction Inquiry screen
TEXAS S086 UNIFORM STATEWIDE ACCOUNTING SYSTEM 09/27/95 05:26 PM
LINK TO: DOCUMENT TRANSACTION INQUIRY PROD
AGENCY: 999 DOCUMENT NO/SUFFIX: E1115111
S --------TRANS ID-------- TC D DT PAYMENT # REF DOC/SFX TRANSACTION AMOUNT R
EFF DT APPN M INDEX PCA AY COBJ AOBJ VENDOR NO/MC FUND
999 08/22/95 4 425 00003 231 116181111 E1115811 001 17.00
F 02111 01014 95 7273 0482 11122111911 000 5490
999 07/06/95 3 480 00036 210 17.00
02111 01014 95 7273 0482 11122111911 000 5490
F1-HELP F3-END F4-INTERRUPT F8-FORWARD F9-S084 F10-S085 F11-S037 F12-S064
Allowed Access Paths
Allowed Access Paths are:
- Agency and Document Number; or
- Agency, Document Number, and Document Suffix. (Control Key).
Note: Since reimbursement documents are not 'pay in full documents,' more than one payment number may be issued on a reimbursement document.
Calculated Balance
Calculated Balance: None.
Note: Transactions are sorted by the most recent effective date first. The Due Date is not included on transactions from the Inactive AE table.