FMX Home
Glenn Hegar  ·  Texas Comptroller of Public Accounts

USAS User’s Manual
Chapter 12 – Understanding Financial Tables (continued)

How USAS Identifies the Primary Table

About this Procedure

T-Codes determine the primary table(s) that a transaction posts to. Before posting a transaction, USAS uses the T-Code from the transaction to determine which primary table(s) to post that transaction to. The 28A Transaction Code Decision Profile, in the following example, shows that transactions with T-Code 012 post to the Appropriation (AP) table and add the transaction amount to the amount of Balance Type 03 (Appropriation Transfers Out).

The financial tables not appearing in the File Posting Indicators section are the Agency Fund table, the General Ledger table, and the Accounting Event table. The Agency Fund table does not appear because when USAS posts transactions to the Appropriation table, it also automatically posts the same transactions to the Agency Fund table. The Contract table does not appear because posting to it is not dependent on the T-Code; it is determined by whether the user enters a contract number on the transaction. The Accounting Event and General Ledger tables (the secondary tables) do not appear because every transaction is automatically posted to these tables.

28A Transaction Code Decision Profile

A picture of the Transaction Code Decision Profile screen

TEXAS S28A		UNIFORM STATEWIDE ACCOUNTING SYSTEM	    09/09/94 02:04 PM 
 LINK TO:		 TRANSACTION CODE DECISION PROFILE                       
 ACTION: R (A=ADD, C=CHANGE, D=DELETE, N=NEXT, R=RECALL)                     
 
TRAN CODE: 012     TITLE: APPROPRIATION TRANSFER OUT (EXPEND BUDGT)

 GENERAL LEDGER	DR-1: 9060  CR-1: 9055 	DR-2:		CR-2:                     
        POSTING	DR-3:	CR-3:		DR-4:		CR-4:                    
 TRANS  DOCD	DUDT N SVDT N CDOC I RDOC    MODI N  AGCY R   IDX    PCA R  COBJ R
 EDIT  AOBJ	RVRS    PDT N   CI N 1099 N  WARR N  INVC N  VNUM N VNAM N  VADD N
 INDS:DMETH N   APN# R FUND R  GLA N  AGL N  GRNT    SUBG    PROJ   MULT     DI# N
 POST SEQ: 4 REG NO: 1 WW IND: 0 D/I: D WAR CANCL TC:	PYTC:	FUTMY: Y    
 GEN TC:     GEN ACCR TC:	FACTS TC: 036 INTERFACE IND:                    
 PAY LIQ TC:	BALANCING TC: 018                                     


              A/S	 BT	 MATCH GLA DOC	    A/S	BT	MATCH GLA DOC                   
         DF:                                                                    
FILE    AP: +	  03                                                             
POSTING AB:                                                                    
INDS:	CC:                                                                    
         GP:                                                                    
         PJ:                                                                    
     AGY GL:	        

  EFF START DATE: 08301990	EFF END DATE:			LAST PROC DATE: 08111993  
 Z06 RECORD SUCCESSFULLY RECALLED                                               
                                                                                
 F1-HELP F3-END F4-INTERRUPT F6-PROCESS F10-28B PROFILE 
 

Chapter 12 Continued

Glenn Hegar
Texas Comptroller of Public Accounts
Questions? Contact statewide.accounting@cpa.texas.gov
Comptroller.Texas.Gov | FMX
FMX Sitemap | Contact FM
Accessibility Policy | Privacy and Security Policy