Skip to content

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.

Return to Chapter 9 Table of Contents