Lesson 9: Reports

DAFR8200 – DAILY TRANSACTION REGISTER (transaction and RTI agency)

DAFR8200 is a requestable report that lists all transactions posted to the requesting agency by day.

The report prints in five registers. The system sorts each register by:

• Document agency
• Document type (based on the first character of the current document number)
• Current document number

The T-code determines the register in which a transaction appears. The register number associated with each T-code can be seen on the T-code Profile (28A screen).

Examples

For ITVs, the two important registers are:

• Register 2 – PRE-ENC/ENC/EXPEND TRANSACTION REGISTER for the buying agency's transfer.
• Register 3 – REVENUE/RECEIPTS TRANSACTION REGISTER for the selling agency's receipt of transfer.

These two registers are shown in the examples below.

The first example highlights the payment for $138.26 to the Department of Information Resources (DIR). The second example shows receipt of the funds by DIR for TEX-AN charges.

Transaction Agency

DAFR8200 309 FFOW 01     JOTT RJE R309   (  ) (  ) (  ) (  ) (  ) (  )  (  )  (  )   USAS        
CYCLE: 03/29/12 23:41 3088 RUN DATE: 03/30/12 TIME: 00:06 19 CFY: 12  CFM: 07 LCY: 11  LCM: 05 FICHE: 300           
                           TEST AGENCY (123)                           
                     DAILY PRE-ENC/ENC/EXPEND TRANSACTION REGISTER (2)                     
PERCENT OF YEAR ELAPSED:  58%           REPORT PERIOD= 03/29/12                            
******************************************************************************************************************PAGE  3
                                                                  
*************************************************************************************************************************
CUR DOC /SFX/AGY/DATE   EFF DATE DUE DATE SERV DATE REF DOC/SFX M TC INDEX PCA AY C/AGY OBJ    DISC   FO  AMOUNT  R PD 
 PROP #  1099  INV #     DATE  ----------DESCRIPTION--------- VEND/MAIL CODE -------------------NAME------------------
 CONTRACT #  WARR # APPN# FUND AFUND GL ACCT/AGENCY GRNT #/PH  SUB GRANTEE PROJ #/PH  MP CODE  ---AGCY 1 2 3---  RTI   
 AGY YYYYMMDD T BATCH SEQ                                                     
*************************************************************************************************************************
                                                                  
GT0890287 456 456 03/26/12 03/25/12 04/24/12 03/19/12 T4011503 309  960    03023 12 7961        0.00      138.26   
        4010059C    02/27/12 T4011503         130090 34564564563 000 TEXAS DEPT OF INFORMATION RESOURCES     
            13023 0001 0001    45600010                                       
 005 20120329 W 679 00001    

RTI Agency

DAFR8200 456 DJW 01     PROD RJE R456   (  ) (  ) (  ) (  ) (  ) (  )  (  )  (  )   USAS        
CYCLE: 03/29/12 23:41 3088 RUN DATE: 03/30/12 TIME: 00:06 19 CFY: 12  CFM: 07 LCY: 11  LCM: 05 FICHE: 456           
                       DEPARTMENT OF TELEPHONE SERVICES (456)                       
                     DAILY REVENUE/RECEIPTS TRANSACTION REGISTER (3)                     
PERCENT OF YEAR ELAPSED:  58%           REPORT PERIOD= 03/29/12                            
*****************************************************************************************************************PAGE 406
                                                                  
************************************************************************************************************************
CUR DOC /SFX/AGY/DATE   EFF DATE DUE DATE SERV DATE REF DOC/SFX  TC INDEX PCA AY C/AGY OBJ FO     AMOUNT  R    
 ----------DESCRIPTION--------- VEND/MAIL CODE ------------------NAME------------------ INT TRMS PMT TYPE  BANK  DISC DAT
 TM PEN DATE TM  PENALTY AMT  APPN# FUND AFUND GL ACCT/AGY GRNT #/PH SUB GRANTEE  PROJ #/PH  MPCODE  --AGY CD 1 2 3--  RTI
 AGY YYYYMMDD T BATCH SEQ                                                     
************************************************************************************************************************
                                                                  
 
                                                                  
GT089028 456 456 03/19/12 03/29/12 04/24/12 03/19/12 T4011503 405 971    00009 12 3961           138.26     
 TEX-AN CHARGES/FEB12  130100                                                  
               .00 13014 0001 0001   40500010                                   
 005 20120329 W 679 00001                                                     

Next: DAFR8910